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

namespace WMS.Business.Stock
{
    public class BussAdjustList : IBussFactory
    {
        #region 查询库存调整单信息
        /// <summary>
        /// 查询库存调整单
        /// </summary>
        /// <param name="model"></param>
        /// <returns>实体集合</returns>
        public List<AdjustListModel> GetAdjustList(AdjustListModel model)
        {
            DataTable dt = DataProvider.Instance.AdjustList.GetAdjustList(model);
            List<AdjustListModel> list = ConvertHelper<AdjustListModel>.ConvertToList(dt);

            return list;
        }
        #endregion

        #region 新增或修改
        /// <summary>
        /// 新增或修改
        /// </summary>
        /// <param name="mode">mode 实体</param>
        /// <param name="flg">工作标志 flg 0 新增，1 修改</param>
        public string ExecInsertUpdate(AdjustListModel mode, int flg)
        {
            Transaction = DataProvider.Instance.TranOracle;

            if (flg == 0)
            {
                DataProvider.Instance.AdjustList.ExecListAdd(mode);
            }
            else
            {
                DataProvider.Instance.AdjustList.ExecListUpdate(mode);
            }

            logList.Add(DataProvider.Instance.logData);
            TaCmtOrRak();
            return this.ErrText;
        }
        #endregion

        #region 新增或修改(主表明细表同一个事务)
        /// <summary>
        /// 新增或修改
        /// </summary>
        /// <param name="mode">主表</param>
        /// <param name="list">明细实体集合</param>
        /// <param name="flg">操作标志 0 新增，1 修改</param>
        /// <returns></returns>
        public string InsertUpdate(AdjustListModel mode, List<AdjustListInfoModel> list, int flg,ref string listId)
        {
          

            if (flg == 0)//新增
            {
                #region 盘点单Status改成已调整
                //获取流水号
              
                if (mode.List_reason == "0" && !string.IsNullOrEmpty(mode.Count_id))
                {
                    CountingModel countModel = new CountingModel();
                    countModel.COUNT_ID = mode.Count_id;
                    countModel.COUNT_STATUS = "5";
                    DataProvider.Instance.Counting.Update(countModel);
                }
                #endregion
            
                Transaction = DataProvider.Instance.TranOracle;
               // DataProvider.Instance.Message.Add(messModel);
                foreach (AdjustListInfoModel model in list)
                {
                    model.LIST_ID = listId;
                    DataProvider.Instance.AdjustListInfo.ExecListAdd(model);
                }
            }
            else//修改
            {
                //先删除之前的表
                AdjustListInfoModel mode_info = new AdjustListInfoModel();
                mode_info.LIST_ID = mode.List_id;
                DataProvider.Instance.AdjustListInfo.DelList(mode_info);
                Transaction = DataProvider.Instance.TranOracle;
                //修改主表和插入新的明细
                DataProvider.Instance.AdjustList.ExecListUpdate(mode);
                foreach (AdjustListInfoModel model in list)
                {
                    DataProvider.Instance.AdjustListInfo.ExecListAdd(model);
                }
            }

            logList.Add(DataProvider.Instance.logData);
            TaCmtOrRak();

            return this.ErrText;
        }
        #endregion

