public PagedResult <SystemFeedbackDTO> GetList(SystemFeedbackSM sm, int Page, int PageSize)
{
var sql = @"select a.*,b.UserName,c.Description from EM_System_Feedback a
join EM_User_Account b on b.UserId=a.Creater
join EM_User_Role c on b.RoleId=c.Id
where 1=1 ";
if (sm.UserId.HasValue)
{
sql += " and a.Creater=@UserId ";
}
if (sm.IsRepert.HasValue)
{
if (sm.IsRepert.Value == 1)
{
sql += " and (a.ReplyDate is not null or a.ReplyMessage<>'') ";
}
else
{
sql += " and (a.ReplyDate is null or a.ReplyMessage='') ";
}
}
if (sm.SDate.HasValue)
{
sql += " and a.CreateDate >=@SDate ";
}
if (sm.EDate.HasValue)
{
sql += " and a.CreateDate <=@EDate ";
}
var list = DapperHelper.QueryWithPage <SystemFeedbackDTO>(sql, sm, " CreateDate desc ", Page, PageSize);
return(list);
}
public ActionResult FeedbackManage(SystemFeedbackSM sm, int Page = 1, int PageSize = 20)
{
var list = systemFeedbackRepo.GetList(sm, Page, PageSize);
var vms = Mapper.Map <IList <SystemFeedbackVM> >(list.Results);
var result = new PagedResult <SystemFeedbackVM>(vms, Page, PageSize, list.RowCount);
if (Request.IsAjaxRequest())
{
return(PartialView("_ListFeedbackManage", result));
}
ViewBag.userList = SelectHelper.GetUserList();
return(View(result));
}
