WMSPrjInstance/HH-0121_DuShanZiShiHua.git

			@@ -2,13 +2,15 @@
			using System.Collections.Generic;
			using System.Linq;

			using HH.WCS.Mobox3.DSZSH.core;
			using HH.WCS.Mobox3.DSZSH.models;
			using HH.WCS.Mobox3.DSZSH.util;
			using HH.WCS.Mobox3.DSZSH.wms;

			using Newtonsoft.Json;

			using SqlSugar;

			using Swashbuckle.Swagger;

			using static HH.WCS.Mobox3.DSZSH.api.ApiModel;
			using static HH.WCS.Mobox3.DSZSH.api.OtherModel;
			@@ -16,512 +18,310 @@
			namespace HH.WCS.Mobox3.DSZSH.api {
			public class ApiHelper {
			/// <summary>
			/// 好运箱-满箱下线入库(PDA)
			/// 满箱下线入库
			/// </summary>
			/// <remarks>
			/// 人工：产线==>满箱操作区<br/>
			/// PDA：调用接口，呼叫AGV<br/>
			/// AGV：满箱操作区==搬运==>货架区（不指定终点货区）
			/// </remarks>
			/// <param name="model">包含：物料信息、起点货位</param>
			/// <param name="model"></param>
			/// <returns></returns>
			public static SimpleResult GoodpackOffline(GoodpackOfflineInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.H好运箱_满箱下线入库;
			const string startAreaName = AreaName.M满箱操作区;
			const string endAreaName = AreaName.M满箱货架区;
			var taskInfo = ETask.M满箱下线入库.Info();
			const string preLog = "API：满箱下线入库：";
			const string cntrType = "好运箱";

			try {
			if (model.Num <= 0) {
			info = $"物料数量'{model.Num}'不合法：物料数量应该大于0";
			LogHelper.Info(info);
			return NewSimpleResult(400, info);
			return NewSimpleResult(400, preLog + $"物料数量'{model.Num}'不合法！要求：物料数量＞0");
			}

			var cgDetail = db.Queryable<TN_CG_Detail>()
			.Where(d => d.S_ITEM_CODE == model.ItemCode && d.S_BATCH_NO == model.BatchNo)
			.Where(d => d.N_ITEM_STATE == 1 && d.S_ITEM_STATE == "待检")
			.First(); // TODO model 中数量、规格是否也参与比对待后续要求

			// 检查货品容器表：是否已经存在贴标机传递的待入库物料信息
			// TODO：数量、规格是否也参与比对？
			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) {
			info = $"PDA扫码物料信息与贴标机传递的信息不一致：" + JsonConvert.SerializeObject(model);
			LogHelper.Info(info);
			return NewSimpleResult(1, info);
			return NewSimpleResult(1, preLog + $"没有在[货品明细表]中找到[物料编码='{model.ItemCode}',批次号='{model.BatchNo}']的物料！请检查：PDA扫码物料信息与贴标机传递的信息是否一致！要求：物料状态='待检'");
			}

			var startLoc = db.Queryable<TN_Location>()
			.Where(l => l.S_CODE == model.StartLoc)
			.Where(l => Settings.AreaMap[startAreaName].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();

			// 查询起点货位：数量=0
			var startLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => l.S_CODE == model.StartLoc && taskInfo.StartAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).First();
			if (startLoc == null) {
			info = $"在'{startAreaName}'中没有找到起点货位'{model.StartLoc}'，或不满足要求：未上锁、当前容器数量=0";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			}
			return NewSimpleResult(2, preLog + $"没有找到起点货位'{model.StartLoc}'！要求：锁状态='无'，当前容器数量=0，所在库区={LogObject(taskInfo.StartAreas)}");
			}

			startLoc.N_CURRENT_NUM = 1; // 绑定后
			// 和满托下线入库的逻辑一致，由于容器移动不会更改绑定信息，所以必须删除旧数据
			var locCntrRelOld = db.Queryable<TN_Loc_Container>()
			.Where(c => c.S_CNTR_CODE == cgDetail.S_CNTR_CODE).First();

			var locCntrRel = new TN_Loc_Container {
			S_LOC_CODE = startLoc.S_CODE,
			S_CNTR_CODE = cgDetail.S_CNTR_CODE,
			S_CNTR_TYPE = "好运箱",
			};
			// 绑定货位容器，起点货位当前数量=1
			var locCntrRel = new TN_Loc_Container { S_LOC_CODE = startLoc.S_CODE, S_CNTR_CODE = cgDetail.S_CNTR_CODE, S_CNTR_TYPE = cntrType,};
			startLoc.N_CURRENT_NUM = 1;

			var endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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)
			.OrderBy(l => l.N_LAYER) // 按货架最低排序
			.First();// TODO 满箱入库算法待优化

			// 查询终点货位
			// Order：按货位层数，从小到大排列
			var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
			.Where(l => taskInfo.EndAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).OrderBy(l => new { l.N_LAYER }).First();
			if (endLoc == null) {
			info = $"在'{endAreaName}'中没有找到合适的终点货位，需要满足：未上锁、当前容器数量=0";
			LogHelper.Info(info);
			return NewSimpleResult(3, info);
			}
			return NewSimpleResult(3, preLog + $"没有找到合适的终点货位！要求：锁状态='无'，当前容器数量=0，所在库区={LogObject(taskInfo.EndAreas)}");
			}

			LocationHelper.LockStartLoc(ref startLoc);
			LocationHelper.LockEndLoc(ref endLoc);
			var cntId = locCntrRel.S_CNTR_CODE; // 容器号
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
			// 起点终点上锁，创建任务
			WCSHelper.LockStartLoc(ref startLoc);
			WCSHelper.LockEndLoc(ref endLoc);
			var task = WCSHelper.BuildTask(startLoc, endLoc, locCntrRel.S_CNTR_CODE, taskInfo.TaskName);

			using (var tran = db.Ado.UseTran()) {
			if (locCntrRelOld != null) {
			if (db.Deleteable<TN_Loc_Container>(locCntrRelOld).ExecuteCommand() <= 0 &&
			db.Updateable<TN_Location>().SetColumns(l => l.N_CURRENT_NUM == 0).Where(l => l.S_CODE == locCntrRelOld.S_LOC_CODE).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			return NewSimpleResult(500, preLog + $"删除旧货位容器关系表失败！货位编码={locCntrRelOld.S_LOC_CODE}，容器编码={locCntrRelOld.S_CNTR_CODE}");
			}
			}

			if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) {
			info = $"插入【货位容器绑定】表失败：" + JsonConvert.SerializeObject(locCntrRel);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			return NewSimpleResult(500, preLog + $"插入[容器货位绑定表]失败！数据：{LogObject(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) {
			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();
			info = $"生成任务'{taskName}'失败：更新起点货位{startLoc.S_CODE}锁状态失败";
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[终点货位锁状态]失败！终点='{endLoc.S_CODE}'，锁状态=>'入库锁'");
			}

			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);
			return NewSimpleResult(500, preLog + $"生成任务'{task.S_TYPE}'失败！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}

			tran.CommitTran();
			info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + $"生成任务'{task.S_TYPE}'成功！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(-1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			/// <summary>
			/// 托盘-空托入库(PDA)
			/// 空托入库
			/// </summary>
			/// <remarks>
			/// 人工将空托盘通过接驳位入库，需要新绑定容器货位<br/>
			/// 由于空托盘一般是出库卸货后获得，而出库时没有手动卸货的逻辑，所以需要在入库的时候再删除旧绑定信息
			/// </remarks>
			/// <param name="model">包含：起点货位、容器号、容器类型、终点货区</param>
			/// <param name="model"></param>
			/// <returns></returns>
			public static SimpleResult EmptyInboundPallet(EmptyInboundInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.T托盘_空托入库;
			const string startAreaName = AreaName.K空托入库接驳区;
			const string endAreaName = AreaName.K空托存放区;
			var taskInfo = ETask.K空托入库.Info();
			const string preLog = "API：空托入库：";
			const string cntrType = "托盘";

			try {
			var startLoc = db.Queryable<TN_Location>()
			.Where(l => l.S_CODE == model.StartLoc)
			.Where(l => Settings.AreaMap[startAreaName].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();

			// 查询起点货位：数量=0
			var startLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => l.S_CODE == model.StartLoc && taskInfo.StartAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).First();
			if (startLoc == null) {
			info = $"在'{startAreaName}'中没有找到起点货位'{model.StartLoc}'，或不具备起点取货要求：未上锁、绑定前无货物";
			LogHelper.Info(info);
			return NewSimpleResult(1, info);
			return NewSimpleResult(1, preLog + $"没有找到起点货位'{model.StartLoc}'！要求：锁状态='无'；当前容器数量=0；所在库区={LogObject(taskInfo.StartAreas)}");
			}

			var cntr = db.Queryable<TN_Container>()
			.Where(c => c.S_CODE == model.CntrCode) // 对于前台程序而言，S_CODE就是主键，维护时必定唯一
			.First();

			// 查询容器表：容器类型字段
			var cntr = db.Queryable<TN_Container>().Where(c => c.S_CODE == model.CntrCode).First();
			if (cntr == null) {
			info = $"容器'{model.CntrCode}'在【容器表】中不存在，请在前台页面中维护！";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			return NewSimpleResult(2, preLog + $"容器'{model.CntrCode}'在[容器表]中不存在，请在前台页面中维护！");
			}
			if (cntr.S_TYPE != cntrType) { // 空托入库
			info = $"容器'{model.CntrCode}'在【容器表】中的类型为'{cntr.S_TYPE}'，与输入的容器类型'{cntrType}'不同！";
			LogHelper.Info(info);
			return NewSimpleResult(3, info);
			if (cntr.S_TYPE != cntrType) {
			return NewSimpleResult(3, preLog + $"容器'{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();

			// 空箱入库时，如果存在旧的绑定数据，删除
			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 (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, // 空托入库
			};
			// 绑定货位容器，起点货位当前数量=1
			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;

			startLoc.N_CURRENT_NUM = 1; // 绑定后

			var endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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)
			.OrderBy(l => new { l.N_LAYER, l.N_ROW, l.N_COL }) // TODO 暂定选择最低层按区位顺序入库，后面待修改
			.First();

			// 查询终点货位
			// Order：层数从低到高、行、列
			var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => 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) {
			info = $"在【{endAreaName}】中没有找到合适的【终点货位】，需要满足：未上锁、无货物";
			LogHelper.Info(info);
			return NewSimpleResult(4, info);
			return NewSimpleResult(3, preLog + $"没有找到合适的终点货位！要求：锁状态='无'；当前容器数量=0；所在库区={LogObject(taskInfo.EndAreas)}");
			}

			LocationHelper.LockStartLoc(ref startLoc);
			LocationHelper.LockEndLoc(ref endLoc);
			var cntId = locCntrRel.S_CNTR_CODE; // 容器号
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
			// 起点终点上锁，创建任务
			WCSHelper.LockStartLoc(ref startLoc);
			WCSHelper.LockEndLoc(ref endLoc);
			var task = WCSHelper.BuildTask(startLoc, endLoc, locCntrRel.S_CNTR_CODE, taskInfo.TaskName);

			using (var tran = db.Ado.UseTran()) {
			if (cgDetailOld != null) {
			if (db.Deleteable<TN_CG_Detail>(cgDetailOld).ExecuteCommand() <= 0) {
			info = $"删除【旧物料信息】失败：" + JsonConvert.SerializeObject(cgDetailOld);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			}
			if (cgDetailOld != null && db.Deleteable<TN_CG_Detail>(cgDetailOld).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			return NewSimpleResult(500, preLog + $"删除[旧物料信息]失败！数据：{LogObject(cgDetailOld)}");
			}

			if (locCntrRelOld != null) {
			if (db.Deleteable<TN_Loc_Container>(locCntrRelOld).ExecuteCommand() <= 0) {
			info = $"删除【旧货位容器关系】失败：" + JsonConvert.SerializeObject(locCntrRelOld);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			}
			if (locCntrRelOld != null && db.Deleteable<TN_Loc_Container>(locCntrRelOld).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			return NewSimpleResult(500, preLog + $"删除[旧货位容器关系]失败！数据：{LogObject(locCntrRelOld)}");
			}

			if (locOld != null) {
			if (db.Updateable<TN_Location>(locOld).UpdateColumns(l => new { l.N_CURRENT_NUM, l.T_MODIFY }).ExecuteCommand() <= 0) {
			info = $"更新旧货位【容器数量】失败：" + JsonConvert.SerializeObject(locOld);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			}
			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, preLog + $"更新[旧货位\|当前容器数量]失败！货位='{locOld.S_CODE}'，数量=>{locOld.N_CURRENT_NUM}");
			}

			if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) {
			info = $"插入【货位容器关系】失败：" + JsonConvert.SerializeObject(locCntrRel);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			return NewSimpleResult(500, preLog + $"插入[货位容器绑定表]失败！数据：{LogObject(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) {
			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();
			info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[终点货位锁状态]失败！终点='{endLoc.S_CODE}'，锁状态=>'入库锁'");
			}

			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);
			return NewSimpleResult(500, preLog + $"生成任务'{task.S_TYPE}'失败！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}

			tran.CommitTran();
			info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + $"生成任务'{task.S_TYPE}'成功！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(-1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			/// <summary>
			/// 好运箱-空箱入库(PDA)
			/// 空箱入库
			/// </summary>
			/// <remarks>
			/// 人工：空箱==搬运==>入库接驳位，需要新绑定容器货位<br/>
			/// 由于空箱一般是出库卸货后获得，而出库时没有手动卸货的逻辑，所以需要在入库的时候再删除旧绑定信息
			/// </remarks>
			/// <returns></returns>
			public static SimpleResult EmptyInboundGoodpack(EmptyInboundInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.H好运箱_空箱入库;
			const string startAreaName = AreaName.K空箱入库接驳区;
			const string endAreaName = AreaName.K空箱货架区;
			var taskInfo = ETask.K空箱入库.Info();
			const string preLog = "API：空箱入库：";
			const string cntrType = "好运箱";

			try {
			var startLoc = db.Queryable<TN_Location>()
			.Where(l => l.S_CODE == model.StartLoc)
			.Where(l => Settings.AreaMap[startAreaName].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();

			// 查询起点货位：数量=0
			var startLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => l.S_CODE == model.StartLoc && taskInfo.StartAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).First();
			if (startLoc == null) {
			info = $"在'{startAreaName}'中没有找到起点货位'{model.StartLoc}'，或不满足要求：未上锁、当前容器数量=0";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			return NewSimpleResult(1, preLog + $"没有找到起点货位'{model.StartLoc}'！要求：锁状态='无'；当前容器数量=0；所在库区={LogObject(taskInfo.StartAreas)}");
			}

			var cntr = db.Queryable<TN_Container>()
			.Where(c => c.S_CODE == model.CntrCode) // 对于前台程序而言，S_CODE就是主键，维护时必定唯一
			.First();

			// 查询容器表：容器类型字段
			var cntr = db.Queryable<TN_Container>().Where(c => c.S_CODE == model.CntrCode).First();
			if (cntr == null) {
			info = $"容器'{model.CntrCode}'在容器表中不存在，请在前台页面中维护！";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			return NewSimpleResult(2, preLog + $"容器'{model.CntrCode}'在[容器表]中不存在，请在前台页面中维护！");
			}
			if (cntr.S_TYPE != cntrType) {
			info = $"容器'{model.CntrCode}'在容器表中的类型为'{cntr.S_TYPE}'，与输入的容器类型'{cntrType}'不同！";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			return NewSimpleResult(3, preLog + $"容器'{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();

			// 空箱入库时，如果存在旧的绑定数据，删除
			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 (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;
			}
			}

			// 绑定货位和容器号
			var locCntrRel = new TN_Loc_Container {
			S_LOC_CODE = startLoc.S_CODE,
			S_CNTR_CODE = cntr.S_CODE,
			S_CNTR_TYPE = cntrType,
			};
			// 绑定货位容器，起点货位当前数量=1
			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;

			startLoc.N_CURRENT_NUM = 1; // 绑定后

			var endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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)
			.OrderBy(l => new { l.N_LAYER }) // TODO 暂定选择最低层顺序入库，后面待修改
			.First();

			// 查询终点货位
			// Order：层数从低到高、行、列
			var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => 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) {
			info = $"在'{endAreaName}'中没有找到合适的终点货位，需要满足：未上锁、无货物";
			LogHelper.Info(info);
			return NewSimpleResult(4, info);
			return NewSimpleResult(3, preLog + $"没有找到合适的终点货位！要求：锁状态='无'；当前容器数量=0；所在库区={LogObject(taskInfo.EndAreas)}");
			}

			var cntId = locCntrRel.S_CNTR_CODE;

			LocationHelper.LockStartLoc(ref startLoc);
			LocationHelper.LockEndLoc(ref endLoc);
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
			WCSHelper.LockStartLoc(ref startLoc);
			WCSHelper.LockEndLoc(ref endLoc);
			var task = WCSHelper.BuildTask(startLoc, endLoc, locCntrRel.S_CNTR_CODE, taskInfo.TaskName);

			using (var tran = db.Ado.UseTran()) {
			// 存在旧【物料明细】表时，删除旧表
			if (cgDetailOld != null) {
			if (db.Deleteable<TN_CG_Detail>(cgDetailOld).ExecuteCommand() <= 0) {
			info = $"删除【旧物料信息】失败：" + JsonConvert.SerializeObject(cgDetailOld);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			}
			}
			// 存在旧【货位容器绑定】表时，删除旧表
			if (locCntrRelOld != null) {
			if (db.Deleteable<TN_Loc_Container>(locCntrRelOld).ExecuteCommand() <= 0) {
			info = $"删除【旧货位容器关系】失败：" + JsonConvert.SerializeObject(locCntrRelOld);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			}
			if (cgDetailOld != null && db.Deleteable<TN_CG_Detail>(cgDetailOld).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			return NewSimpleResult(500, preLog + $"删除[旧物料信息]失败！数据：{LogObject(cgDetailOld)}");
			}

			if (locOld != null) {
			if (db.Updateable<TN_Location>(locOld).UpdateColumns(l => l.N_CURRENT_NUM).ExecuteCommand() <= 0) {
			info = $"更新旧货位【容器数量】失败：" + JsonConvert.SerializeObject(locOld);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			}
			if (locCntrRelOld != null && db.Deleteable<TN_Loc_Container>(locCntrRelOld).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			return NewSimpleResult(500, preLog + $"删除[旧货位容器关系]失败！" + LogObject(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, preLog + $"更新[旧货位\|容器数量]失败！" + LogObject(locOld));
			}

			if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) {
			info = $"插入【货位容器关系】失败：" + JsonConvert.SerializeObject(locCntrRel);
			tran.RollbackTran();
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			return NewSimpleResult(500, preLog + $"插入[货位容器关系]失败：" + LogObject(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) {
			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();
			info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[终点货位锁状态]失败！终点='{endLoc.S_CODE}'，锁状态=>'入库锁'");
			}

			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);
			return NewSimpleResult(500, preLog + $"生成任务'{task.S_TYPE}'失败！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}

			tran.CommitTran();
			info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + $"生成任务'{task.S_TYPE}'成功！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(-1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			/// <summary>
			/// 托盘-空托上线(PDA)
			/// 空托上线出库
			/// </summary>
			/// <remarks>
			/// 人工根据当前生产物料所需的容器类型，呼叫AGV从空容器货架中叫一个符合要求的托盘
			/// </remarks>
			/// <param name="model">包含：容器号、物料编码</param>
			/// <param name="model"></param>
			/// <returns></returns>
			public static SimpleResult EmptyOnlinePallet(EmptyOnlinePalletInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.T托盘_空托上线;
			const string startAreaName = AreaName.K空托存放区;
			const string endAreaName = AreaName.B包装区;
			var taskInfo = ETask.K空托上线出库.Info();
			const string preLog = "API：空托上线出库：";
			const string cntrType = "托盘";

			try {
			var cntr = db.Queryable<TN_Container>()
			.Where(c => c.S_CODE == model.CntId)
			.First();

			// 查询容器表：容器类型字段
			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);
			return NewSimpleResult(1, $"容器'{model.CntId}'在[容器表]中不存在，请在前台页面中维护！");
			}
			if (cntr.S_TYPE != cntrType) { // 容器类型默认不会为空
			info = $"容器'{model.CntId}'在容器表中的类型是'{cntr.S_TYPE}，不是'{cntrType}'！";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			if (cntr.S_TYPE != cntrType) {
			return NewSimpleResult(2, preLog + $"容器'{model.CntId}'在[容器表]中的类型是'{cntr.S_TYPE}，不是'{cntrType}'！");
			}

			var needUpdateContainer = false;
			@@ -530,119 +330,69 @@
			// 待定：后面可能会更改流程，或者用其他信息（如物料类型/规格）作为容器的规格

			needUpdateContainer = true;
			info = $"容器'{model.CntId}'在容器表中规格（物料编码）为空，将物料编码'{model.ItemCode}'写入容器的规格";
			LogHelper.Info(info);

			cntr.S_SPEC = model.ItemCode;
			LogHelper.Info($"容器'{model.CntId}'在[容器表]中[规格(物料编码)]为空，将物料编码'{model.ItemCode}'写入容器的规格");
			}
			else if (cntr.S_SPEC != model.ItemCode) {
			info = $"容器'{model.CntId}'已经与物料类型'{cntr.S_SPEC}'绑定，无法用于装载物料'{model.ItemCode}'";
			LogHelper.Info(info);
			return NewSimpleResult(3, info);
			return NewSimpleResult(3, $"容器'{model.CntId}'已经与物料类型'{cntr.S_SPEC}'绑定，无法用于装载物料'{model.ItemCode}'！");
			}

			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 => Settings.AreaMap[startAreaName].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();

			var startLoc = db.Queryable<TN_Location>().LeftJoin<TN_Loc_Container>((l, c) => l.S_CODE == c.S_LOC_CODE).Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where((l, c) => taskInfo.StartAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 1 && c.S_CNTR_CODE == model.CntId && c.S_CNTR_TYPE == cntrType).First();
			if (startLoc == null) {
			info = $"在'{startAreaName}'中，找不到适用于{model.ItemCode}物料、且编码为{model.CntId}的空托盘";
			LogHelper.Info(info);
			return NewSimpleResult(3, info);
			return NewSimpleResult(3, preLog + $"没有找到合适的起点货位！要求：锁状态='无'；当前容器数量=1；所在库区={LogObject(taskInfo.StartAreas)}，绑定容器编码='{model.CntId}'，绑定容器类型='{cntrType}'");
			}

			var endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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();

			// 查询终点货位
			var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => taskInfo.EndAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).First();
			if (endLoc == null) {
			info = $"在'{endAreaName}'中，找不到合适的【终点货位】，需要满足：未上锁、当前容器数量=0";
			LogHelper.Info(info);
			return NewSimpleResult(4, info);
			return NewSimpleResult(5, preLog + $"没有找到合适的终点货位！要求：锁状态='无'；当前容器数量=0；所在库区={LogObject(taskInfo.EndAreas)}");
			}

			var cntId = model.CntId;

			LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
			LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
			WCSHelper.LockStartLoc(ref startLoc);
			WCSHelper.LockEndLoc(ref endLoc);
			var task = WCSHelper.BuildTask(startLoc, endLoc, model.CntId, taskInfo.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 (needUpdateContainer && db.Updateable<TN_Container>(cntr).UpdateColumns(c => new { c.S_SPEC, c.S_SOURCE, c.T_MODIFY }).ExecuteCommand() <= 0) {
			return NewSimpleResult(500, preLog + $"更新[容器表]失败！数据：{LogObject(cntr)}");
			}

			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) {
			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();
			info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[终点货位锁状态]失败！终点='{endLoc.S_CODE}'，锁状态=>'入库锁'");
			}

			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);
			return NewSimpleResult(500, preLog + $"生成任务'{task.S_TYPE}'失败！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}

			tran.CommitTran();
			info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + $"生成任务'{task.S_TYPE}'成功！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(-1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			/// <summary>
			/// 好运箱-空箱上线(PDA)
			/// 空箱上线出库
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public static SimpleResult EmptyOnlineGoodpack(EmptyOnlineGoodpackInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.H好运箱_空箱上线;
			const string startAreaName = AreaName.K空箱货架区;
			const string endAreaName = AreaName.K空箱操作区;
			var taskInfo = ETask.K空箱上线出库.Info();
			const string preLog = "API：空箱上线出库：";
			const string cntrType = "好运箱";

			try {
			@@ -651,166 +401,86 @@
			.First();

			if (cntr == null) {
			info = $"容器'{model.CntId}'在【容器表】中不存在，请在前台页面中维护！";
			LogHelper.Info(info);
			return NewSimpleResult(1, info);
			return NewSimpleResult(1, preLog + $"容器'{model.CntId}'在[容器表]中不存在，请在前台页面中维护！");
			}
			if (cntr.S_TYPE != cntrType) {
			info = $"容器'{model.CntId}'在【容器表】中的类型={cntr.S_TYPE}，不是'{cntrType}'！";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			return NewSimpleResult(2, preLog + $"容器'{model.CntId}'在[容器表]中的类型='{cntr.S_TYPE}'，不是'{cntrType}'！");
			}

			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 => Settings.AreaMap[startAreaName].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();

			var startLoc = db.Queryable<TN_Location>().LeftJoin<TN_Loc_Container>((l, c) => l.S_CODE == c.S_LOC_CODE).Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where((l, c) => taskInfo.StartAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 1 && c.S_CNTR_CODE == model.CntId && c.S_CNTR_TYPE == cntrType).First();
			if (startLoc == null) {
			info = $"在'{startAreaName}'中，找不到存放容器编码={model.CntId}的空好运箱的【起点货位】，或不满足：未上锁、当前数量=1";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			return NewSimpleResult(2, preLog + $"没有找到合适的起点货位！要求：锁状态='无'，当前容器数量=1，所在库区={LogObject(taskInfo.StartAreas)}，绑定容器编码='{model.CntId}'，绑定容器类型='{cntrType}'");
			}

			var endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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();

			var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
			.Where(l => taskInfo.EndAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).First();
			if (endLoc == null) {
			info = $"在'{endAreaName}'中，找不到合适的【终点货位】，需要满足：未上锁、当前数量=0";
			LogHelper.Info(info);
			return NewSimpleResult(4, info);
			return NewSimpleResult(3, preLog + $"没有找到合适的终点货位！要求：锁状态='无'，当前容器数量=0，所在库区={LogObject(taskInfo.EndAreas)}");
			}

			var cntId = model.CntId;
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);

			LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
			LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
			WCSHelper.LockStartLoc(ref startLoc);
			WCSHelper.LockEndLoc(ref endLoc);
			var task = WCSHelper.BuildTask(startLoc, endLoc, model.CntId, taskInfo.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) {
			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();
			info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[终点货位锁状态]失败！终点='{endLoc.S_CODE}'，锁状态=>'入库锁'");
			}

			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);
			return NewSimpleResult(500, preLog + $"生成任务'{task.S_TYPE}'失败！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}

			tran.CommitTran();
			info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + $"生成任务'{task.S_TYPE}'成功！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(-1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}


			/// <summary>
			/// 抽检-合格回库(PDA)
			/// 抽检合格回库
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public static SimpleResult QualifiedBack(QualifiedBackInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.C抽检_合格回库;
			const string startAreaName = AreaName.C抽检区;
			var endAreaName = "";
			var taskInfo = ETask.C抽检合格回库.Info();
			const string preLog = "API：抽检合格回库";

			try {
			var cgDetail = db.Queryable<TN_CG_Detail>()
			.Where(d => d.S_ITEM_CODE == model.ItemCode && d.S_CNTR_CODE == model.CntrCode)
			.First();

			.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);
			return NewSimpleResult(2, preLog + "没有找到待回库的抽检物料：" + LogObject(model));
			}

			var locCntrRel = db.Queryable<TN_Loc_Container>()
			.Where(c => c.S_CNTR_CODE == cgDetail.S_CNTR_CODE)
			.First();

			.Where(c => c.S_CNTR_CODE == cgDetail.S_CNTR_CODE).First();
			if (locCntrRel == null) {
			info = $"容器{model.CntrCode}在货位容器关系表中不存在";
			LogHelper.Info(info);
			return NewSimpleResult(3, info);
			return NewSimpleResult(3, preLog + $"容器{model.CntrCode}在货位容器关系表中不存在");
			}

			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 => Settings.AreaMap[startAreaName].Contains(l.S_AREA_CODE)) // 起点货区符合任务要求
			.First();

			.Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => l.S_CODE == locCntrRel.S_LOC_CODE && taskInfo.StartAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 1).First();
			if (startLoc == null) {
			info = $"在'{startAreaName}'中没有找到容器{model.CntrCode}的起点货位，或不具备取货要求：未上锁、有货物";
			LogHelper.Info(info);
			return NewSimpleResult(4, info);
			return NewSimpleResult(4, preLog + $"没有找到合适的起点货位！要求：锁状态='无'，当前容器数量=1，所在库区={LogObject(taskInfo.StartAreas)}");
			}

			TN_Location endLoc = null;
			if (locCntrRel.S_CNTR_TYPE == "托盘") {
			endAreaName = AreaName.M满托货架区;
			endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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 == "好运箱") {
			endAreaName = AreaName.M满箱货架区;
			endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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}");
			}

			var endAreas = locCntrRel.S_CNTR_CODE == "托盘" ? taskInfo.EndAreas_Pallet : taskInfo.EndAreas_Goodpack;
			var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
			.Where(l => endAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).First();
			if (endLoc == null) {
			info = $"在【{endAreaName}】中没有找到合适的【终点货位】，或不满足要求：未上锁、当前容器数量为 0";
			LogHelper.Info(info);
			return NewSimpleResult(3, info);
			return NewSimpleResult(3, preLog + $"没有找到合适的终点货位！要求：锁状态='无'，当前容器数量=0，所在库区={LogObject(endAreas)}");
			}

			cgDetail.N_ITEM_STATE = 0;
			@@ -818,315 +488,190 @@
			cgDetail.T_MODIFY = DateTime.Now;

			var cntId = locCntrRel.S_CNTR_CODE;
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskInfo.TaskName);

			LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
			LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
			WCSHelper.LockStartLoc(ref startLoc);
			WCSHelper.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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[物料明细表]失败！物料号='{cgDetail.S_ITEM_CODE}'，物料状态=>'合格'");
			}

			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) {
			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();
			info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[终点货位锁状态]失败！终点='{endLoc.S_CODE}'，锁状态=>'入库锁'");
			}

			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);
			return NewSimpleResult(500, preLog + $"生成任务'{task.S_TYPE}'失败！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}

			tran.CommitTran();
			info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + $"生成任务'{task.S_TYPE}'成功！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(-1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			/// <summary>
			/// 抽检-不合格移库(PDA)
			/// 抽检不合格移库
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public static SimpleResult UnqualifiedShift(UnqualifiedShiftInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.C抽检_不合格移库;
			const string startAreaName = AreaName.C抽检区;
			const string endAreaName = AreaName.C抽检异常区;
			var taskInfo = ETask.C抽检不合格移库.Info();
			const string preLog = "API：抽检不合格移库：";

			try {

			if (!Settings.AreaMap[endAreaName].Contains(model.EndArea)) {
			info = $"输入的终点库区'{model.EndArea}'不属于'{endAreaName}'!";
			LogHelper.Info(info);
			return NewSimpleResult(1, info);
			if (!taskInfo.EndAreas.Contains(model.EndArea)) {
			return NewSimpleResult(1, preLog + $"终点库区'{model.EndArea}'不满足条件！需要：货区={LogObject(taskInfo.EndAreas)}");
			}

			var cgDetail = db.Queryable<TN_CG_Detail>()
			.Where(d => d.S_ITEM_CODE == model.ItemCode && d.S_CNTR_CODE == model.CntrCode)
			.First();

			.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);
			return NewSimpleResult(2, preLog + $"没有在[物料明细表]中找到物料！要求：物料编码='{model.ItemCode}'，容器编码='{model.CntrCode}'");
			}

			var locCntrRel = db.Queryable<TN_Loc_Container>()
			.Where(c => c.S_CNTR_CODE == cgDetail.S_CNTR_CODE)
			.First();

			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);
			return NewSimpleResult(3, preLog + $"在[货位容器关系表]中没有找到容器'{model.CntrCode}'！");
			}

			var startLoc = db.Queryable<TN_Location>()
			.Where(l => l.S_CODE == locCntrRel.S_LOC_CODE)
			.Where(l => Settings.AreaMap[startAreaName].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();

			// 查询起点货位：数量=1
			var startLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y").Where(l => l.S_CODE == locCntrRel.S_LOC_CODE && taskInfo.StartAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 1).First();
			if (startLoc == null) {
			info = $"在'{startAreaName}'中没有找到起点货位'{locCntrRel.S_LOC_CODE}'，或不满足要求：未上锁、当前容器数量=0";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			return NewSimpleResult(1, preLog + $"没有找到起点货位'{locCntrRel.S_LOC_CODE}'！要求：锁状态='无'；当前容器数量=1；所在库区={LogObject(taskInfo.StartAreas)}");
			}

			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();

			var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
			.Where(l => l.S_AREA_CODE == model.EndArea && l.N_CURRENT_NUM == 0).First();
			if (endLoc == null) {
			info = $"在终点货区'{model.EndArea}'中，没有找到合适的【终点货位】，需要满足要求：未上锁、当前容器数量=0";
			LogHelper.Info(info);
			return NewSimpleResult(3, info);
			return NewSimpleResult(3, preLog + $"没有找到合适的终点货位！要求：锁状态='无'，当前容器数量=0，所在库区='{model.EndArea}'");
			}

			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); // 终点入库锁
			WCSHelper.LockStartLoc(ref startLoc);
			WCSHelper.LockEndLoc(ref endLoc);
			var task = WCSHelper.BuildTask(startLoc, endLoc, locCntrRel.S_CNTR_CODE, taskInfo.TaskName);

			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[货品明细表]失败！物料号='{cgDetail}'，物料状态=>'{cgDetail.S_ITEM_STATE}'");
			}

			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) {
			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();
			info = $"生成任务'{taskName}'失败：更新起点货位'{startLoc.S_CODE}'锁状态失败";
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[终点货位锁状态]失败！终点='{endLoc.S_CODE}'，锁状态=>'入库锁'");
			}

			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);
			return NewSimpleResult(500, preLog + $"生成任务'{task.S_TYPE}'失败！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}

			tran.CommitTran();
			info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + $"生成任务'{task.S_TYPE}'成功！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(-1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			/// <summary>
			/// 余料回库/尾箱回库(PDA)
			/// 尾料回库/余料回库
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public static SimpleResult RestBack(RestBackInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.W尾箱回库;
			var endAreaName = "";
			var taskInfo = ETask.W尾料回库.Info();
			const string preLog = "API：尾料回库：";

			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();

			var startLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
			.Where(l => l.S_CODE == model.StartLoc && l.N_CURRENT_NUM == 1).First();
			if (startLoc == null) {
			info = $"没有找到起点货位{model.StartLoc}，或不具备取货要求：未上锁、有货物";
			LogHelper.Info(info);
			return NewSimpleResult(2, info);
			return NewSimpleResult(2, $"没有找到起点货位'{model.StartLoc}'！要求：锁状态='无'；当前容器数量=1");
			}

			var locCntrRel = db.Queryable<TN_Loc_Container>()
			.Where(c => c.S_LOC_CODE == model.StartLoc)
			.First();

			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);
			return NewSimpleResult(3, preLog + $"没有找到起点货位{model.StartLoc}所绑定的容器");
			}

			TN_Location endLoc = null;
			if (locCntrRel.S_CNTR_TYPE == "托盘") {
			endAreaName = AreaName.M满托货架区;
			endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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 == "好运箱"){
			endAreaName = AreaName.M满箱货架区;
			endLoc = db.Queryable<TN_Location>()
			.Where(l => Settings.AreaMap[endAreaName].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();
			}

			var endAreas = locCntrRel.S_CNTR_CODE == "托盘" ? taskInfo.EndAreas_Pallet : taskInfo.EndAreas_Goodpack;
			var endLoc = db.Queryable<TN_Location>().Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y")
			.Where(l => endAreas.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM == 0).First();
			if (endLoc == null) {
			info = "查询：没有找到合适的终点货位";
			LogHelper.Info(info);
			return NewSimpleResult(3, info);
			return NewSimpleResult(3, preLog + $"没有找到合适的终点货位！要求：锁状态='无'，当前容器数量=0，所在库区={LogObject(endAreas)}");
			}

			var cntId = locCntrRel.S_CNTR_CODE;

			LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁
			LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName);
			WCSHelper.LockStartLoc(ref startLoc);
			WCSHelper.LockEndLoc(ref endLoc);
			var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskInfo.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) {
			//if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) {
			// tran.RollbackTran();
			// return NewSimpleResult(500, preLog + $"插入[容器货位绑定表]失败！数据：{LogObject(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();
			info = $"生成任务'{taskName}'失败：更新起点货位{startLoc.S_CODE}锁状态失败";
			LogHelper.Info(info);
			return NewSimpleResult(500, info);
			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) {
			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);
			return NewSimpleResult(500, preLog + $"更新[终点货位锁状态]失败！终点='{endLoc.S_CODE}'，锁状态=>'入库锁'");
			}

			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);
			return NewSimpleResult(500, preLog + $"生成任务'{task.S_TYPE}'失败！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}

			tran.CommitTran();
			info = $"生成任务'{taskName}'成功，任务号={task.S_CODE}，容器号={cntId}，起点={startLoc.S_CODE}，终点={endLoc.S_CODE}";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + $"生成任务'{task.S_TYPE}'成功！任务号={task.S_CODE}，容器号={task.S_CNTR_CODE}，起点={task.S_START_LOC}，终点={task.S_END_LOC}");
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(-1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			/// <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 = "";

			const string taskName = TaskName.C成品胶出库;
			var taskInfo = ETask.C成品胶出库.Info();
			const string preLog = "API：成品胶出库：";

			try {
			var orderNo = GenerateOrderNo("出库单号", "CKD");
			@@ -1134,9 +679,7 @@
			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);
			return NewSimpleResult(3, preLog + $"没有合适的物料可以出库");
			}

			var order = new TN_Outbound_Order {
			@@ -1163,29 +706,21 @@
			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);
			return NewSimpleResult(2, preLog + "生成出库单失败：" + LogObject(order));
			}

			if (db.Insertable<TN_Outbound_Detail>(detailList).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			info = "生成出库单明细失败";
			LogHelper.Info(info);
			return NewSimpleResult(4, info);
			return NewSimpleResult(4, preLog + "生成出库单明细失败：" + LogObject(detailList));
			}

			tran.CommitTran();
			}

			info = "生成出库单成功";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + "生成出库单成功");
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			@@ -1195,9 +730,8 @@
			/// <returns></returns>
			public static SimpleResult FinishedOutboundForce(FinishedOutboundInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";

			const string taskName = TaskName.C成品胶出库;
			var taskInfo = ETask.C成品胶出库.Info();
			const string preLog = "API：成品胶出库：";

			try {
			var orderNo = GenerateOrderNo("出库单号", "CKD");
			@@ -1205,9 +739,7 @@
			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);
			return NewSimpleResult(3, preLog + $"没有合适的物料可以出库");
			}

			var order = new TN_Outbound_Order {
			@@ -1234,29 +766,21 @@
			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);
			return NewSimpleResult(2, preLog + "生成出库单失败：" + LogObject(order));
			}

			if (db.Insertable<TN_Outbound_Detail>(detailList).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			info = "生成出库单明细失败";
			LogHelper.Info(info);
			return NewSimpleResult(4, info);
			return NewSimpleResult(4, preLog + "生成出库单明细失败：" + LogObject(detailList));
			}

			tran.CommitTran();
			}

			info = "生成出库单成功";
			LogHelper.Info(info);
			return NewSimpleResult(0, info);
			return NewSimpleResult(0, preLog + "生成出库单成功");
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewSimpleResult(1, info);
			return NewSimpleResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			@@ -1264,7 +788,6 @@
			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)
			@@ -1328,7 +851,6 @@
			}
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return result;
			}
			@@ -1337,7 +859,7 @@
			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')}";
			return $"{prefix}{date}-{id.ToString().PadLeft(4, '0')}";
			}

			/// <summary>
			@@ -1347,28 +869,21 @@
			/// <returns></returns>
			public static MesResult CgInfoSync(CgInfoSyncInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var info = "";
			const string preLog = "API：博实下发物料信息：";
			const string cntrType = "好运箱";

			try {
			if (string.IsNullOrEmpty(model.ItemCode)) {
			info = $"博实下发物料信息：参数不合法：物料编码（itemCode）不能为空";
			LogHelper.Info(info);
			return NewMesResult(400, info);
			return NewMesResult(400, preLog + $"物料编码'{model.ItemCode}'不能为空！");
			}
			if (string.IsNullOrEmpty(model.CntrCode)) {
			info = $"博实下发物料信息：参数不合法：容器编码（CntrCode）不能为空";
			LogHelper.Info(info);
			return NewMesResult(400, info);
			return NewMesResult(400, preLog + $"容器编码'{model.CntrCode}'不能为空！");
			}
			if (string.IsNullOrEmpty(model.BatchNo)) {
			info = $"博实下发物料信息：参数不合法：批次号（BatchNo）不能为空";
			LogHelper.Info(info);
			return NewMesResult(400, info);
			return NewMesResult(400, preLog + $"批次号'{model.BatchNo}'不能为空！");
			}
			if (model.ItemNum <= 0) {
			info = $"博实下发物料信息：参数不合法：货品数量（ItemNum）应该大于 0";
			LogHelper.Info(info);
			return NewMesResult(400, info);
			return NewMesResult(400, preLog + $"物料数量'{model.ItemNum}'不合法！要求：物料数量＞0");
			}

			// TEMP 目前流程：对博实下发的信息也进行检查，未找到就报错，后面有需求再更改
			@@ -1377,14 +892,10 @@
			.First();

			if (cntr == null) {
			info = $"容器'{model.CntrCode}'在容器表中不存在，请在前台页面中维护！";
			LogHelper.Info(info);
			return NewMesResult(1, info);
			return NewMesResult(1, preLog + $"容器'{model.CntrCode}'在[容器表]中不存在，请在前台页面中维护！");
			}
			if (cntr.S_TYPE != "好运箱") {
			info = $"容器'{model.CntrCode}'在容器表中的类型为'{cntr.S_TYPE}'，与当前容器类型'好运箱'不同！";
			LogHelper.Info(info);
			return NewMesResult(2, info);
			if (cntr.S_TYPE != cntrType) {
			return NewMesResult(2, preLog + $"容器'{model.CntrCode}'在[容器表]中的类型为'{cntr.S_TYPE}'，与当前容器类型'{cntrType}'不同！");
			}

			// 将下发的信息先存储到CG表中（此时托盘没有与产线处的货位绑定）
			@@ -1411,41 +922,35 @@
			// 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();
			if (db.Insertable<TN_CG_Detail>(detail).ExecuteCommand() <= 0) {
			return NewMesResult(500, preLog + $"插入[物料明细表]失败！数据：{LogObject(detail)}");
			}

			info = "插入物料信息成功";
			return NewMesResult(0, info);
			return NewMesResult(500, preLog + $"插入[物料明细表]成功！数据：{LogObject(detail)}");
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewMesResult(-1, info);
			return NewMesResult(-1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			public static ErpResult ErpSendOutboundPlan(ErpSendOutboundPlanInfo model) {
			var db = new SqlHelper<object>().GetInstance();
			var orderNo = GenerateOrderNo("出库单号", "CKD");
			var info = "";
			const string preLog = "API：ERP下发出库计划单：";
			try {
			// 参数合法性确认部分：错误编码：400
			if (model.pzsl <= 0) {
			info = $"物料数量(pzsl){model.pzsl}不合法：物料数量应该大于 0";
			LogHelper.Info(info);
			return NewErpResult(400, info);
			if (model.pzjs <= 0) {
			return NewErpResult(400, preLog + $"物料数量(pzjs)'{model.pzjs}'不合法！要求：物料数量＞0");
			}

			var outboundPlan = new TN_Outbound_Plan {
			var outboundPlan = db.Queryable<TN_Outbound_Plan>()
			.Where(p => p.JHDH == model.jhdh).First();
			if (outboundPlan != null) {
			return NewErpResult(1, preLog + $"计划单号'{model.jhdh}'已在[出库计划单]中存在！");
			}

			outboundPlan = new TN_Outbound_Plan {
			JHDH = model.jhdh, // 计划单号（唯一标识）
			CKZT = model.ckzt, // 出库状态
			CKZT = model.ckzt, // 出库状态（需要返回）
			JHLB = model.jhlb, // 计划类别
			CKDH = model.ckdh, // 参考单号
			CPH = model.cph, // 车牌号
			@@ -1456,9 +961,9 @@
			CPLB = model.cplb, // 产品类别
			CPLBMX = model.cplbmx, // 产品类别明细
			PP = model.pp, // 品牌
			DJ = model.dj, // 等级
			DJ = model.dj, // 等级（需要返回）
			GH = model.gh, // 罐号
			PH = model.ph, // 批号
			PH = model.ph, // 批号（需要返回）
			BZLX = model.bzlx, // 包装类型
			PZDH = model.pzdh, // 派装单号
			PZD_DW = model.pzd_dw, // 派装单单位
			@@ -1471,15 +976,15 @@
			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, // 操作员
			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, // 作废标记
			@@ -1488,88 +993,100 @@
			SHDW = model.shdw, // 收货单位
			YSDW = model.ysdw, // 运输单位
			LXR = model.lxr, // 联系人
			RY_ZXG = model.ry_zxg, // 装卸工
			RY_CCSJ = model.ry_ccsj, // 叉车司机
			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 // 货位状态
			HW = model.hw, // 货位（需要返回）
			HWZT = model.hwzt // 货位状态（需要返回）
			};

			var cgDetailList = SelectCgByTotalQty(
			qty: (int)model.pzsl,
			itemCode: model.cpdm,
			batchNo: model.ph
			);
			//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);
			//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 ) {
			return NewErpResult(2, preLog + $"在[货品明细表]中没有找到合适的物料！要求：物料编码='{model.cpdm}'，物料数量>={model.pzjs}");
			}

			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 = model.ph,
			N_END_NUM = (int)model.pzsl,
			//F_OUT_QTY = cgDetailList.Sum(a => a.N_QTY),
			S_END_AREA = model.ysfs == "汽车" ? "QCCKQ" : "HCCKQ", // 暂时用运输方式（火车/汽车）来区分终点货区
			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);
			}
			//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);
			return NewErpResult(500, preLog + $"生成[出库单]失败！数据：{LogObject(order)}");
			}

			if (db.Insertable<TN_Outbound_Detail>(detailList).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			info = "生成出库单明细失败";
			LogHelper.Info(info);
			return NewErpResult(500, info);
			return NewErpResult(500, preLog + $"生成[出库单明细]失败！数据：{LogObject(detailList)}");
			}

			if (db.Insertable<TN_Outbound_Plan>(outboundPlan).ExecuteCommand() <= 0) {
			tran.RollbackTran();
			info = "生成出库单计划记录表失败";
			LogHelper.Info(info);
			return NewErpResult(500, info);
			return NewErpResult(500, preLog + $"生成[出库单计划记录表]失败！数据：{LogObject(outboundPlan)}");
			}

			tran.CommitTran();
			return NewErpResult(0, preLog + $"生成[出库单]成功！出库单：{LogObject(order)}\n出库单明细：{LogObject(detail)}");
			}

			info = $"生成出库单成功";
			LogHelper.Info(info);
			return NewErpResult(0, info);
			}
			catch (Exception ex) {
			info = $"发生了异常：{ex.Message}";
			LogHelper.InfoEx(ex);
			return NewErpResult(1, info);
			return NewErpResult(1, preLog + $"发生了异常：{ex.Message}\n{ex.StackTrace}");
			}
			}

			private static string LogObject(object obj) {
			return JsonConvert.SerializeObject(obj).Replace("\"", "'");
			}
			}
			}