| | |
| | | /// </summary> |
| | | /// <param name="wo"></param> |
| | | /// <returns></returns> |
| | | public async Task<ApiAction<ShippingOutput>> GetShipList(string wo, string orgCode) |
| | | public async Task<ApiAction<ShippingOutput>> GetShipList(ShippingInput input) |
| | | { |
| | | var result = new ApiAction<ShippingOutput>(); |
| | | try |
| | | { |
| | | DbClient db = Biz.DataSource["YadaU9C"].Client; |
| | | var org = await Biz.Db.Queryable<SYS_ORGANIZATION>().Where(q => q.ORG_CODE == orgCode).FirstAsync(); |
| | | var org = await Biz.Db.Queryable<SYS_ORGANIZATION>().Where(q => q.ORG_CODE == input.orgCode).FirstAsync(); |
| | | string wo = input.wo; |
| | | if (!input.SN.IsNullOrEmpty() && input.wo.IsNullOrEmpty()) { |
| | | var woSn = Biz.Db.Queryable<BIZ_MES_WO_SN>().Where(q => q.SN == input.SN || q.FLOW_SN == input.SN).First(); |
| | | if (!woSn.IsNullOrEmpty()) { |
| | | wo = woSn.WORK_ORDER; |
| | | } |
| | | } |
| | | var ship = db.Queryable<mes_ShipList>().Where(q => q.MoDoc.Equals(wo) && q.Org == org.ID.ToInt64()).First(); |
| | | if (!ship.IsNullOrEmpty()) |
| | | { |
| | | result.Data = ship.BusinessDate.Date == DateTime.Now.Date ? new() |
| | | { |
| | | ShipDoc = ship.ShipDoc, |
| | | ShippingQty = ship.ShipQty, |
| | | Tag = "Customer" |
| | | } : new() |
| | | { |
| | | ShipDoc = ship.ShipDoc, |
| | | ShippingQty = ship.ShipQty, |
| | | Tag = "InStoreLabel" |
| | | }; |
| | |
| | | { |
| | | result.Data = new() |
| | | { |
| | | ShipDoc = "", |
| | | ShippingQty = 0, |
| | | Tag = "InStoreLabel" |
| | | }; |