using Rhea.Common;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using Tiger.Business.SqlSugarHepler;
using Tiger.IBusiness;
using Tiger.Model;
using Tiger.Model.Entitys.WMS.DTOS;
using Tiger.Model.Extensions;

namespace Tiger.Business.WMS
{
    /// <summary>
    ///
    /// </summary>
    public class ReworkBusiness : IReworkBusiness
    {
        /// <summary>
        /// 重工
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        /// <exception cref="NotImplementedException"></exception>
        public int ReworkData(List<string> input)
        {
            var DB = Biz.DataSource["WMS57"].Client;
            var itemData = DB.Queryable<WMS_ITEM>().Where(i => input.Contains(i.SN)).ToList();// 查询库存信息数据

            if (!itemData.Any())
            {
                return 0;
            }
            foreach (var item in itemData)
            {
                item.CREATE_TIME = DateTime.Now;
            }
            var itemhisData = itemData.ToObject<List<WMS_ITEM_HIS>>();// 实体映射
            foreach (var item in itemhisData)
            {
                item.STATUS = 110;
            }

            var pkgData = DB.Queryable<WMS_ITEM_PKG>().Where(i => input.Contains(i.SN)).ToList();

            int res = 0;
            BizSqlsugar.CreateTran(() =>
            {
                if (itemData.Any())
                {
                    DB.Deleteable(itemData).ExecuteCommand();// 删除库存信息数据
                }
                if (itemhisData.Any())
                {
                    res = BizSqlsugar.InsertDataTable(itemhisData, DB);// 库存历史添加数据
                }
                if (pkgData.Any())
                {
                    DB.Deleteable(pkgData).ExecuteCommand();// 删除包装信息数据
                }
            }, DB);

            return res;
        }
    }
}