87 lines
3.4 KiB
C#
87 lines
3.4 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Data;
|
|||
|
|
|
|||
|
|
using WMS.DBUtility;
|
|||
|
|
using WMS.IData.ICK;
|
|||
|
|
using WMS.IData;using Oracle.ManagedDataAccess.Client;
|
|||
|
|
using WMS.Model.CK;
|
|||
|
|
using WMS.Model.Strategy;
|
|||
|
|
using WMS.IData.IStrategy;
|
|||
|
|
|
|||
|
|
namespace WMS.SqlServerData.CKData
|
|||
|
|
{
|
|||
|
|
public class StrAreaRepGoodsData : IStrAreaRepGoods
|
|||
|
|
{
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取库区间定时补货策略商品明细
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns>库区间定时补货策略商品明细</returns>
|
|||
|
|
public DataTable GetStrAreaRepGoodsDT(StrAreaRepGoodsModel model)
|
|||
|
|
{
|
|||
|
|
StringBuilder strSql = new StringBuilder();
|
|||
|
|
|
|||
|
|
strSql.AppendLine("select a.STRATEGY_ID,a.GOODS_ID,b.goods_name,a.STOCK_NUM,a.NUM,a.UNIT ");
|
|||
|
|
strSql.AppendLine(" FROM T_STR_AREAREP_GOODS a");
|
|||
|
|
strSql.AppendLine(" left join t_base_goods b ");
|
|||
|
|
strSql.AppendLine(" on a.goods_id = b.goods_id ");
|
|||
|
|
strSql.AppendLine("where 1 = 1");
|
|||
|
|
if (!string.IsNullOrEmpty(model.STRATEGY_ID))
|
|||
|
|
{
|
|||
|
|
strSql.AppendLine(" and a.STRATEGY_ID = '" + model.STRATEGY_ID + "' ");
|
|||
|
|
}
|
|||
|
|
strSql.AppendLine(" order by a.STRATEGY_ID desc");
|
|||
|
|
|
|||
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 插入库区间定时补货策略商品明细信息
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="StrAreaRepGoodsModel">库区间定时补货策略商品明细Model</param>
|
|||
|
|
/// <returns>库区间定时补货策略商品明细编号</returns>
|
|||
|
|
public void InsertStrAreaRepGoods(StrAreaRepGoodsModel model)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
StringBuilder strSql = new StringBuilder();
|
|||
|
|
strSql.AppendLine("insert into T_STR_AREAREP_GOODS(");
|
|||
|
|
strSql.AppendLine("STRATEGY_ID,GOODS_ID,STOCK_NUM,NUM,UNIT)");
|
|||
|
|
strSql.AppendLine(" values (");
|
|||
|
|
strSql.AppendLine(":STRATEGY_ID,:GOODS_ID,:STOCK_NUM,:NUM,:UNIT)");
|
|||
|
|
OracleParameter[] parameters = {
|
|||
|
|
new OracleParameter(":STRATEGY_ID",OracleDbType.Varchar2,50),
|
|||
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,50),
|
|||
|
|
new OracleParameter(":STOCK_NUM", OracleDbType.Decimal,4),
|
|||
|
|
new OracleParameter(":NUM", OracleDbType.Decimal,4),
|
|||
|
|
new OracleParameter(":UNIT", OracleDbType.Char,1)};
|
|||
|
|
parameters[0].Value = model.STRATEGY_ID;
|
|||
|
|
parameters[1].Value = model.GOODS_ID;
|
|||
|
|
parameters[2].Value = model.STOCK_NUM;
|
|||
|
|
parameters[3].Value = model.NUM;
|
|||
|
|
parameters[4].Value = model.UNIT;
|
|||
|
|
|
|||
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除一个库区间定时补货策略的库区间定时补货策略商品明细
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="STRATEGY_ID">补货策略ID</param>
|
|||
|
|
public void DeleteStrAreaRepGoods(string STRATEGY_ID)
|
|||
|
|
{
|
|||
|
|
StringBuilder strSql = new StringBuilder();
|
|||
|
|
strSql.AppendLine("delete from T_STR_AREAREP_GOODS ");
|
|||
|
|
strSql.AppendLine(" where STRATEGY_ID=:STRATEGY_ID ");
|
|||
|
|
OracleParameter[] parameters = {
|
|||
|
|
new OracleParameter(":STRATEGY_ID",OracleDbType.Varchar2,50) };
|
|||
|
|
parameters[0].Value = STRATEGY_ID;
|
|||
|
|
|
|||
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|