/// <summary>
/// 加载流程列表
/// </summary>
/// <returns></returns>
public TableData Load(QueryWorkflowListReq request)
{
//获取分页存储过程的参数
//var sqlPageParams = GetQueryPageParams("Workflow", "Id",
// "Id, Name,[Identity], SqlId, Remark, IsAble, IsDel, Sort",100, 1, "","", "Id Desc");
var loginUser = _auth.GetCurrentUser();
//where条件
var sSqlWhere = "IsDel=0";
//模糊查询
if (!string.IsNullOrEmpty(request.KeyWorld))
{
sSqlWhere = sSqlWhere + " and (Name like '%" + request.KeyWorld + "%') ";
}
//获取分页存储过程的参数
var sqlPageParams = GetQueryPageParams("WorkFlows", request.PrimaryKey,
"Id, Name,[Identity], Label,SqlId, Remark, IsAble, IsDel,WorkOrderManagementId,CreateTime, Sort",
request.PageSize, request.PageIndex, sSqlWhere,
"", request.PrimaryKey + " " + request.Order);
//获取流程列表
var wfList = UnitWork.SqlQuery <Repository.Domain.WorkFlow>(
"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 = wfList
});
}
/// <summary>
/// 加载列表
/// </summary>
/// <returns></returns>
public TableData Load([FromQuery] QueryWorkflowListReq response)
{
return(_app.Load(response));
}
