コード例 #1
0
    protected void btnClientToHighSeas_Click(object sender, EventArgs e)
    {
        CRM_STAFF_CUSTOMER con = new CRM_STAFF_CUSTOMER();

        con._Cus_ID = Convert.ToInt32(txt_cus_id.Value);
        con._SID    = txt_s_id.Value;
        int count = BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Delete(con);

        CRM_STAFF_CUSTOMER_CONTACTRECORDS ccon = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        ccon.ID = Convert.ToDecimal(txt_ContactDetailID.Value);
        count  += BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Delete(ccon);

        if (count > 1)
        {
            //丢入公海成功
        }
        else
        {
            //丢入公海失败
            return;
        }

        showEditStr                 = "<div style=\"display:none\">";
        showEditEnd                 = "</div>";
        Cus_Status.Enabled          = false;
        Cus_Status.SelectedIndex    = Convert.ToInt32(txt_cus_status.Value);
        btnClientToHighSeas.Visible = false;
        //UpdatePanel3.UpdateMode = UpdatePanelUpdateMode.Always;
        //UpdatePanel3.Update();
    }
コード例 #2
0
    /// <summary>
    /// 将过期客户投入公海
    /// </summary>
    public void OutPutCustToHighSeas()
    {
        int count = 0;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cSelVal = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        cSelVal._SID    = "";
        cSelVal._Cus_ID = 0;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS ccon = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        ccon.Where("{0} is null and {1} < '{2}'", CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-60));
        List <CRM_STAFF_CUSTOMER_CONTACTRECORDS> csccList = BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Select(cSelVal, ccon);

        if (csccList.Count < 1)
        {
            return;
        }
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cval = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        cval._ContactTime    = DateTime.Now;
        cval._ContactRecords = "过期联系人,系统自动丢入公海!";
        count += BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Update(cval, ccon);//更新未联系为已联系

        List <string> sidList   = new List <string>();
        List <int>    cusidList = new List <int>();

        foreach (CRM_STAFF_CUSTOMER_CONTACTRECORDS cscc in csccList)
        {
            if (!sidList.Contains(cscc.SID))
            {
                sidList.Add(cscc.SID);
            }
            if (!cusidList.Contains(cscc.Cus_ID))
            {
                cusidList.Add(cscc.Cus_ID);
            }
        }

        string[] sidArr   = sidList.ToArray();
        int[]    cusidArr = cusidList.ToArray();

        CRM_STAFF_CUSTOMER con = new CRM_STAFF_CUSTOMER();//删除员工与客户关联

        con.In(CRM_STAFF_CUSTOMER.Attribute.SID, sidArr);
        con.In(CRM_STAFF_CUSTOMER.Attribute.Cus_ID, cusidArr);
        count += BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Delete(con);

        CRM_CUSTOMER ccCon = new CRM_CUSTOMER();

        ccCon.In(CRM_CUSTOMER.Attribute.Cus_Id, cusidArr);
        CRM_CUSTOMER ccVal = new CRM_CUSTOMER();

        ccVal._LoadHighSeasTime = DateTime.Now;
        count += BLLTable <CRM_CUSTOMER> .Factory(conn).Update(ccVal, ccCon);//更新加入公海时间
    }
コード例 #3
0
    protected void btnClientToHighSeas_Click(object sender, EventArgs e)
    {
        CRM_STAFF_CUSTOMER con = new CRM_STAFF_CUSTOMER();

        con._Cus_ID = Convert.ToInt32(txt_cus_id.Value);
        con._SID    = txt_s_id.Value;
        int count = BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Delete(con);

        CRM_STAFF_CUSTOMER_CONTACTRECORDS cval = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        cval.ID             = Convert.ToDecimal(txt_ContactDetailID.Value);
        cval.ContactTime    = DateTime.Now;
        cval.ContactRecords = "被" + userBase.RealName + "(" + userBase.UserID + ")抛入公海";
        count += BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Update(cval, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ID);

        CRM_CUSTOMER ccVal = new CRM_CUSTOMER();

        ccVal._Cus_Id           = con._Cus_ID;
        ccVal._LoadHighSeasTime = DateTime.Now;
        count += BLLTable <CRM_CUSTOMER> .Factory(conn).Update(ccVal, CRM_CUSTOMER.Attribute.Cus_Id);//更新加入公海时间

        if (count > 2)
        {
            //丢入公海成功
            AgileFrame.Core.ScriptHelper.Alert(Page, "投入公海成功!");
            AgileFrame.Core.ScriptHelper.CloseMe(Page);
        }
        else
        {
            //丢入公海失败
            AgileFrame.Core.ScriptHelper.Alert(Page, "投入公海失败!");
            return;
        }

        addCustConnDailt.Visible    = false;
        Cus_Status.Enabled          = false;
        Cus_Status.SelectedIndex    = Convert.ToInt32(txt_cus_status.Value);
        btnClientToHighSeas.Visible = false;
        //UpdatePanel3.UpdateMode = UpdatePanelUpdateMode.Always;
        //UpdatePanel3.Update();
    }
