using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WMS.Model.Stock;
using System.Data;
using WMS.IData;
using WMS.Common;
using WMS.Model.Base;

namespace WMS.Business.Stock
{
    public class BussMoveLoc : IBussFactory
    {
        /// <summary>
        /// 修改移位单(包括明细)
        /// </summary>
        /// <param name="MoveLocModel">移位单Model</param>
        /// <param name="listMoveLocTab">明细ModelList</param>
        /// <returns>是否成功</returns>
        public string UpdateMoveLocAndTab(MoveLocModel moveLocModel, List<MoveLocTabModel> listMoveLocTab, List<SKUTabModel> listSKU)
        {
            //修改移位单
            DataProvider.Instance.MoveLoc.UpdateMoveLoc(moveLocModel);
            logList.Add(DataProvider.Instance.logData);

            Transaction = DataProvider.Instance.TranOracle;

            //获取原来的所有明细,减去原来的已占用库存
            MoveLocTabModel tab = new MoveLocTabModel();
            tab.MOVELOC_ID = moveLocModel.MOVELOC_ID;
            DataTable table = DataProvider.Instance.MoveLocTab.GetMoveLocTabDT(tab);
            List<MoveLocTabModel> moveLocTabList = ConvertHelper<MoveLocTabModel>.ConvertToList(table);
            foreach (var item in moveLocTabList)
            {
                MIStockModel mi = new MIStockModel();
                mi.PUTIN_ID = item.PUTIN_ID;
                mi.GOODS_ID = item.GOODS_ID;
                mi.LOCATION_ID = item.OLD_LOC_ID;
                mi.OCCUPY_NUM = -item.PLAN_NUM;
                DataProvider.Instance.MIStock.UpdateMIStockOccupyNum(mi);
                logList.Add(DataProvider.Instance.logData);


                //删除库存占用记录表相应记录
                MIStockOccupyModel queryOccupy = new MIStockOccupyModel();
                queryOccupy.GOODS_ID = mi.GOODS_ID;
                queryOccupy.LOCATION_ID = mi.LOCATION_ID;
                queryOccupy.PUTIN_ID = mi.PUTIN_ID;
                List<MIStockOccupyModel> occupy = ConvertHelper<MIStockOccupyModel>.ConvertToList(DataProvider.Instance.MIStockOccupy.GetMIStockOccupyDT(queryOccupy));
                DataProvider.Instance.MIStockOccupy.DeleteMIStockOccupy(occupy[0]);
                logList.Add(DataProvider.Instance.logData);
            }

            //删除所有明细
            DataProvider.Instance.MoveLocTab.DeleteMoveLocTab(moveLocModel.MOVELOC_ID);
            logList.Add(DataProvider.Instance.logData);

            //增加明细
            foreach (MoveLocTabModel moveLocTabModel in listMoveLocTab)
            {
                DataProvider.Instance.MoveLocTab.InsertMoveLocTab(moveLocTabModel);
                logList.Add(DataProvider.Instance.logData);

                //根据计划数修改已占用库存
                MIStockModel mi = new MIStockModel();
                mi.PUTIN_ID = moveLocTabModel.PUTIN_ID;
                mi.GOODS_ID = moveLocTabModel.GOODS_ID;
                mi.LOCATION_ID = moveLocTabModel.OLD_LOC_ID;
                mi.OCCUPY_NUM = moveLocTabModel.PLAN_NUM;
                DataProvider.Instance.MIStock.UpdateMIStockOccupyNum(mi);
                logList.Add(DataProvider.Instance.logData);

                //写入库存占用记录表
                MIStockModel mistock = ConvertHelper<MIStockModel>.ConvertToList(DataProvider.Instance.MIStock.GetMIStockDT(mi))[0];
                MIStockOccupyModel occupy = new MIStockOccupyModel();
                occupy.AREA_ID = mistock.AREA_ID;
                occupy.DOCCTNUMBER = moveLocTabModel.MOVELOC_ID;
                occupy.GOODS_ID = mistock.GOODS_ID;
                occupy.LOCATION_ID = mistock.LOCATION_ID;
                occupy.OCCUPY_NUM = moveLocTabModel.PLAN_NUM;
                occupy.PUTIN_ID = mistock.PUTIN_ID;
                occupy.STOCK_ID = mistock.STOCK_ID;
                occupy.STORAGE_ID = mistock.STORAGE_ID;
                DataProvider.Instance.MIStockOccupy.InsertMIStockOccupy(occupy);
                logList.Add(DataProvider.Instance.logData);
            }

            if (moveLocModel.STATE == "2")
            {//状态为完成
                List<MIStockModel> hadUpdeteList = new List<MIStockModel>();//已经被修改过的库存记录

                foreach (MoveLocTabModel item in listMoveLocTab)
                {
                    /*操作库存表*/

                    MIStockModel model = new MIStockModel();//出
                    model.LOCATION_ID = item.OLD_LOC_ID;
                    model.GOODS_ID = item.GOODS_ID;
                    model.PUTIN_ID = item.PUTIN_ID;

                    //得到库存记录
                    bool hadMIStock = false;
                    foreach (MIStockModel i in hadUpdeteList)
                    {
                        if (i.LOCATION_ID == model.LOCATION_ID && i.GOODS_ID == model.GOODS_ID && i.PUTIN_ID == model.PUTIN_ID)
                        {
                            hadMIStock = true;
                            model = i;
                            break;
                        }
                    }
                    if (!hadMIStock)
                    {
                        model = ConvertHelper<MIStockModel>.ConvertToList(DataProvider.Instance.MIStock.GetMIStockDT(model))[0];
                    }

                    model.SHELVES_NUM -= item.REAL_NUM;//修改库存记录
                    //model.OCCUPY_NUM -= item.PLAN_NUM;

                    if (model.SHELVES_NUM == 0)
                    { //删该条库存
                        DataProvider.Instance.MIStock.DeleteMIStock(model);
                        logList.Add(DataProvider.Instance.logData);
                    }
                    else
                    {
                        hadUpdeteList.Add(model);//保存修改过的库存记录

                        DataProvider.Instance.MIStock.UpdateMIStock(model);
                        logList.Add(DataProvider.Instance.logData);
                    }


                    //操作库存日志表
                    MIStockBackModel backModel = new MIStockBackModel();//出
                    backModel.AREA_ID = model.AREA_ID;
                    backModel.CHANGE_NUM = model.SHELVES_NUM;
                    backModel.GOODS_ID = model.GOODS_ID;
                    backModel.GOODS_NAME = model.GOODS_NAME;
                    backModel.GOODS_NUM = item.REAL_NUM;
                    backModel.GOODS_TYPEID = model.GOODS_TYPEID;
                    backModel.ID = DataProvider.Instance.MIStockBack.GetSerialNum();
                    backModel.LOCATION_ID = model.LOCATION_ID;
                    backModel.OPERATOR_MAN = moveLocModel.MOVE_PERSON;
                    backModel.OPERATOR_MAN_NAME = moveLocModel.MOVE_PERSON_NAME;
                    backModel.OPERATOR_TYPE = "1";
                    backModel.ORI_NUM = model.SHELVES_NUM + item.REAL_NUM;
                    backModel.OUT_ID = item.MOVELOC_TAB_ID;
                    backModel.PRODUCTION_DATE = model.PRODUCTION_DATE;
                    backModel.REMARK = model.REMARK;
                    backModel.STOCK_ID = model.STOCK_ID;
                    backModel.STORAGE_ID = model.STORAGE_ID;
                    backModel.STORAGE_NAME = model.STORAGE_NAME;
                    backModel.VERSION = model.VERSION;
                    backModel.PUTIN_ID = model.PUTIN_ID;
                    DataProvider.Instance.MIStockBack.AddBMiStockack(backModel);
                    logList.Add(DataProvider.Instance.logData);

                    /*操作库存表*/

                    MIStockModel inModel = new MIStockModel();//入
                    //inModel.LOCATION_ID = item.NEW_LOC_ID;
                    //inModel.GOODS_ID = item.GOODS_ID;

                    ////得到库存记录
                    //hadMIStock = false;
                    //foreach (MIStockModel i in hadUpdeteList)
                    //{
                    //    if (i.LOCATION_ID == inModel.LOCATION_ID && i.GOODS_ID == inModel.GOODS_ID)
                    //    {
                    //        hadMIStock = true;
                    //        inModel = i;
                    //        break;
                    //    }
                    //}
                    //if (!hadMIStock)
                    //{
                    //    List<MIStockModel> nowMIStock = ConvertHelper<MIStockModel>.ConvertToList(DataProvider.Instance.MIStock.GetMIStockDT(inModel));
                    //    if (nowMIStock.Count > 0)//有该记录但没改过
                    //    {
                    //        inModel = nowMIStock[0];
                    //        inModel.SHELVES_NUM += item.REAL_NUM;
                    //        DataProvider.Instance.MIStock.UpdateMIStock(inModel);
                    //        logList.Add(DataProvider.Instance.logData);
                    //    }
                    //    else//没有该记录添加
                    //    {
                    inModel = model;

                    inModel.OCCUPY_NUM = 0;
                    inModel.LOCATION_ID = item.NEW_LOC_ID;
                    inModel.GOODS_ID = item.GOODS_ID;
                    inModel.PUTIN_ID = item.PUTIN_ID;
                    inModel.SHELVES_NUM = item.REAL_NUM;
                    inModel.WARE_DATE = System.DateTime.Now;
                    inModel.DOCCTNUMBER = item.MOVELOC_ID;
                    inModel.STOCK_ID = DataProvider.Instance.MIStock.InsertMIStock(inModel);//////////////////////////////////////////////////
                    logList.Add(DataProvider.Instance.logData);
                    //    }
                    //}
                    //else {//已经改过
                    //    inModel.SHELVES_NUM += item.REAL_NUM;
                    //    DataProvider.Instance.MIStock.UpdateMIStock(inModel);
                    //    logList.Add(DataProvider.Instance.logData);
                    //}

                    //hadUpdeteList.Add(inModel);//保存修改过的库存记录


                    //操作库存日志表
                    backModel = new MIStockBackModel();//入
                    backModel.AREA_ID = inModel.AREA_ID;
                    backModel.CHANGE_NUM = inModel.SHELVES_NUM;
                    backModel.GOODS_ID = inModel.GOODS_ID;
                    backModel.GOODS_NAME = inModel.GOODS_NAME;
                    backModel.GOODS_NUM = item.REAL_NUM;
                    backModel.GOODS_TYPEID = inModel.GOODS_TYPEID;
                    backModel.ID = DataProvider.Instance.MIStockBack.GetSerialNum();
                    backModel.LOCATION_ID = inModel.LOCATION_ID;
                    backModel.OPERATOR_MAN = moveLocModel.MOVE_PERSON;
                    backModel.OPERATOR_MAN_NAME = moveLocModel.MOVE_PERSON_NAME;
                    backModel.OPERATOR_TYPE = "0";
                    backModel.ORI_NUM = inModel.SHELVES_NUM - item.REAL_NUM;
                    backModel.PUTIN_ID = item.PUTIN_ID;
                    backModel.PRODUCTION_DATE = inModel.PRODUCTION_DATE;
                    backModel.REMARK = inModel.REMARK;
                    backModel.STOCK_ID = inModel.STOCK_ID;
                    backModel.STORAGE_ID = inModel.STORAGE_ID;
                    backModel.STORAGE_NAME = inModel.STORAGE_NAME;
                    backModel.VERSION = inModel.VERSION;

                    DataProvider.Instance.MIStockBack.AddBMiStockack(backModel);
                    logList.Add(DataProvider.Instance.logData);

                    //修改库位已占用体积
                    GoodsInfoModel goods = new GoodsInfoModel();
                    Decimal perVo = Convert.ToDecimal(DataProvider.Instance.Goods.GetGoodsDataTable(item.GOODS_ID, "", "", "").Rows[0]["GVOLUME"].ToString());
                    Decimal allVo = 0;
                    allVo = item.REAL_NUM * perVo;
                    if (allVo != 0)
                    {
                        //原库位
                        StorageAreaLocationModel loc = new StorageAreaLocationModel();
                        loc.STORAGE_ID = moveLocModel.STORAGE_ID;
                        loc.LOCATION_ID = item.OLD_LOC_ID;
                        loc = ConvertHelper<StorageAreaLocationModel>.ConvertToList(DataProvider.Instance.StorageAreaLocation.GetLocationInfoDS(loc))[0];

                        loc.HASVOLUME -= allVo;
                        loc.OPERATORID = moveLocModel.MOVE_PERSON;
                        DataProvider.Instance.StorageAreaLocation.UpdateLocHasVolume(loc);
                        logList.Add(DataProvider.Instance.logData);

                        //新库位
                        loc = new StorageAreaLocationModel();
                        loc.STORAGE_ID = moveLocModel.STORAGE_ID;
                        loc.LOCATION_ID = item.NEW_LOC_ID;
                        loc = ConvertHelper<StorageAreaLocationModel>.ConvertToList(DataProvider.Instance.StorageAreaLocation.GetLocationInfoDS(loc))[0];

                        loc.HASVOLUME += allVo;
                        loc.OPERATORID = moveLocModel.MOVE_PERSON;
                        DataProvider.Instance.StorageAreaLocation.UpdateLocHasVolume(loc);
                        logList.Add(DataProvider.Instance.logData);
                    }
                }

              
            }

            //修改规格明细
         
            TaCmtOrRak();
            return ErrText;
        }


