/// <summary> /// 客户名称重复列表,包含(客户名称、客户编号、客户状态、锁定状态) /// </summary> /// <returns>返回格式:客户编号_客户名称_客户状态_锁定状态</returns> internal string GetCustNameList() { string msg = ""; int totalCount = 0; BitAuto.YanFa.Crm2009.Entities.QueryCustInfo qci = new BitAuto.YanFa.Crm2009.Entities.QueryCustInfo(); qci.ExistCustName = this.CustName; if (!string.IsNullOrEmpty(this.CustID)) { qci.ExistCustID = this.CustID; } DataTable dt = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(qci, "", 1, 100000, out totalCount); if (totalCount > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string custID = dt.Rows[i]["CustID"].ToString().Trim(); string custName = dt.Rows[i]["CustName"].ToString().Trim(); string status = dt.Rows[i]["Status"].ToString().Trim(); string lockStatus = dt.Rows[i]["Lock"].ToString().Trim(); msg += custID + "_" + BLL.Util.EscapeString(custName) + "_" + status + "_" + lockStatus + ","; } } return(msg.TrimEnd(',')); }
private void BindData() { int count = -1; BitAuto.YanFa.Crm2009.Entities.QueryCustInfo query = new BitAuto.YanFa.Crm2009.Entities.QueryCustInfo(); Entities.ProjectTask_DelCustRelation model = BLL.ProjectTask_DelCustRelation.Instance.GetProjectTask_DelCustRelationByTID(TID); if (IsShowdDelCustRelation && model != null && !string.IsNullOrEmpty(model.DelCustIDs)) { query.DelCustIDs = model.DelCustIDs; } else { if (!string.IsNullOrEmpty(CustName)) { if (!string.IsNullOrEmpty(CustNameAllMatch) && CustNameAllMatch.ToLower().Equals("yes")) { query.ExistCustName = CustName; } else { query.CustName = CustName; } } if (ProvinceID > 0) { query.ProvinceID = ProvinceID.ToString(); } if (CityID > 0) { query.CityID = CityID.ToString(); } if (CountyID > 0) { query.CountyID = CountyID.ToString(); } if (ExceptCustID > 0) { query.ExistCustID = ExceptCustID.ToString(); } if (!string.IsNullOrEmpty(CustAddress)) { query.Address = CustAddress; } //if (!string.IsNullOrEmpty(TradeMarketID)) //{ // query.TradeMarketID = TradeMarketID; //} if (!string.IsNullOrEmpty(CustContactName)) { query.ContactAllName = CustContactName; } } DataTable dt = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(query, "CustName", 1, 100, out count); repterCustInfo.DataSource = dt; repterCustInfo.DataBind(); }
private void LoadData(string requestSearch) { if (requestSearch == "yes") { //查询 int totalCount = 0; BitAuto.YanFa.Crm2009.Entities.QueryCustInfo query = new BitAuto.YanFa.Crm2009.Entities.QueryCustInfo(); if (RequestCustID != "") { query.CustID = RequestCustID; } if (RequestCustName != "") { query.CustName = RequestCustName; } if (RequestProvinceID != "-1" && RequestProvinceID != "") { query.ProvinceID = RequestProvinceID; } if (RequestCityID != "-1" && RequestCityID != "") { query.CityID = RequestCityID; } query.Status = 0; DataTable table; switch (RequestType) { case "1": query.TypeID = ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Company).ToString(); table = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(query, "CreateTime Desc", PageCommon.Instance.PageIndex, PageSize, out totalCount); break; case "2": query.TypeID = ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Bloc).ToString(); table = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(query, "CreateTime Desc", PageCommon.Instance.PageIndex, PageSize, out totalCount); break; case "3": query.TypeID = ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.TradeMarket).ToString();; table = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(query, "CreateTime Desc", PageCommon.Instance.PageIndex, PageSize, out totalCount); break; case "4": query.TypeID = "20003"; spanTitle.InnerHtml = "选择所属4S"; table = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(query, "CreateTime Desc", PageCommon.Instance.PageIndex, PageSize, out totalCount); break; default: //显示全部客户,但是要加权限判断 int userID = int.Parse(Session["userid"].ToString()); string departID = Session["departid"].ToString(); table = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(query, userID, departID, "CreateTime Desc", PageCommon.Instance.PageIndex, PageSize, out totalCount); break; } //设置数据源 if (table != null && table.Rows.Count > 0) { repterCustomerList.DataSource = table; } //绑定列表数据 repterCustomerList.DataBind(); litPagerDown.Text = PageCommon.Instance.LinkStringByPost(GetWhere(), GroupLength, totalCount, PageSize, PageCommon.Instance.PageIndex, 1); } }