/// <summary>
/// get search info
/// </summary>
/// <returns></returns>
EyouSoft.Model.CrmStructure.MLBCrmSearchInfo GetSearchInfo()
{
var info = new EyouSoft.Model.CrmStructure.MLBCrmSearchInfo();
info.CrmName = Utils.GetQueryStringValue("txtUnitName");
info.ProvinceId = Utils.GetIntNull(Utils.GetQueryStringValue("ddlProvice"));
info.CityId = Utils.GetIntNull(Utils.GetQueryStringValue("ddlCity"));
info.SellerId = Utils.GetQueryStringValue(txtXiaoShouYuan.SellsIDClient);
info.SellerName = Utils.GetQueryStringValue(txtXiaoShouYuan.SellsNameClient);
info.DengJiBH = Utils.GetIntNull(Utils.GetQueryStringValue("ddlLevId"));
info.LxrName = Utils.GetQueryStringValue("txtLxrName");
return(info);
}
/// <summary>
/// 获取客户单位查询信息业务实体的SQL查询条件
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
string GetCrmsQuerySQL(EyouSoft.Model.CrmStructure.MLBCrmSearchInfo searchInfo)
{
StringBuilder s = new StringBuilder();
if (searchInfo != null)
{
/*if (!string.IsNullOrEmpty(searchInfo.BriefCode))
* {
* s.AppendFormat(" AND BrevityCode LIKE '{0}%' ", searchInfo.BriefCode);
* }*/
if (searchInfo.CityId.HasValue)
{
s.AppendFormat(" AND CityId={0} ", searchInfo.CityId.Value);
}
if (!string.IsNullOrEmpty(searchInfo.CrmName))
{
s.AppendFormat(" AND (Name LIKE '%{0}%' OR BrevityCode LIKE '%{0}%') ", searchInfo.CrmName);
}
if (searchInfo.DengJiBH.HasValue)
{
s.AppendFormat(" AND LevId={0} ", searchInfo.DengJiBH.Value);
}
if (searchInfo.ProvinceId.HasValue)
{
s.AppendFormat(" AND ProvinceId={0} ", searchInfo.ProvinceId.Value);
}
if (!string.IsNullOrEmpty(searchInfo.SellerId))
{
s.AppendFormat(" AND SellerId='{0}' ", searchInfo.SellerId);
}
if (!string.IsNullOrEmpty(searchInfo.SellerName))
{
s.AppendFormat(" AND SellerName LIKE '%{0}%' ", searchInfo.SellerName);
}
if (!string.IsNullOrEmpty(searchInfo.LxrName))
{
s.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_CrmLinkman AS A1 WHERE A1.TypeId=tbl_Crm.CrmId AND A1.Name LIKE '%{0}%' AND A1.Type={1}) ", searchInfo.LxrName, (int)EyouSoft.Model.EnumType.ComStructure.LxrType.客户单位);
}
}
return(s.ToString());
}
/// <summary>
/// 获取客户单位信息集合(选用时使用)
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="crmType">客户单位类型</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.CrmStructure.MLBCrmXuanYongInfo> GetCrmsXuanYong(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.EnumType.CrmStructure.CrmType?crmType, EyouSoft.Model.CrmStructure.MLBCrmSearchInfo searchInfo)
{
if (string.IsNullOrEmpty(companyId))
{
return(null);
}
return(dal.GetCrmsXuanYong(companyId, null, null, pageSize, pageIndex, ref recordCount, crmType, searchInfo));
}
/// <summary>
/// 获取客户单位信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="crmType">客户单位类型</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <Model.CrmStructure.MLBCrmInfo> GetCrms(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.EnumType.CrmStructure.CrmType crmType, EyouSoft.Model.CrmStructure.MLBCrmSearchInfo searchInfo)
{
if (string.IsNullOrEmpty(companyId))
{
return(null);
}
if (crmType == EyouSoft.Model.EnumType.CrmStructure.CrmType.个人会员)
{
return(null);
}
bool isOnlySelf = false;
int[] depts = null;
if (crmType == EyouSoft.Model.EnumType.CrmStructure.CrmType.单位直客)
{
depts = GetDataPrivs(EyouSoft.Model.EnumType.PrivsStructure.Menu2.客户管理_单位直客, out isOnlySelf);
}
else if (crmType == EyouSoft.Model.EnumType.CrmStructure.CrmType.行客户)
{
depts = GetDataPrivs(EyouSoft.Model.EnumType.PrivsStructure.Menu2.客户管理_同行客户, out isOnlySelf);
}
var items = dal.GetCrms(companyId, LoginUserId, depts, pageSize, pageIndex, ref recordCount, crmType, searchInfo);
if (items != null && items.Count > 0)
{
var citybll = new EyouSoft.BLL.ComStructure.BComCity();
foreach (var item in items)
{
item.CPCD = citybll.GetCPCD(companyId, item.CountryId, item.ProvinceId, item.CityId, item.DistrictId);
}
}
return(items);
}
/// <summary>
/// 获取客户单位信息集合(选用时使用)
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="userId">数据级浏览权限控制-用户编号</param>
/// <param name="depts">数据级浏览权限控制-部门编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="crmType">客户单位类型</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.CrmStructure.MLBCrmXuanYongInfo> GetCrmsXuanYong(string companyId, string userId, int[] depts, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.EnumType.CrmStructure.CrmType?crmType, EyouSoft.Model.CrmStructure.MLBCrmSearchInfo searchInfo)
{
IList <Model.CrmStructure.MLBCrmXuanYongInfo> items = new List <Model.CrmStructure.MLBCrmXuanYongInfo>();
string tableName = "tbl_Crm";
string fields = "CrmId,Name,Type,LevId";
string orderByString = "IssueTime DESC";
StringBuilder query = new StringBuilder();
#region SQL
query.AppendFormat("CompanyId='{0}' AND IsDelete='0' ", companyId);
query.AppendFormat(GetOrgCondition(userId, depts, "OperatorId", "DeptId"));
if (crmType.HasValue)
{
query.AppendFormat(" AND Type={0} ", (int)crmType.Value);
}
query.Append(GetCrmsQuerySQL(searchInfo));
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName, string.Empty, fields, query.ToString(), orderByString))
{
while (rdr.Read())
{
var info = new Model.CrmStructure.MLBCrmXuanYongInfo();
info.CrmId = rdr.GetString(rdr.GetOrdinal("CrmId"));
info.Lxrs = null;
info.Name = rdr["Name"].ToString();
info.CrmType = (EyouSoft.Model.EnumType.CrmStructure.CrmType)rdr.GetByte(rdr.GetOrdinal("Type"));
info.KeHuDengJiBH = rdr.GetInt32(rdr.GetOrdinal("LevId"));
items.Add(info);
}
}
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
item.Lxrs = GetCrmLxrs(item.CrmId);
}
}
return(items);
}
/// <summary>
/// 获取客户单位信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="userId">数据级浏览权限控制-用户编号</param>
/// <param name="depts">数据级浏览权限控制-部门集合</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="crmType">客户单位类型</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <Model.CrmStructure.MLBCrmInfo> GetCrms(string companyId, string userId, int[] depts, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.EnumType.CrmStructure.CrmType?crmType, EyouSoft.Model.CrmStructure.MLBCrmSearchInfo searchInfo)
{
IList <Model.CrmStructure.MLBCrmInfo> items = new List <Model.CrmStructure.MLBCrmInfo>();
string tableName = "tbl_Crm";
string fields = "CrmId,CountryId,ProvinceId,CityId,CountyId,Type,Name,IsSignContract,SellerId,OperatorId,LevId,SellerName";
string orderByString = "IssueTime DESC";
StringBuilder query = new StringBuilder();
#region SQL
query.AppendFormat(" CompanyId='{0}' AND IsDelete='0' ", companyId);
//query.AppendFormat(GetOrgCondition(userId, depts, "OperatorId", "DeptId"));
if (depts != null && depts.Length == 1 && depts[0] == -1)//查看自己
{
query.AppendFormat(" AND SellerId='{0}' ", userId);
}
else
{
if (depts != null && depts.Length > 0)
{
query.AppendFormat(" AND( EXISTS(SELECT 1 FROM tbl_ComUser AS A WHERE A.UserId=tbl_Crm.SellerId AND A.DeptId IN({0}) ) ", GetIdsByArr(depts));
if (!string.IsNullOrEmpty(userId))
{
query.AppendFormat(" OR SellerId='{0}' ", userId);
}
query.Append(" ) ");
}
}
query.AppendFormat(" AND Type IN({0},{1}) ", (int)EyouSoft.Model.EnumType.CrmStructure.CrmType.单位直客, (int)EyouSoft.Model.EnumType.CrmStructure.CrmType.行客户);
if (crmType.HasValue)
{
query.AppendFormat(" AND Type={0} ", (int)crmType.Value);
}
query.Append(GetCrmsQuerySQL(searchInfo));
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName, string.Empty, fields, query.ToString(), orderByString))
{
while (rdr.Read())
{
var info = new Model.CrmStructure.MLBCrmInfo();
info.CityId = rdr.GetInt32(rdr.GetOrdinal("CityId"));
info.CompanyId = companyId;
info.CountryId = rdr.GetInt32(rdr.GetOrdinal("CountryId"));
info.CrmId = rdr.GetString(rdr.GetOrdinal("CrmId"));
info.DingDanJinE = 0;
info.DingDanRenShu = 0;
info.DingDanShu = 0;
info.DistrictId = rdr.GetInt32(rdr.GetOrdinal("CountyId"));
info.IsXieYi = rdr.GetString(rdr.GetOrdinal("IsSignContract")) == "1";
info.LastTime = null;
info.LevId = rdr.GetInt32(rdr.GetOrdinal("LevId"));
info.Lxrs = null;
info.Name = rdr["Name"].ToString();
info.ProvinceId = rdr.GetInt32(rdr.GetOrdinal("ProvinceId"));
info.SellerId = rdr.GetString(rdr.GetOrdinal("SellerId"));
info.SellerName = rdr["SellerName"].ToString();
info.TuoQianJinE = 0;
info.Type = (EyouSoft.Model.EnumType.CrmStructure.CrmType)rdr.GetByte(rdr.GetOrdinal("Type"));
info.OperatorId = rdr.GetString(rdr.GetOrdinal("OperatorId"));
items.Add(info);
}
}
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
item.Lxrs = GetCrmLxrs(item.CrmId);
var jiaoYiMingXi = GetCrmJiaoYiMingXi(item.CrmId);
item.DingDanJinE = jiaoYiMingXi.DingDanJinE;
item.DingDanRenShu = jiaoYiMingXi.DingDanRenShu;
item.DingDanShu = jiaoYiMingXi.DingDanShu;
item.LastTime = jiaoYiMingXi.LatestTime;
item.TuoQianJinE = jiaoYiMingXi.TuoQianJinE;
item.JiFen = jiaoYiMingXi.JiFen;
}
}
return(items);
}
