/// <summary>
/// 判断是否需要刷新
/// </summary>
/// <param name="reqP"></param>
/// <returns></returns>
public IActionResult GetUnReadCount(DataTablesRequsetDto reqP)
{
var userName = LoginUserHelper.GetLoginUserName(reqP.logonid, User.Identity.Name);
var res = boxBiz.GetUnReadCount(reqP, userName);
return(Json(res));
}
public JsonResult DataTableList(DataTablesRequsetDto reqP)
{
var userName = LoginUserHelper.GetLoginUserName(reqP.logonid, User.Identity.Name);
var res = boxBiz.ListForDataTables(reqP, userName);
return(Json(res));
}
public BizListResultForDataTables <SignMessageBox> ListForDataTables(DataTablesRequsetDto reqP, string email)
{
var emp = getUserInfo(email);
string toempid = emp.emp_id;//"TEST01";
string formtype = SettingConfig.AllString;
if (reqP.formtype != formtype)
{
formtype = roleService.getAppNameByChs(reqP.formtype);
}
int limit = reqP.length;
int start = reqP.start;
double page = start / limit;
int pageIndex = Math.Ceiling(page).ObjToInt() + 1;//Sql Sugar 页从1开始！
var timeSpan = reqP.timespan.Split("-");
//零点日期
var startD = new DateTime(timeSpan[0].ObjToInt(), timeSpan[1].ObjToInt(), timeSpan[2].ObjToInt());
var endD = new DateTime(timeSpan[3].ObjToInt(), timeSpan[4].ObjToInt(), timeSpan[5].ObjToInt());
var res = Service.GetPageList(pageIndex, limit, toempid, startD, endD, formtype, reqP.msgstatus, reqP.msghandlestatus);
return(new BizListResultForDataTables <SignMessageBox>
{
data = res.Rows,
draw = reqP.draw + 1,
recordsFiltered = res.total,
recordsTotal = res.total,
unReadCount = res.Code
});
//Expression<Func<SignMessageBox, object>> orderByExpression = p => p.createtime;
//Expression<Func<SignMessageBox, bool>> whereExpression = buildWhereExpreesion(reqP, userName);
//var res = Service.GetPageList(start, limit);
//return new BizListResultForDataTables<SignMessageBox>
//{
// data = res.Rows,
// draw = reqP.draw + 1,
// recordsFiltered = res.total,
// recordsTotal = res.total
//};
}
public BizResult <SignMessageBox> GetUnReadCount(DataTablesRequsetDto reqP, string email)
{
var emp = getUserInfo(email);
string toempid = emp.emp_id;//"TEST01";
var timeSpan = reqP.timespan.Split("-");
//零点日期
var startD = new DateTime(timeSpan[0].ObjToInt(), timeSpan[1].ObjToInt(), timeSpan[2].ObjToInt());
var endD = new DateTime(timeSpan[3].ObjToInt(), timeSpan[4].ObjToInt(), timeSpan[5].ObjToInt());
string formtype = SettingConfig.AllString;
if (reqP.formtype != formtype)
{
formtype = roleService.getAppNameByChs(reqP.formtype);
}
return(Service.GetUnReadCount(toempid, startD, endD, formtype, HandleStatusString.Undo, (int)ReadStatusEnum.UnRead));
}
/// <summary>
/// DataTable
/// </summary>
/// <param name="reqP"></param>
/// <returns></returns>
public BizListResultForDataTables <SignMessageRole> ListForDataTables(DataTablesRequsetDto reqP1)
{
int ordertype = 0;
int limit = reqP1.length;
int start = reqP1.start;
if (string.IsNullOrEmpty(reqP1.orderString)) //排序方式为空， 倒序
{
ordertype = 1;
}
Expression <Func <SignMessageRole, bool> > whereExpression = null;
Expression <Func <SignMessageRole, object> > orderByExpression = p => new { p.isshow, p.createtime };
var res = Service.GetPageList(start, limit, orderByExpression, ordertype, whereExpression);
return(new BizListResultForDataTables <SignMessageRole>
{
data = res.Rows,
draw = reqP1.draw + 1,
recordsFiltered = res.total,
recordsTotal = res.total
});
}
public JsonResult DataTableList(DataTablesRequsetDto reqP)
{
var res = roleBiz.ListForDataTables(reqP);
return(Json(res));
}
