/// <summary>
/// 获得投诉管理显示列表页面上的数据
/// </summary>
/// <param name="model">投诉管理列表页面搜索Model</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">当前显示记录数</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public IList <Model.CrmStructure.MComplaintsListModel> GetVisitShowModel(Model.CrmStructure.MComplaintsSearchModel model, int pageIndex, int pageSize, ref int recordCount)
{
IList <Model.CrmStructure.MComplaintsListModel> list = new List <Model.CrmStructure.MComplaintsListModel>();
StringBuilder sbWhereSql = new StringBuilder();
sbWhereSql.AppendFormat(" CompanyId='{0}' ", model.CompanyId);
if (!string.IsNullOrEmpty(model.TourCode))
{
sbWhereSql.AppendFormat(" and TourCode like '%{0}%' ", model.TourCode);
}
if (!string.IsNullOrEmpty(model.RouteName))
{
sbWhereSql.AppendFormat(" and RouteName like '%{0}%' ", model.RouteName);
}
if (model.StartTime != null)
{
sbWhereSql.AppendFormat(" and ComplaintsTime>='{0}'", model.StartTime.ToString());
}
if (model.EndTime != null)
{
sbWhereSql.AppendFormat(" and ComplaintsTime<='{0}' ", model.EndTime.ToString());
}
if (!string.IsNullOrEmpty(model.ComplaintsName))
{
sbWhereSql.AppendFormat(" and ComplaintsName like '%{0}%' ", model.ComplaintsName);
}
if (!string.IsNullOrEmpty(model.ComplaintsType))
{
sbWhereSql.AppendFormat(" and ComplaintsType like '%{0}%' ", model.ComplaintsType);
}
using (IDataReader reader = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, "view_CrmComplaint", "ComplaintsId", "*", sbWhereSql.ToString(), " IssueTime desc"))
{
while (reader.Read())
{
Model.CrmStructure.MComplaintsListModel visitListModel = new EyouSoft.Model.CrmStructure.MComplaintsListModel();
visitListModel.CompanyId = model.CompanyId;
visitListModel.TourCode = !reader.IsDBNull(reader.GetOrdinal("TourCode")) ? (string)reader["TourCode"] : string.Empty;
visitListModel.TourId = !reader.IsDBNull(reader.GetOrdinal("TourId")) ? (string)reader["TourId"] : string.Empty;
visitListModel.RouteName = !reader.IsDBNull(reader.GetOrdinal("RouteName")) ? (string)reader["RouteName"] : string.Empty;
visitListModel.RouteId = !reader.IsDBNull(reader.GetOrdinal("RouteId")) ? (string)reader["RouteId"] : string.Empty;
visitListModel.IsHandle = !reader.IsDBNull(reader.GetOrdinal("IsHandle")) ? reader["IsHandle"].ToString() == "0" ? false : true : false;
visitListModel.Id = (int)reader["Id"];
visitListModel.HandleTime = !reader.IsDBNull(reader.GetOrdinal("HandleTime")) ? (DateTime?)reader["HandleTime"] : null;
visitListModel.HandleResult = !reader.IsDBNull(reader.GetOrdinal("HandleOpinion")) ? (string)reader["HandleOpinion"] : string.Empty;
visitListModel.HandleName = !reader.IsDBNull(reader.GetOrdinal("HandleName")) ? (string)reader["HandleName"] : string.Empty;
visitListModel.ComplaintsType = !reader.IsDBNull(reader.GetOrdinal("ComplaintsType")) ? (string)reader["ComplaintsType"] : string.Empty;
visitListModel.ComplaintsTime = !reader.IsDBNull(reader.GetOrdinal("ComplaintsTime")) ? (DateTime?)reader["ComplaintsTime"] : null;
visitListModel.ComplaintsName = !reader.IsDBNull(reader.GetOrdinal("ComplaintsName")) ? (string)reader["ComplaintsName"] : string.Empty;
visitListModel.ComplaintsId = !reader.IsDBNull(reader.GetOrdinal("ComplaintsId")) ? (string)reader["ComplaintsId"] : string.Empty;
list.Add(visitListModel);
}
}
return(list);
}
/// <summary>
/// 获得投诉管理显示列表页面上的数据
/// </summary>
/// <param name="model">投诉管理列表页面搜索Model</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">当前显示记录数</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public IList <Model.CrmStructure.MComplaintsListModel> GetVisitShowModel(Model.CrmStructure.MComplaintsSearchModel model, int pageIndex, int pageSize, ref int recordCount)
{
if (model == null)
{
return(null);
}
if (string.IsNullOrEmpty(model.CompanyId))
{
return(null);
}
return(complaintDal.GetVisitShowModel(model, pageIndex, pageSize, ref recordCount));
}
