| | |
| | | private readonly IHttpContextAccessor _http; |
| | | |
| | | private readonly string _userCode, _userGuid, _orgFids; |
| | | |
| | | public PrintUserManager(IHttpContextAccessor httpContextAccessor) |
| | | { |
| | | _http = httpContextAccessor; |
| | |
| | | var _sbBy = |
| | | new StringBuilder(query.sortName + " " + query.sortOrder); |
| | | var totalCount = 0; |
| | | var itemsList = Db |
| | | .Queryable<PrintUser, PrintInfo, SysUser>((a, b, c) => |
| | | new object[] |
| | | var itemsList = Db.Queryable<PrintUser, PrintInfo, SysUser>( |
| | | (a, b, c) => new object[] |
| | | { |
| | | JoinType.Left, a.PrintId == b.Guid, |
| | | JoinType.Left, a.UserId == c.Guid |
| | | JoinType.Left, a.UserId == c.Guid, |
| | | }) |
| | | .Select((a, b, c) => new PrintUser |
| | | { |
| | |
| | | IsStatus = a.IsStatus, |
| | | Account = c.Account, |
| | | userName = c.UserName, |
| | | printNo = b.PrintNo |
| | | printNo = b.PrintNo, |
| | | }) |
| | | .Where(_sbWhere.ToString()) |
| | | .OrderBy(_sbBy.ToString()) |
| | |
| | | [RequestMethod(RequestMethods.POST)] |
| | | public ReturnDto<PrintUser> GetModel([FromBody] PrintUser model) |
| | | { |
| | | var m = Db.Queryable<PrintUser, PrintInfo, SysUser>((a, b, c) => |
| | | new object[] |
| | | var m = Db.Queryable<PrintUser, PrintInfo, SysUser>( |
| | | (a, b, c) => new object[] |
| | | { |
| | | JoinType.Left, a.PrintId == b.Guid, |
| | | JoinType.Left, a.UserId == c.Guid |
| | | JoinType.Left, a.UserId == c.Guid, |
| | | }) |
| | | .Where((a, b, c) => a.Guid == model.Guid) |
| | | .Select((a, b, c) => new PrintUser |
| | |
| | | IsStatus = a.IsStatus, |
| | | Account = c.Account, |
| | | userName = c.UserName, |
| | | printNo = b.PrintNo |
| | | printNo = b.PrintNo, |
| | | }).First(); |
| | | |
| | | |
| | | if (m != null) |
| | | return ReturnDto<PrintUser>.QuickReturn(m, ReturnCode.Success, |
| | | "读取成功!"); |