コード例 #4
0
ファイル: Main.aspx.cs プロジェクト: Fred-Lee/AppInOneBPM
    /// <summary>
    /// 将过期客户投入公海
    /// </summary>
    public void OutPutCustToHighSeas()
    {
        int count = 0;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cSelVal = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        cSelVal._SID = "";
        cSelVal._Cus_ID = 0;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS ccon = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        ccon.Where("{0} is null and {1} < '{2}'",CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ContactTime, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-60));
        List<CRM_STAFF_CUSTOMER_CONTACTRECORDS> csccList = BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Select(cSelVal, ccon);
        if (csccList.Count < 1)
            return;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cval = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        cval._ContactTime = DateTime.Now;
        cval._ContactRecords = "过期联系人,系统自动丢入公海!";
        count += BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Update(cval, ccon);//更新未联系为已联系

        List<string> sidList = new List<string>();
        List<int> cusidList = new List<int>();
        foreach (CRM_STAFF_CUSTOMER_CONTACTRECORDS cscc in csccList)
        {
            if (!sidList.Contains(cscc.SID))
                sidList.Add(cscc.SID);
            if (!cusidList.Contains(cscc.Cus_ID))
                cusidList.Add(cscc.Cus_ID);
        }

        string[] sidArr = sidList.ToArray();
        int[] cusidArr = cusidList.ToArray();

        CRM_STAFF_CUSTOMER con = new CRM_STAFF_CUSTOMER();//删除员工与客户关联
        con.In(CRM_STAFF_CUSTOMER.Attribute.SID, sidArr);
        con.In(CRM_STAFF_CUSTOMER.Attribute.Cus_ID, cusidArr);
        count += BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Delete(con);

        CRM_CUSTOMER ccCon = new CRM_CUSTOMER();
        ccCon.In(CRM_CUSTOMER.Attribute.Cus_Id, cusidArr);
        CRM_CUSTOMER ccVal = new CRM_CUSTOMER();
        ccVal._LoadHighSeasTime = DateTime.Now;
        count += BLLTable<CRM_CUSTOMER>.Factory(conn).Update(ccVal, ccCon);//更新加入公海时间
    }