        /// <summary>
        /// 新增移位单(包括明细)
        /// </summary>
        /// <param name="MoveLocModel">移位单Model</param>
        /// <param name="listMoveLocTab">明细ModelList</param>
        /// <returns>是否成功</returns>
        public string InsertMoveLocAndTab(MoveLocModel moveLocModel, List<MoveLocTabModel> listMoveLocTab, List<SKUTabModel> listSKU)
        {
            //新增移位单
            moveLocModel.MOVELOC_ID = IBussFactory<WMS.Business.Base.BussDocumentTable>.Instance().GetDocumentStream("移位单");
            DataProvider.Instance.MoveLoc.InsertMoveLoc(moveLocModel);
            logList.Add(DataProvider.Instance.logData);

            Transaction = DataProvider.Instance.TranOracle;

            ////删除所有明细
            //DataProvider.Instance.MoveLocTab.DeleteMoveLocTab(MoveLocModel.MOVELOC_ID);
            //logList.Add(DataProvider.Instance.logData);

            //增加明细
            foreach (MoveLocTabModel moveLocTabModel in listMoveLocTab)
            {
                if (!string.IsNullOrEmpty(moveLocModel.MOVELOC_ID))
                {
                    moveLocTabModel.MOVELOC_ID = moveLocModel.MOVELOC_ID;
                }

                DataProvider.Instance.MoveLocTab.InsertMoveLocTab(moveLocTabModel);
                logList.Add(DataProvider.Instance.logData);

                ////根据计划数修改已占用库存
                //MIStockModel mi = new MIStockModel();
                //mi.PUTIN_ID = moveLocTabModel.PUTIN_ID;
                //mi.GOODS_ID = moveLocTabModel.GOODS_ID;
                //mi.LOCATION_ID = moveLocTabModel.OLD_LOC_ID;
                //mi.OCCUPY_NUM = moveLocTabModel.PLAN_NUM;
                //DataProvider.Instance.MIStock.UpdateMIStockOccupyNum(mi);
                //logList.Add(DataProvider.Instance.logData);

                ////写入库存占用记录表
                //MIStockModel mistock = ConvertHelper<MIStockModel>.ConvertToList(DataProvider.Instance.MIStock.GetMIStockDT(mi))[0];
                //MIStockOccupyModel occupy = new MIStockOccupyModel();
                //occupy.AREA_ID = mistock.AREA_ID;
                //occupy.DOCCTNUMBER = moveLocTabModel.MOVELOC_ID;
                //occupy.GOODS_ID = mistock.GOODS_ID;
                //occupy.LOCATION_ID = mistock.LOCATION_ID;
                //occupy.OCCUPY_NUM = moveLocTabModel.PLAN_NUM;
                //occupy.PUTIN_ID = mistock.PUTIN_ID;
                //occupy.STOCK_ID = mistock.STOCK_ID;
                //occupy.STORAGE_ID = mistock.STORAGE_ID;
                //DataProvider.Instance.MIStockOccupy.InsertMIStockOccupy(occupy);
                //logList.Add(DataProvider.Instance.logData);
            }

        
            TaCmtOrRak();


            #region 新增消息
            MessageModel messModel = new MessageModel();
            messModel.ID = "YW" + DateTime.Now.ToString("yyyyMMddHHmmss") + DataProvider.Instance.Message.GetSerialNum();
            messModel.MENU_FORM = "FrmMoveLoc";
            messModel.MESS_CONTENT = "新增移位单,单据编号:" + moveLocModel.MOVELOC_ID;
            messModel.MESS_DATE = DateTime.Now;
            messModel.MESS_DEP = moveLocModel.STORAGE_ID;
            messModel.MESS_FLAG = "0";
            messModel.MESS_STAR = moveLocModel.CREATE_PERSON;
            messModel.MESS_TO = moveLocModel.MOVE_PERSON;
            messModel.MESS_STATUS = "0";
            messModel.WORK_TYPE = "worktype005";
            messModel.WORK_KIND = "0";
            messModel.MESS_TYPE = "6";
            messModel.RELATIVE_NUMBER = moveLocModel.MOVELOC_ID;
            messModel.STO_ID = moveLocModel.STORAGE_ID;
            DataProvider.Instance.Message.Add(messModel);
            logList.Add(DataProvider.Instance.logData);
            Transaction = DataProvider.Instance.TranOracle;
            TaCmtOrRak();
            #endregion
            return ErrText;
        }
        /// <summary>
        /// 获取移位单结果集
        /// </summary>
        /// <returns>移位单</returns>
        public List<MoveLocModel> GetMoveLocList(MoveLocModel model)
        {
            DataTable table = DataProvider.Instance.MoveLoc.GetMoveLocDT(model);
            List<MoveLocModel> MoveLocModel = ConvertHelper<MoveLocModel>.ConvertToList(table);

            if (DataLogErrWrite(table, "获取移位单"))
            {
                return MoveLocModel;
            }
            return null;
        }

