protected void Page_Load(object sender, EventArgs e)
{
//执行投入公海操作，每天第一个用户登录的时候执行
if (LastOutPutCustToHighSeas.Date != DateTime.Now.Date)
{
OutPutCustToHighSeas();//执行投入公海操作
LastOutPutCustToHighSeas = DateTime.Now;
}
m_SName = userBase.RealName;
m_userId = "" + userBase.UserID;
HR_STAFF js = userBase.GetStaff();
m_SID = js.STAFF_ID.ToString();
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdToDayCon.STAFF_ID = js.STAFF_ID;
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());
V_CRM_STAFF_CUSTOMER_NOTCONTACT valToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valToDayCon.STAFF_ID = 0;
toDayConCount = BLLTable <V_CRM_STAFF_CUSTOMER_NOTCONTACT> .Factory(conn).Select(valToDayCon, vcrmscdToDayCon).Count;
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdExpiredCon.STAFF_ID = js.STAFF_ID;
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.Where("{0} < '{1}' And {2} <> {3}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
V_CRM_STAFF_CUSTOMER_NOTCONTACT valExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valExpiredCon.STAFF_ID = 0;
expiredCount = BLLTable <V_CRM_STAFF_CUSTOMER_NOTCONTACT> .Factory(conn).Select(valExpiredCon, vcrmscdExpiredCon).Count;
if (userBase.UserType.ToString() != EnumInfo.SYS_UserType.Admin.ToString("d"))
{
sysMange.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//执行投入公海操作，每天第一个用户登录的时候执行
if (LastOutPutCustToHighSeas.Date != DateTime.Now.Date)
{
OutPutCustToHighSeas();//执行投入公海操作
LastOutPutCustToHighSeas = DateTime.Now;
}
m_SName = userBase.RealName;
m_userId = "" + userBase.UserID;
HR_STAFF js = userBase.GetStaff();
m_SID = js.STAFF_ID.ToString();
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdToDayCon.STAFF_ID = js.STAFF_ID;
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());
V_CRM_STAFF_CUSTOMER_NOTCONTACT valToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valToDayCon.STAFF_ID = 0;
toDayConCount = BLLTable<V_CRM_STAFF_CUSTOMER_NOTCONTACT>.Factory(conn).Select(valToDayCon, vcrmscdToDayCon).Count;
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdExpiredCon.STAFF_ID = js.STAFF_ID;
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.Where("{0} < '{1}' And {2} <> {3}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
V_CRM_STAFF_CUSTOMER_NOTCONTACT valExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valExpiredCon.STAFF_ID = 0;
expiredCount = BLLTable<V_CRM_STAFF_CUSTOMER_NOTCONTACT>.Factory(conn).Select(valExpiredCon, vcrmscdExpiredCon).Count;
if (userBase.UserType.ToString() != EnumInfo.SYS_UserType.Admin.ToString("d"))
{
sysMange.Visible = false;
}
}
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();
}
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 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);
}