コード例 #5
0
    protected void btnOk_Click(object sender, EventArgs e)
    {
        if (Cus_Status.SelectedIndex == 0)
        {
            lit_Info.Text = "<a style=\"color:Red;\">请选择客户状态!</a>";
            return;
        }
        if (string.IsNullOrEmpty(ContactRecords.Value))
        {
            lit_Info.Text = "<a style=\"color:Red;\">请输入联系记录!</a>";
            return;
        }
        DateTime _nextContactTime = DateTime.MinValue;

        if (!DateTime.TryParse(NextContactTime.Value, out _nextContactTime))
        {
            lit_Info.Text = "<a style=\"color:Red;\">请输入下次联系时间!</a>";
            return;
        }
        if (_nextContactTime.AddDays(1).AddSeconds(-1) <= DateTime.Now)
        {
            lit_Info.Text = "<a style=\"color:Red;\">请输入一个等于或晚于今天的下次联系时间!</a>";
            return;
        }
        DateTime dt = DateTime.MinValue;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS crm_sta_cc = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        crm_sta_cc._Cus_ID          = Convert.ToInt32(txt_cus_id.Value);
        crm_sta_cc._SID             = txt_s_id.Value;
        crm_sta_cc._CustStatus      = Cus_Status.SelectedIndex;
        crm_sta_cc._NextContactTime = _nextContactTime;
        txt_cus_status.Value        = crm_sta_cc._CustStatus.ToString();
        try
        {
            int count = BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Insert(crm_sta_cc);

            if (count < 1)
            {
                lit_Info.Text = "<a style=\"color:Red;\">提交失败!存在重复的记录!</a>";
                return;
            }
            //ContactDetailID.Value

            crm_sta_cc.ID = decimal.Parse(txt_ContactDetailID.Value);
            crm_sta_cc._ContactRecords = ContactRecords.Value;
            crm_sta_cc._ContactTime    = DateTime.Now;
            dt = DateTime.MinValue;
            DateTime.TryParse(txt_lastnextContactTime.Value, out dt);
            crm_sta_cc._NextContactTime = dt;
            count = 0;
            count = BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Update(crm_sta_cc, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.SID, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.Cus_ID, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.NextContactTime, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ID);

            if (count < 1)
            {
                lit_Info.Text = "<a style=\"color:Red;\">提交失败!</a>";
                return;
            }
        }
        catch
        {
            lit_Info.Text = "<a style=\"color:Red;\">提交失败!存在重复的记录!</a>";
            return;
        }
        CRM_STAFF_CUSTOMER crm_sta_c = new CRM_STAFF_CUSTOMER();

        crm_sta_c._Cus_ID     = Convert.ToInt32(txt_cus_id.Value);
        crm_sta_c._SID        = txt_s_id.Value;
        crm_sta_c._CustStatus = Cus_Status.SelectedIndex;
        dt = DateTime.MinValue;
        DateTime.TryParse(txt_lastContactTime.Value, out dt);
        crm_sta_c._LastContactTime = dt;
        try
        {
            BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Update(crm_sta_c, CRM_STAFF_CUSTOMER.Attribute.Cus_ID, CRM_STAFF_CUSTOMER.Attribute.SID);
        }
        catch
        {
            lit_Info.Text = "<a style=\"color:Red;\">提交失败!</a>";
            return;
        }

        CRM_STAFF_CUSTOMER_CONTACTRECORDS csccval = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        csccval.ID = 0;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cscccon = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        csccval.Top(1);
        csccval.SID    = crm_sta_c._SID;
        csccval.Cus_ID = crm_sta_c.Cus_ID;
        csccval.OrderBy(CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ID, Order.Desc);
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cscc = BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).GetRowData(csccval, cscccon);

        if (cscc != null)
        {
            txt_ContactDetailID.Value = cscc.ID.ToString();
        }
        txt_lastContactTime.Value     = crm_sta_cc._ContactTime.ToString();
        txt_lastnextContactTime.Value = _nextContactTime.ToString();
        lit_Info.Text = "<a style=\"color:Green;\">提交成功!</a>";
    }
