/// <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);
}
}
