博实物料下发同步接口开发，满箱入库、出库逻辑测试与优化

kazelee

2025-05-16 6abc355aeb4e6f7960c11795dbbcc26396b0c888

 Services/MoboxService.cs

@@ -1,57 +1,21 @@
using System;
using System.Collections.Generic;
using System.Linq;

using HH.WCS.Mobox3.DSZSH.Consts;
using HH.WCS.Mobox3.DSZSH.Helper;
using HH.WCS.Mobox3.DSZSH.Helpers;
using HH.WCS.Mobox3.DSZSH.Helpers.Model;
using HH.WCS.Mobox3.DSZSH.Models;

using Newtonsoft.Json;

using SqlSugar;

using static HH.WCS.Mobox3.DSZSH.Dtos.Request.MoboxRequest;
using static HH.WCS.Mobox3.DSZSH.Dtos.Response.MoboxResponse;
using static HH.WCS.Mobox3.DSZSH.Helpers.ResultHelper;

namespace HH.WCS.Mobox3.DSZSH.Services {
    public class MoboxService {

        #region 模板功能
        public static SimpleResult BaseBound(StartCntEndInfo model) {
            var taskName = ""; // 用于生成任务类型、打印日志信息
            var db = DbHelper.GetDbClient();

            try {
                var startLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.StartLoc))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty.Negate()).First();

                if (startLoc == null) {
                    return BuildSimpleResult(2, $"起点位置 '{model.StartLoc}' 不存在或不具备取货要求");
                }

                var locCntrRel = db.Queryable<TN_Loc_Container>()
                    .Where(ExprHelper.LocCntrIsBind(startLoc.S_CODE, model.CntId)).First();

                if (locCntrRel == null) {
                    return BuildSimpleResult(3, $"起点位置 '{startLoc.S_CODE}' 没有绑定容器 '{model.CntId}'");
                }

                var endLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.EndLoc))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty).First();

                if (endLoc == null) {
                    return BuildSimpleResult(4, $"终点位置 '{model.EndLoc}' 不存在或不具备放货要求");
                }

                return TaskHelper.SimpleCreateTask(startLoc.S_CODE, locCntrRel.S_CNTR_CODE, endLoc.S_CODE, taskName);
            }
            catch (Exception ex) {
                return BuildSimpleEx(ex);
            }
        }
        #endregion

        #region PDA 功能
        /// <summary>