コード例 #6
0
    protected void btnSub_Click(object sender, EventArgs e)
    {
        lit_AddInfo.Text    = "";
        lit_AddInfo.Visible = false;
        CRM_STAFF_CUSTOMER cscVal = new CRM_STAFF_CUSTOMER();

        cscVal._Cus_ID = 0;
        CRM_STAFF_CUSTOMER cscCon = new CRM_STAFF_CUSTOMER();

        cscCon._SID = hid_SID.Value;
        List <CRM_STAFF_CUSTOMER> cscList = BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Select(cscVal, cscCon);

        if (cscList.Count >= 500)
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!客户数达到上限500个。</a>";
            return;
        }

        if (CheckTheSame())
        {
            return;
        }

        CRM_CUSTOMER c_customer = new CRM_CUSTOMER();

        if (!string.IsNullOrEmpty(txt_addComAddress.Value))
        {
            c_customer.CompanyAddress = txt_addComAddress.Value.Trim().Replace(" ", "");
        }
        c_customer._CustSex = txt_addCustSexMan.Checked ? 1 : 0;
        if (!string.IsNullOrEmpty(txt_addShopName.Value))
        {
            c_customer._ShopName = txt_addShopName.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addShopUrl.Value))
        {
            c_customer._ShopNameURL = txt_addShopUrl.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addWangWangId.Value))
        {
            c_customer._WangWangId = txt_addWangWangId.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addComName.Value))
        {
            c_customer._CompanyName = txt_addComName.Value.Trim().Replace(" ", "");
        }
        else
        {
            c_customer._CompanyName = txt_addShopName.Value.Trim().Replace(" ", "");
        }
        c_customer._LastEditors = hid_SID.Value;
        int count = BLLTable <CRM_CUSTOMER> .Factory(conn).Insert(c_customer);

        if (count < 1)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }
        c_customer.OrderBy(CRM_CUSTOMER.Attribute.Cus_Id, Order.Desc);
        c_customer.Top(1);
        CRM_CUSTOMER c_customerval = new CRM_CUSTOMER();

        c_customerval.Cus_Id = 0;
        List <CRM_CUSTOMER> c_customercusid = BLLTable <CRM_CUSTOMER> .Factory(conn).Select(c_customerval, c_customer);

        if (c_customercusid.Count < 1)//插入不成功?
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        CRM_CUST c_cust = new CRM_CUST();

        c_cust._Cus_ID = c_customercusid[0].Cus_Id;
        if (!string.IsNullOrEmpty(txt_addCustName.Value))
        {
            c_cust._Cus_Name = txt_addCustName.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addEmail.Value))
        {
            c_cust._Email = txt_addEmail.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addMobPhone.Value))
        {
            c_cust._MobPhone = txt_addMobPhone.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addPhone.Value))
        {
            c_cust._Phone = txt_addPhone.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addQQ.Value))
        {
            c_cust._QQ = txt_addQQ.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addCustName.Value))
        {
            c_cust._ContactName = txt_addCustName.Value.Trim().Replace(" ", "");
        }
        c_cust._AddTime  = DateTime.Now;
        c_cust._EditTime = DateTime.Now;
        count           += BLLTable <CRM_CUST> .Factory(conn).Insert(c_cust);

        if (count < 2)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        if (string.IsNullOrEmpty(hid_SID.Value))
        {
            return;
        }
        DateTime lastConTime = DateTime.MinValue;

        if (!string.IsNullOrEmpty(txt_addConDailts.Value))
        {
            CRM_STAFF_CUSTOMER_CONTACTRECORDS c_scc = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
            c_scc._Cus_ID          = c_customercusid[0].Cus_Id;
            c_scc._SID             = hid_SID.Value;
            c_scc._NextContactTime = DateTime.Now;
            c_scc._ContactTime     = DateTime.Now;
            lastConTime            = c_scc._ContactTime;
            c_scc._ContactRecords  = txt_addConDailts.Value;
            c_scc._CustStatus      = ddl_CusStatus.SelectedIndex;
            BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Insert(c_scc);
        }
        CRM_STAFF_CUSTOMER_CONTACTRECORDS c_sccNext = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        c_sccNext._Cus_ID          = c_customercusid[0].Cus_Id;
        c_sccNext._SID             = hid_SID.Value;
        c_sccNext._NextContactTime = DateTime.Now.AddDays(1);
        c_sccNext._CustStatus      = ddl_CusStatus.SelectedIndex;
        count += BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Insert(c_sccNext);

        if (count < 3)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        CRM_STAFF_CUSTOMER c_sc = new CRM_STAFF_CUSTOMER();

        c_sc._Cus_ID     = c_customercusid[0].Cus_Id;
        c_sc._SID        = hid_SID.Value;
        c_sc._CustStatus = ddl_CusStatus.SelectedIndex;
        if (lastConTime != DateTime.MinValue)
        {
            c_sc._LastContactTime = lastConTime;
        }
        count += BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Insert(c_sc);

        if (count < 4)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }
        lit_AddInfo.Visible = true;
        lit_AddInfo.Text    = "<a style=\"color:green; font-size:12px;\">添加成功!</a>";
        ClearForm();
    }
