protected void BindData(V_CRM_STAFF_CUSTOMER_CONTACTRECORDS con, int curPage)
    {
        //hidCondition.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>(con);
        int recount = -1;
        V_CRM_STAFF_CUSTOMER_CONTACTRECORDS val = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        val._SNAME         = "";
        val.ContactTime    = DateTime.MinValue;
        val.ContactRecords = "";

        if (con.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序
        {
            con.af_PageBy(V_CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ID, Order.Desc);
        }
        List <V_CRM_STAFF_CUSTOMER_CONTACTRECORDS> listObj = BLLTable <V_CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).SelectByPage(val, con, aspPager.PageSize, curPage, ref recount);

        if (listObj.Count > 0)
        {
            FormHelper.Bind(Page, listObj[0].DicAttrValues);
            //BindToFindSelect(listObj[0].DicAttrValues);
            txt_lastContactTime.Value = string.IsNullOrEmpty(txt_lastContactTime.Value) ? listObj[0].ContactTime.ToString() : txt_lastContactTime.Value;
        }
        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
        //hidCondition.Value = con.ToJson(200);
    }
 protected void aspPager_PageChanged(object sender, EventArgs e)
 {
     if (hidCondition.Value != "")
     {
         //wcp zlg? 转换回来时转换错了,造成翻页时绑定数据报错。
         bindCon = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>(hidCondition.Value);
     }
     //ContactRecords.Value = hidCondition.Value;
     BindData(bindCon, aspPager.CurrentPageIndex);
 }
Exemplo n.º 3
0
 protected void aspPager_PageChanged(object sender, EventArgs e)
 {
     if (hidCondition.Value != "")
     {
         //wcp zlg? 转换回来时转换错了,造成翻页时绑定数据报错。
         bindCon = JsonServiceBase.FromJson<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>(hidCondition.Value);
     }
     //ContactRecords.Value = hidCondition.Value;
     BindData(bindCon, aspPager.CurrentPageIndex);
 }
Exemplo n.º 4
0
    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 BindData(V_CRM_STAFF_CUSTOMER_CONTACTRECORDS con, int curPage)
 {
     //hidCondition.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>(con);
     int recount = -1;
     V_CRM_STAFF_CUSTOMER_CONTACTRECORDS val = new V_CRM_STAFF_CUSTOMER_CONTACTRECORDS();
     val._SNAME = "";
     val.ContactTime = DateTime.MinValue;
     val.ContactRecords = "";
     List<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS> listObj = BLLTable<V_CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).SelectByPage(val, con, aspPager.PageSize, curPage, ref recount);
     if (listObj.Count > 0)
     {
         FormHelper.Bind(Page, listObj[0].DicAttrValues);
         //BindToFindSelect(listObj[0].DicAttrValues);
         txt_lastContactTime.Value = string.IsNullOrEmpty(txt_lastContactTime.Value) ? listObj[0].ContactTime.ToString() : txt_lastContactTime.Value;
     }
     repList.DataSource = listObj;
     repList.DataBind();
     aspPager.RecordCount = recount;
     //hidCondition.Value = con.ToJson(200);
 }
    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);
    }
Exemplo n.º 7
0
    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);
    }
Exemplo n.º 8
0
    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);
    }