public TableData Load(QueryModifierListReq request)
{
var loginUser = _auth.GetCurrentUser();
//var modifiersList = UnitWork.SqlQuery<Modifier>("select [Id], [WOM_ID], [UpdateNumber], [SO_ID], [User_ID], [UserName], [CreateTime], [UpdateTime] from Modifiers").ToList();
//where条件
var sSqlWhere = "";
////模糊查询
//if (!string.IsNullOrEmpty(request.KeyWorld))
//{
// sSqlWhere = sSqlWhere + " and (Name like '%" + request.KeyWorld + "%' or Account like '%" + request.KeyWorld + "%') ";
//}
//获取分页存储过程的参数
var sqlPageParams = GetQueryPageParams("Modifiers", request.PrimaryKey,
"[Id], [WOM_ID], [UpdateNumber], [SO_ID], [User_ID], [UserName], [CreateTime], [UpdateTime],[Remark]",
request.PageSize, request.PageIndex, sSqlWhere,
"", request.PrimaryKey + " " + request.Order);
//获取用户数据
var modifiersList = UnitWork.SqlQuery <Modifier>(
"proc_Paging @TableNames,@PrimaryKey,@Columns,@PageSize,@PageIndex,@sWhere,@Group,@Order,@totalCount output"
, sqlPageParams).ToList();
return(new TableData()
{
total = ((SqlParameter)sqlPageParams.ToList()[8]).Value.ToInt(0),
data = modifiersList
});
}
public TableData Load([FromQuery] QueryModifierListReq request)
{
return(app.Load(request));
}
