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

    }
}