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)); }