/// <summary>
/// 初始化
/// </summary>
private void PageInit()
{
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
int?ProvinceId = Utils.GetIntNull(Utils.GetQueryStringValue("sltProvince"));
int?CityId = Utils.GetIntNull(Utils.GetQueryStringValue("sltCity"));
int?CountryId = Utils.GetIntNull(Utils.GetQueryStringValue("sltCountry"));
EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType?selCrmType = (EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType), Utils.GetQueryStringValue("selCrmType"));
EyouSoft.Model.SmsStructure.MLBDaoRuLxrSearchInfo search = new EyouSoft.Model.SmsStructure.MLBDaoRuLxrSearchInfo();
search.CityId = CityId;
search.CountryId = CountryId;
search.ProvinceId = ProvinceId;
search.DanWeiType = selCrmType;
var list = new EyouSoft.BLL.SmsStructure.BDaoRuLxr().GetLxrs(CurrentUserCompanyID, pageSize, pageIndex, ref recordCount, search);
if (list == null || list.Count == 0)
{
this.ExporPageInfoSelect1.Visible = false;
this.repList.EmptyText = "<tr><td colspan=\"5\" align=\"center\">暂无相关记录!</td></tr>";
}
else
{
this.repList.DataSource = list;
this.repList.DataBind();
BindPage();
}
}
/// <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.SmsStructure.MLBDaoRuLxrInfo> GetLxrs(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.SmsStructure.MLBDaoRuLxrSearchInfo searchInfo)
{
if (string.IsNullOrEmpty(companyId)) return null;
var items = dal.GetLxrs(companyId, pageSize, pageIndex, ref recordCount, 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="pageSize">页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.SmsStructure.MLBDaoRuLxrInfo> GetLxrs(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.SmsStructure.MLBDaoRuLxrSearchInfo searchInfo)
{
IList <EyouSoft.Model.SmsStructure.MLBDaoRuLxrInfo> items = new List <EyouSoft.Model.SmsStructure.MLBDaoRuLxrInfo>();
string tableName = "view_Crm_Source_Sms_Lxr";
string fields = "CountryId,ProvinceId,CityId,DistrictId,DanWeiName,LxrName,DanWeiType,MingXiType,Mobile";
string orderByString = "IssueTime DESC";
StringBuilder query = new StringBuilder();
#region SQL
query.AppendFormat(" CompanyId='{0}' ", companyId);
if (searchInfo != null)
{
if (searchInfo.CityId.HasValue)
{
query.AppendFormat(" AND CityId={0} ", searchInfo.CityId.Value);
}
if (searchInfo.CountryId.HasValue)
{
query.AppendFormat(" AND CountryId={0} ", searchInfo.CountryId.Value);
}
if (searchInfo.DanWeiType.HasValue)
{
int _danWeiType = -1;
int _mingXiType = -1;
switch (searchInfo.DanWeiType.Value)
{
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.餐馆:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.餐馆;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.车队:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.车队;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.单位直客:
_danWeiType = 0;
_mingXiType = (int)EyouSoft.Model.EnumType.CrmStructure.CrmType.单位直客;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.地接社:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.地接社;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.个人会员:
_danWeiType = 0;
_mingXiType = (int)EyouSoft.Model.EnumType.CrmStructure.CrmType.个人会员;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.购物:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.购物;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.景点:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.景点;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.酒店:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.酒店;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.票务:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.票务;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.其他:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.其他;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.行客户:
_danWeiType = 0;
_mingXiType = (int)EyouSoft.Model.EnumType.CrmStructure.CrmType.行客户;
break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.游轮:
_danWeiType = 1;
_mingXiType = (int)EyouSoft.Model.EnumType.SourceStructure.SourceType.游轮;
break;
default: break;
case EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.系统用户:
_danWeiType = 2;
break;
}
if (_danWeiType > -1)
{
query.AppendFormat(" AND DanWeiType={0} ", _danWeiType);
}
if (_mingXiType > -1)
{
query.AppendFormat(" AND MingXiType={0} ", _mingXiType);
}
}
if (searchInfo.DistrictId.HasValue)
{
query.AppendFormat(" AND DistrictId={0} ", searchInfo.DistrictId.Value);
}
if (searchInfo.ProvinceId.HasValue)
{
query.AppendFormat(" AND ProvinceId={0} ", searchInfo.ProvinceId.Value);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName, string.Empty, fields, query.ToString(), orderByString))
{
while (rdr.Read())
{
EyouSoft.Model.SmsStructure.MLBDaoRuLxrInfo item = new EyouSoft.Model.SmsStructure.MLBDaoRuLxrInfo();
item.CityId = rdr.GetInt32(rdr.GetOrdinal("CityId"));
item.CountryId = rdr.GetInt32(rdr.GetOrdinal("CountryId"));
item.CPCD = null;
item.DanWeiName = rdr["DanWeiName"].ToString();
item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.系统用户;
item.DistrictId = rdr.GetInt32(rdr.GetOrdinal("DistrictId"));
item.LxrName = rdr["LxrName"].ToString();
item.Mobile = rdr["Mobile"].ToString().Trim();
item.ProvinceId = rdr.GetInt32(rdr.GetOrdinal("ProvinceId"));
//类型转换
int _danWeiType = rdr.GetInt32(rdr.GetOrdinal("DanWeiType"));
int _mingXiType = rdr.GetByte(rdr.GetOrdinal("MingXiType"));
if (_danWeiType == 0)
{
EyouSoft.Model.EnumType.CrmStructure.CrmType crmType = (EyouSoft.Model.EnumType.CrmStructure.CrmType)_mingXiType;
switch (crmType)
{
case EyouSoft.Model.EnumType.CrmStructure.CrmType.单位直客: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.单位直客; break;
case EyouSoft.Model.EnumType.CrmStructure.CrmType.个人会员: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.个人会员; break;
case EyouSoft.Model.EnumType.CrmStructure.CrmType.行客户: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.行客户; break;
}
}
else if (_danWeiType == 1)
{
EyouSoft.Model.EnumType.SourceStructure.SourceType sourceType = (EyouSoft.Model.EnumType.SourceStructure.SourceType)_mingXiType;
switch (sourceType)
{
case EyouSoft.Model.EnumType.SourceStructure.SourceType.餐馆: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.餐馆; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.车队: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.车队; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.地接社: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.地接社; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.购物: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.购物; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.景点: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.景点; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.酒店: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.酒店; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.票务: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.票务; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.其他: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.其他; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.游轮: item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.游轮; break;
}
}
else if (_danWeiType == 2)
{
item.DanWeiType = EyouSoft.Model.EnumType.SmsStructure.DaoRuKeHuType.系统用户;
}
items.Add(item);
}
}
return(items);
}