@@ -65,170 +29,185 @@
            var db = DbHelper.GetDbClient();

            try {
                // TODO 将PDA提供的物料编码与贴标机的信息比对
                // 将PDA提供的物料编码与贴标机的信息比对
                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 == "待检") // NOTE 冗余检查：物料状态应该为 1待检
                    .First();

                var startLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.StartLoc))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty.Negate()).First();

                if (startLoc == null) {
                    return BuildSimpleResult(2, $"起点位置 '{model.StartLoc}' 不存在或不具备取货要求");
                if (cgDetail == null) {
                    return BuildSimpleResult(2, $"PDA扫码物料信息与贴标机传递的信息不一致：" + JsonConvert.SerializeObject(model));
                }

                // 查看容器与起点货位是否绑定
                var locCntrRel = db.Queryable<TN_Loc_Container>().First(
                    a => a.S_LOC_CODE == model.StartLoc
                    && a.S_CNTR_CODE == model.CntId);
                if (locCntrRel == null) {
                    return BuildSimpleResult(3, $"起点位置 '{model.StartLoc}' 没有绑定容器 '{model.CntId}' ，无可出库的物料");
                var startLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.StartLoc)) // 指定：起点货位
                    .Where(ExprHelper.LocIsFree)
                    //.Where(ExprHelper.LocIsEmpty)
                    .First();

                if (startLoc == null) {
                    return BuildSimpleResult(3, $"起点位置 '{model.StartLoc}' 不存在或不具备取货要求");
                }

                // 绑定货位和容器号
                var locCntrRel = new TN_Loc_Container {
                    S_LOC_CODE = model.StartLoc,
                    S_CNTR_CODE = cgDetail.S_CNTR_CODE,
                    S_CNTR_TYPE = "好运箱",
                };

                if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) {
                    return BuildSimpleResult(4, $"插入货位容器关系失败：" + JsonConvert.SerializeObject(locCntrRel));
                }

                // TODO 满箱入库算法待优化
                var endLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocBelongsToArea(AreaName.满箱存放区))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty)
                    .OrderBy(l => l.N_LAYER)
                    .OrderBy(l => l.S_AREA_CODE).First();

                if (endLoc == null) {
                    return BuildSimpleResult(4, "满箱入库暂时没有合适的货位可以入库");
                    return BuildSimpleResult(5, "满箱入库暂时没有合适的货位可以入库");
                }

                return TaskHelper.SimpleCreateTask(startLoc.S_CODE, locCntrRel.S_CNTR_CODE, endLoc.S_CODE, taskName);
                return TaskHelper.SimpleCreateTask(startLoc.S_CODE, locCntrRel.S_CNTR_CODE, endLoc.S_CODE, taskName, failCode: 6);
            }
            catch (Exception ex) {
                return BuildSimpleResult(1, $"发生了异常：{ex.Message}");
            }
        }

        /// <summary>
        /// 空托盘绑定(PDA)
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static SimpleResult EmptyBindPallet(EmptyBindInfo model) {
            var db = DbHelper.GetDbClient();
        ///// <summary>
        ///// 空托盘绑定(PDA)
        ///// </summary>
        ///// <param name="model"></param>
        ///// <returns></returns>
        //public static SimpleResult EmptyBindPallet(EmptyBindInfo model) {
        //    var db = DbHelper.GetDbClient();

            try {
                var loc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.LocCode))
                    .Where(ExprHelper.LocBelongsToArea(AreaName.空托盘接驳区))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty).First();
        //    try {
        //        var loc = db.Queryable<TN_Location>()
        //            .Where(ExprHelper.LocCode(model.LocCode))
        //            .Where(ExprHelper.LocBelongsToArea(AreaName.空托盘接驳区))
        //            .Where(ExprHelper.LocIsFree)
        //            .Where(ExprHelper.LocIsEmpty).First();

                if (loc == null) {
                    return BuildSimpleResult(2, $"当前货位 '{model.LocCode}' 无法再绑定容器");
                }
        //        if (loc == null) {
        //            return BuildSimpleResult(2, $"当前货位 '{model.LocCode}' 无法再绑定容器");
        //        }

                var locCntrRel = db.Queryable<TN_Loc_Container>()
                    .Where(lc => lc.S_CNTR_CODE == model.LocCode).First();
        //        var locCntrRel = db.Queryable<TN_Loc_Container>()
        //            .Where(lc => lc.S_CNTR_CODE == model.LocCode).First();

                if (locCntrRel != null) {
                    return BuildSimpleResult(3, $"当前容器 '{model.CntrCode}' 已经与 '{locCntrRel.S_LOC_CODE}' 绑定");
                }
        //        if (locCntrRel != null) {
        //            return BuildSimpleResult(3, $"当前容器 '{model.CntrCode}' 已经与 '{locCntrRel.S_LOC_CODE}' 绑定");
        //        }

                loc.N_CURRENT_NUM = model.PalletCount;
        //        //loc.N_CURRENT_NUM = model.PalletCount;

                locCntrRel = new TN_Loc_Container {
                    S_LOC_CODE = model.LocCode,
                    S_CNTR_CODE = model.CntrCode
                };
        //        locCntrRel = new TN_Loc_Container {
        //            S_LOC_CODE = model.LocCode,
        //            S_CNTR_CODE = model.CntrCode
        //        };

                using (var tran = db.Ado.UseTran()) {
                    if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() > 0
                        && db.Updateable<TN_Location>(loc).UpdateColumns(it => it.N_CURRENT_NUM).ExecuteCommand() > 0) {
                        tran.CommitTran();
                        return BuildSimpleResult(0, $"绑定容器 '{model.CntrCode}' 与货位 '{model.LocCode}' 成功");
                    }
                    else {
                        tran.RollbackTran();
                        return BuildSimpleResult(4, $"绑定容器 '{model.CntrCode}' 与货位 '{model.LocCode}' 失败");
                    }
                }
            }
            catch (Exception ex) {
                return BuildSimpleEx(ex);
            }
        }
        //        using (var tran = db.Ado.UseTran()) {
        //            if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() > 0
        //                && db.Updateable<TN_Location>(loc).UpdateColumns(it => it.N_CURRENT_NUM).ExecuteCommand() > 0) {
        //                tran.CommitTran();
        //                return BuildSimpleResult(0, $"绑定容器 '{model.CntrCode}' 与货位 '{model.LocCode}' 成功");
        //            }
        //            else {
        //                tran.RollbackTran();
        //                return BuildSimpleResult(4, $"绑定容器 '{model.CntrCode}' 与货位 '{model.LocCode}' 失败");
        //            }
        //        }
        //    }
        //    catch (Exception ex) {
        //        return BuildSimpleEx(ex);
        //    }
        //}

        /// <summary>
        /// 空箱绑定(PDA)
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static SimpleResult EmptyBindGoodpack(EmptyBindInfo model) {
            var db = DbHelper.GetDbClient();
        ///// <summary>
        ///// 空箱绑定(PDA)
        ///// </summary>
        ///// <param name="model"></param>
        ///// <returns></returns>
        //public static SimpleResult EmptyBindGoodpack(EmptyBindInfo model) {
        //    var db = DbHelper.GetDbClient();

            try {
                var loc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.LocCode))
                    .Where(ExprHelper.LocBelongsToArea(AreaName.空箱接驳区))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty).First();
        //    try {
        //        var loc = db.Queryable<TN_Location>()
        //            .Where(ExprHelper.LocCode(model.LocCode))
        //            .Where(ExprHelper.LocBelongsToArea(AreaName.空箱接驳区))
        //            .Where(ExprHelper.LocIsFree)
        //            .Where(ExprHelper.LocIsEmpty).First();

                if (loc == null) {
                    return BuildSimpleResult(2, $"当前货位 '{model.LocCode}' 无法再绑定容器");
                }
        //        if (loc == null) {
        //            return BuildSimpleResult(2, $"当前货位 '{model.LocCode}' 无法再绑定容器");
        //        }

                var locCntrRel = db.Queryable<TN_Loc_Container>()
                    .Where(lc => lc.S_CNTR_CODE == model.LocCode).First();
        //        var locCntrRel = db.Queryable<TN_Loc_Container>()
        //            .Where(lc => lc.S_CNTR_CODE == model.LocCode).First();

                if (locCntrRel != null) {
                    return BuildSimpleResult(3, $"当前容器 '{model.CntrCode}' 已经与 '{locCntrRel.S_LOC_CODE}' 绑定");
                }
        //        if (locCntrRel != null) {
        //            return BuildSimpleResult(3, $"当前容器 '{model.CntrCode}' 已经与 '{locCntrRel.S_LOC_CODE}' 绑定");
        //        }

                loc.N_CURRENT_NUM = 1; // 空箱绑定时容器数必然为 1
        //        loc.N_CURRENT_NUM = 1; // 空箱绑定时容器数必然为 1

                locCntrRel = new TN_Loc_Container {
                    S_LOC_CODE = model.LocCode,
                    S_CNTR_CODE = model.CntrCode
                };
        //        locCntrRel = new TN_Loc_Container {
        //            S_LOC_CODE = model.LocCode,
        //            S_CNTR_CODE = model.CntrCode
        //        };

                using (var tran = db.Ado.UseTran()) {
                    if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() > 0
                        && db.Updateable<TN_Location>(loc).UpdateColumns(it => it.N_CURRENT_NUM).ExecuteCommand() > 0) {
                        tran.CommitTran();
                        return BuildSimpleResult(0, $"绑定容器 '{model.CntrCode}' 与货位 '{model.LocCode}' 成功");
                    }
                    else {
                        tran.RollbackTran();
                        return BuildSimpleResult(4, $"绑定容器 '{model.CntrCode}' 与货位 '{model.LocCode}' 失败");
                    }
                }

            }
            catch (Exception ex) {
                return BuildSimpleEx(ex);
            }
        }
        //        using (var tran = db.Ado.UseTran()) {
        //            if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() > 0
        //                && db.Updateable<TN_Location>(loc).UpdateColumns(it => it.N_CURRENT_NUM).ExecuteCommand() > 0) {
        //                tran.CommitTran();
        //                return BuildSimpleResult(0, $"绑定容器 '{model.CntrCode}' 与货位 '{model.LocCode}' 成功");
        //            }
        //            else {
        //                tran.RollbackTran();
        //                return BuildSimpleResult(4, $"绑定容器 '{model.CntrCode}' 与货位 '{model.LocCode}' 失败");
        //            }
        //        }
        //    }
        //    catch (Exception ex) {
        //        return BuildSimpleEx(ex);
        //    }
        //}

        /// <summary>
        /// 托盘-空托入库(PDA)
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static SimpleResult EmptyInboundPallet(EmptyInboundDetailInfo model) {
        public static SimpleResult EmptyInboundPallet(EmptyInboundInfo model) {
            var taskName = TaskName.托盘_空托入库;
            var db = DbHelper.GetDbClient();

            try {


                var startLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.StartLoc))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty.Negate()).First();
                    .Where(ExprHelper.LocIsEmpty.Negate())
                    .First();

                if (startLoc == null) {
                    return BuildSimpleResult(2, $"起点位置 '{model.StartLoc}' 不存在或不具备取货要求");
                }

                // 查看容器与起点货位是否绑定
                var locCntrRel = db.Queryable<TN_Loc_Container>().First(
                    a => a.S_LOC_CODE == model.StartLoc
                    && a.S_CNTR_CODE == model.CntId);
                var locCntrRel = db.Queryable<TN_Loc_Container>()
                    .Where(c => c.S_LOC_CODE == model.StartLoc && c.S_CNTR_CODE == model.CntrCode)
                    .First();

                if (locCntrRel == null) {
                    return BuildSimpleResult(3, $"起点位置 '{model.StartLoc}' 没有绑定容器 '{model.CntId}'");
                    return BuildSimpleResult(3, $"起点位置 '{model.StartLoc}' 没有绑定容器 '{model.CntrCode}'");
                }

                // TODO 暂定选择最低层按区位顺序入库，后面待修改
