protected void Page_Load(object sender, EventArgs e) { #region//默认隐藏的列 //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(CRM_CUSTOMER.Attribute.EXP1); //hideTableColumnList.Add(CRM_CUSTOMER.Attribute.EXP2); //hideTableColumnList.Add(CRM_CUSTOMER.Attribute.EXP3); //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要 //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(CRM_CUSTOMER.Attribute.EXP1); //hideFindColumnList.Add(CRM_CUSTOMER.Attribute.EXP2); //hideFindColumnList.Add(CRM_CUSTOMER.Attribute.EXP3); #endregion valObj.OrderBy(CRM_CUSTOMER.Attribute.Cus_Id, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { CRM_CUSTOMER roleOld = new CRM_CUSTOMER(); roleOld.Where(CRM_CUSTOMER.Attribute.Cus_Id, Request["ids"].ToString()); listObj = BLLTable <CRM_CUSTOMER> .Factory(conn).Select(valObj, roleOld); for (int i = 0; i < listObj.Count; i++) { if (i > 0) { hidOld.Value += ","; hidInitIDS.Value += ","; } hidOld.Value += "{ID:'" + listObj[i].Cus_Id + "',Name:'" + listObj[i].Cus_Id + "'}";//这里的Name用于显示在列表中,请自行重定义。 hidInitIDS.Value += listObj[i].Cus_Id; } } try { listObj = BLLTable <CRM_CUSTOMER> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; } catch (Exception ex) { litWarn.Text = ex.Message; } } }
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(); }
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(); }