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