using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WMS.IData;using Oracle.ManagedDataAccess.Client;
using System.Data;

using WMS.DBUtility;
using WMS.Model.Base;
using WMS.IData.IBase;

namespace WMS.SqlServerData.BaseData
{
    public class LocAreaData : ILocArea
    {
        #region 获取库区库位关联
        /// <summary>
        /// 获取库区库位关联
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public DataTable GetLocAreaDT(LocAreaModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.AppendLine("select a.STORAGE_AREA_ID,a.LOCATION_ID,b.storage_area_name");
            strSql.AppendLine(" FROM T_BASE_LOC_AREA a left join t_base_storage_area b on a.storage_area_id = b.storage_area_id");
            strSql.AppendLine("where 1=1");
            if (!string.IsNullOrEmpty(model.STORAGE_AREA_ID))
            {
                strSql.AppendLine(" and a.STORAGE_AREA_ID = '" + model.STORAGE_AREA_ID + "' ");
            }
            if (!string.IsNullOrEmpty(model.LOCATION_ID))
            {
                strSql.AppendLine(" and a.LOCATION_ID = '" + model.LOCATION_ID + "' ");
            }

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

        /// <summary>
        /// 插入库区库位关联信息
        /// </summary>
        /// <param name="LocAreaModel">库区库位关联Model</param>
        public void InsertLocArea(LocAreaModel model)
        {
            StringBuilder strSql = new StringBuilder();

            //if (string.IsNullOrEmpty(model.STORAGE_AREA_ID))
            //{

            //}
            //else
            //{

            strSql.Append("insert into T_BASE_LOC_AREA(");

            strSql.Append("STORAGE_AREA_ID,LOCATION_ID,STORAGE_ID)");

            strSql.Append(" values (");

            strSql.Append(":STORAGE_AREA_ID,:LOCATION_ID,:STORAGE_ID)");

            OracleParameter[] parameters = {
					new OracleParameter(":STORAGE_AREA_ID",OracleDbType.Varchar2),
					new OracleParameter(":LOCATION_ID",OracleDbType.Varchar2),
                     new OracleParameter(":STORAGE_ID",OracleDbType.Varchar2)};

            parameters[0].Value = model.STORAGE_AREA_ID; 
            parameters[1].Value = model.LOCATION_ID;
            parameters[2].Value = model.STORAGE_ID;
            SystemDataObject.Instance.ExecuteSqlCommit(strSql.ToString(), parameters);
            //}

        }

        /// <summary>
        /// 删除库区库位关联
        /// </summary>
        /// <param name="ID"></param>
        public void DeleteLocArea(LocAreaModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_BASE_LOC_AREA ");
            strSql.AppendLine("where 1=1");
            if (!string.IsNullOrEmpty(model.STORAGE_AREA_ID))
            {
                strSql.AppendLine(" and STORAGE_AREA_ID = '" + model.STORAGE_AREA_ID + "' ");
            }
            if (!string.IsNullOrEmpty(model.LOCATION_ID))
            {
                strSql.AppendLine(" and LOCATION_ID = '" + model.LOCATION_ID + "' ");
            }

            SystemDataObject.Instance.ExecuteSql(strSql.ToString());
        }

    }
}