protected void aspPager_PageChanged(object sender, EventArgs e) { AspNetPager asppage = sender as AspNetPager; if (asppage == null) { return; } switch (asppage.ID) { case "aspAllCusPager": V_CRM_STAFF_CUSTOMER conAllCus = new V_CRM_STAFF_CUSTOMER(); if (string.IsNullOrEmpty(hidAllCus.Value)) { conAllCus = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER>(hidAllCus.Value); } BindData(conAllCus, asppage.CurrentPageIndex, asppage); break; case "aspToDayMustConPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conToDayMustCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidToDayMustCon.Value)) { conToDayMustCon = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidToDayMustCon.Value); } BindData(conToDayMustCon, asppage.CurrentPageIndex, asppage); break; case "aspExpiredPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conExpired = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidExpired.Value)) { conExpired = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidExpired.Value); } BindData(conExpired, asppage.CurrentPageIndex, asppage); break; case "aspWillInHighSeasPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conWillInHighSeas = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidWillInHighSeas.Value)) { conExpired = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidWillInHighSeas.Value); } BindData(conWillInHighSeas, asppage.CurrentPageIndex, asppage); break; case "aspContractedPager": V_CRM_STAFF_CUSTOMER conContracted = new V_CRM_STAFF_CUSTOMER(); if (string.IsNullOrEmpty(hidContracted.Value)) { conContracted = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER>(hidContracted.Value); } BindData(conContracted, asppage.CurrentPageIndex, asppage); break; default: break; } }
protected void aspPager_PageChanged(object sender, EventArgs e) { AspNetPager asppage = sender as AspNetPager; if (asppage == null) return; switch (asppage.ID) { case "aspAllCusPager": V_CRM_STAFF_CUSTOMER conAllCus = new V_CRM_STAFF_CUSTOMER(); if (string.IsNullOrEmpty(hidAllCus.Value)) { conAllCus = JsonServiceBase.FromJson<V_CRM_STAFF_CUSTOMER>(hidAllCus.Value); } BindData(conAllCus, asppage.CurrentPageIndex, asppage); break; case "aspToDayMustConPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conToDayMustCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidToDayMustCon.Value)) { conToDayMustCon = JsonServiceBase.FromJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidToDayMustCon.Value); } BindData(conToDayMustCon, asppage.CurrentPageIndex, asppage); break; case "aspExpiredPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conExpired = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidExpired.Value)) { conExpired = JsonServiceBase.FromJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidExpired.Value); } BindData(conExpired, asppage.CurrentPageIndex, asppage); break; case "aspWillInHighSeasPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conWillInHighSeas = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidWillInHighSeas.Value)) { conExpired = JsonServiceBase.FromJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidWillInHighSeas.Value); } BindData(conWillInHighSeas, asppage.CurrentPageIndex, asppage); break; case "aspContractedPager": V_CRM_STAFF_CUSTOMER conContracted = new V_CRM_STAFF_CUSTOMER(); if (string.IsNullOrEmpty(hidContracted.Value)) { conContracted = JsonServiceBase.FromJson<V_CRM_STAFF_CUSTOMER>(hidContracted.Value); } BindData(conContracted, asppage.CurrentPageIndex, asppage); break; default: break; } }
protected void btnSearch_Click(object sender, EventArgs e) { V_CRM_STAFF_CUSTOMER conAllCus = new V_CRM_STAFF_CUSTOMER(); conAllCus.OrderBy(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, Order.Asc); V_CRM_STAFF_CUSTOMER_NOTCONTACT conToDayMustCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); conToDayMustCon.Where("{0} <> {1}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5"); conToDayMustCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc); V_CRM_STAFF_CUSTOMER_NOTCONTACT conWillInHighSeas = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); conWillInHighSeas.Where("{0} <> {1}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5"); conWillInHighSeas.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc); V_CRM_STAFF_CUSTOMER_NOTCONTACT conExpired = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); conExpired.Where("{0} <> {1}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5"); conExpired.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc); V_CRM_STAFF_CUSTOMER conContracted = new V_CRM_STAFF_CUSTOMER(); conContracted.OrderBy(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, Order.Asc); if (ddl_CusStatus.SelectedItem.Value == "0") { conAllCus.In(V_CRM_STAFF_CUSTOMER.Attribute.CustStatus, new int[] { 1, 2, 3, 4 }); conToDayMustCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus, new int[] { 1, 2, 3, 4 }); conExpired.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus, new int[] { 1, 2, 3, 4 }); conWillInHighSeas.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus, new int[] { 1, 2, 3, 4 }); conContracted.In(V_CRM_STAFF_CUSTOMER.Attribute.CustStatus, new int[] { 5 }); } else { conAllCus._CustStatus = Convert.ToInt32(ddl_CusStatus.SelectedItem.Value); conToDayMustCon._CustStatus = Convert.ToInt32(ddl_CusStatus.SelectedItem.Value); conExpired._CustStatus = Convert.ToInt32(ddl_CusStatus.SelectedItem.Value); conWillInHighSeas._CustStatus = Convert.ToInt32(ddl_CusStatus.SelectedItem.Value); conContracted._CustStatus = 5;//已签约客户 } if (ddl_CusToStf.SelectedItem.Value == "0") { string[] SIDArr = new string[ddl_CusToStf.Items.Count - 1]; int index = 0; foreach (ListItem li in ddl_CusToStf.Items) { if (li.Value != "0") { SIDArr[index] = li.Value; index++; } } conAllCus.In(V_CRM_STAFF_CUSTOMER.Attribute.SID, SIDArr); conToDayMustCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr); conExpired.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr); conWillInHighSeas.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr); conContracted.In(V_CRM_STAFF_CUSTOMER.Attribute.SID, SIDArr); } else { conAllCus._SID = ddl_CusToStf.SelectedItem.Value; conToDayMustCon.STAFF_ID = decimal.Parse(ddl_CusToStf.SelectedItem.Value); conExpired.STAFF_ID = decimal.Parse(ddl_CusToStf.SelectedItem.Value); conWillInHighSeas.STAFF_ID = decimal.Parse(ddl_CusToStf.SelectedItem.Value); conContracted._SID = ddl_CusToStf.SelectedItem.Value; } if (!string.IsNullOrEmpty(txt_ComName.Value)) { conAllCus.Like(V_CRM_STAFF_CUSTOMER.Attribute.CompanyName, txt_ComName.Value); conToDayMustCon.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CompanyName, txt_ComName.Value); conExpired.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CompanyName, txt_ComName.Value); conWillInHighSeas.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CompanyName, txt_ComName.Value); conContracted.Like(V_CRM_STAFF_CUSTOMER.Attribute.CompanyName, txt_ComName.Value); } if (!string.IsNullOrEmpty(txt_ShopName.Value)) { conAllCus.Like(V_CRM_STAFF_CUSTOMER.Attribute.ShopName, txt_ShopName.Value); conToDayMustCon.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.ShopName, txt_ShopName.Value); conExpired.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.ShopName, txt_ShopName.Value); conWillInHighSeas.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.ShopName, txt_ShopName.Value); conContracted.Like(V_CRM_STAFF_CUSTOMER.Attribute.ShopName, txt_ShopName.Value); } if (!string.IsNullOrEmpty(txt_QQ.Value)) { conAllCus.Like(V_CRM_STAFF_CUSTOMER.Attribute.CustQQ, txt_QQ.Value); conToDayMustCon.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustQQ, txt_QQ.Value); conExpired.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustQQ, txt_QQ.Value); conWillInHighSeas.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustQQ, txt_QQ.Value); conContracted.Like(V_CRM_STAFF_CUSTOMER.Attribute.CustQQ, txt_QQ.Value); } if (!string.IsNullOrEmpty(txt_WW.Value)) { conAllCus.Like(V_CRM_STAFF_CUSTOMER.Attribute.WangWangId, txt_WW.Value); conToDayMustCon.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.WangWangId, txt_WW.Value); conExpired.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.WangWangId, txt_WW.Value); conWillInHighSeas.Like(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.WangWangId, txt_WW.Value); conContracted.Like(V_CRM_STAFF_CUSTOMER.Attribute.WangWangId, txt_WW.Value); } if (string.IsNullOrEmpty(time_Staf.Value) && string.IsNullOrEmpty(time_End.Value)) { conToDayMustCon.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date, DateTime.Now.Date.Date.AddDays(1).AddSeconds(-1))); conExpired.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date.Date.AddDays(-57), DateTime.Now.Date.AddSeconds(-1))); //conWillInHighSeas.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date.AddSeconds(-60), DateTime.Now.Date.AddSeconds(-58))); } else if (!string.IsNullOrEmpty(time_Staf.Value) && string.IsNullOrEmpty(time_End.Value)) { //conAllCus.Where(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, new Between(DateTime.Parse(time_Staf.Value), DateTime.MaxValue)); conToDayMustCon.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date > DateTime.Parse(time_Staf.Value) ? DateTime.Now.Date : DateTime.Parse(time_Staf.Value), DateTime.Now.Date.AddDays(1).AddSeconds(-1))); conExpired.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Parse(time_Staf.Value), DateTime.Now.Date.AddSeconds(-1))); //conWillInHighSeas.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date.AddSeconds(-60), DateTime.Now.Date.AddSeconds(-58))); //conContracted.Where(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, new Between(DateTime.Parse(time_Staf.Value), DateTime.MaxValue)); } else if (string.IsNullOrEmpty(time_Staf.Value) && !string.IsNullOrEmpty(time_End.Value)) { //conAllCus.Where(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, new Between(DateTime.MinValue, DateTime.Parse(time_End.Value))); conToDayMustCon.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date, DateTime.Now.Date.Date.AddDays(1).AddSeconds(-1) > DateTime.Parse(time_End.Value) ? DateTime.Parse(time_End.Value) : DateTime.Now.Date.AddDays(1).AddSeconds(-1))); conExpired.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date.AddDays(-57), DateTime.Now.Date.AddSeconds(-1) > DateTime.Parse(time_End.Value) ? DateTime.Parse(time_End.Value) : DateTime.Now.Date.AddSeconds(-1))); //conWillInHighSeas.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(new DateTime(1900, 1, 1), DateTime.Now.Date.AddSeconds(-1) > DateTime.Parse(time_End.Value) ? DateTime.Parse(time_End.Value) : DateTime.Now.Date.AddSeconds(-1))); //conContracted.Where(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, new Between(DateTime.MinValue, DateTime.Parse(time_End.Value))); } else if (!string.IsNullOrEmpty(time_Staf.Value) && !string.IsNullOrEmpty(time_End.Value)) { //conAllCus.Where(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, new Between(DateTime.Parse(time_Staf.Value), DateTime.Parse(time_End.Value))); conToDayMustCon.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date > DateTime.Parse(time_Staf.Value) ? DateTime.Now.Date : DateTime.Parse(time_Staf.Value), DateTime.Now.Date.AddDays(1).AddSeconds(-1) > DateTime.Parse(time_End.Value) ? DateTime.Parse(time_End.Value) : DateTime.Now.Date.AddDays(1).AddSeconds(-1))); conExpired.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Parse(time_Staf.Value), DateTime.Now.Date.AddSeconds(-1) > DateTime.Parse(time_End.Value) ? DateTime.Parse(time_End.Value) : DateTime.Now.Date.AddSeconds(-1))); //conWillInHighSeas.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Parse(time_Staf.Value), DateTime.Now.Date.AddSeconds(-1) > DateTime.Parse(time_End.Value) ? DateTime.Parse(time_End.Value) : DateTime.Now.Date.AddSeconds(-1))); //conContracted.Where(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, new Between(DateTime.Parse(time_Staf.Value), DateTime.Parse(time_End.Value))); } conWillInHighSeas.Where(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, new Between(DateTime.Now.Date.AddDays(-60), DateTime.Now.Date.AddDays(-57).AddSeconds(-1))); BindData(conAllCus, 1, aspAllCusPager); BindData(conToDayMustCon, 1, aspToDayMustConPager); BindData(conExpired, 1, aspExpiredPager); BindData(conWillInHighSeas, 1, aspWillInHighSeasPager); BindData(conContracted, 1, aspContractedPager); }
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(); }
private void BindData(ITableImplement con, int pageCur, AspNetPager asppager) { int recount = -1; asppager.PageSize = 20; switch (asppager.ID) { case "aspAllCusPager": case "aspContractedPager": V_CRM_STAFF_CUSTOMER vcrmscCon = con as V_CRM_STAFF_CUSTOMER; if (vcrmscCon == null) { return; } if (asppager.ID == "aspAllCusPager") { hidAllCus.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER>(vcrmscCon); } else { hidContracted.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER>(vcrmscCon); } vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER valsc = new V_CRM_STAFF_CUSTOMER(); valsc._SID = ""; valsc.Cus_ID = 0; valsc.CompanyName = ""; valsc.ShopName = ""; valsc.Cus_Name = ""; valsc.CustQQ = ""; valsc.WangWangId = ""; valsc.LastContactTime = DateTime.MinValue; valsc.SNAME = ""; valsc.CustStatus = 0; if (vcrmscCon.af_PageByAttributeItem == null) //如果不存在用户定义的分页排序属性,则用主键属性排序 { vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc); } List <V_CRM_STAFF_CUSTOMER> vcrmscList = BLLTable <V_CRM_STAFF_CUSTOMER> .Factory(conn).SelectByPage(valsc, vcrmscCon, asppager.PageSize, pageCur, ref recount); if (vcrmscList.Count > 0) { FormHelper.Bind(Page, vcrmscList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspAllCusPager") { repAllCusList.DataSource = vcrmscList; repAllCusList.DataBind(); } else { lit_ContractedCusCount.Text = recount.ToString(); repContractedList.DataSource = vcrmscList; repContractedList.DataBind(); } asppager.RecordCount = recount; break; case "aspToDayMustConPager": case "aspExpiredPager": case "aspWillInHighSeasPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscnCon = con as V_CRM_STAFF_CUSTOMER_NOTCONTACT; if (vcrmscnCon == null) { return; } if (asppager.ID == "aspToDayMustConPager") { hidToDayMustCon.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); } else if (asppager.ID == "aspExpiredPager") { hidExpired.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); } else { hidWillInHighSeas.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); } vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER_NOTCONTACT valscn = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); valscn.STAFF_ID = 0; valscn.Cus_ID = 0; valscn.CompanyName = ""; valscn.ShopName = ""; valscn.Cus_Name = ""; valscn.CustQQ = ""; valscn.WangWangId = ""; valscn.LastContactTime = DateTime.MinValue; valscn.NextContactTime = DateTime.MinValue; valscn.SNAME = ""; valscn.CustStatus = 0; if (vcrmscnCon.af_PageByAttributeItem == null) //如果不存在用户定义的分页排序属性,则用主键属性排序 { vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc); } List <V_CRM_STAFF_CUSTOMER_NOTCONTACT> vcrmscnList = BLLTable <V_CRM_STAFF_CUSTOMER_NOTCONTACT> .Factory(conn).SelectByPage(valscn, vcrmscnCon, asppager.PageSize, pageCur, ref recount); if (vcrmscnList.Count > 0) { FormHelper.Bind(Page, vcrmscnList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspToDayMustConPager") { lit_todayConCusCount.Text = recount.ToString(); repToDayMustConList.DataSource = vcrmscnList; repToDayMustConList.DataBind(); } else if (asppager.ID == "aspExpiredPager") { lit_ExpiredUnConCusCount.Text = recount.ToString(); repExpiredList.DataSource = vcrmscnList; repExpiredList.DataBind(); } else { lit_WillInHighSeasCusCount.Text = recount.ToString(); repWillInHighSeasList.DataSource = vcrmscnList; repWillInHighSeasList.DataBind(); } asppager.RecordCount = recount; break; default: break; } }
private void BindData(ITableImplement con, int pageCur, AspNetPager asppager) { int recount = -1; asppager.PageSize = 20; switch (asppager.ID) { case "aspAllCusPager": case "aspContractedPager": V_CRM_STAFF_CUSTOMER vcrmscCon = con as V_CRM_STAFF_CUSTOMER; if (vcrmscCon == null) return; if (asppager.ID == "aspAllCusPager") hidAllCus.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon); else hidContracted.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon); vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER valsc = new V_CRM_STAFF_CUSTOMER(); valsc._SID = ""; valsc.Cus_ID = 0; valsc.CompanyName = ""; valsc.ShopName = ""; valsc.Cus_Name = ""; valsc.CustQQ = ""; valsc.WangWangId = ""; valsc.LastContactTime = DateTime.MinValue; valsc.SNAME = ""; valsc.CustStatus = 0; List<V_CRM_STAFF_CUSTOMER> vcrmscList = BLLTable<V_CRM_STAFF_CUSTOMER>.Factory(conn).SelectByPage(valsc, vcrmscCon, asppager.PageSize, pageCur, ref recount); if (vcrmscList.Count > 0) { FormHelper.Bind(Page, vcrmscList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspAllCusPager") { repAllCusList.DataSource = vcrmscList; repAllCusList.DataBind(); } else { lit_ContractedCusCount.Text = recount.ToString(); repContractedList.DataSource = vcrmscList; repContractedList.DataBind(); } asppager.RecordCount = recount; break; case "aspToDayMustConPager": case "aspExpiredPager": case "aspWillInHighSeasPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscnCon = con as V_CRM_STAFF_CUSTOMER_NOTCONTACT; if (vcrmscnCon == null) return; if (asppager.ID == "aspToDayMustConPager") hidToDayMustCon.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); else if (asppager.ID == "aspExpiredPager") hidExpired.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); else hidWillInHighSeas.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER_NOTCONTACT valscn = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); valscn.STAFF_ID = 0; valscn.Cus_ID = 0; valscn.CompanyName = ""; valscn.ShopName = ""; valscn.Cus_Name = ""; valscn.CustQQ = ""; valscn.WangWangId = ""; valscn.LastContactTime = DateTime.MinValue; valscn.NextContactTime = DateTime.MinValue; valscn.SNAME = ""; valscn.CustStatus = 0; List<V_CRM_STAFF_CUSTOMER_NOTCONTACT> vcrmscnList = BLLTable<V_CRM_STAFF_CUSTOMER_NOTCONTACT>.Factory(conn).SelectByPage(valscn, vcrmscnCon, asppager.PageSize, pageCur, ref recount); if (vcrmscnList.Count > 0) { FormHelper.Bind(Page, vcrmscnList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspToDayMustConPager") { lit_todayConCusCount.Text = recount.ToString(); repToDayMustConList.DataSource = vcrmscnList; repToDayMustConList.DataBind(); } else if (asppager.ID == "aspExpiredPager") { lit_ExpiredUnConCusCount.Text = recount.ToString(); repExpiredList.DataSource = vcrmscnList; repExpiredList.DataBind(); } else { lit_WillInHighSeasCusCount.Text = recount.ToString(); repWillInHighSeasList.DataSource = vcrmscnList; repWillInHighSeasList.DataBind(); } asppager.RecordCount = recount; break; default: break; } }
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(); }