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 DownStyctsData : IDownStycts
|
|
{
|
|
/// <summary>
|
|
/// 获取下架策略明细
|
|
/// </summary>
|
|
/// <returns>下架策略明细</returns>
|
|
public DataTable GetDownStyctsDT(DownStyctsModel model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
strSql.Append("select DOWNSTRATEGY_ID,STORAGE_ID,STORAGE_AREA_ID,VC_DICTIONARY_ID,GOODS_TYPE_ID,PRO_TYPE_ID ");
|
|
strSql.Append(" FROM T_DOWNSTYCTS ");
|
|
strSql.AppendLine("where 1 = 1");
|
|
if (!string.IsNullOrEmpty(model.DOWNSTRATEGY_ID))
|
|
{
|
|
strSql.AppendLine(" and DOWNSTRATEGY_ID = '" + model.DOWNSTRATEGY_ID + "' ");
|
|
}
|
|
strSql.AppendLine(" order by DOWNSTRATEGY_ID desc");
|
|
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|
}
|
|
|
|
/// <summary>
|
|
/// 插入下架策略明细信息
|
|
/// </summary>
|
|
/// <param name="DownStyctsModel">下架策略明细Model</param>
|
|
/// <returns>下架策略明细编号</returns>
|
|
public void InsertDownStycts(DownStyctsModel model)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("insert into T_DOWNSTYCTS(");
|
|
strSql.Append("DOWNSTRATEGY_ID,STORAGE_ID,STORAGE_AREA_ID,VC_DICTIONARY_ID,GOODS_TYPE_ID,PRO_TYPE_ID)");
|
|
strSql.Append(" values (");
|
|
strSql.Append(":DOWNSTRATEGY_ID,:STORAGE_ID,:STORAGE_AREA_ID,:VC_DICTIONARY_ID,:GOODS_TYPE_ID,:PRO_TYPE_ID)");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":DOWNSTRATEGY_ID",OracleDbType.Varchar2,50),
|
|
new OracleParameter(":STORAGE_ID",OracleDbType.Varchar2,50),
|
|
new OracleParameter(":STORAGE_AREA_ID",OracleDbType.Varchar2,50),
|
|
new OracleParameter(":VC_DICTIONARY_ID",OracleDbType.Varchar2,50),
|
|
new OracleParameter(":GOODS_TYPE_ID",OracleDbType.Varchar2,50),
|
|
new OracleParameter(":PRO_TYPE_ID",OracleDbType.Varchar2,50)};
|
|
parameters[0].Value = model.DOWNSTRATEGY_ID;
|
|
parameters[1].Value = model.STORAGE_ID;
|
|
parameters[2].Value = model.STORAGE_AREA_ID;
|
|
parameters[3].Value = model.VC_DICTIONARY_ID;
|
|
parameters[4].Value = model.GOODS_TYPE_ID;
|
|
parameters[5].Value = model.PRO_TYPE_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除一个下架策略的下架策略商品明细
|
|
/// </summary>
|
|
/// <param name="DOWNSTRATEGY_ID">下架策略ID</param>
|
|
public void DeleteDownStycts(string DOWNSTRATEGY_ID)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("delete from T_DOWNSTYCTS ");
|
|
strSql.Append(" where DOWNSTRATEGY_ID=:DOWNSTRATEGY_ID ");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":DOWNSTRATEGY_ID",OracleDbType.Varchar2,50) };
|
|
parameters[0].Value = DOWNSTRATEGY_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
|
|
}
|
|
}
|