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
}