コード例 #7
0
    protected void btnDistribution_Click(object sender, EventArgs e)
    {
        lit_CustInfo.Visible = false;
        lit_CustInfo.Text    = "";
        int count = 0;
        CRM_STAFF_CUSTOMER cscVal = new CRM_STAFF_CUSTOMER();

        cscVal._Cus_ID = 0;
        CRM_STAFF_CUSTOMER cscCon = new CRM_STAFF_CUSTOMER();

        cscCon._SID = ddl_Staf.SelectedItem.Value;
        List <CRM_STAFF_CUSTOMER> cscList = BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Select(cscVal, cscCon);

        if (cscList.Count >= 500)
        {
            lit_CustInfo.Visible = true;
            lit_CustInfo.Text    = "<a style=\"color:red\">改员工客户数达到上限500个,不能再分配!</a>";
            return;
        }
        string msg = "";

        foreach (Control c in repList.Controls)
        {
            if (cscList.Count + count >= 500)
            {
                break;
            }
            RepeaterItem ri = c as RepeaterItem;

            foreach (Control cc in c.Controls)
            {
                if (cc.GetType() == typeof(HtmlInputCheckBox))
                {
                    HtmlInputCheckBox hc = cc as HtmlInputCheckBox;
                    if (hc.Checked)
                    {
                        string[] cus = hc.Value.Split(new string[] { "*|*9527*|*" }, StringSplitOptions.None);
                        if (cus.Length < 2)
                        {
                            break;
                        }
                        CRM_STAFF_CUSTOMER_CONTACTRECORDS csccCon = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
                        csccCon._Cus_ID = Convert.ToInt32(cus[0]);
                        csccCon._SID    = ddl_Staf.SelectedItem.Value;
                        if (BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Exists(csccCon))
                        {
                            msg += ddl_Staf.SelectedItem.Text == "自己" ? "你" : ddl_Staf.SelectedItem.Text;
                            msg += "曾经拥有过客户" + cus[1] + ",不能分配\n";
                            break;
                        }
                        CRM_STAFF_CUSTOMER csc = new CRM_STAFF_CUSTOMER();
                        csc.SID        = ddl_Staf.SelectedItem.Value;
                        csc.Cus_ID     = Convert.ToInt32(cus[0]);
                        csc.CustStatus = 1;
                        BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Insert(csc);

                        CRM_STAFF_CUSTOMER_CONTACTRECORDS cscc = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
                        cscc.SID             = csc.SID;
                        cscc.Cus_ID          = csc.Cus_ID;
                        cscc.NextContactTime = DateTime.Now.AddDays(1);
                        cscc.CustStatus      = 1;
                        BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Insert(cscc);

                        count++;
                        c.Controls.Remove(c);
                        break;
                    }
                }
            }
        }
        lit_CustInfo.Visible = true;
        lit_CustInfo.Text    = "<a style=\"color:green\">成功分配:" + count + "个客户到" + ddl_Staf.SelectedItem.Text + "</a>";
        if (!string.IsNullOrEmpty(msg))
        {
            ScriptHelper.Alert(Page, msg);
        }
        V_CUSTHIGHSEAS con = new V_CUSTHIGHSEAS();

        if (hidHighSeas.Value != "")
        {
            //wcp zlg? 转换回来时转换错了,造成翻页时绑定数据报错。
            con = JsonServiceBase.FromJson <V_CUSTHIGHSEAS>(hidHighSeas.Value);
        }
        //ContactRecords.Value = hidCondition.Value;
        BindData(con, aspPager.CurrentPageIndex);
    }
コード例 #8
0
    protected void btnClientToHighSeas_Click(object sender, EventArgs e)
    {
        CRM_STAFF_CUSTOMER con = new CRM_STAFF_CUSTOMER();
        con._Cus_ID = Convert.ToInt32(txt_cus_id.Value);
        con._SID = txt_s_id.Value;
        int count = BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Delete(con);
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cval = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        cval.ID = Convert.ToDecimal(txt_ContactDetailID.Value);
        cval.ContactTime = DateTime.Now;
        cval.ContactRecords = "被" + userBase.RealName + "(" + userBase.UserID + ")抛入公海";
        count += BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Update(cval, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ID);
        CRM_CUSTOMER ccVal = new CRM_CUSTOMER();
        ccVal._Cus_Id = con._Cus_ID;
        ccVal._LoadHighSeasTime = DateTime.Now;
        count += BLLTable<CRM_CUSTOMER>.Factory(conn).Update(ccVal, CRM_CUSTOMER.Attribute.Cus_Id);//更新加入公海时间
        if (count > 2)
        {
            //丢入公海成功
            AgileFrame.Core.ScriptHelper.Alert(Page, "投入公海成功!");
            AgileFrame.Core.ScriptHelper.CloseMe(Page);
        }
        else
        {
            //丢入公海失败
            AgileFrame.Core.ScriptHelper.Alert(Page, "投入公海失败!");
            return;
        }

        addCustConnDailt.Visible = false;
        Cus_Status.Enabled = false;
        Cus_Status.SelectedIndex = Convert.ToInt32(txt_cus_status.Value);
        btnClientToHighSeas.Visible = false;
        //UpdatePanel3.UpdateMode = UpdatePanelUpdateMode.Always;
        //UpdatePanel3.Update();
    }
