using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
using System.Web.UI;
|
using System.Web.UI.WebControls;
|
using CY.BLL;
|
using CY.Model;
|
using CY.Infrastructure.Query;
|
using CY.Infrastructure.Common;
|
using CY.BLL.Sys;
|
using CY.BLL.OA;
|
using CY.BLL.EC;
|
using System.Drawing;
|
|
namespace CY.WebForm.Pages.business
|
{
|
public partial class xiaoshouyejiReportList : BasePage
|
{
|
|
EC_OrderBLL bll_EC_OrderBLL = null;
|
|
OA_StaffBLL bll_OA_StaffBLL = null;
|
|
|
//初始化
|
public xiaoshouyejiReportList()
|
{
|
|
bll_EC_OrderBLL = new EC_OrderBLL();
|
bll_OA_StaffBLL = new OA_StaffBLL();
|
|
}
|
|
protected void Page_Load(object sender, EventArgs e)
|
{
|
UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
|
if (!IsPostBack)
|
{
|
InitialSelectData();
|
BindList();
|
|
}
|
}
|
|
//加载查询条件
|
protected void InitialSelectData()
|
{
|
if (this.txtDeliveryTime.Value == "")
|
{
|
this.txtDeliveryTime.Value = "本周业绩";
|
}
|
|
//业务经理
|
this.selBusinessManagerId.DataSource = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId, true, false);
|
this.selBusinessManagerId.DataTextField = "Name";
|
this.selBusinessManagerId.DataValueField = "Keyid";
|
this.selBusinessManagerId.DataBind();
|
this.selBusinessManagerId.Items.Insert(0, new ListItem("全部", ""));
|
|
|
|
|
}
|
|
//绑定列表
|
private void BindList()
|
{
|
if (this.txtDeliveryTime.Value == "")
|
{
|
this.txtDeliveryTime.Value = this.Button0.Text;
|
}
|
|
if (this.txtDeliveryTime.Value == this.Button0.Text)
|
{
|
this.Button0.BorderColor = Color.Black;
|
this.Button1.BorderColor = Color.LightBlue;
|
this.Button2.BorderColor = Color.LightBlue;
|
this.Button3.BorderColor = Color.LightBlue;
|
this.Button4.BorderColor = Color.LightBlue;
|
this.Button5.BorderColor = Color.LightBlue;
|
|
|
}
|
else if (this.txtDeliveryTime.Value == this.Button1.Text)
|
{
|
this.Button1.BorderColor = Color.Black;
|
this.Button2.BorderColor = Color.LightBlue;
|
this.Button3.BorderColor = Color.LightBlue;
|
this.Button4.BorderColor = Color.LightBlue;
|
this.Button5.BorderColor = Color.LightBlue;
|
this.Button0.BorderColor = Color.LightBlue;
|
}
|
else if (this.txtDeliveryTime.Value == this.Button2.Text)
|
{
|
this.Button2.BorderColor = Color.Black;
|
this.Button3.BorderColor = Color.LightBlue;
|
this.Button4.BorderColor = Color.LightBlue;
|
this.Button5.BorderColor = Color.LightBlue;
|
this.Button0.BorderColor = Color.LightBlue;
|
this.Button1.BorderColor = Color.LightBlue;
|
}
|
else if (this.txtDeliveryTime.Value == this.Button3.Text)
|
{
|
this.Button3.BorderColor = Color.Black;
|
this.Button4.BorderColor = Color.LightBlue;
|
this.Button5.BorderColor = Color.LightBlue;
|
this.Button0.BorderColor = Color.LightBlue;
|
this.Button1.BorderColor = Color.LightBlue;
|
this.Button2.BorderColor = Color.LightBlue;
|
}
|
else if (this.txtDeliveryTime.Value == this.Button4.Text)
|
{
|
this.Button4.BorderColor = Color.Black;
|
this.Button5.BorderColor = Color.LightBlue;
|
this.Button0.BorderColor = Color.LightBlue;
|
this.Button1.BorderColor = Color.LightBlue;
|
this.Button2.BorderColor = Color.LightBlue;
|
this.Button3.BorderColor = Color.LightBlue;
|
}
|
else if (this.txtDeliveryTime.Value == this.Button5.Text)
|
{
|
this.Button5.BorderColor = Color.Black;
|
this.Button0.BorderColor = Color.LightBlue;
|
this.Button1.BorderColor = Color.LightBlue;
|
this.Button2.BorderColor = Color.LightBlue;
|
this.Button3.BorderColor = Color.LightBlue;
|
this.Button4.BorderColor = Color.LightBlue;
|
}
|
string chaxuntimestart = "";
|
string chaxuntimeend = "";
|
|
if (this.txtDeliveryTime.Value== "本周业绩")
|
{
|
DateTime nowTime = DateTime.Now;
|
#region 获取本周第一天
|
//星期一为第一天
|
int weeknow = Convert.ToInt32(nowTime.DayOfWeek);
|
|
//因为是以星期一为第一天,所以要判断weeknow等于0时,要向前推6天。
|
weeknow = (weeknow == 0 ? (7 - 1) : (weeknow - 1));
|
int daydiff = (-1) * weeknow;
|
|
//本周第一天
|
DateTime FirstDay = nowTime.AddDays(daydiff);
|
#endregion
|
|
#region 获取本周最后一天
|
//星期天为最后一天
|
int lastWeekDay = Convert.ToInt32(nowTime.DayOfWeek);
|
lastWeekDay = lastWeekDay == 0 ? (7 - lastWeekDay) : lastWeekDay;
|
int lastWeekDiff = (7 - lastWeekDay);
|
|
//本周最后一天
|
DateTime LastDay = nowTime.AddDays(lastWeekDiff);
|
|
#endregion
|
chaxuntimestart = FirstDay.ToString("yyyy-MM-dd");
|
chaxuntimeend = LastDay.ToString("yyyy-MM-dd");
|
|
}
|
else if(this.txtDeliveryTime.Value == "上周业绩")
|
{
|
DateTime nowTime = DateTime.Now.AddDays(-7);
|
#region 获取本周第一天
|
//星期一为第一天
|
int weeknow = Convert.ToInt32(nowTime.DayOfWeek);
|
|
//因为是以星期一为第一天,所以要判断weeknow等于0时,要向前推6天。
|
weeknow = (weeknow == 0 ? (7 - 1) : (weeknow - 1));
|
int daydiff = (-1) * weeknow;
|
|
//本周第一天
|
DateTime FirstDay = nowTime.AddDays(daydiff);
|
#endregion
|
|
#region 获取本周最后一天
|
//星期天为最后一天
|
int lastWeekDay = Convert.ToInt32(nowTime.DayOfWeek);
|
lastWeekDay = lastWeekDay == 0 ? (7 - lastWeekDay) : lastWeekDay;
|
int lastWeekDiff = (7 - lastWeekDay);
|
|
//本周最后一天
|
DateTime LastDay = nowTime.AddDays(lastWeekDiff);
|
|
#endregion
|
chaxuntimestart = FirstDay.ToString("yyyy-MM-dd");
|
chaxuntimeend = LastDay.ToString("yyyy-MM-dd");
|
}
|
else if (this.txtDeliveryTime.Value == "本月业绩")
|
{
|
chaxuntimestart = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date.ToString("yyyy-MM-dd");
|
|
chaxuntimeend = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date.AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
|
|
}
|
else if (this.txtDeliveryTime.Value == "上月业绩")
|
{
|
chaxuntimestart = DateTime.Now.AddMonths(-1).AddDays(1 - DateTime.Now.Day).Date.ToString("yyyy-MM-dd");
|
|
chaxuntimeend = DateTime.Now.AddMonths(-1).AddDays(1 - DateTime.Now.Day).Date.AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
|
}
|
else if (this.txtDeliveryTime.Value == "本年业绩")
|
{
|
DateTime dt = DateTime.Now;
|
//本年第一天
|
chaxuntimestart = new DateTime(dt.Year,1,1).ToString("yyyy-MM-dd");
|
chaxuntimeend = new DateTime(dt.Year, 12, 31).ToString("yyyy-MM-dd");
|
}
|
else if (this.txtDeliveryTime.Value == "上年业绩")
|
{
|
DateTime dt = DateTime.Now.AddYears(-1);
|
//本年第一天
|
chaxuntimestart = new DateTime(dt.Year, 1, 1).ToString("yyyy-MM-dd");
|
chaxuntimeend = new DateTime(dt.Year, 12, 31).ToString("yyyy-MM-dd");
|
}
|
|
|
|
|
|
Pagination pa = new Pagination();
|
pa.PageSize = UCPager1.AspNetPager.PageSize;
|
pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
|
this.RepClientList.DataSource = bll_EC_OrderBLL.GetyewurenportList(pa,
|
CurrentUser.MemberId,
|
|
this.selBusinessManagerId.Value,
|
chaxuntimestart,
|
chaxuntimeend
|
|
);
|
this.RepClientList.DataBind();
|
UCPager1.AspNetPager.RecordCount = pa.RecordCount;
|
}
|
|
//分页事件
|
protected void AspNetPager1_PageChanged(object src, EventArgs e)
|
{
|
BindList();
|
}
|
|
//查询事件
|
protected void btn_Search_Click(object sender, EventArgs e)
|
{
|
BindList();
|
}
|
|
protected void btn_Search_Click0(object sender, EventArgs e)
|
{
|
|
this.txtDeliveryTime.Value = this.Button0.Text;
|
|
BindList();
|
}
|
protected void btn_Search_Click1(object sender, EventArgs e)
|
{
|
|
this.txtDeliveryTime.Value = this.Button1.Text;
|
|
BindList();
|
}
|
|
protected void btn_Search_Click2(object sender, EventArgs e)
|
{
|
|
this.txtDeliveryTime.Value = this.Button2.Text;
|
|
BindList();
|
}
|
protected void btn_Search_Click3(object sender, EventArgs e)
|
{
|
|
this.txtDeliveryTime.Value = this.Button3.Text;
|
|
BindList();
|
}
|
protected void btn_Search_Click4(object sender, EventArgs e)
|
{
|
|
this.txtDeliveryTime.Value = this.Button4.Text;
|
|
BindList();
|
}
|
protected void btn_Search_Click5(object sender, EventArgs e)
|
{
|
|
this.txtDeliveryTime.Value = this.Button5.Text;
|
|
BindList();
|
}
|
|
}
|
}
|