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;
|
}
|
}
|
}
|