コード例 #9
0
    protected void btnOk_Click(object sender, EventArgs e)
    {
        if (Cus_Status.SelectedIndex == 0)
        {
            lit_Info.Text = "<a style=\"color:Red;\">请选择客户状态!</a>";
            return;
        }
        if (string.IsNullOrEmpty(ContactRecords.Value))
        {
            lit_Info.Text = "<a style=\"color:Red;\">请输入联系记录!</a>";
            return;
        }
        DateTime _nextContactTime = DateTime.MinValue;
        if (!DateTime.TryParse(NextContactTime.Value, out _nextContactTime) && Cus_Status.SelectedItem.Value != "5")
        {
            lit_Info.Text = "<a style=\"color:Red;\">请输入下次联系时间!</a>";
            return;
        }
        if (_nextContactTime.AddDays(1).AddSeconds(-1) <= DateTime.Now && Cus_Status.SelectedItem.Value != "5")
        {
            lit_Info.Text = "<a style=\"color:Red;\">请输入一个等于或晚于今天的下次联系时间!</a>";
            return;
        }
        DateTime dt = DateTime.MinValue;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS crm_sta_cc = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        crm_sta_cc._Cus_ID = Convert.ToInt32(txt_cus_id.Value);
        crm_sta_cc._SID = txt_s_id.Value;
        crm_sta_cc._CustStatus = Cus_Status.SelectedIndex;
        crm_sta_cc._NextContactTime = _nextContactTime;
        txt_cus_status.Value = crm_sta_cc._CustStatus.ToString();
        try
        {
            int count = 0;
            if (Cus_Status.SelectedItem.Value != "5")
            {
                count = BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Insert(crm_sta_cc);
                if (count < 1)
                {
                    lit_Info.Text = "<a style=\"color:Red;\">提交失败!存在重复的记录!</a>";
                    return;
                }
            }
            //ContactDetailID.Value

            crm_sta_cc.ID = decimal.Parse(txt_ContactDetailID.Value);
            crm_sta_cc._ContactRecords = ContactRecords.Value;
            crm_sta_cc._ContactTime = DateTime.Now;
            dt = DateTime.MinValue;
            DateTime.TryParse(txt_lastnextContactTime.Value, out dt);
            crm_sta_cc._NextContactTime = dt;
            count = 0;
            count = BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Update(crm_sta_cc, CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ID);
            if (count < 1)
            {
                lit_Info.Text = "<a style=\"color:Red;\">提交失败!</a>";
                return;
            }
        }
        catch
        {
            lit_Info.Text = "<a style=\"color:Red;\">提交失败!存在重复的记录!</a>";
            return;
        }
        CRM_STAFF_CUSTOMER crm_sta_c = new CRM_STAFF_CUSTOMER();
        crm_sta_c._Cus_ID = Convert.ToInt32(txt_cus_id.Value);
        crm_sta_c._SID = txt_s_id.Value;
        crm_sta_c._CustStatus = Cus_Status.SelectedIndex;
        crm_sta_c._LastContactTime = crm_sta_cc._ContactTime;
        try
        {
            BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Update(crm_sta_c, CRM_STAFF_CUSTOMER.Attribute.Cus_ID, CRM_STAFF_CUSTOMER.Attribute.SID);
        }
        catch
        {
            lit_Info.Text = "<a style=\"color:Red;\">提交失败!</a>";
            return;
        }

        CRM_STAFF_CUSTOMER_CONTACTRECORDS csccval = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        csccval.ID = 0;
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cscccon = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        csccval.Top(1);
        csccval.SID = crm_sta_c._SID;
        csccval.Cus_ID = crm_sta_c.Cus_ID;
        csccval.OrderBy(CRM_STAFF_CUSTOMER_CONTACTRECORDS.Attribute.ID, Order.Desc);
        CRM_STAFF_CUSTOMER_CONTACTRECORDS cscc = BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).GetRowData(csccval, cscccon);
        if (cscc!= null)
            txt_ContactDetailID.Value = cscc.ID.ToString();
        txt_lastContactTime.Value = crm_sta_cc._ContactTime.ToString();
        txt_lastnextContactTime.Value = _nextContactTime.ToString();
        lit_Info.Text = "<a style=\"color:Green;\">提交成功!</a>";

        AgileFrame.Core.ScriptHelper.Alert(Page, "提交成功!");
        AgileFrame.Core.ScriptHelper.CloseMe(Page);
    }