@@ -252,7 +231,7 @@
        /// 好运箱-空箱入库(PDA)
        /// </summary>
        /// <returns></returns>
        public static SimpleResult EmptyInboundGoodpack(EmptyInboundDetailInfo model) {
        public static SimpleResult EmptyInboundGoodpack(EmptyInboundInfo model) {
            var taskName = TaskName.好运箱_空箱入库;
            var db = DbHelper.GetDbClient();

@@ -267,11 +246,12 @@
                }

                // 查看容器与起点货位是否绑定
                var locCntrRel = db.Queryable<TN_Loc_Container>().First(
                    a => a.S_LOC_CODE == model.StartLoc
                    && a.S_CNTR_CODE == model.CntId);
                var locCntrRel = db.Queryable<TN_Loc_Container>()
                    .Where(c => c.S_LOC_CODE == model.StartLoc && c.S_CNTR_CODE == model.CntrCode)
                    .First();

                if (locCntrRel == null) {
                    return BuildSimpleResult(3, $"起点位置 '{model.StartLoc}' 没有绑定容器 '{model.CntId}'");
                    return BuildSimpleResult(3, $"起点位置 '{model.StartLoc}' 没有绑定容器 '{model.CntrCode}'");
                }

                // TODO 暂定选择最低层按区位顺序入库，后面待修改
@@ -321,13 +301,13 @@
                }

                var endLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.EndLoc))
                    .Where(ExprHelper.LocBelongsToArea(AreaName.包装区))
                    .Where(l => taskInfo.EndAreas.Contains(l.S_AREA_CODE))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty).First();

                if (endLoc == null) {
                    return BuildSimpleResult(4, $"终点位置 '{model.EndLoc}' 不存在或不具备放货要求");
                    return BuildSimpleResult(4, $"终点位置 不存在或不具备放货要求");
                }

                return TaskHelper.SimpleCreateTask(startLoc.S_CODE, locCntrRel.S_CNTR_CODE, endLoc.S_CODE, taskName);