        /// <summary>
        /// 删除移位单信息
        /// </summary>
        /// <param name="MoveLoc">移位单</param>
        /// <returns>是否成功</returns>
        public string DeleteMoveLoc(string MoveLocID)
        {

            DataProvider.Instance.MoveLoc.DeleteMoveLoc(MoveLocID); 

            TaCmtOrRak();
            return ErrText;
        }

        /// <summary>
        /// 删除移位单信息与属于它的商品清单信息
        /// </summary>
        /// <param name="MoveLoc">移位单</param>
        /// <returns>是否成功</returns>
        public string DeleteMoveLocAndTab(string MoveLocID)
        {
            DataProvider.Instance.MoveLoc.DeleteMoveLoc(MoveLocID);
            logList.Add(DataProvider.Instance.logData);

            Transaction = DataProvider.Instance.TranOracle;

            //获取原来的所有明细,减去原来的已占用库存
            MoveLocTabModel tab = new MoveLocTabModel();
            tab.MOVELOC_ID = MoveLocID;
            DataTable table = DataProvider.Instance.MoveLocTab.GetMoveLocTabDT(tab);
            List<MoveLocTabModel> moveLocTabList = ConvertHelper<MoveLocTabModel>.ConvertToList(table);
            foreach (var item in moveLocTabList)
            {
                MIStockModel mi = new MIStockModel();
                mi.PUTIN_ID = item.PUTIN_ID;
                mi.GOODS_ID = item.GOODS_ID;
                mi.LOCATION_ID = item.OLD_LOC_ID;
                mi.OCCUPY_NUM = -item.PLAN_NUM;
                DataProvider.Instance.MIStock.UpdateMIStockOccupyNum(mi);
                logList.Add(DataProvider.Instance.logData);

                //删除库存占用记录表相应记录
                MIStockOccupyModel queryOccupy = new MIStockOccupyModel();
                queryOccupy.GOODS_ID = mi.GOODS_ID;
                queryOccupy.LOCATION_ID = mi.LOCATION_ID;
                queryOccupy.PUTIN_ID = mi.PUTIN_ID;
                List<MIStockOccupyModel> occupy = ConvertHelper<MIStockOccupyModel>.ConvertToList(DataProvider.Instance.MIStockOccupy.GetMIStockOccupyDT(queryOccupy));
                DataProvider.Instance.MIStockOccupy.DeleteMIStockOccupy(occupy[0]);
                logList.Add(DataProvider.Instance.logData);
            }

            DataProvider.Instance.MoveLocTab.DeleteMoveLocTab(MoveLocID);
            logList.Add(DataProvider.Instance.logData); 

            TaCmtOrRak();
            return ErrText;
        }
 
 