コード例 #10
0
    protected void btnDistribution_Click(object sender, EventArgs e)
    {
        lit_CustInfo.Visible = false;
        lit_CustInfo.Text = "";
        int count = 0;
        CRM_STAFF_CUSTOMER cscVal = new CRM_STAFF_CUSTOMER();
        cscVal._Cus_ID = 0;
        CRM_STAFF_CUSTOMER cscCon = new CRM_STAFF_CUSTOMER();
        cscCon._SID = ddl_Staf.SelectedItem.Value;
        List<CRM_STAFF_CUSTOMER> cscList = BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Select(cscVal, cscCon);
        if (cscList.Count >= 500)
        {
            lit_CustInfo.Visible = true;
            lit_CustInfo.Text = "<a style=\"color:red\">改员工客户数达到上限500个,不能再分配!</a>";
            return;
        }
        string msg = "";
        foreach (Control c in repList.Controls)
        {
            if (cscList.Count + count >= 500)
                break;
            RepeaterItem ri = c as RepeaterItem;

            foreach (Control cc in c.Controls)
            {
                if (cc.GetType() == typeof(HtmlInputCheckBox))
                {
                    HtmlInputCheckBox hc = cc as HtmlInputCheckBox;
                    if (hc.Checked)
                    {
                        string[] cus = hc.Value.Split(new string[]{"*|*9527*|*"},StringSplitOptions.None);
                        if(cus.Length<2)
                            break;
                        CRM_STAFF_CUSTOMER_CONTACTRECORDS csccCon = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
                        csccCon._Cus_ID = Convert.ToInt32(cus[0]);
                        csccCon._SID = ddl_Staf.SelectedItem.Value;
                        if (BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Exists(csccCon))
                        {
                            msg += ddl_Staf.SelectedItem.Text == "自己" ? "你" : ddl_Staf.SelectedItem.Text;
                            msg += "曾经拥有过客户" + cus[1] + ",不能分配\n";
                            break;
                        }
                        CRM_STAFF_CUSTOMER csc = new CRM_STAFF_CUSTOMER();
                        csc.SID = ddl_Staf.SelectedItem.Value;
                        csc.Cus_ID = Convert.ToInt32(cus[0]);
                        csc.CustStatus = 1;
                        BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Insert(csc);

                        CRM_STAFF_CUSTOMER_CONTACTRECORDS cscc = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
                        cscc.SID = csc.SID;
                        cscc.Cus_ID = csc.Cus_ID;
                        cscc.NextContactTime = DateTime.Now.AddDays(1);
                        cscc.CustStatus = 1;
                        BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Insert(cscc);
                        count++;
                        c.Controls.Remove(c);
                        break;
                    }
                }
            }
        }
        lit_CustInfo.Visible = true;
        lit_CustInfo.Text = "<a style=\"color:green\">成功分配:" + count + "个客户到" + ddl_Staf.SelectedItem.Text + "</a>";
        if (!string.IsNullOrEmpty(msg))
            ScriptHelper.Alert(Page, msg);
        V_CUSTHIGHSEAS con = new V_CUSTHIGHSEAS();
        if (hidHighSeas.Value != "")
        {
            //wcp zlg? 转换回来时转换错了,造成翻页时绑定数据报错。
            con = JsonServiceBase.FromJson<V_CUSTHIGHSEAS>(hidHighSeas.Value);
        }
        //ContactRecords.Value = hidCondition.Value;
        BindData(con, aspPager.CurrentPageIndex);
    }
コード例 #11
0
    protected void btnClientToHighSeas_Click(object sender, EventArgs e)
    {
        CRM_STAFF_CUSTOMER con = new CRM_STAFF_CUSTOMER();
        con._Cus_ID = Convert.ToInt32(txt_cus_id.Value);
        con._SID = txt_s_id.Value;
        int count = BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Delete(con);
        CRM_STAFF_CUSTOMER_CONTACTRECORDS ccon = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        ccon.ID = Convert.ToDecimal(txt_ContactDetailID.Value);
        count += BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Delete(ccon);
        if (count > 1)
        {
            //丢入公海成功
        }
        else
        {
            //丢入公海失败
            return;
        }

        showEditStr = "<div style=\"display:none\">";
        showEditEnd = "</div>";
        Cus_Status.Enabled = false;
        Cus_Status.SelectedIndex = Convert.ToInt32(txt_cus_status.Value);
        btnClientToHighSeas.Visible = false;
        //UpdatePanel3.UpdateMode = UpdatePanelUpdateMode.Always;
        //UpdatePanel3.Update();
    }
