using Rhea.Common; using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Linq.Expressions; using System.Text; using System.Threading; using System.Threading.Tasks; using Tiger.Model; using Tiger.IBusiness; using Org.BouncyCastle.Ocsp; namespace Tiger.Business.WMS.Transaction { /// /// 标准下架事务 /// public class Out_Default : WMSTransactionBase, IOut_Default { public IOut_Default Init(string id, string userCode, string apiHost, string orgCode) { TransID = id; UserCode = userCode; ApiHost = apiHost; OrgCode = orgCode; Logger.Console.Info($"Start {this.GetType().Name} Transaction[ID: {TransID}]"); return this; } #region Propertys & Variables public string UserCode { get; set; } public long UserId { get; set; } public string OrgCode { get; set; } public Inventory CurInvItem { get; set; } public ScanShelfInfo CurScanShelf { get; set; } public string Command { get; set; } = "Normal"; #endregion #region Functions /// /// 扫描入口 /// public async Task> Scan(BaseInput input) { var action = new ApiAction(); try { if (input.SN.IsNullOrEmpty()) { action.IsSuccessed = false; //action.LocaleMsg = Biz.L("条码不能为空"); action.LocaleMsg = Biz.L("WMS.Default.ScanItem.SnEmptyFailure"); return SetOutPutMqttMsg(action, input.Locale); } //扫描物料并复核 { action = await ScanItem(input); } } catch (Exception ex) { //取消当前操作 ResetInfo(); //action.CatchExceptionWithLog(ex, $"扫描[{input.SN}]异常"); action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.Scan.ScanException", input.SN)); } return SetOutPutMqttMsg(action, input.Locale); } /// /// 扫描物料并复核,如果是智能货架则亮灯提醒储位 /// public async Task> ScanItem(BaseInput input) { var action = new ApiAction(new ScanOutput() { Command = Command }); try { //解析条码 Result result = WMS_ITEM_Biz.WmsItem.Get(input.SN, input.AuthOption, true); if (!result.IsSuccessed) { action.IsSuccessed = false; action.LocaleMsg = result.LocaleMsg; return action; } CurInvItem = result.Data as Inventory; //验证条码是否正确 if (!CurInvItem.isNormalStatus || CurInvItem.Status != WMS_ITEM.STATUSs.InStore) { action.IsSuccessed = false; //action.LocaleMsg = Biz.L($"状态[{0}]异常,请重新扫描"); action.LocaleMsg = Biz.L("WMS.Default.ScanItem.StatusException", string.Join(',', CurInvItem.StatusList.Select(x => x.GetDesc()))); return action; } //储位验证 if (CurInvItem.Location.IsNullOrEmpty()) { action.IsSuccessed = false; //action.LocaleMsg = Biz.L($"条码[{0}]库存信息异常: 没有储位信息,请先上架后再扫描(储位Id: {1})"); action.LocaleMsg = Biz.L("WMS.Default.ScanItem.LocationIsNull", CurInvItem.CurPkg.SN, CurInvItem.CurPkg.LOCATION_ID); return action; } //物料验证 if (CurInvItem.ItemInfo.IsNullOrEmpty() || CurInvItem.ItemInfo.IS_ACTIVE == "N") { action.IsSuccessed = false; //action.LocaleMsg = Biz.L($"物料编码[{0}]不存在或者该物料未启用"); action.LocaleMsg = Biz.L("WMS.Default.ScanItem.ItemCodeNotExistsOrNotActive", CurInvItem.ItemInfo.ITEM_CODE.IsNullOrEmpty(CurInvItem.Barcode.ItemCode)); return action; } //出库下架 foreach (var item in CurInvItem.Items) { item.TRANS_CODE = "Out_Default"; item.TRANS_NO = $"Out_Default_{DateTime.Now:yyyyMMdd}"; } Result downResult = WMS_ITEM_Biz.WmsItem.TakeDown(CurInvItem, input.AuthOption, WMS_ITEM.STATUSs.Sended); if (!downResult.IsSuccessed) { action.IsSuccessed = false; action.LocaleMsg = downResult.LocaleMsg; return action; } TakeDownInfo downInfo = downResult.Data; //灭灯 if (CurInvItem.Shelf.IsLightShelf) { await Share.Shelf.DownSingle(TransID, CurInvItem.Location); } //保存数据库 var db = Business.Biz.Db; var dbTran = db.UseTran(() => { //下架 db.Updateable(downInfo.Items, UserCode).ExecuteCommand(); db.Insertable(downInfo.History, UserCode).ExecuteCommand(); db.Updateable(downInfo.Packages, UserCode).ExecuteCommand(); }); if (!dbTran.IsSuccess) { Logger.Default.Fatal(dbTran.ErrorException, "Database transaction save exception"); throw dbTran.ErrorException; } action.Data.Data = new DefaultScanItemOutput() { SN = CurInvItem.SN, ItemCode = CurInvItem.ItemInfo.ITEM_CODE, MaterialName = CurInvItem.ItemInfo.ITEM_NAME, Qty = CurInvItem.CurPkg.QTY, Unit = CurInvItem.CurPkg.UNIT, regionCode = CurInvItem.Region.REGION_CODE, locationCode = CurInvItem.Location?.LOCATION_CODE, DateCode = CurInvItem.Items[0].PROD_DATE, ScanAfCut = CurInvItem.Warehouse.SCAN_AF_CUT }; //action.LocaleMsg = Biz.L($"扫描条码[{0}]从储位[{1}]下架成功"); action.LocaleMsg = Biz.L("WMS.Default.ScanItem.TakeDownSucceeded", CurInvItem.SN, CurInvItem.Location?.LOCATION_CODE); } catch (Exception ex) { ResetInfo(); //action.CatchExceptionWithLog(ex, $"扫描条码[{input.SN}]复核异常"); action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.ScanItem.ScanException", input.SN)); } return action; } /// /// 扫描货架或者储位(供亮灯货架使用) /// public async Task> ScanShelf(string Code) { var action = new ApiAction(); try { if (Code.IsNullOrEmpty()) { action.IsSuccessed = false; //action.LocaleMsg = Biz.L("请输入或扫描有效的货架/储位码"); action.LocaleMsg = Biz.L("WMS.Default.ScanShelf.ShelfCanNotEmpty"); return action; } CurScanShelf = new ScanShelfInfo(); // 查询货架信息 var whUnit = await Biz.Db.Queryable().Where(t => t.SHELF_CODE.ToUpper() == Code.ToUpper() && t.AUTH_ORG == OrgCode).IncludesAllFirstLayer().FirstAsync(); // 扫描货架代码,且为智能货架 if (whUnit != null && whUnit.SHELF_TYPE == WMS_SHELF.SHELF_TYPEs.Smart.GetValue()) { CurScanShelf.Shelf = whUnit.Shelf; CurScanShelf.WarehouseCode = whUnit.WH_CODE; CurScanShelf.RegionCode = whUnit.REGION_CODE; CurScanShelf.ShelfCode = whUnit.SHELF_CODE; CurScanShelf.ShelfType = whUnit.SHELF_TYPE; CurScanShelf.IsSmartRack = true; } // 扫描库位代码 else { var nLocation = await Biz.Db.Queryable().Where(t => t.LOCATION_CODE.ToUpper() == Code.ToUpper() && t.AUTH_ORG == OrgCode).IncludesAllFirstLayer().FirstAsync(); if (nLocation == null) { action.IsSuccessed = false; //action.LocaleMsg = Biz.L("储位[{0}]不存在"); action.LocaleMsg = Biz.L("WMS.Default.ScanShelf.LocationNotExist", Code); return action; } if (nLocation.IS_ACTIVE == "N") { action.IsSuccessed = false; //action.LocaleMsg = Biz.L("扫描的储位[{0}]未启用"); action.LocaleMsg = Biz.L("WMS.Default.ScanShelf.ShelfOrLocationDisabled", Code); return action; } //if (nLocation.Shelf.IsLightShelf || nLocation.Location.IS_SINGLE == "Y") //{ // var locationData = Biz.Db.Queryable().Where(q => q.LOCATION_ID == nLocation.LOCATION_ID && q.AUTH_ORG == OrgCode).First(); // if (!locationData.IsNullOrEmpty()) // { // action.IsSuccessed = false; // //action.LocaleMsg = Biz.L("储位[{0}]已存有物料[{1}],请检查系统库存信息"); // action.LocaleMsg = Biz.L($"WMS.Default.ScanShelf.ItemAlreadyExistsInLocation", Code, locationData.SN); // return action; // } //} CurScanShelf.Shelf = nLocation.Shelf; CurScanShelf.Location = nLocation.Location; CurScanShelf.WarehouseCode = nLocation.WH_CODE; CurScanShelf.RegionCode = nLocation.REGION_CODE; CurScanShelf.ShelfCode = nLocation.SHELF_CODE; CurScanShelf.LocationCode = nLocation.LOCATION_CODE; CurScanShelf.IsSmartRack = false; } CurScanShelf.IsScanShelf = true; //action.LocaleMsg = Biz.L("扫描货架/储位[{0}]成功"); action.LocaleMsg = Biz.L("WMS.Default.ScanShelf.ScanSucceeded", Code); action.Data.Data = CurScanShelf; } catch (Exception ex) { //取消当前操作 ResetInfo(); //action.CatchExceptionWithLog(ex, $"扫描货架/储位[{0}]异常"); action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.ScanShelf.ScanException", Code)); } return action; } #endregion /// /// 重置当前操作,有需要则重写此方法 /// public override void ResetInfo() { base.ResetInfo(); Command = null; CurInvItem = null; CurScanShelf = null; } public override bool Close(bool needSaveHistoryLog = false) { this.IsFinished = true; return IsFinished ? base.Close(needSaveHistoryLog) : IsFinished; } }//endClass }