/// <summary>
/// 查询投诉列表
/// </summary>
/// <param name="model">搜索实体对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-3</remarks>
public JsonResult List(SearchComplaintsModel model)
{
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
var paramList =
_complaintsService.Select(model);
var data = new { rows = paramList.Data, total = paramList.Data.TotalCount };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 投诉对象分布查询
/// </summary>
/// <param name="model">输入查询参数对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-8</remarks>
public ResultModel Select(SearchComplaintsModel model)
{
var complaints = _database.Db.Complaints;
var user = _database.Db.YH_User;
var merc = _database.Db.YH_MerchantInfo;
var whereExpr = new SimpleExpression(1, 1, SimpleExpressionType.Equal);
//昵称
if (!string.IsNullOrEmpty(model.NickName))
{
whereExpr = new SimpleExpression(whereExpr, user.NickName.Like("%" + model.NickName + "%"), SimpleExpressionType.And);
}
//手机号码
if (!string.IsNullOrEmpty(model.Phone))
{
whereExpr = new SimpleExpression(whereExpr, user.Phone.Like("%" + model.Phone + "%"), SimpleExpressionType.And);
}
//Email
if (!string.IsNullOrEmpty(model.Email))
{
whereExpr = new SimpleExpression(whereExpr, user.Email.Like("%" + model.Email + "%"), SimpleExpressionType.And);
}
//订单Id
if (!string.IsNullOrEmpty(model.OrderID))
{
whereExpr = new SimpleExpression(whereExpr, complaints.OrderID.Like("%" + model.OrderID + "%"), SimpleExpressionType.And);
}
dynamic m;
dynamic u;
var query = complaints.All().LeftJoin(user, out u).On(u.UserID == complaints.UserID).
LeftJoin(merc, out m).On(m.MerchantID == complaints.MerchantID).
Select(
complaints.ComplaintsID,
complaints.OrderID,
m.ShopName,
u.NickName,
u.Phone,
u.Email,
complaints.complainType,
complaints.Content,
complaints.ComplaintsDate,
complaints.DealPeople,
complaints.DealDate,
complaints.Flag,
complaints.Comments
).Where(whereExpr).OrderByComplaintsDateDescending();
var result = new ResultModel
{
Data =
new SimpleDataPagedList <ComplaintsModel>(
query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
/// <summary>
/// 根据用户ID查询投诉数据
/// zhoub 20150716
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public ResultModel GetPagingComplaints(SearchComplaintsModel model)
{
var com = _database.Db.Complaints;
var merc = _database.Db.YH_MerchantInfo;
dynamic m;
var whereExpr = com.UserID == model.UserID;
var result = new ResultModel
{
Data =
new SimpleDataPagedList <ComplaintsModel>(com.All().
LeftJoin(merc, out m).On(m.MerchantID == com.MerchantID).
Select(com.ComplaintsID, com.OrderID, com.Content, com.Comments, com.ComplaintsDate, com.DealDate, merc.ShopName, com.Flag).Where(whereExpr),
model.PagedIndex, model.PagedSize)
};
return(result);
}
