using Model.ModelDto;
|
using Model.ModelVm;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using WMS.Entity.Context;
|
using WMS.IBLL.IPdaServer;
|
using WMS.DAL;
|
using WMS.Entity.BllAsnEntity;
|
using WMS.Entity.DataEntity;
|
using WMS.Entity.SysEntity;
|
|
namespace WMS.BLL.BllPdaServer
|
{
|
public class PdaAsnServer : IPdaAsnServer
|
{
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
|
// 获取单据列表
|
public List<ArrivalNoticeDto> GetArrivalNotices(ArrivalNoticeVm model)
|
{
|
string sqlString = string.Empty;
|
try
|
{
|
// 未关单的单据
|
sqlString = $"select * from BllArrivalNotice where Status != '3' and IsDel='0' order by CreateTime;";
|
var modelList = Db.Ado.SqlQuery<ArrivalNoticeDto>(sqlString);
|
|
return modelList;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
// 根据单据号获取单据明细列表
|
public List<ArrivalNoticeDetailDto> GetArrivalNoticeDetails(ArrivalNoticeVm model)
|
{
|
string sqlString = string.Empty;
|
try
|
{
|
sqlString = $"select * from BllArrivalNoticeDetail where ASNNo = '{model.ASNNo}' and isdel='0' order by CreateTime;";
|
var modelList = Db.Ado.SqlQuery<ArrivalNoticeDetailDto>(sqlString);
|
|
return modelList;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
// 根据单据明细ID获取明细详情
|
public ArrivalNoticeDetailDto GetArrivalNoticeDetail(ArrivalNoticeDetailVm model)
|
{
|
string sqlString = string.Empty;
|
try
|
{
|
if (model.Id == null || model.Id == 0)
|
{
|
throw new Exception("明细ID不可为空！");
|
}
|
|
sqlString = $"select * from BllArrivalNoticeDetail where Id = '{model.Id}' and isdel='0' order by CreateTime;";
|
var modelList = Db.Ado.SqlQuery<ArrivalNoticeDetailDto>(sqlString);
|
|
if (modelList.Count > 0)
|
{
|
return modelList[0];
|
}
|
|
return new ArrivalNoticeDetailDto();
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
/// <summary>
|
/// 验证托盘是否存在
|
/// </summary>
|
/// <param name="palletNo">托盘号</param>
|
/// <returns>"":可使用 -1:不可使用（原因)</returns>
|
public string IsEnablePalletNo(string palletNo)
|
{
|
string sqlMsg = "";
|
string sqlString = string.Empty;
|
try
|
{
|
sqlString = $"select * from SysPallets where PalletNo = '{palletNo}' and isdel = '0';";
|
var models = Db.Ado.SqlQuery<PalletBindVm>(sqlString);
|
|
if (models.Count > 1)
|
{
|
sqlMsg = "-1:存在重复托盘号,请检查!";
|
return sqlMsg;
|
}
|
if (models.Count > 0)
|
{
|
if (models[0].Status == "1")
|
{
|
sqlString = $"select count(id) from DataStockDetail where PalletNo = '{palletNo}' and isnull(LocatNo,'') != '' and isdel = '0';";
|
int rowNum = Db.Ado.GetInt(sqlString);
|
if (rowNum > 0)
|
{
|
sqlMsg = "-1:托盘使用中，此托盘应在库内请核实!";
|
}
|
}
|
}
|
else
|
{
|
sqlMsg = "-1:托盘号不存在!";
|
}
|
|
return sqlMsg;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
// 根据箱码或托盘号获取箱支信息 liudl
|
public List<BoxInfoDto> GetBoxInfos(BoxInfoVm model)
|
{
|
try
|
{
|
var sqlString = "select BoxNo, SkuNo,SkuName, LotNo, SUM(Qty) as Qty from BllBoxInfo where IsDel = '0' ";
|
if (!string.IsNullOrEmpty(model.PalletNo))
|
{
|
sqlString += $"and PalletNo = '{model.PalletNo}' and Status = '1' ";
|
}
|
if (!string.IsNullOrEmpty(model.BoxNo))
|
{
|
sqlString += $"and BoxNo = '{model.BoxNo}' and Status in ('0','1') ";
|
}
|
sqlString += $"group by BoxNo,SkuNo,SkuName,LotNo; ";
|
var models = Db.Ado.SqlQuery<BoxInfoDto>(sqlString);
|
|
return models;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
// 绑定物料托盘
|
public void BindPallet(PdaPalletBindVm model, int userId)
|
{
|
try
|
{
|
#region 判断
|
|
if (string.IsNullOrEmpty(model.AsnNo))
|
{
|
throw new Exception("-1:单据号不可为空!");
|
}
|
if (model.AsnDetailId == null || model.AsnDetailId == 0)
|
{
|
throw new Exception("-1:物料不可为空!");
|
}
|
if (string.IsNullOrEmpty(model.PalletNo))
|
{
|
throw new Exception("-1:托盘号不可为空!");
|
}
|
if (string.IsNullOrEmpty(model.BoxNo))
|
{
|
throw new Exception("-1:物料数量不可为空!");
|
}
|
|
if (model.IsContinue == "1")
|
{
|
if (string.IsNullOrWhiteSpace(model.TailBoxNo))
|
{
|
throw new Exception("-1:开启连续组托时，尾箱码信息不可为空!");
|
}
|
|
}
|
#endregion
|
|
Db.BeginTran();
|
|
//托盘是否存在
|
var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
|
if (pallet == null)
|
{
|
throw new Exception("未查询到托盘信息，请核实！");
|
}
|
// 验证入库单明细是否存在
|
var detail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.Id == model.AsnDetailId && m.ASNNo == model.AsnNo);
|
if (detail == null)
|
{
|
throw new Exception("-1:当前物料及批次与单据无关联，请核实!");
|
}
|
#region 包装
|
var package = Db.Queryable<SysPackag>().Where(m => m.IsDel == "0");
|
var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == detail.SkuNo);
|
var pack = package.First(m => m.IsDel == "0" && m.PackagNo == sku.PackagNo);
|
var pNum = 0;//托盘物品数量
|
var bNum = 0;//箱码物品数量
|
if (pack.L5Num.HasValue)
|
{
|
pNum = (int)pack.L5Num;
|
bNum = (int)pack.L4Num;
|
}
|
else if (pack.L4Num.HasValue)
|
{
|
pNum = (int)pack.L4Num;
|
bNum = (int)pack.L3Num;
|
}
|
else if (pack.L3Num.HasValue)
|
{
|
pNum = (int)pack.L3Num;
|
bNum = (int)pack.L2Num;
|
}
|
else if (pack.L2Num.HasValue)
|
{
|
pNum = (int)pack.L2Num;
|
bNum = (int)pack.L1Num;
|
}
|
else if (pack.L1Num.HasValue)
|
{
|
pNum = (int)pack.L1Num;
|
bNum = (int)pack.L1Num;
|
}
|
if (pNum == 0 || bNum == 0)
|
{
|
throw new Exception($"绑定失败，{detail.SkuNo}物品包装未找到！");
|
}
|
|
var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == model.AsnDetailId && m.PalletNo == model.PalletNo);
|
|
var bindId = 0;
|
if (bind == null)
|
{
|
bind = new BllPalletBind
|
{
|
ASNNo = model.AsnNo,
|
ASNDetailNo = (int)model.AsnDetailId,
|
PalletNo = model.PalletNo,
|
PalletNo2 = "",
|
PalletNo3 = "",
|
Qty = int.Parse(model.BoxNo),
|
FullQty = pNum,
|
Status = "0",
|
Type = "0",
|
LotNo = detail.LotNo,
|
LotText = detail.LotText,
|
SupplierLot = detail.SupplierLot,
|
InspectMark = "1",
|
BitPalletMark = pNum == int.Parse(model.BoxNo) ? "0" : "1",
|
IsBale = "0",
|
IsBelt = "0",
|
CreateUser = userId
|
};
|
// 插入托盘绑定表
|
bindId = Db.Insertable(bind).ExecuteReturnIdentity();
|
}
|
else
|
{
|
if (bind.Status != "0")
|
{
|
throw new Exception("-1:当前托盘正在执行中，绑定失败，请核实!");
|
}
|
bindId = bind.Id;
|
}
|
|
#region 箱码信息
|
var boxInfoList = new List<BllBoxInfo>();
|
//首箱
|
var boxInfo = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BoxNo == model.BoxNo && m.Status == "0").ToList();
|
if (boxInfo.Count == 0)
|
{
|
throw new Exception("-1:箱码信息不存在!");
|
}
|
boxInfoList.AddRange(boxInfo);
|
//是否连续组托
|
if (model.IsContinue == "1")
|
{
|
//尾箱
|
var boxInfo2 = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BoxNo == model.TailBoxNo).ToList();
|
if (boxInfo2.Count == 0)
|
{
|
throw new Exception("-1:尾箱码信息不存在!");
|
}
|
boxInfoList.AddRange(boxInfo2);
|
var sql = $"select * from BllBoxInfo where IsDel = '0' and boxNo>'{model.BoxNo}' and boxNo<'{model.TailBoxNo}'; ";
|
var list = Db.Ado.SqlQuery<BllBoxInfo>(sql);
|
boxInfoList.AddRange(list);
|
}
|
#endregion
|
|
|
|
|
#endregion
|
// 更改箱支关系表
|
var factQty = 0;//托盘总数量
|
var boxGroup = boxInfoList.GroupBy(m => m.BoxNo).ToList();
|
foreach (var g in boxGroup)
|
{
|
var boxFullQty = 0;//箱内总数量
|
foreach (var box in g)
|
{
|
if (box.BindNo != null && box.BindNo != 0)
|
{
|
continue;
|
}
|
//箱内物料批次与单据明细不符合
|
if (box.SkuNo != detail.SkuNo || box.LotNo != detail.LotNo)
|
{
|
throw new Exception($"-1:{box.BoxNo}箱内物料及批次与单据不一致，请核实!");
|
}
|
|
box.ASNNo = model.AsnNo;
|
box.ASNDetailNo = model.AsnDetailId;
|
box.BindNo = bindId;
|
box.PalletNo = model.PalletNo;
|
box.Status = "1";
|
box.CompleteTime = DateTime.Now;
|
box.UpdateTime = DateTime.Now;
|
box.UpdateUser = userId;
|
|
factQty += box.Qty;
|
boxFullQty += box.Qty;
|
}
|
if (boxFullQty > bNum)
|
{
|
throw new Exception($"绑定失败，{g.Key}箱码绑定数量大于该物品包装数量！");
|
}
|
}
|
Db.Updateable(boxInfoList).ExecuteCommand();
|
|
// 更新托盘绑定表
|
bind.Qty += factQty;
|
if (bind.FullQty < bind.Qty)
|
{
|
throw new Exception("托盘绑定数量已超出该物料包装数量");
|
}
|
|
if (bind.FullQty == bind.Qty)
|
{
|
bind.BitPalletMark = "1";
|
}
|
Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand();
|
|
// 更改入库单明细已组数量
|
var sqlString = string.Empty;
|
sqlString += $"update BllArrivalNoticeDetail set FactQty = FactQty + '{factQty}' where id = '{model.AsnDetailId}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
|
// 更改入库单及入库明细状态
|
if (detail.Status == "0")
|
{
|
var sqlString2 = string.Empty;
|
sqlString2 += $"update BllArrivalNotice set Status = '1',CompleteTime= getDate() where ASNNo = '{model.AsnNo}' and Status ='0';";
|
sqlString2 += $"update BllArrivalNoticeDetail set Status = '1',CompleteTime= getDate() where id = '{model.AsnDetailId}' and Status ='0';";
|
Db.Ado.ExecuteCommand(sqlString2);
|
}
|
|
// 更改托盘使用状态
|
var sqlStr = $"update SysPallets set Status = '1' where PalletNo = '{model.PalletNo}';";
|
//添加托盘记录表数据
|
sqlStr += $"insert into LogPalletTrack values('{model.PalletNo}','{model.AsnNo}','组盘','0',getDate(),{userId},NULL,NULL);";
|
Db.Ado.ExecuteCommand(sqlStr);
|
Db.CommitTran();
|
|
}
|
catch (Exception ex)
|
{
|
Db.Ado.RollbackTran();
|
throw ex;
|
}
|
}
|
|
// 绑定空托盘
|
public string BindNullPallet(PalletBindVm model)
|
{
|
string strMsg = "";
|
try
|
{
|
if (string.IsNullOrEmpty(model.PalletNo))
|
{
|
strMsg = "-1:托盘号不可为空!";
|
return strMsg;
|
}
|
if (model.Qty == null || model.Qty == 0)
|
{
|
strMsg = "-1:空托盘数量不可为空!";
|
return strMsg;
|
}
|
|
Db.BeginTran();
|
// 插入托盘绑定表
|
var modelpb = new BllPalletBind
|
{
|
PalletNo = model.PalletNo,
|
PalletNo2 = model.PalletNo2,
|
PalletNo3 = model.PalletNo3,
|
Qty = (int)model.Qty,
|
FullQty = model.FullQty,
|
Status = "0",
|
Type = "1",
|
LotNo = model.LotNo,
|
LotText = model.LotText,
|
SupplierLot = model.SupplierLot,
|
InspectMark = model.InspectMark,
|
BitPalletMark = model.BitPalletMark,
|
IsBale = model.IsBale,
|
IsBelt = model.IsBelt,
|
CreateUser = (int)model.CreateUser,
|
CreateTime = Db.GetDate()
|
};
|
Db.Insertable(modelpb).ExecuteCommand();
|
|
// 更改托盘使用状态
|
string sqlStr = string.Empty;
|
sqlStr = $"update SysPallets set Status = '1' where PalletNo = '{model.PalletNo}';";
|
Db.Ado.ExecuteCommand(sqlStr);
|
Db.CommitTran();
|
|
return strMsg;
|
}
|
catch (Exception ex)
|
{
|
Db.Ado.RollbackTran();
|
throw ex;
|
}
|
}
|
|
// 删除已组信息
|
public string DelBoxInfo(BoxInfoVm model)
|
{
|
string strMsg = "";
|
string sqlString = string.Empty;
|
try
|
{
|
if (model.Id == null || model.Id == 0)
|
{
|
strMsg = "-1:箱支ID不可为空!";
|
return strMsg;
|
}
|
|
// 获取箱支信息和托盘状态（已组未入库的可删除；入库成功又出库的不可删除）
|
sqlString = $"select * from BllBoxInfo where id = '{model.Id}' and Status='1' and isdel = '0';";
|
var boxModel = Db.Ado.SqlQuery<BoxInfoDto>(sqlString);
|
if (boxModel.Count <= 0)
|
{
|
strMsg = "-1:箱支信息状态已变更或已存在库存信息，请检查!";
|
}
|
|
// 查询托盘上其他物料数量
|
sqlString = string.Empty;
|
sqlString += $"select count(id) from BllBoxInfo where PalletNo = '{boxModel[0].PalletNo}' and isdel = '0' and id != '{model.Id}';";
|
int rowNum = Db.Ado.GetInt(sqlString);
|
|
// 查询入库单明细是否有其他托盘绑定信息
|
sqlString = string.Empty;
|
sqlString += $"select count(id) from BllBoxInfo where ASNDetailNo = '{boxModel[0].ASNDetailNo}' and isdel = '0' and id != '{model.Id}';";
|
int asnDetailNum = Db.Ado.GetInt(sqlString);
|
|
// 查询入库单明细是否有其他托盘绑定信息
|
sqlString = string.Empty;
|
sqlString += $"select count(id) from BllBoxInfo where ASNNo = '{boxModel[0].ASNNo}' and isdel = '0' and id != '{model.Id}';";
|
int asnNum = Db.Ado.GetInt(sqlString);
|
|
Db.BeginTran();
|
// 解除箱支和托盘的关联
|
sqlString = string.Empty;
|
sqlString = $"Update BllBoxInfo set ASNNo = '',ASNDetailNo='',BindNo = '',PalletNo='' ";
|
sqlString += $",UpdateTime=GETDATE(),UpdateUser='{model.CreateUser} where id = '{model.Id}';";
|
|
// 判断托盘上是否还有物料 无:删除绑定的托盘信息并更改托盘状态
|
if (rowNum <= 0)
|
{
|
// 删除托盘绑定信息
|
sqlString = string.Empty;
|
sqlString = $"Update BllPalletBind set IsDel = '1' where id = '{model.Id}';";
|
|
|
// 判断入库单明细是否存在其他已组托盘的
|
if (asnDetailNum <= 0)
|
{
|
// 更改入库单明细状态
|
sqlString = string.Empty;
|
sqlString += $"update BllArrivalNoticeDetail set FactQty = FactQty - '{boxModel[0].Qty}',Status = '0', ";
|
sqlString += $"CompleteTime=GETDATE() where id = '{boxModel[0].ASNDetailNo}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
|
// 判断入库单是否有其他组托信息
|
if (asnNum <= 0)
|
{
|
// 更改入库单状态
|
sqlString = string.Empty;
|
sqlString += $"update BllArrivalNotice set Status = '0',CompleteTime=GETDATE() where ASNNo = '{boxModel[0].ASNNo}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
}
|
}
|
|
// 更改托盘状态
|
sqlString = string.Empty;
|
sqlString = $"update SysPallets set Status = '0' where PalletNo = '{boxModel[0].PalletNo}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
}
|
|
Db.CommitTran();
|
return strMsg;
|
}
|
catch (Exception ex)
|
{
|
Db.RollbackTran();
|
throw ex;
|
}
|
}
|
|
// 平库完成入库操作
|
public string CompleteInStock(PalletBindVm model)
|
{
|
string strMsg = "";
|
string sqlString = string.Empty;
|
try
|
{
|
DateTime serverTime = Db.Ado.GetDateTime("select GETDATE();");
|
// 验证托盘信息
|
sqlString += $"select tb1.*,tb2.Standard,tb2.SkuNo,tb2.SkuName,tb2.PackagNo from BllPalletBind as tb1 ";
|
sqlString += "left join SysMaterials as tb2 on tb1.SkuNo = tb2.SkuNo ";
|
sqlString += $"where PalletNo = '{model.PalletNo}' and tb1.isdel = '0' and tb1.Status='0';";
|
var bindModels = Db.Ado.SqlQuery<PalletBindVm>(sqlString);
|
if (bindModels.Count <= 0)
|
{
|
strMsg = "-1:托盘状态变更，请检查!";
|
return strMsg;
|
}
|
// 验证储位状态
|
var locatModel = Db.Queryable<SysStorageLocat>()
|
.First(it => it.LocatNo == model.LocatNo && it.Status == "0" && it.Flag == "0" && it.IsDel == "0");
|
if (locatModel == null)
|
{
|
strMsg = "-1:储位不可用，请检查储位状态!";
|
return strMsg;
|
}
|
|
Db.BeginTran();
|
// 改变储位状态; 有货物
|
sqlString = $"Update SysStorageLocat set Status = '1' where LocatNo = '{model.LocatNo}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
|
// 改变箱支关系表状态：已入库
|
sqlString = "Update BllBoxInfo set Status = '2' where PalletNo = '{model.PalletNo}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
|
// 改变托盘绑定表状态：已入库 完成时间：当前时间
|
sqlString = "Update BllPalletBind set Status = '2',CompleteTime=GETDATE() where PalletNo = '{model.PalletNo}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
|
// 改变入库明细表状态：若完成数量和数量相等：执行完成 不相等：正在执行；
|
foreach (PalletBindVm bindModel in bindModels)
|
{
|
// 判断入库明细是否完成
|
sqlString = $"select count(id) from BllArrivalNoticeDetail where isdel = '0' ";
|
sqlString += $"and Qty = CompleteQty + {bindModel.Qty} and id = '{bindModel.ASNDetailNo}';";
|
int detailNum = Db.Ado.GetInt(sqlString);
|
if (detailNum > 0)
|
{
|
// 改变入库单明细状态和完成时间
|
sqlString = $"Update BllArrivalNoticeDetail set Status = '2',CompleteTime=GETDATE() ";
|
sqlString += $"where id = '{bindModel.ASNDetailNo}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
|
// 判断入库单总表是否完成
|
sqlString = $"select count(id) from BllArrivalNoticeDetail where isdel = '0' and Status != '2' ";
|
sqlString += $"and ASNNo = '{bindModel.ASNNo}' and id !='{bindModel.ASNDetailNo}';";
|
int asnNum = Db.Ado.GetInt(sqlString);
|
if (detailNum <= 0)
|
{
|
// 改变入库单状态和完成时间 若入库明细表所有状态为执行完毕：执行完毕 否：正在执行；
|
sqlString = $"Update BllArrivalNotice set Status = '2',CompleteTime=GETDATE() ";
|
sqlString += $"where ASNNo = '{bindModel.ASNNo}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
}
|
}
|
|
#region 库存总表
|
// 判断当前物料库存表是否已存在
|
var stockModel = Db.Queryable<DataStock>()
|
.First(it => it.SkuNo == bindModel.SkuNo && it.LotNo == bindModel.LotNo
|
&& it.Standard == bindModel.Standard && it.SupplierLot == bindModel.SupplierLot && it.IsDel == "0");
|
|
if (stockModel == null || stockModel.Id == 0)
|
{
|
stockModel = new DataStock
|
{
|
LotNo = bindModel.LotNo,
|
LotText = bindModel.LotText,
|
SupplierLot = bindModel.SupplierLot,
|
SkuNo = bindModel.SkuNo,
|
SkuName = bindModel.SkuName,
|
Qty = (int)bindModel.Qty,
|
Standard = bindModel.Standard,
|
CreateUser = (int)model.CreateUser
|
};
|
Db.Insertable<DataStock>(stockModel).ExecuteCommand();
|
}
|
else
|
{
|
sqlString = $"update DataStock set Qty = Qty + {bindModel.Qty}," +
|
$"UpdateTime = GETDATE(),UpdateUser='{model.CreateUser}' where id = '{stockModel.Id}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
}
|
#endregion
|
|
#region 库存明细表
|
// 判断当前托盘是否已存在（拣货回库托盘）
|
var detailModel = Db.Queryable<DataStockDetail>()
|
.First(it => it.PalletNo == bindModel.PalletNo && it.LotNo == bindModel.LotNo && it.SkuNo == bindModel.SkuNo
|
&& it.Standard == bindModel.Standard && it.SupplierLot == bindModel.SupplierLot && it.IsDel == "0");
|
if (detailModel == null || detailModel.Id == 0)
|
{
|
// 获取可抽检数量
|
sqlString = "select sum(qty) from BllBoxInfo where isdel = 0 and ";
|
sqlString += $"BindNo = '{bindModel.Id}' and BitBoxMark = '1';";
|
int inspectQty = Db.Ado.GetInt(sqlString);
|
|
// 添加库存明细表
|
detailModel = new DataStockDetail()
|
{
|
LotNo = bindModel.LotNo,
|
LotText = bindModel.LotText,
|
SupplierLot = bindModel.SupplierLot,
|
SkuNo = bindModel.SkuNo,
|
SkuName = bindModel.SkuName,
|
Standard = bindModel.Standard,
|
Qty = bindModel.Qty,
|
InspectQty = inspectQty,
|
ASNNo = bindModel.ASNNo,
|
ASNDetailNo = (int)bindModel.ASNDetailNo,
|
WareHouseNo = locatModel.WareHouseNo,
|
RoadwayNo = locatModel.RoadwayNo,
|
AreaNo = locatModel.AreaNo,
|
LocatNo = model.LocatNo,
|
PalletNo = model.PalletNo,
|
PalletNo2 = bindModel.PalletNo2,
|
PalletNo3 = bindModel.PalletNo3,
|
CompleteTime = serverTime,
|
ProductionTime = bindModel.ProductionTime,
|
ExpirationTime = bindModel.ExpirationTime,
|
Status = "0",
|
InspectMark = bindModel.InspectMark,
|
BitPalletMark = bindModel.BitPalletMark,
|
InspectStatus = bindModel.InspectMark, // 组盘的时候就要默认设定好是否合格
|
PackagNo = bindModel.PackagNo,
|
IsBale = bindModel.IsBale,
|
IsBelt = bindModel.IsBelt,
|
CreateUser = (int)model.CreateUser
|
};
|
|
Db.Insertable<DataStockDetail>(detailModel).ExecuteCommand();
|
}
|
else
|
{
|
detailModel.LocatNo = model.LocatNo;
|
detailModel.UpdateTime = serverTime;
|
detailModel.UpdateUser = (int)model.CreateUser;
|
// 变更储位地址
|
Db.Updateable<DataStockDetail>(detailModel).UpdateColumns(it => new { it.LocatNo, it.UpdateTime, it.UpdateUser }).ExecuteCommand();
|
}
|
#endregion
|
|
#region 库存箱支明细表
|
// 插入新组的箱支信息
|
sqlString = $"insert into DataBoxInfo ";
|
sqlString += "select BindNo,BoxNo,BoxNo2,BoxNo3,PalletNo,PalletNo2,PalletNo3, ";
|
sqlString += "Qty,FullQty,'0' as Status,LotNo,LotText,ProductionTime,SupplierLot,";
|
sqlString += "InspectMark,BitBoxMark,InspectStatus ";
|
sqlString += $"from BllBoxInfo where isdel = 0 and Status='1' and BindNo = '{bindModel.Id}';";
|
Db.Ado.ExecuteCommand(sqlString);
|
#endregion
|
}
|
|
Db.CommitTran();
|
|
return strMsg;
|
}
|
catch (Exception ex)
|
{
|
Db.RollbackTran();
|
throw ex;
|
}
|
}
|
|
}
|
}
|
