/// <summary>
/// 加载列表
/// </summary>
/// <returns></returns>
public TableData Load(QueryWorkOrderManagementListReq request)
{
var loginUser = _auth.GetCurrentUser();
//where条件
var sSqlWhere = "IsDel=0";
//模糊查询
if (!string.IsNullOrEmpty(request.KeyWorld))
{
//sSqlWhere = sSqlWhere + " and (Name like '%" + request.KeyWorld + "%' or Account like '%" + request.KeyWorld + "%') ";
}
//获取分页存储过程的参数
var sqlPageParams = GetQueryPageParams("WorkOrderManagements", request.PrimaryKey,
"Id,Name,Title,Content,ParentId,FeedbackTime,FeedbackUserId,FeedbackUserName,Priority,UserId,UserName,DepartmentId,DepartmentName,Type,Origin,Sort,CreateTime,UpdateTime,IsDel",
request.PageSize, request.PageIndex, sSqlWhere,
"", request.PrimaryKey + " " + request.Order);
//获取用户数据
var workOrderManagements = UnitWork.SqlQuery <Repository.Domain.WorkOrderManagement.WorkOrderManagement>(
"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),
items = workOrderManagements
});
}
/// <summary>
/// 查
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public TableData Load([FromQuery] QueryWorkOrderManagementListReq request)
{
return(App.Load(request));
}
