protected void btnFind_Click(object sender, EventArgs e) { //wcp zlg? if (string.IsNullOrEmpty(txt_cus_id.Value)) { return; } bindCon = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(); bindCon._Cus_ID = Convert.ToInt32(txt_cus_id.Value); DateTime sdt = DateTime.MinValue; DateTime edt = DateTime.MaxValue; //string wherebetween = "1=1"; if (DateTime.TryParse(startTime.Value, out sdt) && DateTime.TryParse(endTime.Value, out edt)) { bindCon.Where("{0} is not null and {1} between '{2}' and '{3}'", V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName, V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName, sdt.Date.ToString(), edt.Date.AddDays(1).AddSeconds(-1).ToString() ); //wherebetween = string.Format("[{0}].[{1}] between '{2}' and '{3}'", // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName, // sdt.Date.ToString(), // edt.Date.AddDays(1).AddSeconds(-1).ToString() // ); } else { bindCon.Where("{0} is not null", V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName); //wherebetween = string.Format("[{0}].[{1}] is not null", V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName); } bindCon.OrderBy(V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime, Order.Desc); //hidCondition.Value = string.Format("3|af_where` And [{0}].[{1}]`{2} And {3}|af_pageby`[{4}].[{5}] |af_pagebyorder`0", // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID.FieldName, // bindCon._Cus_ID, // wherebetween, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName // ); //wcp zlg? 转换成json hidCondition.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>(bindCon); BindData(bindCon, 1); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } aspPager.PageSize = 10; 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; } //if (Request["CusId"] == null || !int.TryParse(Request["CusId"].ToString(),out cusId)) //{ // return; //} //if (Request["stfId"] == null || string.IsNullOrEmpty(Request["stfId"].ToString())) //{ // return; //} //stfId = Request["stfId"].ToString(); V_CRM_STAFF_CUSTOMER_NOTCONTACT m_Customer = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); V_CRM_STAFF_CUSTOMER_NOTCONTACT con = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); con.Cus_ID = 5; con.STAFF_ID = 1;//chx?? List <V_CRM_STAFF_CUSTOMER_NOTCONTACT> cusList = BLLTable <V_CRM_STAFF_CUSTOMER_NOTCONTACT> .Factory(conn).Select(new V_CRM_STAFF_CUSTOMER_NOTCONTACT(), con); if (cusList.Count > 0)//未签约 { m_Customer = cusList[0]; Cus_Status.Items.AddRange(FormHelper.GetListItem(AgileFrame.Orm.PersistenceLayer.Model.CRM_STAFF_CUSTOMER.Attribute.CustStatus)); Cus_Status.SelectedIndex = m_Customer.CustStatus; txt_cus_id.Value = m_Customer._Cus_ID.ToString(); txt_s_id.Value = m_Customer.STAFF_ID.ToString(); txt_s_name.Value = m_Customer._SNAME; NextContactTime.Value = DateTime.Now.Date.AddDays(1).ToShortDateString(); txt_lastContactTime.Value = ""; txt_lastnextContactTime.Value = m_Customer._NextContactTime.ToString(); txt_ContactDetailID.Value = m_Customer.ID.ToString(); txt_cus_status.Value = m_Customer._CustStatus.ToString(); page_CompanyAddress.Value = m_Customer.CompanyAddress; page_CompanyName.Value = m_Customer.CompanyName; page_ShopName.Value = m_Customer.ShopName; page_ShopNameURL.Value = m_Customer._ShopNameURL; page_WangWangId.Value = m_Customer._WangWangId; page_CustQQ.Value = m_Customer._CustQQ; page_Phone.Value = m_Customer.CUS_PHONE; page_Email.Value = m_Customer.CUS_EMAIL; page_Cus_Name.Value = m_Customer.Cus_Name; lit_CompanyAddress.Text = m_Customer.CompanyAddress; lit_CompanyName.Text = m_Customer.CompanyName; lit_ShopName.Text = m_Customer.ShopName; lit_ShopNameURL.Text = m_Customer._ShopNameURL; lit_WangWangId.Text = m_Customer._WangWangId; lit_CustQQ.Text = m_Customer._CustQQ; lit_Phone.Text = m_Customer.CUS_PHONE; lit_Email.Text = m_Customer.CUS_EMAIL; lit_Cus_Name.Text = m_Customer.Cus_Name; } else //已签约 { showEditStr = "<div style=\"display:none\">"; showEditEnd = "</div>"; Cus_Status.Enabled = false; btnClientToHighSeas.Visible = false; V_CRM_STAFF_CUSTOMER_CONTACTRECORDS m_CustomerC = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(); V_CRM_STAFF_CUSTOMER_CONTACTRECORDS conc = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(); conc.Cus_ID = 5; conc.SID = "10001"; conc.Top(1); List <V_CRM_STAFF_CUSTOMER_CONTACTRECORDS> cusstaccList = BLLTable <V_CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Select(new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(), conc); if (cusstaccList.Count > 0) { m_CustomerC = cusstaccList[0]; Cus_Status.Items.AddRange(FormHelper.GetListItem(AgileFrame.Orm.PersistenceLayer.Model.CRM_STAFF_CUSTOMER.Attribute.CustStatus)); Cus_Status.SelectedIndex = m_CustomerC.CustStatus; txt_cus_id.Value = m_CustomerC._Cus_ID.ToString(); txt_s_id.Value = m_CustomerC._SID; txt_s_name.Value = m_CustomerC._SNAME; NextContactTime.Value = DateTime.Now.Date.AddDays(1).ToShortDateString(); txt_cus_status.Value = m_CustomerC._CustStatus.ToString(); page_CompanyAddress.Value = m_CustomerC.CompanyAddress; page_CompanyName.Value = m_CustomerC.CompanyName; page_ShopName.Value = m_CustomerC.ShopName; page_ShopNameURL.Value = m_CustomerC._ShopNameURL; page_WangWangId.Value = m_CustomerC._WangWangId; page_CustQQ.Value = m_CustomerC._CustQQ; page_Phone.Value = m_CustomerC.CUS_PHONE; page_Email.Value = m_CustomerC.CUS_EMAIL; page_Cus_Name.Value = m_CustomerC.Cus_Name; lit_CompanyAddress.Text = m_CustomerC.CompanyAddress; lit_CompanyName.Text = m_CustomerC.CompanyName; lit_ShopName.Text = m_CustomerC.ShopName; lit_ShopNameURL.Text = m_CustomerC._ShopNameURL; lit_WangWangId.Text = m_CustomerC._WangWangId; lit_CustQQ.Text = m_CustomerC._CustQQ; lit_Phone.Text = m_CustomerC.CUS_PHONE; lit_Email.Text = m_CustomerC.CUS_EMAIL; lit_Cus_Name.Text = m_CustomerC.Cus_Name; } } bindCon = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(); bindCon._Cus_ID = con.Cus_ID; bindCon.Where("{0} is not null", V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName); bindCon.OrderBy(V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime, Order.Desc); //hidCondition.Value = string.Format("3|af_where` And [{0}].[{1}]`{2} And [{3}].[{4}] is not null|af_pageby`[{5}].[{6}] |af_pagebyorder`0", // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID.FieldName, // bindCon._Cus_ID, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName // ); //wcp zlg? 转换成json hidCondition.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>(bindCon); BindData(bindCon, 1); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; aspPager.PageSize = 20; Cus_Status.Items.AddRange(FormHelper.GetListItem(AgileFrame.Orm.PersistenceLayer.Model.CRM_STAFF_CUSTOMER.Attribute.CustStatus)); 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; } if (Request["CUSID"] == null || !int.TryParse(Request["CUSID"].ToString(), out cusId)) { return; } //zlg-chx,这里如何和员工进行关联,修改下。 HR_STAFF js = userBase.GetStaff(); if (js == null) { return; } stfId = js.STAFF_ID.ToString(); V_CRM_STAFF_CUSTOMER_NOTCONTACT m_Customer = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); V_CRM_STAFF_CUSTOMER_NOTCONTACT con = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); con.Cus_ID = cusId; con.STAFF_ID =decimal.Parse( stfId); List<V_CRM_STAFF_CUSTOMER_NOTCONTACT> cusList = BLLTable<V_CRM_STAFF_CUSTOMER_NOTCONTACT>.Factory(conn).Select(new V_CRM_STAFF_CUSTOMER_NOTCONTACT(), con); if (cusList.Count > 0)//未签约 { addCustConnDailt.Visible = true; m_Customer = cusList[0]; Cus_Status.SelectedIndex = m_Customer.CustStatus; txt_cus_id.Value = m_Customer._Cus_ID.ToString(); txt_s_id.Value = m_Customer.STAFF_ID.ToString(); txt_s_name.Value = m_Customer._SNAME; NextContactTime.Value = DateTime.Now.Date.AddDays(1).ToString("yyyy-MM-dd"); txt_lastContactTime.Value = ""; txt_lastnextContactTime.Value = m_Customer._NextContactTime.ToString(); txt_ContactDetailID.Value = m_Customer.ID.ToString(); txt_cus_status.Value = m_Customer._CustStatus.ToString(); page_CompanyAddress.Value = m_Customer.CompanyAddress; page_CompanyName.Value = m_Customer.CompanyName; page_ShopName.Value = m_Customer.ShopName; page_ShopNameURL.Value = m_Customer._ShopNameURL; page_WangWangId.Value = m_Customer._WangWangId; page_CustQQ.Value = m_Customer._CustQQ; page_Phone.Value = m_Customer.CUS_PHONE; page_Email.Value = m_Customer.CUS_EMAIL; page_Cus_Name.Value = m_Customer.Cus_Name; lit_CompanyAddress.Text = m_Customer.CompanyAddress; lit_CompanyName.Text = m_Customer.CompanyName; lit_ShopName.Text = m_Customer.ShopName; lit_ShopNameURL.Text = m_Customer._ShopNameURL; lit_WangWangId.Text = m_Customer._WangWangId; lit_CustQQ.Text = m_Customer._CustQQ; lit_Phone.Text = m_Customer.CUS_PHONE; lit_Email.Text = m_Customer.CUS_EMAIL; lit_Cus_Name.Text = m_Customer.Cus_Name; Title = m_Customer.Cus_Name + "-" + Title; } else //已签约 { addCustConnDailt.Visible = false; Cus_Status.Enabled = false; btnClientToHighSeas.Visible = false; V_CRM_STAFF_CUSTOMER_CONTACTRECORDS m_CustomerC = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(); V_CRM_STAFF_CUSTOMER_CONTACTRECORDS conc = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(); conc.Cus_ID = cusId; conc.SID = stfId; conc.Top(1); List<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS> cusstaccList = BLLTable<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Select(new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(), conc); if (cusstaccList.Count > 0) { m_CustomerC = cusstaccList[0]; Cus_Status.Items.AddRange(FormHelper.GetListItem(AgileFrame.Orm.PersistenceLayer.Model.CRM_STAFF_CUSTOMER.Attribute.CustStatus)); Cus_Status.SelectedIndex = m_CustomerC.CustStatus; txt_cus_id.Value = m_CustomerC._Cus_ID.ToString(); txt_s_id.Value = m_CustomerC._SID; txt_s_name.Value = m_CustomerC._SNAME; NextContactTime.Value = DateTime.Now.Date.AddDays(1).ToShortDateString(); txt_cus_status.Value = m_CustomerC._CustStatus.ToString(); page_CompanyAddress.Value = m_CustomerC.CompanyAddress; page_CompanyName.Value = m_CustomerC.CompanyName; page_ShopName.Value = m_CustomerC.ShopName; page_ShopNameURL.Value = m_CustomerC._ShopNameURL; page_WangWangId.Value = m_CustomerC._WangWangId; page_CustQQ.Value = m_CustomerC._CustQQ; page_Phone.Value = m_CustomerC.CUS_PHONE; page_Email.Value = m_CustomerC.CUS_EMAIL; page_Cus_Name.Value = m_CustomerC.Cus_Name; lit_CompanyAddress.Text = m_CustomerC.CompanyAddress; lit_CompanyName.Text = m_CustomerC.CompanyName; lit_ShopName.Text = m_CustomerC.ShopName; lit_ShopNameURL.Text = m_CustomerC._ShopNameURL; lit_WangWangId.Text = m_CustomerC._WangWangId; lit_CustQQ.Text = m_CustomerC._CustQQ; lit_Phone.Text = m_CustomerC.CUS_PHONE; lit_Email.Text = m_CustomerC.CUS_EMAIL; lit_Cus_Name.Text = m_CustomerC.Cus_Name; Title = m_CustomerC.Cus_Name + "-" + Title; } } bindCon = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(); bindCon._Cus_ID = con.Cus_ID; bindCon.Where("{0} is not null", V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName); bindCon.OrderBy(V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime, Order.Desc); //hidCondition.Value = string.Format("3|af_where` And [{0}].[{1}]`{2} And [{3}].[{4}] is not null|af_pageby`[{5}].[{6}] |af_pagebyorder`0", // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID.FieldName, // bindCon._Cus_ID, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName // ); //wcp zlg? 转换成json hidCondition.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>(bindCon); //bindCon.OrderBy(); BindData(bindCon, 1); }
protected void btnFind_Click(object sender, EventArgs e) { //wcp zlg? if (string.IsNullOrEmpty(txt_cus_id.Value)) return; bindCon = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS(); bindCon._Cus_ID = Convert.ToInt32(txt_cus_id.Value); DateTime sdt = DateTime.MinValue; DateTime edt = DateTime.MaxValue; //string wherebetween = "1=1"; if (DateTime.TryParse(startTime.Value, out sdt) && DateTime.TryParse(endTime.Value, out edt)) { bindCon.Where("{0} is not null and {1} between '{2}' and '{3}'", V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName, V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName, sdt.Date.ToString(), edt.Date.AddDays(1).AddSeconds(-1).ToString() ); //wherebetween = string.Format("[{0}].[{1}] between '{2}' and '{3}'", // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName, // sdt.Date.ToString(), // edt.Date.AddDays(1).AddSeconds(-1).ToString() // ); } else { bindCon.Where("{0} is not null",V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName); //wherebetween = string.Format("[{0}].[{1}] is not null", V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName); } bindCon.OrderBy(V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime, Order.Desc); //hidCondition.Value = string.Format("3|af_where` And [{0}].[{1}]`{2} And {3}|af_pageby`[{4}].[{5}] |af_pagebyorder`0", // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID.FieldName, // bindCon._Cus_ID, // wherebetween, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.TableName, // V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime.FieldName // ); //wcp zlg? 转换成json hidCondition.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>(bindCon); BindData(bindCon, 1); }