| | |
| | | /// </summary> |
| | | /// <param name="wo"></param> |
| | | /// <returns></returns> |
| | | public async Task<ApiAction> GetShipList(string wo, string orgCode) |
| | | public async Task<ApiAction<ShippingOutput>> GetShipList(string wo, string orgCode) |
| | | { |
| | | var result = new ApiAction(); |
| | | 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 shipList = db.Queryable<mes_ShipList>().Where(q => q.MoDoc.Equals(wo) && SqlFunc.DateIsSame(q.BusinessDate, DateTime.Now) && q.Status == 2 && q.Org == org.ID.ToInt64()).ToList(); |
| | | if (shipList.Any()) |
| | | var org = await Biz.Db.Queryable<SYS_ORGANIZATION>().Where(q => q.ORG_CODE == orgCode).FirstAsync(); |
| | | var ship = db.Queryable<mes_ShipList>().Where(q => q.MoDoc.Equals(wo) && q.Org == org.ID.ToInt64()).First(); |
| | | if (!ship.IsNullOrEmpty()) |
| | | { |
| | | result.Data = shipList[0].ShipQty; |
| | | result.Data = ship.BusinessDate.Date == DateTime.Now.Date ? new() |
| | | { |
| | | ShippingQty = ship.ShipQty, |
| | | Tag = "Customer" |
| | | } : new() |
| | | { |
| | | ShippingQty = ship.ShipQty, |
| | | Tag = "InStoreLabel" |
| | | }; |
| | | result.LocaleMsg = new($"出货信息存在!"); |
| | | } |
| | | else |
| | | { |
| | | result.Data = "InStoreLabel"; |
| | | result.Data = new() |
| | | { |
| | | ShippingQty = 0, |
| | | Tag = "InStoreLabel" |
| | | }; |
| | | } |
| | | } |
| | | catch (Exception ex) |