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 StrAreaRepStorageData : IStrAreaRepStorage
    {
        /// <summary>
        /// 获取库区间定时补货策略仓库库区明细
        /// </summary>
        /// <returns>库区间定时补货策略仓库库区明细</returns>
        public DataTable GetStrAreaRepStorageDT(StrAreaRepStorageModel model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.AppendLine("select STORAGE_ID,OUT_AREA_ID,IN_AREA_ID,STRATEGY_ID ");
            strSql.AppendLine(" FROM T_STR_AREAREP_STORAGE ");
            strSql.AppendLine("where 1 = 1");
            if (!string.IsNullOrEmpty(model.STRATEGY_ID))
            {
                strSql.AppendLine(" and STRATEGY_ID = '" + model.STRATEGY_ID + "' ");
            }
            strSql.AppendLine(" order by STRATEGY_ID desc");

            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }

        /// <summary>
        /// 插入库区间定时补货策略仓库库区明细信息
        /// </summary>
        /// <param name="StrAreaRepStorageModel">库区间定时补货策略仓库库区明细Model</param>
        /// <returns>库区间定时补货策略仓库库区明细编号</returns>
        public void InsertStrAreaRepStorage(StrAreaRepStorageModel model)
        {
            
            StringBuilder strSql = new StringBuilder();
            strSql.AppendLine("insert into T_STR_AREAREP_STORAGE(");
            strSql.AppendLine("STORAGE_ID,OUT_AREA_ID,IN_AREA_ID,STRATEGY_ID)");
            strSql.AppendLine(" values (");
            strSql.AppendLine(":STORAGE_ID,:OUT_AREA_ID,:IN_AREA_ID,:STRATEGY_ID)");
            OracleParameter[] parameters = {
					new OracleParameter(":STORAGE_ID",OracleDbType.Varchar2,50),
					new OracleParameter(":OUT_AREA_ID",OracleDbType.Varchar2,50),
					new OracleParameter(":IN_AREA_ID",OracleDbType.Varchar2,50),
					new OracleParameter(":STRATEGY_ID",OracleDbType.Varchar2,50)};
            parameters[0].Value = model.STORAGE_ID;
            parameters[1].Value = model.OUT_AREA_ID;
            parameters[2].Value = model.IN_AREA_ID;
            parameters[3].Value = model.STRATEGY_ID;

            SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);

        }

        /// <summary>
        /// 删除一个库区间定时补货策略的库区间定时补货策略商品明细
        /// </summary>
        /// <param name="STRATEGY_ID">补货策略ID</param>
        public void DeleteStrAreaRepStorage(string STRATEGY_ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.AppendLine("delete from T_STR_AREAREP_STORAGE ");
            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); 
        }

    }
}