        /// <summary>
        /// 修改移位单Status
        /// </summary>
        /// <param name="MoveLocModel">移位单Model</param>
        /// <returns>是否成功</returns>
        public string UpdateMoveLocState(MoveLocModel MoveLocModel)
        {
            //修改移位单Status
            DataProvider.Instance.MoveLoc.UpdateMoveLocState(MoveLocModel);
            logList.Add(DataProvider.Instance.logData);

            Transaction = DataProvider.Instance.TranOracle;

            if (MoveLocModel.STATE == "1")
            {
                MoveLocTabModel m = new MoveLocTabModel();
                m.MOVELOC_ID = MoveLocModel.MOVELOC_ID;
                DataTable table = DataProvider.Instance.MoveLocTab.GetMoveLocTabDT(m);
                List<MoveLocTabModel> list = ConvertHelper<MoveLocTabModel>.ConvertToList(table);

                foreach (var moveLocTabModel in list)
                {
                    //根据计划数修改已占用库存
                    MIStockModel mi = new MIStockModel();
                    mi.PUTIN_ID = moveLocTabModel.PUTIN_ID;
                    mi.GOODS_ID = moveLocTabModel.GOODS_ID;
                    mi.LOCATION_ID = moveLocTabModel.OLD_LOC_ID;
                    mi.OCCUPY_NUM = moveLocTabModel.PLAN_NUM;
                    DataProvider.Instance.MIStock.UpdateMIStockOccupyNum(mi);
                    logList.Add(DataProvider.Instance.logData);

                    //写入库存占用记录表
                    MIStockModel mistock = ConvertHelper<MIStockModel>.ConvertToList(DataProvider.Instance.MIStock.GetMIStockDT(mi))[0];
                    MIStockOccupyModel occupy = new MIStockOccupyModel();
                    occupy.AREA_ID = mistock.AREA_ID;
                    occupy.DOCCTNUMBER = moveLocTabModel.MOVELOC_ID;
                    occupy.GOODS_ID = mistock.GOODS_ID;
                    occupy.LOCATION_ID = mistock.LOCATION_ID;
                    occupy.OCCUPY_NUM = moveLocTabModel.PLAN_NUM;
                    occupy.PUTIN_ID = mistock.PUTIN_ID;
                    occupy.STOCK_ID = mistock.STOCK_ID;
                    occupy.STORAGE_ID = mistock.STORAGE_ID;
                    DataProvider.Instance.MIStockOccupy.InsertMIStockOccupy(occupy);
                    logList.Add(DataProvider.Instance.logData);
                }
            }

            TaCmtOrRak();
            return ErrText;
        }

