Files

2009 lines
107 KiB
C#
Executable File

using Microsoft.Extensions.DependencyInjection;
using Opsoft.Data;
using Opsoft.NetCore.O3App.Domain.Interface;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.WMS.IRepositories;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.WMS.Model;
using Opsoft.NetCore.O3App.Shared;
using Opsoft.NetCore.O3App.Shared.Utils;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Tasks;
namespace Opsoft.NetCore.O3App.Repositories.WMS
{
/// <summary>
/// 委外领料/委外退料
/// </summary>
[MapTo(typeof(ISUBPICKMTRLRepository), ServiceLifetime.Transient)]
public class SUBPICKMTRLRepository : RepositoryBase<BaseEntity>, ISUBPICKMTRLRepository
{
public SUBPICKMTRLRepository() : base()
{
}
/// <summary>
/// 委外领料
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public async Task<RetMessage> SUBPICKMTRL(InputBarCode<BD_BARCODERS2> request, List<BOS_SELBILL> selBillList)
{
string billTypeID = request.billTypeID;
RetMessage jsonRet = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
#region 初始化
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
string strSQL = string.Empty;
List<BarCodeMsg<BD_BARCODERS2>> barcodeEntry1 = new List<BarCodeMsg<BD_BARCODERS2>>();//条码原始扫描信息
List<BarCodeMsg<BD_BARCODERS2>> barcodeEntry2 = new List<BarCodeMsg<BD_BARCODERS2>>();//箱码最底阶信息
request.barcodeList.ForEach(o =>
{
o.FSRCINFO ??= new BD_BARCODERS2();
//箱码最底阶信息
if (o.FISBOX == 1)
{
if (o.FBOXINFO != null && o.FBOXINFO.Count > 0)
{
//装箱底阶明细,提交的仓库仓位重新赋值
o.FBOXINFO.ForEach(x =>
{
x.FSRCINFO ??= new BD_BARCODERS2();
x.FISBOX = 1;
x.FID = o.FID;
x.FSUPPLYID = o.FSUPPLYID;
x.FDEPTID = o.FDEPTID;
x.FCUSTID = o.FCUSTID;
x.FSTOCKID = o.FSTOCKID;
x.FSTOCKLOCID = o.FSTOCKLOCID;
});
}
barcodeEntry2.AddRange(o.FBOXINFO);
}
else
{
barcodeEntry2.Add(o);
}
//条码原始扫描信息
barcodeEntry1.Add(o);
});
#endregion
#region 校验条码状态,若箱码需查询最底阶信息
foreach (var sub in barcodeEntry1)
{
DataTable dtCusor = context.Database.SqlQuery($@"SELECT
S.FDELETED
,S.FBARTYPE
,S.FINBOX--被装箱
,S.FISBOX--箱码
,S.FQTY--数量
,S.FBARCODESTATUS
,S.FSTOCKSTATUS
FROM T_BD_BARCODERS S
WHERE FBARCODE='{sub.FBARCODE}'");
dtCusor.CaseSensitive = false;
if (dtCusor == null || dtCusor.Rows.Count <= 0)
{
jsonRet.Message = string.Format("条码【{0}】信息未找到!", sub.FBARCODE);
return jsonRet;
}
if (dtCusor.Rows.Count > 1)
{
jsonRet.Message = string.Format("条码【{0}】信息存在多条记录!", sub.FBARCODE);
return jsonRet;
}
DataRow selectDr = dtCusor.Rows[0];
if (selectDr["FDELETED"].ToBoolean())
{
jsonRet.Message = string.Format("条码【{0}】已禁用!", sub.FBARCODE);
return jsonRet;
}
if (selectDr["FBARTYPE"].ToInt() < 3)
{
if (selectDr["FINBOX"].ToBoolean())
{
jsonRet.Message = string.Format("条码【{0}】不符规则,原因:已入箱!", sub.FBARCODE);
return jsonRet;
}
string errorMsg = CheckBill.CheckBarCodeStatus(request.TranType, selectDr["FSTOCKSTATUS"].ToInt(), sub.FBARCODE);
if (!string.IsNullOrEmpty(errorMsg))
{
jsonRet.Message = errorMsg;
return jsonRet;
}
}
}
#endregion
#region 按源单信息汇总
#region 定义中间表字典库
Dictionary<string, HEAD> dicHead = new Dictionary<string, HEAD>();
Dictionary<string, List<BarCodeMsg<BD_BARCODERS2>>> dicEntry2 = new Dictionary<string, List<BarCodeMsg<BD_BARCODERS2>>>();
#endregion
#region 无源单信息,按供应商汇总
var notSoureGroups = request.barcodeList.Where(o => o.FSRCFORMID.IsNullOrWhiteSpace() == true).GroupBy(o => new
{
o.FSRCFORMID,
o.FSRCBILLNO,
o.FSUPPLYID
}).ToList();
foreach (var sub in notSoureGroups)
{
BOS_SELBILL selBill = selBillList.FirstOrDefault(o => o.FSRCFORMID == sub.Key.FSRCFORMID);
jsonRet.Message = GetBillType(sub.Key.FSRCFORMID, string.Empty, selBillList, out billTypeID);
if (!string.IsNullOrEmpty(jsonRet.Message))
{
return jsonRet;
}
string newID = Guid.NewGuid().ToString();
dicHead.Add(newID, new HEAD
{
FBILLTYPEID = billTypeID,
FINTERID = newID,
FSUPPLYID = sub.Key.FSUPPLYID,
FTRANTYPE = request.TranType,
FSRCFORMID = sub.Key.FSRCFORMID,
FSRCBILLNO = sub.Key.FSRCBILLNO,
FCOMPANYID = request.orgID,
FISSYNTOERP = selBill.FCANSYNERP,
FISNOWSYNERP = selBill.FCHECKERPSTOCK
});
List<BarCodeMsg<BD_BARCODERS2>> notSourceEntry2 = new List<BarCodeMsg<BD_BARCODERS2>>();
notSourceEntry2.AddRange(barcodeEntry2.Where(o => o.FSRCFORMID.ToStringEx() == sub.Key.FSRCFORMID &&
o.FSRCBILLNO.ToStringEx() == sub.Key.FSRCBILLNO &&
o.FSUPPLYID == sub.Key.FSUPPLYID).ToList());
notSourceEntry2.ForEach(o =>
{
o.FSRCFORMID = string.Empty;
o.FSRCID = string.Empty;
o.FSRCENTRYID = 0;
o.FSRCDETAILID = string.Empty;
o.FSRCBILLNO = string.Empty;
o.FSRCINFO.FMOID = string.Empty;
o.FSRCINFO.FMOENTRYID = 0;
o.FSRCINFO.FMOBILLNO = string.Empty;
o.FSRCINFO.FMODETAILID = string.Empty;
o.FSRCINFO.FPPBOMID = string.Empty;
o.FSRCINFO.FPPBOMBILLNO = string.Empty;
o.FSRCINFO.FPPBOMENTRYID = 0;
o.FSRCINFO.FPPBOMDETAILID = string.Empty;
});
//条码最底阶中间表
dicEntry2.Add(newID, notSourceEntry2);
}
#endregion
#region 有源单,按物料类别汇总
List<BarCodeMsg<BD_BARCODERS2>> myInBillList = barcodeEntry2.Select(o => new BarCodeMsg<BD_BARCODERS2>()
{
FUSEFULDATE = o.FUSEFULDATE,
FSTOCKSTATUSID = o.FSTOCKSTATUSID,
FSUPPLYID = o.FSUPPLYID,
FISBOX = o.FISBOX,
FBOXBARCODE = o.FBOXBARCODE,
FBARCODE = o.FBARCODE,
FBARTYPE = o.FBARTYPE,
FMATERIALID = o.FMATERIALID,
FITEMNUMBER = o.FITEMNUMBER,
FKFDATE = o.FKFDATE,
FKFPERIOD = o.FKFPERIOD,
FSTOCKID = o.FSTOCKID,
FSTOCKLOCID = o.FSTOCKLOCID,
FUNITID = o.FUNITID,
FBASEUNITID = o.FBASEUNITID,
FLOT = o.FLOT,
FAUXPROPID = o.FAUXPROPID,
FQTY = o.FQTY,
FBASEQTY = o.FBASEQTY,
FSECUNITID = o.FSECUNITID,
FSECUNITQTY = o.FSECUNITQTY,
FSRCFORMID = o.FSRCFORMID,
FSRCBILLNO = o.FSRCBILLNO,
FSRCINFO = o.FSRCINFO,
FKEEPERID = o.FKEEPERID,
FKEEPERTYPEID = o.FKEEPERTYPEID,
FOWNERID = o.FOWNERID,
FOWNERTYPEID = o.FOWNERTYPEID
}).ToList();
var haveSourceGroups = barcodeEntry2.Where(o => o.FSRCFORMID.IsNullOrWhiteSpace() != true).GroupBy(o =>
new
{
o.FSRCFORMID,
o.FSRCBILLNO,
o.FSRCENTRYID,
o.FSUPPLYID
}).ToList();
foreach (var sub in haveSourceGroups)
{
#region 查询源单信息
BOS_SELBILL selBill = selBillList.FirstOrDefault(o => o.FSRCFORMID == sub.Key.FSRCFORMID);
if (selBill == null)
{
jsonRet.Message = "委外领料异常:" + "源单【" + sub.Key.FSRCBILLNO + "】出入库流程单据信息未找到!";
return jsonRet;
}
string tempSQL = CheckBill.GetSoureBillData(request.orgID, request.TranType, selBill.FSRCFORMID, sub.Key.FSRCBILLNO, sub.Key.FSRCENTRYID);
if (tempSQL.IsNullOrWhiteSpace())
{
jsonRet.Message = "委外领料异常:" + "源单【" + sub.Key.FSRCBILLNO + "】查询信息未设置!";
return jsonRet;
}
string FCOMPANYID = string.Empty;
List<SOURCEBILLINFO> hisSourceBill = context.Database.SqlQuery<SOURCEBILLINFO>(tempSQL);
if (hisSourceBill == null || hisSourceBill.Count <= 0)
{
jsonRet.Message = "委外领料异常:" + "源单【" + sub.Key.FSRCBILLNO + "】中信息未找到!";
return jsonRet;
}
else if (hisSourceBill.All(o => o.FBASEREMINANQTY <= 0))
{
jsonRet.Message = "委外领料异常:" + "源单【" + sub.Key.FSRCBILLNO + "】中可领料数量小于等于零!";
return jsonRet;
}
else
{
if (request.orgID.IsNullOrEmpty())
{
FCOMPANYID = hisSourceBill[0].FCOMPANYID;
}
else
{
FCOMPANYID = request.orgID;
}
}
#endregion
#region 查询源单单据类型
jsonRet.Message = GetBillType(sub.Key.FSRCFORMID, hisSourceBill.First().FBILLTYPEID, selBillList, out billTypeID);
if (!string.IsNullOrEmpty(jsonRet.Message))
{
return jsonRet;
}
#endregion
#region 按物料、批号、辅助属性、保质日期分组
var barcodeGroups = barcodeEntry2
.Where(b =>
b.FSRCFORMID == sub.Key.FSRCFORMID &&
b.FSRCBILLNO == sub.Key.FSRCBILLNO &&
b.FSRCENTRYID == sub.Key.FSRCENTRYID &&
b.FSUPPLYID == sub.Key.FSUPPLYID)
.GroupBy(b => new
{
b.FMATERIALID,
b.FITEMNUMBER,
b.FLOT,
b.FAUXPROPID,
b.FKFDATE
});
List<TargetGroup> myTargetGroups = new List<TargetGroup>();
foreach (var bill in barcodeGroups)
{
myTargetGroups.Add(new TargetGroup
{
FMATERIALID = bill.Key.FMATERIALID,
FITEMNUMBER = bill.Key.FITEMNUMBER,
FLOT = bill.Key.FLOT,
FAUXPROPID = bill.Key.FAUXPROPID,
FKFDATE = bill.Key.FKFDATE
});
}
if (!selBill.FISCHECKLOT)
{
myTargetGroups.ForEach(o => o.FLOT = string.Empty);
}
if (!selBill.FISCHECKAUX)
{
myTargetGroups.ForEach(o => o.FAUXPROPID = string.Empty);
}
if (!selBill.FISCHECKKFDATE)
{
myTargetGroups.ForEach(o => o.FKFDATE = string.Empty);
}
var myBillGroups = myTargetGroups.GroupBy(o => new
{
o.FMATERIALID,
o.FITEMNUMBER,
o.FLOT,
o.FAUXPROPID,
o.FKFDATE
});
List<BarCodeMsg<BD_BARCODERS2>> itemList = new List<BarCodeMsg<BD_BARCODERS2>>();
foreach (var bill in myBillGroups)
{
#region 判断源单中批次、辅助属性、保质期、数量是否满足要求
List<SOURCEBILLINFO> hisList = hisSourceBill
.Where(o => o.FMATERIALID.Equals(bill.Key.FMATERIALID))
.OrderBy(o => o.FSRCENTRYID)
.ToList();
List<BarCodeMsg<BD_BARCODERS2>> barList = ObjectExtensions.CreateDeepCopy(myInBillList
.Where(o =>
o.FSRCFORMID.Equals(sub.Key.FSRCFORMID) &&
o.FSRCBILLNO.Equals(sub.Key.FSRCBILLNO) &&
o.FMATERIALID.Equals(bill.Key.FMATERIALID)).ToList());
if (selBill.FISCHECKLOT)
{
hisList = hisList.Where(o => o.FLOT.Equals(bill.Key.FLOT)).ToList();
if (hisList == null || hisList.Count <= 0)
{
jsonRet.Message = "委外领料异常:" + "源单【" + sub.Key.FSRCBILLNO + "】中物料【" + bill.Key.FITEMNUMBER + "】,批次【" + bill.Key.FLOT + "】信息未找到!";
return jsonRet;
}
barList = barList.Where(o => o.FLOT.Equals(bill.Key.FLOT)).ToList();
}
if (selBill.FISCHECKAUX)
{
hisList = hisList.Where(o => o.FAUXPROPID.IsNullOrEmpty() || (!o.FAUXPROPID.IsNullOrEmpty() && o.FAUXPROPID.Equals(bill.Key.FAUXPROPID))).ToList();
if (hisList == null || hisList.Count <= 0)
{
jsonRet.Message = "委外领料异常:" + "源单【" + sub.Key.FSRCBILLNO + "】中物料【" + bill.Key.FITEMNUMBER + "】,辅助属性【" + bill.Key.FAUXPROPID + "】信息未找到!";
return jsonRet;
}
barList = barList.Where(o => o.FAUXPROPID.Equals(bill.Key.FAUXPROPID)).ToList();
}
if (selBill.FISCHECKKFDATE)
{
hisList = hisList.Where(o => o.FKFPERIOD == 0 || (o.FKFPERIOD > 0 && !o.FKFDATE.IsNullOrEmpty() && CheckDateTime.CompareTime(o.FKFDATE, bill.Key.FKFDATE) == 0)).ToList();
if (hisList == null || hisList.Count <= 0)
{
jsonRet.Message = "委外领料异常:" + "源单【" + sub.Key.FSRCBILLNO + "】中物料【" + bill.Key.FITEMNUMBER + "】,保质日期【" + bill.Key.FKFDATE + "】信息未找到!";
return jsonRet;
}
barList = barList.Where(o => o.FKFDATE.Equals(bill.Key.FKFDATE)).ToList();
}
if (selBill.FISCONTROLQTY)
{
if (barList.Sum(o => o.FBASEQTY) > hisList.Sum(o => o.FBASEREMINANQTY))
{
jsonRet.Message = "委外领料异常:" + "源单【" + sub.Key.FSRCBILLNO + "】中物料【" + bill.Key.FITEMNUMBER + "】,扫描数量【" + barList.Sum(o => o.FBASEQTY) + "】>可领料数量【" + hisList.Sum(o => o.FBASEREMINANQTY) + "】!";
return jsonRet;
}
}
#endregion
#region 遍历当前源单的出库信息,产生物料中间表
List<BarCodeMsg<BD_BARCODERS2>> newList = new List<BarCodeMsg<BD_BARCODERS2>>();
foreach (var inputMtrl in barList)
{
//找源单中是否有存在这个行号的数据,如果有,优先用这个行号的数据
decimal tempQty = inputMtrl.FBASEQTY;
bool isScan = true;
for (int i = 0; i < hisList.Count && tempQty > 0; i++)
{
decimal remainQty = hisList[i].FBASEREMINANQTY;
if (remainQty <= 0 && selBill.FISCONTROLQTY)
{
continue;
}
if (remainQty >= tempQty)
{
//源单数量充足
hisList[i].FBASEREMINANQTY = remainQty - tempQty;
if (isScan)
{
isScan = false;
inputMtrl.FBASEQTY = tempQty;
inputMtrl.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, tempQty);
inputMtrl.FSRCID = hisList[i].FSRCID;
inputMtrl.FSRCENTRYID = hisList[i].FSRCENTRYID;
inputMtrl.FSRCDETAILID = hisList[i].FSRCDETAILID;
inputMtrl.FSRCBILLNO = hisList[i].FSRCBILLNO;
inputMtrl.FSRCINFO.FMOID = hisList[i].FMOID;
inputMtrl.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
inputMtrl.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
inputMtrl.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
inputMtrl.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
inputMtrl.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
inputMtrl.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
inputMtrl.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
}
else
{
BarCodeMsg<BD_BARCODERS2> tNewItem = ObjectExtensions.CreateDeepCopy(inputMtrl);
tNewItem.FBASEQTY = tempQty;
tNewItem.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, tempQty);
tNewItem.FSRCID = hisList[i].FSRCID;
tNewItem.FSRCENTRYID = hisList[i].FSRCENTRYID;
tNewItem.FSRCDETAILID = hisList[i].FSRCDETAILID;
tNewItem.FSRCBILLNO = hisList[i].FSRCBILLNO;
tNewItem.FSRCINFO.FMOID = hisList[i].FMOID;
tNewItem.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
tNewItem.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
tNewItem.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
tNewItem.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
tNewItem.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
tNewItem.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
tNewItem.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
newList.Add(tNewItem);
}
tempQty = 0;
}
else
{
//源单数量不足
hisList[i].FBASEREMINANQTY = 0;
if (i == hisList.Count - 1)
{
if (isScan)
{
isScan = false;
inputMtrl.FBASEQTY = tempQty;
inputMtrl.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, tempQty);
inputMtrl.FSRCID = hisList[i].FSRCID;
inputMtrl.FSRCENTRYID = hisList[i].FSRCENTRYID;
inputMtrl.FSRCDETAILID = hisList[i].FSRCDETAILID;
inputMtrl.FSRCBILLNO = hisList[i].FSRCBILLNO;
inputMtrl.FSRCINFO.FMOID = hisList[i].FMOID;
inputMtrl.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
inputMtrl.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
inputMtrl.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
inputMtrl.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
inputMtrl.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
inputMtrl.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
inputMtrl.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
}
else
{
BarCodeMsg<BD_BARCODERS2> tNewItem =
ObjectExtensions.CreateDeepCopy(inputMtrl);
tNewItem.FBASEQTY = tempQty;
tNewItem.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, tempQty);
tNewItem.FSRCID = hisList[i].FSRCID;
tNewItem.FSRCENTRYID = hisList[i].FSRCENTRYID;
tNewItem.FSRCDETAILID = hisList[i].FSRCDETAILID;
tNewItem.FSRCBILLNO = hisList[i].FSRCBILLNO;
tNewItem.FSRCINFO.FMOID = hisList[i].FMOID;
tNewItem.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
tNewItem.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
tNewItem.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
tNewItem.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
tNewItem.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
tNewItem.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
tNewItem.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
newList.Add(tNewItem);
}
tempQty = 0;
}
else
{
if (isScan)
{
isScan = false;
inputMtrl.FBASEQTY = remainQty;
inputMtrl.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, remainQty);
inputMtrl.FSRCID = hisList[i].FSRCID;
inputMtrl.FSRCENTRYID = hisList[i].FSRCENTRYID;
inputMtrl.FSRCDETAILID = hisList[i].FSRCDETAILID;
inputMtrl.FSRCBILLNO = hisList[i].FSRCBILLNO;
inputMtrl.FSRCINFO.FMOID = hisList[i].FMOID;
inputMtrl.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
inputMtrl.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
inputMtrl.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
inputMtrl.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
inputMtrl.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
inputMtrl.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
inputMtrl.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
}
else
{
BarCodeMsg<BD_BARCODERS2> tNewItem =
ObjectExtensions.CreateDeepCopy(inputMtrl);
tNewItem.FBASEQTY = remainQty;
tNewItem.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, remainQty);
tNewItem.FSRCID = hisList[i].FSRCID;
tNewItem.FSRCENTRYID = hisList[i].FSRCENTRYID;
tNewItem.FSRCDETAILID = hisList[i].FSRCDETAILID;
tNewItem.FSRCBILLNO = hisList[i].FSRCBILLNO;
tNewItem.FSRCINFO.FMOID = hisList[i].FMOID;
tNewItem.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
tNewItem.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
tNewItem.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
tNewItem.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
tNewItem.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
tNewItem.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
tNewItem.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
newList.Add(tNewItem);
}
tempQty -= remainQty;
}
}
}
}
#endregion
#region 产生物料中间表信息
itemList.AddRange(newList);
itemList.AddRange(barList);
#endregion
}
#endregion
#region 有源单,给中间表赋值
string newID = Guid.NewGuid().ToString();
dicHead.Add(newID, new HEAD
{
FBILLTYPEID = billTypeID,
FINTERID = newID,
FSUPPLYID = sub.Key.FSUPPLYID,
FTRANTYPE = request.TranType,
FSRCFORMID = sub.Key.FSRCFORMID,
FSRCBILLNO = sub.Key.FSRCBILLNO,
FCOMPANYID = FCOMPANYID,
FISSYNTOERP = selBill.FCANSYNERP,
FISNOWSYNERP = selBill.FCHECKERPSTOCK
});
//条码最底阶中间表
dicEntry2.Add(newID, itemList);
#endregion
}
#endregion
#endregion
#region 产生出入库单据
int entryId = 1;
var sqlStr = "";
List<string> exeSqlStrList = new List<string>();
Dictionary<string, TBarStatus> updateBarcodeList = new Dictionary<string, TBarStatus>();
#region 更新库存记录
//操作库存
string retMess = APPWmsCommonFunc.CalculateInventory(context, request.orgID, myInBillList, false, ref exeSqlStrList);
if (!retMess.IsNullOrWhiteSpace())
{
jsonRet.Message = retMess;
return jsonRet;
}
#endregion
#region 创建中间表信息
foreach (var head in dicHead)
{
//表体1物料信息
var dicvalue = dicEntry2.First(p => p.Key.Equals(head.Key));
if (dicvalue.Value.Count != 0)
{
var material = dicvalue.Value.GroupBy(o => new
{
o.FUSEFULDATE,
o.FSTOCKSTATUSID,
o.FKEEPERTYPEID,
o.FKEEPERID,
o.FOWNERTYPEID,
o.FOWNERID,
o.FSUPPLYID,
o.FMATERIALID,
o.FUNITID,
o.FSECUNITID,
o.FBASEUNITID,
o.FLOT,
o.FAUXPROPID,
o.FKFDATE,
o.FSTOCKID,
o.FSTOCKLOCID,
o.FSRCFORMID,
o.FSRCID,
o.FSRCBILLNO,
o.FSRCENTRYID,
o.FSRCDETAILID,
o.FSRCINFO.FPPBOMID,
o.FSRCINFO.FPPBOMBILLNO,
o.FSRCINFO.FPPBOMENTRYID,
o.FSRCINFO.FPPBOMDETAILID,
o.FSRCINFO.FMOID,
o.FSRCINFO.FMOBILLNO,
o.FSRCINFO.FMOENTRYID,
o.FSRCINFO.FMODETAILID
});
entryId = 1;
foreach (var data in material)
{
string materialDetailId = Guid.NewGuid().ToString();
var pickQty = data.Sum(o => o.FQTY);
var pickBaseQty = data.Sum(o => o.FBASEQTY);
var secUnitQty = data.Sum(o => o.FSECUNITQTY);
sqlStr =
$@"INSERT INTO T_SUB_PICKMTRLENTRY
(
UID,
FINTERID,
FENTRYID,
FDETAILID,
FSRCFORMID,
FSRCID,
FSRCBILLNO,
FSRCENTRYID,
FSRCDETAILID,
FMOID,
FMOBILLNO,
FMOENTRYSEQ,
FMOENTRYID,
FPPBOMID,
FPPBOMBILLNO,
FPPBOMENTRYSEQ,
FPPBOMENTRYID,
FMATERIALID,
FLOT,
FAUXPROPID,
FSTOCKID,
FSTOCKLOCID,
FUNITID,
FBASEUNITID,
FMUSTQTY,
FREALQTY,
FBASEUNITQTY,
FSUPPLYID,
FSECUNITID,
FSECUNITQTY,
FKEEPERID,
FKEEPERTYPEID,
FOWNERID,
FOWNERTYPEID,
FSTOCKSTATUSID";
if (CheckDateTime.IsDate(data.Key.FKFDATE.ToStringEx()))
{
sqlStr += ",FKFDATE,FUSEFULDATE";
}
sqlStr += $@")
VALUES
(
'{Guid.NewGuid().ToStringEx()}',
'{head.Key}',
'{entryId++}',
'{materialDetailId}',
'{data.Key.FSRCFORMID}',
'{data.Key.FSRCID}',
'{data.Key.FSRCBILLNO}',
{data.Key.FSRCENTRYID},
'{data.Key.FSRCDETAILID}',
'{data.Key.FMOID}',
'{data.Key.FMOBILLNO}',
{data.Key.FMOENTRYID},
'{data.Key.FMODETAILID}',
'{data.Key.FPPBOMID}',
'{data.Key.FPPBOMBILLNO}',
{data.Key.FPPBOMENTRYID},
'{data.Key.FPPBOMDETAILID}',
'{data.Key.FMATERIALID}',
'{data.Key.FLOT}',
'{data.Key.FAUXPROPID}',
'{data.Key.FSTOCKID}',
'{data.Key.FSTOCKLOCID}',
'{data.Key.FUNITID}',
'{data.Key.FBASEUNITID}',
{pickQty},
{pickQty},
{pickBaseQty},
'{data.Key.FSUPPLYID}',
'{data.Key.FSECUNITID}',
{secUnitQty},
'{data.Key.FKEEPERID}',
'{data.Key.FKEEPERTYPEID}',
'{data.Key.FOWNERID}',
'{data.Key.FOWNERTYPEID}',
'{data.Key.FSTOCKSTATUSID}'
";
if (CheckDateTime.IsDate(data.Key.FKFDATE.ToStringEx()))
{
sqlStr += $",'{data.Key.FKFDATE}','{data.Key.FUSEFULDATE}'";
}
sqlStr += ")";
exeSqlStrList.Add(sqlStr);
//反写条码明细的关联字段FBODYID
dicvalue.Value.Where(o =>
o.FSUPPLYID == data.Key.FSUPPLYID &&
o.FMATERIALID == data.Key.FMATERIALID &&
o.FUNITID == data.Key.FUNITID &&
o.FBASEUNITID == data.Key.FBASEUNITID &&
o.FLOT == data.Key.FLOT &&
o.FAUXPROPID == data.Key.FAUXPROPID &&
o.FKFDATE == data.Key.FKFDATE &&
o.FUSEFULDATE == data.Key.FUSEFULDATE &&
o.FSTOCKSTATUSID == data.Key.FSTOCKSTATUSID &&
o.FSTOCKID == data.Key.FSTOCKID &&
o.FSTOCKLOCID == data.Key.FSTOCKLOCID &&
o.FSRCINFO.FPPBOMDETAILID == data.Key.FPPBOMDETAILID)
.ForEach(o =>
{
o.FBODYID = materialDetailId;
});
}
#region 更新源单关联数量
var billGroup = dicvalue.Value
.Where(o => o.FSRCFORMID != "null" && o.FSRCFORMID.IsNullOrEmpty() != true)
.GroupBy(o => new
{
o.FSRCFORMID,
o.FSRCINFO.FPPBOMDETAILID
});
//更新源单关联数据
foreach (var srcItem in billGroup)
{
var pickQty = srcItem.Sum(o => o.FQTY);
var pickBaseQty = srcItem.Sum(o => o.FBASEQTY);
switch (srcItem.Key.FSRCFORMID)
{
case "SUB_SUBREQORDER": //委外订单
exeSqlStrList.Add(
$@"UPDATE T_SUB_PPBOMENTRY
SET FPICKEDQTY=FPICKEDQTY+{pickQty},
FBASEPICKEDQTY=FBASEPICKEDQTY+{pickBaseQty},
FNOPICKEDQTY=FNOPICKEDQTY-{pickQty},
FBASENOPICKEDQTY=FBASENOPICKEDQTY-{pickBaseQty}
WHERE FDETAILID='{srcItem.Key.FPPBOMDETAILID}';");
break;
}
}
#endregion 更新源单关联数量
}
//表体2条码信息
int entryID2 = 1;
dicvalue.Value.ForEach(v =>
{
sqlStr =
$@"INSERT INTO T_SUB_PICKMTRLENTRY1
(
UID,
FBODYID,
FINTERID,
FENTRYID,
FDETAILID,
FTYPEID,
FSRCFORMID,
FSRCID,
FSRCBILLNO,
FSRCENTRYID,
FSRCDETAILID,
FMOID,
FMOBILLNO,
FMOENTRYSEQ,
FMOENTRYID,
FPPBOMID,
FPPBOMBILLNO,
FPPBOMENTRYSEQ,
FPPBOMENTRYID,
FMATERIALID,
FLOT,
FAUXPROPID,
FSTOCKID,
FSTOCKLOCID,
FSTOCKSTATUSID,
FUNITID,
FBASEUNITID,
FQTY,
FBASEUNITQTY,
FISBOX,
FBARCODE,
FSUPPLYID,
FSECUNITID,
FSECUNITQTY,
FKEEPERID,
FKEEPERTYPEID,
FOWNERID,
FOWNERTYPEID,
FBARTYPE,
FBOXBARCODE";
if (CheckDateTime.IsDate(v.FKFDATE.ToStringEx()))
{
sqlStr += ",FKFDATE,FUSEFULDATE";
}
sqlStr +=$@" )
VALUES
(
'{Guid.NewGuid().ToStringEx()}',
'{v.FBODYID}',
'{head.Key}',
'{entryID2++}',
'{Guid.NewGuid().ToStringEx()}',
{2},
'{v.FSRCFORMID}',
'{v.FSRCID}',
'{v.FSRCBILLNO}',
{v.FSRCENTRYID},
'{v.FSRCDETAILID}',
'{v.FSRCINFO.FMOID}',
'{v.FSRCINFO.FMOBILLNO}',
{v.FSRCINFO.FMOENTRYID},
'{v.FSRCINFO.FMODETAILID}',
'{v.FSRCINFO.FPPBOMID}',
'{v.FSRCINFO.FPPBOMBILLNO}',
{v.FSRCINFO.FPPBOMENTRYID},
'{v.FSRCINFO.FPPBOMDETAILID}',
'{v.FMATERIALID}',
'{v.FLOT}',
'{v.FAUXPROPID}',
'{v.FSTOCKID}',
'{v.FSTOCKLOCID}',
'{v.FSTOCKSTATUSID}',
'{v.FUNITID}',
'{v.FBASEUNITID}',
{v.FQTY},
{v.FBASEQTY},
{v.FISBOX},
'{v.FBARCODE}',
'{v.FSUPPLYID}',
'{v.FSECUNITID}',
{v.FSECUNITQTY},
'{v.FKEEPERID}',
'{v.FKEEPERTYPEID}',
'{v.FOWNERID}',
'{v.FOWNERTYPEID}',
'{v.FBARTYPE}',
'{v.FBOXBARCODE}'
";
if (CheckDateTime.IsDate(v.FKFDATE.ToStringEx()))
{
sqlStr += $",'{v.FKFDATE}','{v.FUSEFULDATE}'";
}
sqlStr += ")";
exeSqlStrList.Add(sqlStr);
//添加条码信息
if (!updateBarcodeList.ContainsKey(v.FBARCODE))
{
updateBarcodeList.Add(
v.FBARCODE,
new TBarStatus
{
FSTOCKID = v.FSTOCKID,
FSTOCKLOCID = v.FSTOCKLOCID,
FISBOX = v.FISBOX == 1 ? true : false,
FSTOCKSTATUSID = v.FSTOCKSTATUSID
});
}
if (v.FISBOX == 1)
{
if (!updateBarcodeList.ContainsKey(v.FBOXBARCODE))
{
updateBarcodeList.Add(v.FBOXBARCODE,
new TBarStatus
{
FSTOCKID = v.FSTOCKID,
FSTOCKLOCID = v.FSTOCKLOCID,
FISBOX = v.FISBOX == 1 ? true : false,
FSTOCKSTATUSID = v.FSTOCKSTATUSID
});
}
}
});
//表头信息
head.Value.FDATE = DateTime.Today;// request.FDate.IsNullOrEmpty() ? DateTime.Now : Convert.ToDateTime(request.FDate);
head.Value.FBILLNO = CreateBilllNO(context, CheckBill.NewDataRow(head.Value), "SUB_PICKMTRL", "T_SUB_PICKMTRL", "FBILLNO", null, null);
sqlStr =
$@"INSERT INTO T_SUB_PICKMTRL
(
UID,
FINTERID,
FBILLTYPEID,
FBILLNO,
FDATE,
FTYPEID,
FSRCFORMID,
FSRCBILLNO,
FDEPTID,
FSUPPLYID,
FCOMPANYID,
FSTATUS,
C_YMD,
C_USER,
FCHECKDATE,
FCHECKERID,
FPICKERID
)
VALUES
(
'{Guid.NewGuid().ToStringEx()}',
'{head.Key}',
'{head.Value.FBILLTYPEID}',
'{head.Value.FBILLNO}',
'{head.Value.FDATE}',
2,
'{head.Value.FSRCFORMID}',
'{head.Value.FSRCBILLNO}',
'{head.Value.FDEPTID}',
'{head.Value.FSUPPLYID}',
'{head.Value.FCOMPANYID}',
{40},
GETDATE(),
'{LoginInfo.UserID}',
GETDATE(),
'{LoginInfo.UserID}',
''
)";
exeSqlStrList.Add(sqlStr);
}
#endregion 创建中间表信息
#region 更新条码信息
//更新条码状态、仓库仓位信息
exeSqlStrList.AddRange(CheckBill.UpdateBarStatus(request.TranType, updateBarcodeList));
#endregion
#region 创建同步队列
List<string> needNowSyn = new List<string>();
dicHead
.Where(o => o.Value.FISSYNTOERP)
.ForEach(p =>
{
exeSqlStrList.Add(CheckBill.GetSynTask(request.TranType, p.Value.FBILLNO, p.Key, p.Value.FISNOWSYNERP));
if (p.Value.FISNOWSYNERP)
{
needNowSyn.Add(p.Key);
}
});
#endregion
#region 执行事务操作
try
{
await context.Database.BeginTransactionAsync();
//执行SQL
context.Database.SqlQuery(exeSqlStrList);
await context.Database.CommitTransactionAsync();
}
catch (Exception ex)
{
await context.Database.RollbackTransactionAsync();
jsonRet.Message = "执行事务操作异常," + ex.Message;
return jsonRet;
}
#endregion
#region WMS操作成功后,实时同步到ERP中
if (needNowSyn.Count > 0)
{
ToERPResult result = APPWmsCommonFunc.SubmitToERP(LoginInfo.DBAias, request.TranType, needNowSyn);
if (result == null || !result.ExecuteResult)
{
jsonRet.Status = 1;
jsonRet.Data.Add("data", $"WMS单号【{string.Join(";", dicHead.Select(o => o.Value.FBILLNO).ToList())}】委外领料成功,同步ERP失败:" + result.Message);
return jsonRet;
}
}
#endregion
#endregion
#region 返回值
jsonRet.Status = 1;
jsonRet.Data.Add("data", $"单号【{string.Join(";", dicHead.Select(o => o.Value.FBILLNO).ToList())}】委外领料成功.");
return await Task.Run(() => jsonRet);
#endregion
}
catch (Exception ex)
{
#region 异常处理
jsonRet.Status = 0;
jsonRet.Message = "委外领料异常," + ex.Message;
return jsonRet;
#endregion
}
}
/// <summary>
/// 委外退料
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public async Task<RetMessage> SUBRETURNMTRL(InputBarCode<BD_BARCODERS2> request, List<BOS_SELBILL> selBillList)
{
string billTypeID = request.billTypeID;
RetMessage jsonRet = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
#region 初始化
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
string strSQL = string.Empty;
List<BarCodeMsg<BD_BARCODERS2>> barcodeEntry1 = new List<BarCodeMsg<BD_BARCODERS2>>();//条码原始扫描信息
List<BarCodeMsg<BD_BARCODERS2>> barcodeEntry2 = new List<BarCodeMsg<BD_BARCODERS2>>();//箱码最底阶信息
request.barcodeList.ForEach(o =>
{
o.FSRCINFO ??= new BD_BARCODERS2();
//箱码最底阶信息
if (o.FISBOX == 1)
{
if (o.FBOXINFO != null && o.FBOXINFO.Count > 0)
{
//装箱底阶明细,提交的仓库仓位重新赋值
o.FBOXINFO.ForEach(x =>
{
x.FSRCINFO ??= new BD_BARCODERS2();
x.FISBOX = 1;
x.FID = o.FID;
x.FSUPPLYID = o.FSUPPLYID;
x.FDEPTID = o.FDEPTID;
x.FCUSTID = o.FCUSTID;
x.FSTOCKID = o.FSTOCKID;
x.FSTOCKLOCID = o.FSTOCKLOCID;
});
}
barcodeEntry2.AddRange(o.FBOXINFO);
}
else
{
barcodeEntry2.Add(o);
}
//条码原始扫描信息
barcodeEntry1.Add(o);
});
#endregion
#region 校验条码状态,若箱码需查询最底阶信息
foreach (var sub in barcodeEntry1)
{
DataTable dtCusor = context.Database.SqlQuery($@"SELECT
S.FDELETED
,S.FBARTYPE
,S.FINBOX--被装箱
,S.FISBOX--箱码
,S.FQTY--数量
,S.FBARCODESTATUS
,S.FSTOCKSTATUS
FROM T_BD_BARCODERS S
WHERE FBARCODE='{sub.FBARCODE}'");
dtCusor.CaseSensitive = false;
if (dtCusor == null || dtCusor.Rows.Count <= 0)
{
jsonRet.Message = string.Format("条码【{0}】信息未找到!", sub.FBARCODE);
return jsonRet;
}
if (dtCusor.Rows.Count > 1)
{
jsonRet.Message = string.Format("条码【{0}】信息存在多条记录!", sub.FBARCODE);
return jsonRet;
}
DataRow selectDr = dtCusor.Rows[0];
if (selectDr["FDELETED"].ToBoolean())
{
jsonRet.Message = string.Format("条码【{0}】已禁用!", sub.FBARCODE);
return jsonRet;
}
if (selectDr["FBARTYPE"].ToInt() < 3)
{
if (selectDr["FINBOX"].ToBoolean())
{
jsonRet.Message = string.Format("条码【{0}】不符规则,原因:已入箱!", sub.FBARCODE);
return jsonRet;
}
string errorMsg = CheckBill.CheckBarCodeStatus(request.TranType, selectDr["FSTOCKSTATUS"].ToInt(), sub.FBARCODE);
if (!string.IsNullOrEmpty(errorMsg))
{
jsonRet.Message = errorMsg;
return jsonRet;
}
}
}
#endregion
#region 按源单信息汇总
#region 定义中间表字典库
Dictionary<string, HEAD> dicHead = new Dictionary<string, HEAD>();
Dictionary<string, List<BarCodeMsg<BD_BARCODERS2>>> dicEntry2 = new Dictionary<string, List<BarCodeMsg<BD_BARCODERS2>>>();
#endregion
#region 无源单信息,按供应商汇总
var notSoureGroups = request.barcodeList.Where(o => o.FSRCFORMID.IsNullOrWhiteSpace() == true).GroupBy(o => new
{
o.FSRCFORMID,
o.FSRCBILLNO,
o.FID
}).ToList();
foreach (var sub in notSoureGroups)
{
BOS_SELBILL selBill = selBillList.FirstOrDefault(o => o.FSRCFORMID == sub.Key.FSRCFORMID);
jsonRet.Message = GetBillType(sub.Key.FSRCFORMID, string.Empty, selBillList, out billTypeID);
if (!string.IsNullOrEmpty(jsonRet.Message))
{
return jsonRet;
}
string newID = Guid.NewGuid().ToString();
dicHead.Add(newID, new HEAD
{
FBILLTYPEID = billTypeID,
FINTERID = newID,
FSUPPLYID = sub.Key.FID,
FTRANTYPE = request.TranType,
FSRCFORMID = sub.Key.FSRCFORMID,
FSRCBILLNO = sub.Key.FSRCBILLNO,
FCOMPANYID = request.orgID,
FISSYNTOERP = selBill.FCANSYNERP,
FISNOWSYNERP = selBill.FCHECKERPSTOCK
});
List<BarCodeMsg<BD_BARCODERS2>> notSourceEntry2 = new List<BarCodeMsg<BD_BARCODERS2>>();
notSourceEntry2.AddRange(barcodeEntry2.Where(o => o.FSRCFORMID.ToStringEx() == sub.Key.FSRCFORMID &&
o.FSRCBILLNO.ToStringEx() == sub.Key.FSRCBILLNO &&
o.FID == sub.Key.FID).ToList());
notSourceEntry2.ForEach(o =>
{
o.FSRCFORMID = string.Empty;
o.FSRCID = string.Empty;
o.FSRCENTRYID = 0;
o.FSRCDETAILID = string.Empty;
o.FSRCBILLNO = string.Empty;
o.FSRCINFO.FMOID = string.Empty;
o.FSRCINFO.FMOENTRYID = 0;
o.FSRCINFO.FMOBILLNO = string.Empty;
o.FSRCINFO.FMODETAILID = string.Empty;
o.FSRCINFO.FPPBOMID = string.Empty;
o.FSRCINFO.FPPBOMBILLNO = string.Empty;
o.FSRCINFO.FPPBOMENTRYID = 0;
o.FSRCINFO.FPPBOMDETAILID = string.Empty;
});
//条码最底阶中间表
dicEntry2.Add(newID, notSourceEntry2);
}
#endregion
#region 有源单,按物料类别汇总
List<BarCodeMsg<BD_BARCODERS2>> myInBillList = barcodeEntry2.Select(o => new BarCodeMsg<BD_BARCODERS2>()
{
FUSEFULDATE = o.FUSEFULDATE,
FSTOCKSTATUSID = o.FSTOCKSTATUSID,
FID = o.FID,
FISBOX = o.FISBOX,
FBOXBARCODE = o.FBOXBARCODE,
FBARCODE = o.FBARCODE,
FBARTYPE = o.FBARTYPE,
FMATERIALID = o.FMATERIALID,
FITEMNUMBER = o.FITEMNUMBER,
FKFDATE = o.FKFDATE,
FKFPERIOD = o.FKFPERIOD,
FSTOCKID = o.FSTOCKID,
FSTOCKLOCID = o.FSTOCKLOCID,
FUNITID = o.FUNITID,
FBASEUNITID = o.FBASEUNITID,
FLOT = o.FLOT,
FAUXPROPID = o.FAUXPROPID,
FQTY = o.FQTY,
FBASEQTY = o.FBASEQTY,
FSECUNITID = o.FSECUNITID,
FSECUNITQTY = o.FSECUNITQTY,
FSRCFORMID = o.FSRCFORMID,
FSRCBILLNO = o.FSRCBILLNO,
FSRCINFO = o.FSRCINFO,
FKEEPERID = o.FKEEPERID,
FKEEPERTYPEID = o.FKEEPERTYPEID,
FOWNERID = o.FOWNERID,
FOWNERTYPEID = o.FOWNERTYPEID
}).ToList();
var haveSourceGroups = barcodeEntry2.Where(o => o.FSRCFORMID.IsNullOrWhiteSpace() != true).GroupBy(o =>
new
{
o.FSRCFORMID,
o.FSRCBILLNO,
o.FSRCENTRYID,
o.FID
}).ToList();
foreach (var haveSourceGroup in haveSourceGroups)
{
#region 查询源单信息
BOS_SELBILL selBill = selBillList.FirstOrDefault(o => o.FSRCFORMID == haveSourceGroup.Key.FSRCFORMID);
if (selBill == null)
{
jsonRet.Message = "委外退料异常:" + "源单【" + haveSourceGroup.Key.FSRCBILLNO + "】出入库流程单据信息未找到!";
return jsonRet;
}
string tempSQL = CheckBill.GetSoureBillData(request.orgID, request.TranType, selBill.FSRCFORMID, haveSourceGroup.Key.FSRCBILLNO, haveSourceGroup.Key.FSRCENTRYID);
if (tempSQL.IsNullOrWhiteSpace())
{
jsonRet.Message = "委外退料异常:" + "源单【" + haveSourceGroup.Key.FSRCBILLNO + "】查询信息未设置!";
return jsonRet;
}
string FCOMPANYID = string.Empty;
List<SOURCEBILLINFO> hisSourceBill = context.Database.SqlQuery<SOURCEBILLINFO>(tempSQL);
if (hisSourceBill == null || hisSourceBill.Count <= 0)
{
jsonRet.Message = "委外退料异常:" + "源单【" + haveSourceGroup.Key.FSRCBILLNO + "】中信息未找到!";
return jsonRet;
}
else if (hisSourceBill.All(o => o.FBASEREMINANQTY <= 0))
{
jsonRet.Message = "委外退料异常:" + "源单【" + haveSourceGroup.Key.FSRCBILLNO + "】中可退料数量小于等于零!";
return jsonRet;
}
else
{
if (request.orgID.IsNullOrEmpty())
{
FCOMPANYID = hisSourceBill[0].FCOMPANYID;
}
else
{
FCOMPANYID = request.orgID;
}
}
#endregion
#region 查询源单单据类型
jsonRet.Message = GetBillType(haveSourceGroup.Key.FSRCFORMID, hisSourceBill.First().FBILLTYPEID, selBillList, out billTypeID);
if (!string.IsNullOrEmpty(jsonRet.Message))
{
return jsonRet;
}
#endregion
#region 按物料、批号、辅助属性、保质日期分组
var barcodeGroups = barcodeEntry2
.Where(b =>
b.FSRCFORMID == haveSourceGroup.Key.FSRCFORMID &&
b.FSRCBILLNO == haveSourceGroup.Key.FSRCBILLNO &&
b.FSRCENTRYID == haveSourceGroup.Key.FSRCENTRYID &&
b.FID == haveSourceGroup.Key.FID)
.GroupBy(b => new
{
b.FMATERIALID,
b.FITEMNUMBER,
b.FLOT,
b.FAUXPROPID,
b.FKFDATE
});
List<TargetGroup> tempEntryGroups = new List<TargetGroup>();
foreach (var barcodeGroup in barcodeGroups)
{
tempEntryGroups.Add(new TargetGroup
{
FMATERIALID = barcodeGroup.Key.FMATERIALID,
FITEMNUMBER = barcodeGroup.Key.FITEMNUMBER,
FLOT = barcodeGroup.Key.FLOT,
FAUXPROPID = barcodeGroup.Key.FAUXPROPID,
FKFDATE = barcodeGroup.Key.FKFDATE
});
}
if (!selBill.FISCHECKLOT)
{
tempEntryGroups.ForEach(o => o.FLOT = string.Empty);
}
if (!selBill.FISCHECKAUX)
{
tempEntryGroups.ForEach(o => o.FAUXPROPID = string.Empty);
}
if (!selBill.FISCHECKKFDATE)
{
tempEntryGroups.ForEach(o => o.FKFDATE = string.Empty);
}
var myBillGroups = tempEntryGroups.GroupBy(o => new
{
o.FMATERIALID,
o.FITEMNUMBER,
o.FLOT,
o.FAUXPROPID,
o.FKFDATE
});
List<BarCodeMsg<BD_BARCODERS2>> itemList = new List<BarCodeMsg<BD_BARCODERS2>>();
foreach (var bill in myBillGroups)
{
#region 判断源单中批次、辅助属性、保质期、数量是否满足要求
List<SOURCEBILLINFO> hisList = hisSourceBill
.Where(o => o.FMATERIALID.Equals(bill.Key.FMATERIALID))
.OrderBy(o => o.FSRCENTRYID)
.ToList();
List<BarCodeMsg<BD_BARCODERS2>> barList = ObjectExtensions.CreateDeepCopy(myInBillList
.Where(o =>
o.FSRCFORMID.Equals(haveSourceGroup.Key.FSRCFORMID) &&
o.FSRCBILLNO.Equals(haveSourceGroup.Key.FSRCBILLNO) &&
o.FMATERIALID.Equals(bill.Key.FMATERIALID))
.ToList());
if (selBill.FISCHECKLOT)
{
hisList = hisList.Where(o => o.FLOT.Equals(bill.Key.FLOT)).ToList();
if (hisList == null || hisList.Count <= 0)
{
jsonRet.Message = "委外退料异常:" + "源单【" + haveSourceGroup.Key.FSRCBILLNO + "】中物料【" + bill.Key.FITEMNUMBER + "】,批次【" + bill.Key.FLOT + "】信息未找到!";
return jsonRet;
}
barList = barList.Where(o => o.FLOT.Equals(bill.Key.FLOT)).ToList();
}
if (selBill.FISCHECKAUX)
{
hisList = hisList.Where(o => o.FAUXPROPID.IsNullOrEmpty() || (!o.FAUXPROPID.IsNullOrEmpty() && o.FAUXPROPID.Equals(bill.Key.FAUXPROPID))).ToList();
if (hisList == null || hisList.Count <= 0)
{
jsonRet.Message = "委外退料异常:" + "源单【" + haveSourceGroup.Key.FSRCBILLNO + "】中物料【" + bill.Key.FITEMNUMBER + "】,辅助属性【" + bill.Key.FAUXPROPID + "】信息未找到!";
return jsonRet;
}
barList = barList.Where(o => o.FAUXPROPID.Equals(bill.Key.FAUXPROPID)).ToList();
}
if (selBill.FISCHECKKFDATE)
{
hisList = hisList.Where(o => o.FKFPERIOD == 0 || (o.FKFPERIOD > 0 && !o.FKFDATE.IsNullOrEmpty() && CheckDateTime.CompareTime(o.FKFDATE, bill.Key.FKFDATE) == 0)).ToList();
if (hisList == null || hisList.Count <= 0)
{
jsonRet.Message = "委外退料异常:" + "源单【" + haveSourceGroup.Key.FSRCBILLNO + "】中物料【" + bill.Key.FITEMNUMBER + "】,保质日期【" + bill.Key.FKFDATE + "】信息未找到!";
return jsonRet;
}
barList = barList.Where(o => o.FKFDATE.Equals(bill.Key.FKFDATE)).ToList();
}
if (selBill.FISCONTROLQTY)
{
if (barList.Sum(o => o.FBASEQTY) > hisList.Sum(o => o.FBASEREMINANQTY))
{
jsonRet.Message = "委外退料异常:" + "源单【" + haveSourceGroup.Key.FSRCBILLNO + "】中物料【" + bill.Key.FITEMNUMBER + "】,扫描数量【" + barList.Sum(o => o.FBASEQTY) + "】>可退料数量【" + hisList.Sum(o => o.FBASEREMINANQTY) + "】!";
return jsonRet;
}
}
#endregion
#region 遍历当前源单的出库信息,产生物料中间表
List<BarCodeMsg<BD_BARCODERS2>> newList = new List<BarCodeMsg<BD_BARCODERS2>>();
foreach (var inputMtrl in barList)
{
//找源单中是否有存在这个行号的数据,如果有,优先用这个行号的数据
decimal tempQty = inputMtrl.FBASEQTY;
bool isScan = true;
for (int i = 0; i < hisList.Count && tempQty > 0; i++)
{
decimal remainQty = hisList[i].FBASEREMINANQTY;
if (remainQty <= 0 && selBill.FISCONTROLQTY)
{
continue;
}
if (remainQty >= tempQty)
{
//源单数量充足
hisList[i].FBASEREMINANQTY = remainQty - tempQty;
if (isScan)
{
isScan = false;
inputMtrl.FBASEQTY = tempQty;
inputMtrl.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, tempQty);
inputMtrl.FSRCID = hisList[i].FSRCID;
inputMtrl.FSRCENTRYID = hisList[i].FSRCENTRYID;
inputMtrl.FSRCDETAILID = hisList[i].FSRCDETAILID;
inputMtrl.FSRCBILLNO = hisList[i].FSRCBILLNO;
inputMtrl.FSRCINFO.FMOID = hisList[i].FMOID;
inputMtrl.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
inputMtrl.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
inputMtrl.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
inputMtrl.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
inputMtrl.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
inputMtrl.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
inputMtrl.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
}
else
{
BarCodeMsg<BD_BARCODERS2> tNewItem = ObjectExtensions.CreateDeepCopy(inputMtrl);
tNewItem.FBASEQTY = tempQty;
tNewItem.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, tempQty);
tNewItem.FSRCID = hisList[i].FSRCID;
tNewItem.FSRCENTRYID = hisList[i].FSRCENTRYID;
tNewItem.FSRCDETAILID = hisList[i].FSRCDETAILID;
tNewItem.FSRCBILLNO = hisList[i].FSRCBILLNO;
tNewItem.FSRCINFO.FMOID = hisList[i].FMOID;
tNewItem.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
tNewItem.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
tNewItem.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
tNewItem.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
tNewItem.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
tNewItem.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
tNewItem.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
newList.Add(tNewItem);
}
tempQty = 0;
}
else
{
//源单数量不足
hisList[i].FBASEREMINANQTY = 0;
if (i == hisList.Count - 1)
{
if (isScan)
{
isScan = false;
inputMtrl.FBASEQTY = tempQty;
inputMtrl.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, tempQty);
inputMtrl.FSRCID = hisList[i].FSRCID;
inputMtrl.FSRCENTRYID = hisList[i].FSRCENTRYID;
inputMtrl.FSRCDETAILID = hisList[i].FSRCDETAILID;
inputMtrl.FSRCBILLNO = hisList[i].FSRCBILLNO;
inputMtrl.FSRCINFO.FMOID = hisList[i].FMOID;
inputMtrl.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
inputMtrl.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
inputMtrl.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
inputMtrl.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
inputMtrl.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
inputMtrl.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
inputMtrl.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
}
else
{
BarCodeMsg<BD_BARCODERS2> tNewItem =
ObjectExtensions.CreateDeepCopy(inputMtrl);
tNewItem.FBASEQTY = tempQty;
tNewItem.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, tempQty);
tNewItem.FSRCID = hisList[i].FSRCID;
tNewItem.FSRCENTRYID = hisList[i].FSRCENTRYID;
tNewItem.FSRCDETAILID = hisList[i].FSRCDETAILID;
tNewItem.FSRCBILLNO = hisList[i].FSRCBILLNO;
tNewItem.FSRCINFO.FMOID = hisList[i].FMOID;
tNewItem.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
tNewItem.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
tNewItem.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
tNewItem.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
tNewItem.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
tNewItem.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
tNewItem.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
newList.Add(tNewItem);
}
tempQty = 0;
}
else
{
if (isScan)
{
isScan = false;
inputMtrl.FBASEQTY = remainQty;
inputMtrl.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, remainQty);
inputMtrl.FSRCID = hisList[i].FSRCID;
inputMtrl.FSRCENTRYID = hisList[i].FSRCENTRYID;
inputMtrl.FSRCDETAILID = hisList[i].FSRCDETAILID;
inputMtrl.FSRCBILLNO = hisList[i].FSRCBILLNO;
inputMtrl.FSRCINFO.FMOID = hisList[i].FMOID;
inputMtrl.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
inputMtrl.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
inputMtrl.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
inputMtrl.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
inputMtrl.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
inputMtrl.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
inputMtrl.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
}
else
{
BarCodeMsg<BD_BARCODERS2> tNewItem =
ObjectExtensions.CreateDeepCopy(inputMtrl);
tNewItem.FBASEQTY = remainQty;
tNewItem.FQTY = GetMaterQty2(context, inputMtrl.FMATERIALID, inputMtrl.FBASEUNITID, inputMtrl.FUNITID, remainQty);
tNewItem.FSRCID = hisList[i].FSRCID;
tNewItem.FSRCENTRYID = hisList[i].FSRCENTRYID;
tNewItem.FSRCDETAILID = hisList[i].FSRCDETAILID;
tNewItem.FSRCBILLNO = hisList[i].FSRCBILLNO;
tNewItem.FSRCINFO.FMOID = hisList[i].FMOID;
tNewItem.FSRCINFO.FMOENTRYID = hisList[i].FMOENTRYID;
tNewItem.FSRCINFO.FMOBILLNO = hisList[i].FMOBILLNO;
tNewItem.FSRCINFO.FMODETAILID = hisList[i].FMODETIALID;
tNewItem.FSRCINFO.FPPBOMID = hisList[i].FPPBOMID;
tNewItem.FSRCINFO.FPPBOMBILLNO = hisList[i].FPPBOMBILLNO;
tNewItem.FSRCINFO.FPPBOMENTRYID = hisList[i].FPPBOMENTRYID;
tNewItem.FSRCINFO.FPPBOMDETAILID = hisList[i].FPPBOMDETAILID;
newList.Add(tNewItem);
}
tempQty -= remainQty;
}
}
}
}
#endregion
#region 产生物料中间表信息
itemList.AddRange(newList);
itemList.AddRange(barList);
#endregion
}
#endregion
#region 有源单,给中间表赋值
string newID = Guid.NewGuid().ToString();
dicHead.Add(newID, new HEAD
{
FBILLTYPEID = billTypeID,
FINTERID = newID,
FSUPPLYID = haveSourceGroup.Key.FID,
FTRANTYPE = request.TranType,
FSRCFORMID = haveSourceGroup.Key.FSRCFORMID,
FSRCBILLNO = haveSourceGroup.Key.FSRCBILLNO,
FCOMPANYID = FCOMPANYID,
FISSYNTOERP = selBill.FCANSYNERP,
FISNOWSYNERP = selBill.FCHECKERPSTOCK
});
//条码最底阶中间表
dicEntry2.Add(newID, itemList);
#endregion
}
#endregion
#endregion
#region 产生出入库单据
var sqlStr = "";
int entryId = 1;
List<string> exeSqlStrList = new List<string>();
Dictionary<string, TBarStatus> updateBarcodeList = new Dictionary<string, TBarStatus>();
#region 更新库存记录
//操作库存
string retMess = APPWmsCommonFunc.CalculateInventory(context, request.orgID, myInBillList, true, ref exeSqlStrList);
if (!retMess.IsNullOrWhiteSpace())
{
jsonRet.Message = retMess;
return jsonRet;
}
#endregion
#region 创建中间表信息
foreach (var head in dicHead)
{
var dicvalue = dicEntry2.First(p => p.Key.Equals(head.Key));
#region 物料信息
if (dicvalue.Value.Count != 0)
{
var material = dicvalue.Value.GroupBy(o => new
{
o.FUSEFULDATE,
o.FSTOCKSTATUSID,
o.FKEEPERTYPEID,
o.FKEEPERID,
o.FOWNERTYPEID,
o.FOWNERID,
o.FID,
o.FMATERIALID,
o.FUNITID,
o.FSECUNITID,
o.FBASEUNITID,
o.FLOT,
o.FAUXPROPID,
o.FKFDATE,
o.FSTOCKID,
o.FSTOCKLOCID,
o.FSUPPLYID,
o.FSRCFORMID,
o.FSRCID,
o.FSRCBILLNO,
o.FSRCENTRYID,
o.FSRCDETAILID,
o.FSRCINFO.FPPBOMID,
o.FSRCINFO.FPPBOMENTRYID,
o.FSRCINFO.FPPBOMBILLNO,
o.FSRCINFO.FPPBOMDETAILID,
o.FSRCINFO.FMOID,
o.FSRCINFO.FMOBILLNO,
o.FSRCINFO.FMOENTRYID,
o.FSRCINFO.FMODETAILID
});
entryId = 1;
foreach (var data in material)
{
string materialDetailId = Guid.NewGuid().ToString();
var pickQty = data.Sum(o => o.FQTY);
var pickBaseQty = data.Sum(o => o.FBASEQTY);
var secUnitQty = data.Sum(o => o.FSECUNITQTY);
sqlStr =
$@"INSERT INTO T_SUB_RETURNMTRLENTRY
(
UID,
FINTERID,
FENTRYID,
FDETAILID,
FSRCFORMID,
FSRCID,
FSRCBILLNO,
FSRCENTRYID,
FSRCDETAILID,
FMOID,
FMOBILLNO,
FMOENTRYSEQ,
FMOENTRYID,
FPPBOMID,
FPPBOMBILLNO,
FPPBOMENTRYSEQ,
FPPBOMENTRYID,
FMATERIALID,
FLOT,
FAUXPROPID,
FSTOCKID,
FSTOCKLOCID,
FSTOCKSTATUSID,
FUNITID,
FBASEUNITID,
FAPPQTY,
FACTUALQTY,
FBASEUNITQTY,
FSUPPLYID,
FSECUNITID,
FSECUNITQTY,
FKEEPERID,
FKEEPERTYPEID,
FOWNERID,
FOWNERTYPEID
";
if (CheckDateTime.IsDate(data.Key.FKFDATE.ToStringEx()))
{
sqlStr += ",FKFDATE,FUSEFULDATE";
}
sqlStr += $@")
VALUES
(
'{Guid.NewGuid().ToStringEx()}',
'{head.Key}',
'{entryId++}',
'{materialDetailId}',
'{data.Key.FSRCFORMID}',
'{data.Key.FSRCID}',
'{data.Key.FSRCBILLNO}',
{data.Key.FSRCENTRYID},
'{data.Key.FSRCDETAILID}',
'{data.Key.FMOID}',
'{data.Key.FMOBILLNO}',
{data.Key.FMOENTRYID},
'{data.Key.FMODETAILID}',
'{data.Key.FPPBOMID}',
'{data.Key.FPPBOMBILLNO}',
{data.Key.FPPBOMENTRYID},
'{data.Key.FPPBOMDETAILID}',
'{data.Key.FMATERIALID}',
'{data.Key.FLOT}',
'{data.Key.FAUXPROPID}',
'{data.Key.FSTOCKID}',
'{data.Key.FSTOCKLOCID}',
'{data.Key.FSTOCKSTATUSID}',
'{data.Key.FUNITID}',
'{data.Key.FBASEUNITID}',
{pickQty},
{pickQty},
{pickBaseQty},
'{data.Key.FSUPPLYID}',
'{data.Key.FSECUNITID}',
{secUnitQty},
'{data.Key.FKEEPERID}',
'{data.Key.FKEEPERTYPEID}',
'{data.Key.FOWNERID}',
'{data.Key.FOWNERTYPEID}'";
if (CheckDateTime.IsDate(data.Key.FKFDATE.ToStringEx()))
{
sqlStr += $",'{data.Key.FKFDATE}','{data.Key.FUSEFULDATE}'";
}
sqlStr += ")";
exeSqlStrList.Add(sqlStr);
//反写条码明细的关联字段FBODYID
dicvalue.Value.Where(o =>
o.FID == data.Key.FID &&
o.FMATERIALID == data.Key.FMATERIALID &&
o.FUNITID == data.Key.FUNITID &&
o.FBASEUNITID == data.Key.FBASEUNITID &&
o.FLOT == data.Key.FLOT &&
o.FAUXPROPID == data.Key.FAUXPROPID &&
o.FKFDATE == data.Key.FKFDATE &&
o.FSTOCKID == data.Key.FSTOCKID &&
o.FSTOCKLOCID == data.Key.FSTOCKLOCID &&
o.FSTOCKSTATUSID == data.Key.FSTOCKSTATUSID &&
o.FSRCINFO.FPPBOMDETAILID == data.Key.FPPBOMDETAILID).ForEach(o =>
{
o.FBODYID = materialDetailId;
});
}
}
#region 更新源单关联数量
var billGroup = dicvalue.Value
.Where(o => o.FSRCFORMID != "null" && o.FSRCFORMID.IsNullOrEmpty() != true)
.GroupBy(o => new
{
o.FSRCFORMID,
o.FSRCINFO.FPPBOMDETAILID
});
foreach (var srcItem in billGroup)
{
var pickQty = srcItem.Sum(o => o.FQTY);
var pickBaseQty = srcItem.Sum(o => o.FBASEQTY);
switch (srcItem.Key.FSRCFORMID.ToUpper())
{
case "SUB_PICKMTRL":
case "SUB_SUBREQORDER":
exeSqlStrList.Add(
$@"UPDATE T_SUB_PPBOMENTRY
SET FPICKEDQTY=FPICKEDQTY-{pickQty},
FBASEPICKEDQTY=FBASEPICKEDQTY-{pickBaseQty},
FNOPICKEDQTY=FNOPICKEDQTY+{pickQty},
FBASENOPICKEDQTY=FBASENOPICKEDQTY+{pickBaseQty}
WHERE FDETAILID='{srcItem.Key.FPPBOMDETAILID}';");
break;
}
}
#endregion 更新源单关联数量
#endregion 物料信息
#region 条码信息
entryId = 1;
dicvalue.Value.ForEach(v =>
{
sqlStr =
$@"INSERT INTO T_SUB_RETURNMTRLENTRY1
(
UID,
FBODYID,
FINTERID,
FENTRYID,
FDETAILID,
FTYPEID,
FSRCFORMID,
FSRCID,
FSRCBILLNO,
FSRCENTRYID,
FSRCDETAILID,
FMOID,
FMOBILLNO,
FMOENTRYSEQ,
FMOENTRYID,
FPPBOMID,
FPPBOMBILLNO,
FPPBOMENTRYSEQ,
FPPBOMENTRYID,
FMATERIALID,
FLOT,
FAUXPROPID,
FSTOCKID,
FSTOCKLOCID,
FSTOCKSTATUSID,
FUNITID,
FBASEUNITID,
FQTY,
FBASEUNITQTY,
FISBOX,
FBARCODE,
FSUPPLYID,
FSECUNITID,
FSECUNITQTY,
FKEEPERID,
FKEEPERTYPEID,
FOWNERID,
FOWNERTYPEID,
FBARTYPE,
FBOXBARCODE";
if (CheckDateTime.IsDate(v.FKFDATE.ToStringEx()))
{
sqlStr += ",FKFDATE,FUSEFULDATE";
}
sqlStr += $@")
VALUES
(
'{Guid.NewGuid().ToStringEx()}',
'{v.FBODYID}',
'{head.Key}',
'{entryId++}',
'{Guid.NewGuid().ToStringEx()}',
{2},
'{v.FSRCFORMID}',
'{v.FSRCID}',
'{v.FSRCBILLNO}',
{v.FSRCENTRYID},
'{v.FSRCDETAILID}',
'{v.FSRCINFO.FMOID}',
'{v.FSRCINFO.FMOBILLNO}',
{v.FSRCINFO.FMOENTRYID},
'{v.FSRCINFO.FMODETAILID}',
'{v.FSRCINFO.FPPBOMID}',
'{v.FSRCINFO.FPPBOMBILLNO}',
{v.FSRCINFO.FPPBOMENTRYID},
'{v.FSRCINFO.FPPBOMDETAILID}',
'{v.FMATERIALID}',
'{v.FLOT}',
'{v.FAUXPROPID}',
'{v.FSTOCKID}',
'{v.FSTOCKLOCID}',
'{v.FSTOCKSTATUSID}',
'{v.FUNITID}',
'{v.FBASEUNITID}',
{v.FQTY},
{v.FBASEQTY},
{v.FISBOX},
'{v.FBARCODE}',
'{v.FSUPPLYID}',
'{v.FSECUNITID}',
{v.FSECUNITQTY},
'{v.FKEEPERID}',
'{v.FKEEPERTYPEID}',
'{v.FOWNERID}',
'{v.FOWNERTYPEID}',
'{v.FBARTYPE}',
'{v.FBOXBARCODE}'";
if (CheckDateTime.IsDate(v.FKFDATE.ToStringEx()))
{
sqlStr += $",'{v.FKFDATE}','{v.FUSEFULDATE}'";
}
sqlStr += ")";
exeSqlStrList.Add(sqlStr);
//添加条码信息
if (!updateBarcodeList.ContainsKey(v.FBARCODE))
{
updateBarcodeList.Add(
v.FBARCODE,
new TBarStatus
{
FSTOCKID = v.FSTOCKID,
FSTOCKLOCID = v.FSTOCKLOCID,
FISBOX = v.FISBOX == 1 ? true : false,
FSTOCKSTATUSID = v.FSTOCKSTATUSID
});
}
if (v.FISBOX == 1)
{
if (!updateBarcodeList.ContainsKey(v.FBOXBARCODE))
{
updateBarcodeList.Add(v.FBOXBARCODE,
new TBarStatus
{
FSTOCKID = v.FSTOCKID,
FSTOCKLOCID = v.FSTOCKLOCID,
FISBOX = v.FISBOX == 1 ? true : false,
FSTOCKSTATUSID = v.FSTOCKSTATUSID
});
}
}
});
#endregion 条码信息
#region 表头信息
head.Value.FDATE = DateTime.Today;// request.FDate.IsNullOrEmpty() ? DateTime.Now : Convert.ToDateTime(request.FDate);
head.Value.FBILLNO = CreateBilllNO(context, CheckBill.NewDataRow(head.Value), "SUB_RETURNMTRL", "T_SUB_RETURNMTRL", "FBILLNO", null, null);
sqlStr =
$@"INSERT INTO T_SUB_RETURNMTRL
(
UID,
FINTERID,
FBILLTYPEID,
FBILLNO,
FDATE,
FTYPEID,
FSRCFORMID,
FSRCBILLNO,
FDEPTID,
FSUPPLYID,
FCOMPANYID,
FSTATUS,
C_YMD,
C_USER,
FCHECKDATE,
FCHECKERID,
FRETURNERID
)
VALUES
(
'{Guid.NewGuid().ToStringEx()}',
'{head.Key}',
'{head.Value.FBILLTYPEID}',
'{head.Value.FBILLNO}',
'{head.Value.FDATE}',
2,
'{head.Value.FSRCFORMID}',
'{head.Value.FSRCBILLNO}',
'{head.Value.FDEPTID}',
'{head.Value.FSUPPLYID}',
'{head.Value.FCOMPANYID}',
{40},
GETDATE(),
'{LoginInfo.UserID}',
GETDATE(),
'{LoginInfo.UserID}',
''
)";
exeSqlStrList.Add(sqlStr);
#endregion 表头信息
}
#endregion 创建中间表信息
#region 更新条码信息
//更新条码状态、仓库仓位信息
exeSqlStrList.AddRange(CheckBill.UpdateBarStatus(request.TranType, updateBarcodeList));
#endregion
#region 创建同步队列
List<string> needNowSyn = new List<string>();
dicHead
.Where(o => o.Value.FISSYNTOERP)
.ForEach(p =>
{
exeSqlStrList.Add(CheckBill.GetSynTask(request.TranType, p.Value.FBILLNO, p.Key, p.Value.FISNOWSYNERP));
if (p.Value.FISNOWSYNERP)
{
needNowSyn.Add(p.Key);
}
});
#endregion 创建同步队列
#region 执行事务操作
try
{
await context.Database.BeginTransactionAsync();
//执行SQL
context.Database.SqlQuery(exeSqlStrList);
await context.Database.CommitTransactionAsync();
}
catch (Exception ex)
{
await context.Database.RollbackTransactionAsync();
jsonRet.Message = "执行事务操作异常," + ex.Message;
return jsonRet;
}
#endregion
#region WMS操作成功后,实时同步到ERP中
if (needNowSyn.Count > 0)
{
ToERPResult result = APPWmsCommonFunc.SubmitToERP(LoginInfo.DBAias, request.TranType, needNowSyn);
if (result == null || !result.ExecuteResult)
{
jsonRet.Status = 1;
jsonRet.Data.Add("data", $"WMS单号【{string.Join(";", dicHead.Select(o => o.Value.FBILLNO).ToList())}】委外退料成功,同步ERP失败:" + result.Message);
return jsonRet;
}
}
#endregion
#endregion
#region 返回值
jsonRet.Status = 1;
jsonRet.Data.Add("data", $"单号【{string.Join(";", dicHead.Select(o => o.Value.FBILLNO).ToList())}】委外退料成功.");
return await Task.Run(() => jsonRet);
#endregion
}
catch (Exception ex)
{
#region 异常处理
jsonRet.Status = 0;
jsonRet.Message = "委外退料异常," + ex.Message;
return jsonRet;
#endregion
}
}
}
}