using HH.Redis.ReisModel;
using HH.TOOLS.LOG;
using HH.WMS.Common;
using HH.WMS.DAL;
using HH.WMS.DAL.Basic;
using HH.WMS.DAL.Check;
using HH.WMS.DAL.InStock;
using HH.WMS.Entitys;
using HH.WMS.Entitys.Basic;
using HH.WMS.Entitys.Check;
using HH.WMS.Entitys.Entitys;
using HH.WMS.Entitys.Enums;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.BLL.Check
{
    /// <summary>
    /// 盘点单管理 无锡宇寿
    /// </summary>
    public class TN_WM_CHECK_WXYSBLL : DapperBaseBLL
    {
        #region GET

        public OperateResult GetCheckDtl(string opNo)
        {
            var checkDtls = BLLCreator.Create<DapperBLL<TN_WM_CHECK_DTLEntity>>().GetList(new { CN_S_OP_NO = opNo });
            foreach (var checkDtl in checkDtls)
            {
               // var item = CreateDAL<TN_WMS_ITEMDAL>().GetItemEntity(checkDtl.CN_S_ITEM_CODE);
               // checkDtl.CN_F_QUANTITY = (item.CN_F_NW == 0 ? 0 : Math.Round(checkDtl.CN_F_WEIGHT / item.CN_F_NW, 2));// Math.Round(checkDtl.CN_F_WEIGHT / item.CN_F_NW, 2);
                checkDtl.CN_S_AREA_NAME = GetAreaName(checkDtl.CN_S_STOCK_AREA);
            }
            return OperateResult.Succeed("", checkDtls);
        }

        public DataTable GetCheckList(dynamic obj)
        {
            DataTable dt = CreateDAL<TN_WM_CHECK_WXYSDAL>().GetCheckList(obj);
            dt.Columns.Add("CN_S_STOCK_NAME");
            dt.Columns.Add("CN_S_AREA_NAME");
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    dt.Rows[i]["CN_S_STOCK_NAME"] = GetStockName(dt.Rows[i]["CN_S_STOCK_CODE"].ToString().Trim());
                    dt.Rows[i]["CN_S_AREA_NAME"] = GetAreaName(dt.Rows[i]["CN_S_STOCK_AREA"].ToString().Trim());
                }
            }
            return dt;
        }

        public OperateResult GetCheckListByOpNo(string opNo)
        {
            var checkLists = CreateDAL<DapperDAL<TN_WM_CHECK_LISTEntity>>().GetList(new { CN_S_OP_NO = opNo });
            var temp = checkLists.Select(e => new
            {
                CN_S_LOCATION_CODE = e.CN_S_LOCATION_CODE,
                CN_S_STOCK_CODE = e.CN_S_STOCK_CODE,
                CN_S_STOCK_AREA = e.CN_S_STOCK_AREA,
                CN_S_TRAY_CODE = e.CN_S_TRAY_CODE,
                CN_S_STOCK_NAME = GetStockName(e.CN_S_STOCK_CODE),
                CN_S_AREA_NAME = GetAreaName(e.CN_S_STOCK_AREA)
            }).Distinct().ToList();
            return OperateResult.Succeed("", temp);
        }

        public OperateResult GetMstAndDtl(string opNo)
        {
            var checkMst = CreateDAL<DapperDAL<TN_WM_CHECK_MSTEntity>>().GetSingleEntity(new { CN_S_OP_NO = opNo });
            if (checkMst == null)
            {
                return OperateResult.Error("未找到当前" + opNo + "盘点业务");
            }
            checkMst.CN_S_STOCK_NAME = GetStockName(checkMst.CN_S_STOCK_CODE);
            var checkDtls = CreateDAL<DapperDAL<TN_WM_CHECK_DTLEntity>>().GetList(new { CN_S_OP_NO = opNo });
            foreach (var checkDtl in checkDtls)
            {
                var item = CreateDAL<TN_WMS_ITEMDAL>().GetItemEntity(checkDtl.CN_S_ITEM_CODE);
                checkDtl.CN_F_QUANTITY = (item.CN_F_NW == 0 ? 0 : Math.Round(checkDtl.CN_F_WEIGHT / item.CN_F_NW, 2));
                checkDtl.CN_S_AREA_NAME = GetAreaName(checkDtl.CN_S_STOCK_AREA);
            }
            checkMst.dtls = checkDtls;
            return OperateResult.Succeed("", checkMst);
        }

        #endregion

        #region ADD

        /// <summary>
        /// 新增盘点单
        /// </summary>
        /// <param name="checkLists"></param>
        /// <param name="loginer"></param>
        /// <returns></returns>
        public OperateResult Add(List<TN_WM_CHECK_LISTEntity> checkListDtos, RedisUserEntity loginer, LogPara logPara)
        {
            var checkLists = new List<TN_WM_CHECK_LISTEntity>();
            foreach (var checkListDto in checkListDtos)
            {
                var checkList = CreateDAL<DapperDAL<TN_WM_CHECK_LISTEntity>>().GetList(new
                {
                    CN_S_STOCK_CODE = checkListDto.CN_S_STOCK_CODE,
                    CN_S_STOCK_AREA = checkListDto.CN_S_STOCK_AREA,
                    CN_S_LOCATION_CODE = checkListDto.CN_S_LOCATION_CODE,
                    CN_S_TRAY_CODE = checkListDto.CN_S_TRAY_CODE
                });
                checkLists.AddRange(checkList);
            }

            var checkListsStr = JsonConvert.SerializeObject(checkLists);
            var checkMst = new TN_WM_CHECK_MSTEntity();
            var checkDtls = new List<TN_WM_CHECK_DTLEntity>();

            string postData = "{\"appCode\":\"AutoWMS\",\"ruleName\":\"" + Constants.CheckCode + "\",\"orgId\":\"" + loginer.CN_S_ORGCODE + "\",\"orgFlag\":\"" + loginer.CN_S_ORGFLAG + "\"}";
            var opNo = WebApiManager.HttpAutoBom_Post("api/BillRule/GenBillNo", postData);
            if (string.IsNullOrEmpty(opNo))
            {
                return OperateResult.Error("未获取到autobom中盘点单号！");
            }
            checkMst.CN_S_OP_NO = opNo;
            checkMst.CN_S_STOCK_CODE = checkLists.FirstOrDefault().CN_S_STOCK_CODE;
            checkMst.CN_T_OP_TIME = DateTime.Now;
            checkMst.CN_S_STATE = BillStateEnum.Create.GetDescription();
            checkMst.CN_S_CREATOR = loginer.CN_S_LOGIN;
            checkMst.CN_S_CREATOR_BY = loginer.CN_S_NAME;
            checkMst.CN_T_CREATE = DateTime.Now;
            checkMst.CN_S_OPERATOER = checkLists.FirstOrDefault().CN_S_CREATOR;
            checkMst.CN_S_OPERATOER_NAME = checkLists.FirstOrDefault().CN_S_CREATOR_BY;
            var result = CreateCheckDtls(opNo, checkLists, checkDtls);
            if (!result.Success) return result;
            result = UseTransaction(trans =>
            {

                var backResult = CreateDAL<DapperDAL<TN_WM_CHECK_MSTEntity>>().Add(checkMst, trans);
                logPara.Push("新增盘点单主表结果：" + (backResult.Success ? "成功" : "失败"));
                if (!backResult.Success)
                {
                    trans.Rollback();
                    return;
                }
                backResult = CreateDAL<DapperDAL<TN_WM_CHECK_DTLEntity>>().AddRange(checkDtls, trans);
                logPara.Push("新增盘点单子表结果：" + (backResult.Success ? "成功" : "失败"));
                if (!backResult.Success)
                {
                    trans.Rollback();
                    return;
                }

                //更新checklist的业务号
                foreach (var checkList in checkLists)
                {
                    CreateDAL<DapperDAL<TN_WM_CHECK_LISTEntity>>().Update(new { CN_S_OP_NO = opNo }, new
                    {
                        CN_S_STOCK_CODE = checkList.CN_S_STOCK_CODE,
                        CN_S_STOCK_AREA = checkList.CN_S_STOCK_AREA,
                        CN_S_LOCATION_CODE = checkList.CN_S_LOCATION_CODE,
                        CN_S_TRAY_CODE = checkList.CN_S_TRAY_CODE
                    });
                }
            });
            return result;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="opNo"></param>
        /// <param name="checkLists"></param>
        /// <param name="checkDtls"></param>
        /// <returns></returns>
        public OperateResult CreateCheckDtls(string opNo, List<TN_WM_CHECK_LISTEntity> checkLists, List<TN_WM_CHECK_DTLEntity> checkDtls)
        {
            var rowNo = 0;
            checkLists = checkLists.OrderBy(o => o.CN_S_CHECK_RESULT).ThenBy(o => o.CN_S_TRAY_CODE).ToList();
            foreach (var checkList in checkLists)
            {
                rowNo = rowNo + 1;
                var checkDtl = new TN_WM_CHECK_DTLEntity();
                var afterState = "盘点后";
                #region 删除、新增、修改后、正确

                var checkStateEnum = EnumExtensions.GetEnumByName<CheckStateEnum>(checkList.CN_S_CHECK_RESULT);
                if (checkStateEnum.Equals(CheckStateEnum.ERROR))
                    return OperateResult.Error("盘点状态" + checkList.CN_S_CHECK_RESULT + "存在异常！");
                afterState = checkStateEnum.GetDescription();

                checkDtl = new TN_WM_CHECK_DTLEntity
                {
                    CN_S_OP_NO = opNo,
                    CN_N_ROW_NO = rowNo,
                    CN_S_STOCK_AREA = checkList.CN_S_STOCK_AREA,
                    CN_S_LOCATION_CODE = checkList.CN_S_LOCATION_CODE,
                    CN_S_TRAY_CODE = checkList.CN_S_TRAY_CODE,
                    CN_S_ITEM_CODE = checkList.CN_S_ITEM_CODE,
                    CN_S_ITEM_NAME = checkList.CN_S_ITEM_NAME,
                    CN_S_ITEM_STATE = checkList.CN_S_ITEM_STATE,
                    CN_S_OWNER = checkList.CN_S_OWNER,
                    CN_S_LOT_NO = checkList.CN_S_LOT_NO,
                    CN_S_MODEL = checkList.CN_S_MODEL,
                    CN_S_FIGURE_NO = checkList.CN_S_FIGURE_NO,
                    CN_S_MEASURE_UNIT = checkList.CN_S_MEASURE_UNIT,
                    CN_F_QUANTITY = checkList.CN_F_QUANTITY,
                    CN_S_PACK_CODE = checkList.CN_S_PACK_CODE,
                    CN_S_TYPE = afterState,
                    CN_F_WEIGHT = checkList.CN_F_WEIGHT,
                    CN_F_PACKING_QTY = checkList.CN_F_PACKING_QTY,
                    CN_S_CHECK_RESULT = checkList.CN_S_CHECK_RESULT
                };
                checkDtls.Add(checkDtl);

                #endregion

                #region 修改前

                if (checkList.CN_S_CHECK_RESULT.Equals(CheckStateEnum.E.ToString()))
                {
                    var trayItemDtl = BLLCreator.Create<DapperBLL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetSingleEntity(new
                    {
                        // CN_PARENT_GUID = trayItemMst.CN_GUID,
                        CN_S_UNIQUE_CODE = checkList.CN_S_PACK_CODE
                    });
                    if (trayItemDtl == null)
                    {
                        return OperateResult.Error("未找到当前托盘" + checkList.CN_S_TRAY_CODE + "下料箱：" + checkList.CN_S_PACK_CODE + "的物料信息！");
                    }

                    var trayItemMst = BLLCreator.Create<DapperBLL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetSingleEntity(new
                    {
                        CN_GUID = trayItemDtl.CN_PARENT_GUID,
                        CN_S_TRAY_CODE = checkList.CN_S_TRAY_CODE
                    });

                    if (trayItemMst == null)
                    {
                        return OperateResult.Error("未找到托盘：" + checkList.CN_S_TRAY_CODE + "的物料托盘数据！");
                    }
                    checkDtl = new TN_WM_CHECK_DTLEntity
                    {
                        CN_S_OP_NO = opNo,
                        CN_N_ROW_NO = rowNo,
                        CN_S_STOCK_AREA = checkList.CN_S_STOCK_AREA,
                        CN_S_LOCATION_CODE = checkList.CN_S_LOCATION_CODE,
                        CN_S_TRAY_CODE = checkList.CN_S_TRAY_CODE,
                        CN_S_ITEM_CODE = trayItemMst.CN_S_ITEM_CODE,
                        CN_S_ITEM_NAME = trayItemMst.CN_S_ITEM_NAME,
                        CN_S_ITEM_STATE = trayItemMst.CN_S_ITEM_STATE,
                        CN_S_OWNER = checkList.CN_S_OWNER,
                        CN_S_LOT_NO = trayItemDtl.CN_S_LOT_NO,
                        CN_S_MODEL = trayItemMst.CN_S_MODEL,
                        CN_S_FIGURE_NO = trayItemDtl.CN_S_EXT1,
                        CN_S_MEASURE_UNIT = trayItemMst.CN_S_MEASURE_UNIT,
                        CN_F_QUANTITY = trayItemDtl.CN_F_QUANTITY,
                        CN_S_PACK_CODE = checkList.CN_S_PACK_CODE,
                        CN_S_TYPE = CheckStateEnum.EB.GetDescription(),
                        CN_S_CHECK_RESULT = CheckStateEnum.EB.ToString(),
                        CN_F_WEIGHT = Convert.ToDecimal(trayItemDtl.CN_S_SERIAL_NO),
                        CN_F_PACKING_QTY = Convert.ToDecimal(trayItemDtl.CN_F_PACKING_QTY)
                    };
                    checkDtls.Add(checkDtl);
                }

                #endregion
            }
            return OperateResult.Succeed();
        }

        #endregion

        #region UPDATE

        public OperateResult Update(CheckAddDto checkAddDto, RedisUserEntity loginer)
        {
            var checkListDtos = checkAddDto.checkList;
            var checkLists = new List<TN_WM_CHECK_LISTEntity>();
            foreach (var checkListDto in checkListDtos)
            {
                var checkList = CreateDAL<DapperDAL<TN_WM_CHECK_LISTEntity>>().GetList(new
                {
                    CN_S_STOCK_CODE = checkListDto.CN_S_STOCK_CODE,
                    CN_S_STOCK_AREA = checkListDto.CN_S_STOCK_AREA,
                    CN_S_LOCATION_CODE = checkListDto.CN_S_LOCATION_CODE,
                    CN_S_TRAY_CODE = checkListDto.CN_S_TRAY_CODE
                });
                checkLists.AddRange(checkList);
            }

            var checkListsStr = JsonConvert.SerializeObject(checkLists);
            var checkMst = new TN_WM_CHECK_MSTEntity();
            var checkDtls = new List<TN_WM_CHECK_DTLEntity>();

            checkMst.CN_S_OP_NO = checkAddDto.opNo;
            checkMst.CN_S_STOCK_CODE = checkLists.FirstOrDefault().CN_S_STOCK_CODE;
            checkMst.CN_T_OP_TIME = DateTime.Now;
            checkMst.CN_S_STATE = BillStateEnum.Create.GetDescription();
            checkMst.CN_S_CREATOR = loginer.CN_S_LOGIN;
            checkMst.CN_S_CREATOR_BY = loginer.CN_S_NAME;
            checkMst.CN_T_CREATE = DateTime.Now;
            checkMst.CN_S_OPERATOER = checkLists.FirstOrDefault().CN_S_CREATOR;
            checkMst.CN_S_OPERATOER_NAME = checkLists.FirstOrDefault().CN_S_CREATOR_BY;
            var result = CreateCheckDtls(checkAddDto.opNo, checkLists, checkDtls);
            if (!result.Success) return result;

            result = UseTransaction(trans =>
            {
                CreateDAL<DapperDAL<TN_WM_CHECK_MSTEntity>>().Delete(new { CN_S_OP_NO = checkAddDto.opNo });
                CreateDAL<DapperDAL<TN_WM_CHECK_DTLEntity>>().Delete(new { CN_S_OP_NO = checkAddDto.opNo });
                CreateDAL<TN_WM_CHECK_WXYSDAL>().UpdateCheckListOpNo(checkAddDto.opNo, "", trans);

                var backResult = CreateDAL<DapperDAL<TN_WM_CHECK_MSTEntity>>().Add(checkMst, trans);
                if (!backResult.Success)
                {
                    trans.Rollback();
                    return;
                }
                backResult = CreateDAL<DapperDAL<TN_WM_CHECK_DTLEntity>>().AddRange(checkDtls, trans);
                if (!backResult.Success)
                {
                    trans.Rollback();
                    return;
                }

                //更新checklist的业务号
                foreach (var checkList in checkLists)
                {
                    CreateDAL<DapperDAL<TN_WM_CHECK_LISTEntity>>().Update(new { CN_S_OP_NO = checkAddDto.opNo }, new
                    {
                        CN_S_STOCK_CODE = checkList.CN_S_STOCK_CODE,
                        CN_S_STOCK_AREA = checkList.CN_S_STOCK_AREA,
                        CN_S_LOCATION_CODE = checkList.CN_S_LOCATION_CODE,
                        CN_S_TRAY_CODE = checkList.CN_S_TRAY_CODE
                    }, trans);
                }
            });
            return result;
        }

        public OperateResult Submit(CheckAuditDto checkAuditDto)
        {
            var checkMst = BLLCreator.Create<DapperBLL<TN_WM_CHECK_MSTEntity>>().GetSingleEntity(new { CN_S_OP_NO = checkAuditDto.opNo });
            if (checkMst == null)
            {
                return OperateResult.Error("未找到当前盘点单" + checkAuditDto.opNo);
            }
            var result = CreateDAL<DapperDAL<TN_WM_CHECK_MSTEntity>>().Update(new
            {
                CN_S_STATE = BillStateEnum.Submit.GetDescription(),
                CN_S_NOTE = checkAuditDto.note,
                CN_S_CURR_ORG_CODE = checkAuditDto.checkAuditOrgDto.currentOrgCode,
                CN_S_CURR_ORG_NAME = checkAuditDto.checkAuditOrgDto.currentOrgName,
                CN_S_NEXT_ORG_CODE = checkAuditDto.checkAuditOrgDto.nextOrgCode,
                CN_S_NEXT_ORG_NAME = checkAuditDto.checkAuditOrgDto.nextOrgName,
            }, new { CN_S_OP_NO = checkAuditDto.opNo });
            return result;
        }

        /// <summary>
        /// 审核
        /// </summary>
        /// <param name="checkAuditDto"></param>
        /// <returns></returns>
        public OperateResult Audit(CheckAuditPara checkAuditPara, LogPara logPara)
        {
            logPara.Push("接收参数：" + JsonConvert.SerializeObject(checkAuditPara.checkAuditDto));

            checkAuditPara.state = BillStateEnum.Auditing.GetDescription();
            checkAuditPara.isEnd = false;
            if (string.IsNullOrEmpty(checkAuditPara.checkAuditDto.checkAuditOrgDto.nextOrgCode))
                checkAuditPara.state = BillStateEnum.Audit.GetDescription();

            checkAuditPara.checkMst = BLLCreator.Create<DapperBLL<TN_WM_CHECK_MSTEntity>>().GetSingleEntity(new { CN_S_OP_NO = checkAuditPara.checkAuditDto.opNo });
            if (checkAuditPara.checkMst == null)
            {
                return OperateResult.Error("未找到当前盘点单" + checkAuditPara.checkAuditDto.opNo);
            }

            //最终审核结束，释放货位
            if (string.IsNullOrEmpty(checkAuditPara.checkAuditDto.checkAuditOrgDto.nextOrgCode))
            {
                var reuslt = AuditHandleParam(checkAuditPara, logPara);
                if (!reuslt.Success) return reuslt;

                logPara.Push("接收参数checkAuditPara：" + JsonConvert.SerializeObject(checkAuditPara));
                AuditReduceQty(checkAuditPara, logPara);
            }

            #region 逻辑处理
            //1、针对已经在货位上的料箱，需要在绑定之前，把先前的绑定给解绑，避免造成同一个料箱在不同货位上的情况
            //2、新增时需要判断是否主表已存在，如果存在则累加数量，不存在的话，新增主表

            List<TN_WM_B_TRAY_ITEM_MSTEntity> mstDeleteList = new List<TN_WM_B_TRAY_ITEM_MSTEntity>();
            List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlDeleteList = new List<TN_WM_B_TRAY_ITEM_DTLEntity>();

            List<TN_WM_B_TRAY_ITEM_MSTEntity> mstAddList = new List<TN_WM_B_TRAY_ITEM_MSTEntity>();
            List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlAddList = new List<TN_WM_B_TRAY_ITEM_DTLEntity>();

            List<TN_WM_B_TRAY_ITEM_MSTEntity> mstModAddQtyList = new List<TN_WM_B_TRAY_ITEM_MSTEntity>();
            List<TN_WM_B_TRAY_ITEM_MSTEntity> mstModReduceQtyList = new List<TN_WM_B_TRAY_ITEM_MSTEntity>();

            List<TN_WM_B_TRAY_LOCATIONEntity> trayLocationDeleteList = new List<TN_WM_B_TRAY_LOCATIONEntity>();

            if (checkAuditPara.isEnd)
            {
                foreach (var checkDtl in checkAuditPara.checkMst.dtls)
                {
                    if (checkDtl.CN_S_CHECK_RESULT.Equals(CheckStateEnum.A.ToString())) //增加
                    {
                        #region 是否位于其他货位
                        TN_WM_B_TRAY_ITEM_DTLEntity dtlDelete = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetSingleEntity(new { CN_S_UNIQUE_CODE = checkDtl.CN_S_PACK_CODE });
                        if (dtlDelete != null)
                        {
                            TN_WM_B_TRAY_ITEM_MSTEntity mstDelete = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetSingleEntity(new { CN_GUID = dtlDelete.CN_PARENT_GUID });
                            if (mstDelete != null)
                            {
                                TN_WM_B_TRAY_LOCATIONEntity traylocationDelete = CreateDAL<DapperDAL<TN_WM_B_TRAY_LOCATIONEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = mstDelete.CN_S_TRAY_CODE });
                                if (traylocationDelete != null)
                                {
                                    dtlDeleteList.Add(dtlDelete);

                                    List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlExistList = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetList(new { CN_PARENT_GUID = mstDelete.CN_GUID });
                                    var exi = dtlExistList.Where(x => x.CN_GUID != dtlDelete.CN_GUID);
                                    if (!exi.Any())//说明子表中只有一条，所以需要删除主表
                                    {
                                        //主表能删的情况下，托盘货位关联才能解绑
                                        trayLocationDeleteList.Add(traylocationDelete);
                                        mstDeleteList.Add(mstDelete);
                                    }
                                }
                            }
                        }
                        #endregion

                        #region 主表新增或修改
                        var trayItemMstExist = new TN_WM_B_TRAY_ITEM_MSTEntity
                        {
                            CN_GUID = Guid.NewGuid().ToString(),
                            CN_S_TRAY_CODE = checkDtl.CN_S_TRAY_CODE,
                            CN_S_TRAY_GRID = "1",
                            CN_S_OWNER = checkDtl.CN_S_OWNER,
                            CN_S_ITEM_CODE = checkDtl.CN_S_ITEM_CODE,
                            CN_S_ITEM_NAME = checkDtl.CN_S_ITEM_NAME,
                            CN_S_FIGURE_NO = "",//checkDtl.CN_S_FIGURE_NO,
                            CN_S_MODEL = checkDtl.CN_S_MODEL,
                            CN_S_ITEM_STATE = "合格",//CN_S_ITEM_STATE = checkDtl.CN_S_ITEM_STATE,
                            CN_F_QUANTITY = 1,
                            CN_S_MEASURE_UNIT = checkDtl.CN_S_MEASURE_UNIT
                        };

                        List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlList = new List<TN_WM_B_TRAY_ITEM_DTLEntity>();
                        dtlList.Add(new TN_WM_B_TRAY_ITEM_DTLEntity
                        {
                            CN_GUID = Guid.NewGuid().ToString(),
                            CN_PARENT_GUID = trayItemMstExist.CN_GUID,
                            CN_S_UNIQUE_CODE = checkDtl.CN_S_PACK_CODE,
                            CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                            CN_F_QUANTITY = checkDtl.CN_F_QUANTITY,
                            CN_F_PACKING_QTY = checkDtl.CN_F_PACKING_QTY,
                            CN_T_PRODUCTION = DateTime.Now,
                            CN_T_EXPIRATION = DateTime.Now,
                            CN_S_NOTE = "盘点新增",
                            CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                            CN_T_CREATE = DateTime.Now,
                            CN_T_MODIFY = DateTime.Now,
                            CN_S_SERIAL_NO = checkDtl.CN_F_WEIGHT.ToString(),
                            CN_S_EXT1 = checkDtl.CN_S_FIGURE_NO,
                            CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY
                        });

                        trayItemMstExist.TrayItemDtlList = dtlList;

                        var resultExist = CreateDAL<TN_WM_B_TRAY_ITEM_RELDAL>().CheckExists(trayItemMstExist);
                        if (resultExist.Count > 1)
                        {
                            logPara.Push("此处有异常，根据条件获取到多条主表信息，Json条件：" + JsonConvert.SerializeObject(trayItemMstExist));
                        }

                        //当后台查到有主表存在数据的时候，主表修改数量，字表新增
                        if (resultExist.Any())
                        {
                            trayItemMstExist.CN_GUID = resultExist[0].CN_GUID;
                            foreach (var item in trayItemMstExist.TrayItemDtlList)
                            {
                                item.CN_PARENT_GUID = trayItemMstExist.CN_GUID;
                            }
                            mstModAddQtyList.Add(trayItemMstExist);
                        }
                        else
                        {
                            mstAddList.Add(trayItemMstExist);

                            //添加上架记录
                            checkAuditPara.upHis.Add(new TN_WM_UP_HISTORYEntity
                            {
                                CN_GUID = Guid.NewGuid().ToString(),
                                CN_S_LOCATION_CODE = checkDtl.CN_S_LOCATION_CODE,
                                CN_S_ITEM_STATE = trayItemMstExist.CN_S_ITEM_STATE,
                                CN_S_TRAY_CODE = trayItemMstExist.CN_S_TRAY_CODE,
                                CN_S_TRAY_GRID = trayItemMstExist.CN_S_TRAY_GRID == null ? "" : trayItemMstExist.CN_S_TRAY_GRID,
                                CN_S_ITEM_CODE = trayItemMstExist.CN_S_ITEM_CODE,
                                CN_S_ITEM_NAME = trayItemMstExist.CN_S_ITEM_NAME,
                                CN_S_PRODUCTION_BATCH = trayItemMstExist.CN_S_LOT_NO,
                                CN_F_QUANTITY = checkDtl.CN_F_WEIGHT,
                                CN_F_PACKING_QTY = checkDtl.CN_F_PACKING_QTY,
                                CN_S_MODEL = trayItemMstExist.CN_S_MODEL,
                                CN_S_STOCK_AREA = checkDtl.CN_S_STOCK_AREA,
                                CN_S_STOCK_CODE = checkAuditPara.checkMst.CN_S_STOCK_CODE,
                                CN_T_CREATE = DateTime.Now,
                                CN_T_MODIFY = DateTime.Now,
                                CN_S_OWNER = "",
                                CN_S_MEASURE_UNIT = trayItemMstExist.CN_S_MEASURE_UNIT,
                                CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                                CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY,
                                CN_S_MODIFY = "",
                                CN_S_MODIFY_BY = "",
                                CN_S_OP_FROM = "盘点审核-新增",
                                CN_S_EXT1 = checkDtl.CN_S_PACK_CODE,//trayItemMst.CN_S_UNIQUE_CODE,
                                CN_S_EXT2 = "其他入库",
                                CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                                CN_S_FIGURE_NO = checkDtl.CN_S_FIGURE_NO
                            });
                        }

                        dtlAddList.AddRange(dtlList);

                        #endregion
                    }
                }

                foreach (var checkDtl in checkAuditPara.checkMst.dtls)
                {
                    if (checkDtl.CN_S_CHECK_RESULT.Equals(CheckStateEnum.D.ToString()))//删除
                    {
                        #region 判断主表是否需要删除
                        var trayItemMst = checkDtl.trayItemMst;
                        List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlExistList = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetList(new { CN_PARENT_GUID = trayItemMst.CN_GUID });
                        if (dtlExistList.Count == 1)
                        {
                            mstDeleteList.Add(trayItemMst);
                            dtlDeleteList.Add(dtlExistList[0]);
                        }
                        if (dtlExistList.Count > 1)
                        {
                            var findDtl = dtlExistList.Where(x => x.CN_S_UNIQUE_CODE == checkDtl.CN_S_PACK_CODE).ToList();
                            dtlDeleteList.AddRange(findDtl);

                            var findMst = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetSingleEntity(new { CN_GUID = findDtl[0].CN_PARENT_GUID });
                            mstModReduceQtyList.Add(findMst);
                        }
                        //添加下架记录
                        checkAuditPara.downHis.Add(new TN_WM_DOWN_HISTORYEntity
                        {
                            CN_GUID = Guid.NewGuid().ToString(),
                            CN_S_LOCATION_CODE = checkDtl.CN_S_LOCATION_CODE,
                            CN_S_ITEM_STATE = trayItemMst.CN_S_ITEM_STATE,
                            CN_S_TRAY_CODE = trayItemMst.CN_S_TRAY_CODE,
                            CN_S_TRAY_GRID = trayItemMst.CN_S_TRAY_GRID == null ? "" : trayItemMst.CN_S_TRAY_GRID,
                            CN_S_ITEM_CODE = trayItemMst.CN_S_ITEM_CODE,
                            CN_S_ITEM_NAME = trayItemMst.CN_S_ITEM_NAME,
                            CN_S_PRODUCTION_BATCH = trayItemMst.CN_S_LOT_NO,
                            CN_F_QUANTITY = checkDtl.CN_F_WEIGHT,
                            CN_F_PACKING_QTY = checkDtl.CN_F_PACKING_QTY,
                            CN_S_MODEL = trayItemMst.CN_S_MODEL,
                            CN_S_STOCK_AREA = checkDtl.CN_S_STOCK_AREA,
                            CN_S_STOCK_CODE = checkAuditPara.checkMst.CN_S_STOCK_CODE,
                            CN_T_CREATE = DateTime.Now,
                            CN_T_MODIFY = DateTime.Now,
                            CN_S_OWNER = "",
                            CN_S_MEASURE_UNIT = trayItemMst.CN_S_MEASURE_UNIT,
                            CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                            CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY,
                            CN_S_MODIFY = "",
                            CN_S_MODIFY_BY = "",
                            CN_S_OP_FROM = "盘点审核-删除",
                            CN_S_EXT1 = checkDtl.CN_S_PACK_CODE,//trayItemMst.CN_S_UNIQUE_CODE,
                            CN_S_EXT2 = "其他出库",
                            CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                            CN_S_FIGURE_NO = checkDtl.CN_S_FIGURE_NO
                        });
                        #endregion
                    }
                }
                foreach (var checkDtl in checkAuditPara.checkMst.dtls)
                {
                    if (checkDtl.CN_S_CHECK_RESULT.Equals(CheckStateEnum.E.ToString()))//修改后
                    {
                        #region 原数据删除，新增修改后的数据
                        TN_WM_B_TRAY_ITEM_DTLEntity dtlMod = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetSingleEntity(new { CN_S_UNIQUE_CODE = checkDtl.CN_S_PACK_CODE });

                        TN_WM_B_TRAY_ITEM_MSTEntity mstMod = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetSingleEntity(new { CN_GUID = dtlMod.CN_PARENT_GUID });

                        var trayItemMstExist = new TN_WM_B_TRAY_ITEM_MSTEntity
                        {
                            CN_GUID = System.Guid.NewGuid().ToString().ToUpper(),
                            CN_S_TRAY_CODE = checkDtl.CN_S_TRAY_CODE,
                            CN_S_TRAY_GRID = "1",
                            CN_S_OWNER = checkDtl.CN_S_OWNER,
                            CN_S_ITEM_CODE = checkDtl.CN_S_ITEM_CODE,
                            CN_S_ITEM_NAME = checkDtl.CN_S_ITEM_NAME,
                            CN_S_FIGURE_NO = "",//checkDtl.CN_S_FIGURE_NO,
                            CN_S_MODEL = checkDtl.CN_S_MODEL,
                            CN_S_ITEM_STATE = "合格",//CN_S_ITEM_STATE = checkDtl.CN_S_ITEM_STATE,
                            CN_F_QUANTITY = 1,
                            CN_S_MEASURE_UNIT = checkDtl.CN_S_MEASURE_UNIT
                        };

                        List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlList = new List<TN_WM_B_TRAY_ITEM_DTLEntity>();
                        dtlList.Add(new TN_WM_B_TRAY_ITEM_DTLEntity
                        {
                            CN_GUID = Guid.NewGuid().ToString(),
                            CN_PARENT_GUID = trayItemMstExist.CN_GUID,
                            CN_S_UNIQUE_CODE = checkDtl.CN_S_PACK_CODE,
                            CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                            CN_F_QUANTITY = checkDtl.CN_F_QUANTITY,
                            CN_F_PACKING_QTY = checkDtl.CN_F_PACKING_QTY,
                            CN_T_PRODUCTION = DateTime.Now,
                            CN_T_EXPIRATION = DateTime.Now,
                            CN_S_NOTE = "盘点新增",
                            CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                            CN_T_CREATE = DateTime.Now,
                            CN_T_MODIFY = DateTime.Now,
                            CN_S_SERIAL_NO = checkDtl.CN_F_WEIGHT.ToString(),
                            CN_S_EXT1 = checkDtl.CN_S_FIGURE_NO,
                            CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY
                        });


                        //主表判断是直接删除，还是减主表的数量
                        if (mstMod.CN_F_QUANTITY > 1)
                        {
                            mstModReduceQtyList.Add(mstMod);
                        }
                        else
                        {
                            mstDeleteList.Add(mstMod);
                        }

                        var resultExist = CreateDAL<TN_WM_B_TRAY_ITEM_RELDAL>().CheckExistMsts(trayItemMstExist, checkDtl.CN_S_PACK_CODE);
                        if (resultExist.Count > 1)
                        {
                            logPara.Push("此处有异常，根据条件获取到多条主表信息，Json条件：" + JsonConvert.SerializeObject(trayItemMstExist));
                            return OperateResult.Error("此处有异常，根据条件获取到多条主表信息!");
                        }

                        if (resultExist.Count == 1)
                        {
                            var haveExist = mstDeleteList.Where(x => x.CN_GUID == resultExist[0].CN_GUID);
                            if (haveExist == null)
                            {
                                trayItemMstExist.CN_GUID = resultExist[0].CN_GUID;
                                foreach (var item in dtlList)
                                {
                                    item.CN_PARENT_GUID = trayItemMstExist.CN_GUID;
                                }
                                mstModAddQtyList.Add(trayItemMstExist);
                            }
                            else
                            {
                                mstAddList.Add(trayItemMstExist);
                            }
                        }
                        if (resultExist.Count == 0)
                        {
                            mstAddList.Add(trayItemMstExist);
                        }

                        //子表：直接先删后增
                        dtlAddList.AddRange(dtlList);
                        dtlDeleteList.Add(dtlMod);

                        #endregion
                    }

                }
            }

            if (checkAuditPara.isEnd)
            {
                #region 旧代码已注释
                //foreach (var checkDtl in checkAuditPara.checkMst.dtls)
                //{
                //    if (checkDtl.CN_S_CHECK_RESULT.Equals(CheckStateEnum.A.ToString())) //增加
                //    {
                //        #region 是否位于其他货位
                //        TN_WM_B_TRAY_ITEM_DTLEntity dtlDelete = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetSingleEntity(new { CN_S_UNIQUE_CODE = checkDtl.CN_S_PACK_CODE });
                //        if (dtlDelete != null)
                //        {
                //            TN_WM_B_TRAY_ITEM_MSTEntity mstDelete = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetSingleEntity(new { CN_GUID = dtlDelete.CN_PARENT_GUID });
                //            if (mstDelete != null)
                //            {
                //                TN_WM_B_TRAY_LOCATIONEntity traylocationDelete = CreateDAL<DapperDAL<TN_WM_B_TRAY_LOCATIONEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = mstDelete.CN_S_TRAY_CODE });
                //                if (traylocationDelete != null)
                //                {
                //                    trayLocationDeleteList.Add(traylocationDelete);

                //                    dtlDeleteList.Add(dtlDelete);

                //                    List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlExistList = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetList(new { CN_PARENT_GUID = mstDelete.CN_GUID });
                //                    var exi = dtlExistList.Where(x => x.CN_GUID != dtlDelete.CN_GUID);
                //                    if (!exi.Any())
                //                    {
                //                        mstDeleteList.Add(mstDelete);
                //                    }
                //                }
                //            }
                //        }
                //        #endregion

                //        #region 主表新增或修改
                //        var trayItemMstExist = new TN_WM_B_TRAY_ITEM_MSTEntity
                //        {
                //            CN_GUID = Guid.NewGuid().ToString(),
                //            CN_S_TRAY_CODE = checkDtl.CN_S_TRAY_CODE,
                //            CN_S_TRAY_GRID = "1",
                //            CN_S_OWNER = checkDtl.CN_S_OWNER,
                //            CN_S_ITEM_CODE = checkDtl.CN_S_ITEM_CODE,
                //            CN_S_ITEM_NAME = checkDtl.CN_S_ITEM_NAME,
                //            CN_S_FIGURE_NO = checkDtl.CN_S_FIGURE_NO,
                //            CN_S_MODEL = checkDtl.CN_S_MODEL,
                //            CN_S_ITEM_STATE = "合格",//CN_S_ITEM_STATE = checkDtl.CN_S_ITEM_STATE,
                //            CN_F_QUANTITY = 1,
                //            CN_S_MEASURE_UNIT = checkDtl.CN_S_MEASURE_UNIT
                //        };

                //        List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlList = new List<TN_WM_B_TRAY_ITEM_DTLEntity>();
                //        dtlList.Add(new TN_WM_B_TRAY_ITEM_DTLEntity
                //        {
                //            CN_GUID = Guid.NewGuid().ToString(),
                //            CN_PARENT_GUID = trayItemMstExist.CN_GUID,
                //            CN_S_UNIQUE_CODE = checkDtl.CN_S_PACK_CODE,
                //            CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                //            CN_F_QUANTITY = checkDtl.CN_F_QUANTITY,
                //            CN_T_PRODUCTION = DateTime.Now,
                //            CN_T_EXPIRATION = DateTime.Now,
                //            CN_S_NOTE = "盘点新增",
                //            CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                //            CN_T_CREATE = DateTime.Now,
                //            CN_T_MODIFY = DateTime.Now,
                //            CN_S_SERIAL_NO = checkDtl.CN_F_WEIGHT.ToString(),
                //            CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY
                //        });

                //        trayItemMstExist.TrayItemDtlList = dtlList;

                //        var resultExist = CreateDAL<TN_WM_B_TRAY_ITEM_RELDAL>().CheckExists(trayItemMstExist);
                //        if (resultExist.Count > 1)
                //        {
                //            logPara.Push("此处有异常，根据条件获取到多条主表信息，Json条件：" + JsonConvert.SerializeObject(trayItemMstExist));
                //        }

                //        if (resultExist.Any())
                //        {
                //            trayItemMstExist.CN_GUID = resultExist[0].CN_GUID;
                //            trayItemMstExist.CN_F_QUANTITY = resultExist[0].CN_F_QUANTITY + 1;
                //            foreach (var item in trayItemMstExist.TrayItemDtlList)
                //            {
                //                item.CN_PARENT_GUID = trayItemMstExist.CN_GUID;
                //            }
                //            mstModList.Add(trayItemMstExist);
                //        }
                //        else
                //        {
                //            mstAddList.Add(trayItemMstExist);

                //            //添加上架记录
                //            checkAuditPara.upHis.Add(new TN_WM_UP_HISTORYEntity
                //            {
                //                CN_GUID = Guid.NewGuid().ToString(),
                //                CN_S_LOCATION_CODE = checkDtl.CN_S_LOCATION_CODE,
                //                CN_S_ITEM_STATE = trayItemMstExist.CN_S_ITEM_STATE,
                //                CN_S_TRAY_CODE = trayItemMstExist.CN_S_TRAY_CODE,
                //                CN_S_TRAY_GRID = trayItemMstExist.CN_S_TRAY_GRID == null ? "" : trayItemMstExist.CN_S_TRAY_GRID,
                //                CN_S_ITEM_CODE = trayItemMstExist.CN_S_ITEM_CODE,
                //                CN_S_ITEM_NAME = trayItemMstExist.CN_S_ITEM_NAME,
                //                CN_S_PRODUCTION_BATCH = trayItemMstExist.CN_S_LOT_NO,
                //                CN_F_QUANTITY = checkDtl.CN_F_WEIGHT,
                //                CN_S_MODEL = trayItemMstExist.CN_S_MODEL,
                //                CN_S_STOCK_AREA = checkDtl.CN_S_STOCK_AREA,
                //                CN_S_STOCK_CODE = checkAuditPara.checkMst.CN_S_STOCK_CODE,
                //                CN_T_CREATE = DateTime.Now,
                //                CN_T_MODIFY = DateTime.Now,
                //                CN_S_OWNER = "",
                //                CN_S_MEASURE_UNIT = trayItemMstExist.CN_S_MEASURE_UNIT,
                //                CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                //                CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY,
                //                CN_S_MODIFY = "",
                //                CN_S_MODIFY_BY = "",
                //                CN_S_OP_FROM = "盘点审核-新增",
                //                CN_S_EXT1 = checkDtl.CN_S_PACK_CODE,//trayItemMst.CN_S_UNIQUE_CODE,
                //                CN_S_EXT2 = "其他入库",
                //                CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                //                CN_S_FIGURE_NO = checkDtl.CN_S_FIGURE_NO
                //            });
                //        }


                //        #endregion
                //    }

                //    if (checkDtl.CN_S_CHECK_RESULT.Equals(CheckStateEnum.E.ToString()))//修改后
                //    {
                //        #region 主表新增或修改
                //        var trayItemMstExist = new TN_WM_B_TRAY_ITEM_MSTEntity
                //        {
                //            CN_GUID = Guid.NewGuid().ToString(),
                //            CN_S_TRAY_CODE = checkDtl.CN_S_TRAY_CODE,
                //            CN_S_TRAY_GRID = "1",
                //            CN_S_OWNER = checkDtl.CN_S_OWNER,
                //            CN_S_ITEM_CODE = checkDtl.CN_S_ITEM_CODE,
                //            CN_S_ITEM_NAME = checkDtl.CN_S_ITEM_NAME,
                //            CN_S_FIGURE_NO = checkDtl.CN_S_FIGURE_NO,
                //            CN_S_MODEL = checkDtl.CN_S_MODEL,
                //            CN_S_ITEM_STATE = "合格",//CN_S_ITEM_STATE = checkDtl.CN_S_ITEM_STATE,
                //            CN_F_QUANTITY = 1,
                //            CN_S_MEASURE_UNIT = checkDtl.CN_S_MEASURE_UNIT
                //        };

                //        List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlList = new List<TN_WM_B_TRAY_ITEM_DTLEntity>();
                //        dtlList.Add(new TN_WM_B_TRAY_ITEM_DTLEntity
                //        {
                //            CN_GUID = Guid.NewGuid().ToString(),
                //            CN_PARENT_GUID = trayItemMstExist.CN_GUID,
                //            CN_S_UNIQUE_CODE = checkDtl.CN_S_PACK_CODE,
                //            CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                //            CN_F_QUANTITY = checkDtl.CN_F_QUANTITY,
                //            CN_T_PRODUCTION = DateTime.Now,
                //            CN_T_EXPIRATION = DateTime.Now,
                //            CN_S_NOTE = "盘点新增",
                //            CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                //            CN_T_CREATE = DateTime.Now,
                //            CN_T_MODIFY = DateTime.Now,
                //            CN_S_SERIAL_NO = checkDtl.CN_F_WEIGHT.ToString(),
                //            CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY
                //        });

                //        trayItemMstExist.TrayItemDtlList = dtlList;

                //        var resultExist = CreateDAL<TN_WM_B_TRAY_ITEM_RELDAL>().CheckExists(trayItemMstExist);
                //        if (resultExist.Count > 1)
                //        {
                //            logPara.Push("此处有异常，根据条件获取到多条主表信息，Json条件：" + JsonConvert.SerializeObject(trayItemMstExist));
                //        }

                //        if (resultExist.Any())
                //        {
                //            trayItemMstExist.CN_GUID = resultExist[0].CN_GUID;
                //            //trayItemMstExist.CN_F_QUANTITY = resultExist[0].CN_F_QUANTITY + 1;
                //            foreach (var item in trayItemMstExist.TrayItemDtlList)
                //            {
                //                item.CN_PARENT_GUID = trayItemMstExist.CN_GUID;
                //            }
                //            //mstModList.Add(trayItemMstExist);
                //            //mstDeleteList.Add(trayItemMstExist);
                //        }
                //        //else
                //        //{
                //        mstAddList.Add(trayItemMstExist);

                //        //添加上架记录
                //        //checkAuditPara.upHis.Add(new TN_WM_UP_HISTORYEntity
                //        //{
                //        //    CN_GUID = Guid.NewGuid().ToString(),
                //        //    CN_S_LOCATION_CODE = checkDtl.CN_S_LOCATION_CODE,
                //        //    CN_S_ITEM_STATE = trayItemMstExist.CN_S_ITEM_STATE,
                //        //    CN_S_TRAY_CODE = trayItemMstExist.CN_S_TRAY_CODE,
                //        //    CN_S_TRAY_GRID = trayItemMstExist.CN_S_TRAY_GRID == null ? "" : trayItemMstExist.CN_S_TRAY_GRID,
                //        //    CN_S_ITEM_CODE = trayItemMstExist.CN_S_ITEM_CODE,
                //        //    CN_S_ITEM_NAME = trayItemMstExist.CN_S_ITEM_NAME,
                //        //    CN_S_PRODUCTION_BATCH = trayItemMstExist.CN_S_LOT_NO,
                //        //    CN_F_QUANTITY = checkDtl.CN_F_WEIGHT,
                //        //    CN_S_MODEL = trayItemMstExist.CN_S_MODEL,
                //        //    CN_S_STOCK_AREA = checkDtl.CN_S_STOCK_AREA,
                //        //    CN_S_STOCK_CODE = checkAuditPara.checkMst.CN_S_STOCK_CODE,
                //        //    CN_T_CREATE = DateTime.Now,
                //        //    CN_T_MODIFY = DateTime.Now,
                //        //    CN_S_OWNER = "",
                //        //    CN_S_MEASURE_UNIT = trayItemMstExist.CN_S_MEASURE_UNIT,
                //        //    CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                //        //    CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY,
                //        //    CN_S_MODIFY = "",
                //        //    CN_S_MODIFY_BY = "",
                //        //    CN_S_OP_FROM = "盘点审核-新增",
                //        //    CN_S_EXT1 = checkDtl.CN_S_PACK_CODE,//trayItemMst.CN_S_UNIQUE_CODE,
                //        //    CN_S_EXT2 = "其他入库",
                //        //    CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                //        //    CN_S_FIGURE_NO = checkDtl.CN_S_FIGURE_NO
                //        //});
                //        // }


                //        #endregion
                //    }
                //    if (checkDtl.CN_S_CHECK_RESULT.Equals(CheckStateEnum.D.ToString()))//删除
                //    {
                //        #region 判断主表是否需要删除
                //        var trayItemMst = checkDtl.trayItemMst;
                //        List<TN_WM_B_TRAY_ITEM_DTLEntity> dtlExistList = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetList(new { CN_PARENT_GUID = trayItemMst.CN_GUID });
                //        if (dtlExistList.Count == 1)
                //        {
                //            mstDeleteList.Add(trayItemMst);
                //            dtlDeleteList.Add(dtlExistList[0]);
                //        }
                //        if (dtlExistList.Count > 1)
                //        {
                //            var findDtl = dtlExistList.Where(x => x.CN_S_UNIQUE_CODE == checkDtl.CN_S_PACK_CODE);
                //            dtlDeleteList.AddRange(findDtl);
                //        }
                //        //添加下架记录
                //        checkAuditPara.downHis.Add(new TN_WM_DOWN_HISTORYEntity
                //        {
                //            CN_GUID = Guid.NewGuid().ToString(),
                //            CN_S_LOCATION_CODE = checkDtl.CN_S_LOCATION_CODE,
                //            CN_S_ITEM_STATE = trayItemMst.CN_S_ITEM_STATE,
                //            CN_S_TRAY_CODE = trayItemMst.CN_S_TRAY_CODE,
                //            CN_S_TRAY_GRID = trayItemMst.CN_S_TRAY_GRID == null ? "" : trayItemMst.CN_S_TRAY_GRID,
                //            CN_S_ITEM_CODE = trayItemMst.CN_S_ITEM_CODE,
                //            CN_S_ITEM_NAME = trayItemMst.CN_S_ITEM_NAME,
                //            CN_S_PRODUCTION_BATCH = trayItemMst.CN_S_LOT_NO,
                //            CN_F_QUANTITY = checkDtl.CN_F_WEIGHT,
                //            CN_S_MODEL = trayItemMst.CN_S_MODEL,
                //            CN_S_STOCK_AREA = checkDtl.CN_S_STOCK_AREA,
                //            CN_S_STOCK_CODE = checkAuditPara.checkMst.CN_S_STOCK_CODE,
                //            CN_T_CREATE = DateTime.Now,
                //            CN_T_MODIFY = DateTime.Now,
                //            CN_S_OWNER = "",
                //            CN_S_MEASURE_UNIT = trayItemMst.CN_S_MEASURE_UNIT,
                //            CN_S_CREATOR = checkAuditPara.checkMst.CN_S_CREATOR,
                //            CN_S_CREATOR_BY = checkAuditPara.checkMst.CN_S_CREATOR_BY,
                //            CN_S_MODIFY = "",
                //            CN_S_MODIFY_BY = "",
                //            CN_S_OP_FROM = "盘点审核-删除",
                //            CN_S_EXT1 = checkDtl.CN_S_PACK_CODE,//trayItemMst.CN_S_UNIQUE_CODE,
                //            CN_S_EXT2 = "其它出库",
                //            CN_S_LOT_NO = checkDtl.CN_S_LOT_NO,
                //            CN_S_FIGURE_NO = checkDtl.CN_S_FIGURE_NO
                //        });
                //        #endregion
                //    }
                //    if (checkDtl.CN_S_CHECK_RESULT.Equals(CheckStateEnum.EB.ToString()))//修改前
                //    {

                //        TN_WM_B_TRAY_ITEM_DTLEntity dtlDelete = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetSingleEntity(new { CN_S_UNIQUE_CODE = checkDtl.CN_S_PACK_CODE });

                //        TN_WM_B_TRAY_ITEM_MSTEntity mstDelete = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetSingleEntity(new { CN_GUID = dtlDelete.CN_PARENT_GUID });

                //        dtlDeleteList.Add(dtlDelete);

                //        mstDeleteList.Add(mstDelete);
                //    }
                //}
                #endregion
            }
            #endregion

            logPara.Push("删除料箱已绑定托盘mst：" + JsonConvert.SerializeObject(mstDeleteList));
            logPara.Push("删除料箱已绑定托盘dtl：" + JsonConvert.SerializeObject(dtlDeleteList));
            logPara.Push("新增托盘mst：" + JsonConvert.SerializeObject(mstAddList));
            logPara.Push("新增托盘dtl：" + JsonConvert.SerializeObject(dtlAddList));
            logPara.Push("修改托盘mst增：" + JsonConvert.SerializeObject(mstModAddQtyList));
            logPara.Push("修改托盘mst减：" + JsonConvert.SerializeObject(mstModReduceQtyList));

            #region 执行事务

            var result = UseTransaction(trans =>
            {
                logPara.Push("更新盘点单状态为：" + checkAuditPara.state);
                CreateDAL<DapperDAL<TN_WM_CHECK_MSTEntity>>().Update(new
                {
                    CN_S_STATE = checkAuditPara.state,
                    CN_S_AUDIT_CONTENT = "审核通过！" + checkAuditPara.checkAuditDto.auditContent,
                    CN_S_CURR_ORG_CODE = checkAuditPara.checkAuditDto.checkAuditOrgDto.currentOrgCode,
                    CN_S_CURR_ORG_NAME = checkAuditPara.checkAuditDto.checkAuditOrgDto.currentOrgName,
                    CN_S_NEXT_ORG_CODE = checkAuditPara.checkAuditDto.checkAuditOrgDto.nextOrgCode,
                    CN_S_NEXT_ORG_NAME = checkAuditPara.checkAuditDto.checkAuditOrgDto.nextOrgName,
                }, new { CN_S_OP_NO = checkAuditPara.checkAuditDto.opNo }, trans);

                #region 最终审核

                if (checkAuditPara.isEnd)
                {
                    logPara.Push("降低仓库库存：" + JsonConvert.SerializeObject(checkAuditPara.stockQtys));
                    //降低仓库库存
                    CreateDAL<TN_WM_B_STOCK_QTYDAL>().ReduceStockQty(checkAuditPara.stockQtys, trans);
                    //降低库区库存
                    CreateDAL<TN_WM_B_AREA_QTYDAL>().ReduceAreaQty(checkAuditPara.areaQtys, trans);

                    foreach (var item in trayLocationDeleteList)
                    {
                        //删除托盘货位关联
                        CreateDAL<DapperDAL<TN_WM_B_TRAY_LOCATIONEntity>>().Delete(new { CN_S_TRAY_CODE = item.CN_S_TRAY_CODE, CN_S_LOCATION_CODE = item.CN_S_LOCATION_CODE }, trans);
                        CreateDAL<DapperDAL<TN_WM_LOCATION_EXTEntity>>().Update(new
                        {
                            CN_S_LOCATION_STATE = "正常",
                            CN_S_USE_STATE = "空"
                        }, new
                        {
                            CN_S_LOCATION_CODE = item.CN_S_LOCATION_CODE
                        }, trans);
                    }

                    foreach (var mstEntity in mstDeleteList)
                    {
                        //删除前主表
                        CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().Delete(new { CN_GUID = mstEntity.CN_GUID }, trans);
                    }
                    foreach (var dtlEntity in dtlDeleteList)
                    {
                        //删除前子表
                        CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().Delete(new { CN_PARENT_GUID = dtlEntity.CN_PARENT_GUID, CN_S_UNIQUE_CODE = dtlEntity.CN_S_UNIQUE_CODE }, trans);
                    }

                    //新增主表
                    foreach (var item in mstAddList)
                    {
                        CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().Add(item, trans);
                    }

                    //新增子表
                    foreach (var item in dtlAddList)
                    {
                        CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().Add(item, trans);
                    }

                    //修改数量增
                    foreach (var item in mstModAddQtyList)
                    {
                        CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().Update(new { CN_F_QUANTITY = item.CN_F_QUANTITY + 1 }, new { CN_GUID = item.CN_GUID }, trans);
                    }
                    //修改数量减
                    foreach (var item in mstModReduceQtyList)
                    {
                        CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().Update(new { CN_F_QUANTITY = item.CN_F_QUANTITY - 1 }, new { CN_GUID = item.CN_GUID }, trans);
                    }

                    //释放被锁定货位
                    foreach (var checkDtl in checkAuditPara.checkMst.dtls)
                    {
                        logPara.Push("释放被锁定的货位" + checkDtl.CN_S_LOCATION_CODE);
                        CreateDAL<DapperDAL<TN_WM_LOCATION_EXTEntity>>().Update(new
                        {
                            CN_S_LOCATION_STATE = "正常"
                        }, new
                        {
                            CN_S_LOCATION_CODE = checkDtl.CN_S_LOCATION_CODE
                        }, trans);
                    }

                    //删除list记录，并往历史表中添加
                    AuditAddHistory(checkAuditPara, logPara, trans);

                    //上下架记录
                    CreateDAL<DapperDAL<TN_WM_UP_HISTORYEntity>>().AddRange(checkAuditPara.upHis, trans);
                    CreateDAL<DapperDAL<TN_WM_DOWN_HISTORYEntity>>().AddRange(checkAuditPara.downHis, trans);

                  //  throw new Exception("tedifanhui");
                }

                #endregion
            });

            #endregion

            if (result.Success && checkAuditPara.isEnd)
            {
                //升库存
                AuditAddQty(checkAuditPara, logPara, null);

                //修改装箱数据
                foreach (var checkDtl in checkAuditPara.checkMst.dtls)
                {
                    if (checkDtl.CN_S_CHECK_RESULT.Equals(CheckStateEnum.E.ToString()))//修改后
                    {
                        AutoBomItemEntity itemEntity = CreateDAL<TN_WMS_ITEMDAL>().GetItemEntity(checkDtl.CN_S_ITEM_CODE);
                        bool execResult = CreateDAL<MONGO_PRINT_BARCODEDAL>().UpdateZX(checkDtl.CN_S_PACK_CODE, checkDtl.CN_F_WEIGHT.ToString(),checkDtl.CN_F_PACKING_QTY.ToString(), checkDtl.CN_S_LOT_NO, checkDtl.CN_S_FIGURE_NO, itemEntity);
                        if (!execResult)
                        {
                            logPara.Push("更新装箱信息失败！" + JsonConvert.SerializeObject(checkDtl));
                        }
                    }
                }
            }
            return result;

        }

        /// <summary>
        /// 盘点单审核 - 参数处理
        /// </summary>
        /// <param name="checkAuditPara"></param>
        public OperateResult AuditHandleParam(CheckAuditPara checkAuditPara, LogPara logPara)
        {
            logPara.Push("最终审核");
            checkAuditPara.isEnd = true;
            checkAuditPara.checkMst.dtls = BLLCreator.Create<DapperBLL<TN_WM_CHECK_DTLEntity>>().GetList(new { CN_S_OP_NO = checkAuditPara.checkAuditDto.opNo });
            checkAuditPara.checkMst.dtls = checkAuditPara.checkMst.dtls.Where(e => !e.CN_S_CHECK_RESULT.Equals(CheckStateEnum.ERROR.ToString())).ToList();
            if (checkAuditPara.checkMst.dtls.Count() == 0)
            {
                return OperateResult.Error("盘点单子表不存在数据！");
            }
            else
            {
                checkAuditPara.stockCode = checkAuditPara.checkMst.CN_S_STOCK_CODE;
                checkAuditPara.areaCode = checkAuditPara.checkMst.dtls.FirstOrDefault().CN_S_STOCK_AREA;
            }

            foreach (var dtl in checkAuditPara.checkMst.dtls)
            {
                var trayItemDtl = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetSingleEntity(new { CN_S_UNIQUE_CODE = dtl.CN_S_PACK_CODE });

                if (trayItemDtl != null)
                {
                    var trayItemMst = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetSingleEntity(new { CN_GUID = trayItemDtl.CN_PARENT_GUID });
                    if (trayItemMst != null)
                    {
                        dtl.trayItemMst = trayItemMst;
                    }
                }
                else
                {
                    var trayItemMst = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = dtl.CN_S_TRAY_CODE, CN_S_ITEM_CODE = dtl.CN_S_ITEM_CODE });
                    if (trayItemMst != null)
                    {
                        dtl.trayItemMst = trayItemMst;
                    }
                }
            }
            checkAuditPara.checkLists = CreateDAL<DapperDAL<TN_WM_CHECK_LISTEntity>>().GetList(new { CN_S_OP_NO = checkAuditPara.checkAuditDto.opNo });
            checkAuditPara.upHis = new List<TN_WM_UP_HISTORYEntity>();
            checkAuditPara.downHis = new List<TN_WM_DOWN_HISTORYEntity>();

            return OperateResult.Succeed();
        }

        /// <summary>
        /// 盘点单审核 - 降库存
        /// </summary>
        /// <param name="checkAuditPara"></param>
        public void AuditReduceQty(CheckAuditPara checkAuditPara, LogPara logPara)
        {
            foreach (var dtl in checkAuditPara.checkMst.dtls)
            {
                var trayItemMstData = dtl.trayItemMst;
                if (trayItemMstData == null)
                {
                    logPara.Push("trayItemMstData异常为NULL:" + JsonConvert.SerializeObject(trayItemMstData));
                    continue;
                };

                var trayItemDtls = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetList(new { CN_PARENT_GUID = trayItemMstData.CN_GUID });
                //decimal weight = 0;

                foreach (var trayItemDlt in trayItemDtls)
                {
                   // var weight = Convert.ToDecimal(trayItemDlt.CN_S_SERIAL_NO);
                    //var weight = Convert.ToDecimal(dtl.CN_F_QUANTITY);

                    checkAuditPara.stockQtys.Add(new TN_WM_B_STOCK_QTYEntity()
                    {
                        CN_S_ITEM_CODE = trayItemMstData.CN_S_ITEM_CODE,
                        CN_S_ITEM_NAME = trayItemMstData.CN_S_ITEM_NAME,
                        CN_S_ITEM_STATE = trayItemMstData.CN_S_ITEM_STATE,
                        CN_S_OWNER = trayItemMstData.CN_S_OWNER,
                        CN_S_PRODUCTION_BATCH = string.IsNullOrEmpty(trayItemDtls.FirstOrDefault().CN_S_PRODUCTION_BATCH) ? "" : trayItemDtls.FirstOrDefault().CN_S_PRODUCTION_BATCH,
                        CN_S_LOT_NO = trayItemDlt.CN_S_LOT_NO,
                        CN_F_QUANTITY = Convert.ToDecimal(trayItemDlt.CN_F_PACKING_QTY),
                        CN_S_STOCK_CODE = checkAuditPara.stockCode,//checkAuditPara.checkLists.FirstOrDefault().CN_S_STOCK_CODE,
                        CN_S_STOCK_AREA = checkAuditPara.areaCode,//checkAuditPara.checkLists.FirstOrDefault().CN_S_STOCK_AREA,
                        CN_F_PLANNED_QTY = trayItemMstData.CN_F_INQTY,
                        CN_S_MODEL = trayItemMstData.CN_S_MODEL,
                        CN_S_FIGURE_NO = trayItemDlt.CN_S_EXT1,
                        CN_S_MEASURE_UNIT = trayItemMstData.CN_S_MEASURE_UNIT
                    });
                    checkAuditPara.areaQtys.Add(new TN_WM_B_AREA_QTYEntity()
                    {
                        CN_S_ITEM_CODE = trayItemMstData.CN_S_ITEM_CODE,
                        CN_S_ITEM_NAME = trayItemMstData.CN_S_ITEM_NAME,
                        CN_S_ITEM_STATE = trayItemMstData.CN_S_ITEM_STATE,
                        CN_S_OWNER = trayItemMstData.CN_S_OWNER,
                        CN_S_PRODUCTION_BATCH = string.IsNullOrEmpty(trayItemDtls.FirstOrDefault().CN_S_PRODUCTION_BATCH) ? "" : trayItemDtls.FirstOrDefault().CN_S_PRODUCTION_BATCH,
                        CN_S_LOT_NO = trayItemDlt.CN_S_LOT_NO,
                        CN_F_QUANTITY = Convert.ToDecimal(trayItemDlt.CN_F_PACKING_QTY),
                        CN_S_STOCK_CODE = checkAuditPara.stockCode,//checkAuditPara.checkLists.FirstOrDefault().CN_S_STOCK_CODE,
                        CN_S_STOCK_AREA = checkAuditPara.areaCode,//checkAuditPara.checkLists.FirstOrDefault().CN_S_STOCK_AREA,
                        CN_F_PLANNED_QTY = trayItemMstData.CN_F_INQTY,
                        CN_S_MODEL = trayItemMstData.CN_S_MODEL,
                        CN_S_FIGURE_NO = trayItemDlt.CN_S_EXT1,
                        CN_S_MEASURE_UNIT = trayItemMstData.CN_S_MEASURE_UNIT
                    });
                }
            }

        }


        /// <summary>
        /// 盘点单审核
        /// </summary>
        /// <param name="checkAuditPara"></param>
        /// <param name="logPara"></param>
        /// <param name="trans"></param>
        public void AuditAddHistory(CheckAuditPara checkAuditPara, LogPara logPara, IDbTransaction trans)
        {
            foreach (var checkList in checkAuditPara.checkLists)
            {
                checkAuditPara.checkListHistorys.Add(new TN_WM_CHECK_LIST_HISTORYEntity
                {
                    CN_GUID = Guid.NewGuid().ToString(),
                    CN_S_OP_NO = checkList.CN_S_OP_NO,
                    CN_S_STOCK_CODE = checkList.CN_S_STOCK_CODE,
                    CN_S_STOCK_AREA = checkList.CN_S_STOCK_AREA,
                    CN_S_LOCATION_CODE = checkList.CN_S_LOCATION_CODE,
                    CN_S_TRAY_CODE = checkList.CN_S_TRAY_CODE,
                    CN_S_ITEM_CODE = checkList.CN_S_ITEM_CODE,
                    CN_S_ITEM_NAME = checkList.CN_S_ITEM_NAME,
                    CN_S_ITEM_STATE = checkList.CN_S_ITEM_STATE,
                    CN_S_LOT_NO = checkList.CN_S_LOT_NO,
                    CN_S_CHECK_RESULT = checkList.CN_S_CHECK_RESULT,
                    CN_S_MODEL = checkList.CN_S_MODEL,
                    CN_S_FIGURE_NO = checkList.CN_S_FIGURE_NO,
                    CN_F_QUANTITY = checkList.CN_F_QUANTITY,
                    CN_F_PACKING_QTY = checkList.CN_F_PACKING_QTY,
                    CN_F_WEIGHT = checkList.CN_F_WEIGHT,
                    CN_S_PACK_CODE = checkList.CN_S_PACK_CODE,
                    CN_S_CREATOR = checkList.CN_S_CREATOR,
                    CN_S_CREATOR_BY = checkList.CN_S_CREATOR_BY,
                    CN_T_CREATE = checkList.CN_T_CREATE,
                    CN_S_MODIFY = checkList.CN_S_MODIFY,
                    CN_S_MODIFY_BY = checkList.CN_S_MODIFY_BY,
                    CN_T_MODIFY = checkList.CN_T_MODIFY
                });
            }

            logPara.Push("删除盘点列表记录，添加盘点历史表记录！");
            if (checkAuditPara.checkListHistorys.Count() > 0)
            {
                checkAuditPara.checkListHistorys.ForEach(e => e.CN_GUID = Guid.NewGuid().ToString());
                CreateDAL<DapperDAL<TN_WM_CHECK_LIST_HISTORYEntity>>().AddRange(checkAuditPara.checkListHistorys, trans);
                CreateDAL<DapperDAL<TN_WM_CHECK_LISTEntity>>().Delete(new { CN_S_OP_NO = checkAuditPara.checkAuditDto.opNo }, trans);
            }
        }

        /// <summary>
        /// 盘点单审核 - 升库存
        /// </summary>
        /// <param name="checkAuditPara"></param>
        /// <param name="logPara"></param>
        /// <param name="trans"></param>
        public void AuditAddQty(CheckAuditPara checkAuditPara, LogPara logPara, IDbTransaction trans)
        {
            logPara.Push("统一升库存！");
            var addStockQty = new List<TN_WM_B_STOCK_QTYEntity>();
            var addAreaQty = new List<TN_WM_B_AREA_QTYEntity>();

            List<TN_WM_B_TRAY_ITEM_MSTEntity> trayItemList = new List<TN_WM_B_TRAY_ITEM_MSTEntity>();

            List<TN_WM_CHECK_DTLEntity> dtlList = checkAuditPara.checkMst.dtls;

            List<string> disdtlList = dtlList.Select(x => x.CN_S_TRAY_CODE).Distinct().ToList();
            logPara.Push("去重！" + JsonConvert.SerializeObject(disdtlList));

            foreach (var item in disdtlList)
            {
                List<TN_WM_B_TRAY_ITEM_MSTEntity> mstList = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().GetList(new { CN_S_TRAY_CODE = item });

                if (!mstList.Any())
                {
                    logPara.Push("trayItemList发生异常了！");
                }
                trayItemList.AddRange(mstList);
            }
            logPara.Push("trayItemList！" + JsonConvert.SerializeObject(trayItemList));

            trayItemList.ForEach(dtl =>
            {
                var trayItemMstData = dtl;
                var trayItemDtls = CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_DTLEntity>>().GetList(new { CN_PARENT_GUID = trayItemMstData.CN_GUID });
                //判断如果物料明细为空，则清空托盘物料表，货位置为空
                if (trayItemDtls.Count() == 0)
                {
                    CreateDAL<DapperDAL<TN_WM_B_TRAY_ITEM_MSTEntity>>().Delete(new { CN_GUID = trayItemMstData.CN_GUID });
                }

                //decimal weight = 0;
                foreach (var trayItemDlt in trayItemDtls)
                {
                    var qty = Convert.ToDecimal(trayItemDlt.CN_F_PACKING_QTY);
                    if (qty > 0)
                    {
                        addStockQty.Add(new TN_WM_B_STOCK_QTYEntity()
                        {
                            CN_S_ITEM_CODE = trayItemMstData.CN_S_ITEM_CODE,
                            CN_S_ITEM_NAME = trayItemMstData.CN_S_ITEM_NAME,
                            CN_S_ITEM_STATE = trayItemMstData.CN_S_ITEM_STATE,
                            CN_S_OWNER = trayItemMstData.CN_S_OWNER,
                            CN_S_PRODUCTION_BATCH = trayItemMstData.CN_S_PRODUCTION_BATCH,
                            CN_S_LOT_NO = trayItemDlt.CN_S_LOT_NO,
                            CN_F_QUANTITY = qty,
                            CN_S_STOCK_CODE = checkAuditPara.stockCode,
                            CN_S_STOCK_AREA = checkAuditPara.areaCode,
                            CN_F_PLANNED_QTY = trayItemMstData.CN_F_INQTY,
                            CN_S_MODEL = trayItemMstData.CN_S_MODEL,
                            CN_S_FIGURE_NO = trayItemDlt.CN_S_EXT1,
                            CN_S_MEASURE_UNIT = trayItemMstData.CN_S_MEASURE_UNIT
                        });
                        addAreaQty.Add(new TN_WM_B_AREA_QTYEntity()
                        {
                            CN_GUID = Guid.NewGuid().ToString(),
                            CN_S_ITEM_CODE = trayItemMstData.CN_S_ITEM_CODE,
                            CN_S_ITEM_NAME = trayItemMstData.CN_S_ITEM_NAME,
                            CN_S_ITEM_STATE = trayItemMstData.CN_S_ITEM_STATE,
                            CN_S_OWNER = trayItemMstData.CN_S_OWNER,
                            CN_S_PRODUCTION_BATCH = trayItemMstData.CN_S_PRODUCTION_BATCH,
                            CN_S_LOT_NO = trayItemDlt.CN_S_LOT_NO,
                            CN_F_QUANTITY = qty,
                            CN_S_STOCK_CODE = checkAuditPara.stockCode,
                            CN_S_STOCK_AREA = checkAuditPara.areaCode,
                            CN_F_PLANNED_QTY = trayItemMstData.CN_F_INQTY,
                            CN_S_MODEL = trayItemMstData.CN_S_MODEL,
                            CN_S_FIGURE_NO = trayItemDlt.CN_S_EXT1,
                            CN_S_MEASURE_UNIT = trayItemMstData.CN_S_MEASURE_UNIT
                        });
                    }
                }
            });

            ////统一升库存
            //foreach (var trayItemMstData in checkAuditPara.trayItemMsts)
            //{
            //}

            //增加仓库库存
            logPara.Push("升仓库库存：" + JsonConvert.SerializeObject(addStockQty));
            var qtyResult = CreateDAL<TN_WM_B_STOCK_QTYDAL>().AddStockQty(addStockQty, null);//ReduceStockQty(addStockQty, null);
            logPara.Push("升仓库库存结果：" + qtyResult.Describe());
            qtyResult = CreateDAL<TN_WM_B_AREA_QTYDAL>().AddAreaQty(addAreaQty, null);
            logPara.Push("升库区库存结果：" + qtyResult.Describe());
        }

        /// <summary>
        /// 盘点单反审
        /// </summary>
        /// <param name="checkAuditDto"></param>
        /// <returns></returns>
        public OperateResult ReAudit(CheckAuditDto checkAuditDto, LogPara logPara)
        {
            var state = BillStateEnum.ReAudit.GetDescription();
            var checkMst = BLLCreator.Create<DapperBLL<TN_WM_CHECK_MSTEntity>>().GetSingleEntity(new { CN_S_OP_NO = checkAuditDto.opNo });
            if (checkMst == null)
            {
                return OperateResult.Error("未找到当前盘点单" + checkAuditDto.opNo);
            }
            var result = CreateDAL<DapperDAL<TN_WM_CHECK_MSTEntity>>().Update(new
            {
                CN_S_STATE = state,
                CN_S_AUDIT_CONTENT = checkAuditDto.auditContent,
                CN_S_CURR_ORG_CODE = "",
                CN_S_CURR_ORG_NAME = "",
                CN_S_NEXT_ORG_CODE = "",
                CN_S_NEXT_ORG_NAME = "",
            }, new { CN_S_OP_NO = checkAuditDto.opNo });
            return result;
        }

        #endregion

        #region DELETE

        /// <summary>
        /// 删除盘点单
        /// </summary>
        /// <param name="opNo"></param>
        /// <returns></returns>
        public OperateResult Delete(string opNo, LogPara logPara)
        {
            var checkDtls = BLLCreator.Create<DapperBLL<TN_WM_CHECK_DTLEntity>>().GetList(new { CN_S_OP_NO = opNo });
            var reuslt = UseBasisTransaction(trans =>
            {
                CreateDAL<DapperDAL<TN_WM_CHECK_MSTEntity>>().Delete(new { CN_S_OP_NO = opNo }, trans);
                CreateDAL<DapperDAL<TN_WM_CHECK_DTLEntity>>().Delete(new { CN_S_OP_NO = opNo }, trans);
                CreateDAL<DapperDAL<TN_WM_CHECK_LISTEntity>>().Delete(new { CN_S_OP_NO = opNo }, trans);
                foreach (var checkDtl in checkDtls)
                {
                    logPara.Push("更新货位" + checkDtl.CN_S_LOCATION_CODE + "状态为正常！");
                    CreateDAL<DapperDAL<TN_WM_LOCATION_EXTEntity>>().Update(new { CN_S_LOCATION_STATE = "正常" },
                        new { CN_S_LOCATION_CODE = checkDtl.CN_S_LOCATION_CODE }, trans);
                }
            });
            return OperateResult.Succeed();
        }

        #endregion
    }
}