        /// <summary>
        /// 将已完成的或已关闭的移位单与属于它的移位单明细放到备份表中
        /// </summary>
        /// <param name="moveLocModel">移位单</param>
        /// <returns>是否成功</returns>
        public string MoveMoveLocAndTabIntoBack(MoveLocModel moveLocModel)
        {
            DataProvider.Instance.MoveLoc.UpdateMoveLocState(moveLocModel);
            logList.Add(DataProvider.Instance.logData);

            Transaction = DataProvider.Instance.TranOracle;

            DataProvider.Instance.MoveLoc.InsertMoveLocBack(moveLocModel.MOVELOC_ID);
            logList.Add(DataProvider.Instance.logData);

            DataProvider.Instance.MoveLocTab.InsertMoveLocTabBack(moveLocModel.MOVELOC_ID);
            logList.Add(DataProvider.Instance.logData);

            DataProvider.Instance.MoveLoc.DeleteMoveLoc(moveLocModel.MOVELOC_ID);
            logList.Add(DataProvider.Instance.logData);

            //获取原来的所有明细,减去原来的已占用库存
            MoveLocTabModel tab = new MoveLocTabModel();
            tab.MOVELOC_ID = moveLocModel.MOVELOC_ID;
            DataTable table = DataProvider.Instance.MoveLocTab.GetMoveLocTabDT(tab);
            List<MoveLocTabModel> moveLocTabList = ConvertHelper<MoveLocTabModel>.ConvertToList(table);
            foreach (var item in moveLocTabList)
            {
                MIStockModel mi = new MIStockModel();
                mi.PUTIN_ID = item.PUTIN_ID;
                mi.GOODS_ID = item.GOODS_ID;
                mi.LOCATION_ID = item.OLD_LOC_ID;
                mi.OCCUPY_NUM = -item.PLAN_NUM;
                DataProvider.Instance.MIStock.UpdateMIStockOccupyNum(mi);
                logList.Add(DataProvider.Instance.logData);

                //删除库存占用记录表相应记录
                MIStockOccupyModel queryOccupy = new MIStockOccupyModel();
                queryOccupy.GOODS_ID = mi.GOODS_ID;
                queryOccupy.LOCATION_ID = mi.LOCATION_ID;
                queryOccupy.PUTIN_ID = mi.PUTIN_ID;
                List<MIStockOccupyModel> occupy = ConvertHelper<MIStockOccupyModel>.ConvertToList(DataProvider.Instance.MIStockOccupy.GetMIStockOccupyDT(queryOccupy));
                DataProvider.Instance.MIStockOccupy.DeleteMIStockOccupy(occupy[0]);
                logList.Add(DataProvider.Instance.logData);
            }

            DataProvider.Instance.MoveLocTab.DeleteMoveLocTab(moveLocModel.MOVELOC_ID);
            logList.Add(DataProvider.Instance.logData);

     
            TaCmtOrRak();
            return ErrText;
        }


        /// <summary>
        /// 打印完成
        /// </summary>
        /// <param name="model">移位单</param>
        /// <returns>是否成功</returns>
        public string PrintOK(MoveLocModel model)
        {
            //修改捡货单打印次数
            model.PRINT_COUNT += 1;
            DataProvider.Instance.MoveLoc.UpdateMoveLoc(model);
            logList.Add(DataProvider.Instance.logData); 
            TaCmtOrRak();
            return ErrText;
        }
    }
}