public ActionResult GetListJson(DataTablesParameters query)
{
string UserName = Request.GetSqlParamer("UserName");
string LoginName = Request.GetSqlParamer("LoginName");
string sWhere = " 1=1 ";
if (!string.IsNullOrWhiteSpace(UserName))
{
sWhere += $" and UserName like '{UserName}%'";
}
if (!string.IsNullOrWhiteSpace(LoginName))
{
sWhere += $" and LoginName like '{LoginName}%'";
}
SysUserDal sysUserDal = flexibleContext.GetService <SysUserDal>();
var list = sysUserDal.GetModels(
where : sWhere,
orderBy: query.OrderBy,
currentPage: query.Start / 10 + 1,
itemsPerPage: query.Length
);
int recordsCount = sysUserDal.GetCount(sWhere);
var resultJson = new DataTablesResult <SysUser>(query.Draw, recordsCount, recordsCount, list);
return(Json(resultJson));
}