| | |
|---|
| | | //当前类已经继承了 Repository 增、删、查、改的方法 |
|---|
| | | //这里面写的代码不会给覆盖,如果要重新生成请删除 MesInvItemOutsManager.cs |
|---|
| | | |
|---|
| | | public List<MesInvItemOuts> GetProductionPickPage(WarehouseQuery query) |
|---|
| | | public (List<MesInvItemOuts> Items, int TotalCount) GetProductionPickPage(WarehouseQuery query) |
|---|
| | | { |
|---|
| | | return Db.Queryable<MesInvItemOuts, MesDepots>((a, o) => |
|---|
| | | int totalCount = 0; // 初始化 totalCount |
|---|
| | | // 确保这里使用 'out' 来获取总行数 |
|---|
| | | var result = Db.Queryable<MesInvItemOuts, MesDepots>((a, o) => |
|---|
| | | new JoinQueryInfos( |
|---|
| | | JoinType.Left, |
|---|
| | | o.DepotCode == a.DepotCode && a.Company == o.Company && |
|---|
| | | a.Factory == o.Factory |
|---|
| | | a.Factory == a.Factory |
|---|
| | | )) |
|---|
| | | .Where((a, o) => a.BillTypeId == 200 && |
|---|
| | | a.TransactionNo == 201 && |
|---|
| | |
|---|
| | | ItemOutNo = a.ItemOutNo, |
|---|
| | | DepotName = o.DepotName // 需要动态添加的字段 |
|---|
| | | }) |
|---|
| | | .ToPageList(query.PageIndex, query.Limit); |
|---|
| | | .ToPageList(query.PageIndex, query.Limit, ref totalCount); // 确保这里使用 'out' |
|---|
| | | |
|---|
| | | return (result, totalCount); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public MaterialReceipt GetProductionPick(WarehouseQuery query) |
|---|
| | |
|---|
| | | if (query.id != null) |
|---|
| | | { |
|---|
| | | var mesInvItemOutsList = GetProductionPickPage(query); |
|---|
| | | if (mesInvItemOutsList.Count <= 0) return form; |
|---|
| | | if (mesInvItemOutsList.TotalCount <= 0) return form; |
|---|
| | | |
|---|
| | | form.ItemOuts = mesInvItemOutsList[0]; |
|---|
| | | form.ItemOuts = mesInvItemOutsList.Items[0]; |
|---|
| | | form.ItemsList = getProductionItemsList(query); |
|---|
| | | form.InvItemoutCDetails = GetProductionDetails(query); |
|---|
| | | } |
|---|
| | |
|---|
| | | throw new Exception("获取数据失败"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | private MessageCenter ProductionMesToErpParam(WarehouseQuery query) |
|---|
| | | public MessageCenter ProductionMesToErpParam(WarehouseQuery query) |
|---|
| | | { |
|---|
| | | var erpParameters = ""; |
|---|
| | | var title = ""; |
|---|
| | |
|---|
| | | item.ItemId + "')"; |
|---|
| | | var C_ITEM_UNIT = Db.Ado.SqlQuerySingle<string>(sql); |
|---|
| | | |
|---|
| | | var xsddh = item.Caa015 ?? ""; |
|---|
| | | var wzh = item.PositionNo ?? ""; |
|---|
| | | var qty = ((int)item.Quantity).ToString(); |
|---|
| | | var erpid = ((int)item.erpId).ToString(); |
|---|
| | | var id = ((int)item.Id).ToString(); |
|---|
| | | scllentryList.Add(new |
|---|
| | | { |
|---|
| | | FMaterialId = item.ItemNo, |
|---|
| | | FUnitID = C_ITEM_UNIT, |
|---|
| | | FAppQty = item.Quantity, |
|---|
| | | FActualQty = item.Quantity, |
|---|
| | | FAppQty = qty, |
|---|
| | | FActualQty = qty, |
|---|
| | | FStockId = item.DepotCode, |
|---|
| | | FPPBomEntryId = item.erpId, |
|---|
| | | F_UNW_Text_xsddh = item.Caa015, |
|---|
| | | F_UNW_TEXT_WZH = item.PositionNo, |
|---|
| | | F_MES_ENTRYID = item.Id |
|---|
| | | FPPBomEntryId = erpid, |
|---|
| | | F_UNW_Text_xsddh = xsddh, |
|---|
| | | F_UNW_TEXT_WZH = wzh, |
|---|
| | | F_MES_ENTRYID = id |
|---|
| | | }); |
|---|
| | | } |
|---|
| | | |
|---|
| | | var dataJson = new |
|---|
| | | { |
|---|
| | | F_MES_ID = mesInvItemOuts.Id, |
|---|
| | | FDate = mesInvItemOuts.CreateBy, |
|---|
| | | F_MES_ID = mesInvItemOuts.Id.ToString(), |
|---|
| | | FDate = DateTime.Now.ToString("yyyy-MM-dd"), |
|---|
| | | FPickerId = userName, |
|---|
| | | F_UNW_LargeText_BZ = " ", |
|---|
| | | F_UNW_KH = " ", |
|---|
| | | F_UNW_DDSL = womcaa.Caa012, |
|---|
| | | F_UNW_DDSL = womcaa.Caa012.ToString(), |
|---|
| | | F_UNW_Text_CZG = userName, |
|---|
| | | scllentry = scllentryList |
|---|
| | | }; |
|---|