        #region 库存调整单审核
        /// <summary>
        /// 库存调整单审核
        /// </summary>
        /// <param name="adListmodel"></param>
        /// <param name="userID"></param>
        /// <returns></returns>
        public string Check(AdjustListModel adListmodel, string userID)
        {
            Transaction = DataProvider.Instance.TranOracle;
            DateTime dt_now = System.DateTime.Now.Date;

            #region 修改库存调整单状态

            adListmodel.Status = "2";
            adListmodel.List_checkdate = dt_now;
            adListmodel.List_checkper = userID;
            DataProvider.Instance.AdjustList.Check(adListmodel);

            #endregion

            //查出调整单明细
            AdjustListInfoModel adinfo_model = new AdjustListInfoModel();
            adinfo_model.LIST_ID = adListmodel.List_id;
            List<AdjustListInfoModel> adinfo_list = ConvertHelper<AdjustListInfoModel>.ConvertToList(DataProvider.Instance.AdjustListInfo.GetAdjustList(adinfo_model));


            //库存实体、库位实体、商品实体
            MIStockModel stoc = new MIStockModel();
            StorageAreaLocationModel stoc_loc = new StorageAreaLocationModel();
            GoodsInfoModel goods = new GoodsInfoModel();


            foreach (AdjustListInfoModel _ad_info in adinfo_list)
            {
                //调整数量为0 的过滤
                if (_ad_info.LIST_INFO_COUNT == 0)
                {
                    continue;
                }

                #region 修改库存

                stoc = new MIStockModel();
                stoc.STORAGE_ID = _ad_info.Storage_id;
                stoc.AREA_ID = _ad_info.Area_id;
                stoc.LOCATION_ID = _ad_info.LOC_ID;
                stoc.GOODS_ID = _ad_info.LIST_INFO_GOODSID;
                stoc.PROVIDER_NAME = _ad_info.PUTIN_ID;
                //查询库存实体
                DataTable dt_Stock = DataProvider.Instance.MIStock.GetMIStockDT(stoc);
                stoc = ConvertHelper<MIStockModel>.ConvertToList(dt_Stock)[0];

                //修改库存数量
                stoc.SHELVES_NUM = _ad_info.NEWCOUNT;
                DataProvider.Instance.MIStock.UpdateMIStock(stoc);

                #endregion

                #region 插入库存日志

                MIStockBackModel back_model = new MIStockBackModel();

                back_model.ID = DataProvider.Instance.MIStockBack.GetSerialNum();
                back_model.STOCK_ID = stoc.STOCK_ID;
                back_model.STORAGE_ID = _ad_info.Storage_id;
                back_model.AREA_ID = _ad_info.Area_id;
                back_model.LOCATION_ID = _ad_info.LOC_ID;
                back_model.GOODS_TYPEID = _ad_info.Goods_typeid;
                back_model.GOODS_ID = _ad_info.LIST_INFO_GOODSID;
                back_model.ORI_NUM = _ad_info.Oldcount;
                back_model.CHANGE_NUM = _ad_info.NEWCOUNT;//改变后数量
                back_model.GOODS_NUM = _ad_info.LIST_INFO_COUNT;
                back_model.OPERATOR_DATE = dt_now;
                back_model.OPERATOR_MAN = userID;
                back_model.PRODUCTION_DATE = _ad_info.Production_date;
                back_model.OPERATOR_TYPE = "2";//库存调整
                back_model.REMARK = "库存调整";

                DataProvider.Instance.MIStockBack.AddBMiStockack(back_model);

                #endregion

                #region 修改库位占用面积

                //查询商品单位体积
                Decimal goods_Volume = Convert.ToDecimal(DataProvider.Instance.Goods.GetGoodsDataTable(_ad_info.LIST_INFO_GOODSID, "", "", "").Rows[0]["GVOLUME"].ToString());
                stoc_loc = new StorageAreaLocationModel();
                stoc_loc.STORAGE_ID = back_model.STORAGE_ID;
                stoc_loc.STORAGE_AREA_ID = back_model.AREA_ID;
                stoc_loc.LOCATION_ID = back_model.LOCATION_ID;
                stoc_loc.HASVOLUME = back_model.CHANGE_NUM * goods_Volume;

                DataProvider.Instance.StorageAreaLocation.UpdateLocHasVolume(stoc_loc);
                #endregion
            }

            logList.Add(DataProvider.Instance.logData);
            TaCmtOrRak();

            return this.ErrText;
        }
        #endregion

        #region 删除库存调整单
        /// <summary>
        /// 删除库存调整单(明细一起删除掉)
        /// </summary>
        /// <param name="model">model 实体</param>
        /// <returns>影响行数</returns>
        public string DelList(AdjustListModel model)
        {
            Transaction = DataProvider.Instance.TranOracle;

            DataProvider.Instance.AdjustList.DelList(model);

            //删除明细
            AdjustListInfoModel info_model = new AdjustListInfoModel();
            info_model.LIST_ID = model.List_id;
            //主表
            DataProvider.Instance.AdjustListInfo.DelList(info_model);


            logList.Add(DataProvider.Instance.logData);
            TaCmtOrRak();

            return this.ErrText;
        }
        #endregion
    }
}