211 lines
6.8 KiB
C#
211 lines
6.8 KiB
C#
|
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using WMS.Model.Strategy;
|
|||
|
|
using System.Data;
|
|||
|
|
using WMS.IData;
|
|||
|
|
using WMS.Common;
|
|||
|
|
|
|||
|
|
namespace WMS.Business.Strategy
|
|||
|
|
{
|
|||
|
|
public class BussProRepStrategy : IBussFactory
|
|||
|
|
{
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获得策略流水号
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string GetNextValNum()
|
|||
|
|
{
|
|||
|
|
return DataProvider.Instance.ProRepStrategy.GetNextValNum();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#region 单独操作主表
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获得供应商补货策略信息集
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public List<ProRepStrategyModel> GetProRepStrategyData(ProRepStrategyModel model)
|
|||
|
|
{
|
|||
|
|
DataTable dt = DataProvider.Instance.ProRepStrategy.GetProRepStrategyData(model);
|
|||
|
|
List<ProRepStrategyModel> list = null;
|
|||
|
|
|
|||
|
|
if (DataLogErrWrite(dt, "获得供应商补货策略主表数据"))
|
|||
|
|
{
|
|||
|
|
list = ConvertHelper<ProRepStrategyModel>.ConvertToList(dt);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return list;
|
|||
|
|
}
|
|||
|
|
return list;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 新增供应商补货策略
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model"></param>
|
|||
|
|
public string AddProRepStrategyData(ProRepStrategyModel model)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.AddProRepStrategyData(model);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 修改供应商补货策略
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model"></param>
|
|||
|
|
public string UpdateProRepStrategyData(ProRepStrategyModel model)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.UpdateProRepStrategyData(model);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除供应商策略补货明细
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="strategyID"></param>
|
|||
|
|
public string DelProRepStrategyData(string strategyID)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.DelProRepStrategyData(strategyID);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
#region 同时操作主表明细表
|
|||
|
|
/// <summary>
|
|||
|
|
/// 同时新增主表明细数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model"></param>
|
|||
|
|
/// <param name="list"></param>
|
|||
|
|
public string InsertStrategyDataAndInfo(ProRepStrategyModel model, List<ProRepStrategyInfoModel> list)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.InsertStrategyDataAndInfo(model, list);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 同时修改主表明细表数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model"></param>
|
|||
|
|
/// <param name="list"></param>
|
|||
|
|
public string UpdateStrategyDataAndInfo(ProRepStrategyModel model, List<ProRepStrategyInfoModel> list)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.UpdateStrategyDataAndInfo(model, list);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 根据策略编号 同时删除主表明细表数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="strategy_id"></param>
|
|||
|
|
public string DeleteStrategyDataAndInfo(string strategy_id)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.DeleteStrategyDataAndInfo(strategy_id);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
#region 单独操作明细表
|
|||
|
|
/// <summary>
|
|||
|
|
/// 查明细
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public List<ProRepStrategyInfoModel> GetProRepInfoData(ProRepStrategyInfoModel model)
|
|||
|
|
{
|
|||
|
|
DataTable dt = DataProvider.Instance.ProRepStrategy.GetProRepInfoData(model);
|
|||
|
|
List<ProRepStrategyInfoModel> list = null;
|
|||
|
|
if (DataLogErrWrite("查询供应商补货策略明细数据"))
|
|||
|
|
{
|
|||
|
|
list = ConvertHelper<ProRepStrategyInfoModel>.ConvertToList(dt);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return list;
|
|||
|
|
}
|
|||
|
|
return list;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 增加策略明细数据
|
|||
|
|
/// </summary>
|
|||
|
|
public string AddStrategyInfo(List<ProRepStrategyInfoModel> model)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.AddStrategyInfo(model);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 更新策略明细数据
|
|||
|
|
/// </summary>
|
|||
|
|
public string UpdateStrategyInfo(List<ProRepStrategyInfoModel> model)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.UpdateStrategyInfo(model);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除策略明细数据
|
|||
|
|
/// </summary>
|
|||
|
|
public string DeleteStrategyInfo(string STRATEGY_ID, string STORAGE_ID)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProRepStrategy.DeleteStrategyInfo(STRATEGY_ID, STORAGE_ID);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 检验编号的唯一性
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="strategyID"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string Exists(string strategyID)
|
|||
|
|
{
|
|||
|
|
string strResult = DataProvider.Instance.ProRepStrategy.Exists(strategyID);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return strResult;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|