@@ -367,13 +347,13 @@
                }

                var endLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocCode(model.EndLoc))
                    .Where(ExprHelper.LocBelongsToArea(AreaName.包装区))
                    .Where(l => taskInfo.EndAreas.Contains(l.S_AREA_CODE))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty).First();

                if (endLoc == null) {
                    return BuildSimpleResult(4, $"终点位置 '{model.EndLoc}' 不存在或不具备放货要求");
                    return BuildSimpleResult(4, $"终点位置 不存在或不具备放货要求");
                }

                return TaskHelper.SimpleCreateTask(startLoc.S_CODE, locCntrRel.S_CNTR_CODE, endLoc.S_CODE, taskName);
@@ -382,6 +362,200 @@
                return BuildSimpleEx(ex);
            }
        }

        /// <summary>
        /// 创建抽检单
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static SimpleResult CreateCheckOrder(CreateCheckOrderInfo model) {
            var db = DbHelper.GetDbClient();
            try {
                // 绑定操作：插入出库单、所有的出库单明细
                using (var tran = db.Ado.UseTran()) {

                    var order = new TN_Check_Order {
                        S_NO = GenerateOrderNo("抽检单号", "CN"),
                        S_ITEM_CODE = model.ItemCode,
                        //S_ITEM_NAME = model.ItemName,
                        S_BATCH_NO = model.BatchNo,
                        N_COUNT = model.Qty,
                        S_END_AREA = model.EndArea,
                    };

                    if (db.Insertable<TN_Check_Order>(order).ExecuteCommand() <= 0) {
                        tran.RollbackTran();
                        return BuildSimpleResult(2, "生成 抽检单 失败：" + JsonConvert.SerializeObject(order));
                    }

                    for (int i = 0; i < model.Qty; i++) {
                        var detail = new TN_Check_Detail {
                            S_NO = order.S_NO,
                            S_ITEM_CODE = model.ItemCode,
                            S_BATCH_NO = model.BatchNo,
                            S_END_AREA = model.EndArea
                        };

                        if (db.Insertable<TN_Check_Detail>(detail).ExecuteCommand() <= 0) {
                            tran.RollbackTran();
                            return BuildSimpleResult(3, "生成 抽检单明细 失败：" + JsonConvert.SerializeObject(detail));
                        }
                    }

                    tran.CommitTran();
                }
                return BuildSimpleResult(0, $"创建 抽检单 成功");
            }
            catch (Exception ex) {
                return BuildSimpleEx(ex);
            }
        }
        /// <summary>
        /// 抽检-合格回库(PDA)
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static SimpleResult QualifiedBack(QualifiedBackInfo model) {
            var db = DbHelper.GetDbClient();

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

                cgDetail.N_ITEM_STATE = 0;
                cgDetail.S_ITEM_STATE = "合格";

                var startLocCntrRel = db.Queryable<TN_Location, TN_Loc_Container>
                    ((l, c) => l.S_CODE == c.S_LOC_CODE)
                    .Where((l, c) => c.S_CNTR_CODE == cgDetail.S_CNTR_CODE) // 指定容器号
                    .Where(ExprHelper.LocIsFree) // NOTE 检查
                    .Select((l, c) => c) // 筛选 Loc_Container
                    .First();

                if (startLocCntrRel == null) {
                    return BuildSimpleResult(0, "没有找到合适的起点货位");
                }

                var endLoc = db.Queryable<TN_Location>()
                    .Where(ExprHelper.LocBelongsToArea(startLocCntrRel.S_CNTR_TYPE == "托盘" ? AreaName.满托存放区 :
                        startLocCntrRel.S_CNTR_TYPE == "好运箱" ? AreaName.满箱存放区 : ""))
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty).First();

                if (endLoc == null) {
                    return BuildSimpleResult(3, "查询：没有找到合适的终点货位");
                }

                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();
                        return BuildSimpleResult(4, "修改物料状态为合格 失败");
                    }
                    
                    if (!TaskHelper.LogCreateTask(startLocCntrRel.S_LOC_CODE, startLocCntrRel.S_CNTR_CODE, 
                        endLoc.S_CODE, TaskName.抽检_合格回库)) {
                        tran.RollbackTran();
                        return BuildSimpleResult(5, "创建任务失败", false);
                    }

                    tran.CommitTran();
                }
                return BuildSimpleResult(0, "物料合格回库任务创建成功");
            }
            catch (Exception ex) {
                return BuildSimpleEx(ex);
            }
        }
        public static SimpleResult UnqualifiedShift(UnqualifiedShiftInfo model) {
            var db = DbHelper.GetDbClient();
            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) {
                    return BuildSimpleResult(2, "没有找到待回库的抽检物料");
                }

                cgDetail.N_ITEM_STATE = 2;
                cgDetail.S_ITEM_STATE = "不合格";

                var startLocCntrRel = db.Queryable<TN_Location, TN_Loc_Container>
                    ((l, c) => l.S_CODE == c.S_LOC_CODE)
                    .Where(ExprHelper.LocIsFree)
                    .Select((l, c) => c)
                    .First();

                if (startLocCntrRel == null) {
                    return BuildSimpleResult(0, "没有找到合适的起点货位");
                }

                var endLoc = db.Queryable<TN_Location>()
                    .Where(l => l.S_AREA_CODE == model.EndArea)
                    .Where(ExprHelper.LocIsFree)
                    .Where(ExprHelper.LocIsEmpty).First();

                if (endLoc == null) {
                    return BuildSimpleResult(3, "查询：没有找到合适的终点货位");
                }

                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();
                        return BuildSimpleResult(4, "修改物料状态为合格 失败");
                    }

                    if (!TaskHelper.LogCreateTask(startLocCntrRel.S_LOC_CODE, startLocCntrRel.S_CNTR_CODE,
                        endLoc.S_CODE, TaskName.抽检_不合格移库)) {
                        tran.RollbackTran();
                        return BuildSimpleResult(5, "创建任务失败", false);
                    }

                    tran.CommitTran();
                }
                return BuildSimpleResult(0, "物料不合格移库任务创建成功");
            }
            catch (Exception ex) {
                return BuildSimpleEx(ex);
            }
        }

        public static SimpleResult RestBack(RestBackInfo model) {
            var db = DbHelper.GetDbClient();

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

                if (locCntrRel == null) {
                    return BuildSimpleResult(2, $"起点货位 {model.StartLoc}");
                }

                var endLoc = db.Queryable<TN_Location, TN_Loc_Container>((l, c) => l.S_CODE == c.S_LOC_CODE)
                    .Where((l, c) => c.S_CNTR_TYPE == locCntrRel.S_CNTR_TYPE)
                    .First();

                if (endLoc == null) {
                    return BuildSimpleResult(3, $"不存在合适的终点货位可以回库");
                }

                return TaskHelper.SimpleCreateTask(locCntrRel.S_LOC_CODE, locCntrRel.S_CNTR_CODE, endLoc.S_CODE, TaskName.尾箱回库);
            }
            catch (Exception ex) {

                return BuildSimpleEx(ex);
            }
        }

        #endregion

        #region Mobox 功能
