| | |
|---|
| | | |
|---|
| | | var query = db |
|---|
| | | .Queryable<QsQaItemXj, Womdaa, MesLine, |
|---|
| | | MesItems, SysUser>((s, a, c, b, us) => |
|---|
| | | MesItems, SysUser,Womcaa,SysDepartment, MesUserDepartmentQc,MesItems>((s, a, c, b, us,ca,d,dq,i) => |
|---|
| | | new JoinQueryInfos( |
|---|
| | | JoinType.Inner, s.BillNo == a.Daa001, |
|---|
| | | JoinType.Left, a.Daa015 == c.LineNo, |
|---|
| | | JoinType.Left, s.ItemId == b.Id, |
|---|
| | | JoinType.Left, us.Fcode == s.CreateBy |
|---|
| | | JoinType.Left, us.Fcode == s.CreateBy, |
|---|
| | | JoinType.Left, ca.Caa020 == a.Daa021, |
|---|
| | | JoinType.Left, d.Departmentcode == c.Departmentcode, |
|---|
| | | JoinType.Left, dq.Departmentcode == d.Departmentcode,//查询用户权限 |
|---|
| | | JoinType.Left, i.Id == Convert.ToDecimal(a.Daa002) |
|---|
| | | ) |
|---|
| | | ) |
|---|
| | | //.WhereIF(lineNo != null && lineNo.Length > 0, |
|---|
| | |
|---|
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
|---|
| | | !"未完成".Equals(queryObj.result), |
|---|
| | | (s, a, c, b, us) => s.SubmitStatus == 1) |
|---|
| | | .WhereIF(id > 0, (s, a, c, b, us) => s.Id == id) |
|---|
| | | .Select((s, a, c, b, us) => new QsQaItemXj |
|---|
| | | .WhereIF(id > 0, (s, a, c, b, us,ca) => s.Id == id) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(queryObj.LoginUser), |
|---|
| | | (s, a, c, b, us, ca, d, dq) => dq.Usercode == queryObj.LoginUser) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(queryObj.SearchValue), |
|---|
| | | (s, a, c, b, us, ca, d, dq,i) => |
|---|
| | | s.ReleaseNo.ToLower().Contains(queryObj.SearchValue.ToLower()) || |
|---|
| | | i.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) || |
|---|
| | | ca.Caa015.ToLower().Contains(queryObj.SearchValue.ToLower()) || |
|---|
| | | i.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower())) |
|---|
| | | .Select((s, a, c, b, us,ca,d) => new QsQaItemXj |
|---|
| | | { |
|---|
| | | Daa020 = c.LineNo, |
|---|
| | | Id = s.Id, |
|---|
| | |
|---|
| | | ItemModel = b.ItemModel, |
|---|
| | | CheckBy = s.CheckBy, |
|---|
| | | CheckResult = s.CheckResult, |
|---|
| | | Remarks = s.Remarks |
|---|
| | | Remarks = s.Remarks, |
|---|
| | | SaleOrder = ca.Caa015, |
|---|
| | | DepartName = d.Departmentname |
|---|
| | | |
|---|
| | | }).OrderBy(s => s.CreateDate, OrderByType.Desc); |
|---|
| | | var items = query.ToPageList(queryObj.PageIndex, queryObj.Limit, |
|---|
| | | ref totalCount); |
|---|
| | |
|---|
| | | .ExecuteCommand(); |
|---|
| | | }); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public int saveNotesPid(XJDto dto) |
|---|
| | | { |
|---|
| | | return SqlSugarHelper.UseTransactionWithOracle(db => |
|---|
| | | { |
|---|
| | | return db.Updateable<QsQaItemXj01>() |
|---|
| | | .SetColumns(it => |
|---|
| | | it.Notes == dto.Remarks) //SetColumns是可以叠加的 写2个就2个字段赋值 |
|---|
| | | .Where(it => it.Id == dto.pid) |
|---|
| | | .ExecuteCommand(); |
|---|
| | | }); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //孙表修改备注字段 |
|---|
| | | public int saveRemarksById(XJDto dto) |
|---|
