/// <summary>
/// get search info
/// </summary>
/// <returns></returns>
EyouSoft.Model.CrmStructure.MLBCrmPersonalSearchInfo GetSearchInfo()
{
var info = new EyouSoft.Model.CrmStructure.MLBCrmPersonalSearchInfo();
info.JiFenOperator = (EyouSoft.Model.EnumType.FinStructure.EqualSign?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.FinStructure.EqualSign), Utils.GetQueryStringValue(txtJiFen.ClientUniqueIDOperator));
info.JiFenOperatorNumber = Utils.GetIntNull(Utils.GetQueryStringValue(txtJiFen.ClientUniqueIDOperatorNumber), 0);
info.MemberCardCode = Utils.GetQueryStringValue("txtCardCode");
info.MemberTypeId = Utils.GetIntNull(Utils.GetQueryStringValue("txtMemberTypeId"));
info.Name = Utils.GetQueryStringValue("txtName");
info.Telephone = Utils.GetQueryStringValue("txtTelephone");
return(info);
}
/// <summary>
/// 获取个人会员信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.CrmStructure.MLBCrmPersonalInfo> GetCrmsPersonal(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.CrmStructure.MLBCrmPersonalSearchInfo searchInfo)
{
if (string.IsNullOrEmpty(companyId))
{
return(null);
}
bool isOnlySelf = false;
int[] depts = null;
depts = GetDataPrivs(EyouSoft.Model.EnumType.PrivsStructure.Menu2.客户管理_个人会员, out isOnlySelf);
return(dal.GetCrmsPersonal(companyId, LoginUserId, depts, pageSize, pageIndex, ref recordCount, searchInfo));
}
/// <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="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.CrmStructure.MLBCrmPersonalInfo> GetCrmsPersonal(string companyId, string userId, int[] depts, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.CrmStructure.MLBCrmPersonalSearchInfo searchInfo)
{
IList <EyouSoft.Model.CrmStructure.MLBCrmPersonalInfo> items = new List <EyouSoft.Model.CrmStructure.MLBCrmPersonalInfo>();
string tableName = "view_Crm_Personal";
string fields = "CrmId,CountryId,ProvinceId,CityId,CountyId,Type,Name,OperatorId,MemberTypeName,MemberCardNumber,Gender,ContactPhone,MobilePhone,AvailableIntegral,SellerId";
string orderByString = "IssueTime DESC";
StringBuilder query = new StringBuilder();
#region SQL
query.AppendFormat(" CompanyId='{0}' AND IsDelete='0' ", companyId);
query.AppendFormat(" AND Type={0} ", (int)EyouSoft.Model.EnumType.CrmStructure.CrmType.个人会员);
//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=view_Crm_Personal.SellerId AND A.DeptId IN({0}) ) ", GetIdsByArr(depts));
if (!string.IsNullOrEmpty(userId))
{
query.AppendFormat(" OR SellerId='{0}' ", userId);
}
query.Append(" ) ");
}
}
if (searchInfo != null)
{
if (searchInfo.JiFenOperator.HasValue && searchInfo.JiFenOperatorNumber.HasValue)
{
string _operator = Utils.GetSqlBiJiaoYunSuanFu((int)searchInfo.JiFenOperator.Value);
query.AppendFormat(" AND AvailableIntegral{0}{1} ", _operator, searchInfo.JiFenOperatorNumber.Value);
}
if (!string.IsNullOrEmpty(searchInfo.MemberCardCode))
{
query.AppendFormat(" AND MemberCardNumber LIKE '%{0}%' ", searchInfo.MemberCardCode);
}
if (searchInfo.MemberTypeId.HasValue)
{
query.AppendFormat(" AND MemberType={0} ", searchInfo.MemberTypeId.Value);
}
if (!string.IsNullOrEmpty(searchInfo.Name))
{
query.AppendFormat(" AND Name LIKE '%{0}%' ", searchInfo.Name);
}
if (!string.IsNullOrEmpty(searchInfo.Telephone))
{
query.AppendFormat(" AND (ContactPhone LIKE '%{0}%' OR MobilePhone LIKE '%{0}%') ", searchInfo.Telephone);
}
}
#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.MLBCrmPersonalInfo();
info.CrmId = rdr.GetString(rdr.GetOrdinal("CrmId"));
info.Gender = (EyouSoft.Model.EnumType.GovStructure.Gender)rdr.GetByte(rdr.GetOrdinal("Gender"));
info.JiFen = rdr.GetDecimal(rdr.GetOrdinal("AvailableIntegral"));
info.MemberCardCode = rdr["MemberCardNumber"].ToString();
info.MemberTypeName = rdr["MemberTypeName"].ToString();
info.Mobile = rdr["MobilePhone"].ToString();
info.Name = rdr["Name"].ToString();
info.OperatorId = rdr.GetString(rdr.GetOrdinal("OperatorId"));
info.Telephone = rdr["ContactPhone"].ToString();
info.SellerId = rdr["SellerId"].ToString();
items.Add(info);
}
}
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
var jiaoYiMingXi = GetCrmJiaoYiMingXi(item.CrmId);
item.DingDanJinE = jiaoYiMingXi.DingDanJinE;
item.DingDanRenShu = jiaoYiMingXi.DingDanRenShu;
item.DingDanShu = jiaoYiMingXi.DingDanShu;
item.LatestTime = jiaoYiMingXi.LatestTime;
item.TuoQianJinE = jiaoYiMingXi.TuoQianJinE;
item.JiFen = jiaoYiMingXi.JiFen;
}
}
return(items);
}
