protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
aspPager.PageSize = 20;
HR_STAFF js = userBase.GetStaff();
SID = js.STAFF_ID.ToString();
if (userBase.UserType.ToString() == EnumInfo.SYS_UserType.Admin.ToString("d"))//wcp?
{
V_CMR_STAF csVal = new V_CMR_STAF();
csVal.STAFF_ID = 0;
csVal._SNAME = "";
csVal._DEPT_ID = "";
csVal.USER_ID = 0;
V_CMR_STAF csCon = new V_CMR_STAF();
csCon.DEPT_ID = js.DEPT_ID;
List <V_CMR_STAF> csList = BLLTable <V_CMR_STAF> .Factory(conn).Select(csVal, csCon);
if (csList.Count > 0)
{
ddl_Staf.Items.Add(new ListItem("自己", js.STAFF_ID.ToString()));
foreach (V_CMR_STAF cs in csList)
{
if (cs.USER_ID == userBase.UserID)
{
continue;
}
else
{
ddl_Staf.Items.Add(new ListItem(cs.SNAME, cs.STAFF_ID.ToString()));
}
}
ddl_Staf.SelectedIndex = 0;
}
}
else
{
ddl_Staf.Visible = true;
ddl_Staf.Items.Add(new ListItem("自己", SID));
ddl_Staf.SelectedIndex = 0;
}
BindData(new V_CUSTHIGHSEAS(), 1);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
lit_ContractedCusCount.Text = "0";
lit_ExpiredUnConCusCount.Text = "0";
lit_todayConCusCount.Text = "0";
lit_WillInHighSeasCusCount.Text = "0";
List <string> SIDList = new List <string>();
//aspPager.PageSize = 20;
HR_STAFF js = userBase.GetStaff();
SIDList.Add(js.STAFF_ID.ToString());
if (HttpContext.Current != null && HttpContext.Current.Request != null && HttpContext.Current.Request.UrlReferrer != null && !string.IsNullOrEmpty(HttpContext.Current.Request.UrlReferrer.OriginalString))
{
PreviousUrlUrl = HttpContext.Current.Request.UrlReferrer.OriginalString;
}
SID = userBase.UserID + "";
ddl_CusStatus.Items.AddRange(FormHelper.GetListItem(AgileFrame.Orm.PersistenceLayer.Model.CRM_STAFF_CUSTOMER.Attribute.CustStatus));
if (ddl_CusStatus.Items.Count > 0)
{
ddl_CusStatus.Items[0].Text = "全部状态";
ddl_CusStatus.Items[0].Value = "0";
}
if (userBase.UserType.ToString() == EnumInfo.SYS_UserType.Admin.ToString("d"))//wcp?
{
ddl_CusStatus.Visible = true;
V_CMR_STAF csVal = new V_CMR_STAF();
csVal.STAFF_ID = 0;
csVal._SNAME = "";
csVal.DEPT_NAME = "";
csVal.USER_ID = 0;
V_CMR_STAF csCon = new V_CMR_STAF();
csCon.DEPT_ID = js.DEPT_ID;
List <V_CMR_STAF> csList = BLLTable <V_CMR_STAF> .Factory(conn).Select(csVal, csCon);
if (csList.Count > 0)
{
ddl_CusStatus.SelectedIndex = 0;
ddl_CusToStf.Items.Add(new ListItem("全部" + csList[0].DEPT_NAME + "员工", "0"));
ddl_CusToStf.Items.Add(new ListItem("自己", js.STAFF_ID.ToString()));
foreach (V_CMR_STAF cs in csList)
{
if (cs.USER_ID == userBase.UserID)
{
continue;
}
else
{
ddl_CusToStf.Items.Add(new ListItem(cs.SNAME, cs.STAFF_ID.ToString()));
SIDList.Add(cs.STAFF_ID.ToString());
}
}
ddl_CusToStf.SelectedIndex = 0;
}
}
else
{
ddl_CusStatus.Visible = true;
ddl_CusToStf.Items.Add(new ListItem(userBase.RealName, userBase.UserID.ToString()));
ddl_CusToStf.SelectedIndex = 0;
}
string[] SIDArr = SIDList.ToArray();
V_CRM_STAFF_CUSTOMER vcrmscCon = new V_CRM_STAFF_CUSTOMER();
vcrmscCon.In(V_CRM_STAFF_CUSTOMER.Attribute.SID, SIDArr);
vcrmscCon.OrderBy(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, Order.Asc);
BindData(vcrmscCon, 1, aspAllCusPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdToDayCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdToDayCon.Where("{0} <> {1} And {2} Between '{3}' And '{4}'", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.ToString(), DateTime.Now.Date.AddDays(1).AddSeconds(-1).ToString());
vcrmscdToDayCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
//vcrmscdToDayCon.Where("{0} <> {1}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
BindData(vcrmscdToDayCon, 1, aspToDayMustConPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdExpiredCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdExpiredCon.Where("{0} between '{1}' And '{2}' And {3} <> {4}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-57).ToString(), DateTime.Now.Date.AddSeconds(-1).ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
vcrmscdExpiredCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
BindData(vcrmscdExpiredCon, 1, aspExpiredPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdWillInHighSeasCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdWillInHighSeasCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdWillInHighSeasCon.Where("{0} between '{1}' And '{2}' And {3} <> {4}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-60).ToString(), DateTime.Now.Date.AddDays(-57).AddSeconds(-1).ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
vcrmscdWillInHighSeasCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
BindData(vcrmscdWillInHighSeasCon, 1, aspWillInHighSeasPager);
V_CRM_STAFF_CUSTOMER vcrmscContractedCon = new V_CRM_STAFF_CUSTOMER();
vcrmscContractedCon.In(V_CRM_STAFF_CUSTOMER.Attribute.SID, SIDArr);
vcrmscContractedCon._CustStatus = 5;
vcrmscContractedCon.OrderBy(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, Order.Asc);
BindData(vcrmscContractedCon, 1, aspContractedPager);
this.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
return;
aspPager.PageSize = 20;
HR_STAFF js = userBase.GetStaff();
SID = js.STAFF_ID.ToString();
if (userBase.UserType.ToString() == EnumInfo.SYS_UserType.Admin.ToString("d"))//wcp?
{
V_CMR_STAF csVal = new V_CMR_STAF();
csVal.STAFF_ID = 0;
csVal._SNAME = "";
csVal._DEPT_ID = "";
csVal.USER_ID = 0;
V_CMR_STAF csCon = new V_CMR_STAF();
csCon.DEPT_ID = js.DEPT_ID;
List<V_CMR_STAF> csList = BLLTable<V_CMR_STAF>.Factory(conn).Select(csVal, csCon);
if (csList.Count > 0)
{
ddl_Staf.Items.Add(new ListItem("自己", js.STAFF_ID.ToString()));
foreach (V_CMR_STAF cs in csList)
{
if (cs.USER_ID == userBase.UserID)
{
continue;
}
else
{
ddl_Staf.Items.Add(new ListItem(cs.SNAME, cs.STAFF_ID.ToString()));
}
}
ddl_Staf.SelectedIndex = 0;
}
}
else
{
ddl_Staf.Visible = true;
ddl_Staf.Items.Add(new ListItem("自己", SID));
ddl_Staf.SelectedIndex = 0;
}
BindData(new V_CUSTHIGHSEAS(), 1);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
return;
lit_ContractedCusCount.Text = "0";
lit_ExpiredUnConCusCount.Text = "0";
lit_todayConCusCount.Text = "0";
lit_WillInHighSeasCusCount.Text = "0";
List<string> SIDList = new List<string>();
//aspPager.PageSize = 20;
HR_STAFF js = userBase.GetStaff();
SIDList.Add(js.STAFF_ID.ToString());
if (HttpContext.Current != null && HttpContext.Current.Request != null && HttpContext.Current.Request.UrlReferrer != null && !string.IsNullOrEmpty(HttpContext.Current.Request.UrlReferrer.OriginalString))
{
PreviousUrlUrl = HttpContext.Current.Request.UrlReferrer.OriginalString;
}
SID = userBase.UserID + "";
ddl_CusStatus.Items.AddRange(FormHelper.GetListItem(AgileFrame.Orm.PersistenceLayer.Model.CRM_STAFF_CUSTOMER.Attribute.CustStatus));
if (ddl_CusStatus.Items.Count > 0)
{
ddl_CusStatus.Items[0].Text = "全部状态";
ddl_CusStatus.Items[0].Value = "0";
}
if (userBase.UserType.ToString() == EnumInfo.SYS_UserType.Admin.ToString("d"))//wcp?
{
ddl_CusStatus.Visible = true;
V_CMR_STAF csVal = new V_CMR_STAF();
csVal.STAFF_ID = 0;
csVal._SNAME = "";
csVal.DEPT_NAME = "";
csVal.USER_ID = 0;
V_CMR_STAF csCon = new V_CMR_STAF();
csCon.DEPT_ID = js.DEPT_ID;
List<V_CMR_STAF> csList = BLLTable<V_CMR_STAF>.Factory(conn).Select(csVal,csCon);
if (csList.Count > 0)
{
ddl_CusStatus.SelectedIndex = 0;
ddl_CusToStf.Items.Add(new ListItem("全部" + csList[0].DEPT_NAME + "员工", "0"));
ddl_CusToStf.Items.Add(new ListItem("自己", js.STAFF_ID.ToString()));
foreach (V_CMR_STAF cs in csList)
{
if (cs.USER_ID == userBase.UserID)
{
continue;
}
else
{
ddl_CusToStf.Items.Add(new ListItem(cs.SNAME, cs.STAFF_ID.ToString()));
SIDList.Add(cs.STAFF_ID.ToString());
}
}
ddl_CusToStf.SelectedIndex = 0;
}
}
else
{
ddl_CusStatus.Visible = true;
ddl_CusToStf.Items.Add(new ListItem(userBase.RealName, userBase.UserID.ToString()));
ddl_CusToStf.SelectedIndex = 0;
}
string[] SIDArr = SIDList.ToArray();
V_CRM_STAFF_CUSTOMER vcrmscCon = new V_CRM_STAFF_CUSTOMER();
vcrmscCon.In(V_CRM_STAFF_CUSTOMER.Attribute.SID, SIDArr);
vcrmscCon.OrderBy(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, Order.Asc);
BindData(vcrmscCon, 1, aspAllCusPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdToDayCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdToDayCon.Where("{0} <> {1} And {2} Between '{3}' And '{4}'", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.ToString(), DateTime.Now.Date.AddDays(1).AddSeconds(-1).ToString());
vcrmscdToDayCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
//vcrmscdToDayCon.Where("{0} <> {1}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
BindData(vcrmscdToDayCon, 1, aspToDayMustConPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdExpiredCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdExpiredCon.Where("{0} between '{1}' And '{2}' And {3} <> {4}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-57).ToString(), DateTime.Now.Date.AddSeconds(-1).ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
vcrmscdExpiredCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
BindData(vcrmscdExpiredCon, 1, aspExpiredPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdWillInHighSeasCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdWillInHighSeasCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdWillInHighSeasCon.Where("{0} between '{1}' And '{2}' And {3} <> {4}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-60).ToString(), DateTime.Now.Date.AddDays(-57).AddSeconds(-1).ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
vcrmscdWillInHighSeasCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
BindData(vcrmscdWillInHighSeasCon, 1, aspWillInHighSeasPager);
V_CRM_STAFF_CUSTOMER vcrmscContractedCon = new V_CRM_STAFF_CUSTOMER();
vcrmscContractedCon.In(V_CRM_STAFF_CUSTOMER.Attribute.SID, SIDArr);
vcrmscContractedCon._CustStatus = 5;
vcrmscContractedCon.OrderBy(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, Order.Asc);
BindData(vcrmscContractedCon, 1, aspContractedPager);
this.DataBind();
}