@@ -395,40 +569,50 @@
        /// <returns></returns>
        public static SimpleResult FinishedOutbound(FinishedOutboundInfo model) {
            var db = DbHelper.GetDbClient();
            var orderNo = GenerateOrderNo("出库单号", "ON");

            try {
                if (string.IsNullOrEmpty(model.No)) {
                if (string.IsNullOrEmpty(orderNo)) {
                    return BuildSimpleResult(2, "出库单号不能为空");
                }

                if (model.OutboundDetails.Count == 0) {
                    return BuildSimpleResult(2, "出库单明细没有项目");
                }

                using (var tran = db.Ado.UseTran()) {

                    var cgDetailList = SelectCgByTotalQty(model);

                    if (cgDetailList.Count == 0) {
                        return BuildSimpleResult(3, "没有合适的物料可以出库");
                    }

                    // NOTE 如果创建order的时候就指定具体出库物料的cntr，那么如果在创建任务前，这个物料被错误抽检了怎么办
                    foreach (var cgDetail in cgDetailList) {
                        var detail = new TN_Outbound_Detail {
                            S_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_QTY,
                            S_END_AREA = model.EndArea
                        };

                        if (db.Insertable<TN_Outbound_Detail>(detail).ExecuteCommand() <= 0) {
                            tran.RollbackTran();
                            return BuildSimpleResult(4, "生成出库单明细失败：" + JsonConvert.SerializeObject(detail));
                        }
                    }

                    var order = new TN_Outbound_Order {
                        S_NO = model.No,
                        N_FORCE = model.Forced ? 1 : 0
                        S_NO = orderNo,
                        S_ITEM_CODE = model.ItemCode,
                        S_BATCH = model.BatchNo,
                        N_END_NUM = model.Qty,                        
                        //F_OUT_QTY = cgDetailList.Sum(a => a.N_QTY),
                        S_END_AREA = model.EndArea
                    };

                    if (db.Insertable<TN_Outbound_Order>(order).ExecuteCommand() <= 0) {
                        tran.RollbackTran();
                        return BuildSimpleResult(3, "生成出库单失败：" + JsonConvert.SerializeObject(order));
                    }

                    foreach (var detail in model.OutboundDetails) {
                        var newDetail = new TN_Outbound_Detail {
                            S_NO = order.S_NO,
                            S_CG_ID = detail.CgCode,
                            S_BATCH_NO = detail.PatchNo,
                            N_QTY = detail.Qty,
                            N_FORCE = order.N_FORCE,
                            S_END_AREA = detail.EndArea
                        };
                        if (db.Insertable<TN_Outbound_Detail>(newDetail).ExecuteCommand() <= 0) {
                            tran.RollbackTran();
                            return BuildSimpleResult(4, "生成出库单明细失败：" + JsonConvert.SerializeObject(detail));
                        }
                        return BuildSimpleResult(5, "生成出库单失败：" + JsonConvert.SerializeObject(order));
                    }

                    tran.CommitTran();
@@ -447,36 +631,52 @@
        /// <returns></returns>
        public static SimpleResult FinishedOutboundForce(FinishedOutboundInfo model) {
            var db = DbHelper.GetDbClient();
            var orderNo = GenerateOrderNo("出库单号", "ON");

            try {
                if (string.IsNullOrEmpty(model.No)) {
                if (string.IsNullOrEmpty(orderNo)) {
                    return BuildSimpleResult(2, "出库单号不能为空");
                }

                using (var tran = db.Ado.UseTran()) {
                    var order = new TN_Outbound_Order {
                        S_NO = model.No,
                        N_FORCE = model.Forced ? 1 : 0
                    };

                    if (db.Insertable<TN_Outbound_Order>(order).ExecuteCommand() <= 0) {
                        tran.RollbackTran();
                        return BuildSimpleResult(3, "生成出库单失败：" + JsonConvert.SerializeObject(order));
                    var cgDetailList = SelectCgByTotalQty(model);

                    if (cgDetailList.Count == 0) {
                        return BuildSimpleResult(3, "没有合适的物料可以出库");
                    }

                    foreach (var detail in model.OutboundDetails) {
                        var newDetail = new TN_Outbound_Detail {
                            S_NO = order.S_NO,
                            S_CG_ID = detail.CgCode,
                            S_BATCH_NO = detail.PatchNo,
                            N_QTY = detail.Qty,
                            N_FORCE = order.N_FORCE
                    // NOTE 如果创建order的时候就指定具体出库物料的cntr，那么如果在创建任务前，这个物料被错误抽检了怎么办
                    foreach (var cgDetail in cgDetailList) {
                        var detail = new TN_Outbound_Detail {
                            S_NO = orderNo,
                            S_ITEM_CODE = cgDetail.S_ITEM_CODE,
                            S_BATCH_NO = cgDetail.S_BATCH_NO,
                            S_CNTR_CODE = cgDetail.S_CNTR_CODE,
                            S_END_AREA = model.EndArea
                        };
                        if (db.Insertable<TN_Inbound_Order>(order).ExecuteCommand() <= 0) {

                        if (db.Insertable<TN_Outbound_Detail>(detail).ExecuteCommand() <= 0) {
                            tran.RollbackTran();
                            return BuildSimpleResult(4, "生成出库单明细失败：" + JsonConvert.SerializeObject(detail));
                        }
                    }

                    var order = new TN_Outbound_Order {
                        S_NO = orderNo,
                        S_ITEM_CODE = model.ItemCode,
                        S_BATCH = model.BatchNo,
                        N_END_NUM = model.Qty,
                        //F_OUT_QTY = cgDetailList.Sum(a => a.N_QTY),
                        S_END_AREA = model.EndArea
                    };

                    if (db.Insertable<TN_Outbound_Order>(order).ExecuteCommand() <= 0) {
                        tran.RollbackTran();
                        return BuildSimpleResult(5, "生成出库单失败：" + JsonConvert.SerializeObject(order));
                    }

                    tran.CommitTran();
                }

                return BuildSimpleResult(0, "生成出库单成功");
@@ -486,6 +686,121 @@
            }
        }

        public static List<TN_CG_Detail> SelectCgByTotalQty(FinishedOutboundInfo model) {
            var db = DbHelper.GetDbClient();
            var result = new List<TN_CG_Detail>();
            var targetNum = model.Qty;

            try {
                var targetCg = db.Queryable<TN_CG_Detail>().Where(a => a.S_ITEM_CODE == model.ItemCode
                && a.N_QTY > targetNum).
                OrderBy(a => a.N_QTY, OrderByType.Asc).First();
                if (targetCg != null) //刚好有一行满足条件
                {
                    result.Add(targetCg);
                    return result;
                }

                // NOTE 根据总量选detail时，是否需要考虑货位的高低？
                var 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 == model.ItemCode && d.S_BATCH_NO == model.BatchNo && d.N_QTY > 0)
                    .Where((d, c) => c.S_CNTR_TYPE == model.CntrType)
                    .Where(d => (model.ForcedOut && d.N_ITEM_STATE == 0 && d.S_ITEM_STATE == "合格")
                        || (!model.ForcedOut && (d.N_ITEM_STATE == 0 && d.S_ITEM_STATE == "合格"
                        || d.N_ITEM_STATE == 1 && d.S_ITEM_STATE == "待检")))
                    .OrderBy(d => d.N_QTY, OrderByType.Desc)
                    .OrderBy(d => d.N_ITEM_STATE, OrderByType.Asc).ToList();

                if (sortedMaterials.Count == 0) //没有满足条件的
                {
                    return result;
                }

                float countNum = 0;
                foreach (var mat in sortedMaterials) {
                    countNum += mat.N_QTY;
                    result.Add(mat);
                    if (countNum >= targetNum) {
                        break;
                    }
                }
                if (result.Sum(a => a.N_QTY) >= targetNum) {
                    return result;
                }
                else {
                    result.Clear();
                    return result;
                }
            }
            catch (Exception ex) {
                throw ex;
            }
        }

        /// <summary>
        /// 移库-创建移库任务(WMS)
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static SimpleResult CreateShiftOrder(CreateShiftOrderInfo model) {
            var db = DbHelper.GetDbClient();
            try {
                var locCntrRelList = db.Queryable<TN_Loc_Container, TN_CG_Detail>((c, d) => c.S_CNTR_CODE == d.S_CNTR_CODE)
                    .Where((c, d) => d.S_ITEM_CODE == model.ItemCode && d.S_BATCH_NO == model.ItemCode)
                    .ToList();

                if (locCntrRelList.Count == 0) {
                    return BuildSimpleResult(2, "没有找到待移库的物料");
                }

                // 绑定操作：插入出库单、所有的出库单明细
                using (var tran = db.Ado.UseTran()) {

                    var order = new TN_Shift_Order {
                        S_NO = GenerateOrderNo("移库单号", "SN"),
                        S_ITEM_CODE = model.ItemCode,
                        //S_ITEM_NAME = model.ItemName,
                        S_BATCH_NO = model.BatchNo,
                        N_COUNT = locCntrRelList.Count,
                        S_END_AREA = model.EndArea,
                    };

                    if (db.Insertable<TN_Shift_Order>(order).ExecuteCommand() <= 0) {
                        tran.RollbackTran();
                        return BuildSimpleResult(2, "生成 移库单 失败：" + JsonConvert.SerializeObject(order));
                    }

                    foreach (var locCntrRel in locCntrRelList) {
                        var detail = new TN_Shift_Detail {
                            S_NO = order.S_NO,
                            S_ITEM_CODE = model.ItemCode,
                            S_LOC_CODE = locCntrRel.S_LOC_CODE,
                            S_CNTR_CODE = locCntrRel.S_CNTR_CODE,
                            S_BATCH_NO = model.BatchNo,
                            S_END_AREA = model.EndArea
                        };

                        if (db.Insertable<TN_Shift_Detail>(detail).ExecuteCommand() <= 0) {
                            tran.RollbackTran();
                            return BuildSimpleResult(3, "生成 移库单明细 失败：" + JsonConvert.SerializeObject(detail));
                        }
                    }

                    tran.CommitTran();
                }
                return BuildSimpleResult(0, $"创建 移库单 成功");
            }
            catch (Exception ex) {
                return BuildSimpleEx(ex);
            }
        }

        private static string GenerateOrderNo(string snType, string prefix) {
            var id = SysHelper.GetSerialNumber(snType, prefix);
            var date = DateTime.Now.ToString("yyMMdd");
            return $"ON{date}{id.ToString().PadLeft(4, '0')}";
        }

        #endregion

    }