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

    }
}