junjie.wang
/
Estsh-Yiri
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
Estsh-Yiri/Estsh.Core.Wms/Services/SplitCarrierService.cs

583 lines
33 KiB
C#
Raw Permalink Blame History

using Dapper;
using Estsh.Core.Base;
using Estsh.Core.Model.EnumUtil;
using Estsh.Core.Models;
using Estsh.Core.Services;
using Estsh.Core.Wms.IRepositories;
using Estsh.Core.Wms.IServices;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Estsh.Core.Wms.Services
{
/// <summary>
/// 拆分台车
/// </summary>
public class SplitCarrierService : BaseService<BaseEntity>, ISplitCarrierService
{
private readonly ISplitCarrierRepository repository;
public SplitCarrierService(ISplitCarrierRepository _repository) : base(_repository)
{
repository = _repository;
}
public SetObjectDetail GetCarrierByName(string srcRackNo)
{
SetObjectDetail rfInfo = new SetObjectDetail();
//查询台车信息
List<WmsRackPackage> wmsRacks = repository.GetCarrierByName(srcRackNo);
if (wmsRacks.Count == 0)
{
//提示 [A1-2-2]:该库位不存在，请检查!
rfInfo.type = "FAIL";
rfInfo.message = "[" + srcRackNo + "]:该台车未绑定箱条码，请检查!";
return rfInfo;
}
List<SysStock> sysStocks = repository.GetSysStockBySumQty(srcRackNo);
rfInfo.type = "PASS";
rfInfo.message = "[" + srcRackNo + "]:扫描成功,请扫描产品条码";
rfInfo.wmsObjectDetail = sysStocks.ConvertAll(s => (object)s);
return rfInfo;
}
public SetObjectDetail CheckStockByCartonNo(string srcRackNo, string cartonNo, string loginId)
{
SetObjectDetail rfInfo = new SetObjectDetail();
List<SysStock> sysStocks = repository.GetSysStockByNO(cartonNo);
if (sysStocks.Count == 0)
{
//提示 [M0090105]:该条码不存在，请检查!
rfInfo.type = "FAIL";
rfInfo.message = "[" + cartonNo + "]:该条码不存在，请检查!";
return rfInfo;
}
else if (string.IsNullOrEmpty(sysStocks[0].PartNo))
{
//提示 [M0090105]:该条码对应零件号为空，无法操作!
rfInfo.type = "FAIL";
rfInfo.message = "[" + cartonNo + "]:该条码对应零件号为空，请检查!";
return rfInfo;
}
List<SysStock> stocks = repository.GetSysStockByPartNoSumQty(srcRackNo, sysStocks[0].PartNo);
if (stocks.Count == 0)
{
rfInfo.type = "FAIL";
rfInfo.message = "[" + cartonNo + "]:该条码对应零件号未维护到源台车，请检查!";
return rfInfo;
}
rfInfo.type = "PASS";
rfInfo.message = "[" + cartonNo + "]:扫描成功,请输入台车容量";
rfInfo.wmsObjectDetail = stocks.ConvertAll(s => (object)s);
return rfInfo;
}
public SetObjectDetail CheckStockByCartonNoAndQty(string srcRackNo, string cartonNo, string qty, string loginId)
{
SetObjectDetail rfInfo = new SetObjectDetail();
StringBuilder stringBuilder = new StringBuilder(1024);
List<string> sqlStrings = new List<string>();
List<DynamicParameters> parameterList = new List<DynamicParameters>();
List<SysStock> sysStocks = repository.GetSysStockByNO(cartonNo);
List<SysStock> stocks = repository.GetSysStockByPartNoSumQty(srcRackNo, sysStocks[0].PartNo);
if (stocks[0].Qty < decimal.Parse(qty))
{
rfInfo.type = "FAIL";
rfInfo.message = "拆分数量大于源台车容量，请检查!";
return rfInfo;
}
rfInfo.type = "PASS";
rfInfo.message = "台车容量处理成功，请扫描目标台车";
return rfInfo;
}
public SetObjectDetail CheckStockByCartonNoAndQtyAddRackNo(string srcRackNo, string cartonNo, string qty, string destRackNo, string loginId)
{
SetObjectDetail rfInfo = new SetObjectDetail();
if (string.IsNullOrEmpty(srcRackNo))
{
rfInfo.type = "FAIL";
rfInfo.message = "料架号为空，请重扫料架号";
return rfInfo;
}
StringBuilder stringBuilder = new StringBuilder(1024);
List<string> sqlStrings = new List<string>();
List<DynamicParameters> parameterList = new List<DynamicParameters>();
StringBuilder SqlStringBuilder = new StringBuilder(1024);
DynamicParameters parameters = new DynamicParameters();
List<SysStock> sysStocks = repository.GetSysStockByNO(cartonNo);
decimal qtyNum = decimal.Parse(qty);
List<SysStock> stocks = repository.GetSysStockByPartInfo(srcRackNo, sysStocks[0].PartNo);
for (int i = 0; i < stocks.Count; i++)
{
if (qtyNum > 0)
{
if (stocks[i].Qty <= qtyNum)
{
SqlStringBuilder = new StringBuilder(1024);
SqlStringBuilder.Append(" update sys_stock set qty=@qty,enabled='N' where ruid=@ruid ");
sqlStrings.Add(SqlStringBuilder.ToString());
parameters = new DynamicParameters();
parameters.Add("@qty", 0);
parameters.Add("@ruid", stocks[i].Ruid);
parameterList.Add(parameters);
SqlStringBuilder = new StringBuilder(1024);
SqlStringBuilder.Append(@"UPDATE wms_rack_package SET enabled='N' where rack_no=@rackNo and carton_no=@cartonNo");
sqlStrings.Add(SqlStringBuilder.ToString());
parameters = new DynamicParameters();
parameters.Add("@rackNo", srcRackNo);
parameters.Add("@cartonNo", stocks[i].CartonNo);
parameterList.Add(parameters);
qtyNum -= stocks[i].Qty;
}
else if (stocks[i].Qty > qtyNum)
{
SqlStringBuilder = new StringBuilder(1024);
SqlStringBuilder.Append(" update sys_stock set qty-=@qty where ruid=@ruid ");
sqlStrings.Add(SqlStringBuilder.ToString());
parameters = new DynamicParameters();
parameters.Add("@qty", qtyNum);
parameters.Add("@ruid", stocks[i].Ruid);
parameterList.Add(parameters);
qtyNum = 0;
}
}
}
List<SysStock> rackStock = repository.GetCarrierByStockRackNo(destRackNo);
if (rackStock.Count == 0)
{
#region 新增库存表
//在STOCK中插入料架
StringBuilder updateString3 = new StringBuilder(1024);
updateString3.Append(@" INSERT INTO [dbo].[sys_stock]
([vendor_id]
,[vendor_code]
,[carton_no]
,[carton_type]
,[part_id]
,[part_no]
,[part_spec]
,[lot_no]
,[fix_lot_no]
,[status]
,[qty]
,[snp_qty]
,[locate_id]
,[locate_name]
,[group_no]
,[erp_warehouse]
,[date_code]
,[qms_status]
,[ref_order_no]
,[unit]
,[dock]
,[warehouse_id]
,[warehouse_name]
,[zone_id]
,[zone_name]
,[printed]
,[print_time]
,[remark]
,[factory_id]
,[factory_code]
,[enabled]
,[create_userid]
,[create_time]
,[update_userid]
,[update_time]
,[guid])
VALUES(@vendor_id,@vendor_code,@carton_no,@carton_type,@part_id,@part_no,@part_spec,@lot_no,@fix_lot_no,@status,@qty,@snp_qty
,@locate_id,@locate_name,@group_no,@erp_warehouse,@date_code,@qms_status,@ref_order_no,@unit,@dock,@warehouse_id,@warehouse_name,@zone_id,@zone_name
,@printed,@print_time,@remark,@factory_id,@factory_code,@enabled,@create_userid,@create_time,@update_userid,@update_time,@guid )");
DynamicParameters updateStringparameters3 = new DynamicParameters();
updateStringparameters3.Add("@vendor_id", sysStocks[0].VendorId);
updateStringparameters3.Add("@vendor_code", sysStocks[0].VendorName);
updateStringparameters3.Add("@carton_no", destRackNo);
updateStringparameters3.Add("@carton_type", "1");
updateStringparameters3.Add("@part_id", "0");
updateStringparameters3.Add("@part_no", destRackNo);
updateStringparameters3.Add("@part_spec", "");
updateStringparameters3.Add("@lot_no", "99999999");
updateStringparameters3.Add("@fix_lot_no", "");
updateStringparameters3.Add("@status", (int)WmsEnumUtil.StockStatus.INSTOCKED);
updateStringparameters3.Add("@qty", 1);
updateStringparameters3.Add("@snp_qty", 1);
updateStringparameters3.Add("@locate_id", 0);
updateStringparameters3.Add("@locate_name", "");
updateStringparameters3.Add("@group_no", "");
updateStringparameters3.Add("@erp_warehouse", "");
updateStringparameters3.Add("@date_code", "");
updateStringparameters3.Add("@qms_status", "");
updateStringparameters3.Add("@ref_order_no", "台车");
updateStringparameters3.Add("@unit", "");
updateStringparameters3.Add("@dock", "");
updateStringparameters3.Add("@warehouse_id", 0);
updateStringparameters3.Add("@warehouse_name", "");
updateStringparameters3.Add("@zone_id", 0);
updateStringparameters3.Add("@zone_name", "");
updateStringparameters3.Add("@printed", "");
updateStringparameters3.Add("@print_time", "");
updateStringparameters3.Add("@remark", "");
updateStringparameters3.Add("@factory_id", sysStocks[0].FactoryId);
updateStringparameters3.Add("@factory_code", sysStocks[0].FactoryCode);
updateStringparameters3.Add("@enabled", "Y");
updateStringparameters3.Add("@update_userid", loginId);
updateStringparameters3.Add("@update_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters3.Add("@create_userid", loginId);
updateStringparameters3.Add("@create_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters3.Add("@guid", Guid.NewGuid());
sqlStrings.Add(updateString3.ToString());
parameterList.Add(updateStringparameters3);
#endregion
#region 新增 sys_stock_trans 事务表
StringBuilder updateString4 = new StringBuilder(1024);
updateString4.Append(@" INSERT INTO[dbo].[sys_stock_trans]
([trans_code]
,[carton_no]
,[part_id]
,[part_no]
,[part_spec]
,[src_locate_id]
,[src_locate_name]
,[dest_locate_id]
,[dest_locate_name]
,[old_qty]
,[new_qty]
,[trans_qty]
,[old_status]
,[new_status]
,[old_qms_status]
,[new_qms_status]
,[unit]
,[factory_id]
,[factory_code]
,[src_erp_warehouse]
,[dest_erp_warehouse]
,[src_warehouse_id]
,[src_warehouse_name]
,[dest_warehouse_id]
,[dest_warehouse_name]
,[src_zone_id]
,[src_zone_name]
,[dest_zone_id]
,[dest_zone_name]
,[enabled]
,[update_userid]
,[update_time]
,[create_userid]
,[create_time]
,[guid])
VALUES (@trans_code,@carton_no,@part_id,@part_no,@part_spec,@src_locate_id ,@src_locate_name ,@dest_locate_id ,@dest_locate_name ,@old_qty
,@new_qty ,@trans_qty ,@old_status ,@new_status ,@old_qms_status ,@new_qms_status ,@unit ,@factory_id ,@factory_code ,@src_erp_warehouse ,@dest_erp_warehouse ,@src_warehouse_id ,@src_warehouse_name ,@dest_warehouse_id ,@dest_warehouse_name ,@src_zone_id ,@src_zone_name ,@dest_zone_id ,@dest_zone_name ,@enabled ,@update_userid ,@update_time ,@create_userid ,@create_time ,@guid )");
DynamicParameters updateStringparameters4 = new DynamicParameters();
updateStringparameters4.Add("@trans_code", (int)WmsEnumUtil.TransType.PART_SPLIT);
updateStringparameters4.Add("@carton_no", destRackNo);
updateStringparameters4.Add("@part_id", 0);
updateStringparameters4.Add("@part_no", destRackNo);
updateStringparameters4.Add("@part_spec", "");
updateStringparameters4.Add("@src_locate_id", 0);
updateStringparameters4.Add("@src_locate_name", "");
updateStringparameters4.Add("@dest_locate_id", 0);
updateStringparameters4.Add("@dest_locate_name", "");
updateStringparameters4.Add("@old_qty", 1);
updateStringparameters4.Add("@new_qty", 1);
updateStringparameters4.Add("@trans_qty", 1);
updateStringparameters4.Add("@old_status", "");
updateStringparameters4.Add("@new_status", (int)WmsEnumUtil.StockStatus.INSTOCKED);
updateStringparameters4.Add("@old_qms_status", "");
updateStringparameters4.Add("@new_qms_status", "");
updateStringparameters4.Add("@unit", "");
updateStringparameters4.Add("@factory_id", sysStocks[0].FactoryId);
updateStringparameters4.Add("@factory_code", sysStocks[0].FactoryCode);
updateStringparameters4.Add("@src_erp_warehouse", "");
updateStringparameters4.Add("@dest_erp_warehouse", "");
updateStringparameters4.Add("@src_warehouse_id", "0");
updateStringparameters4.Add("@src_warehouse_name", "");
updateStringparameters4.Add("@dest_warehouse_id", "0");
updateStringparameters4.Add("@dest_warehouse_name", "");
updateStringparameters4.Add("@src_zone_id", "0");
updateStringparameters4.Add("@src_zone_name", "");
updateStringparameters4.Add("@dest_zone_id", "0");
updateStringparameters4.Add("@dest_zone_name", "");
updateStringparameters4.Add("@enabled", "Y");
updateStringparameters4.Add("@update_userid", loginId);
updateStringparameters4.Add("@update_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters4.Add("@create_userid", loginId);
updateStringparameters4.Add("@create_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters4.Add("@guid", Guid.NewGuid());
sqlStrings.Add(updateString4.ToString());
parameterList.Add(updateStringparameters4);
#endregion
}
string carton_no_new = repository.GetOrderNo("StockOrder", "T");
List<SysStock> sysStocksDest = repository.GetSysStockByPartInfo(destRackNo, sysStocks[0].PartNo);
if (sysStocksDest.Count > 0)
{
SqlStringBuilder = new StringBuilder(1024);
SqlStringBuilder.Append(" update sys_stock set qty+=@qty where ruid=@ruid ");
sqlStrings.Add(SqlStringBuilder.ToString());
parameters = new DynamicParameters();
parameters.Add("@qty", qty);
parameters.Add("@ruid", sysStocksDest[0].Ruid);
parameterList.Add(parameters);
}
else
{
#region 新增库存表
//在STOCK中插入料架
StringBuilder updateString3 = new StringBuilder(1024);
updateString3.Append(@" INSERT INTO [dbo].[sys_stock]
([vendor_id]
,[vendor_code]
,[carton_no]
,[carton_type]
,[part_id]
,[part_no]
,[part_spec]
,[lot_no]
,[fix_lot_no]
,[status]
,[qty]
,[snp_qty]
,[locate_id]
,[locate_name]
,[group_no]
,[erp_warehouse]
,[date_code]
,[qms_status]
,[ref_order_no]
,[unit]
,[dock]
,[warehouse_id]
,[warehouse_name]
,[zone_id]
,[zone_name]
,[printed]
,[print_time]
,[remark]
,[factory_id]
,[factory_code]
,[enabled]
,[create_userid]
,[create_time]
,[update_userid]
,[update_time]
,[guid])
VALUES(@vendor_id,@vendor_code,@carton_no,@carton_type,@part_id,@part_no,@part_spec,@lot_no,@fix_lot_no,@status,@qty,@snp_qty
,@locate_id,@locate_name,@group_no,@erp_warehouse,@date_code,@qms_status,@ref_order_no,@unit,@dock,@warehouse_id,@warehouse_name,@zone_id,@zone_name
,@printed,@print_time,@remark,@factory_id,@factory_code,@enabled,@create_userid,@create_time,@update_userid,@update_time,@guid )");
DynamicParameters updateStringparameters3 = new DynamicParameters();
updateStringparameters3.Add("@vendor_id", sysStocks[0].VendorId);
updateStringparameters3.Add("@vendor_code", sysStocks[0].VendorName);
updateStringparameters3.Add("@carton_no", carton_no_new);
updateStringparameters3.Add("@carton_type", "0");
updateStringparameters3.Add("@part_id", sysStocks[0].PartId);
updateStringparameters3.Add("@part_no", sysStocks[0].PartNo);
updateStringparameters3.Add("@part_spec", sysStocks[0].PartSpec);
updateStringparameters3.Add("@lot_no", "99999999");
updateStringparameters3.Add("@fix_lot_no", "");
updateStringparameters3.Add("@status", (int)WmsEnumUtil.StockStatus.INSTOCKED);
updateStringparameters3.Add("@qty", qty);
updateStringparameters3.Add("@snp_qty", qty);
updateStringparameters3.Add("@locate_id", 0);
updateStringparameters3.Add("@locate_name", "");
updateStringparameters3.Add("@group_no", "");
updateStringparameters3.Add("@erp_warehouse", "");
updateStringparameters3.Add("@date_code", "");
updateStringparameters3.Add("@qms_status", "");
updateStringparameters3.Add("@ref_order_no", "");
updateStringparameters3.Add("@unit", "");
updateStringparameters3.Add("@dock", "");
updateStringparameters3.Add("@warehouse_id", 0);
updateStringparameters3.Add("@warehouse_name", "");
updateStringparameters3.Add("@zone_id", 0);
updateStringparameters3.Add("@zone_name", "");
updateStringparameters3.Add("@printed", "");
updateStringparameters3.Add("@print_time", "");
updateStringparameters3.Add("@remark", "");
updateStringparameters3.Add("@factory_id", sysStocks[0].FactoryId);
updateStringparameters3.Add("@factory_code", sysStocks[0].FactoryCode);
updateStringparameters3.Add("@enabled", "Y");
updateStringparameters3.Add("@update_userid", loginId);
updateStringparameters3.Add("@update_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters3.Add("@create_userid", loginId);
updateStringparameters3.Add("@create_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters3.Add("@guid", Guid.NewGuid());
sqlStrings.Add(updateString3.ToString());
parameterList.Add(updateStringparameters3);
#endregion
#region 新增 sys_stock_trans 事务表
StringBuilder updateString4 = new StringBuilder(1024);
updateString4.Append(@" INSERT INTO[dbo].[sys_stock_trans]
([trans_code]
,[carton_no]
,[part_id]
,[part_no]
,[part_spec]
,[src_locate_id]
,[src_locate_name]
,[dest_locate_id]
,[dest_locate_name]
,[old_qty]
,[new_qty]
,[trans_qty]
,[old_status]
,[new_status]
,[old_qms_status]
,[new_qms_status]
,[unit]
,[factory_id]
,[factory_code]
,[src_erp_warehouse]
,[dest_erp_warehouse]
,[src_warehouse_id]
,[src_warehouse_name]
,[dest_warehouse_id]
,[dest_warehouse_name]
,[src_zone_id]
,[src_zone_name]
,[dest_zone_id]
,[dest_zone_name]
,[enabled]
,[update_userid]
,[update_time]
,[create_userid]
,[create_time]
,[guid])
VALUES (@trans_code,@carton_no,@part_id,@part_no,@part_spec,@src_locate_id ,@src_locate_name ,@dest_locate_id ,@dest_locate_name ,@old_qty
,@new_qty ,@trans_qty ,@old_status ,@new_status ,@old_qms_status ,@new_qms_status ,@unit ,@factory_id ,@factory_code ,@src_erp_warehouse ,@dest_erp_warehouse ,@src_warehouse_id ,@src_warehouse_name ,@dest_warehouse_id ,@dest_warehouse_name ,@src_zone_id ,@src_zone_name ,@dest_zone_id ,@dest_zone_name ,@enabled ,@update_userid ,@update_time ,@create_userid ,@create_time ,@guid )");
DynamicParameters updateStringparameters4 = new DynamicParameters();
updateStringparameters4.Add("@trans_code", (int)WmsEnumUtil.TransType.PART_SPLIT);
updateStringparameters4.Add("@carton_no", carton_no_new);
updateStringparameters4.Add("@part_id", sysStocks[0].PartId);
updateStringparameters4.Add("@part_no", sysStocks[0].PartNo);
updateStringparameters4.Add("@part_spec", sysStocks[0].PartSpec);
updateStringparameters4.Add("@src_locate_id", 0);
updateStringparameters4.Add("@src_locate_name", "");
updateStringparameters4.Add("@dest_locate_id", 0);
updateStringparameters4.Add("@dest_locate_name", "");
updateStringparameters4.Add("@old_qty", 1);
updateStringparameters4.Add("@new_qty", 1);
updateStringparameters4.Add("@trans_qty", 1);
updateStringparameters4.Add("@old_status", "");
updateStringparameters4.Add("@new_status", (int)WmsEnumUtil.StockStatus.INSTOCKED);
updateStringparameters4.Add("@old_qms_status", "");
updateStringparameters4.Add("@new_qms_status", "");
updateStringparameters4.Add("@unit", "");
updateStringparameters4.Add("@factory_id", sysStocks[0].FactoryId);
updateStringparameters4.Add("@factory_code", sysStocks[0].FactoryCode);
updateStringparameters4.Add("@src_erp_warehouse", "");
updateStringparameters4.Add("@dest_erp_warehouse", "");
updateStringparameters4.Add("@src_warehouse_id", "0");
updateStringparameters4.Add("@src_warehouse_name", "");
updateStringparameters4.Add("@dest_warehouse_id", "0");
updateStringparameters4.Add("@dest_warehouse_name", "");
updateStringparameters4.Add("@src_zone_id", "0");
updateStringparameters4.Add("@src_zone_name", "");
updateStringparameters4.Add("@dest_zone_id", "0");
updateStringparameters4.Add("@dest_zone_name", "");
updateStringparameters4.Add("@enabled", "Y");
updateStringparameters4.Add("@update_userid", loginId);
updateStringparameters4.Add("@update_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters4.Add("@create_userid", loginId);
updateStringparameters4.Add("@create_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters4.Add("@guid", Guid.NewGuid());
sqlStrings.Add(updateString4.ToString());
parameterList.Add(updateStringparameters4);
#endregion
StringBuilder updateString2 = new StringBuilder(1024);
updateString2.Append(@"INSERT INTO [dbo].[wms_rack_package]
([rack_no]
,[carton_no]
,[factory_id]
,[factory_code]
,[enabled]
,[create_userid]
,[create_time]
,[update_userid]
,[update_time]
,[guid],rack_num)
VALUES (@rack_no,@carton_no,@factory_id,@factory_code,@enabled,@create_userid,@create_time,@update_userid,@update_time,@guid,@rack_num
)");
DynamicParameters updateStringparameters2 = new DynamicParameters();
updateStringparameters2.Add("@rack_no", destRackNo);//新台车号
updateStringparameters2.Add("@carton_no", carton_no_new);
updateStringparameters2.Add("@factory_id", sysStocks[0].FactoryId);
updateStringparameters2.Add("@factory_code", sysStocks[0].FactoryCode);
updateStringparameters2.Add("@enabled", "Y");
updateStringparameters2.Add("@create_userid", loginId);
updateStringparameters2.Add("@create_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
updateStringparameters2.Add("@guid", Guid.NewGuid());
updateStringparameters2.Add("@rack_num", 1);
updateStringparameters2.Add("@update_userid", loginId);
updateStringparameters2.Add("@update_time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sqlStrings.Add(updateString2.ToString());
parameterList.Add(updateStringparameters2);
}
int recNum = repository.SQLTransaction(sqlStrings, parameterList);
if (recNum > 0)
{
List<SysStock> sysStocksSrc = repository.GetSysStockBySumQty(srcRackNo);
if (sysStocksSrc.Count==0)
{
repository.UpdateStockByRackNo(srcRackNo);
}
List<SysStock> sysStocksSum = repository.GetSysStockBySumQty(destRackNo);
if (sysStocksSum.Count > 0)
{
rfInfo.type = "PASS";
rfInfo.message = "拆分成功，请扫描源台车";
rfInfo.wmsObjectDetail = sysStocksSum.ConvertAll(s => (object)s);
}
else
{
rfInfo.type = "FAIL";
rfInfo.message = "未查询到数据，请检查！";
}
}
return rfInfo;
}
}
}
Reference in New Issue View Git Blame Copy Permalink