using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
|
using HH.WCS.Mobox3.DSZSH.models;
|
using HH.WCS.Mobox3.DSZSH.util;
|
using HH.WCS.Mobox3.DSZSH.wms;
|
|
using Newtonsoft.Json;
|
|
using SqlSugar;
|
|
using static HH.WCS.Mobox3.DSZSH.api.ApiModel;
|
using static HH.WCS.Mobox3.DSZSH.api.OtherModel;
|
|
namespace HH.WCS.Mobox3.DSZSH.api {
|
public class ApiHelper {
|
/// <summary>
|
/// 满箱下线入库
|
/// </summary>
|
/// <remarks>
|
/// 人工：产线==>满箱操作区<br/>
|
/// PDA：调用接口，呼叫AGV<br/>
|
/// AGV：满箱操作区==搬运==>货架区（不指定终点货区）
|
/// </remarks>
|
/// <param name="model">包含：物料信息、起点货位</param>
|
/// <returns></returns>
|
public static SimpleResult GoodpackOffline(GoodpackOfflineInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var taskInfo = ETask.M满箱下线入库.Info();
|
const string preLog = "API：满箱下线入库：";
|
const string cntrType = "好运箱";
|
|
try {
|
if (model.Num <= 0) {
|
return NewSimpleResult(400, preLog + $"物料数量'{model.Num}'不合法！要求：物料数量＞0");
|
}
|
|
// TODO model 中 数量、规格是否也参与比对 待后续要求
|
var cgDetail = db.Queryable<TN_CG_Detail>().Where(d => d.S_ITEM_CODE == model.ItemCode && d.S_BATCH_NO == model.BatchNo && d.N_ITEM_STATE == 1 && d.S_ITEM_STATE == "待检").First();
|
if (cgDetail == null) {
|
return NewSimpleResult(1, preLog + $"没有在货品明细表中找到[物料编码='{model.ItemCode}',批次号='{model.BatchNo}']的物料！请检查：PDA扫码物料信息与贴标机传递的信息是否一致！要求：物料状态='待检'；");
|
}
|
|
var startLoc = LocationHelper.Query(db, 0, 0, taskInfo.StartAreas, model.StartLoc).First();
|
if (startLoc == null) {
|
return NewSimpleResult(2, LogBuilder.StartLocNotFound(0, 0, taskInfo.StartAreas, model.StartLoc, preLog));
|
}
|
startLoc.N_CURRENT_NUM = 1; // 绑定后
|
|
|
var locCntrRel = new TN_Loc_Container {
|
S_LOC_CODE = startLoc.S_CODE,
|
S_CNTR_CODE = cgDetail.S_CNTR_CODE,
|
S_CNTR_TYPE = cntrType,
|
};
|
|
// Order：按货位层数，从小到大排列
|
var endLoc = LocationHelper.Query(db, 0, 0, taskInfo.EndAreas).OrderBy(l => new { l.N_LAYER }).First();
|
if (endLoc == null) {
|
return NewSimpleResult(3, LogBuilder.EndLocNotFound(0, 0, taskInfo.EndAreas, pre: preLog));
|
}
|
|
LocationHelper.LockStartLoc(ref startLoc);
|
LocationHelper.LockEndLoc(ref endLoc);
|
|
var cntId = locCntrRel.S_CNTR_CODE; // 容器号
|
var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskInfo.TaskName);
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, preLog + $"插入[货位容器绑定表]失败！" + JsonConvert.SerializeObject(locCntrRel));
|
}
|
|
if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY, it.N_CURRENT_NUM, }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, preLog + $"更新起点货位'{startLoc.S_CODE}'锁状态失败！");
|
}
|
|
if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY, }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, preLog + $"更新终点货位'{endLoc.S_CODE}'锁状态失败！");
|
}
|
|
if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, preLog + $"生成任务'{taskInfo.TaskName}'失败！任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}");
|
}
|
|
tran.CommitTran();
|
return NewSimpleResult(0, LogBuilder.CreateTaskSuccess(task, preLog));
|
}
|
}
|
catch (Exception ex) {
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}", false);
|
}
|
}
|
|
/// <summary>
|
/// 空托入库
|
/// </summary>
|
/// <remarks>
|
/// 人工将空托盘通过接驳位入库，需要新绑定容器货位<br/>
|
/// 由于空托盘一般是出库卸货后获得，而出库时没有手动卸货的逻辑，所以需要在入库的时候再删除旧绑定信息
|
/// </remarks>
|
/// <param name="model">包含：起点货位、容器号、容器类型、终点货区</param>
|
/// <returns></returns>
|
public static SimpleResult EmptyInboundPallet(EmptyInboundInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var taskInfo = ETask.K空托入库.Info();
|
const string pre = "API：空托入库：";
|
const string cntrType = "托盘";
|
|
try {
|
var startLoc = LocationHelper.Query(db, 0, 0, taskInfo.StartAreas, model.StartLoc).First();
|
if (startLoc == null) {
|
return NewSimpleResult(1, LogBuilder.StartLocNotFound(0, 0, taskInfo.StartAreas, model.StartLoc, pre));
|
}
|
|
// 对于前台程序而言，S_CODE就是主键，维护时必定唯一
|
var cntr = db.Queryable<TN_Container>().Where(c => c.S_CODE == model.CntrCode).First();
|
if (cntr == null) {
|
return NewSimpleResult(2, pre + $"容器'{model.CntrCode}'在[容器表]中不存在，请在前台页面中维护！");
|
}
|
if (cntr.S_TYPE != cntrType) {
|
return NewSimpleResult(3, pre + $"容器'{model.CntrCode}'在[容器表]中的类型为'{cntr.S_TYPE}'，与输入的容器类型'{cntrType}'不同！");
|
}
|
|
// 假定人工不会将有物料的箱子放在空箱入库接驳位，没有必要检查
|
// 如果人工将出库后的托盘入库，这时物料信息并没有删除，需要将托盘物料的关系解除
|
var cgDetailOld = db.Queryable<TN_CG_Detail>().Where(d => d.S_CNTR_CODE == model.CntrCode).First();
|
|
// 如果人工将出库后的托盘入库，此时容器仍然与旧的出库货位绑定，需要检查
|
var locCntrRelOld = db.Queryable<TN_Loc_Container>().Where(c => c.S_CNTR_CODE == model.CntrCode).First();
|
|
TN_Location locOld = null;
|
if (locCntrRelOld != null) { // 如果需要解绑容器货位，也需要修改货位信息
|
locOld = db.Queryable<TN_Location>().Where(l => l.S_CODE == locCntrRelOld.S_LOC_CODE).First();
|
if (locOld != null) {
|
locOld.N_CURRENT_NUM = 0; // 如果旧货位存在，将旧货位的数量设置为 0
|
locOld.T_MODIFY = DateTime.Now;
|
}
|
}
|
|
// 绑定货位和容器号（PDA在接驳位绑定）
|
var locCntrRel = new TN_Loc_Container { S_LOC_CODE = startLoc.S_CODE, S_CNTR_CODE = cntr.S_CODE, S_CNTR_TYPE = cntrType };
|
startLoc.N_CURRENT_NUM = 1; // 绑定后
|
|
|
// TODO 暂定选择最低层按区位顺序入库，后面待修改
|
var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y" && taskInfo.EndAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).OrderBy(l => new { l.N_LAYER, l.N_ROW, l.N_COL }).First();
|
if (endLoc == null) {
|
return NewSimpleResult(4, pre + $"没有找到合适的终点货位！要求：(1)未上锁;(2)数量=0;(3)货区属于['{string.Join("','", taskInfo.EndAreas)}'];");
|
}
|
|
LocationHelper.LockStartLoc(ref startLoc);
|
LocationHelper.LockEndLoc(ref endLoc);
|
var cntId = locCntrRel.S_CNTR_CODE; // 容器号
|
var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskInfo.TaskName);
|
|
using (var tran = db.Ado.UseTran()) {
|
if (cgDetailOld != null && db.Deleteable<TN_CG_Detail>(cgDetailOld).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"删除[旧物料信息]失败！" + JsonConvert.SerializeObject(cgDetailOld));
|
}
|
|
if (locCntrRelOld != null && db.Deleteable<TN_Loc_Container>(locCntrRelOld).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"删除[旧货位容器关系]失败！" + JsonConvert.SerializeObject(locCntrRelOld));
|
}
|
|
if (locOld != null && db.Updateable<TN_Location>(locOld).UpdateColumns(l => new { l.N_CURRENT_NUM, l.T_MODIFY }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"更新[旧货位][容器数量]失败！" + JsonConvert.SerializeObject(locOld));
|
}
|
|
if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"插入[货位容器关系]失败：" + JsonConvert.SerializeObject(locCntrRel));
|
}
|
|
if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY, it.N_CURRENT_NUM, }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"更新起点货位'{startLoc.S_CODE}'锁状态失败！");
|
}
|
|
if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY, }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"更新终点货位'{endLoc.S_CODE}'锁状态失败！");
|
}
|
|
if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"生成任务'{taskInfo.TaskName}'失败！任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}");
|
}
|
|
tran.CommitTran();
|
return NewSimpleResult(0, pre + $"生成任务'{taskInfo.TaskName}'成功！任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}");
|
}
|
}
|
catch (Exception ex) {
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(-1, pre + $"发生了异常：{ex.Message}", false);
|
}
|
}
|
|
/// <summary>
|
/// 空箱入库
|
/// </summary>
|
/// <remarks>
|
/// 人工：空箱==搬运==>入库接驳位，需要新绑定容器货位<br/>
|
/// 由于空箱一般是出库卸货后获得，而出库时没有手动卸货的逻辑，所以需要在入库的时候再删除旧绑定信息
|
/// </remarks>
|
/// <returns></returns>
|
public static SimpleResult EmptyInboundGoodpack(EmptyInboundInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var taskInfo = ETask.K空箱入库.Info();
|
const string pre = "API：空箱入库：";
|
const string cntrType = "好运箱";
|
|
try {
|
var startLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y" && l.S_CODE == model.StartLoc && taskInfo.StartAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).First();
|
if (startLoc == null) {
|
return NewSimpleResult(1, pre + $"没有找到起点货位'{model.StartLoc}'！要求：(1)未上锁;(2)数量=0;(3)货区属于['{string.Join("','", taskInfo.StartAreas)}'];");
|
}
|
|
// 对于前台程序而言，S_CODE就是主键，维护时必定唯一
|
var cntr = db.Queryable<TN_Container>().Where(c => c.S_CODE == model.CntrCode).First();
|
if (cntr == null) {
|
return NewSimpleResult(2, pre + $"容器'{model.CntrCode}'在[容器表]中不存在，请在前台页面中维护！");
|
}
|
if (cntr.S_TYPE != cntrType) {
|
return NewSimpleResult(3, pre + $"容器'{model.CntrCode}'在[容器表]中的类型为'{cntr.S_TYPE}'，与输入的容器类型'{cntrType}'不同！");
|
}
|
|
// 假定人工不会将有物料的箱子放在空箱入库接驳位，没有必要检查
|
// 如果人工将出库后的托盘入库，这时物料信息并没有删除，需要将托盘物料的关系解除
|
var cgDetailOld = db.Queryable<TN_CG_Detail>().Where(d => d.S_CNTR_CODE == model.CntrCode).First();
|
|
// 如果人工将出库后的托盘入库，此时容器仍然与旧的出库货位绑定，需要检查
|
var locCntrRelOld = db.Queryable<TN_Loc_Container>().Where(c => c.S_CNTR_CODE == model.CntrCode).First();
|
|
TN_Location locOld = null;
|
if (locCntrRelOld != null) { // 如果需要解绑容器货位，也需要修改货位信息
|
locOld = db.Queryable<TN_Location>().Where(l => l.S_CODE == locCntrRelOld.S_LOC_CODE).First();
|
if (locOld != null) {
|
locOld.N_CURRENT_NUM = 0; // 如果旧货位存在，将旧货位的数量设置为 0
|
locOld.T_MODIFY = DateTime.Now;
|
}
|
}
|
|
// 绑定货位和容器号（PDA在接驳位绑定）
|
var locCntrRel = new TN_Loc_Container { S_LOC_CODE = startLoc.S_CODE, S_CNTR_CODE = cntr.S_CODE, S_CNTR_TYPE = cntrType };
|
startLoc.N_CURRENT_NUM = 1; // 绑定后
|
|
|
// TODO 暂定选择最低层按区位顺序入库，后面待修改
|
var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y" && taskInfo.EndAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).OrderBy(l => new { l.N_LAYER, l.N_ROW, l.N_COL }).First();
|
if (endLoc == null) {
|
return NewSimpleResult(4, pre + $"没有找到合适的终点货位！要求：(1)未上锁;(2)数量=0;(3)货区属于['{string.Join("','", taskInfo.EndAreas)}'];");
|
}
|
|
LocationHelper.LockStartLoc(ref startLoc);
|
LocationHelper.LockEndLoc(ref endLoc);
|
var cntId = locCntrRel.S_CNTR_CODE; // 容器号
|
var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskInfo.TaskName);
|
|
using (var tran = db.Ado.UseTran()) {
|
if (cgDetailOld != null && db.Deleteable<TN_CG_Detail>(cgDetailOld).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"删除[旧物料信息]失败！" + JsonConvert.SerializeObject(cgDetailOld));
|
}
|
|
if (locCntrRelOld != null && db.Deleteable<TN_Loc_Container>(locCntrRelOld).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"删除[旧货位容器关系]失败！" + JsonConvert.SerializeObject(locCntrRelOld));
|
}
|
|
if (locOld != null && db.Updateable<TN_Location>(locOld).UpdateColumns(l => new { l.N_CURRENT_NUM, l.T_MODIFY }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"更新[旧货位][容器数量]失败！" + JsonConvert.SerializeObject(locOld));
|
}
|
|
if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"插入[货位容器关系]失败：" + JsonConvert.SerializeObject(locCntrRel));
|
}
|
|
if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY, it.N_CURRENT_NUM, }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"更新起点货位'{startLoc.S_CODE}'锁状态失败！");
|
}
|
|
if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY, }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"更新终点货位'{endLoc.S_CODE}'锁状态失败！");
|
}
|
|
if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
return NewSimpleResult(500, pre + $"生成任务'{taskInfo.TaskName}'失败！任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}");
|
}
|
|
tran.CommitTran();
|
return NewSimpleResult(0, pre + $"生成任务'{taskInfo.TaskName}'成功！任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}");
|
}
|
}
|
catch (Exception ex) {
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(-1, pre + $"发生了异常：{ex.Message}", false);
|
}
|
}
|
|
/// <summary>
|
/// 空托上线出库
|
/// </summary>
|
/// <remarks>
|
/// 人工根据当前生产物料所需的容器类型，呼叫AGV从空容器货架中叫一个符合要求的托盘
|
/// </remarks>
|
/// <param name="model">包含：容器号、物料编码</param>
|
/// <returns></returns>
|
public static SimpleResult EmptyOnlinePallet(EmptyOnlinePalletInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var info = "";
|
|
var taskInfo = Settings.GetTaskInfo(ETask.K空托上线出库);
|
var taskName = taskInfo.TaskName;
|
var startAreas = taskInfo.StartAreas;
|
var endAreas = taskInfo.EndAreas;
|
const string cntrType = "托盘";
|
|
try {
|
var cntr = db.Queryable<TN_Container>()
|
.Where(c => c.S_CODE == model.CntId)
|
.First();
|
|
if (cntr == null) {
|
info = $"容器'{model.CntId}'在容器表中不存在，请在前台页面中维护！";
|
LogHelper.Info(info);
|
return NewSimpleResult(1, info);
|
}
|
if (cntr.S_TYPE != cntrType) { // 容器类型默认不会为空
|
info = $"容器'{model.CntId}'在容器表中的类型是'{cntr.S_TYPE}，不是'{cntrType}'！";
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
var needUpdateContainer = false;
|
if (string.IsNullOrEmpty(cntr.S_SPEC)) {
|
// TEMP 目前流程：如果容器表中规格（物料编码）为空，根据流程的物料信息写入
|
// 待定：后面可能会更改流程，或者用其他信息（如物料类型/规格）作为容器的规格
|
|
needUpdateContainer = true;
|
info = $"容器'{model.CntId}'在容器表中 规格（物料编码）为空，将物料编码'{model.ItemCode}'写入容器的规格";
|
LogHelper.Info(info);
|
|
cntr.S_SPEC = model.ItemCode;
|
}
|
else if (cntr.S_SPEC != model.ItemCode) {
|
info = $"容器'{model.CntId}'已经与物料类型'{cntr.S_SPEC}'绑定，无法用于装载物料'{model.ItemCode}'";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
var startLoc = db.Queryable<TN_Location>()
|
.LeftJoin<TN_Loc_Container>((l, c) => l.S_CODE == c.S_LOC_CODE)
|
.Where((l, c) => c.S_CNTR_CODE == model.CntId)
|
.Where(l => startAreas.Contains(l.S_AREA_CODE))
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
|
.Where(l => l.N_CURRENT_NUM == 1)
|
.First();
|
|
if (startLoc == null) {
|
info = $"找不到适用于{model.ItemCode}物料、且编码为{model.CntId}的空托盘";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
var endLoc = db.Queryable<TN_Location>()
|
.Where(l => endAreas.Contains(l.S_AREA_CODE))
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
|
.Where(l => l.N_CURRENT_NUM == 0)
|
.First();
|
|
if (endLoc == null) {
|
info = $"找不到合适的终点货位，需要满足：未上锁、当前容器数量=0";
|
LogHelper.Info(info);
|
return NewSimpleResult(4, info);
|
}
|
|
var cntId = model.CntId;
|
|
LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
|
LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
|
var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
|
|
cntr.S_SOURCE = task.S_CODE; // 用任务号作为容器更新的依据
|
cntr.T_MODIFY = DateTime.Now;
|
|
using (var tran = db.Ado.UseTran()) {
|
if (needUpdateContainer) {
|
if (db.Updateable<TN_Container>(cntr)
|
.UpdateColumns(c => new { c.S_SPEC, c.S_SOURCE, c.T_MODIFY }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"更新表容器表失败：" + JsonConvert.SerializeObject(cntr);
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
}
|
|
if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新终点货位'{endLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
tran.CommitTran();
|
info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(0, info);
|
}
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(-1, info);
|
}
|
}
|
|
/// <summary>
|
/// 空箱上线出库
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public static SimpleResult EmptyOnlineGoodpack(EmptyOnlineGoodpackInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var info = "";
|
|
var taskInfo = Settings.GetTaskInfo(ETask.K空箱上线出库);
|
var taskName = taskInfo.TaskName;
|
var startAreas = taskInfo.StartAreas;
|
var endAreas = taskInfo.EndAreas;
|
const string cntrType = "好运箱";
|
|
try {
|
var cntr = db.Queryable<TN_Container>()
|
.Where(c => c.S_CODE == model.CntId)
|
.First();
|
|
if (cntr == null) {
|
info = $"容器'{model.CntId}'在【容器表】中不存在，请在前台页面中维护！";
|
LogHelper.Info(info);
|
return NewSimpleResult(1, info);
|
}
|
if (cntr.S_TYPE != cntrType) {
|
info = $"容器'{model.CntId}'在【容器表】中的类型={cntr.S_TYPE}，不是'{cntrType}'！";
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
var startLoc = db.Queryable<TN_Location>()
|
.LeftJoin<TN_Loc_Container>((l, c) => l.S_CODE == c.S_LOC_CODE)
|
.Where((l, c) => c.S_CNTR_CODE == model.CntId && c.S_CNTR_TYPE == "好运箱")
|
.Where(l => startAreas.Contains(l.S_AREA_CODE))
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
|
.Where(l => l.N_CURRENT_NUM == 1)
|
.First();
|
|
if (startLoc == null) {
|
info = $"没有找到起点货位'{model.CntId}的空好运箱的【起点货位】，或不满足：未上锁、当前数量=1";
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
var endLoc = db.Queryable<TN_Location>()
|
.Where(l => endAreas.Contains(l.S_AREA_CODE))
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y") // 筛选：未上锁
|
.Where(l => l.N_CURRENT_NUM == 0)
|
.First();
|
|
if (endLoc == null) {
|
info = $"没有找到合适的终点货位！需要：未上锁、无货物";
|
LogHelper.Info(info);
|
return NewSimpleResult(4, info);
|
}
|
|
var cntId = model.CntId;
|
var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
|
|
LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
|
LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new {
|
it.N_LOCK_STATE,
|
it.S_LOCK_STATE,
|
it.S_LOCK_OP,
|
it.T_MODIFY
|
}).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new {
|
it.N_LOCK_STATE,
|
it.S_LOCK_STATE,
|
it.S_LOCK_OP,
|
it.T_MODIFY
|
}).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新终点货位'{endLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
tran.CommitTran();
|
info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(0, info);
|
}
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(-1, info);
|
}
|
}
|
|
/// <summary>
|
/// 抽检合格回库
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public static SimpleResult QualifiedBack(QualifiedBackInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var info = "";
|
|
var taskInfo = Settings.GetTaskInfo(ETask.C抽检合格回库);
|
var taskName = taskInfo.TaskName;
|
var startAreas = taskInfo.StartAreas;
|
var endAreas = taskInfo.EndAreas;
|
|
try {
|
var cgDetail = db.Queryable<TN_CG_Detail>()
|
.Where(d => d.S_ITEM_CODE == model.ItemCode && d.S_CNTR_CODE == model.CntrCode)
|
.First();
|
|
if (cgDetail == null) {
|
info = "没有找到待回库的抽检物料：" + JsonConvert.SerializeObject(model);
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
var locCntrRel = db.Queryable<TN_Loc_Container>()
|
.Where(c => c.S_CNTR_CODE == cgDetail.S_CNTR_CODE)
|
.First();
|
|
if (locCntrRel == null) {
|
info = $"容器{model.CntrCode}在货位容器关系表中不存在";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
var startLoc = db.Queryable<TN_Location>()
|
.Where(l => l.S_CODE == locCntrRel.S_LOC_CODE)
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y") // 筛选：未上锁
|
.Where(l => l.N_CURRENT_NUM == 1)
|
.Where(l => startAreas.Contains(l.S_AREA_CODE)) // 起点货区符合任务要求
|
.First();
|
|
if (startLoc == null) {
|
info = $"没有找到容器{model.CntrCode}的起点货位，或不具备取货要求：未上锁、有货物";
|
LogHelper.Info(info);
|
return NewSimpleResult(4, info);
|
}
|
|
TN_Location endLoc = null;
|
if (locCntrRel.S_CNTR_TYPE == "托盘") {
|
endAreas = taskInfo.EndAreas_Pallet;
|
endLoc = db.Queryable<TN_Location>()
|
.Where(l => startAreas.Contains(l.S_AREA_CODE))
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
|
.Where(l => l.N_CURRENT_NUM == 0).First();
|
}
|
else if (locCntrRel.S_CNTR_TYPE == "好运箱") {
|
endAreas = taskInfo.EndAreas_Goodpack;
|
endLoc = db.Queryable<TN_Location>().Where(l => startAreas.Contains(l.S_AREA_CODE)).Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => l.N_CURRENT_NUM == 0).First();
|
}
|
else {
|
return NewSimpleResult(-1, $"托盘类型{locCntrRel.S_CNTR_TYPE}不合法：托盘号{locCntrRel.S_CNTR_CODE}");
|
}
|
|
if (endLoc == null) {
|
info = $"没有找到合适的【终点货位】，或不满足要求：未上锁、当前容器数量为 0";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
cgDetail.N_ITEM_STATE = 0;
|
cgDetail.S_ITEM_STATE = "合格";
|
cgDetail.T_MODIFY = DateTime.Now;
|
|
var cntId = locCntrRel.S_CNTR_CODE;
|
var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
|
|
LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
|
LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Updateable<TN_CG_Detail>(cgDetail).UpdateColumns(it => new { it.N_ITEM_STATE, it.S_ITEM_STATE, it.T_MODIFY }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成'{taskName}'失败：修改物料状态为'合格'失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新终点货位'{endLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
tran.CommitTran();
|
info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(0, info);
|
}
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(-1, info);
|
}
|
}
|
|
/// <summary>
|
/// 抽检不合格移库
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public static SimpleResult UnqualifiedShift(UnqualifiedShiftInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var info = "";
|
|
const ETask eTask = ETask.C抽检不合格移库;
|
var taskName = Settings.GetTaskInfo(eTask).TaskName;
|
var startAreas = Settings.GetTaskInfo(eTask).StartAreas;
|
var endAreas = Settings.GetTaskInfo(eTask).EndAreas;
|
|
try {
|
if (!startAreas.Contains(model.EndArea)) {
|
info = $"终点库区'{model.EndArea}'不满足条件！需要：货区属于[{string.Join(", ", startAreas)}]";
|
LogHelper.Info(info);
|
return NewSimpleResult(1, info);
|
}
|
|
var cgDetail = db.Queryable<TN_CG_Detail>()
|
.Where(d => d.S_ITEM_CODE == model.ItemCode && d.S_CNTR_CODE == model.CntrCode)
|
.First();
|
|
if (cgDetail == null) {
|
info = $"没有在物料明细表中，找到物料编码={model.ItemCode}、容器编码={model.CntrCode}的物料";
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
var locCntrRel = db.Queryable<TN_Loc_Container>()
|
.Where(c => c.S_CNTR_CODE == cgDetail.S_CNTR_CODE)
|
.First();
|
|
if (locCntrRel == null) {
|
info = $"容器'{model.CntrCode}'在货位容器关系表中不存在";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
var startLoc = db.Queryable<TN_Location>()
|
.Where(l => l.S_CODE == locCntrRel.S_LOC_CODE)
|
.Where(l => startAreas.Contains(l.S_AREA_CODE))
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y") // 筛选：未上锁
|
.Where(l => l.N_CURRENT_NUM == 1)
|
.First();
|
|
if (startLoc == null) {
|
info = $"起点货位' {locCntrRel.S_LOC_CODE} '不满足条件！需要：货区属于[ {string.Join(", ", startAreas)} ]";
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
var endLoc = db.Queryable<TN_Location>()
|
.Where(l => l.S_AREA_CODE == model.EndArea)
|
.Where(a => a.N_LOCK_STATE == 0 && a.S_LOCK_STATE == "无" && a.C_ENABLE == "Y") // 筛选：未上锁
|
.Where(a => a.N_CURRENT_NUM == 0)
|
.First();
|
|
if (endLoc == null) {
|
info = $"在终点货区'{model.EndArea}'中，没有找到合适的【终点货位】，需要满足要求：未上锁、当前容器数量=0";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
cgDetail.N_ITEM_STATE = 2;
|
cgDetail.S_ITEM_STATE = "不合格";
|
|
var cntId = locCntrRel.S_CNTR_CODE;
|
var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
|
|
LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
|
LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Updateable<TN_CG_Detail>(cgDetail).UpdateColumns(it =>
|
new { it.N_ITEM_STATE, it.S_ITEM_STATE }).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：修改物料状态为'不合格'失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new {
|
it.N_LOCK_STATE,
|
it.S_LOCK_STATE,
|
it.S_LOCK_OP,
|
it.T_MODIFY
|
}).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new {
|
it.N_LOCK_STATE,
|
it.S_LOCK_STATE,
|
it.S_LOCK_OP,
|
it.T_MODIFY
|
}).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新终点货位'{endLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
tran.CommitTran();
|
info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(0, info);
|
}
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(-1, info);
|
}
|
}
|
|
/// <summary>
|
/// 尾料回库/余料回库
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public static SimpleResult RestBack(RestBackInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var info = "";
|
|
var taskInfo = Settings.GetTaskInfo(ETask.W尾料回库);
|
var taskName = taskInfo.TaskName;
|
var startAreas = taskInfo.StartAreas;
|
List<string> endAreas = null;
|
|
try {
|
var startLoc = db.Queryable<TN_Location>()
|
.Where(l => l.S_CODE == model.StartLoc)
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y") // 筛选：未上锁
|
.Where(l => l.N_CURRENT_NUM == 1)
|
.First();
|
|
if (startLoc == null) {
|
info = $"没有找到起点货位{model.StartLoc}，或不具备取货要求：未上锁、有货物";
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
var locCntrRel = db.Queryable<TN_Loc_Container>()
|
.Where(c => c.S_LOC_CODE == model.StartLoc)
|
.First();
|
|
if (locCntrRel == null) {
|
info = $"没有找到起点货位{model.StartLoc}所绑定的容器";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
TN_Location endLoc = null;
|
if (locCntrRel.S_CNTR_TYPE == "托盘") {
|
endAreas = taskInfo.EndAreas_Pallet;
|
endLoc = db.Queryable<TN_Location>()
|
.Where(l => endAreas.Contains(l.S_AREA_CODE))
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y") // 筛选：未上锁
|
.Where(l => l.N_CURRENT_NUM == 0)
|
.First();
|
}
|
else if (locCntrRel.S_CNTR_TYPE == "好运箱"){
|
endAreas = taskInfo.EndAreas_Goodpack;
|
endLoc = db.Queryable<TN_Location>()
|
.Where(l => endAreas.Contains(l.S_AREA_CODE))
|
.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y") // 筛选：未上锁
|
.Where(l => l.N_CURRENT_NUM == 0)
|
.First();
|
}
|
|
if (endLoc == null) {
|
info = "查询：没有找到合适的终点货位";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
var cntId = locCntrRel.S_CNTR_CODE;
|
|
LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
|
LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
|
var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new {
|
it.N_LOCK_STATE,
|
it.S_LOCK_STATE,
|
it.S_LOCK_OP,
|
it.T_MODIFY
|
}).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新起点货位{startLoc.S_CODE}锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new {
|
it.N_LOCK_STATE,
|
it.S_LOCK_STATE,
|
it.S_LOCK_OP,
|
it.T_MODIFY
|
}).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败：更新终点货位'{endLoc.S_CODE}'锁状态失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = $"生成任务'{taskName}'失败，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(500, info);
|
}
|
|
tran.CommitTran();
|
info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
|
LogHelper.Info(info);
|
return NewSimpleResult(0, info);
|
}
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(-1, info);
|
}
|
}
|
|
/// <summary>
|
/// 成品胶出库(PDA) 待定，暂时不需要此功能
|
/// </summary>
|
/// <remarks>
|
/// WMS提供出库的物料类型与数量，调用接口由WCS生成具体的出库任务，然后WCS后台轮询处理
|
/// </remarks>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public static SimpleResult FinishedOutbound(FinishedOutboundInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var info = "";
|
|
var taskInfo = Settings.GetTaskInfo(ETask.C成品胶出库);
|
var taskName = taskInfo.TaskName;
|
|
try {
|
var orderNo = GenerateOrderNo("出库单号", "CKD");
|
|
var cgDetailList = SelectCgByTotalQty(model.Qty, model.ItemCode, model.BatchNo, model.CntrType, model.ForcedOut);
|
|
if (cgDetailList.Count == 0) {
|
info = "没有合适的物料可以出库";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
var order = new TN_Outbound_Order {
|
S_NO = orderNo,
|
S_ITEM_CODE = model.ItemCode,
|
S_BATCH = model.BatchNo,
|
N_END_NUM = model.Qty,
|
S_END_AREA = model.EndArea
|
};
|
|
var detailList = new List<TN_Outbound_Detail>();
|
foreach (var cgDetail in cgDetailList) {
|
var detail = new TN_Outbound_Detail {
|
S_OO_NO = orderNo,
|
S_ITEM_CODE = cgDetail.S_ITEM_CODE,
|
S_BATCH_NO = cgDetail.S_BATCH_NO,
|
S_CNTR_CODE = cgDetail.S_CNTR_CODE,
|
N_COUNT = cgDetail.N_ITEM_NUM,
|
S_END_AREA = model.EndArea
|
};
|
detailList.Add(detail);
|
}
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Insertable<TN_Outbound_Order>(order).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = "生成出库单失败：" + JsonConvert.SerializeObject(order);
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
if (db.Insertable<TN_Outbound_Detail>(detailList).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = "生成出库单明细失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(4, info);
|
}
|
|
tran.CommitTran();
|
}
|
|
info = "生成出库单成功";
|
LogHelper.Info(info);
|
return NewSimpleResult(0, info);
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(1, info);
|
}
|
}
|
|
/// <summary>
|
/// 成品胶强制出库(WMS)
|
/// </summary>
|
/// <returns></returns>
|
public static SimpleResult FinishedOutboundForce(FinishedOutboundInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var info = "";
|
|
var taskInfo = Settings.GetTaskInfo(ETask.C成品胶出库);
|
var taskName = taskInfo.TaskName;
|
|
try {
|
var orderNo = GenerateOrderNo("出库单号", "CKD");
|
|
var cgDetailList = SelectCgByTotalQty(model.Qty, model.ItemCode, model.BatchNo, model.CntrType, model.ForcedOut);
|
|
if (cgDetailList.Count == 0) {
|
info = "没有合适的物料可以出库";
|
LogHelper.Info(info);
|
return NewSimpleResult(3, info);
|
}
|
|
var order = new TN_Outbound_Order {
|
S_NO = orderNo,
|
S_ITEM_CODE = model.ItemCode,
|
S_BATCH = model.BatchNo,
|
N_END_NUM = model.Qty,
|
S_END_AREA = model.EndArea
|
};
|
|
var detailList = new List<TN_Outbound_Detail>();
|
foreach (var cgDetail in cgDetailList) {
|
var detail = new TN_Outbound_Detail {
|
S_OO_NO = orderNo,
|
S_ITEM_CODE = cgDetail.S_ITEM_CODE,
|
S_BATCH_NO = cgDetail.S_BATCH_NO,
|
S_CNTR_CODE = cgDetail.S_CNTR_CODE,
|
N_COUNT = cgDetail.N_ITEM_NUM,
|
S_END_AREA = model.EndArea
|
};
|
detailList.Add(detail);
|
}
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Insertable<TN_Outbound_Order>(order).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = "生成出库单失败：" + JsonConvert.SerializeObject(order);
|
LogHelper.Info(info);
|
return NewSimpleResult(2, info);
|
}
|
|
if (db.Insertable<TN_Outbound_Detail>(detailList).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = "生成出库单明细失败";
|
LogHelper.Info(info);
|
return NewSimpleResult(4, info);
|
}
|
|
tran.CommitTran();
|
}
|
|
info = "生成出库单成功";
|
LogHelper.Info(info);
|
return NewSimpleResult(0, info);
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewSimpleResult(1, info);
|
}
|
}
|
|
public static List<TN_CG_Detail> SelectCgByTotalQty(int qty, string itemCode, string batchNo, string cntrType = "", bool forcedOut = true) {
|
var db = new SqlHelper<object>().GetInstance();
|
var result = new List<TN_CG_Detail>();
|
var targetNum = qty;
|
var info = "";
|
try {
|
var targetCg = db.Queryable<TN_CG_Detail>()
|
.Where(a => a.S_ITEM_CODE == itemCode && a.S_BATCH_NO == batchNo)
|
.Where(a => a.N_ITEM_NUM > targetNum)
|
.OrderBy(a => a.N_ITEM_NUM, OrderByType.Asc).First();
|
if (targetCg != null) //刚好有一行满足条件
|
{
|
result.Add(targetCg);
|
return result;
|
}
|
|
// NOTE 根据总量选detail时，是否需要考虑货位的高低？
|
|
var sortedMaterials = new List<TN_CG_Detail>();
|
|
var cntrTypeList = new List<string>();
|
if (cntrType == "") {
|
cntrTypeList = new List<string> { "托盘", "好运箱" }; // 不指定托盘类型，二者均可
|
}
|
else {
|
cntrTypeList.Add(cntrType);
|
}
|
|
if (forcedOut) {
|
sortedMaterials = db.Queryable<TN_CG_Detail, TN_Loc_Container>((d, c) => d.S_CNTR_CODE == c.S_CNTR_CODE)
|
.Where(d => d.S_ITEM_CODE == itemCode && d.S_BATCH_NO == batchNo && d.N_ITEM_NUM > 0)
|
.Where((d, c) => cntrTypeList.Contains(c.S_CNTR_TYPE))
|
.Where(d => d.N_ITEM_STATE == 0 && d.S_ITEM_STATE == "合格"
|
|| d.N_ITEM_STATE == 1 && d.S_ITEM_STATE == "待检")
|
.OrderBy(d => d.N_ITEM_NUM, OrderByType.Desc)
|
.OrderBy(d => d.N_ITEM_STATE, OrderByType.Asc).ToList();
|
}
|
else {
|
sortedMaterials = db.Queryable<TN_CG_Detail, TN_Loc_Container>((d, c) => d.S_CNTR_CODE == c.S_CNTR_CODE)
|
.Where(d => d.S_ITEM_CODE == itemCode && d.S_BATCH_NO == batchNo && d.N_ITEM_NUM > 0)
|
.Where((d, c) => cntrTypeList.Contains(c.S_CNTR_TYPE))
|
.Where(d => d.N_ITEM_STATE == 0 && d.S_ITEM_STATE == "合格")
|
.OrderBy(d => d.N_ITEM_NUM, OrderByType.Desc)
|
.OrderBy(d => d.N_ITEM_STATE, OrderByType.Asc).ToList();
|
}
|
|
if (sortedMaterials.Count == 0) //没有满足条件的
|
{
|
return result;
|
}
|
|
int countNum = 0;
|
foreach (var mat in sortedMaterials) {
|
countNum += mat.N_ITEM_NUM;
|
result.Add(mat);
|
if (countNum >= targetNum) {
|
break;
|
}
|
}
|
if (result.Sum(a => a.N_ITEM_NUM) >= targetNum) {
|
return result;
|
}
|
else {
|
result.Clear();
|
return result;
|
}
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return result;
|
}
|
}
|
|
private static string GenerateOrderNo(string snType, string prefix) {
|
var id = SYSHelper.GetSerialNumber(snType, prefix);
|
var date = DateTime.Now.ToString("yyMMdd");
|
return $"{prefix}{date}-{id.ToString().PadLeft(4, '0')}";
|
}
|
|
/// <summary>
|
/// 博实物料信息下发同步（只针对好运箱）
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public static MesResult CgInfoSync(CgInfoSyncInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var info = "";
|
|
try {
|
if (string.IsNullOrEmpty(model.ItemCode)) {
|
info = $"博实下发物料信息：参数不合法：物料编码（itemCode）不能为空";
|
LogHelper.Info(info);
|
return NewMesResult(400, info);
|
}
|
if (string.IsNullOrEmpty(model.CntrCode)) {
|
info = $"博实下发物料信息：参数不合法：容器编码（CntrCode）不能为空";
|
LogHelper.Info(info);
|
return NewMesResult(400, info);
|
}
|
if (string.IsNullOrEmpty(model.BatchNo)) {
|
info = $"博实下发物料信息：参数不合法：批次号（BatchNo）不能为空";
|
LogHelper.Info(info);
|
return NewMesResult(400, info);
|
}
|
if (model.ItemNum <= 0) {
|
info = $"博实下发物料信息：参数不合法：货品数量（ItemNum）应该大于 0";
|
LogHelper.Info(info);
|
return NewMesResult(400, info);
|
}
|
|
// TEMP 目前流程：对博实下发的信息也进行检查，未找到就报错，后面有需求再更改
|
var cntr = db.Queryable<TN_Container>()
|
.Where(c => c.S_CODE == model.CntrCode) // 对于前台程序而言，S_CODE就是主键，维护时必定唯一
|
.First();
|
|
if (cntr == null) {
|
info = $"容器'{model.CntrCode}'在容器表中不存在，请在前台页面中维护！";
|
LogHelper.Info(info);
|
return NewMesResult(1, info);
|
}
|
if (cntr.S_TYPE != "好运箱") {
|
info = $"容器'{model.CntrCode}'在容器表中的类型为'{cntr.S_TYPE}'，与当前容器类型'好运箱'不同！";
|
LogHelper.Info(info);
|
return NewMesResult(2, info);
|
}
|
|
// 将下发的信息先存储到CG表中（此时托盘没有与产线处的货位绑定）
|
var detail = new TN_CG_Detail {
|
S_ITEM_CODE = model.ItemCode, // NOT NULL
|
S_ITEM_NAME = model.ItemName,
|
S_CNTR_CODE = model.CntrCode, // NOT NULL 料箱编号（待定，现在暂时设定为博实下发）
|
S_BATCH_NO = model.BatchNo, // NOT NULL
|
S_STANDARD = model.Standard,
|
S_NET_WEIGHT = model.NetWeight,
|
S_QUALITY_GRADE = model.QualityGrade,
|
};
|
|
// 产线号的逻辑待定，现在设定为博实下发产线号，看后续需求变更
|
// 好运箱起点为产线货位，人工将好运箱从产线上取下，搬运到满好运箱操作区
|
//var startLocCode = "";
|
//if (model.ProdLineId.Trim() == "3") {
|
// startLocCode = "";
|
//}
|
|
//if (model.ProdLineId.Trim() != "3" || model.ProdLineId.Trim() != "4") {
|
// info = $"不合法的产线号{model.ProdLineId}：好运箱产线号必须为 3 或 4";
|
// LogHelper.Info(info);
|
// return NewMesResult(2, info);
|
//}
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Insertable<TN_CG_Detail>(detail).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = "插入物料信息失败：" + JsonConvert.SerializeObject(detail);
|
return NewMesResult(500, info);
|
}
|
|
tran.CommitTran();
|
}
|
|
info = "插入物料信息成功";
|
return NewMesResult(0, info);
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewMesResult(-1, info);
|
}
|
}
|
|
public static ErpResult ErpSendOutboundPlan(ErpSendOutboundPlanInfo model) {
|
var db = new SqlHelper<object>().GetInstance();
|
var orderNo = GenerateOrderNo("出库单号", "CKD");
|
var info = "";
|
try {
|
// 参数合法性确认部分：错误编码：400
|
if (model.pzjs <= 0) {
|
info = $"物料数量(pzjs){model.pzjs}不合法：物料数量应该大于 0";
|
LogHelper.Info(info);
|
return NewErpResult(400, info);
|
}
|
|
var outboundPlan = db.Queryable<TN_Outbound_Plan>()
|
.Where(p => p.JHDH == model.jhdh).First();
|
if (outboundPlan != null) {
|
info = $"计划单号{model.jhdh}已在数据库中存在";
|
LogHelper.Info(info);
|
return NewErpResult(1, info);
|
}
|
|
outboundPlan = new TN_Outbound_Plan {
|
JHDH = model.jhdh, // 计划单号（唯一标识）
|
CKZT = model.ckzt, // 出库状态（需要返回）
|
JHLB = model.jhlb, // 计划类别
|
CKDH = model.ckdh, // 参考单号
|
CPH = model.cph, // 车牌号
|
YSFS = model.ysfs, // 运输方式
|
CPZT = model.cpzt, // 产品状态
|
MDDW = model.mddw, // 买断单位
|
CPDM = model.cpdm, // 产品代码
|
CPLB = model.cplb, // 产品类别
|
CPLBMX = model.cplbmx, // 产品类别明细
|
PP = model.pp, // 品牌
|
DJ = model.dj, // 等级（需要返回）
|
GH = model.gh, // 罐号
|
PH = model.ph, // 批号（需要返回）
|
BZLX = model.bzlx, // 包装类型
|
PZDH = model.pzdh, // 派装单号
|
PZD_DW = model.pzd_dw, // 派装单单位
|
PZD_DYBH = model.pzd_dybh, // 派装单调运编号
|
PZJS = model.pzjs, // 派装件数
|
PZSL = model.pzsl, // 派装数量
|
PZ_RQ = model.pz_rq, // 派装日期(yyyy-mm-dd)
|
PZ_CZRQ = model.pz_czrq, // 派装操作日期
|
PZ_ZFBJ = model.pz_zfbj, // 派装作废标记
|
PZ_ZFRQ = model.pz_zfrq, // 派装作废日期
|
PZ_BZ = model.pz_bz, // 派装备注
|
CKDBH = model.ckdbh, // 出库单编号
|
SFJS = model.sfjs, // 实发件数（需要返回）
|
SFSL = model.sfsl, // 实发数量（需要返回）
|
SFCS = model.sfcs, // 实发车数（需要返回）
|
ZCSJ = model.zcsj, // 装车时间（需要返回）
|
JLDW = model.jldw, // 计量单位（需要返回）
|
FHRQ = model.fhrq, // 发货日期（需要返回）
|
CKDM = model.ckdm, // 仓库代码（需要返回）
|
FHR = model.fhr, // 发货人（需要返回）
|
CZYDM = model.czydm, // 操作员（需要返回）
|
SHR_USERNAME = model.shr_username, // 审核人
|
SHRQ = model.shrq, // 审核日期
|
ZFBJ = model.zfbj, // 作废标记
|
ZFRQ = model.zfrq, // 作废日期
|
JSDW = model.jsdw, // 结算单位
|
SHDW = model.shdw, // 收货单位
|
YSDW = model.ysdw, // 运输单位
|
LXR = model.lxr, // 联系人
|
RY_ZXG = model.ry_zxg, // 装卸工（需要返回）
|
RY_CCSJ = model.ry_ccsj, // 叉车司机（需要返回）
|
ERPHX_JHDH = model.erphx_jhdh, // erp交货单号
|
ERPHX_WLBM = model.erphx_wlbm, // erp物料编码
|
ERPHX_WLMC = model.erphx_wlmc, // erp物料名称
|
ERPHX_CJRQ = model.erphx_cjrq, // erp创建日期
|
HW = model.hw, // 货位（需要返回）
|
HWZT = model.hwzt // 货位状态（需要返回）
|
};
|
|
//var cgDetailList = SelectCgByTotalQty(
|
// qty: (int)model.pzsl,
|
// itemCode: model.cpdm,
|
// batchNo: model.ph
|
// );
|
|
//if (cgDetailList.Count == 0) {
|
// info = "没有合适的物料可以出库";
|
// LogHelper.Info(info);
|
// return NewErpResult(3, info);
|
//}
|
|
var cgDetail = db.Queryable<TN_CG_Detail>()
|
.Where(d => d.S_ITEM_CODE == model.cpdm && d.N_ITEM_NUM >= model.pzjs).First();
|
if (cgDetail == null ) {
|
info = $"没有合适的物料可以满足：物料编码={model.cpdm}，物料数量>={model.pzjs}";
|
LogHelper.Info(info);
|
return NewErpResult(2, info);
|
}
|
|
var order = new TN_Outbound_Order {
|
S_NO = orderNo,
|
//S_ITEM_CODE = model.cpdm,
|
//S_BATCH = model.ph,
|
//N_END_NUM = (int)model.pzsl,
|
S_ITEM_CODE = model.cpdm,
|
S_BATCH = cgDetail.S_BATCH_NO,
|
N_END_NUM = (int)model.pzjs,
|
S_END_AREA = "QCCKQ", // ERP下发出库任务为汽车出库区
|
S_BS_NO = model.jhdh,
|
S_BS_TYPE = "ERP",
|
};
|
|
var detailList = new List<TN_Outbound_Detail>();
|
//foreach (var cgDetail in cgDetailList) {
|
// var detail = new TN_Outbound_Detail {
|
// S_OO_NO = orderNo,
|
// S_ITEM_CODE = cgDetail.S_ITEM_CODE,
|
// S_BATCH_NO = cgDetail.S_BATCH_NO,
|
// S_CNTR_CODE = cgDetail.S_CNTR_CODE,
|
// N_COUNT = cgDetail.N_ITEM_NUM,
|
// S_END_AREA = order.S_END_AREA, // order为detail的每一个货位设置终点值
|
// S_BS_NO = order.S_BS_NO,
|
// S_BS_TYPE= order.S_BS_TYPE,
|
// };
|
// detailList.Add(detail);
|
//}
|
var detail = new TN_Outbound_Detail {
|
S_OO_NO = orderNo,
|
S_ITEM_CODE = cgDetail.S_ITEM_CODE,
|
S_BATCH_NO = cgDetail.S_BATCH_NO,
|
S_CNTR_CODE = cgDetail.S_CNTR_CODE,
|
N_COUNT = cgDetail.N_ITEM_NUM,
|
S_END_AREA = order.S_END_AREA, // order为detail的每一个货位设置终点值
|
S_BS_NO = order.S_BS_NO,
|
S_BS_TYPE = order.S_BS_TYPE,
|
};
|
detailList.Add(detail);
|
|
using (var tran = db.Ado.UseTran()) {
|
if (db.Insertable<TN_Outbound_Order>(order).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = "生成出库单失败：" + JsonConvert.SerializeObject(order);
|
LogHelper.Info(info);
|
return NewErpResult(500, info);
|
}
|
|
if (db.Insertable<TN_Outbound_Detail>(detailList).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = "生成出库单明细失败";
|
LogHelper.Info(info);
|
return NewErpResult(500, info);
|
}
|
|
if (db.Insertable<TN_Outbound_Plan>(outboundPlan).ExecuteCommand() <= 0) {
|
tran.RollbackTran();
|
info = "生成出库单计划记录表失败";
|
LogHelper.Info(info);
|
return NewErpResult(500, info);
|
}
|
|
tran.CommitTran();
|
}
|
|
info = $"生成出库单成功：" + JsonConvert.SerializeObject(order) + "\n出库单明细：" +JsonConvert.SerializeObject(detail);
|
LogHelper.Info(info);
|
return NewErpResult(0, info);
|
}
|
catch (Exception ex) {
|
info = $"发生了异常：{ex.Message}";
|
LogHelper.InfoEx(ex);
|
return NewErpResult(1, info);
|
}
|
}
|
}
|
}
|
