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(); }