Files

2114 lines
122 KiB
C#
Executable File

using Microsoft.EntityFrameworkCore.Update.Internal;
using Microsoft.Extensions.DependencyInjection;
using Newtonsoft.Json.Linq;
using Opsoft.Data;
using Opsoft.NetCore.O3App.Domain;
using Opsoft.NetCore.O3App.Domain.Interface;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.IPadReport.Model;
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 Org.BouncyCastle.Asn1.X509;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Tasks;
namespace Opsoft.NetCore.O3App.Repositories.WMS
{
[MapTo(typeof(ISelBillRepository), ServiceLifetime.Transient)]
public partial class SelBillRepository : RepositoryBase<BaseEntity>, ISelBillRepository
{
public SelBillRepository(ILogger<BaseEntity> logger) : base(logger)
{
}
/// <summary>
/// 查询出入库流程配置
/// </summary>
/// <param name="data">目标单据类型</param>
/// <returns></returns>
public async Task<List<BOS_SELBILL>> QuerySelBill(string orgID, string data)
{
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
string sql = @"SELECT
T01.FNAME
,T01.FNUMBER
,T01.FSOURCETRANTYPE AS FSRCFORMID
,CASE WHEN ISNULL(T02.FNAME,'')='' THEN '无源单' ELSE T02.FNAME END AS FSRCNAME
,UPPER(FDESTTRANTYPE) AS FTRANTYPE
,T03.FNAME AS FTRANTYPENAME
,T01.FISCONTROLQTY
,T01.FISOPENSOURCE
,T01.FDEFAULT
,T01.FCHECK
,T01.FKIND
,T01.FISWHOLEOUT
,T01.FISDEFAULTSTOCK
,T01.FISCHECKLOT
,T01.FISCHECKAUX
,T01.FISCHECKKFDATE
,T01.FCANSYNERP
,T01.FISUSECODERULE
,T01.FCHECKERPSTOCK
,T01.FINTERID
,T01.FCOMPANYID
,T01.UID
FROM T_BOS_SELBILL T01
LEFT JOIN SYS_BILLTEMPLATE T02 ON T01.FSOURCETRANTYPE = T02.FNUMBER
LEFT JOIN SYS_BILLTEMPLATE T03 ON T01.FDESTTRANTYPE = T03.FNUMBER
WHERE T01.FSTATUS = 40 AND T01.FISUSE=1 AND T01.FDELETED=0";
string sql2 = @"SELECT
T.FINTERID,
T.FSOURCEID,
T.FDESTID,
T.FDEFAULT,
T02.FNUMBER AS FSOURCENUMBER,
T02.FNAME AS FSOURCENAME,
T03.FNUMBER AS FDESTNUMBER,
T03.FNAME AS FDESTNAME
FROM T_BOS_SELBILLENTRY T
LEFT JOIN T_BOS_SELBILL T01 ON T.FINTERID = T01.FINTERID
LEFT JOIN T_BAS_BILLTYPE T02 ON T.FSOURCEID = T02.FINTERID
LEFT JOIN T_BAS_BILLTYPE T03 ON T.FDESTID = T03.FINTERID
WHERE 1=1 ";
if (!string.IsNullOrWhiteSpace(data))
{
sql += $" AND UPPER(T01.FDESTTRANTYPE)='{data.ToUpper()}' ORDER BY T01.FDEFAULT DESC";
sql2 += $" AND UPPER(T01.FDESTTRANTYPE)='{data.ToUpper()}' ORDER BY T.FDEFAULT DESC";
}
List<BOS_SELBILL> retData = await context.Database.SqlQueryAsync<BOS_SELBILL>(sql);
List<BOS_SELBILLENTRY> retData2 = await context.Database.SqlQueryAsync<BOS_SELBILLENTRY>(sql2);
if (retData != null && retData.Count > 0 && retData2 != null && retData2.Count > 0)
{
retData.ForEach(o =>
{
if (retData2.Exists(x => x.FINTERID == o.FINTERID))
{
o.FSELBILLENTRY.AddRange(retData2.Where(y => y.FINTERID == o.FINTERID));
}
else
{
o.FSELBILLENTRY = new List<BOS_SELBILLENTRY>();
}
});
}
return retData;
}
/// <summary>
/// 查询出入库流程配置
/// </summary>
/// <param name="data">目标单据类型</param>
/// <returns></returns>
public async Task<List<BOS_SELBILL>> QuerySelBill(APPServerContext context, string orgID, string data)
{
string sql = @"SELECT
T01.FNAME
,T01.FNUMBER
,T01.FSOURCETRANTYPE AS FSRCFORMID
,CASE WHEN ISNULL(T02.FNAME,'')='' THEN '无源单' ELSE T02.FNAME END AS FSRCNAME
,UPPER(FDESTTRANTYPE) AS FTRANTYPE
,T03.FNAME AS FTRANTYPENAME
,T01.FISCONTROLQTY
,T01.FISOPENSOURCE
,T01.FDEFAULT
,T01.FCHECK
,T01.FKIND
,T01.FISWHOLEOUT
,T01.FISDEFAULTSTOCK
,T01.FISCHECKLOT
,T01.FISCHECKAUX
,T01.FISCHECKKFDATE
,T01.FCANSYNERP
,T01.FISUSECODERULE
,T01.FCHECKERPSTOCK
,T01.FINTERID
,T01.FCOMPANYID
,T01.UID
FROM T_BOS_SELBILL T01
LEFT JOIN SYS_BILLTEMPLATE T02 ON T01.FSOURCETRANTYPE = T02.FNUMBER
LEFT JOIN SYS_BILLTEMPLATE T03 ON T01.FDESTTRANTYPE = T03.FNUMBER
WHERE T01.FSTATUS = 40 AND T01.FISUSE=1 AND T01.FDELETED=0";
string sql2 = @"SELECT
T.FINTERID,
T.FSOURCEID,
T.FDESTID,
T.FDEFAULT,
T02.FNUMBER AS FSOURCENUMBER,
T02.FNAME AS FSOURCENAME,
T03.FNUMBER AS FDESTNUMBER,
T03.FNAME AS FDESTNAME
FROM T_BOS_SELBILLENTRY T
LEFT JOIN T_BOS_SELBILL T01 ON T.FINTERID = T01.FINTERID
LEFT JOIN T_BAS_BILLTYPE T02 ON T.FSOURCEID = T02.FINTERID
LEFT JOIN T_BAS_BILLTYPE T03 ON T.FDESTID = T03.FINTERID
WHERE 1=1 ";
if (!string.IsNullOrWhiteSpace(data))
{
sql += $" AND UPPER(T01.FDESTTRANTYPE)='{data.ToUpper()}' ORDER BY T01.FDEFAULT DESC";
sql2 += $" AND UPPER(T01.FDESTTRANTYPE)='{data.ToUpper()}' ORDER BY T.FDEFAULT DESC";
}
List<BOS_SELBILL> retData = await context.Database.SqlQueryAsync<BOS_SELBILL>(sql);
List<BOS_SELBILLENTRY> retData2 = await context.Database.SqlQueryAsync<BOS_SELBILLENTRY>(sql2);
if (retData != null && retData.Count > 0 && retData2 != null && retData2.Count > 0)
{
retData.ForEach(o =>
{
if (retData2.Exists(x => x.FINTERID == o.FINTERID))
{
o.FSELBILLENTRY.AddRange(retData2.Where(y => y.FINTERID == o.FINTERID));
}
else
{
o.FSELBILLENTRY = new List<BOS_SELBILLENTRY>();
}
});
}
return retData;
}
/// <summary>
/// 扫描源单编号,查询源单信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public async Task<RetMessage> QuerySourceBillInfo(JObject data)
{
string retData = string.Empty;
RetMessage jsonRet = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
#region 校验参数是否正确
string sourceTranType = data["sourceTranType"].ToStringEx().ToUpper();
string sourceBillNo = data["sourceBillNO"].ToStringEx();
string tranType = data["tranType"].ToStringEx().ToUpper();
string orgID = data["orgID"].ToStringEx();
switch (sourceTranType.ToUpper())
{
case "SP_INSTOCK": //简单生产入库
case "SP_OUTSTOCK": //简单生产退库
break;
default:
{
if (sourceTranType.IsNullOrWhiteSpace())
{
jsonRet.Message = "传参类型错误,源单类型信息为空";
return jsonRet;
}
break;
}
}
if (sourceBillNo.IsNullOrWhiteSpace())
{
jsonRet.Message = "传参类型错误,源单编号信息为空";
return jsonRet;
}
if (tranType.IsNullOrWhiteSpace())
{
jsonRet.Message = "传参类型错误,目标单据信息为空";
return jsonRet;
}
#endregion
#region 检验源单为(收料通知单/发货通知单)是否已全部生成检验单并且检验合格
//获取系统配置:是否使用WMS检验流程
Hashtable PBCursor = context.PBValue("FUSEWMS_QMFLOW,L,;");
//是否使用WMS检验流程
if (PBCursor["FUSEWMS_QMFLOW"].ToBoolean())
{
switch (sourceTranType.ToUpper())
{
case "PUR_RECEIVEBILL"://收料通知单
DataTable T_PUR_RECEIVEENTRY = context.Database.SqlQuery($@"SELECT T01.* FROM T_PUR_RECEIVEENTRY T01
LEFT JOIN T_PUR_RECEIVE T02 ON T02.FINTERID=T01.FINTERID
WHERE T02.FBILLNO='{sourceBillNo}'");
for (int i = 0; i < T_PUR_RECEIVEENTRY.Rows.Count; i++)
{
DataRow bd = T_PUR_RECEIVEENTRY.Rows[i];
if (bd["FCHECKINCOMING"].ToBoolean() == true)//是否来料检验
{
DataTable T_BD_QM_CL = context.Database.SqlQuery($@"SELECT * FROM T_BD_QM_CL
WHERE FSRCBILLNO='{sourceBillNo}'
AND FSRCENTRYID='{bd["FENTRYID"].ToStringEx()}'
AND FLAUTYPE='1'");
if (T_BD_QM_CL.Rows.Count == 0)
{
jsonRet.Message = "该收料通知单存在未生成检验单,无法入库";
return jsonRet;
}
}
}
break;
case "SAL_DELIVERYNOTICE"://发货通知单
DataTable T_SAL_DELIVERYNOTICEENTRY = context.Database.SqlQuery($@"SELECT T01.* FROM T_SAL_DELIVERYNOTICEENTRY T01
LEFT JOIN T_SAL_DELIVERYNOTICE T02 ON T02.FINTERID=T01.FINTERID
WHERE T02.FBILLNO='{sourceBillNo}'");
for (int i = 0; i < T_SAL_DELIVERYNOTICEENTRY.Rows.Count; i++)
{
DataRow bd = T_SAL_DELIVERYNOTICEENTRY.Rows[i];
if (bd["FCHECKSENDING"].ToBoolean() == true)//是否发货检验
{
DataTable T_BD_QM_CL = context.Database.SqlQuery($@"SELECT * FROM T_BD_QM_CL
WHERE FSRCBILLNO='{sourceBillNo}'
AND FSRCENTRYID='{bd["FENTRYID"].ToStringEx()}'
AND FLAUTYPE='4'");
if (T_BD_QM_CL.Rows.Count == 0)
{
jsonRet.Message = "该发货通知单存在未生成检验单,无法发货";
return jsonRet;
}
}
}
break;
}
}
#endregion
#region 查询源单信息
List<SOURCEBILLINFO> sourceList = await context.Database.SqlQueryAsync<SOURCEBILLINFO>(CheckBill.GetSoureBillData(orgID, tranType, sourceTranType, sourceBillNo));
if (sourceList == null || sourceList.Count <= 0)
{
jsonRet.Message = "源单信息未找到";
return jsonRet;
}
if (tranType.ToUpper() == "PRD_INSTOCK")
{
List<SOURCEBILLINFO> hisSourceBill = sourceList.Where(o => o.FBSTATUS >= 4).ToList();
if (hisSourceBill == null || hisSourceBill.Count <= 0)
{
jsonRet.Message = "生产入库异常:" + "源单【" + sourceBillNo + "】中没有已经开工的订单!";
return jsonRet;
}
}
jsonRet.Data.Add("data1", sourceList);
dynamic billList;
switch (tranType)
{
case "SUB_PICKMTRL"://委外领料
case "PRD_PICKMTRL"://生产领料
case "PRD_FEEDMTRL"://生产补料
billList = sourceList.Select(p => new
{
p.FSRCBILLNO,
p.FMOBILLNO,
p.FMOENTRYID,
p.FCUSTID,
p.FCUSTNAME,
p.FDEPTID,
p.FDEPTNAME,
p.FSUPPLYID,
p.FSUPPLYNAME,
p.FPPBOMBILLNO,
p.FPRODUCTNUMBER,
p.FPRODUCTNAME,
p.FPRODUCTSPEC
}).Distinct().ToList();
jsonRet.Data.Add("data2", billList);
break;
case "SUB_RETURNMTRL"://委外退料
case "PRD_RETURNMTRL"://生产退料
billList = sourceList.Select(p => new
{
p.FSRCBILLNO,
p.FMOBILLNO,
p.FMOENTRYID,
p.FCUSTID,
p.FCUSTNAME,
p.FDEPTID,
p.FDEPTNAME,
p.FSUPPLYID,
p.FSUPPLYNAME,
p.FPPBOMBILLNO,
p.FPRODUCTNUMBER,
p.FPRODUCTNAME,
p.FPRODUCTSPEC
}).Distinct().ToList();
jsonRet.Data.Add("data2", billList);
break;
case "STK_OEMPICK"://受托领料
case "STK_OEMRETURNSTOCK"://受托退料
billList = sourceList.Select(p => new
{
p.FSRCBILLNO,
p.FMOBILLNO,
p.FMOENTRYID,
p.FCUSTID,
p.FCUSTNAME,
p.FDEPTID,
p.FDEPTNAME,
p.FSUPPLYID,
p.FSUPPLYNAME
}).Distinct().ToList();
jsonRet.Data.Add("data2", billList);
break;
case "STK_TRANSFERMANAGE"://调拨管理
//调拨管理的源单为生产订单和委外订单时,有行号选择
if (sourceTranType.ToUpper() == "PRD_MO" || sourceTranType.ToUpper() == "SUB_SUBREQORDER")
{
billList = sourceList.Select(p => new
{
p.FSRCBILLNO,
p.FMOBILLNO,
p.FMOENTRYID,
p.FCUSTID,
p.FCUSTNAME,
p.FDEPTID,
p.FDEPTNAME,
p.FSUPPLYID,
p.FSUPPLYNAME,
p.FPPBOMBILLNO,
p.FPRODUCTNUMBER,
p.FPRODUCTNAME,
p.FPRODUCTSPEC
}).Distinct().ToList();
jsonRet.Data.Add("data2", billList);
}
else
{
jsonRet.Data.Add("data2", sourceList.Select(p => new
{
p.FSRCBILLNO,
p.FMOBILLNO,
p.FMOENTRYID
}).Distinct().ToList());
}
break;
default:
var templist = sourceList.Select(p => new
{
p.FSRCBILLNO,
p.FMOBILLNO,
p.FMOENTRYID
}).Distinct().ToList();
jsonRet.Data.Add("data2", templist);
break;
}
#endregion
#region 返回值
jsonRet.Status = 1;
return jsonRet;
#endregion
}
/// <summary>
/// 扫描条码信息,验证条码状态
/// </summary>
public async Task<RetMessage> QueryBarCode(JObject data)
{
RetMessage jsonRet = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
#region 校验参数是否正确
DateTime? usefulDate = new DateTime();
string barcode = data["barCodeNum"].ToStringEx().Trim();
bool isExit = data["isExit"].ToBoolean();//是否已扫描
bool isHaveSource = data["isHaveSource"].ToBoolean();
int sourceEntryID = data["sourceEntryID"].ToInt();
string sourceBillNO = data["sourceBillNO"].ToStringEx();
string sourceTranType = data["sourceTranType"].ToStringEx();
string tranType = data["tranType"].ToStringEx().ToUpper();
string orgID = data["orgID"].ToStringEx();
string OwnerID = data["OwnerID"].ToStringEx();
string OwnerTypeID = data["OwnerTypeID"].ToStringEx();
List<BOS_SELBILL> selBillList = await QuerySelBill(context, orgID, tranType);
if (selBillList == null || selBillList.Count <= 0)
{
jsonRet.Message = "出入库流程信息未找到";
return jsonRet;
}
BOS_SELBILL selBill = selBillList.FirstOrDefault(o => o.FSRCFORMID == sourceTranType);
if (selBill == null)
{
jsonRet.Message = $"源单类型【{(sourceTranType.IsNullOrEmpty() ? "无源单" : sourceTranType)}】在出入库流程信息未找到";
return jsonRet;
}
bool isOpenSource = selBill.FISOPENSOURCE;
if (isHaveSource && isOpenSource && string.IsNullOrEmpty(sourceBillNO))
{
jsonRet.Message = "开放源单时,源单编号必录";
return jsonRet;
}
#endregion
#region 条码解析
barcode = GetAnalysisBarCode(context, barcode, tranType);
//if (selBill.FISUSECODERULE)
//{
//}
#endregion
#region 检查当前条码是否已盘点
if (tranType.Equals("STK_STOCKDIFF"))
{
DataTable checkDt = context.Database.SqlQuery($@"SELECT S.UID
FROM T_STK_STOCKSCHEMEENTRY3 S
JOIN T_STK_STOCKSCHEME B ON S.FINTERID=B.FINTERID
WHERE B.FBILLNO='{sourceBillNO}' AND S.FBARCODE='{barcode}'");
if (checkDt != null && checkDt.Rows.Count > 0)
{
jsonRet.Message = "该条码已被盘点";
return jsonRet;
}
}
#endregion
#region 抓取条码信息
string sql = $@"SELECT
S.FCOMPANYID
,S.FSECUNITQTY --辅助单位数量
,S.FSECUNITID --辅助单位
,S.FOWNERTYPEID
,S.FOWNERID
,S13.FNAME AS FOWNERNAME
,S.FKEEPERTYPEID
,S.FKEEPERID
,S.FBARCODE--条码
,S.FDELETED--是否禁用
,S.FKFDATE--保质日期
,S.FUSEFULDATE--有效期至
,S3.FKFPERIOD--保质天数
,S3.FKFUNIT--保质期单位
,S.FAUXPROPID--辅助属性
,S.FINBOX--被装箱
,S.FISBOX--箱码
,S.FQTY--数量
,S.FBASEQTY--基本数量
,S.FUNITID--单位内码
,S.FBARTYPE--条码类型
,S.FBARCODESTATUS--条码状态(1=初始;2=收料)
,S.FSTOCKSTATUS--库存状态(0.未入库 1.已入库 2.生产领料出库 3.销售出库 4.其他出库 5.委外调拨 8.已折分 9.已合并 10.已废弃)
,S.FKID --打印来源(1=采购订单;2=生产订单;3=委外订单;4=库存;5=物料,A=生产订单)
,S.FLOT--批次
,S.FMATERIALID--物料内码
,S3.FNUMBER AS FITEMNUMBER --物料代码
,S3.FNAME AS FITEMNAME--物料名称
,S3.FISSECUNIT --启用辅助单位
,S3.FISBATCHMANAGE--启用批次管理
,S3.FISKFPERIOD--启用保质期管理
,S3.FSPECIFICATION --规格型号
,S3.FERPCLSID --物料属性
,S3.FSUITE --是否套件
,S3.FSTATUS AS FITEMSTATUS --物料状态
,S3.FDELETED AS FITEMDELETED --物料是否禁用
,S4.FNAME AS FUNITNAME--单位名称
,S.FBASEUNITID--基本单位
,S5.FNUMBER AS FBASEUNITNUMBER--基本单位代码
,S5.FNAME AS FBASEUNITNAME--基本单位名称
,S6.FINTERID AS FSUPPLYID --供应商
,S6.FNUMBER AS FSUPPLYNUMBER--供应商代码
,S6.FNAME AS FSUPPLYNAME --供应商名称
,S.FSTOCKID--仓库
,S.FSTOCKLOCID--仓位
,S7.FNUMBER AS FSCSTOCKNUMBER --仓库代码
,S7.FISOPENLOCATION --启用仓位管理
,S8.FNUMBER AS FSCSPNUMBER --仓位代码
,S10.FNAME AS FORGNAME
,S11.FNAME AS FAUXPROPNAME
,S.FSTOCKSTATUSID,S3.FENBOMID -- 是否启用BOM版本
,S12.FNAME AS FSTOCKSTATUSNAME
,S.FBOMID --BOM版本
,isnull(Y.FMODELNO,'') as FMODELNO --车号
,S12.FTYPE,S12.FAVAILABLE,S12.FNOTSALE,S12.FNOTGET --库存状态:可使用、不可销售、不可以领用
FROM T_BD_BARCODERS S
LEFT JOIN T_BD_MATERIAL S3(NOLOCK) ON S.FMATERIALID =S3.FINTERID
LEFT JOIN T_BD_UNIT S4 ON S.FUNITID = S4.FINTERID
LEFT JOIN T_BD_BARCODERS2 Y ON S.FBARCODE = Y.FBARCODE
LEFT JOIN T_BD_UNIT S5 ON S.FBASEUNITID = S5.FINTERID
LEFT JOIN T_BD_SUPPLIER S6 ON S.FSUPPLYID=S6.FINTERID
LEFT JOIN T_BD_STOCK S7 ON S.FSTOCKID = S7.FINTERID
LEFT JOIN T_BAS_FLEXVALUESDETAIL S8 ON S.FSTOCKLOCID = S8.FINTERID
LEFT JOIN SYS_ORGSTRUCTURE S10 on S.FCOMPANYID = S10.FINTERID
LEFT JOIN T_BD_FLEXSITEMDETAILV S11 on S.FAUXPROPID = S11.FINTERID
LEFT JOIN T_BD_STOCKSTATUS S12 ON S.FSTOCKSTATUSID = S12.FNUMBER
LEFT JOIN SYS_ORGSTRUCTURE S13 on S.FOWNERID = S13.FINTERID
WHERE S.FBARCODE = '{barcode}'";
DataTable myTable = context.Database.SqlQuery(sql);
myTable.CaseSensitive = false;
if (myTable == null || myTable.Rows.Count <= 0)
{
jsonRet.Message = $"条码【{barcode}】信息未找到";
return jsonRet;
}
if (myTable.Rows.Count > 1)
{
jsonRet.Message = $"条码【{barcode}】信息存在多条";
return jsonRet;
}
if (myTable.Rows[0]["FDELETED"].ToBoolean())
{
jsonRet.Message = $"条码【{barcode}】已禁用";
return jsonRet;
}
if (myTable.Rows[0]["FQTY"].ToDecimal() <= 0)
{
jsonRet.Message = $"条码【{barcode}】数量不能小于等于零";
return jsonRet;
}
if (myTable.Rows[0]["FBASEQTY"].ToDecimal() <= 0)
{
jsonRet.Message = $"条码【{barcode}】基本单位数量不能小于等于零";
return jsonRet;
}
if (myTable.Rows[0]["FSUITE"].ToBoolean())
{
jsonRet.Message = $"条码【{barcode}】对应的产品类型为套件";
return jsonRet;
}
if (myTable.Rows[0]["FITEMSTATUS"].ToInt() != 40)
{
jsonRet.Message = $"条码【{barcode}】对应的产品未审核";
return jsonRet;
}
if (myTable.Rows[0]["FITEMDELETED"].ToBoolean())
{
jsonRet.Message = $"条码【{barcode}】对应的产品已禁用";
return jsonRet;
}
if (myTable.Rows[0]["FISSECUNIT"].ToBoolean() && myTable.Rows[0]["FSECUNITQTY"].ToDecimal() <= 0)
{
jsonRet.Message = $"条码【{barcode}】已启用辅助单位,辅助单位数量不能小于等于零!";
return jsonRet;
}
if (myTable.Rows[0]["FOWNERTYPEID"].ToStringEx().IsNullOrEmpty())
{
jsonRet.Message = $"条码【{barcode}】对应的货主类型为空";
return jsonRet;
}
else
{
//原单类型为原单,且目标单据为其他入库单/其他出库单/调拨单,控制条码的货主和货主类型与条码的一致
//2024-05-30 客户自定义:其他入库货主与货主类型是否一致校验取消 tranType.ToUpperEx() == "STK_MISCELLANEOUS" ||
if (sourceTranType == "" && (tranType.ToUpperEx() == "STK_MISDELIVERY" || tranType.ToUpperEx() == "STK_TRANSFERMANAGE")&& myTable.Rows[0]["FOWNERTYPEID"].ToStringEx().ToUpperEx()!=OwnerTypeID.ToUpperEx())
{
jsonRet.Message = $"条码【{barcode}】对应的货主类型【{myTable.Rows[0]["FOWNERTYPEID"].ToStringEx()}】与表头选择的货主类型【{OwnerTypeID}】不一致";
return jsonRet;
}
}
if (myTable.Rows[0]["FOWNERID"].ToStringEx().IsNullOrEmpty())
{
jsonRet.Message = $"条码【{barcode}】对应的货主为空";
return jsonRet;
}
else
{
//原单类型为原单,且目标单据为其他入库单/其他出库单/调拨单,控制条码的货主和货主类型与条码的一致 tranType.ToUpperEx() == "STK_MISCELLANEOUS" ||
if (sourceTranType == "" && (tranType.ToUpperEx() == "STK_MISDELIVERY" || tranType.ToUpperEx() == "STK_TRANSFERMANAGE") && myTable.Rows[0]["FOWNERID"].ToStringEx() != OwnerID)
{
jsonRet.Message = $"条码【{barcode}】对应的货主与与表头选择的货主不一致";
return jsonRet;
}
}
if (myTable.Rows[0]["FKEEPERTYPEID"].ToStringEx().IsNullOrEmpty())
{
jsonRet.Message = $"条码【{barcode}】对应的保管者类型为空";
return jsonRet;
}
if (myTable.Rows[0]["FKEEPERID"].ToStringEx().IsNullOrEmpty())
{
jsonRet.Message = $"条码【{barcode}】对应的保管者为空";
return jsonRet;
}
if (tranType.Equals("SP_INSTOCK"))
{
if (myTable.Rows[0]["FERPCLSID"].ToInt() != 2)
{
jsonRet.Message = $"条码【{barcode}】对应的产品类型非自制";
return jsonRet;
}
}
string barcodeOrg = myTable.Rows[0]["FCOMPANYID"].ToStringEx();
if (orgID.IsNullOrEmpty())
{
if (!barcodeOrg.IsNullOrEmpty())
{
jsonRet.Message = $"组织异常,条码【{barcode}】创建组织为【{myTable.Rows[0]["FORGNAME"].ToStringEx()}】!";
return jsonRet;
}
}
else
{
if (!orgID.Equals(barcodeOrg))
{
jsonRet.Message = $"组织异常,条码【{barcode}】创建组织为【{myTable.Rows[0]["FORGNAME"].ToStringEx()}】!";
return jsonRet;
}
if (tranType.ToUpperEx().Equals("PRD_PICKMTRL"))
{
if (!myTable.Rows[0]["FOWNERID"].ToStringEx().Equals(orgID))
{
jsonRet.Message = $"货主异常,条码【{barcode}】货主为【{myTable.Rows[0]["FOWNERNAME"].ToStringEx()}】与当前组织不一致!";
return jsonRet;
}
}
}
#endregion
#region 条码基础状态判断
if (!int.TryParse(myTable.Rows[0]["FSTOCKSTATUS"].ToString(), out int barcodeStatus))
{
jsonRet.Message = $"条码【{barcode}】库存状态未定义";
return jsonRet;
}
if (!bool.TryParse(myTable.Rows[0]["FISBOX"].ToString(), out bool barcodeIsBox))
{
jsonRet.Message = $"条码【{barcode}】是否箱码未定义";
return jsonRet;
}
if (!bool.TryParse(myTable.Rows[0]["FINBOX"].ToString(), out bool barcodeInBox))
{
jsonRet.Message = $"条码【{barcode}】装箱状态未定义";
return jsonRet;
}
if (int.TryParse(myTable.Rows[0]["FBARTYPE"].ToString(), out int barcodeType))
{
if (barcodeType != 1 && barcodeType != 2 && barcodeType != 3)
{
barcodeType = 2;
}
switch (barcodeType)
{
case 1:
case 2:
if (isExit)
{
jsonRet.Message = $"条码【{barcode}】已扫描!";
return jsonRet;
}
if (barcodeInBox)
{
jsonRet.Message = $"条码【{barcode}】已入箱!";
return jsonRet;
}
string retMsg = CheckBill.CheckBarCodeStatus(tranType, barcodeStatus, barcode, sourceTranType);//校验条码出入库状态
if (!string.IsNullOrEmpty(retMsg))
{
throw new O3AppException(retMsg);
}
if (barcodeStatus == 1)
{
if (myTable.Rows[0]["FSTOCKSTATUSID"].ToString().IsNullOrWhiteSpace())
{
jsonRet.Message = $"条码【{barcode}】仓库库存状态未定义";
return jsonRet;
}
else
{
if (!APPWmsCommonFunc.CkeckFStockStatusId(tranType, myTable.Rows[0]["FTYPE"].ToString(), myTable.Rows[0]["FAVAILABLE"].ToBoolean(),
myTable.Rows[0]["FNOTSALE"].ToBoolean(), myTable.Rows[0]["FNOTGET"].ToBoolean(), out string msg))
{
jsonRet.Message = $"条码【{barcode}】" + msg;
return jsonRet;
}
}
}
break;
case 3:
if (isExit && barcodeIsBox)
{
jsonRet.Message = $"条码【{barcode}】已扫描!";
return jsonRet;
}
break;
}
}
else
{
jsonRet.Message = $"条码【{barcode}】类别未定义";
return jsonRet;
}
if (!bool.TryParse(myTable.Rows[0]["FISBATCHMANAGE"].ToString(), out bool isBatchmanager))
{
jsonRet.Message = $"条码【{barcode}】是否启用批次管理未定义";
return jsonRet;
}
if (isBatchmanager && string.IsNullOrEmpty(myTable.Rows[0]["FLOT"].ToString()))
{
jsonRet.Message = $"条码【{barcode}】已启用批次管理,批次号为空";
return jsonRet;
}
if (!bool.TryParse(myTable.Rows[0]["FISKFPERIOD"].ToString(), out bool isKFPeriod))
{
jsonRet.Message = $"条码【{barcode}】是否启用保质期未定义";
return jsonRet;
}
if (!barcodeIsBox)
{
if (isKFPeriod)
{
if (!CheckDateTime.IsDate(myTable.Rows[0]["FKFDATE"].ToStringEx()))
{
jsonRet.Message =
$"条码中物料【{myTable.Rows[0]["FITEMNUMBER"].ToString()}】物料启用保质期管理,但保质期日期信息为空!";
return jsonRet;
}
if (myTable.Rows[0]["FKFPERIOD"].ToInt() == 0)
{
jsonRet.Message = $"条码【{barcode}】物料保质期限未设定!";
return jsonRet;
}
if (!CheckDateTime.IsDate(myTable.Rows[0]["FUSEFULDATE"].ToStringEx()))
{
usefulDate = GetExpiryDate(context, myTable.Rows[0]["FKFDATE"].ToStringEx().ToDateTime(), myTable.Rows[0]["FKFUNIT"].ToInt(), myTable.Rows[0]["FKFPERIOD"].ToInt());
}
else
{
usefulDate = myTable.Rows[0]["FUSEFULDATE"].ToStringEx().ToDateTime();
}
}
else
{
usefulDate = null;
}
}
#region 盘点时,验证条码仓库仓位信息
if (tranType.Equals("STK_STOCKDIFF"))
{
DataTable checkDt = context.Database.SqlQuery($@"SELECT S.UID
FROM T_STK_STOCKSCHEME S
LEFT JOIN T_BD_STOCK S1 ON S.FSTOCKID=S1.FINTERID
LEFT JOIN T_BD_STOCK S2 ON S.FSTOCKIDTO=S2.FINTERID
LEFT JOIN T_BD_MATERIAL M1 ON S.FMATERIALID=M1.FINTERID
LEFT JOIN T_BD_MATERIAL M2 ON S.FMATERIALIDTO=M2.FINTERID
WHERE S.FBILLNO='{sourceBillNO}' AND '{myTable.Rows[0]["FSCSTOCKNUMBER"].ToStringEx()}' BETWEEN S1.FNUMBER AND S2.FNUMBER
AND (ISNULL(S.FMATERIALID,'')='' OR M1.FNUMBER<='{myTable.Rows[0]["FITEMNUMBER"].ToStringEx()}')
AND (ISNULL(S.FMATERIALIDTO,'')='' OR M2.FNUMBER>='{myTable.Rows[0]["FITEMNUMBER"].ToStringEx()}') ");
if (checkDt == null || checkDt.Rows.Count <= 0)
{
jsonRet.Message = "该条码不在此盘点方案规定的仓库或者物料范围内";
return jsonRet;
}
}
#endregion
#region 查询条码源单信息
int sourceSec = 0;
string sourceID = string.Empty, sourceDetailID = string.Empty, sourceNO = string.Empty;
DataTable sourceDT = null;
//源码信息添加
object srcInfo = null;
if (isHaveSource && !tranType.Equals("STK_STOCKDIFF"))//盘点的不做源单处理
{
if (!isOpenSource)
{
#region 未开放源单时,查询条码源单信息
switch (myTable.Rows[0]["FKID"].ToString())
{//1=采购订单;2=生产订单;3=委外订单;4=库存;5=物料;6受托加工收料
case "1":
{
sourceDT = context.Database.SqlQuery($"SELECT * FROM T_BD_BARCODERS1 WHERE FBARCODE='{barcode}'");
if (sourceDT != null && sourceDT.Rows.Count > 0)
{
//判断源单类型
if (sourceTranType.ToUpper() == "PUR_RECEIVEBILL")
{
sourceSec = sourceDT.Rows[0]["FPURENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FPURBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FPURID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FPURDETAILID"].ToStringEx();
}
else
{
sourceSec = sourceDT.Rows[0]["FPOENTREYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FPOBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FPOID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FPODETAILID"].ToStringEx();
}
srcInfo = new BD_BARCODERS1
{
FPOID = sourceDT.Rows[0]["FPOID"].ToStringEx(),
FPOENTREYID = sourceDT.Rows[0]["FPOENTREYID"].ToInt(),
FPOBILLNO = sourceDT.Rows[0]["FPOBILLNO"].ToStringEx(),
FPODETAILID = sourceDT.Rows[0]["FPODETAILID"].ToStringEx(),
FPURID = sourceDT.Rows[0]["FPURID"].ToStringEx(),
FPURBILLNO = sourceDT.Rows[0]["FPURBILLNO"].ToStringEx(),
FPURENTRYID = sourceDT.Rows[0]["FPURENTRYID"].ToInt(),
FPURDETAILID = sourceDT.Rows[0]["FPURDETAILID"].ToStringEx(),
FSUPPLIERID = sourceDT.Rows[0]["FSUPPLIERID"].ToStringEx(),
FINSPECTID = sourceDT.Rows[0]["FINSPECTID"].ToStringEx(),
FINSPECTDATE = sourceDT.Rows[0]["FINSPECTDATE"].ToDateTime()
};
}
}
break;
case "2":
case "A":
{
sourceDT = context.Database.SqlQuery($"SELECT * FROM T_BD_BARCODERS2 WHERE FBARCODE='{barcode}'");
if (sourceDT != null && sourceDT.Rows.Count > 0)
{
switch (sourceTranType.ToUpper())
{
case "PRD_MO"://生产任务单
sourceSec = sourceDT.Rows[0]["FMOENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FMOBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FMOID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FMODETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS2
{
FMOID = sourceDT.Rows[0]["FMOID"].ToStringEx(),
FMOBILLNO = sourceDT.Rows[0]["FMOBILLNO"].ToStringEx(),
FMOENTRYID = sourceDT.Rows[0]["FMOENTRYID"].ToInt(),
FMODETAILID = sourceDT.Rows[0]["FMODETAILID"].ToStringEx(),
FCUSTID = sourceDT.Rows[0]["FCUSTID"].ToStringEx(),
FODID = sourceDT.Rows[0]["FODID"].ToStringEx(),
FODDETAILID = sourceDT.Rows[0]["FODDETAILID"].ToStringEx(),
FODENTRYID = sourceDT.Rows[0]["FODENTRYID"].ToInt()
};
break;
case "PRD_MORPT"://生产汇报单
sourceSec = sourceDT.Rows[0]["FREPORTENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FREPORTBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FREPORTID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FREPORTDETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS2
{
FREPORTENTRYID = sourceDT.Rows[0]["FREPORTENTRYID"].ToInt(),
FREPORTBILLNO = sourceDT.Rows[0]["FREPORTBILLNO"].ToStringEx(),
FREPORTID = sourceDT.Rows[0]["FREPORTID"].ToStringEx(),
FREPORTDETAILID = sourceDT.Rows[0]["FREPORTDETAILID"].ToStringEx(),
FMOID = sourceDT.Rows[0]["FMOID"].ToStringEx(),
FMOBILLNO = sourceDT.Rows[0]["FMOBILLNO"].ToStringEx(),
FMOENTRYID = sourceDT.Rows[0]["FMOENTRYID"].ToInt(),
FMODETAILID = sourceDT.Rows[0]["FMODETAILID"].ToStringEx(),
FCUSTID = sourceDT.Rows[0]["FCUSTID"].ToStringEx(),
FODID = sourceDT.Rows[0]["FODID"].ToStringEx(),
FODDETAILID = sourceDT.Rows[0]["FODDETAILID"].ToStringEx(),
FODENTRYID = sourceDT.Rows[0]["FODENTRYID"].ToInt()
};
break;
case "SFC_OPTRPT"://工序汇报单
sourceSec = sourceDT.Rows[0]["FREPORTENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FREPORTBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FREPORTID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FREPORTDETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS2
{
FREPORTENTRYID = sourceDT.Rows[0]["FREPORTENTRYID"].ToInt(),
FREPORTBILLNO = sourceDT.Rows[0]["FREPORTBILLNO"].ToStringEx(),
FREPORTID = sourceDT.Rows[0]["FREPORTID"].ToStringEx(),
FREPORTDETAILID = sourceDT.Rows[0]["FREPORTDETAILID"].ToStringEx(),
FMOID = sourceDT.Rows[0]["FMOID"].ToStringEx(),
FMOBILLNO = sourceDT.Rows[0]["FMOBILLNO"].ToStringEx(),
FMOENTRYID = sourceDT.Rows[0]["FMOENTRYID"].ToInt(),
FMODETAILID = sourceDT.Rows[0]["FMODETAILID"].ToStringEx(),
FCUSTID = sourceDT.Rows[0]["FCUSTID"].ToStringEx(),
FODID = sourceDT.Rows[0]["FODID"].ToStringEx(),
FODDETAILID = sourceDT.Rows[0]["FODDETAILID"].ToStringEx(),
FODENTRYID = sourceDT.Rows[0]["FODENTRYID"].ToInt()
};
break;
}
}
}
break;
case "3":
{
sourceDT = context.Database.SqlQuery($"SELECT * FROM T_BD_BARCODERS3 WHERE FBARCODE='{barcode}'");
if (sourceDT != null && sourceDT.Rows.Count > 0)
{
sourceSec = sourceDT.Rows[0]["FREQENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FREQBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FREQID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FREQDETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS3
{
FREQID = sourceDT.Rows[0]["FREQID"].ToStringEx(),
FREQBILLNO = sourceDT.Rows[0]["FREQBILLNO"].ToStringEx(),
FREQENTRYID = sourceDT.Rows[0]["FREQENTRYID"].ToInt(),
FREQDETAILID = sourceDT.Rows[0]["FREQDETAILID"].ToStringEx()
};
}
}
break;
case "6":
{
sourceDT = context.Database.SqlQuery($"SELECT * FROM T_BD_BARCODERS5 WHERE FBARCODE='{barcode}'");
if (sourceDT != null && sourceDT.Rows.Count > 0)
{
sourceSec = sourceDT.Rows[0]["FOEMRECEIVEENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FOEMRECEIVEBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FOEMRECEIVEID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FOEMRECEIVEDETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS5
{
FOEMRECEIVEID = sourceDT.Rows[0]["FOEMRECEIVEID"].ToStringEx(),
FOEMRECEIVEBILLNO = sourceDT.Rows[0]["FOEMRECEIVEBILLNO"].ToStringEx(),
FOEMRECEIVEENTRYID = sourceDT.Rows[0]["FOEMRECEIVEENTRYID"].ToInt(),
FOEMRECEIVEDETAILID = sourceDT.Rows[0]["FOEMRECEIVEDETAILID"].ToStringEx(),
FOWNERID = sourceDT.Rows[0]["FOWNERID"].ToStringEx(),
FODID = sourceDT.Rows[0]["FODID"].ToStringEx(),
FODDETAILID = sourceDT.Rows[0]["FODDETAILID"].ToStringEx(),
FODENTRYID = sourceDT.Rows[0]["FODENTRYID"].ToInt(),
FODBILLNO = sourceDT.Rows[0]["FODBILLNO"].ToStringEx()
};
}
break;
}
}
if (string.IsNullOrEmpty(sourceNO))
{
jsonRet.Message = $"条码【{barcode}】中源单编号信息为空";
return jsonRet;
}
sourceBillNO = sourceNO;
#endregion
}
else
{
#region 开放源单时,未查到源单信息时使用扫描的源单编号
switch (myTable.Rows[0]["FKID"].ToString())
{//1=采购订单;2=生产订单;3=委外订单;4=库存;5=物料;6受托加工收料
case "1":
{
srcInfo = new BD_BARCODERS1();
break;
}
case "2":
case "A":
{
srcInfo = new BD_BARCODERS2();
break;
}
case "3":
case "4":
case "5":
{
srcInfo = new BD_BARCODERS3();
break;
}
case "6":
{
srcInfo = new BD_BARCODERS5();
break;
}
}
sourceNO = sourceBillNO;
sourceSec = sourceEntryID;
#endregion
}
}
#endregion
#region 默认带出仓库仓位
string strLocation = string.Empty, strFSCStockNumber = string.Empty, strFSCSPNumber = string.Empty;
if (selBill.FISDEFAULTSTOCK && !string.IsNullOrEmpty(myTable.Rows[0]["FSCSTOCKNUMBER"].ToString()))
{
Hashtable sysParams = context.PBValue("STOCKCHAR,C;FLEXCHAR,C;");
string stcokChar = sysParams["STOCKCHAR"].ToStringEx();
string valueChar = stcokChar ?? "-";
string flexChar = sysParams["FLEXCHAR"].ToStringEx();
flexChar ??= ".";
strLocation = (!myTable.Rows[0]["FISOPENLOCATION"].ToBoolean() || string.IsNullOrEmpty(myTable.Rows[0]["FSCSPNUMBER"].ToString())) ?
myTable.Rows[0]["FSCSTOCKNUMBER"].ToString() :
myTable.Rows[0]["FSCSTOCKNUMBER"].ToString() + valueChar + myTable.Rows[0]["FSCSPNUMBER"].ToString().Replace(".", flexChar);
strFSCStockNumber = myTable.Rows[0]["FSCSTOCKNUMBER"].ToString();
strFSCSPNumber = myTable.Rows[0]["FSCSPNUMBER"].ToString();
}
#endregion
BarCodeMsg<object> barCodeInfo = new BarCodeMsg<object>()
{
FSRCFORMID = selBill.FSRCFORMID,
FSRCNAME = selBill.FSRCNAME,
FSRCID = sourceID,
FSRCBILLNO = sourceNO,
FSRCENTRYID = sourceSec,
FSRCDETAILID = sourceDetailID,
FCOMPANYID = myTable.Rows[0]["FCOMPANYID"].ToString(),
FBARTYPE = barcodeType,
FISBOX = barcodeIsBox.ToInt(),
FBARCODE = barcode,
FMATERIALID = myTable.Rows[0]["FMATERIALID"].ToString(),
FITEMNUMBER = myTable.Rows[0]["FITEMNUMBER"].ToString(),
FITEMNAME = myTable.Rows[0]["FITEMNAME"].ToString(),
FSPECIFICATION = myTable.Rows[0]["FSPECIFICATION"].ToString(),
FLOT = myTable.Rows[0]["FLOT"].ToString(),
FAUXPROPID = myTable.Rows[0]["FAUXPROPID"].ToString(),
FAUXPROPNAME = myTable.Rows[0]["FAUXPROPNAME"].ToString(),
FISKFPERIOD = myTable.Rows[0]["FISKFPERIOD"].ToBoolean(),
FKFPERIOD = myTable.Rows[0]["FKFPERIOD"].ToInt(),
FKFDATE = myTable.Rows[0]["FKFDATE"].ToDateTime().ToStringEx("YMD"),
FUSEFULDATE = usefulDate.ToStringEx("YMD"),
FQTY = myTable.Rows[0]["FQTY"].ToDecimal(),
FUNITNAME = myTable.Rows[0]["FUNITNAME"].ToString(),
FUNITID = myTable.Rows[0]["FUNITID"].ToString(),
FBASEQTY = myTable.Rows[0]["FBASEQTY"].ToDecimal(),
FBASEUNITID = myTable.Rows[0]["FBASEUNITID"].ToString(),
FBASEUNITNUMBER = myTable.Rows[0]["FBASEUNITNUMBER"].ToString(),
FBASEUNITNAME = myTable.Rows[0]["FBASEUNITNAME"].ToString(),
FSTOCKID = myTable.Rows[0]["FSTOCKID"].ToString(),
FSTOCKLOCID = myTable.Rows[0]["FSTOCKLOCID"].ToString(),
FENBOMID = myTable.Rows[0]["FENBOMID"].ToBoolean(),
FLOCATION = strLocation,
FSRCINFO = srcInfo,
FISSECUNIT = myTable.Rows[0]["FISSECUNIT"].ToBoolean(),
FSECUNITQTY = myTable.Rows[0]["FSECUNITQTY"].ToDecimal(),
FSECUNITID = myTable.Rows[0]["FSECUNITID"].ToString(),
FOWNERTYPEID = myTable.Rows[0]["FOWNERTYPEID"].ToString(),
FOWNERID = myTable.Rows[0]["FOWNERID"].ToString(),
FKEEPERTYPEID = myTable.Rows[0]["FKEEPERTYPEID"].ToString(),
FKEEPERID = myTable.Rows[0]["FKEEPERID"].ToString(),
FBOMID = myTable.Rows[0]["FBOMID"].ToString(),
FMODELNO = myTable.Rows[0]["FMODELNO"].ToString(),
FSTOCKSTATUSID = (barcodeStatus == 1 || barcodeType == 3) ? myTable.Rows[0]["FSTOCKSTATUSID"].ToString() : "",
FSTOCKSTATUSNAME = (barcodeStatus == 1 || barcodeType == 3) ? myTable.Rows[0]["FSTOCKSTATUSNAME"].ToString() : "",
};
#endregion
#region 若箱码,获取最底阶信息
string strMess = "";
List<string> billNOList = new List<string>();//源单信息
if (barcodeIsBox)
{
strMess = $"箱码【{barcode}】中";
DataTable dtCusor2 = context.Database.SqlQuery($@"
DECLARE @idoc int;
DECLARE @doc xml;
SELECT @doc=FBOXINFO FROM T_BD_BARCODERS4 WHERE FBARCODE='{barcode}'
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
SELECT
S.FBARCODE--条码
,S.FSECUNITID
,S.FSECUNITQTY
,S.FOWNERTYPEID
,S.FOWNERID
,S.FKEEPERTYPEID
,S.FKEEPERID
,S.FKFDATE--保质日期
,S.FUSEFULDATE--有效期至
,S3.FISSECUNIT --启用辅助单位
,S3.FKFPERIOD--保质天数
,S3.FKFUNIT--保质期单位
,S.FAUXPROPID--辅助属性
,S.FINBOX--被装箱
,S.FQTY--数量
,S.FBASEQTY--基本数量
,S.FUNITID--单位内码
,S.FBARTYPE--条码类型
,S.FBARCODESTATUS--条码状态(1=初始;2=收料)
,S.FSTOCKSTATUS--库存状态(0.未入库 1.已入库 2.生产领料出库 3.销售出库 4.其他出库 5.委外调拨 8.已折分 9.已合并 10.已废弃)
,S.FKID --打印来源(1=采购订单;2=生产订单;3=委外订单;4=库存;5=物料)
,S.FLOT--批次
,S.FMATERIALID--物料内码
,S3.FNUMBER AS FITEMNUMBER --物料代码
,S3.FNAME AS FITEMNAME--物料名称
,S3.FISBATCHMANAGE--启用批次管理
,S3.FISKFPERIOD--启用保质期管理
,S3.FSPECIFICATION --规格型号
,S3.FERPCLSID --物料属性
,S3.FSUITE --是否套件
,S4.FNAME AS FUNITNAME--单位名称
,S.FBASEUNITID--基本单位
,S5.FNUMBER AS FBASEUNITNUMBER--基本单位代码
,S5.FNAME AS FBASEUNITNAME--基本单位名称
,S6.FINTERID AS FSUPPLYID --供应商
,S6.FNUMBER AS FSUPPLYNUMBER--供应商代码
,S6.FNAME AS FSUPPLYNAME --供应商名称
,S.FSTOCKID--仓库
,S.FSTOCKLOCID--仓位
,S7.FNUMBER AS FSCSTOCKNUMBER--仓库代码
,S7.FISOPENLOCATION --启用仓位管理
,S8.FNUMBER AS FSCSPNUMBER --仓位代码
,S9.FNAME AS FAUXPROPNAME
,S.FSTOCKSTATUSID,S3.FENBOMID -- 是否启用BOM版本
,S12.FNAME AS FSTOCKSTATUSNAME
,S.FBOMID --BOM版本
,isnull(Y.FMODELNO,'') as FMODELNO --车号
,S12.FTYPE,S12.FAVAILABLE,S12.FNOTSALE,S12.FNOTGET --库存状态:可使用、不可销售、不可以领用
FROM (
select case when S1.FBARCODE is not null then S1.FBARCODE else S.FBARCODE end AS FBARCODE
from
(
SELECT *
FROM OPENXML(@idoc, '/BARCODE/DATA',0)
WITH (
FBARCODE varchar(50) '@FBARCODE',
FQTY decimal(24,8) '@FQTY'
)
)S
left join T_BD_BARCODERSENTRY S1 on S.FBARCODE = S1.FBOXCODE
) A
LEFT JOIN T_BD_BARCODERS S(nolock) on S.FBARCODE =A.FBARCODE
LEFT JOIN T_BD_MATERIAL S3(nolock) on S.FMATERIALID =S3.FINTERID
LEFT JOIN T_BD_UNIT S4 on S.FUNITID = S4.FINTERID
LEFT JOIN T_BD_BARCODERS2 Y ON S.FBARCODE = Y.FBARCODE
LEFT JOIN T_BD_UNIT S5 on S.FBASEUNITID = S5.FINTERID
LEFT JOIN T_BD_SUPPLIER S6 on S.FSUPPLYID=S6.FINTERID
LEFT JOIN T_BD_STOCK S7 on S.FSTOCKID = S7.FINTERID
LEFT JOIN T_BAS_FLEXVALUESDETAIL S8 on S.FSTOCKLOCID = S8.FINTERID
LEFT JOIN T_BD_FLEXSITEMDETAILV S9 on S.FAUXPROPID = S9.FINTERID
LEFT JOIN T_BD_STOCKSTATUS S12 ON S.FSTOCKSTATUSID = S12.FNUMBER
EXEC sp_xml_removedocument @idoc --释放指针
");
dtCusor2.CaseSensitive = false;
if (dtCusor2 == null || dtCusor2.Rows.Count <= 0)
{
jsonRet.Message = strMess + "信息未找到!";
return jsonRet;
}
foreach (DataRow selectDr2 in dtCusor2.Rows)
{
usefulDate = new DateTime();
string codeNO = selectDr2["FBARCODE"].ToString();
int codeStockStatus = selectDr2["FSTOCKSTATUS"].ToInt();
if (selectDr2["FQTY"].ToDecimal() <= 0)
{
jsonRet.Message = string.Format(strMess + "条码【{0}】数量不能小于等于零", codeNO);
return jsonRet;
}
if (selectDr2["FBASEQTY"].ToDecimal() <= 0)
{
jsonRet.Message = string.Format(strMess + "条码【{0}】基本单位数量不能小于等于零", codeNO);
return jsonRet;
}
if (selectDr2["FISKFPERIOD"].ToBoolean())
{
if (!CheckDateTime.IsDate(selectDr2["FKFDATE"].ToStringEx()))
{
jsonRet.Message = string.Format(strMess + "条码【{0}】物料启用保质期管理,但保质期日期信息为空!", codeNO);
return jsonRet;
}
if (selectDr2["FKFPERIOD"].ToInt() == 0)
{
jsonRet.Message = string.Format(strMess + "条码【{0}】物料保质期限未设定!", codeNO);
return jsonRet;
}
if (!CheckDateTime.IsDate(selectDr2["FUSEFULDATE"].ToStringEx()))
{
usefulDate = GetExpiryDate(context, selectDr2["FKFDATE"].ToStringEx().ToDateTime(), selectDr2["FKFUNIT"].ToInt(), selectDr2["FKFPERIOD"].ToInt());
}
else
{
usefulDate = selectDr2["FUSEFULDATE"].ToStringEx().ToDateTime();
}
}
if (selectDr2["FOWNERTYPEID"].ToStringEx().IsNullOrEmpty())
{
jsonRet.Message = string.Format(strMess + "条码【{0}】对应的货主类型为空", codeNO);
return jsonRet;
}
if (selectDr2["FOWNERID"].ToStringEx().IsNullOrEmpty())
{
jsonRet.Message = string.Format(strMess + "条码【{0}】对应的货主为空", codeNO);
return jsonRet;
}
if (selectDr2["FKEEPERTYPEID"].ToStringEx().IsNullOrEmpty())
{
jsonRet.Message = string.Format(strMess + "条码【{0}】对应的保管者类型为空", codeNO);
return jsonRet;
}
if (selectDr2["FKEEPERID"].ToStringEx().IsNullOrEmpty())
{
jsonRet.Message = string.Format(strMess + "条码【{0}】对应的保管者为空", codeNO);
return jsonRet;
}
if (selectDr2["FSUITE"].ToBoolean())
{
jsonRet.Message = string.Format(strMess + "条码【{0}】对应的产品类型为套件", codeNO);
return jsonRet;
}
if (tranType.Equals("SP_INSTOCK"))
{
if (selectDr2["FERPCLSID"].ToInt() != 2)
{
jsonRet.Message = string.Format(strMess + "条码【{0}】对应的产品类型非自制", codeNO);
return jsonRet;
}
}
if (int.TryParse(selectDr2["FBARTYPE"].ToString(), out barcodeType))
{
if (barcodeType != 1 && barcodeType != 2 && barcodeType != 3)
{
barcodeType = 2;
}
}
else
{
barcodeType = 2;
}
if (barcodeType == 1 || barcodeType == 2)
{
string retMsg = CheckBill.CheckBarCodeStatus(tranType, codeStockStatus, codeNO, sourceTranType);//校验条码出入库状态
if (!string.IsNullOrEmpty(retMsg))
{
jsonRet.Message = strMess + retMsg;
return jsonRet;
}
if (codeStockStatus == 1)
{
if (selectDr2["FSTOCKSTATUSID"].ToString().IsNullOrWhiteSpace())
{
jsonRet.Message = string.Format(strMess + "条码【{0}】仓库库存状态未定义", codeNO);
return jsonRet;
}
else
{
if (!APPWmsCommonFunc.CkeckFStockStatusId(tranType, selectDr2["FTYPE"].ToString(), selectDr2["FAVAILABLE"].ToBoolean(),
selectDr2["FNOTSALE"].ToBoolean(), selectDr2["FNOTGET"].ToBoolean(), out string msg))
{
jsonRet.Message = string.Format(strMess + "条码【{0}】{1}", codeNO, msg);
return jsonRet;
}
}
}
}
//箱码最底阶信息
barCodeInfo.FBOXINFO.Add(new BarCodeMsg<object>
{
FSRCFORMID = selBill.FSRCFORMID,
FSRCNAME = selBill.FSRCNAME,
FISBOX = 0,
FBOXBARCODE = barcode,
FBARCODE = selectDr2["FBARCODE"].ToString(),
FMATERIALID = selectDr2["FMATERIALID"].ToString(),
FITEMNUMBER = selectDr2["FITEMNUMBER"].ToString(),
FITEMNAME = selectDr2["FITEMNAME"].ToString(),
FSPECIFICATION = myTable.Rows[0]["FSPECIFICATION"].ToString(),
FLOT = selectDr2["FLOT"].ToString(),
FAUXPROPID = selectDr2["FAUXPROPID"].ToString(),
FAUXPROPNAME = selectDr2["FAUXPROPNAME"].ToString(),
FKFPERIOD = selectDr2["FKFPERIOD"].ToInt(),
FKFDATE = selectDr2["FKFDATE"].ToDateTime().ToStringEx("YMD"),
FUSEFULDATE = selectDr2["FUSEFULDATE"].ToDateTime().ToStringEx("YMD"),
FQTY = selectDr2["FQTY"].ToDecimal(),
FUNITNAME = selectDr2["FUNITNAME"].ToString(),
FUNITID = selectDr2["FUNITID"].ToString(),
FBASEQTY = selectDr2["FBASEQTY"].ToDecimal(),
FBASEUNITID = selectDr2["FBASEUNITID"].ToString(),
FBASEUNITNUMBER = myTable.Rows[0]["FBASEUNITNUMBER"].ToString(),
FBASEUNITNAME = myTable.Rows[0]["FBASEUNITNAME"].ToString(),
FSRCSTOCKID = selectDr2["FSTOCKID"].ToString(),
FSRCSTOCKLOCID = selectDr2["FSTOCKLOCID"].ToString(),
FSTOCKID = selectDr2["FSTOCKID"].ToString(),
FSTOCKLOCID = selectDr2["FSTOCKLOCID"].ToString(),
FSTOCKNO = selectDr2["FSCSTOCKNUMBER"].ToString(),
FSTOCKLOCNAME = selectDr2["FSCSPNUMBER"].ToString(),
FISSECUNIT = myTable.Rows[0]["FISSECUNIT"].ToBoolean(),
FSECUNITID = selectDr2["FSECUNITID"].ToString(),
FSECUNITQTY = selectDr2["FSECUNITQTY"].ToDecimal(),
FOWNERTYPEID = selectDr2["FOWNERTYPEID"].ToString(),
FOWNERID = selectDr2["FOWNERID"].ToString(),
FKEEPERTYPEID = selectDr2["FKEEPERTYPEID"].ToString(),
FKEEPERID = selectDr2["FKEEPERID"].ToString(),
FBOMID = selectDr2["FBOMID"].ToString(),
FENBOMID = myTable.Rows[0]["FENBOMID"].ToBoolean(),
FMODELNO = selectDr2["FMODELNO"].ToString(),
FSRCSTOCKSTATUSID = (codeStockStatus == 1 || barcodeType == 3) ? selectDr2["FSTOCKSTATUSID"].ToString() : "",
FSRCFSTOCKSTATUSNAME = (codeStockStatus == 1 || barcodeType == 3) ? selectDr2["FSTOCKSTATUSNAME"].ToString() : "",
FSTOCKSTATUSID = (codeStockStatus == 1 || barcodeType == 3) ? myTable.Rows[0]["FSTOCKSTATUSID"].ToString() : "",
FSTOCKSTATUSNAME = (codeStockStatus == 1 || barcodeType == 3) ? myTable.Rows[0]["FSTOCKSTATUSNAME"].ToString() : ""
});
}
if (isHaveSource && !tranType.Equals("STK_STOCKDIFF"))
{
var query = from p in dtCusor2.AsEnumerable()
group p by new { FNO = p.Field<string>("FBARCODE"), FCType = p.Field<string>("FKID") } into m
select new
{
m.Key.FNO,
m.Key.FCType
};
if (!isOpenSource)
{
#region 未开放源单时,查询条码源单信息
foreach (var item in query)
{
sourceSec = 0;
sourceID = string.Empty;
sourceDetailID = string.Empty;
sourceNO = string.Empty;
srcInfo = null;
switch (item.FCType)
{//1=采购订单;2=生产订单;3=委外订单;4=库存;5=物料
case "1":
sourceDT = context.Database.SqlQuery($"SELECT * FROM T_BD_BARCODERS1 WHERE FBARCODE='{barcode}'");
if (sourceDT != null && sourceDT.Rows.Count > 0)
{
//判断源单类型
if (sourceTranType.ToUpper() == "PUR_RECEIVEBILL")
{
sourceSec = sourceDT.Rows[0]["FPURENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FPURBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FPURID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FPURDETAILID"].ToStringEx();
}
else
{
sourceSec = sourceDT.Rows[0]["FPOENTREYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FPOBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FPOID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FPODETAILID"].ToStringEx();
}
srcInfo = new BD_BARCODERS1
{
FPOID = sourceDT.Rows[0]["FPOID"].ToStringEx(),
FPOENTREYID = sourceDT.Rows[0]["FPOENTREYID"].ToInt(),
FPOBILLNO = sourceDT.Rows[0]["FPOBILLNO"].ToStringEx(),
FPODETAILID = sourceDT.Rows[0]["FPODETAILID"].ToStringEx(),
FPURID = sourceDT.Rows[0]["FPURID"].ToStringEx(),
FPURBILLNO = sourceDT.Rows[0]["FPURBILLNO"].ToStringEx(),
FPURENTRYID = sourceDT.Rows[0]["FPURENTRYID"].ToInt(),
FPURDETAILID = sourceDT.Rows[0]["FPURDETAILID"].ToStringEx(),
FSUPPLIERID = sourceDT.Rows[0]["FSUPPLIERID"].ToStringEx(),
FINSPECTID = sourceDT.Rows[0]["FINSPECTID"].ToStringEx(),
FINSPECTDATE = sourceDT.Rows[0]["FINSPECTDATE"].ToDateTime()
};
}
break;
case "2":
case "A":
sourceDT = context.Database.SqlQuery($"SELECT * FROM T_BD_BARCODERS2 WHERE FBARCODE='{barcode}'");
if (sourceDT != null && sourceDT.Rows.Count > 0)
{
switch (sourceTranType.ToUpper())
{
case "PRD_MO"://生产任务单
sourceSec = sourceDT.Rows[0]["FMOENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FMOBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FMOID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FMODETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS2
{
FMOID = sourceDT.Rows[0]["FMOID"].ToStringEx(),
FMOBILLNO = sourceDT.Rows[0]["FMOBILLNO"].ToStringEx(),
FMOENTRYID = sourceDT.Rows[0]["FMOENTRYID"].ToInt(),
FMODETAILID = sourceDT.Rows[0]["FMODETAILID"].ToStringEx(),
FCUSTID = sourceDT.Rows[0]["FCUSTID"].ToStringEx(),
FODID = sourceDT.Rows[0]["FODID"].ToStringEx(),
FODDETAILID = sourceDT.Rows[0]["FODDETAILID"].ToStringEx(),
FODENTRYID = sourceDT.Rows[0]["FODENTRYID"].ToInt()
};
break;
case "PRD_MORPT"://生产汇报单
sourceSec = sourceDT.Rows[0]["FREPORTENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FREPORTBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FREPORTID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FREPORTDETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS2
{
FREPORTENTRYID = sourceDT.Rows[0]["FREPORTENTRYID"].ToInt(),
FREPORTBILLNO = sourceDT.Rows[0]["FREPORTBILLNO"].ToStringEx(),
FREPORTID = sourceDT.Rows[0]["FREPORTID"].ToStringEx(),
FREPORTDETAILID = sourceDT.Rows[0]["FREPORTDETAILID"].ToStringEx(),
FMOID = sourceDT.Rows[0]["FMOID"].ToStringEx(),
FMOBILLNO = sourceDT.Rows[0]["FMOBILLNO"].ToStringEx(),
FMOENTRYID = sourceDT.Rows[0]["FMOENTRYID"].ToInt(),
FMODETAILID = sourceDT.Rows[0]["FMODETAILID"].ToStringEx(),
FCUSTID = sourceDT.Rows[0]["FCUSTID"].ToStringEx(),
FODID = sourceDT.Rows[0]["FODID"].ToStringEx(),
FODDETAILID = sourceDT.Rows[0]["FODDETAILID"].ToStringEx(),
FODENTRYID = sourceDT.Rows[0]["FODENTRYID"].ToInt()
};
break;
case "SFC_OPTRPT"://工序汇报单
sourceSec = sourceDT.Rows[0]["FREPORTENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FREPORTBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FREPORTID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FREPORTDETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS2
{
FREPORTENTRYID = sourceDT.Rows[0]["FREPORTENTRYID"].ToInt(),
FREPORTBILLNO = sourceDT.Rows[0]["FREPORTBILLNO"].ToStringEx(),
FREPORTID = sourceDT.Rows[0]["FREPORTID"].ToStringEx(),
FREPORTDETAILID = sourceDT.Rows[0]["FREPORTDETAILID"].ToStringEx(),
FMOID = sourceDT.Rows[0]["FMOID"].ToStringEx(),
FMOBILLNO = sourceDT.Rows[0]["FMOBILLNO"].ToStringEx(),
FMOENTRYID = sourceDT.Rows[0]["FMOENTRYID"].ToInt(),
FMODETAILID = sourceDT.Rows[0]["FMODETAILID"].ToStringEx(),
FCUSTID = sourceDT.Rows[0]["FCUSTID"].ToStringEx(),
FODID = sourceDT.Rows[0]["FODID"].ToStringEx(),
FODDETAILID = sourceDT.Rows[0]["FODDETAILID"].ToStringEx(),
FODENTRYID = sourceDT.Rows[0]["FODENTRYID"].ToInt()
};
break;
}
}
break;
case "3":
sourceDT = context.Database.SqlQuery($"SELECT * FROM T_BD_BARCODERS3 WHERE FBARCODE='{barcode}'");
if (sourceDT != null && sourceDT.Rows.Count > 0)
{
sourceSec = sourceDT.Rows[0]["FREQENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FREQBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FREQID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FREQDETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS3
{
FREQID = sourceDT.Rows[0]["FREQID"].ToStringEx(),
FREQBILLNO = sourceDT.Rows[0]["FREQBILLNO"].ToStringEx(),
FREQENTRYID = sourceDT.Rows[0]["FREQENTRYID"].ToInt(),
FREQDETAILID = sourceDT.Rows[0]["FREQDETAILID"].ToStringEx()
};
}
break;
case "6":
sourceDT = context.Database.SqlQuery($"SELECT * FROM T_BD_BARCODERS5 WHERE FBARCODE='{barcode}'");
if (sourceDT != null && sourceDT.Rows.Count > 0)
{
sourceSec = sourceDT.Rows[0]["FOEMRECEIVEENTRYID"].ToInt();
sourceNO = sourceDT.Rows[0]["FOEMRECEIVEBILLNO"].ToStringEx();
sourceID = sourceDT.Rows[0]["FOEMRECEIVEID"].ToStringEx();
sourceDetailID = sourceDT.Rows[0]["FOEMRECEIVEDETAILID"].ToStringEx();
srcInfo = new BD_BARCODERS5
{
FOEMRECEIVEID = sourceDT.Rows[0]["FOEMRECEIVEID"].ToStringEx(),
FOEMRECEIVEBILLNO = sourceDT.Rows[0]["FOEMRECEIVEBILLNO"].ToStringEx(),
FOEMRECEIVEENTRYID = sourceDT.Rows[0]["FOEMRECEIVEENTRYID"].ToInt(),
FOEMRECEIVEDETAILID = sourceDT.Rows[0]["FOEMRECEIVEDETAILID"].ToStringEx(),
FOWNERID = sourceDT.Rows[0]["FOWNERID"].ToStringEx(),
FODID = sourceDT.Rows[0]["FODID"].ToStringEx(),
FODDETAILID = sourceDT.Rows[0]["FODDETAILID"].ToStringEx(),
FODENTRYID = sourceDT.Rows[0]["FODENTRYID"].ToInt(),
FODBILLNO = sourceDT.Rows[0]["FODBILLNO"].ToStringEx()
};
}
break;
}
barCodeInfo.FBOXINFO.ForEach(o =>
{
if (item.FNO.Equals(o.FBARCODE))
{
o.FSRCID = sourceID;
o.FSRCBILLNO = sourceNO;
o.FSRCENTRYID = sourceSec;
o.FSRCDETAILID = sourceDetailID;
o.FSRCINFO = srcInfo;
}
});
}
if (barCodeInfo.FBOXINFO.Exists(o => string.IsNullOrEmpty(o.FSRCBILLNO) == true))
{
jsonRet.Message = strMess + "中存在源单编号信息为空的条码!";
return jsonRet;
}
barCodeInfo.FBOXINFO.ForEach(o =>
{
if (!billNOList.Exists(q => q.Equals(o.FSRCBILLNO)))
{
billNOList.Add(o.FSRCBILLNO);
}
});
#endregion
}
else
{
#region 开放源单时,未查到源单信息时使用扫描的源单编号
foreach (var item in query)
{
switch (item.FCType)
{//1=采购订单;2=生产订单;3=委外订单;4=库存;5=物料;6受托加工收料
case "1":
{
srcInfo = new BD_BARCODERS1();
break;
}
case "2":
case "A":
{
srcInfo = new BD_BARCODERS2();
break;
}
case "3":
case "4":
case "5":
{
srcInfo = new BD_BARCODERS3();
break;
}
case "6":
{
srcInfo = new BD_BARCODERS5();
break;
}
}
barCodeInfo.FBOXINFO.ForEach(o =>
{
if (item.FNO.Equals(o.FBARCODE))
{
o.FSRCBILLNO = sourceBillNO;
o.FSRCINFO = srcInfo;
}
});
}
billNOList.Add(sourceBillNO);
#endregion
}
}
}
else
{
strMess = $"条码【{barcode}】";
billNOList.Add(sourceBillNO);
}
#endregion
#region 校验单据源单视图
if (isHaveSource && !tranType.Equals("STK_STOCKDIFF") && !(tranType.Equals("PRD_FEEDMTRL") && sourceTranType.Equals("PRD_MO")))//盘点的不做源单处理、生产补料源单为生产任务单不做源单处理
{
if (tranType.Equals("SAL_OUTSTOCK_SUIT") || tranType.Equals("SAL_RETURNSTOCK_SUIT"))
{//销售出库套件
sourceEntryID = 0;
}
List<SOURCEBILLINFO> sourceList = await context.Database.SqlQueryAsync<SOURCEBILLINFO>(CheckBill.GetSoureBillData(orgID, tranType, sourceTranType, sourceBillNO, sourceEntryID));
if (sourceList == null || sourceList.Count <= 0)
{
jsonRet.Message = "源单信息未找到";
return jsonRet;
}
foreach (string sub in billNOList)
{
//针对生产方面的源单为生产任务单时,真实源单为用料单,源单找不到的情况
if (!sourceList.Exists(o => o.FSRCBILLNO.ToStringEx().Equals(sub) || o.FMOBILLNO.ToStringEx().Equals(sub) || o.FORDERBILLNO.ToStringEx().Equals(sub)))
{
jsonRet.Message = $"源单编号【{sub}】信息未找到";
return jsonRet;
}
}
//var source = sourceList.Where(o => !o.FLOT.ToStringEx().IsNullOrEmpty()).ToList();
//销售出库,且源单为发货通知单且发货通知有车号,我们要检查出库车号是否在发货通知单有
DataTable SNTABLE = null;
#region ======================== 车号的管理 =====================================================
if (tranType.ToUpperEx() == "SAL_OUTSTOCK" && sourceTranType.ToUpperEx() == "SAL_DELIVERYNOTICE")
{
SOURCEBILLINFO SourceBill = sourceList.FirstOrDefault();
if (SourceBill != null)
{
string tempSQL =
" select b.FMATERIALID,a.FMODELNO,b.FENTRYID,T3.FNUMBER as FITEMNUMBER " + "\r\n" +
" from T_SAL_DELIVERYNOTICEENTRY1 (nolock)a " + "\r\n" +
" left join T_SAL_DELIVERYNOTICEENTRY(nolock) b on a.FBODYID = b.FDETAILID " + "\r\n" +
" left join T_BD_MATERIAL (nolock) T3 on b.FMATERIALID=T3.FINTERID " + "\r\n";
tempSQL += $" where a.FINTERID='{SourceBill.FSRCID}' ";
if (sourceEntryID > 0)
{
tempSQL += $" and b.FENTRYID='{sourceEntryID}' ";
}
SNTABLE = context.Database.SqlQuery(tempSQL);
}
}
//生产领料车号限制
if (tranType.ToUpperEx() == "PRD_PICKMTRL" && sourceTranType.ToUpperEx() == "PRD_MO")
{
SOURCEBILLINFO SourceBill = sourceList.FirstOrDefault();
if (SourceBill != null)
{
string tempSQL =
" select b.FMATERIALID,a.FMODELNO,b.FENTRYID,T3.FNUMBER as FITEMNUMBER " + "\r\n" +
" from T_PRD_MOENTRY1 (nolock)a " + "\r\n" +
" left join T_PRD_MOENTRY(nolock) b on a.FBODYID = b.FDETAILID " + "\r\n" +
" left join T_BD_MATERIAL (nolock) T3 on b.FMATERIALID=T3.FINTERID " + "\r\n";
tempSQL += $" where a.FINTERID='{SourceBill.FSRCID}' ";
if (sourceEntryID > 0)
{
tempSQL += $" and b.FENTRYID='{sourceEntryID}' ";
}
SNTABLE = context.Database.SqlQuery(tempSQL);
}
}
#endregion ======================== 车号的管理 ==================================================
if (barcodeIsBox)
{
foreach (BarCodeMsg<object> sub in barCodeInfo.FBOXINFO)
{
if (!sourceList.Exists(o => (o.FSRCBILLNO.ToStringEx().Equals(sub.FSRCBILLNO) || o.FMOBILLNO.ToStringEx().Equals(sub.FSRCBILLNO)
|| o.FORDERBILLNO.ToStringEx().Equals(sub.FSRCBILLNO)) && o.FITEMNUMBER.ToStringEx().Equals(sub.FITEMNUMBER,StringComparison.OrdinalIgnoreCase)))
{
jsonRet.Message = $"条码对应的物料【{sub.FITEMNUMBER}】,在源单【{sub.FSRCBILLNO}】中不存在!";
return jsonRet;
}
//销售出库,要检查源单 BOM 版本号一致
if (tranType.ToUpperEx() == "SAL_OUTSTOCK")
{
if (sub.FENBOMID)
{
if (!sourceList.Any(p => p.FITEMNUMBER.Equals(sub.FITEMNUMBER, StringComparison.OrdinalIgnoreCase) && p.FBOMID == sub.FBOMID))
{
jsonRet.Message = $"条码物料【{sub.FITEMNUMBER}】的BOM版本【{sub.FBOMID}】和源单【{sub.FSRCBILLNO}】不一样!";
return jsonRet;
}
}
}
#region ======================== 车号管理 ==========================================
//销售出库,且源单为发货通知单且发货通知有车号,我们要检查出库车号是否在发货通知单有
if (tranType.ToUpperEx() == "SAL_OUTSTOCK" && sourceTranType.ToUpperEx() == "SAL_DELIVERYNOTICE")
{
if(SNTABLE!=null && SNTABLE.Rows.Count > 0)
{
if (SNTABLE.AsEnumerable().Any(p => p["FITEMNUMBER"].ToStringEx().Equals(sub.FITEMNUMBER,StringComparison.OrdinalIgnoreCase)))
{
if (!SNTABLE.AsEnumerable().Any(p => p["FITEMNUMBER"].ToStringEx().Equals(sub.FITEMNUMBER, StringComparison.OrdinalIgnoreCase) &&
p["FMODELNO"].ToStringEx().ToUpperEx()==sub.FMODELNO.ToUpperEx()))
{
jsonRet.Message = $"车号【{sub.FMODELNO}】在源单【{sub.FSRCBILLNO}】中不存在!";
return jsonRet;
}
}
}
}
// 生产领料车号控制,如果任务单上有车号,且条码里面也有车号,要限制车号任务单上一样
if (tranType.ToUpperEx() == "PRD_PICKMTRL" && sourceTranType.ToUpperEx() == "PRD_MO")
{
if (SNTABLE != null && SNTABLE.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(sub.FMODELNO))
{
if (!SNTABLE.AsEnumerable().Any(p => p["FMODELNO"].ToStringEx().ToUpperEx() == sub.FMODELNO.ToUpperEx()))
{
jsonRet.Message = $"车号【{sub.FMODELNO}】在源单【{sub.FSRCBILLNO}】中不存在!";
return jsonRet;
}
}
}
}
#endregion ======================== 车号管理 ==========================================
if (selBill.FISCHECKLOT)
{
if (!sourceList.Exists(o => (o.FSRCBILLNO.ToStringEx().Equals(sub.FSRCBILLNO) || o.FMOBILLNO.ToStringEx().Equals(sub.FSRCBILLNO)) &&
o.FITEMNUMBER.ToStringEx().Equals(sub.FITEMNUMBER,StringComparison.OrdinalIgnoreCase) && (o.FLOT.ToStringEx().Equals(sub.FLOT) || o.FLOT.ToStringEx().IsNullOrEmpty() || o.FLOT.ToStringEx() == "")))
{
jsonRet.Message =
$"条码对应的物料【{sub.FITEMNUMBER}】,与源单【{sub.FSRCBILLNO}】中批次不匹配!";
return jsonRet;
}
}
if (selBill.FISCHECKAUX)
{
if (!sourceList.Exists(o => (o.FSRCBILLNO.ToStringEx().Equals(sub.FSRCBILLNO) || o.FMOBILLNO.ToStringEx().Equals(sub.FSRCBILLNO)) &&
o.FITEMNUMBER.ToStringEx().Equals(sub.FITEMNUMBER, StringComparison.OrdinalIgnoreCase) && o.FAUXPROPID.Equals(sub.FAUXPROPID)))
{
jsonRet.Message =
$"条码对应的物料【{sub.FITEMNUMBER}】,在源单【{sub.FSRCBILLNO}】中辅助属性不匹配!";
return jsonRet;
}
}
if (selBill.FISCHECKKFDATE)
{
if (!sourceList.Exists(o => (o.FSRCBILLNO.ToStringEx().Equals(sub.FSRCBILLNO) || o.FMOBILLNO.ToStringEx().Equals(sub.FSRCBILLNO))
&& o.FITEMNUMBER.ToStringEx().Equals(sub.FITEMNUMBER, StringComparison.OrdinalIgnoreCase) && o.FKFPERIOD > 0 && CheckDateTime.CompareTime(o.FKFDATE, sub.FKFDATE) == 0))
{
jsonRet.Message =
$"条码对应的物料【{sub.FITEMNUMBER}】,在源单【{sub.FSRCBILLNO}】中保质日期不匹配!";
return jsonRet;
}
}
}
}
else
{
if (!sourceList.Exists(o => (o.FSRCBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO) || o.FMOBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO) ||
o.FORDERBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO))
&& o.FITEMNUMBER.ToStringEx().Equals(barCodeInfo.FITEMNUMBER, StringComparison.OrdinalIgnoreCase)))
{
throw new O3AppException(
$"条码对应的物料【{barCodeInfo.FITEMNUMBER}】,在源单【{barCodeInfo.FSRCBILLNO}】中不存在!");
}
//销售出库,要检查源单 BOM 版本号一致
if (tranType.ToUpperEx() == "SAL_OUTSTOCK")
{
if (barCodeInfo.FENBOMID)
{
if (!sourceList.Any(p => p.FITEMNUMBER.Equals(barCodeInfo.FITEMNUMBER, StringComparison.OrdinalIgnoreCase) && p.FBOMID == barCodeInfo.FBOMID))
{
jsonRet.Message = $"物料【{barCodeInfo.FITEMNUMBER}】BOM版本【{barCodeInfo.FBOMID}】在源单【{barCodeInfo.FSRCBILLNO}】中不存在!";
return jsonRet;
}
}
}
#region ==================== 车号管理 ===============================
//销售出库,且源单为发货通知单且发货通知有车号,我们要检查出库车号是否在发货通知单有
if (tranType.ToUpperEx() == "SAL_OUTSTOCK" && sourceTranType.ToUpperEx() == "SAL_DELIVERYNOTICE")
{
if (SNTABLE != null && SNTABLE.Rows.Count > 0)
{
if (SNTABLE.AsEnumerable().Any(p => p["FITEMNUMBER"].ToStringEx().Equals(barCodeInfo.FITEMNUMBER, StringComparison.OrdinalIgnoreCase)))
{
if (!SNTABLE.AsEnumerable().Any(p => p["FITEMNUMBER"].ToStringEx().Equals(barCodeInfo.FITEMNUMBER, StringComparison.OrdinalIgnoreCase) &&
p["FMODELNO"].ToStringEx().ToUpperEx() == barCodeInfo.FMODELNO.ToUpperEx()))
{
jsonRet.Message = $"车号【{barCodeInfo.FMODELNO}】在源单【{barCodeInfo.FSRCBILLNO}】中不存在!";
return jsonRet;
}
}
}
}
// 生产领料车号控制,如果任务单上有车号,且条码里面也有车号,要限制车号任务单上一样
if (tranType.ToUpperEx() == "PRD_PICKMTRL" && sourceTranType.ToUpperEx() == "PRD_MO")
{
if (SNTABLE != null && SNTABLE.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(barCodeInfo.FMODELNO))
{
if (!SNTABLE.AsEnumerable().Any(p => p["FMODELNO"].ToStringEx().ToUpperEx() == barCodeInfo.FMODELNO.ToUpperEx()))
{
jsonRet.Message = $"车号【{barCodeInfo.FMODELNO}】在源单【{barCodeInfo.FSRCBILLNO}】中不存在!";
return jsonRet;
}
}
}
}
#endregion =========================车号管理=================================
if (selBill.FISCHECKLOT)
{
if (!sourceList.Exists(o => (o.FSRCBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO) || o.FMOBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO))
&& o.FITEMNUMBER.ToStringEx().Equals(barCodeInfo.FITEMNUMBER,StringComparison.OrdinalIgnoreCase) && (o.FLOT.ToStringEx().Equals(barCodeInfo.FLOT) || o.FLOT.ToStringEx().IsNullOrEmpty() || o.FLOT.ToStringEx() == "")))
{
jsonRet.Message =
$"条码对应的物料【{barCodeInfo.FITEMNUMBER}】,与源单【{barCodeInfo.FSRCBILLNO}】中批次不匹配!";
return jsonRet;
}
}
if (selBill.FISCHECKAUX)
{
if (!sourceList.Exists(o => (o.FSRCBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO) || o.FMOBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO))
&& o.FITEMNUMBER.ToStringEx().Equals(barCodeInfo.FITEMNUMBER, StringComparison.OrdinalIgnoreCase) && o.FAUXPROPID.Equals(barCodeInfo.FAUXPROPID)))
{
jsonRet.Message =
$"条码对应的物料【{barCodeInfo.FITEMNUMBER}】,在源单【{barCodeInfo.FSRCBILLNO}】中辅助属性不匹配!";
return jsonRet;
}
}
if (selBill.FISCHECKKFDATE)
{
var tempList = sourceList
.Where(o =>
(o.FKFPERIOD == 0 || o.FKFDATE == null)
||
(((o.FSRCBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO) || o.FMOBILLNO.ToStringEx().Equals(barCodeInfo.FSRCBILLNO))
&& o.FITEMNUMBER.ToStringEx().Equals(barCodeInfo.FITEMNUMBER,StringComparison.OrdinalIgnoreCase))
&& o.FKFPERIOD > 0
&& !o.FKFDATE.IsNullOrEmpty()
&& o.FKFDATE.ToDateTime().Equals(barCodeInfo.FKFDATE.ToDateTime())))
.ToList();
if (tempList == null || tempList.Count <= 0)
{
jsonRet.Message =
$"条码对应的物料【{barCodeInfo.FITEMNUMBER}】,在源单【{barCodeInfo.FSRCBILLNO}】中保质日期不匹配!";
return jsonRet;
}
}
}
string fID = string.Empty;
string fNO = string.Empty;
string fName = string.Empty;
switch (tranType)
{
case "STK_INSTOCK"://外购入库
case "PUR_MRB"://外购退库
case "SUB_PICKMTRL"://委外领料
case "SUB_RETURNMTRL"://委外退料
case "SUB_INSTKPICKMTL"://委外入库
case "SUB_OUTSTKPICKMTL"://委外退库
fID = sourceList[0].FSUPPLYID;
fNO = sourceList[0].FSUPPLYNUMBER;
fName = sourceList[0].FSUPPLYNAME;
break;
case "PRD_INSTOCK"://生产入库
case "PRD_RESTOCK"://生产退库
case "PRD_PICKMTRL"://生产领料
fID = sourceList[0].FDEPTID;
fNO = sourceList[0].FDEPTNUMBER;
fName = sourceList[0].FDEPTNAME;
break;
case "PRD_RETURNMTRL"://生产退料
fID = sourceList[0].FDEPTID;
fNO = sourceList[0].FDEPTNUMBER;
fName = sourceList[0].FDEPTNAME;
break;
case "STK_OEMPICK"://受托加工领料
case "STK_OEMRETURNSTOCK"://受托加工退料
fID = sourceList[0].FDEPTID;
fNO = sourceList[0].FDEPTNUMBER;
fName = sourceList[0].FDEPTNAME;
break;
case "SAL_OUTSTOCK"://销售出库
case "SAL_RETURNSTOCK"://销售退货
case "SAL_OUTSTOCK_SUIT"://销售出库(套件)
case "SAL_RETURNSTOCK_SUIT"://销售退货(套件)
case "STK_OEMINSTOCK"://受托加工入库
case "STK_OEMOUTSTOCK"://受托加工退库
fID = sourceList[0].FCUSTID;
fNO = sourceList[0].FCUSTNUMBER;
fName = sourceList[0].FCUSTNAME;
break;
}
barCodeInfo.FID = fID;
barCodeInfo.FNO = fNO;
barCodeInfo.FNAME = fName;
//判断条码的单位与源单的单位是否一致
string funitId = string.Empty, funitName = string.Empty;
decimal barQty = 0;
//取出对应的源单信息
SOURCEBILLINFO sourceEntry = sourceList.Where(o => o.FITEMNUMBER.ToStringEx().Equals(barCodeInfo.FITEMNUMBER, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (sourceEntry != null && sourceEntry.FUNITID != barCodeInfo.FUNITID)
{
funitId = sourceEntry.FUNITID;
funitName = sourceEntry.FUNITNAME;
barQty = GetMaterQty2(context, barCodeInfo.FMATERIALID, barCodeInfo.FBASEUNITID, funitId, barCodeInfo.FBASEQTY, 6);
barCodeInfo.FUNITID = funitId;
barCodeInfo.FUNITNAME = funitName;
barCodeInfo.FQTY = barQty;
}
//单位一致不做换算处理
if (barcodeIsBox)
{
barCodeInfo.FBOXINFO.ForEach(o =>
{
SOURCEBILLINFO sourceEntry = sourceList.Where(p => p.FITEMNUMBER.ToStringEx().Equals(o.FITEMNUMBER, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
o.FID = fID;
o.FNO = fNO;
o.FNAME = fName;
//判断条码的单位与源单的单位是否一致
if (sourceEntry != null && sourceEntry.FUNITID != o.FUNITID)
{
funitId = sourceEntry.FUNITID;
funitName = sourceEntry.FUNITNAME;
barQty = GetMaterQty2(context, o.FMATERIALID, o.FBASEUNITID, funitId, o.FBASEQTY, 6);
o.FUNITID = funitId;
o.FUNITNAME = funitName;
o.FQTY = barQty;
}
});
}
#region ================== 如果为生产入库,条码上工单不是此车号最后一个工单,不让扫描==============
if (tranType.ToUpperEx() == "PRD_INSTOCK" && isHaveSource)
{
List<string> arrModelNO = new List<string>();
if (barcodeIsBox)
{
if (barCodeInfo.FBOXINFO != null && barCodeInfo.FBOXINFO.Count > 0)
{
var mArr = barCodeInfo.FBOXINFO.Where(p => p.FMODELNO.IsNullOrEmpty() == false)
.GroupBy(p => p.FMODELNO).Select(p => p.Key).ToList();
if (mArr.Count > 0)
{
arrModelNO.AddRange(mArr);
}
}
}
else
{
if (string.IsNullOrEmpty(barCodeInfo.FMODELNO) == false)
{
arrModelNO.Add(barCodeInfo.FMODELNO);
}
}
if (arrModelNO.Count > 0)
{
//检查条码上工单不是此车号最后一个工单
foreach (var item in arrModelNO)
{
string tempSQL =
" select top 1 c.FINTERID,c.FBILLNO " +
" from T_PRD_MOENTRY1(nolock)a " +
" left join T_PRD_MOENTRY(nolock) b on a.FBODYID = b.FDETAILID " +
" left join T_PRD_MO(nolock) c on a.FINTERID = c.FINTERID " +
$" where a.FMODELNO = '{item}' " +
" order by Convert(int, c.FINTERID) desc ";
DataTable tempTable = context.Database.SqlQuery(tempSQL);
if (tempTable.Rows.Count > 0 && tempTable.Rows[0]["FBILLNO"].ToStringEx() != sourceList[0].FSRCBILLNO)
{
jsonRet.Message =
$"条码中车号【{item}】对应的最新任务单为【{tempTable.Rows[0]["FBILLNO"].ToStringEx()}】,和条码上的生产任务单【{sourceList[0].FSRCBILLNO}】不匹配!";
return jsonRet;
}
}
}
}
#endregion ================== 如果为生产入库,条码上工单不是此车号最后一个工单,不让扫描===========
}
#endregion
#region 批次条码使用库存数量
if (barCodeInfo.FBARTYPE == 3)
{
//获取系统配置
Hashtable PBCursor = context.PBValue("FUSEINVENTORYQTY,L,;");
//批次条码是否使用库存数量
if (PBCursor["FUSEINVENTORYQTY"].ToBoolean())
{
string selectWhere = string.Empty;
decimal FQTY = 0, FBASEUNITQTY = 0, FSECUNITQTY = 0;
if (barCodeInfo.FISKFPERIOD.ToBoolean())//是否启用保质期
{
selectWhere = $@"AND FKFDATE = '{barCodeInfo.FKFDATE}'
AND FUSEFULDATE = '{barCodeInfo.FUSEFULDATE}'";
}
DataTable T_STK_INVENTORY = context.Database.SqlQuery($@"SELECT FQTY,FSTOCKUNITID,FBASEUNITQTY,FBASEUNITID,FSECUNITQTY,FSECUNITID FROM T_STK_INVENTORY
WHERE FMATERIALID='{barCodeInfo.FMATERIALID}'
AND FSTOCKORGID = '{barCodeInfo.FCOMPANYID}'
AND FKEEPERTYPEID = '{barCodeInfo.FKEEPERTYPEID}'
AND FKEEPERID = '{barCodeInfo.FKEEPERID}'
AND FOWNERTYPEID = '{barCodeInfo.FOWNERTYPEID}'
AND FOWNERID = '{barCodeInfo.FOWNERID}'
AND FAUXPROPID = '{barCodeInfo.FAUXPROPID}'
AND FSTOCKSTATUSID = '{barCodeInfo.FSTOCKSTATUSID}'
AND FLOT = '{barCodeInfo.FLOT}'
{selectWhere}");
for (int i = 0; i < T_STK_INVENTORY.Rows.Count; i++)//防止条码单位与库存单位不一致
{
var item = T_STK_INVENTORY.Rows[i];
if (!barCodeInfo.FUNITID.IsNullOrEmpty() && !item["FSTOCKUNITID"].ToStringEx().IsNullOrEmpty() && item["FQTY"].ToDecimal() > 0)
{
FQTY += GetMaterQty2(context, barCodeInfo.FMATERIALID, item["FSTOCKUNITID"].ToStringEx(), barCodeInfo.FUNITID, item["FQTY"].ToDecimal(), 6);
}
if (!barCodeInfo.FBASEUNITID.IsNullOrEmpty() && !item["FBASEUNITID"].ToStringEx().IsNullOrEmpty() && item["FBASEUNITQTY"].ToDecimal() > 0)
{
FBASEUNITQTY += GetMaterQty2(context, barCodeInfo.FMATERIALID, item["FBASEUNITID"].ToStringEx(), barCodeInfo.FBASEUNITID, item["FBASEUNITQTY"].ToDecimal(), 6);
}
if (!barCodeInfo.FSECUNITID.IsNullOrEmpty() && !item["FSECUNITID"].ToStringEx().IsNullOrEmpty() && item["FSECUNITQTY"].ToDecimal() > 0)
{
FSECUNITQTY += GetMaterQty2(context, barCodeInfo.FMATERIALID, item["FSECUNITID"].ToStringEx(), barCodeInfo.FSECUNITID, item["FSECUNITQTY"].ToDecimal(), 6);
}
}
if (FQTY > 0)
{
barCodeInfo.FQTY = FQTY;//库存主单位数量
barCodeInfo.FBASEQTY = FBASEUNITQTY;//基本单位数量
barCodeInfo.FSECUNITQTY = FSECUNITQTY;//辅助单位数量
}
}
}
#endregion
#region 返回条码信息
jsonRet.Status = 1;
jsonRet.Data.Add("data", barCodeInfo);
return jsonRet;
#endregion
}
/// <summary>
/// 扫描位置信息,查询仓库仓位
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public async Task<RetMessage> QueryStockData(JObject data)
{
RetMessage jsonRet = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
#region 校验参数是否正确
string stockData = data["stockData"].ToStringEx();
string sourceTranType = data["sourceTranType"].ToStringEx().ToUpper();
string sourceBillNo = data["sourceBillNO"].ToStringEx();
string tranType = data["tranType"].ToStringEx().ToUpper();
string orgID = data["orgID"].ToStringEx();
switch(data.Property("tranType").Value.ToString().ToUpperEx())
{
case "QM_STKAPPCHANGE":
break;
default:
if (stockData.IsNullOrWhiteSpace())
{
jsonRet.Message = "传参类型错误,位置信息为空";
return jsonRet;
}
break;
}
if (tranType.IsNullOrWhiteSpace())
{
jsonRet.Message = "传参类型错误,目标单据信息为空";
return jsonRet;
}
OrgID = orgID;
#endregion
#region 查询仓库仓位信息
LOCATION location = await AnalyzingStock(context, stockData, CheckBill.IsUsedVirtual(tranType));
#endregion
#region 查询源单信息
if (tranType.IsNullOrWhiteSpace())
{
jsonRet.Message = "传参类型错误,目标单据信息为空";
return jsonRet;
}
if (!sourceTranType.IsNullOrWhiteSpace() && !sourceBillNo.IsNullOrWhiteSpace())
{
location.FSRCINFO = await context.Database.SqlQueryAsync<SOURCEBILLINFO>(CheckBill.GetSoureBillData(orgID, tranType, sourceTranType, sourceBillNo));
}
#endregion
#region 查询库存状态信息
if (!location.FSTOCKSTATUSTYPE.IsNullOrEmpty())
{
location.FSTOCKSTATUSALL = await GetStockStatus(context, location.FSTOCKSTATUSTYPE);
}
#endregion
#region 返回值
jsonRet.Data.Add("data", location);
jsonRet.Status = 1;
return jsonRet;
#endregion
}
/// <summary>
/// 查询仓库库存状态
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public async Task<RetMessage> QueryStockStatus(JObject data)
{
RetMessage jsonRet = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
var stocks = await GetStockStatus(context, string.Empty, true);
#region 返回值
jsonRet.Data.Add("data", stocks);
jsonRet.Status = 1;
return jsonRet;
#endregion
}
}
}