Files

3551 lines
173 KiB
C#
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
using Microsoft.Extensions.DependencyInjection;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using ODK.WPF.Helper;
using opsoftdata = Opsoft.Data;
using Opsoft.NetCore.O3App.Domain;
using Opsoft.NetCore.O3App.Domain.Interface;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.WMS.IRepositories;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.WMS.IServices;
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.Text;
using System.Threading.Tasks;
using System.Xml.Serialization;
using static Opsoft.NetCore.O3App.Shared.Constants;
using static System.Net.Mime.MediaTypeNames;
using Microsoft.EntityFrameworkCore;
using Opsoft.NetCore.O3App.Services.CommonFunction;
using System.Collections;
namespace Opsoft.NetCore.O3App.Services.WMS
{
[MapTo(typeof(IBarcodeService), ServiceLifetime.Transient)]
public class BarcodeService : ServiceBase<BaseEntity, IBarcodeRepository>, IBarcodeService
{
private readonly IBarcodeRepository _barcodeRepository;
public BarcodeService(IBarcodeRepository barcodeRepository)
{
Init(barcodeRepository);
_barcodeRepository = barcodeRepository;
}
public async Task<BarCodeMsg> GetBarCodeMsg(string barcode, string orgId,string billType = "")
{
var barcodes = await _barcodeRepository.GetBarcodeMsg(barcode, orgId,billType);
if (barcodes == null || barcodes.Count <= 0)
{
throw new O3AppException("未查询到条码信息");
}
return barcodes.First();
}
/// <summary>
/// MES扫描随工单二维码获取信息
/// </summary>
/// <param name="barcode"></param>
/// <returns></returns>
/// <exception cref="O3AppException"></exception>
public async Task<RetMessage> GetMESWorkOrderInfo(string barcode)
{
string FMOULD = "000";
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
#region 获取系统参数(MES)
await using opsoftdata.APPServerContext dbContext = new opsoftdata.APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
string strErr = string.Empty;
Hashtable PBCursor = dbContext.PBValue("MESConnection,C");
string MESConnection = Convert.ToString(PBCursor["MESConnection"]);
if (string.IsNullOrWhiteSpace(MESConnection))
{
result.Status = 0;
result.Message = $"取得MES信息出错:请求MES地址未配置!";
return result;
}
MySqlUtils mySqlUtils = new MySqlUtils();
mySqlUtils.ConnectionString = MESConnection;
mySqlUtils.GetConnection();
#endregion
try
{
#region 校验参数
if (barcode.IsNullOrWhiteSpace())
{
result.Message = "条码为空!";
return result;
}
#endregion
#region 拆分条码(删)
//string[] barcodes = barcode.Split('#');
//if(barcodes.Length <= 0)
//{
// result.Message = "条码格式错误!";
// return result;
//}
//string FBILLNO = barcodes[1].ToStringEx();
//string FNO = barcodes[4].ToStringEx();
//string FSN = barcodes[5].ToStringEx();
//string FCountry = barcodes[6].ToStringEx();
#endregion
#region 拆分条码
string[] barcodes = barcode.Split('#');
if (barcodes.Length <= 0)
{
result.Message = "条码格式错误!";
return result;
}
string FTaskNum = barcodes[0].ToStringEx();
string FProcessNumber = barcodes[1].ToStringEx();
#endregion
#region 获取MES任务单信息
string MESSQL = $@"SELECT S.machine_no ,S.sn ,S.order_country,S.order_num ,S.securityType,S1.process_name
from i9qco_production_task_bill S
left join i9qco_production_task_detail S1 on S.id= S1.parentId
where S.task_no = '{FTaskNum}' and S1.process_num = '{FProcessNumber}' ";
DataTable MESdt = mySqlUtils.ExecQuery(MESSQL);
if (MESdt == null || MESdt.Rows.Count <= 0)
{
result.Message = $"当前任务单【{FTaskNum}】不存在!";
return result;
}
string FNO = MESdt.Rows[0]["machine_no"].ToStringEx();
string FSN = MESdt.Rows[0]["sn"].ToStringEx();
string FCountry = MESdt.Rows[0]["order_country"].ToStringEx();
string FBILLNO = MESdt.Rows[0]["order_num"].ToStringEx();
string FSecurityType = MESdt.Rows[0]["securityType"].ToStringEx();
string FProcessName = MESdt.Rows[0]["process_name"].ToStringEx();
string UserSQL = $@"SELECT id from h_org_user
WHERE userId = '{LoginInfo.UserID}'";
DataTable Userdt = mySqlUtils.ExecQuery(UserSQL);
string UserID = "8a8a8aeb8dd6357b018dd8aac79d2989";
if (Userdt != null && Userdt.Rows.Count > 0)
{
UserID = Userdt.Rows[0]["id"].ToStringEx();
}
#endregion
#region 判断OQC检验是否检验
string OQCSQL = $@"SELECT S.rule_num,S1.schedule
from i9qco_production_task_bill S
inner join i9qco_production_task_detail S1 on S.id= S1.parentId
where S.task_no = '{FTaskNum}' and S1.process_type = 'OQC检验' ";
DataTable OQCdt = mySqlUtils.ExecQuery(OQCSQL);
if(OQCdt != null && OQCdt.Rows.Count> 0)
{
if(OQCdt.Rows[0]["rule_num"].ToStringEx().Equals("GSS") || OQCdt.Rows[0]["rule_num"].ToStringEx().Equals("GS50") || (OQCdt.Rows[0]["rule_num"].ToStringEx().Equals("GS40")))
{
if (OQCdt.Rows[0]["schedule"].ToInt32() == 1)
{
}
else
{
result.Status = 0;
result.Message = $"当前任务单OQC检验工序未完工!";
return result;
}
}
}
#endregion
#region 判断打包工序是否开工
string MESReport = $@"SELECT * from i9qco_process_log
WHERE task_num = '{FTaskNum}' and process_num ='{FProcessNumber}' and process_status_key ='option1'";
DataTable Reportdt = mySqlUtils.ExecQuery(MESReport);
if (Reportdt == null || Reportdt.Rows.Count <= 0)
{
string ReportIns = $@"INSERT into i9qco_process_log
(id,creater,createdDeptId,owner,ownerDeptId,createdTime,modifier,modifiedTime
,sequenceNo,sequenceStatus,ownerDeptQueryCode,version,order_no,task_num,process_num,process_name
,start_time,process_status,process_status_key,wagon_num,documentType)
values
('{Guid.NewGuid().ToStringEx()}','{UserID}','8a8a8aeb8de90207018de9ce9128017e','{UserID}','8a8a8aeb8de90207018de9ce9128017e','{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}','{UserID}','{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}'
,'{Guid.NewGuid().ToStringEx()}','COMPLETED','1_1#CP240224090215689#CP240227050405622',0,'{FBILLNO}','{FTaskNum}','{FProcessNumber}','{FProcessName}'
,'{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}','开工','option1','{FNO}','标准生产')";
mySqlUtils.ExecuteNonQuery(ReportIns);
}
#endregion
#region 抓取条码
var barcodeInfoSqlStr = string.Empty;
FSN = FSN.IsNullOrEmpty() ? "/" : FSN;
barcodeInfoSqlStr =
$@" SELECT top 1 S.FBARCODE,S.FMODELNO,S.FSN ,S.FMOBILLNO,S1.FISOUT
from T_BD_BARCODERS2 S
left join T_BD_BARCODERS S1 on S.FBARCODE = S1.FBARCODE
where S.FMODELNO = '{FNO}' and S.FSN = '{FSN}'
order by S1.C_YMD desc ";
#endregion
#region 校验条码信息
DataTable dt = opsoftdata.EntityFrameworkCoreExtension.SqlQuery(dbContext.Database, barcodeInfoSqlStr);
if (dt == null || dt.Rows.Count == 0)
{
result.Status = 0;
result.Message = $"成品标签信息未找到!";
return result;
}
#region 是否跳过直接打印
if(!dt.Rows[0]["FISOUT"].ToBoolean())
{
#region 判断MES打包工序是否开工
//string SQL = $@"
// SELECT S.id
// from i9qco_process_log S
// left join i9qco_workstage S1 on S.process_num = S1.process_num
// where S.task_num = '{FBILLNO}' and S1.BelongingToWorkSection = '包装工段' and S.process_status = '开工'";
//DataTable MESdt = mySqlUtils.ExecQuery(SQL);
//if (MESdt == null || MESdt.Rows.Count == 0)
//{
// result.Status = 0;
// result.Message = $"当前打包工序未开工!";
// return result;
//}
#endregion
}
#endregion
#region 标签模板
if (FCountry.Contains("中国"))
{
FMOULD = "000";
}
else
{
FMOULD = "001";
}
#endregion
result.Data.Add("data", new Dictionary<string, object>
{
{"FBARCODE",dt.Rows[0]["FBARCODE"].ToStringEx()},
{"FMODELNO",dt.Rows[0]["FMODELNO"].ToStringEx()},
{"FSN",dt.Rows[0]["FSN"].ToStringEx()},
{"FMOULD",FMOULD},
{"FMOBILLNO",dt.Rows[0]["FMOBILLNO"].ToStringEx()}
});
#endregion
result.Status = 1;
return result;
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
finally
{
mySqlUtils.Dispose();
}
}
/// <summary>
/// 盘点扫描条码,验证条码状态
/// </summary>
/// <param name="barcode"></param>
/// <param name="billType"></param>
/// <param name="orgId"></param>
/// <returns></returns>
public async Task<RetMessage> GetStockTakingBarcodeInfo(string barcode, string orgId)
{
int barcodeInfoDtoType = 3;
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
#region 校验参数
if (barcode.IsNullOrWhiteSpace())
{
result.Message = "条码为空!";
return result;
}
var mixBoxFactorStr = "";
#endregion
#region 抓取条码
var barcodeInfoSqlStr = string.Empty;
barcodeInfoSqlStr =
$@" SELECT
T1.FBARCODE,
T1.FBARTYPE,
T1.FBARCODESTATUS,
T1.FMATERIALID,
T2.FNUMBER AS FMATERIALNUMBER,
T2.FNAME AS FMATERIALNAME,
T2.FSPECIFICATION,
T1.FQTY,
T1.FUNITID,
T1.FBASEQTY,
T1.FBASEUNITID,
T1.FDELETED,
T1.FCOMPANYID,
T1.FSTOCKSTATUSID,
T5.FNAME AS FSTOCKSTATUSNAME,
T1.FSTOCKID,
T1.FSTOCKLOCID,
T3.FMODELNO
FROM T_BD_BARCODERS T1
LEFT JOIN T_BD_MATERIAL T2 ON T2.FINTERID=T1.FMATERIALID
LEFT JOIN T_BD_BARCODERS2 T3 ON T1.FBARCODE = T3.FBARCODE
LEFT JOIN T_BD_STOCKSTATUS T5 ON T5.FNUMBER=T1.FSTOCKSTATUSID
WHERE T1.FBARCODE='{barcode}'
order by T1.C_YMD desc";
var barcodeInfoStr = await _barcodeRepository.GetScanBarcodeInfoAsync(barcodeInfoSqlStr, barcodeInfoDtoType);
#endregion
#region 校验条码信息
var barcodeInfoList = JsonOperator.JsonDeserialize<List<BarcodeInfoDto4>>(barcodeInfoStr);
if (barcodeInfoList == null || barcodeInfoList.Count == 0)
{
result.Message = $"条码【{barcode}】信息未找到!";
return result;
}
var barcodeInfo = barcodeInfoList.FirstOrDefault();
string strSQL = $@"select * from ODK_StockTakingData
where FNO = '{barcodeInfo.FMODELNO}'";
await using opsoftdata.APPServerContext dbContext = new opsoftdata.APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
DataTable dt = opsoftdata.EntityFrameworkCoreExtension.SqlQuery(dbContext.Database, strSQL);
if (dt != null && dt.Rows.Count > 0)
{
result.Status = 0;
result.Message = $"车号【{barcodeInfo.FMODELNO}】已盘点!";
return result;
}
result.Data.Add("data", new Dictionary<string, object>
{
{"FBARCODE",barcode},
{"FBARTYPE",barcodeInfo.FBARTYPE},
{"FBARCODESTATUS",barcodeInfo.FBARCODESTATUS},
{"FMATERIALID",barcodeInfo.FMATERIALID},
{"FMATERIALNUMBER",barcodeInfo.FMATERIALNUMBER},
{"FMATERIALNAME",barcodeInfo.FMATERIALNAME},
{"FSPECIFICATION",barcodeInfo.FSPECIFICATION},
{"FQTY",barcodeInfo.FQTY},
{"FBASEQTY",barcodeInfo.FBASEQTY},
{"FMODELNO",barcodeInfo.FMODELNO},
{"FSTOCKSTATUSID",barcodeInfo.FSTOCKSTATUSID},
{"FSTOCKID",barcodeInfo.FSTOCKID},
{"FSTOCKLOCID",barcodeInfo.FSTOCKLOCID},
{"FSTOCKADDLOCID",barcodeInfo.FSTOCKID+","+barcodeInfo.FSTOCKLOCID}
});
#endregion
result.Status = 1;
return result;
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 盘点条码录入
/// </summary>
/// <param name="inputDto"></param>
/// <returns></returns>
/// <exception cref="O3AppException"></exception>
public async Task<RetMessage> ImportStockTakingBarCode(ImportBarcodeDto inputDto)
{
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
List<string> BarCodeList = new List<string>();
try
{
#region 校验参数
if (inputDto == null)
{
result.Message = "提交参数为空!";
return result;
}
if (inputDto.InBoxInfo == null || inputDto.InBoxInfo.Count == 0)
{
result.Message = "提交的条码信息为空!";
return result;
}
#endregion
List<string> sqlList = new List<string>();
string SQL = string.Empty, strSQL = string.Empty;
await using opsoftdata.APPServerContext dbContext = new opsoftdata.APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
foreach (var inStockTaking in inputDto.InBoxInfo)
{
strSQL = $@"select * from ODK_StockTakingData
where FNO = '{inStockTaking.FNO}'";
DataTable dt = opsoftdata.EntityFrameworkCoreExtension.SqlQuery(dbContext.Database, strSQL);
if (dt != null && dt.Rows.Count > 0)
{
result.Status = 0;
result.Message = $"车号【{inStockTaking.FNO}】已盘点!";
return result;
}
string FCURRID = Guid.NewGuid().ToString();
string UID = Guid.NewGuid().ToString();
SQL = $@"insert into ODK_StockTakingData(FNO,FBARCODE,FORGID,FINTERID,C_YMD,C_USER,UID)
values('{inStockTaking.FNO}','{inStockTaking.Barcode}','{inputDto.orgid}','{FCURRID}','{DateTime.Now}','{LoginInfo.UserID}','{UID}')";
sqlList.Add(SQL);
BarCodeList.Add(inStockTaking.Barcode);
}
if (sqlList.Count > 0)
{
try
{
await dbContext.Database.BeginTransactionAsync();
//执行SQL
opsoftdata.EntityFrameworkCoreExtension.SqlQuery(dbContext.Database, sqlList);
await dbContext.Database.CommitTransactionAsync();
}
catch (System.Exception ex)
{
await dbContext.Database.RollbackTransactionAsync().ConfigureAwait(false);
result.Message = "执行事务操作异常," + ex.Message;
return result;
}
}
result.Status = 1;
result.Data.Add("data", BarCodeList);
return result;
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 扫描条码,验证条码状态
/// </summary>
/// <param name="barcode"></param>
/// <param name="billType"></param>
/// <param name="orgId"></param>
/// <returns></returns>
public async Task<RetMessage> GetBarcodeInfo(string barcode, int billType, string orgId, bool isMix = false)
{
int barcodeInfoDtoType = 0;
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
#region 校验参数
if (barcode.IsNullOrWhiteSpace())
{
result.Message = "条码为空!";
return result;
}
if (billType <= 0 || billType > 4)
{
result.Message = "单据类型为空!";
return result;
}
var mixBoxFactorStr = "";
if (isMix)
{
var sysParas = await _barcodeRepository.GetSystemParameters("MixBoxFactor,C");
if (!sysParas["MixBoxFactor"].ToString().IsNullOrWhiteSpace())
{
mixBoxFactorStr = sysParas["MixBoxFactor"].ToString();
}
}
else
{
mixBoxFactorStr = "FMATERIALID,FUNITID,FAUXPROPID,FLOT,FKFDATE";
}
#endregion
#region 抓取条码
var barcodeInfoSqlStr = string.Empty;
switch (billType)
{
case 1://装箱
case 3://条码拆分
case 4://条码合并
{
barcodeInfoSqlStr =
$@"SELECT
T1.FBARCODE,
T1.FBARTYPE,
T1.FBARCODESTATUS,
T1.FISBOX,
T1.FBOXCODETYPE,
T1.FISMIX,
T1.FINBOX,
T1.FLOT,
T1.FMATERIALID,
T2.FNUMBER AS FMATERIALNUMBER,
T2.FNAME AS FMATERIALNAME,
T2.FSPECIFICATION,
T1.FQTY,
T1.FUNITID,
T3.FNAME AS FUNITNAME,
T1.FBASEQTY,
T1.FBASEUNITID,
T4.FNAME AS FBASEUNITNAME,
T1.FDELETED,
T1.FCOMPANYID,
T1.FAUXPROPID,
T1.FKFDATE,
T1.FUSEFULDATE,
T1.FSTOCKSTATUSID,
T5.FNAME AS FSTOCKSTATUSNAME,
T1.FSTOCKID,
T1.FSTOCKLOCID
FROM T_BD_BARCODERS T1
LEFT JOIN T_BD_MATERIAL T2 ON T2.FINTERID=T1.FMATERIALID
LEFT JOIN T_BD_UNIT T3 ON T3.FINTERID=T1.FUNITID
LEFT JOIN T_BD_UNIT T4 ON T4.FINTERID=T1.FBASEUNITID
LEFT JOIN T_BD_STOCKSTATUS T5 ON T5.FNUMBER=T1.FSTOCKSTATUSID
WHERE T1.FBARCODE='{barcode}'";
barcodeInfoDtoType = 1;
break;
}
case 2://拆箱
{
barcodeInfoSqlStr =
$@"SELECT
T1.FBARCODE,
T1.FBARTYPE,
T1.FISBOX,
T1.FBOXCODETYPE,
T1.FINBOX,
T1.FQTY,
T1.FDELETED
FROM T_BD_BARCODERS T1
WHERE T1.FBARCODE='{barcode}'";
barcodeInfoDtoType = 2;
break;
}
default:
{
result.Message = "单据类型未定义!";
return result;
}
}
if (!orgId.IsNullOrWhiteSpace())
{
barcodeInfoSqlStr += $" AND (T1.FCOMPANYID='{orgId}' OR T1.FCOMPANYID='')";
}
var barcodeInfoStr = await _barcodeRepository.GetScanBarcodeInfoAsync(barcodeInfoSqlStr, barcodeInfoDtoType);
#endregion
#region 校验条码信息
switch (barcodeInfoDtoType)
{
case 1://装箱、拆分、合并
{
var barcodeInfoList = JsonOperator.JsonDeserialize<List<BarcodeInfoDto1>>(barcodeInfoStr);
if (barcodeInfoList == null || barcodeInfoList.Count == 0)
{
result.Message = $"条码【{barcode}】信息未找到!";
return result;
}
if (barcodeInfoList.Count > 1)
{
result.Message = $"条码【{barcode}】信息存在多条!";
return result;
}
var barcodeInfo = barcodeInfoList.FirstOrDefault();
if (barcodeInfo.FCOMPANYID != orgId)
{
result.Message = $"条码【{barcode}】不属于当前组织!";
return result;
}
if (barcodeInfo.FDELETED != null && barcodeInfo.FDELETED.Value)
{
result.Message = $"条码【{barcode}】已禁用!";
return result;
}
if (barcodeInfo.FBARTYPE == null || barcodeInfo.FBARTYPE != 1 && barcodeInfo.FBARTYPE != 2 && barcodeInfo.FBARTYPE != 3)
{
result.Message = $"条码【{barcode}】类别未定义!";
return result;
}
if (barcodeInfo.FISBOX == null)
{
result.Message = $"条码【{barcode}】箱码状态未定义!";
return result;
}
if (barcodeInfo.FINBOX == null)
{
result.Message = $"条码【{barcode}】装箱状态未定义!";
return result;
}
if (!(barcodeInfo.FBARTYPE.Value == 3 && !barcodeInfo.FISBOX.Value) && barcodeInfo.FINBOX.Value)
{
result.Message = $"条码【{barcode}】已装箱!";
return result;
}
if (barcodeInfo.FQTY == null)
{
result.Message = $"条码【{barcode}】数量未定义!";
return result;
}
if (barcodeInfo.FQTY != null && barcodeInfo.FQTY <= 0)
{
result.Message = $"条码【{barcode}】数量等于零!";
return result;
}
switch (billType)
{
#region 装箱
case 1:
if (barcodeInfo.FBARTYPE == 3)
{
result.Message = $"条码【{barcode}】为批次条码,不可以装箱!";
return result;
}
var mixBoxFactor = string.Empty;
if (!mixBoxFactorStr.IsNullOrWhiteSpace())
{
List<string> listData = mixBoxFactorStr.Split(',').ToList();
listData.ForEach(o =>
{
if (o.Equals("FKFDATE"))
{
if(barcodeInfo[o] != null)
mixBoxFactor += CheckDateTime.FormatDate(barcodeInfo[o]);
}
else
{
mixBoxFactor += barcodeInfo[o].Null2Empty();
}
});
}
result.Data.Add("data", new Dictionary<string, object>
{
{"FBARCODE",barcode},
{"FBARTYPE",barcodeInfo.FBARTYPE},
{"FBARCODESTATUS",barcodeInfo.FBARCODESTATUS},
{"FMATERIALID",barcodeInfo.FMATERIALID},
{"FMATERIALNUMBER",barcodeInfo.FMATERIALNUMBER},
{"FMATERIALNAME",barcodeInfo.FMATERIALNAME},
{"FSPECIFICATION",barcodeInfo.FSPECIFICATION},
{"FLOT",barcodeInfo.FLOT},
{"FQTY",barcodeInfo.FQTY},
{"FUNITID",barcodeInfo.FUNITID},
{"FUNITNAME",barcodeInfo.FUNITNAME},
{"FBASEQTY",barcodeInfo.FBASEQTY},
{"FBASEUNITID",barcodeInfo.FBASEUNITID},
{"FBASEUNITNAME",barcodeInfo.FBASEUNITNAME},
{"FISBOX",barcodeInfo.FISBOX},
{"MixBoxFactor",mixBoxFactor},
{"FSTOCKSTATUSID",barcodeInfo.FSTOCKSTATUSID},
{"FUSEFULDATE",barcodeInfo.FUSEFULDATE},
{"FSTOCKID",barcodeInfo.FSTOCKID},
{"FSTOCKLOCID",barcodeInfo.FSTOCKLOCID},
{"FSTOCKADDLOCID",barcodeInfo.FSTOCKID+","+barcodeInfo.FSTOCKLOCID}
});
break;
#endregion
#region 拆分
case 3:
if (barcodeInfo.FISBOX.Value)
{
result.Message = $"条码【{barcode}】是箱码,不可以拆分!";
return result;
}
if (barcodeInfo.FINBOX.Value)
{
result.Message = $"条码【{barcode}】已装箱,不可以拆分!";
return result;
}
if (barcodeInfo.FBARTYPE == 1)
{
result.Message = $"条码【{barcode}】是单品,不可以拆分!";
return result;
}
if (barcodeInfo.FBARTYPE == 3)
{
result.Message = $"条码【{barcode}】为批次条码,不可以拆分!";
return result;
}
result.Data.Add("data", new Dictionary<string, object>
{
{"FBARCODE",barcode},
{"FBARTYPE",barcodeInfo.FBARTYPE},
{"FBARCODESTATUS",barcodeInfo.FBARCODESTATUS},
{"FMATERIALID",barcodeInfo.FMATERIALID},
{"FMATERIALNUMBER",barcodeInfo.FMATERIALNUMBER},
{"FMATERIALNAME",barcodeInfo.FMATERIALNAME},
{"FSPECIFICATION",barcodeInfo.FSPECIFICATION},
{"FLOT",barcodeInfo.FLOT},
{"FQTY",barcodeInfo.FQTY},
{"FUNITID",barcodeInfo.FUNITID},
{"FUNITNAME",barcodeInfo.FUNITNAME},
{"FISBOX",barcodeInfo.FISBOX},
});
break;
#endregion
#region 合并
case 4:
if (barcodeInfo.FISBOX.Value)
{
result.Message = $"条码【{barcode}】是箱码,不可以合并!";
return result;
}
if (barcodeInfo.FINBOX.Value)
{
result.Message = $"条码【{barcode}】已装箱,不可以合并!";
return result;
}
if (barcodeInfo.FBARTYPE == 3)
{
result.Message = $"条码【{barcode}】为批次条码,不可以合并!";
return result;
}
if (barcodeInfo.FBARTYPE == 1)
{
result.Message = $"条码【{barcode}】是单品,不可以合并!";
return result;
}
result.Data.Add("data", new Dictionary<string, object>
{
{"FBARCODE",barcode},
{"FBARTYPE",barcodeInfo.FBARTYPE},
{"FBARCODESTATUS",barcodeInfo.FBARCODESTATUS},
{"FMATERIALID",barcodeInfo.FMATERIALID},
{"FMATERIALNUMBER",barcodeInfo.FMATERIALNUMBER},
{"FMATERIALNAME",barcodeInfo.FMATERIALNAME},
{"FSPECIFICATION",barcodeInfo.FSPECIFICATION},
{"FLOT",barcodeInfo.FLOT},
{"FQTY",barcodeInfo.FQTY},
{"FUNITID",barcodeInfo.FUNITID},
{"FUNITNAME",barcodeInfo.FUNITNAME},
{"FISBOX",barcodeInfo.FISBOX},
{"FAUXPROPID",barcodeInfo.FAUXPROPID},
{"FKFDATE",barcodeInfo.FKFDATE},
{"FSTOCKSTATUSID",barcodeInfo.FSTOCKSTATUSID},
{"FUSEFULDATE",barcodeInfo.FUSEFULDATE}
});
break;
#endregion
}
break;
}
case 2://拆箱
{
var barcodeInfoList = JsonOperator.JsonDeserialize<List<BarcodeInfoDto2>>(barcodeInfoStr);
if (barcodeInfoList == null || barcodeInfoList.Count == 0)
{
result.Message = $"条码【{barcode}】信息未找到!";
return result;
}
var barcodeInfo = barcodeInfoList.FirstOrDefault();
if (barcodeInfo.FDELETED != null && barcodeInfo.FDELETED.Value)
{
result.Message = $"条码【{barcode}】已禁用!";
return result;
}
if (barcodeInfo.FBARTYPE == null || barcodeInfo.FBARTYPE != 1 && barcodeInfo.FBARTYPE != 2 && barcodeInfo.FBARTYPE != 3)
{
result.Message = $"条码【{barcode}】类别未定义!";
return result;
}
if (barcodeInfo.FISBOX == null)
{
result.Message = $"条码【{barcode}】箱码状态未定义!";
return result;
}
if (barcodeInfo.FINBOX == null)
{
result.Message = $"条码【{barcode}】装箱状态未定义!";
return result;
}
if (!(barcodeInfo.FBARTYPE.Value == 3 && !barcodeInfo.FISBOX.Value) && barcodeInfo.FINBOX.Value)
{
result.Message = $"条码【{barcode}】已装箱!";
return result;
}
if (barcodeInfo.FBARTYPE == 3)
{
result.Message = $"条码【{barcode}】为批次条码,不可以拆箱!";
return result;
}
if (barcodeInfo.FQTY == null)
{
result.Message = $"条码【{barcode}】数量未定义!";
return result;
}
if (barcodeInfo.FQTY != null && barcodeInfo.FQTY <= 0)
{
result.Message = $"条码【{barcode}】数量等于零!";
return result;
}
if (!barcodeInfo.FISBOX.Value)
{
result.Message = $"条码【{barcode}】不是箱码!";
return result;
}
var boxBarcodeEntryList = await _barcodeRepository.GetBoxedBarcodeAsync($"SELECT FBOXCODE,FBARCODE FROM T_BD_BARCODERSENTRY WHERE FBOXCODE='{barcode}'");
if (boxBarcodeEntryList == null || boxBarcodeEntryList.Count == 0)
{
result.Message = $"条码【{barcode}】中装箱信息为空!";
return result;
}
var boxedBarcodeInfoSqlStr =
$@"SELECT
T1.FBARCODE,
T1.FBARTYPE,
T1.FBARCODESTATUS,
T1.FISBOX,
T1.FBOXCODETYPE,
T1.FISMIX,
T1.FINBOX,
T1.FLOT,
T1.FMATERIALID,
T2.FNUMBER AS FMATERIALNUMBER,
T2.FNAME AS FMATERIALNAME,
T2.FSPECIFICATION,
T1.FQTY,
T1.FUNITID,
T3.FNAME AS FUNITNAME,
T1.FBASEQTY,
T1.FBASEUNITID,
T4.FNAME AS FBASEUNITNAME,
T1.FDELETED,
T1.FCOMPANYID,
S.FDETAILID
FROM T_BD_BARCODERSENTRY S
INNER JOIN T_BD_BARCODERS T1 ON T1.FBARCODE=S.FBARCODE
LEFT JOIN T_BD_MATERIAL T2 ON T2.FINTERID=T1.FMATERIALID
LEFT JOIN T_BD_UNIT T3 ON T3.FINTERID=T1.FUNITID
LEFT JOIN T_BD_UNIT T4 ON T4.FINTERID=T1.FBASEUNITID
WHERE S.FBOXCODE='{barcode}'
ORDER BY S.FBARCODE";
var infoStr = await _barcodeRepository.GetScanBarcodeInfoAsync(boxedBarcodeInfoSqlStr, 1);
result.Data.Add("data", JsonOperator.JsonDeserialize<List<BarcodeInfoDto1>>(infoStr));
break;
}
}
#endregion
result.Status = 1;
return result;
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 扫描条码,验证追加装箱条码状态
/// </summary>
/// <param name="barcode"></param>
/// <param name="orgId"></param>
/// <returns></returns>
public async Task<RetMessage> GetBarcodeInfoIsAdd(string barcode, string orgId, bool isMix = false)
{
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
#region 校验参数
if (barcode.IsNullOrWhiteSpace())
{
result.Message = "条码为空!";
return result;
}
if (orgId.IsNullOrWhiteSpace())
{
result.Message = "组织为空!";
return result;
}
var mixBoxFactorStr = "";
if (isMix)
{
var sysParas = await _barcodeRepository.GetSystemParameters("MixBoxFactor,C");
if (sysParas["MixBoxFactor"] != null)
{
mixBoxFactorStr = sysParas["MixBoxFactor"].ToString();
}
}
else
{
mixBoxFactorStr = "FMATERIALID,FUNITID,FAUXPROPID,FLOT,FKFDATE";
}
#endregion
#region 校验条码状态
bool isExist = false;
var barcodeInfoSqlStr =
$@"SELECT
T1.FBARCODE,
T1.FBARTYPE,
T1.FBARCODESTATUS,
T1.FISBOX,
T1.FBOXCODETYPE,
T1.FISMIX,
T1.FINBOX,
T1.FLOT,
T1.FAUXPROPID,
T1.FKFDATE,
T1.FMATERIALID,
T2.FNUMBER AS FMATERIALNUMBER,
T2.FNAME AS FMATERIALNAME,
T2.FSPECIFICATION,
T1.FQTY,
T1.FUNITID,
T3.FNAME AS FUNITNAME,
T1.FBASEQTY,
T1.FBASEUNITID,
T4.FNAME AS FBASEUNITNAME,
T1.FDELETED,
T1.FCOMPANYID
FROM T_BD_BARCODERS T1
LEFT JOIN T_BD_MATERIAL T2 ON T2.FINTERID=T1.FMATERIALID
LEFT JOIN T_BD_UNIT T3 ON T3.FINTERID=T1.FUNITID
LEFT JOIN T_BD_UNIT T4 ON T4.FINTERID=T1.FBASEUNITID
WHERE T1.FBARCODE='{barcode}'";
var barcodeInfoStr = await _barcodeRepository.GetScanBarcodeInfoAsync(barcodeInfoSqlStr, 1);
var barcodeInfoList = JsonOperator.JsonDeserialize<List<BarcodeInfoDto1>>(barcodeInfoStr);
if (barcodeInfoList != null && barcodeInfoList.Count > 0)
{
var barcodeInfo = barcodeInfoList.FirstOrDefault();
if (barcodeInfo.FCOMPANYID != orgId)
{
result.Message = $"箱码【{barcode}】不属于该组织!";
return result;
}
if (barcodeInfo.FMATERIALID.IsNullOrWhiteSpace())
{
result.Message = $"条码【{barcode}】物料信息为空!";
}
if (!barcodeInfo.FISBOX.Value)
{
result.Message = $"条码【{barcode}】不是箱码!";
}
if (barcodeInfo.FINBOX.Value)
{
result.Message = $"条码【{barcode}】已被装箱!";
return result;
}
isExist = true;
var boxBarcodeEntryList = await _barcodeRepository.GetBoxedBarcodeAsync($"SELECT * FROM T_BD_BARCODERSENTRY WHERE FBOXCODE='{barcode}'");
if (boxBarcodeEntryList == null || boxBarcodeEntryList.Count == 0)
{
result.Message = $"条码【{barcode}】中装箱信息为空!";
return result;
}
#region 查询装箱信息
var boxedBarcodeInfoSqlStr =
$@"SELECT
T1.FBARCODE,
T1.FBARTYPE,
T1.FBARCODESTATUS,
T1.FISBOX,
T1.FISMIX,
T1.FBOXCODETYPE,
T1.FINBOX,
T1.FLOT,
T1.FMATERIALID,
T2.FNUMBER AS FMATERIALNUMBER,
T2.FNAME AS FMATERIALNAME,
T2.FSPECIFICATION,
T1.FQTY,
T1.FUNITID,
T3.FNAME AS FUNITNAME,
T1.FBASEQTY,
T1.FBASEUNITID,
T4.FNAME AS FBASEUNITNAME,
T1.FDELETED,
T1.FCOMPANYID,
S.FDETAILID
FROM T_BD_BARCODERSENTRY S
INNER JOIN T_BD_BARCODERS T1 ON T1.FBARCODE=S.FBARCODE
LEFT JOIN T_BD_MATERIAL T2 ON T2.FINTERID=T1.FMATERIALID
LEFT JOIN T_BD_UNIT T3 ON T3.FINTERID=T1.FUNITID
LEFT JOIN T_BD_UNIT T4 ON T4.FINTERID=T1.FBASEUNITID
WHERE S.FBOXCODE='{barcode}'
ORDER BY S.FBARCODE";
var boxedBarcodeInfoStr = await _barcodeRepository.GetScanBarcodeInfoAsync(boxedBarcodeInfoSqlStr, 1);
var boxedBarcodeInfoList = JsonOperator.JsonDeserialize<List<BarcodeInfoDto1>>(boxedBarcodeInfoStr);
var mixBoxFactor = string.Empty;
if (!mixBoxFactorStr.IsNullOrWhiteSpace())
{
List<string> listData = mixBoxFactorStr.Split(',').ToList();
listData.ForEach(o =>
{
if (o.Equals("FKFDATE"))
{
mixBoxFactor += CheckDateTime.FormatDate(barcodeInfo[o]);
}
else
{
mixBoxFactor += barcodeInfo[o].Null2Empty();
}
});
}
List<BarcodeInfoDto3> barcodeList = new List<BarcodeInfoDto3>();
foreach (var info in boxedBarcodeInfoList)
{
barcodeList.Add(new BarcodeInfoDto3
{
FBARCODE = info.FBARCODE,
FBARTYPE = info.FBARTYPE,
FBARCODESTATUS = info.FBARCODESTATUS,
FMATERIALID = info.FMATERIALID,
FMATERIALNAME = info.FMATERIALNAME,
FMATERIALNUMBER = info.FMATERIALNUMBER,
FSPECIFICATION = info.FSPECIFICATION,
FLOT = info.FLOT,
FQTY = info.FQTY,
FUNITID = info.FUNITID,
FUNITNAME = info.FUNITNAME,
FBASEQTY = info.FBASEQTY,
FBASEUNITID = info.FBASEUNITID,
FBASEUNITNAME = info.FBASEUNITNAME,
FISBOX = info.FISBOX,
MIXBOXFACTOR = mixBoxFactor
});
}
result.Data.Add("isMix", barcodeInfo.FISMIX.Value);
result.Data.Add("BoxCodeType", barcodeInfo.FBOXCODETYPE);
result.Data.Add("isExist", isExist);
result.Data.Add("innerCodeQty", boxedBarcodeInfoList.Count);
result.Data.Add("barcodeList", barcodeList);
#endregion
}
#endregion
#region 返回值
result.Status = 1;
return result;
#endregion
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
throw new NotImplementedException();
}
/// <summary>
/// 条码拆分
/// </summary>
/// <param name="inputDto"></param>
/// <returns></returns>
public async Task<RetMessage> SplitBarcode(SplitInputDto inputDto)
{
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
JArray arrBarCodeInfo = new JArray();
#region 校验参数
if (inputDto == null)
{
result.Message = "参数为空!";
return result;
}
if (inputDto.SplitInfo == null || !inputDto.SplitInfo.Any())
{
result.Message = "提交的拆分信息为空!";
return result;
}
if (inputDto.RemainQty <= 0)
{
result.Message = "条码余量不能小于0!";
return result;
}
if (inputDto.Barcode.IsNullOrWhiteSpace())
{
result.Message = "原始条码信息为空!";
return result;
}
var barcode = inputDto.Barcode;
#endregion
#region 条码状态校验
var barcodeInfoList = await _barcodeRepository.GetSpMeBarcodeInfoAsync($"SELECT * FROM T_BD_BARCODERS WHERE FBARCODE='{barcode}'");
if (barcodeInfoList == null || barcodeInfoList.Count <= 0)
{
result.Message = "被拆分条码信息未找到!";
return result;
}
if (barcodeInfoList.Count > 1)
{
result.Message = "存在重复的被拆分条码信息!";
return result;
}
var barcodeInfo = barcodeInfoList.FirstOrDefault();
if (barcodeInfo.FDELETED)
{
result.Message = $"条码【{barcodeInfo.FBARCODE}】状态已改变:条码已被禁用!";
return result;
}
if (barcodeInfo.FISBOX)
{
result.Message = $"条码【{barcodeInfo.FBARCODE}】状态已改变:条码是箱码,请重新扫描!";
return result;
}
if (barcodeInfo.FINBOX)
{
result.Message = $"条码【{barcodeInfo.FBARCODE}】状态已改变:条码被装箱,请重新扫描!";
return result;
}
var remainQty = inputDto.RemainQty;
var splitInfoList = inputDto.SplitInfo;
if (!inputDto.CurrentUnitId.IsNullOrEmpty() && inputDto.CurrentUnitId != barcodeInfo.FUNITID)
{
remainQty = await _barcodeRepository.GetBaseUnitQtyAsync(barcodeInfo.FMATERIALID, inputDto.CurrentUnitId, barcodeInfo.FUNITID, remainQty);
foreach (var info in splitInfoList)
{
info.Qty = await _barcodeRepository.GetBaseUnitQtyAsync(barcodeInfo.FMATERIALID, inputDto.CurrentUnitId, barcodeInfo.FUNITID, info.Qty);
}
}
var realQty = barcodeInfo.FQTY;
var splitQty = splitInfoList.Sum(o => o.Qty) - realQty;
if (splitQty > realQty)
{
result.Message = $"条码【{barcodeInfo.FBARCODE}】数量已改变:条码拆分数量大于条码剩余数量,请重新录入!";
return result;
}
remainQty = realQty - splitQty;
#endregion
#region 计算辅助单位数量
foreach (var item in splitInfoList)
{
var secUnitQtu = ((barcodeInfo.FSECUNITQTY.ToDecimal() / barcodeInfo.FQTY.ToDecimal()) * item.Qty.ToDecimal()).ToDecimal();
item.FSECUNITQTY = Math.Round(secUnitQtu, 6);
if (item.Barcode.ToStringEx() == "")
{
splitInfoList[0].FSECUNITQTY = Math.Round(splitInfoList[0].FSECUNITQTY.ToDecimal() - secUnitQtu, 6);
}
}
#endregion
#region 拆分明细
List<string> splitBarcodes = new List<string>();
var interId = Guid.NewGuid();
var detailId = Guid.NewGuid();
//需要执行的sql
List<string> sqlStrList = new List<string>();
#region 更新被拆分条码数量
string exeSql = string.Empty;
if (remainQty <= 0)
{
exeSql = $"UPDATE T_BD_BARCODERS SET FQTY=0,FBASEQTY=0,FSECUNITQTY=0, FDELETED=1,FBARCODESTATUS=3 WHERE FBARCODE='{barcodeInfo.FBARCODE}'";
}
else
{
var baseUnitQty = await _barcodeRepository.GetBaseUnitQtyAsync(barcodeInfo.FMATERIALID, barcodeInfo.FUNITID, barcodeInfo.FBASEUNITID, remainQty);
exeSql = $"UPDATE T_BD_BARCODERS SET FQTY={remainQty},FBASEQTY={baseUnitQty},FSECUNITQTY={splitInfoList[0].FSECUNITQTY.ToDecimal()},FBARCODESTATUS=3 WHERE FBARCODE='{barcodeInfo.FBARCODE}'";
}
sqlStrList.Add(exeSql);
#endregion
#region 向条码变更表插入数据
var date = DateTime.Now;
var insertChangeTableSqlStr =
$@"INSERT INTO T_BD_BARCODERSCHANGE
(
FINTERID,
FBILLNO,
FBILLTYPE,
FDATE,
UID,
C_YMD,
C_USER,
FDELETED,
FSTATUS
)
VALUES
(
'{interId}',
'{await _barcodeRepository.CreateBillNo(new JObject
{
{"FDATE",date},
{"FBILLTYPE",2}
}.ToString(Formatting.None, null))}',
{2},
'{date}',
'{Guid.NewGuid()}',
'{date}',
'{LoginInfo.UserID}',
{0},
{40}
)";
sqlStrList.Add(insertChangeTableSqlStr);
#endregion
#region 向条码变更前表插入数据
var insertChangeBeforeTableSqlStr =
$@"INSERT INTO T_BD_BARCODERSCHANGEBEFORE
(
FINTERID,
FDETAILID,
FENTRYID,
FRELATIONID,
FCHANGESTATUS,
FSTOCKSTATUS,
FBARCODE,
FMATERIALID,
FLOT,
FAUXPROPID,
FKFDATE,
FBARTYPE,
FBARCODESTATUS,
FISBOX,
FUNITID,
FQTY,
FBASEUNITID,
FBASEUNITQTY,
FINSPECTDATE,
FINSPECTID,
FSUPPLYID,
FMFGDATE,
FKID,
UID,
C_YMD,
C_USER,
FDELETED,
FSTATUS,
FSTOCKSTATUSID,
FUSEFULDATE
)
VALUES
(
'{interId}',
'{detailId}',
{1},
'{detailId}',
{2},
{barcodeInfo.FSTOCKSTATUS},
'{barcodeInfo.FBARCODE}',
'{barcodeInfo.FMATERIALID}',
'{barcodeInfo.FLOT}',
'{barcodeInfo.FAUXPROPID}',
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
{barcodeInfo.FBARTYPE},
{barcodeInfo.FBARCODESTATUS},
{barcodeInfo.FISBOX.ToInt()},
'{barcodeInfo.FUNITID}',
{barcodeInfo.FQTY},
'{barcodeInfo.FBASEUNITID}',
{barcodeInfo.FBASEQTY},
{(barcodeInfo.FINSPECTDATE == null ? "null" : "'" + barcodeInfo.FINSPECTDATE.Value.ToString() + "'")},
'{barcodeInfo.FINSPECTID}',
'{barcodeInfo.FSUPPLYID}',
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
{barcodeInfo.FKID},
'{Guid.NewGuid()}',
'{date}',
'{LoginInfo.UserID}',
{0},
{40},
'{barcodeInfo.FSTOCKSTATUSID}',
'{barcodeInfo.FUSEFULDATE}'
)";
sqlStrList.Add(insertChangeBeforeTableSqlStr);
#endregion
#region 向条码变更后表、条码主档表插入数据
#region 查询其他辅助条码表信息
List<string> barcodersEntrySql = new List<string>
{
$"SELECT * FROM T_BD_BARCODERS1 WHERE FBARCODE='{barcode}'",
$"SELECT * FROM T_BD_BARCODERS2 WHERE FBARCODE='{barcode}'",
$"SELECT * FROM T_BD_BARCODERS3 WHERE FBARCODE='{barcode}'",
$"SELECT * FROM T_BD_BARCODERS4 WHERE FBARCODE='{barcode}'",
$"SELECT * FROM T_BD_BARCODERS5 WHERE FBARCODE='{barcode}'"
};
var barcodersEntryDataSet = await _barcodeRepository.GetDataSet(barcodersEntrySql);
var entry = barcodersEntryDataSet.Tables.Cast<DataTable>().FirstOrDefault(o => o.Rows.Count > 0);
var index = barcodersEntryDataSet.Tables.IndexOf(entry);
#endregion
int entryId = 1;
string newBarcode = "";
foreach (var info in splitInfoList)
{
if (info.Barcode.IsNullOrWhiteSpace())
{
newBarcode = await _barcodeRepository.CreateBarcode(JObject.FromObject(barcodeInfo).ToString(Formatting.None), "STK_BARCODESPLIT");
}
else
{
newBarcode = info.Barcode;
}
var insertChangeAfterTableSqlStr =
$@"INSERT INTO T_BD_BARCODERSCHANGEAFTER
(
FINTERID,
FDETAILID,
FENTRYID,
FRELATIONID,
FCHANGESTATUS,
FSTOCKSTATUS,
FBARCODE,
FMATERIALID,
FLOT,
FAUXPROPID,
FKFDATE,
FBARTYPE,
FBARCODESTATUS,
FUNITID,
FQTY,
FBASEUNITID,
FBASEUNITQTY,
FINSPECTDATE,
FINSPECTID,
FSUPPLYID,
FMFGDATE,
FKID,
UID,
C_YMD,
C_USER,
FDELETED,
FSTATUS,
FSTOCKSTATUSID,
FUSEFULDATE
)
VALUES
(
'{interId}',
'{Guid.NewGuid()}',
{entryId},
'{detailId}',
{2},
{barcodeInfo.FSTOCKSTATUS},
'{newBarcode}',
'{barcodeInfo.FMATERIALID}',
'{barcodeInfo.FLOT}',
'{barcodeInfo.FAUXPROPID}',
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
{barcodeInfo.FBARTYPE},
{barcodeInfo.FBARCODESTATUS},
'{barcodeInfo.FUNITID}',
{(entryId == 1 ? info.Qty - splitQty : info.Qty)},
'{barcodeInfo.FBASEUNITID}',
{await _barcodeRepository.GetBaseUnitQtyAsync(barcodeInfo.FMATERIALID, barcodeInfo.FUNITID, barcodeInfo.FBASEUNITID, (entryId == 1 ? info.Qty - splitQty : info.Qty))},
{(barcodeInfo.FINSPECTDATE == null ? "null" : "'" + barcodeInfo.FINSPECTDATE.Value.ToString() + "'")},
'{barcodeInfo.FINSPECTID}',
'{barcodeInfo.FSUPPLYID}',
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
{barcodeInfo.FKID},
'{Guid.NewGuid()}',
'{DateTime.Today}',
'{LoginInfo.UserID}',
{0},
{40},
'{barcodeInfo.FSTOCKSTATUSID}',
'{barcodeInfo.FUSEFULDATE}'
)";
sqlStrList.Add(insertChangeAfterTableSqlStr);
if (entryId > 1)
{
var insertBarcodersTableSqlStr =
$@"INSERT INTO T_BD_BARCODERS
(
[FTOTALQTY]
,[FMFGDATE]
,[FOBARCODE]
,[FMATERIALID]
,[FBARCODESTATUS]
,[FBARCODE]
,[FISBOX]
,[FISMIX]
,[FLOTID]
,[FLOT]
,[FSTOCKSTATUS]
,[FINSPECTDATE]
,[FINSPECTID]
,[FSUPPLYID]
,[FAUXPROPID]
,[FDATE]
,[FKID]
,[FQTY]
,[FSECUNITQTY]
,[FSECUNITID]
,[FUNITID]
,[FSTOCKLOCID]
,[FSTOCKID]
,[FCURRID]
,[FKFDATE]
,[FINTERID]
,[FSTATUS]
,[FDELETED]
,[FCOMPANYID]
,[FBARTYPE]
,[FBASEQTY]
,[FBASEUNITID]
,[UID]
,[C_YMD]
,[C_USER]
,[FKEEPERTYPEID]
,[FKEEPERID]
,[FOWNERTYPEID]
,[FOWNERID]
,[FSTOCKSTATUSID]
,[FUSEFULDATE]
)
VALUES
(
{barcodeInfo.FTOTALQTY},
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
'{barcodeInfo.FOBARCODE}',
'{barcodeInfo.FMATERIALID}',
{barcodeInfo.FBARCODESTATUS},
'{newBarcode}',
{barcodeInfo.FISBOX.ToInt()},
{barcodeInfo.FISMIX.ToInt()},
'{barcodeInfo.FLOTID}',
'{barcodeInfo.FLOT}',
{barcodeInfo.FSTOCKSTATUS},
{(barcodeInfo.FINSPECTDATE == null ? "null" : "'" + barcodeInfo.FINSPECTDATE.Value.ToString() + "'")},
'{barcodeInfo.FINSPECTID}',
'{barcodeInfo.FSUPPLYID}',
'{barcodeInfo.FAUXPROPID}',
'{barcodeInfo.FDATE}',
{barcodeInfo.FKID},
{info.Qty},
{info.FSECUNITQTY},
'{barcodeInfo.FSECUNITID}',
'{barcodeInfo.FUNITID}',
'{barcodeInfo.FSTOCKLOCID}',
'{barcodeInfo.FSTOCKID}',
'{barcodeInfo.FCURRID}',
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
'{barcodeInfo.FINTERID}',
{barcodeInfo.FSTATUS},
{barcodeInfo.FDELETED.ToInt()},
'{barcodeInfo.FCOMPANYID}',
{barcodeInfo.FBARTYPE},
{await _barcodeRepository.GetBaseUnitQtyAsync(barcodeInfo.FMATERIALID, barcodeInfo.FUNITID, barcodeInfo.FBASEUNITID, info.Qty)},
'{barcodeInfo.FBASEUNITID}',
'{Guid.NewGuid()}',
'{DateTime.Today}',
'{LoginInfo.UserID}'
,'{barcodeInfo.FKEEPERTYPEID}'
,'{barcodeInfo.FKEEPERID}'
,'{barcodeInfo.FOWNERTYPEID}'
,'{barcodeInfo.FOWNERID}'
,'{barcodeInfo.FSTOCKSTATUSID}'
,'{barcodeInfo.FUSEFULDATE}'
)";
sqlStrList.Add(insertBarcodersTableSqlStr);
//有源单信息
if (index >= 0)
{
string srcSql = string.Empty;
switch (index + 1)
{
case 1:
srcSql = $@"INSERT INTO T_BD_BARCODERS1
(
[FBARCODE]
,[FPOID]
,[FPODETAILID]
,[FPURID]
,[FPURDETAILID]
,[FSUPPLIERID]
,[FINSPECTID]
,[FINSPECTDATE]
,[FINTERID]
,[UID]
,[FPOBILLNO]
,[FPOENTREYID]
,[FPURBILLNO]
,[FPURENTRYID]
)
VALUES
(
'{newBarcode}',
'{entry.Rows[0]["FPOID"].ToStringEx()}',
'{entry.Rows[0]["FPODETAILID"].ToStringEx()}',
'{entry.Rows[0]["FPURID"].ToStringEx()}',
'{entry.Rows[0]["FPURDETAILID"].ToStringEx()}',
'{entry.Rows[0]["FSUPPLIERID"].ToStringEx()}',
'{entry.Rows[0]["FINSPECTID"].ToStringEx()}',
'{entry.Rows[0]["FINSPECTDATE"].ToStringEx()}',
'{barcodeInfo.FINTERID}',
'{Guid.NewGuid()}',
'{entry.Rows[0]["FPOBILLNO"].ToStringEx()}',
{entry.Rows[0]["FPOENTREYID"].ToInt()},
'{entry.Rows[0]["FPURBILLNO"].ToStringEx()}',
{entry.Rows[0]["FPURENTRYID"].ToInt()}
)";
break;
case 2:
srcSql = $@"INSERT INTO T_BD_BARCODERS2
(
[FBARCODE]
,[FMOID]
,[FMODETAILID]
,[FCUSTID]
,[FODID]
,[FODDETAILID]
,[FINTERID]
,[UID]
,[FMOBILLNO]
,[FMOENTRYID]
,[FODENTRYID]
)
VALUES
(
'{newBarcode}',
'{entry.Rows[0]["FMOID"].ToStringEx()}',
'{entry.Rows[0]["FMODETAILID"].ToStringEx()}',
'{entry.Rows[0]["FCUSTID"].ToStringEx()}',
'{entry.Rows[0]["FODID"].ToStringEx()}',
'{entry.Rows[0]["FODDETAILID"].ToStringEx()}',
'{barcodeInfo.FINTERID}',
'{Guid.NewGuid()}',
'{entry.Rows[0]["FMOBILLNO"].ToStringEx()}',
{entry.Rows[0]["FMOENTRYID"].ToInt()},
{entry.Rows[0]["FODENTRYID"].ToInt()}
)";
break;
case 3:
srcSql = $@"INSERT INTO T_BD_BARCODERS3
(
[FBARCODE]
,[FREQID]
,[FREQBILLNO]
,[FREQDETAILID]
,[FREQENTRYID]
,[FINTERID]
,[UID]
)
VALUES
(
'{newBarcode}',
'{entry.Rows[0]["FREQID"].ToStringEx()}',
'{entry.Rows[0]["FREQBILLNO"].ToStringEx()}',
'{entry.Rows[0]["FREQDETAILID"].ToStringEx()}',
{entry.Rows[0]["FREQENTRYID"].ToInt()},
'{barcodeInfo.FINTERID}',
'{Guid.NewGuid()}'
)";
break;
case 5:
srcSql = $@"INSERT INTO T_BD_BARCODERS5
(
[FBARCODE]
,[FOEMRECEIVEID]
,[FOEMRECEIVEBILLNO]
,[FOEMRECEIVEENTRYID]
,[FOEMRECEIVEDETAILID]
,[FOWNERID]
,[FODID]
,[FODDETAILID]
,[FODENTRYID]
,[FODBILLNO]
,[FINTERID]
,[UID]
)
VALUES
(
'{newBarcode}',
'{entry.Rows[0]["FOEMRECEIVEID"].ToStringEx()}',
'{entry.Rows[0]["FOEMRECEIVEBILLNO"].ToStringEx()}',
{entry.Rows[0]["FOEMRECEIVEENTRYID"].ToInt()},
'{entry.Rows[0]["FOEMRECEIVEDETAILID"].ToStringEx()}',
'{entry.Rows[0]["FOWNERID"].ToStringEx()}',
'{entry.Rows[0]["FODID"].ToStringEx()}',
'{entry.Rows[0]["FODDETAILID"].ToStringEx()}',
{entry.Rows[0]["FODENTRYID"].ToInt()},
'{entry.Rows[0]["FODBILLNO"].ToStringEx()}',
'{barcodeInfo.FINTERID}',
'{Guid.NewGuid()}'
)";
break;
}
sqlStrList.Add(srcSql);
}
JObject myBar = new JObject();
myBar.Add("fbarcode", newBarcode);
myBar.Add("fqty", info.Qty);
arrBarCodeInfo.Add(myBar);
splitBarcodes.Add(newBarcode);
}
entryId++;
}
#endregion
#endregion
#region 执行sql
if (inputDto.IsAutoSplit)
{
result.Status = 1;
result.Message = $"条码【{barcodeInfo.FBARCODE}】自动拆分SQL生成成功";
result.Data.Add("sql", sqlStrList);
result.Data.Add("barcode", splitBarcodes);
result.Data.Add("datainfo", arrBarCodeInfo);
return result;
}
await _barcodeRepository.ExecuteSqlNoneQueryAsync(sqlStrList);
#endregion
#region 返回值
result.Status = 1;
result.Message = $"条码【{barcodeInfo.FBARCODE}】拆分成功";
if (inputDto.IsPickInventory)
{
result.Data.Add("data", newBarcode);
//result.Data.Add("datainfo", arrBarCodeInfo);
}
else
{
result.Data.Add("data", splitBarcodes);
result.Data.Add("datainfo", arrBarCodeInfo);
}
return result;
#endregion
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 条码合并
/// </summary>
/// <param name="inputDto"></param>
/// <returns></returns>
public async Task<RetMessage> MergeBarcode(MergeInputDto inputDto)
{
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
#region 校验参数
if (inputDto == null)
{
result.Message = "参数为空!";
return result;
}
if (inputDto.MergeInfo == null || !inputDto.MergeInfo.Any())
{
result.Message = "提交的合并条码信息为空!";
return result;
}
var mergeInfoList = inputDto.MergeInfo;
#endregion
#region 条码状态校验
var mergeBarcodeInfoSqlStr = $"SELECT * FROM T_BD_BARCODERS WHERE FBARCODE IN ({string.Join(",", mergeInfoList.Select(o => "'" + o.Barcode + "'").ToList())})";
var mergeBarcodeInfoList = await _barcodeRepository.GetSpMeBarcodeInfoAsync(mergeBarcodeInfoSqlStr);
if (mergeBarcodeInfoList == null || mergeBarcodeInfoList.Count == 0)
{
result.Message = "合并条码信息未找到!";
return result;
}
if (mergeBarcodeInfoList.Select(t => t.FSTOCKID).Distinct().Count() > 1)
{
result.Message = "条码仓库不一致,不能合并!";
return result;
}
if(mergeBarcodeInfoList.Select(o => o.FSTOCKLOCID).Distinct().Count() > 1)
{
result.Message = "条码仓位不一致,不能合并!";
return result;
}
foreach (var info in mergeInfoList)
{
var barcodeInfo = mergeBarcodeInfoList.FirstOrDefault(o => o.FBARCODE == info.Barcode);
if (barcodeInfo != null)
{
if (barcodeInfo.FDELETED)
{
result.Message = $"条码【{info.Barcode}】状态已改变:条码已禁用!";
return result;
}
if (barcodeInfo.FBARTYPE != 1)
{
if (barcodeInfo.FISBOX)
{
result.Message = $"条码【{info.Barcode}】状态已改变:条码是箱码!";
return result;
}
if (barcodeInfo.FINBOX)
{
result.Message = $"条码【{info.Barcode}】状态已改变:条码被装箱!";
return result;
}
}
if (mergeBarcodeInfoList[0].FKEEPERTYPEID.ToStringEx() != barcodeInfo.FKEEPERTYPEID.ToStringEx())
{
result.Message = $"条码【{info.Barcode}】与条码【{mergeBarcodeInfoList[0].FBARCODE.ToStringEx()}】保管者类型不同!";
return result;
}
if (mergeBarcodeInfoList[0].FKEEPERID.ToStringEx() != barcodeInfo.FKEEPERID.ToStringEx())
{
result.Message = $"条码【{info.Barcode}】与条码【{mergeBarcodeInfoList[0].FBARCODE.ToStringEx()}】保管者不同!";
return result;
}
if (mergeBarcodeInfoList[0].FOWNERTYPEID.ToStringEx() != barcodeInfo.FOWNERTYPEID.ToStringEx())
{
result.Message = $"条码【{info.Barcode}】与条码【{mergeBarcodeInfoList[0].FBARCODE.ToStringEx()}】货主类型不同!";
return result;
}
if (mergeBarcodeInfoList[0].FOWNERID.ToStringEx() != barcodeInfo.FOWNERID.ToStringEx())
{
result.Message = $"条码【{info.Barcode}】与条码【{mergeBarcodeInfoList[0].FBARCODE.ToStringEx()}】货主不同!";
return result;
}
if (mergeBarcodeInfoList[0].FUSEFULDATE.ToStringEx() != barcodeInfo.FUSEFULDATE.ToStringEx())
{
result.Message = $"条码【{info.Barcode}】与条码【{mergeBarcodeInfoList[0].FBARCODE.ToStringEx()}】有效期至不同!";
return result;
}
if (mergeBarcodeInfoList[0].FSTOCKSTATUSID.ToStringEx() != barcodeInfo.FSTOCKSTATUSID.ToStringEx())
{
result.Message = $"条码【{info.Barcode}】与条码【{mergeBarcodeInfoList[0].FBARCODE.ToStringEx()}】库存状态不同!";
return result;
}
}
else
{
result.Message = $"条码【{info.Barcode}】信息未找到!";
return result;
}
}
#endregion
#region 合并明细
var interId = Guid.NewGuid();
var detailId = Guid.NewGuid();
List<string> sqlStrList = new List<string>();
#region 向条码变更表插入数据
var date = DateTime.Now;
var insertChangeTableSqlStr =
$@"INSERT INTO T_BD_BARCODERSCHANGE
(
FINTERID,
FBILLNO,
FBILLTYPE,
FDATE,
UID,
C_YMD,
C_USER,
FDELETED,
FSTATUS
)
VALUES
(
'{interId}',
'{await _barcodeRepository.CreateBillNo(new JObject
{
{"FDATE",date},
{"FBILLTYPE",2}
}.ToString(Formatting.None, null))}',
{1},
'{date}',
'{Guid.NewGuid()}',
'{date}',
'{LoginInfo.UserID}',
{0},
{40}
)";
sqlStrList.Add(insertChangeTableSqlStr);
#endregion
#region 向条码变更前表插入数据并更新条码主档
int entryId = 1;
foreach (var info in mergeBarcodeInfoList)
{
var insertChangeBeforeTableSqlStr =
$@"INSERT INTO T_BD_BARCODERSCHANGEBEFORE
(
FINTERID,
FDETAILID,
FENTRYID,
FRELATIONID,
FSTOCKSTATUS,
FCHANGESTATUS,
FBARCODE,
FMATERIALID,
FLOT,
FAUXPROPID,
FKFDATE,
FBARTYPE,
FBARCODESTATUS,
FUNITID,
FQTY,
FBASEUNITID,
FBASEUNITQTY,
FINSPECTDATE,
FINSPECTID,
FSUPPLYID,
FMFGDATE,
FKID,
UID,
C_YMD,
C_USER,
FDELETED,
FSTATUS,
FSTOCKSTATUSID,
FUSEFULDATE
)
VALUES
(
'{interId}',
'{Guid.NewGuid()}',
{entryId++},
'{detailId}',
{1},
{info.FSTOCKSTATUS},
'{info.FBARCODE}',
'{info.FMATERIALID}',
'{info.FLOT}',
'{info.FAUXPROPID}',
{(info.FKFDATE == null ? "null" : "'" + info.FKFDATE.Value.ToString() + "'")},
{info.FBARTYPE},
{info.FBARCODESTATUS},
'{info.FUNITID}',
{info.FQTY},
'{info.FBASEUNITID}',
{info.FBASEQTY},
{(info.FINSPECTDATE == null ? "null" : "'" + info.FINSPECTDATE.Value.ToString() + "'")},
'{info.FINSPECTID}',
'{info.FSUPPLYID}',
{(info.FKFDATE == null ? "null" : "'" + info.FKFDATE.Value.ToString() + "'")},
{info.FKID},
'{Guid.NewGuid()}',
'{date}',
'{LoginInfo.UserID}',
{0},
{40},
'{info.FSTOCKSTATUSID}',
'{info.FUSEFULDATE}'
)";
sqlStrList.Add(insertChangeBeforeTableSqlStr);
var updateBarcodeSqlStr = $"UPDATE T_BD_BARCODERS SET FDELETED=1,FBARCODESTATUS=10 WHERE FBARCODE='{info.FBARCODE}'";
sqlStrList.Add(updateBarcodeSqlStr);
}
#endregion
#region 向条码变更后表、条码主档表插入数据
var commonInfo = mergeBarcodeInfoList.FirstOrDefault();
var newBarcode = await _barcodeRepository.CreateBarcode(JObject.FromObject(commonInfo, JsonSerializer.CreateDefault()).ToString(Formatting.None), "STK_BARCODEMERGE");
var insertChangeAfterTableSqlStr =
$@"INSERT INTO T_BD_BARCODERSCHANGEAFTER
(
FINTERID,
FDETAILID,
FENTRYID,
FRELATIONID,
FCHANGESTATUS,
FSTOCKSTATUS,
FBARCODE,
FMATERIALID,
FLOT,
FAUXPROPID,
FKFDATE,
FBARTYPE,
FBARCODESTATUS,
FUNITID,
FQTY,
FBASEUNITID,
FBASEUNITQTY,
FINSPECTDATE,
FINSPECTID,
FSUPPLYID,
FMFGDATE,
FKID,
UID,
C_YMD,
C_USER,
FDELETED,
FSTATUS,
FSTOCKSTATUSID,
FUSEFULDATE
)
VALUES
(
'{interId}',
'{detailId}',
{1},
'{detailId}',
{1},
{commonInfo.FSTOCKSTATUS},
'{newBarcode}',
'{commonInfo.FMATERIALID}',
'{commonInfo.FLOT}',
'{commonInfo.FAUXPROPID}',
{(commonInfo.FKFDATE == null ? "null" : "'" + commonInfo.FKFDATE.Value.ToString() + "'")},
{commonInfo.FBARTYPE},
{commonInfo.FBARCODESTATUS},
'{commonInfo.FUNITID}',
{mergeBarcodeInfoList.Sum(o => o.FQTY)},
'{commonInfo.FBASEUNITID}',
{mergeBarcodeInfoList.Sum(o => o.FBASEQTY)},
{(commonInfo.FINSPECTDATE == null ? "null" : "'" + commonInfo.FINSPECTDATE.Value.ToString() + "'")},
'{commonInfo.FINSPECTID}',
'{commonInfo.FSUPPLYID}',
{(commonInfo.FKFDATE == null ? "null" : "'" + commonInfo.FKFDATE.Value.ToString() + "'")},
{commonInfo.FKID},
'{Guid.NewGuid()}',
'{date}',
'{LoginInfo.UserID}',
{0},
{40},
'{commonInfo.FSTOCKSTATUSID}',
'{commonInfo.FUSEFULDATE}'
)";
sqlStrList.Add(insertChangeAfterTableSqlStr);
var insertBarcodersTableSqlStr =
$@"INSERT INTO T_BD_BARCODERS
(
[FTOTALQTY]
,[FMFGDATE]
,[FOBARCODE]
,[FMATERIALID]
,[FBARCODESTATUS]
,[FBARCODE]
,[FISBOX]
,[FISMIX]
,[FLOTID]
,[FLOT]
,[FSTOCKSTATUS]
,[FINSPECTDATE]
,[FINSPECTID]
,[FSUPPLYID]
,[FAUXPROPID]
,[FDATE]
,[FKID]
,[FQTY]
,[FSECUNITQTY]
,[FSECUNITID]
,[FUNITID]
,[FSTOCKLOCID]
,[FSTOCKID]
,[FCURRID]
,[FINBOX]
,[FKFDATE]
,[FINTERID]
,[FSTATUS]
,[FDELETED]
,[FCOMPANYID]
,[FBARTYPE]
,[FBASEQTY]
,[FBASEUNITID]
,[UID]
,[C_YMD]
,[C_USER]
,[FKEEPERTYPEID]
,[FKEEPERID]
,[FOWNERTYPEID]
,[FOWNERID]
,[FSTOCKSTATUSID]
,[FUSEFULDATE]
)
VALUES
(
{mergeBarcodeInfoList.Sum(o => o.FTOTALQTY)},
{(commonInfo.FKFDATE == null ? "null" : "'" + commonInfo.FKFDATE.Value.ToString() + "'")},
'',
'{commonInfo.FMATERIALID}',
{commonInfo.FBARCODESTATUS},
'{newBarcode}',
{commonInfo.FISBOX.ToInt()},
{commonInfo.FISMIX.ToInt()},
'{commonInfo.FLOTID}',
'{commonInfo.FLOT}',
{commonInfo.FSTOCKSTATUS},
{(commonInfo.FINSPECTDATE == null ? "null" : "'" + commonInfo.FINSPECTDATE.Value.ToString() + "'")},
'{commonInfo.FINSPECTID}',
'{commonInfo.FSUPPLYID}',
'{commonInfo.FAUXPROPID}',
'{DateTime.Now}',
{commonInfo.FKID},
{mergeBarcodeInfoList.Sum(o => o.FQTY)},
{mergeBarcodeInfoList.Sum(o => o.FSECUNITQTY)},
'{commonInfo.FSECUNITID}',
'{commonInfo.FUNITID}',
'{commonInfo.FSTOCKLOCID}',
'{commonInfo.FSTOCKID}',
'{commonInfo.FCURRID}',
{commonInfo.FINBOX.ToInt()},
{(commonInfo.FKFDATE == null ? "null" : "'" + commonInfo.FKFDATE.Value.ToString() + "'")},
'{Guid.NewGuid()}',
{commonInfo.FSTATUS},
{commonInfo.FDELETED.ToInt()},
'{commonInfo.FCOMPANYID}',
{commonInfo.FBARTYPE},
{mergeBarcodeInfoList.Sum(o => o.FBASEQTY)},
'{commonInfo.FBASEUNITID}',
'{Guid.NewGuid()}',
'{DateTime.Now}',
'{LoginInfo.UserID}'
,'{commonInfo.FKEEPERTYPEID}'
,'{commonInfo.FKEEPERID}'
,'{commonInfo.FOWNERTYPEID}'
,'{commonInfo.FOWNERID}'
,'{commonInfo.FSTOCKSTATUSID}'
,'{commonInfo.FUSEFULDATE}'
)";
sqlStrList.Add(insertBarcodersTableSqlStr);
#endregion
#endregion
#region 执行sql
await _barcodeRepository.ExecuteSqlNoneQueryAsync(sqlStrList);
#endregion
#region 返回值
result.Status = 1;
result.Message = $"条码【{newBarcode}】合并成功!";
result.Data.Add("data", newBarcode);
return result;
#endregion
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 条码变更
/// </summary>
/// <param name="inputDto"></param>
/// <returns></returns>
public async Task<RetMessage> UpBarcodeInfo(UpBarCodeInfoDto inputDto)
{
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
#region 校验参数
if (inputDto == null)
{
result.Message = "参数为空!";
return result;
}
if (inputDto.barcodeList == null || !inputDto.barcodeList.Any())
{
result.Message = "提交的条码信息为空!";
return result;
}
#endregion
var mergeInfoList = inputDto.barcodeList;
List<string> sqlStrList = new List<string>();
foreach(var barcode in mergeInfoList)
{
// 提交前进行判断,仓库仓位,是不是属于此组织的仓库仓位,如果组织有变,物料内码也改变成些组织对应的内码
// 2024-06-24 条码状态变更新增库存状态变更
sqlStrList.Add($@"
update T1 set
T1.FSTOCKID='{barcode.FSTOCKID}',T1.FSTOCKLOCID='{barcode.FSTOCKLOCID}',
T1.FSTOCKSTATUS='{barcode.FSTOCKSTATUS}',T1.FCOMPANYID='{barcode.FCOMPANYID}',T1.FKEEPERID='{barcode.FKEEPERID}',
T1.FKEEPERTYPEID='{barcode.FKEEPERTYPEID}',T1.FOWNERID='{barcode.FOWNERID}',T1.FOWNERTYPEID='{barcode.FOWNERTYPEID}',
T1.FSTOCKSTATUSID = '{barcode.FSTOCKSTATUSID}',
T1.FMATERIALID = isnull(T3.FINTERID,T1.FMATERIALID)
from T_BD_BARCODERS T1
left join T_BD_MATERIAL T2 on T1.FMATERIALID=T2.FINTERID
left join T_BD_MATERIAL T3 on T2.FNUMBER=T3.FNUMBER and T3.FCOMPANYID= '{barcode.FCOMPANYID}'
where T1.FBARCODE='{barcode.FBARCODE}'
");
}
#region 执行sql
await _barcodeRepository.ExecuteSqlNoneQueryAsync(sqlStrList);
#endregion
#region 返回值
result.Status = 1;
result.Message = $"条码变更成功!";
result.Data.Add("data", "");
return result;
#endregion
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 条码装箱
/// </summary>
/// <param name="inputDto"></param>
/// <returns></returns>
public async Task<RetMessage> InBox(InBoxInputDto inputDto)
{
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
try
{
#region 校验参数
if (inputDto == null)
{
result.Message = "参数为空!";
return result;
}
if (inputDto.IsMix == null)
{
result.Message = "混装定义为空!";
return result;
}
//if (inputDto.BoxCodeType == null)
//{
// result.Message = "条码类型为空!";
// return result;
//}
if (inputDto.InBoxInfo == null || inputDto.InBoxInfo.Count == 0)
{
result.Message = "装箱条码信息为空!";
return result;
}
#endregion
#region 初始化
var inBoxInfoList = inputDto.InBoxInfo.GroupBy(o => new
{
o.Barcode,
o.BarStatus,
o.IsBox,
o.UnitId,
o.BaseUnitId
}).Select(p => new InBoxInputBarcodeInfo
{
Barcode = p.Key.Barcode,
BarStatus = p.Key.BarStatus,
IsBox = p.Key.IsBox,
UnitId = p.Key.UnitId,
BaseUnitId = p.Key.BaseUnitId,
Qty = inputDto.IsAdd.Value ? p.Sum(q => q.Qty * q.CartonNumber) : p.Sum(q => q.Qty),
BaseQty = inputDto.IsAdd.Value ? p.Sum(q => q.BaseQty * q.CartonNumber) : p.Sum(q => q.BaseQty)
}).ToList();
#endregion
#region 校验条码状态
var inBoxBarcodeInfoSqlStr =
$@"SELECT
FBARCODE,
FMATERIALID,
FISBOX,
FINBOX,
FBARTYPE,
FBARCODESTATUS,
FDELETED,
FKEEPERTYPEID,
FKEEPERID,
FOWNERTYPEID,
FOWNERID
FROM T_BD_BARCODERS
WHERE FBARCODE IN ({string.Join(',', inBoxInfoList.Select(o => "'" + o.Barcode + "'").ToList())})";
var inBoxBarcodeInfoList = await _barcodeRepository.GetInBoxBarcodeInfoAsync(inBoxBarcodeInfoSqlStr);
if (inBoxBarcodeInfoList == null || inBoxBarcodeInfoList.Count == 0)
{
result.Message = "装箱条码信息未找到";
return result;
}
foreach (var info in inBoxInfoList)
{
if (inBoxBarcodeInfoList.All(o => o.FBARCODE != info.Barcode))
{
result.Message = $"条码【{info.Barcode}】信息未找到!";
return result;
}
var barcodeInfo = inBoxBarcodeInfoList.FirstOrDefault(o => o.FBARCODE == info.Barcode);
if (barcodeInfo.FDELETED)
{
result.Message = $"条码【{info.Barcode}】状态已改变:条码已禁用!";
return result;
}
if (barcodeInfo.FKEEPERTYPEID.ToStringEx().IsNullOrEmpty())
{
result.Message = $"条码【{info.Barcode}】保管者类型为空:请重新扫描!";
return result;
}
if (barcodeInfo.FKEEPERID.ToStringEx().IsNullOrEmpty())
{
result.Message = $"条码【{info.Barcode}】保管者为空:请重新扫描!";
return result;
}
if (barcodeInfo.FOWNERTYPEID.ToStringEx().IsNullOrEmpty())
{
result.Message = $"条码【{info.Barcode}】货主类型为空:请重新扫描!";
return result;
}
if (barcodeInfo.FOWNERID.ToStringEx().IsNullOrEmpty())
{
result.Message = $"条码【{info.Barcode}】货主为空:请重新扫描!";
return result;
}
if (barcodeInfo.FBARTYPE != 3)
{
if (info.BarStatus != barcodeInfo.FBARCODESTATUS)
{
result.Message = $"条码【{info.Barcode}】状态已改变,请重新扫描!";
return result;
}
if (info.IsBox != barcodeInfo.FISBOX)
{
result.Message = $"条码【{info.Barcode}】状态已改变,请重新扫描!";
return result;
}
if (barcodeInfo.FINBOX)
{
result.Message = $"条码【{info.Barcode}】已装箱,请重新扫描!";
return result;
}
}
}
#endregion
#region 保存装箱信息
var updateBoxRootInfoSqlStr = string.Empty;//更新最底阶条码信息SQL
var updateBarcodeSqlStr = string.Empty;//更新最底阶条码信息SQL
List<string> sqlStrList = new List<string>();
#region 追加装箱
if (inputDto.IsAdd.Value)
{
#region 获取装箱清单
var boxBarcodeEntryListSqlStr =
$@"SELECT *
FROM T_BD_BARCODERSENTRY
WHERE FBOXCODE='{inputDto.BoxCode}'
ORDER BY FENTRYID DESC";
var boxBarcodeEntryList = await _barcodeRepository.GetBoxedBarcodeAsync(boxBarcodeEntryListSqlStr);
if (boxBarcodeEntryList == null || boxBarcodeEntryList.Count == 0)
{
result.Message = "获取装箱清单失败!";
return result;
}
#endregion
var boxRootInfo = await GetBoxRootInfo(inputDto.BoxCode);//最底阶条码信息
var boxBillInterId = boxBarcodeEntryList[0].FINTERID;//装箱单据内码
var entryId = boxBarcodeEntryList[0].FENTRYID;//装箱清单行号
#region 查询箱码信息
var boxCodeInfoList = await _barcodeRepository.GetBarcodeCheckInfoAsync(inputDto.BoxCode);
#endregion
#region 箱码信息存在
if (boxCodeInfoList != null && boxCodeInfoList.Count != 0)
{
#region 更新箱码数量
var updateBoxCodeQtySqlStr =
$@"UPDATE T_BD_BARCODERS
SET
FQTY=FQTY+{inBoxInfoList.Sum(o => o.Qty)},
FBASEQTY=FBASEQTY+{inBoxInfoList.Sum(o => o.BaseQty)},
FTOTALQTY=FTOTALQTY+{inBoxInfoList.Sum(o => o.Qty)}
WHERE FBARCODE='{inputDto.BoxCode}'";
sqlStrList.Add(updateBoxCodeQtySqlStr);
#endregion
#region 遍历提交的条码,更新箱码明细
foreach (var info in inBoxInfoList)
{
#region 箱内存在该条码
if (boxBarcodeEntryList.Any(o => o.FBARCODE == info.Barcode))
{
//更新最底阶条码信息
if (info.IsBox.Value)
{
var rootInfo = await GetBoxRootInfo(info.Barcode);
rootInfo.FirstOrDefault(o => o.FBARCODE == info.Barcode).FQTY += info.Qty;
updateBoxRootInfoSqlStr = $@"UPDATE T_BD_BARCODERS4
SET FBOXINFO='{XmlHelper.XmlSerialize(rootInfo, Encoding.UTF8, true)}'
WHERE FBARCODE='{info.Barcode}'";
sqlStrList.Add(updateBoxRootInfoSqlStr);
}
else
{
boxRootInfo.FirstOrDefault(o => o.FBARCODE == info.Barcode).FQTY += info.Qty;
}
}
#endregion
#region 箱内不存在该条码
else
{
//插入装箱清单
var insertBoxBarcodeEntrySqlStr =
$@"INSERT INTO T_BD_BARCODERSENTRY
(
FINTERID,
FBOXCODE,
FBARCODE,
FDETAILID,
FENTRYID,
UID,
C_YMD,
C_USER,
FDELETED,
FSTATUS
)
VALUES
(
'{boxBillInterId}',
'{inputDto.BoxCode}',
'{info.Barcode}',
'{Guid.NewGuid().ToString()}',
{++entryId},
'{Guid.NewGuid().ToString()}',
'{DateTime.Today}',
'{LoginInfo.UserID}',
{0},
{40}
)";
sqlStrList.Add(insertBoxBarcodeEntrySqlStr);
//更新最底阶条码信息
if (info.IsBox.Value)
{
var rootInfo = await GetBoxRootInfo(info.Barcode);
rootInfo.Add(new DATA
{
FBARCODE = info.Barcode,
FQTY = info.Qty
});
updateBoxRootInfoSqlStr =
$@"UPDATE T_BD_BARCODERS4
SET FBOXINFO='{XmlHelper.XmlSerialize(rootInfo, Encoding.UTF8, true)}'
WHERE FBARCODE='{info.Barcode}'";
sqlStrList.Add(updateBoxRootInfoSqlStr);
}
else
{
boxRootInfo.Add(new DATA
{
FBARCODE = info.Barcode,
FQTY = info.Qty
});
}
}
#endregion
}
#endregion
#region 更新最底阶条码信息和条码状态
updateBoxRootInfoSqlStr =
$@"UPDATE T_BD_BARCODERS4
SET FBOXINFO='{XmlHelper.XmlSerialize(boxRootInfo, Encoding.UTF8, true)}'
WHERE FBARCODE='{inputDto.BoxCode}'";
sqlStrList.Add(updateBoxRootInfoSqlStr);
updateBarcodeSqlStr =
$@"UPDATE T_BD_BARCODERS
SET FINBOX=1
WHERE FBARCODE IN ({string.Join(",", inBoxInfoList.Select(o => "'" + o.Barcode + "'").ToList())})";
sqlStrList.Add(updateBarcodeSqlStr);
#endregion
}
#endregion
#region 箱码信息不存在
else
{
#region 新建箱码
var barcodeInfoSqlStr = $@"SELECT * FROM T_BD_BARCODERS WHERE FBARCODE='{inBoxInfoList.FirstOrDefault().Barcode}'";
var barcodeInfo = (await _barcodeRepository.GetSpMeBarcodeInfoAsync(barcodeInfoSqlStr)).FirstOrDefault();
var insertBarcodersTableSqlStr =
$@"INSERT INTO T_BD_BARCODERS
(
[FTOTALQTY]
,[FMFGDATE]
,[FOBARCODE]
,[FMATERIALID]
,[FBARCODESTATUS]
,[FBARCODE]
,[FISBOX]
,[FBOXCODETYPE]
,[FISMIX]
,[FLOTID]
,[FLOT]
,[FSTOCKSTATUS]
,[FINSPECTDATE]
,[FINSPECTID]
,[FSUPPLYID]
,[FAUXPROPID]
,[FDATE]
,[FKID]
,[FQTY]
,[FUNITID]
,[FSTOCKLOCID]
,[FSTOCKID]
,[FCURRID]
,[FINBOX]
,[FKFDATE]
,[FINTERID]
,[FSTATUS]
,[FDELETED]
,[FCOMPANYID]
,[FBARTYPE]
,[FBASEQTY]
,[FBASEUNITID]
,[UID]
,[C_YMD]
,[C_USER]
,[FKEEPERTYPEID]
,[FKEEPERID]
,[FOWNERTYPEID]
,[FOWNERID]
,[FSTOCKSTATUSID]
,[FUSEFULDATE]
)
VALUES
(
{inBoxInfoList.Sum(o => o.Qty)},
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
'',
'{barcodeInfo.FMATERIALID}',
{barcodeInfo.FBARCODESTATUS},
'{inputDto.BoxCode}',
{0},
{inputDto.BoxCodeType.ToInt()},
{inputDto.IsMix.Value.ToInt()},
'{barcodeInfo.FLOTID}',
'{barcodeInfo.FLOT}',
{barcodeInfo.FSTOCKSTATUS},
{(barcodeInfo.FINSPECTDATE == null ? "null" : "'" + barcodeInfo.FINSPECTDATE.Value.ToString() + "'")},
'{barcodeInfo.FINSPECTID}',
'{barcodeInfo.FSUPPLYID}',
'{barcodeInfo.FAUXPROPID}',
'{DateTime.Today}',
{barcodeInfo.FKID},
{inBoxInfoList.Sum(o => o.Qty)},
'{barcodeInfo.FUNITID}',
'{barcodeInfo.FSTOCKLOCID}',
'{barcodeInfo.FSTOCKID}',
'{barcodeInfo.FCURRID}',
{1},
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
'{Guid.NewGuid().ToString()}',
{barcodeInfo.FSTATUS},
{barcodeInfo.FDELETED.ToInt()},
'{barcodeInfo.FCOMPANYID}',
{barcodeInfo.FBARTYPE},
{inBoxInfoList.Sum(o => o.BaseQty)},
'{barcodeInfo.FBASEUNITID}',
'{Guid.NewGuid().ToString()}',
'{DateTime.Now}',
'{LoginInfo.UserID}',
'{barcodeInfo.FKEEPERTYPEID}',
'{barcodeInfo.FKEEPERID}',
'{barcodeInfo.FOWNERTYPEID}',
'{barcodeInfo.FOWNERID}',
'{barcodeInfo.FSTOCKSTATUSID}',
'{barcodeInfo.FUSEFULDATE}'
)";
sqlStrList.Add(insertBarcodersTableSqlStr);
#endregion
#region 遍历提交的条码,更新箱码明细
entryId = 1;
var interId = Guid.NewGuid().ToString();
foreach (var info in inBoxInfoList)
{
#region 箱内存在该条码
if (boxBarcodeEntryList.Any(o => o.FBARCODE == info.Barcode))
{
//更新最底阶条码信息
if (info.IsBox.Value)
{
var rootInfo = await GetBoxRootInfo(info.Barcode);
rootInfo.FirstOrDefault(o => o.FBARCODE == info.Barcode).FQTY += info.Qty;
updateBoxRootInfoSqlStr =
$@"UPDATE T_BD_BARCODERS4
SET FBOXINFO='{XmlHelper.XmlSerialize(rootInfo, Encoding.UTF8, true)}'
WHERE FBARCODE='{info.Barcode}'";
sqlStrList.Add(updateBoxRootInfoSqlStr);
}
else
{
boxRootInfo.FirstOrDefault(o => o.FBARCODE == info.Barcode).FQTY += info.Qty;
}
}
#endregion
#region 箱内不存在该条码
else
{
//插入装箱清单
var insertBoxBarcodeEntrySqlStr =
$@"INSERT INTO T_BD_BARCODERSENTRY
(
FINTERID,
FBOXCODE,
FBARCODE,
FDETAILID,
FENTRYID,
FUID,
C_YMD,
C_USER,
FDELETED,
FSTATUS
)
VALUES
(
'{interId}',
'{inputDto.BoxCode}',
'{info.Barcode}',
'{Guid.NewGuid().ToString()}',
{entryId++},
'{Guid.NewGuid().ToString()}',
'{DateTime.Today}',
'{LoginInfo.UserID}',
{0},
{40}
)";
sqlStrList.Add(insertBoxBarcodeEntrySqlStr);
//更新最底阶条码信息
if (info.IsBox.Value)
{
var rootInfo = await GetBoxRootInfo(info.Barcode);
rootInfo.Add(new DATA
{
FBARCODE = info.Barcode,
FQTY = info.Qty
});
updateBoxRootInfoSqlStr =
$@"UPDATE T_BD_BARCODERS4
SET FBOXINFO='{XmlHelper.XmlSerialize(rootInfo, Encoding.UTF8, true)}'
WHERE FBARCODE='{info.Barcode}'";
sqlStrList.Add(updateBoxRootInfoSqlStr);
}
else
{
boxRootInfo.Add(new DATA
{
FBARCODE = info.Barcode,
FQTY = info.Qty
});
}
}
#endregion
}
#endregion
#region 更新最底阶条码信息和条码状态
updateBoxRootInfoSqlStr =
$@"UPDATE T_BD_BARCODERS4
SET FBOXINFO='{XmlHelper.XmlSerialize(boxRootInfo, Encoding.UTF8, true)}'
WHERE FBARCODE='{inputDto.BoxCode}'";
sqlStrList.Add(updateBoxRootInfoSqlStr);
updateBarcodeSqlStr =
$@"UPDATE T_BD_BARCODERS
SET FINBOX=1
WHERE FBARCODE IN ({string.Join(",", inBoxInfoList.Select(o => "'" + o.Barcode + "'").ToList())})";
sqlStrList.Add(updateBarcodeSqlStr);
#endregion
}
#endregion
#region 执行sql
await _barcodeRepository.ExecuteSqlNoneQueryAsync(sqlStrList);
#endregion
result.Status = 1;
result.Message = $"装箱成功,箱码【{inputDto.BoxCode}】!";
result.Data.Add("data", inputDto.BoxCode);
}
#endregion
#region 装箱
else
{
#region 新建箱码
var barcodeInfoSqlStr = $@"SELECT * FROM T_BD_BARCODERS WHERE FBARCODE='{inBoxInfoList.FirstOrDefault().Barcode}'";
var barcodeInfo = (await _barcodeRepository.GetSpMeBarcodeInfoAsync(barcodeInfoSqlStr)).FirstOrDefault();
var barcode = await _barcodeRepository.CreateBarcode(JObject.FromObject(barcodeInfo).ToString(Formatting.None), "STK_INBOX");
string boxCodeInterid = Guid.NewGuid().ToStringEx();//箱码内码
var insertBarcodersTableSqlStr =
$@"INSERT INTO T_BD_BARCODERS
(
[FTOTALQTY]
,[FMFGDATE]
,[FOBARCODE]
,[FMATERIALID]
,[FBARCODESTATUS]
,[FBARCODE]
,[FISBOX]
,[FBOXCODETYPE]
,[FISMIX]
,[FLOTID]
,[FLOT]
,[FSTOCKSTATUS]
,[FINSPECTDATE]
,[FINSPECTID]
,[FSUPPLYID]
,[FAUXPROPID]
,[FDATE]
,[FKID]
,[FQTY]
,[FUNITID]
,[FSTOCKLOCID]
,[FSTOCKID]
,[FCURRID]
,[FINBOX]
,[FKFDATE]
,[FINTERID]
,[FSTATUS]
,[FDELETED]
,[FCOMPANYID]
,[FBARTYPE]
,[FBASEQTY]
,[FBASEUNITID]
,[UID]
,[C_YMD]
,[C_USER]
,[FKEEPERTYPEID]
,[FKEEPERID]
,[FOWNERTYPEID]
,[FOWNERID]
,[FSTOCKSTATUSID]
,[FUSEFULDATE]
)
VALUES
(
{inBoxInfoList.Sum(o => o.Qty)},
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
'',
'{barcodeInfo.FMATERIALID}',
{barcodeInfo.FBARCODESTATUS},
'{barcode}',
{1},
{inputDto.BoxCodeType.ToInt()},
{inputDto.IsMix.Value.ToInt()},
'{barcodeInfo.FLOTID}',
'{barcodeInfo.FLOT}',
{barcodeInfo.FSTOCKSTATUS},
{(barcodeInfo.FINSPECTDATE == null ? "null" : "'" + barcodeInfo.FINSPECTDATE.Value.ToString() + "'")},
'{barcodeInfo.FINSPECTID}',
'{barcodeInfo.FSUPPLYID}',
'{barcodeInfo.FAUXPROPID}',
'{DateTime.Today}',
{barcodeInfo.FKID},
{inBoxInfoList.Sum(o => o.Qty)},
'{barcodeInfo.FUNITID}',
'{barcodeInfo.FSTOCKLOCID}',
'{barcodeInfo.FSTOCKID}',
'{barcodeInfo.FCURRID}',
{0},
{(barcodeInfo.FKFDATE == null ? "null" : "'" + barcodeInfo.FKFDATE.Value.ToString() + "'")},
'{boxCodeInterid}',
{40},
{barcodeInfo.FDELETED.ToInt()},
'{barcodeInfo.FCOMPANYID}',
{barcodeInfo.FBARTYPE},
{inBoxInfoList.Sum(o => o.BaseQty)},
'{barcodeInfo.FBASEUNITID}',
'{Guid.NewGuid()}',
'{DateTime.Now}',
'{LoginInfo.UserID}',
'{barcodeInfo.FKEEPERTYPEID}',
'{barcodeInfo.FKEEPERID}',
'{barcodeInfo.FOWNERTYPEID}',
'{barcodeInfo.FOWNERID}',
'{barcodeInfo.FSTOCKSTATUSID}',
{(barcodeInfo.FUSEFULDATE.IsNullOrEmpty() ? "null" : "'" + barcodeInfo.FUSEFULDATE.Value.ToString() + "'")}
)";
sqlStrList.Add(insertBarcodersTableSqlStr);
#region 生成箱码的源单信息
//条码主档-原材料源单表、成品源单表、委外源单表
List<string> sqlList = new List<string>();
//原材料源单表
sqlList.Add("SELECT * FROM T_BD_BARCODERS1 WHERE FBARCODE IN (" + string.Join(",", inBoxInfoList.Select(o => "'" + o.Barcode + "'").ToList()) + ")");
//成品源单表
sqlList.Add("SELECT * FROM T_BD_BARCODERS2 WHERE FBARCODE IN (" + string.Join(",", inBoxInfoList.Select(o => "'" + o.Barcode + "'").ToList()) + ")");
//委外源单表
sqlList.Add("SELECT * FROM T_BD_BARCODERS3 WHERE FBARCODE IN (" + string.Join(",", inBoxInfoList.Select(o => "'" + o.Barcode + "'").ToList()) + ")");
DataSet dtBarcodes = await _barcodeRepository.GetDataSet(sqlList);
//原材料源单表-采购订单
if (dtBarcodes.Tables[0] != null && dtBarcodes.Tables[0].Rows.Count > 0)
{
sqlStrList.Add($@"INSERT INTO T_BD_BARCODERS1
(
[FBARCODE]
,[FPOID]
,[FPOBILLNO]
,[FPOENTREYID]
,[FPODETAILID]
,[FPURID]
,[FPURBILLNO]
,[FPURENTRYID]
,[FPURDETAILID]
,[FSUPPLIERID]
,[FINSPECTID]
,[FINSPECTDATE]
,[FINTERID]
,[FSTATUS]
,[FDELETED]
,[FCOMPANYID]
,[UID]
,[C_YMD]
,[C_USER]
)
VALUES
(
'{barcode}',
'{dtBarcodes.Tables[0].Rows[0]["FPOID"].ToStringEx()}',
'{dtBarcodes.Tables[0].Rows[0]["FPOBILLNO"].ToStringEx()}',
{dtBarcodes.Tables[0].Rows[0]["FPOENTREYID"].ToStringEx()},
'{dtBarcodes.Tables[0].Rows[0]["FPODETAILID"].ToStringEx()}',
'{dtBarcodes.Tables[0].Rows[0]["FPURID"].ToStringEx()}',
'{dtBarcodes.Tables[0].Rows[0]["FPURBILLNO"].ToStringEx()}',
{dtBarcodes.Tables[0].Rows[0]["FPURENTRYID"].ToStringEx()},
'{dtBarcodes.Tables[0].Rows[0]["FPURDETAILID"].ToStringEx()}',
'{dtBarcodes.Tables[0].Rows[0]["FSUPPLIERID"].ToStringEx()}',
'{dtBarcodes.Tables[0].Rows[0]["FINSPECTID"].ToStringEx()}',
'{dtBarcodes.Tables[0].Rows[0]["FINSPECTDATE"].ToStringEx()}',
'{Guid.NewGuid().ToString()}',
{dtBarcodes.Tables[0].Rows[0]["FSTATUS"].ToStringEx()},
{dtBarcodes.Tables[0].Rows[0]["FDELETED"].ToInt()},
'{dtBarcodes.Tables[0].Rows[0]["FCOMPANYID"].ToStringEx()}',
'{Guid.NewGuid().ToString()}',
'{DateTime.Now}',
'{LoginInfo.UserID}'
)");
}
//成品源单表-生产订单
if (dtBarcodes.Tables[1] != null && dtBarcodes.Tables[1].Rows.Count > 0)
{
sqlStrList.Add($@"INSERT INTO T_BD_BARCODERS2
(
[FBARCODE]
,[FMOID]
,[FMOBILLNO]
,[FMOENTRYID]
,[FMODETAILID]
,[FCUSTID]
,[FODID]
,[FODDETAILID]
,[FODENTRYID]
,[FINTERID]
,[FSTATUS]
,[FDELETED]
,[FCOMPANYID]
,[UID]
,[C_YMD]
,[C_USER]
)
VALUES
(
'{barcode}',
'{dtBarcodes.Tables[1].Rows[0]["FMOID"].ToStringEx()}',
'{dtBarcodes.Tables[1].Rows[0]["FMOBILLNO"].ToStringEx()}',
{dtBarcodes.Tables[1].Rows[0]["FMOENTRYID"].ToStringEx()},
'{dtBarcodes.Tables[1].Rows[0]["FMODETAILID"].ToStringEx()}',
'{dtBarcodes.Tables[1].Rows[0]["FCUSTID"].ToStringEx()}',
'{dtBarcodes.Tables[1].Rows[0]["FODID"].ToStringEx()}',
'{dtBarcodes.Tables[1].Rows[0]["FODDETAILID"].ToStringEx()}',
{dtBarcodes.Tables[1].Rows[0]["FODENTRYID"].ToStringEx()},
'{Guid.NewGuid().ToString()}',
{dtBarcodes.Tables[1].Rows[0]["FSTATUS"].ToStringEx()},
{dtBarcodes.Tables[1].Rows[0]["FDELETED"].ToInt()},
'{dtBarcodes.Tables[1].Rows[0]["FCOMPANYID"].ToStringEx()}',
'{Guid.NewGuid().ToString()}',
'{DateTime.Now}',
'{LoginInfo.UserID}'
)");
}
//委外源单表-委外订单
if (dtBarcodes.Tables[2] != null && dtBarcodes.Tables[2].Rows.Count > 0)
{
sqlStrList.Add($@"INSERT INTO T_BD_BARCODERS3
(
[FBARCODE]
,[FREQID]
,[FREQBILLNO]
,[FREQENTRYID]
,[FREQDETAILID]
,[FINTERID]
,[FSTATUS]
,[FDELETED]
,[FCOMPANYID]
,[UID]
,[C_YMD]
,[C_USER]
)
VALUES
(
'{barcode}',
'{dtBarcodes.Tables[2].Rows[0]["FREQID"].ToStringEx()}',
'{dtBarcodes.Tables[2].Rows[0]["FREQBILLNO"].ToStringEx()}',
{dtBarcodes.Tables[2].Rows[0]["FREQENTRYID"].ToStringEx()},
'{dtBarcodes.Tables[2].Rows[0]["FREQDETAILID"].ToStringEx()}',
'{Guid.NewGuid().ToString()}',
{dtBarcodes.Tables[2].Rows[0]["FSTATUS"].ToStringEx()},
{dtBarcodes.Tables[2].Rows[0]["FDELETED"].ToInt()},
'{dtBarcodes.Tables[2].Rows[0]["FCOMPANYID"].ToStringEx()}',
'{Guid.NewGuid().ToString()}',
'{DateTime.Now}',
'{LoginInfo.UserID}'
)");
}
#endregion
#endregion
#region 遍历提交的条码,更新箱码明细
var entryId = 1;
var interId = Guid.NewGuid().ToString();
//新建最底阶明细
var insertBarcoders4SqlStr =
$@"INSERT INTO T_BD_BARCODERS4
(
FINTERID,
UID,
FBARCODE,
FBOXINFO,
C_YMD,
C_USER,
FCOMPANYID,
FDELETED,
FSTATUS
)
VALUES
(
'{boxCodeInterid}',
'{Guid.NewGuid().ToString()}',
'{barcode}',
'{XmlHelper.XmlSerialize(new BARCODE { new DATA { } }, Encoding.UTF8, true)}',
'{DateTime.Today}',
'{LoginInfo.UserID}',
'{barcodeInfo.FCOMPANYID}',
{0},
{40}
)";
sqlStrList.Add(insertBarcoders4SqlStr);
var boxRootInfo = new BARCODE();
foreach (var info in inBoxInfoList)
{
//插入装箱清单
var insertBoxBarcodeEntrySqlStr =
$@"INSERT INTO T_BD_BARCODERSENTRY
(
FINTERID,
UID,
FBOXCODE,
FBARCODE,
FDETAILID,
FENTRYID,
C_YMD,
C_USER,
FCOMPANYID,
FDELETED,
FSTATUS
)
VALUES
(
'{interId}',
'{Guid.NewGuid().ToString()}',
'{barcode}',
'{info.Barcode}',
'{Guid.NewGuid().ToString()}',
{entryId++},
'{DateTime.Today}',
'{LoginInfo.UserID}',
'{barcodeInfo.FCOMPANYID}',
{0},
{40}
)";
sqlStrList.Add(insertBoxBarcodeEntrySqlStr);
//更新最底阶条码信息
if (info.IsBox.Value)
{
var rootInfo = await GetBoxRootInfo(info.Barcode);
rootInfo.Add(new DATA
{
FBARCODE = info.Barcode,
FQTY = info.Qty
});
updateBoxRootInfoSqlStr =
$@"UPDATE T_BD_BARCODERS4
SET FBOXINFO='{XmlHelper.XmlSerialize(rootInfo, Encoding.UTF8, true)}'
WHERE FBARCODE='{info.Barcode}'";
sqlStrList.Add(updateBoxRootInfoSqlStr);
}
boxRootInfo.Add(new DATA
{
FBARCODE = info.Barcode,
FQTY = info.Qty
});
}
#endregion
#region 更新最底阶条码信息和条码状态
updateBoxRootInfoSqlStr =
$@"UPDATE T_BD_BARCODERS4
SET FBOXINFO='{XmlHelper.XmlSerialize(boxRootInfo, Encoding.UTF8, true)}'
WHERE FBARCODE='{barcode}'";
sqlStrList.Add(updateBoxRootInfoSqlStr);
updateBarcodeSqlStr =
$@"UPDATE T_BD_BARCODERS
SET FINBOX=1
WHERE FBARCODE IN ({string.Join(",", inBoxInfoList.Select(o => "'" + o.Barcode + "'").ToList())})";
sqlStrList.Add(updateBarcodeSqlStr);
#endregion
#region 执行sql
await _barcodeRepository.ExecuteSqlNoneQueryAsync(sqlStrList);
#endregion
result.Status = 1;
result.Message = $"装箱成功,箱码【{barcode}】!";
result.Data.Add("data", $"装箱成功!箱码【{barcode}】");
}
#endregion
#endregion
result.Status = 1;
return result;
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 外部条码导入
/// </summary>
/// <param name="inputDto"></param>
/// <returns></returns>
public async Task<RetMessage> ImportBarCode(ImportBarcodeDto inputDto)
{
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
List<string> BarCodeList = new List<string>();
try
{
#region 校验参数
if (inputDto == null)
{
result.Message = "参数为空!";
return result;
}
if (inputDto.InBoxInfo == null || inputDto.InBoxInfo.Count == 0)
{
result.Message = "装箱条码信息为空!";
return result;
}
#endregion
#region ==================== 初始化 =================================
var inBoxInfoList = inputDto.InBoxInfo.GroupBy(o => new
{
o.FBILLNO,
o.FENTRYID
}).Select(p => new
{
FBILLNO = p.Key.FBILLNO,
FENTRYID = p.Key.FENTRYID,
FQTY = p.Sum(o=>o.Qty)
}).ToList();
#endregion ============= 初始化 =====================================
//SNInput
//=============== 进行条码信息归档 ==================================
List<string> sqlList = new List<string>();
string FCURRID = Guid.NewGuid().ToString();
await using opsoftdata.APPServerContext dbContext = new opsoftdata.APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
foreach (var inBoxInfo in inBoxInfoList)
{
//先根据源单取得相关数据
string strSQL = $@"
select T1.FBILLNO,T2.FENTRYID,T2.FMATERIALID,T1.FINTERID,
T2.FLOT,T2.FUNITID,T2.FBASEUNITID,T1.FSUPPLYID,T1.FCOMPANYID,
T2.FORDERBILLNO,T2.FORDERDETAILID,T2.FAUXPROPID,
T3.FENTRYID as FORDERENTRYID ,T3.FINTERID as FORDERINTERID,
T3.FDETAILID as FPODETAILID, T2.FDETAILID as FPURDETAILID,
TA.FNUMBER as FMATERIALNO,TA.FNAME as FMATERIALNA,TA.FISBATCHMANAGE,
TB.FNUMBER as FSUNO,TB.FNAME as FSUNA,
TA.FISKFPERIOD,TA.FKFPERIOD,TA.FKFUNIT
from T_PUR_RECEIVE T1
join T_PUR_RECEIVEENTRY T2 on T1.FINTERID=T2.FINTERID
left join T_PUR_POORDERENTRY T3 on T2.FORDERDETAILID=T3.FDETAILID
left join T_BD_MATERIAL TA on T2.FMATERIALID=TA.FINTERID
left join T_BD_SUPPLIER TB on T1.FSUPPLYID=TB.FINTERID
" + "\r\n" +
$" where T1.FBILLNO ='{inBoxInfo.FBILLNO}' and T2.FENTRYID='{inBoxInfo.FENTRYID}' ";
DataTable dt = opsoftdata.EntityFrameworkCoreExtension.SqlQuery(dbContext.Database, strSQL);
if (dt.Rows.Count > 0)
{
DataRow SourceRow = dt.Rows[0];
// 第一步,写入大条码
decimal baseQty = await _barcodeRepository.GetBaseUnitQtyAsync(SourceRow["FMATERIALID"].ToStringEx(), SourceRow["FUNITID"].ToStringEx(), SourceRow["FBASEUNITID"].ToStringEx(), inBoxInfo.FQTY);
JObject NewBarCoe = new JObject();
NewBarCoe.Add("FTOTALQTY", inBoxInfo.FQTY);
NewBarCoe.Add("FMATERIALID", SourceRow["FMATERIALID"].ToStringEx());
NewBarCoe.Add("FMATERIALNO", SourceRow["FMATERIALNO"].ToStringEx()); //有可能编条码规则用到,所以加进来
NewBarCoe.Add("FMATERIALNA", SourceRow["FMATERIALNA"].ToStringEx()); //有可能编条码规则用到,所以加进来
NewBarCoe.Add("FBARCODESTATUS", "1"); //1=初始;2=收料;3=已折分;4=已合并 10.已废弃;5=已使用
NewBarCoe.Add("FBARTYPE", "2"); //1=单品条码;2=最小包装量条码;3=批次条码
NewBarCoe.Add("FLOT", "");
NewBarCoe.Add("FSTOCKSTATUS", "0");
NewBarCoe.Add("FSUPPLYID", SourceRow["FSUPPLYID"].ToStringEx());
NewBarCoe.Add("FSUNO", SourceRow["FSUNO"].ToStringEx());
NewBarCoe.Add("FSUNA", SourceRow["FSUNA"].ToStringEx());
NewBarCoe.Add("FBASEQTY", baseQty);
NewBarCoe.Add("FAUXPROPID", SourceRow["FAUXPROPID"].ToStringEx());
NewBarCoe.Add("FBASEUNITID", SourceRow["FBASEUNITID"].ToStringEx());
NewBarCoe.Add("FDATE", DateTime.Today);
NewBarCoe.Add("FKID", "1"); //1=采购订单or收料通知单;2=生产订单;3=委外订单;4=库存;5=物料;6=受托加工;7=不良处理拆卸产生;8=汇报生成;9=余料标签;
NewBarCoe.Add("FQTY", inBoxInfo.FQTY);
NewBarCoe.Add("FUNITID", SourceRow["FUNITID"].ToStringEx());
NewBarCoe.Add("FCURRID", FCURRID);
NewBarCoe.Add("FINTERID", SourceRow["FINTERID"].ToStringEx());
if (SourceRow["FISKFPERIOD"].ToBoolean())
{
DateTime dateTime = DateTime.Today;
NewBarCoe.Add("FKFDATE", dateTime.ToStringEx("YMD"));
NewBarCoe.Add("FUSEFULDATE", Constants.GetExpiryDate(SourceRow["FKFUNIT"].ToInt(),dateTime, SourceRow["FKFPERIOD"].ToInt()).ToStringEx("YMD"));
}
else
{
NewBarCoe.Add("FKFDATE", "");
NewBarCoe.Add("FUSEFULDATE", "");
}
NewBarCoe.Add("FKEEPERID", SourceRow["FCOMPANYID"].ToStringEx());
NewBarCoe.Add("FOWNERID", SourceRow["FCOMPANYID"].ToStringEx());
NewBarCoe.Add("FOWNERTYPEID", "ORG_Organizations");
NewBarCoe.Add("FKEEPERTYPEID", "ORG_Organizations");
NewBarCoe.Add("FCOMPANYID", SourceRow["FCOMPANYID"].ToStringEx());
NewBarCoe.Add("FBOMID", "");
NewBarCoe.Add("FSTOCKSTATUSID", "KCZT01_SYS");
string FBARCODE = await _barcodeRepository.CreateBarcode(NewBarCoe.ToString(), "SNInput");
NewBarCoe.Add("FBARCODE", FBARCODE);
#region ====================== 主档 ==============================================
string insertBarcoder = $@"
INSERT INTO T_BD_BARCODERS(
FTOTALQTY,FMATERIALID,FBARCODESTATUS,FBARTYPE,FLOT,
FSTOCKSTATUS,FSUPPLYID,FBASEQTY,FAUXPROPID,FBASEUNITID,
FDATE,FKID,FQTY,FUNITID,FCURRID,
FINTERID,FKEEPERID,FOWNERID,FOWNERTYPEID,
FKEEPERTYPEID,FCOMPANYID,FBOMID,FSTOCKSTATUSID,FBARCODE,
UID
";
if (NewBarCoe["FKFDATE"].ToStringEx() != "")
{
insertBarcoder += ",FKFDATE,FUSEFULDATE";
}
insertBarcoder += ")";
insertBarcoder += " Values ( ";
insertBarcoder += $" {NewBarCoe["FTOTALQTY"].ToDecimal()},'{NewBarCoe["FMATERIALID"].ToStringEx()}','{NewBarCoe["FBARCODESTATUS"].ToStringEx()}','{NewBarCoe["FBARTYPE"].ToStringEx()}','{NewBarCoe["FLOT"].ToStringEx()}', ";
insertBarcoder += $" '{NewBarCoe["FSTOCKSTATUS"].ToStringEx()}','{NewBarCoe["FSUPPLYID"].ToStringEx()}','{NewBarCoe["FBASEQTY"].ToDecimal()}','{NewBarCoe["FAUXPROPID"].ToStringEx()}','{NewBarCoe["FBASEUNITID"].ToStringEx()}', ";
insertBarcoder += $" '{NewBarCoe["FDATE"].ToDateTime().ToStringEx("YMD")}','{NewBarCoe["FKID"].ToStringEx()}','{NewBarCoe["FQTY"].ToDecimal()}','{NewBarCoe["FUNITID"].ToStringEx()}','{NewBarCoe["FCURRID"].ToStringEx()}', ";
insertBarcoder += $" '{NewBarCoe["FINTERID"].ToStringEx()}','{NewBarCoe["FKEEPERID"].ToStringEx()}','{NewBarCoe["FOWNERID"].ToStringEx()}','{NewBarCoe["FOWNERTYPEID"].ToStringEx()}', ";
insertBarcoder += $" '{NewBarCoe["FKEEPERTYPEID"].ToStringEx()}','{NewBarCoe["FCOMPANYID"].ToStringEx()}','{NewBarCoe["FBOMID"].ToStringEx()}','{NewBarCoe["FSTOCKSTATUSID"].ToStringEx()}','{NewBarCoe["FBARCODE"].ToStringEx()}', ";
insertBarcoder += $" '{Guid.NewGuid().ToString()}' ";
if (NewBarCoe["FKFDATE"].ToStringEx() != "")
{
insertBarcoder += $",'{NewBarCoe["FKFDATE"].ToStringEx()}','{NewBarCoe["FUSEFULDATE"].ToStringEx()}' ";
}
insertBarcoder += ")";
sqlList.Add(insertBarcoder);
#endregion ====================== 主档 ==============================================
#region ====================== 条码主档-原材料源单表 ==============================================
insertBarcoder = $@"
INSERT INTO T_BD_BARCODERS1(
FBARCODE,FPOID,FPOBILLNO,FPOENTREYID,FPODETAILID,
FPURID,FPURBILLNO,FPURENTRYID,FPURDETAILID,FSUPPLIERID,
UID
";
insertBarcoder += ")";
insertBarcoder += " Values ( ";
insertBarcoder += $" '{NewBarCoe["FBARCODE"].ToStringEx()}','{SourceRow["FORDERINTERID"].ToStringEx()}','{SourceRow["FORDERBILLNO"].ToStringEx()}','{SourceRow["FORDERENTRYID"].ToStringEx()}','{SourceRow["FPODETAILID"].ToStringEx()}', ";
insertBarcoder += $" '{SourceRow["FINTERID"].ToStringEx()}','{SourceRow["FBILLNO"].ToStringEx()}','{SourceRow["FENTRYID"].ToStringEx()}','{SourceRow["FPURDETAILID"].ToStringEx()}','{SourceRow["FSUPPLYID"].ToStringEx()}', ";
insertBarcoder += $" '{Guid.NewGuid().ToString()}' ";
insertBarcoder += ")";
sqlList.Add(insertBarcoder);
#endregion ====================== 条码主档-原材料源单表 ==============================================
// 再插入小条码
var QueryList = inputDto.InBoxInfo.Where(p => p.FBILLNO.Equals(inBoxInfo.FBILLNO) && p.FENTRYID == inBoxInfo.FENTRYID).ToList();
decimal sigBaseQty = await _barcodeRepository.GetBaseUnitQtyAsync(SourceRow["FMATERIALID"].ToStringEx(), SourceRow["FUNITID"].ToStringEx(), SourceRow["FBASEUNITID"].ToStringEx(), 1);
foreach (var sub in QueryList)
{
if (sub.Barcode.ToStringEx() != "")
{
sqlList.Add($" delete from T_BD_BARCODERS where FBARCODE='{sub.Barcode}' ");
sqlList.Add($" delete from T_BD_BARCODERS1 where FBARCODE='{sub.Barcode}' ");
#region ====================== 主档 ==============================================
insertBarcoder = $@"
INSERT INTO T_BD_BARCODERS(
FTOTALQTY,FMATERIALID,FBARCODESTATUS,FBARTYPE,FLOT,
FSTOCKSTATUS,FSUPPLYID,FBASEQTY,FAUXPROPID,FBASEUNITID,
FDATE,FKID,FQTY,FUNITID,FCURRID,
FINTERID,FKEEPERID,FOWNERID,FOWNERTYPEID,
FKEEPERTYPEID,FCOMPANYID,FBOMID,FSTOCKSTATUSID,FBARCODE,
UID,FISOUT
";
if (NewBarCoe["FKFDATE"].ToStringEx() != "")
{
insertBarcoder += ",FKFDATE,FUSEFULDATE";
}
insertBarcoder += ")";
insertBarcoder += " Values ( ";
insertBarcoder += $" 1,'{NewBarCoe["FMATERIALID"].ToStringEx()}','{NewBarCoe["FBARCODESTATUS"].ToStringEx()}','{NewBarCoe["FBARTYPE"].ToStringEx()}','{NewBarCoe["FLOT"].ToStringEx()}', ";
insertBarcoder += $" '{NewBarCoe["FSTOCKSTATUS"].ToStringEx()}','{NewBarCoe["FSUPPLYID"].ToStringEx()}','{sigBaseQty}','{NewBarCoe["FAUXPROPID"].ToStringEx()}','{NewBarCoe["FBASEUNITID"].ToStringEx()}', ";
insertBarcoder += $" '{NewBarCoe["FDATE"].ToDateTime().ToStringEx("YMD")}','{NewBarCoe["FKID"].ToStringEx()}','1','{NewBarCoe["FUNITID"].ToStringEx()}','{NewBarCoe["FCURRID"].ToStringEx()}', ";
insertBarcoder += $" '{NewBarCoe["FINTERID"].ToStringEx()}','{NewBarCoe["FKEEPERID"].ToStringEx()}','{NewBarCoe["FOWNERID"].ToStringEx()}','{NewBarCoe["FOWNERTYPEID"].ToStringEx()}', ";
insertBarcoder += $" '{NewBarCoe["FKEEPERTYPEID"].ToStringEx()}','{NewBarCoe["FCOMPANYID"].ToStringEx()}','{NewBarCoe["FBOMID"].ToStringEx()}','{NewBarCoe["FSTOCKSTATUSID"].ToStringEx()}','{sub.Barcode.ToStringEx()}', ";
insertBarcoder += $" '{Guid.NewGuid().ToString()}',1 ";
if (NewBarCoe["FKFDATE"].ToStringEx() != "")
{
insertBarcoder += $",'{NewBarCoe["FKFDATE"].ToStringEx()}','{NewBarCoe["FUSEFULDATE"].ToStringEx()}' ";
}
insertBarcoder += ")";
sqlList.Add(insertBarcoder);
#endregion ====================== 主档 ==============================================
#region ====================== 条码主档-原材料源单表 ==============================================
insertBarcoder = $@"
INSERT INTO T_BD_BARCODERS1(
FBARCODE,FPOID,FPOBILLNO,FPOENTREYID,FPODETAILID,
FPURID,FPURBILLNO,FPURENTRYID,FPURDETAILID,FSUPPLIERID,
UID
";
insertBarcoder += ")";
insertBarcoder += " Values ( ";
insertBarcoder += $" '{sub.Barcode.ToStringEx()}','{SourceRow["FORDERINTERID"].ToStringEx()}','{SourceRow["FORDERBILLNO"].ToStringEx()}','{SourceRow["FORDERENTRYID"].ToStringEx()}','{SourceRow["FPODETAILID"].ToStringEx()}', ";
insertBarcoder += $" '{SourceRow["FINTERID"].ToStringEx()}','{SourceRow["FBILLNO"].ToStringEx()}','{SourceRow["FENTRYID"].ToStringEx()}','{SourceRow["FPURDETAILID"].ToStringEx()}','{SourceRow["FSUPPLYID"].ToStringEx()}', ";
insertBarcoder += $" '{Guid.NewGuid().ToString()}' ";
insertBarcoder += ")";
sqlList.Add(insertBarcoder);
#endregion ====================== 条码主档-原材料源单表 ==============================================
}
}
BarCodeList.Add(FBARCODE);
}
else
{
result.Message = $"收料通知单【{inBoxInfo.FBILLNO}】行号【{inBoxInfo.FENTRYID}】在数据库中不存在!";
return result;
}
}
//=============== 进行条码信息归档 ==================================
if (sqlList.Count > 0)
{
try
{
await dbContext.Database.BeginTransactionAsync();
//执行SQL
opsoftdata.EntityFrameworkCoreExtension.SqlQuery(dbContext.Database, sqlList);
await dbContext.Database.CommitTransactionAsync();
}
catch (System.Exception ex)
{
await dbContext.Database.RollbackTransactionAsync().ConfigureAwait(false);
result.Message = "执行事务操作异常," + ex.Message;
return result;
}
}
result.Status = 1;
result.Data.Add("data", BarCodeList);
return result;
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 条码拆箱
/// </summary>
/// <param name="inputDto"></param>
/// <returns></returns>
public async Task<RetMessage> OutBox(OutBoxInputDto inputDto)
{
RetMessage result = new RetMessage
{
Status = 0,
Message = string.Empty,
Data = new Dictionary<string, object>()
};
List<string> sqlList = new List<string>();
try
{
#region 校验参数
if (inputDto.BoxCode.IsNullOrWhiteSpace())
{
result.Message = "箱码为空!";
return result;
}
if (inputDto.OutBoxInfo == null)
{
result.Message = "提交条码信息为空!";
return result;
}
var boxedBarcodeInfoSqlStr = $"SELECT * FROM T_BD_BARCODERSENTRY WHERE FBOXCODE='{inputDto.BoxCode}'";
var boxedBarcodeInfoList = await _barcodeRepository.GetBoxedBarcodeAsync(boxedBarcodeInfoSqlStr);
if (boxedBarcodeInfoList == null)
{
result.Message = "箱码装箱信息为空!";
return result;
}
#endregion
#region 更新装箱信息
if (inputDto.OutBoxInfo.Count > 0)
{
foreach (var barcode in inputDto.OutBoxInfo)
{
if (boxedBarcodeInfoList.All(o => o.FBARCODE != barcode.Barcode))
{
result.Message = $"条码【{barcode.Barcode}】在箱码【{inputDto.BoxCode}】中未找到";
return result;
}
}
}
await _barcodeRepository.SplitBox(inputDto);
#endregion
result.Status = 1;
result.Data.Add("data", $"拆箱成功,箱码【{inputDto.BoxCode}】!");
return result;
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 获取最底阶条码信息
/// </summary>
/// <param name="barcode"></param>
/// <returns></returns>
private async Task<BARCODE> GetBoxRootInfo(string barcode)
{
try
{
var boxRootInfoXmlSqlStr = $"SELECT * FROM T_BD_BARCODERS4 WHERE FBARCODE='{barcode}'";
var boxRootInfoXml = await _barcodeRepository.GetBoxRootInfoXmlStrAsync(boxRootInfoXmlSqlStr);
return XmlHelper.XmlDeserialize<BARCODE>(boxRootInfoXml, Encoding.UTF8);
}
catch (Exception e)
{
throw new O3AppException(e.Message);
}
}
/// <summary>
/// 条码底阶明细XML类
/// </summary>
[Serializable]
[XmlType("BARCODE")]
public class BARCODE : List<DATA>
{
}
/// <summary>
/// 条码底阶明细XML类明细
/// </summary>
[Serializable]
[XmlType("DATA")]
public class DATA
{
[XmlAttribute]
public string FBARCODE { get; set; }
[XmlAttribute]
public decimal FQTY { get; set; }
[XmlAttribute]
public string FUNITID { get; set; }
[XmlAttribute]
public string FBASEUNITID { get; set; }
[XmlAttribute]
public decimal FBASEQTY { get; set; }
[XmlAttribute]
public string FMATERIALID { get; set; }
[XmlAttribute]
public string FLOT { get; set; }
[XmlAttribute]
public string FLOTID { get; set; }
[XmlAttribute]
public string FSTOCKID { get; set; }
[XmlAttribute]
public string FSTOCKLOCID { get; set; }
[XmlAttribute]
public string FAUXPROPID { get; set; }
[XmlAttribute]
public DateTime FKFDATE { get; set; }
[XmlAttribute]
public int FKFPERIOD { get; set; }
}
}
}