コード例 #12
0
    protected void btnSub_Click(object sender, EventArgs e)
    {
        lit_AddInfo.Text = "";
        lit_AddInfo.Visible = false;
        CRM_STAFF_CUSTOMER cscVal = new CRM_STAFF_CUSTOMER();
        cscVal._Cus_ID = 0;
        CRM_STAFF_CUSTOMER cscCon = new CRM_STAFF_CUSTOMER();
        cscCon._SID = hid_SID.Value;
        List<CRM_STAFF_CUSTOMER> cscList = BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Select(cscVal, cscCon);
        if (cscList.Count >= 500)
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!客户数达到上限500个。</a>";
            return;
        }

        if (CheckTheSame())
        {
            return;
        }

        CRM_CUSTOMER c_customer = new CRM_CUSTOMER();
        if (!string.IsNullOrEmpty(txt_addComAddress.Value))
            c_customer.CompanyAddress = txt_addComAddress.Value.Trim().Replace(" ", "");
        c_customer._CustSex = txt_addCustSexMan.Checked ? 1 : 0;
        if (!string.IsNullOrEmpty(txt_addShopName.Value))
            c_customer._ShopName = txt_addShopName.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addShopUrl.Value))
            c_customer._ShopNameURL = txt_addShopUrl.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addWangWangId.Value))
            c_customer._WangWangId = txt_addWangWangId.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addComName.Value))
            c_customer._CompanyName = txt_addComName.Value.Trim().Replace(" ", "");
        else
            c_customer._CompanyName = txt_addShopName.Value.Trim().Replace(" ", "");
        c_customer._LastEditors = hid_SID.Value;
        int count = BLLTable<CRM_CUSTOMER>.Factory(conn).Insert(c_customer);
        if (count < 1)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }
        c_customer.OrderBy(CRM_CUSTOMER.Attribute.Cus_Id, Order.Desc);
        c_customer.Top(1);
        CRM_CUSTOMER c_customerval = new CRM_CUSTOMER();
        c_customerval.Cus_Id = 0;
        List<CRM_CUSTOMER> c_customercusid = BLLTable<CRM_CUSTOMER>.Factory(conn).Select(c_customerval, c_customer);
        if (c_customercusid.Count < 1)//插入不成功?
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        CRM_CUST c_cust = new CRM_CUST();
        c_cust._Cus_ID = c_customercusid[0].Cus_Id;
        if (!string.IsNullOrEmpty(txt_addCustName.Value))
            c_cust._Cus_Name = txt_addCustName.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addEmail.Value))
            c_cust._Email = txt_addEmail.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addMobPhone.Value))
            c_cust._MobPhone = txt_addMobPhone.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addPhone.Value))
            c_cust._Phone = txt_addPhone.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addQQ.Value))
            c_cust._QQ = txt_addQQ.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addCustName.Value))
            c_cust._ContactName = txt_addCustName.Value.Trim().Replace(" ", "");
        c_cust._AddTime = DateTime.Now;
        c_cust._EditTime = DateTime.Now;
        count += BLLTable<CRM_CUST>.Factory(conn).Insert(c_cust);
        if (count < 2)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        if (string.IsNullOrEmpty(hid_SID.Value))
            return;
        DateTime lastConTime = DateTime.MinValue;
        if (!string.IsNullOrEmpty(txt_addConDailts.Value))
        {
            CRM_STAFF_CUSTOMER_CONTACTRECORDS c_scc = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
            c_scc._Cus_ID = c_customercusid[0].Cus_Id;
            c_scc._SID = hid_SID.Value;
            c_scc._NextContactTime = DateTime.Now;
            c_scc._ContactTime = DateTime.Now;
            lastConTime = c_scc._ContactTime;
            c_scc._ContactRecords = txt_addConDailts.Value;
            c_scc._CustStatus = ddl_CusStatus.SelectedIndex;
            BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Insert(c_scc);
        }
        CRM_STAFF_CUSTOMER_CONTACTRECORDS c_sccNext = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        c_sccNext._Cus_ID = c_customercusid[0].Cus_Id;
        c_sccNext._SID = hid_SID.Value;
        c_sccNext._NextContactTime = DateTime.Now.AddDays(1);
        c_sccNext._CustStatus = ddl_CusStatus.SelectedIndex;
        count += BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Insert(c_sccNext);
        if (count < 3)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        CRM_STAFF_CUSTOMER c_sc = new CRM_STAFF_CUSTOMER();
        c_sc._Cus_ID = c_customercusid[0].Cus_Id;
        c_sc._SID = hid_SID.Value;
        c_sc._CustStatus = ddl_CusStatus.SelectedIndex;
        if (lastConTime != DateTime.MinValue)
            c_sc._LastContactTime = lastConTime;
        count += BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Insert(c_sc);
        if (count < 4)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }
        lit_AddInfo.Visible = true;
        lit_AddInfo.Text = "<a style=\"color:green; font-size:12px;\">添加成功!</a>";
        ClearForm();
    }