using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using WMS.Model.Base;
using WMS.IData.ISystemManage;
using WMS.IData; 
using WMS.Common;
using WMS.DBUtility;
using WMS.Model.SystemManage;
using Oracle.ManagedDataAccess.Client;

namespace WMS.SqlServerData.SystemManageData
{
    public partial class ProviderRoleData:IProviderRole
	{
		#region  BasicMethod
		/// <summary>
		/// 增加一条数据
		/// </summary>
		public void Add(ProviderRoleModel model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into T_BASE_PROVIDER_ROLE(");
			strSql.Append("PRO_TYPE_ID,PROVIDER_ID,ROLE_ID)");
			strSql.Append(" values (");
			strSql.Append(":PRO_TYPE_ID,:PROVIDER_ID,:ROLE_ID)");
			OracleParameter[] parameters = {
					new OracleParameter(":PRO_TYPE_ID",OracleDbType.Varchar2,20),
					new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2,20),
					new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20)};
			parameters[0].Value = model.PRO_TYPE_ID;
			parameters[1].Value = model.PROVIDER_ID;
			parameters[2].Value = model.ROLE_ID;

            SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
        public void Update(ProviderRoleModel model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update T_BASE_PROVIDER_ROLE set ");
			strSql.Append("PRO_TYPE_ID=:PRO_TYPE_ID,");
			strSql.Append("PROVIDER_ID=:PROVIDER_ID");
			strSql.Append(" where ");
            strSql.Append("ROLE_ID=:ROLE_ID");
			OracleParameter[] parameters = {
					new OracleParameter(":PRO_TYPE_ID",OracleDbType.Varchar2,20),
					new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2,20),
					new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20)};
			parameters[0].Value = model.PRO_TYPE_ID;
			parameters[1].Value = model.PROVIDER_ID;
			parameters[2].Value = model.ROLE_ID;

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

		/// <summary>
		/// 删除一条数据
		/// </summary>
        public void Delete(ProviderRoleModel model)
		{
			//该表无主键信息，请自定义主键/条件字段
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete from T_BASE_PROVIDER_ROLE ");
            strSql.Append(" where ROLE_ID=:ROLE_ID");
            if (!string.IsNullOrEmpty(model.PRO_TYPE_ID))
            {
                strSql.Append(" and PRO_TYPE_ID=:PRO_TYPE_ID");
            } 
            if (!string.IsNullOrEmpty(model.PRO_TYPE_ID))
            {
                strSql.Append(" and PROVIDER_ID=:PROVIDER_ID");
            }
			OracleParameter[] parameters = {
                              new OracleParameter(":ROLE_ID",OracleDbType.Varchar2),
                              new OracleParameter(":PRO_TYPE_ID",OracleDbType.Varchar2,20),
					          new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2,20),
			};
            parameters[0].Value = model.ROLE_ID;
            parameters[1].Value = model.PRO_TYPE_ID;
            parameters[2].Value = model.PROVIDER_ID;

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


		/// <summary>
		/// 获得数据列表
		/// </summary>
        public DataTable GetList(ProviderRoleModel model)
		{
			StringBuilder strSql=new StringBuilder();
            strSql.Append("select ");
            strSql.Append("t.PRO_TYPE_ID,");
            strSql.Append("a.PRO_TYPE_NAME PRO_TYPE_NAME,");
            strSql.Append("t.PROVIDER_ID,");
            strSql.Append("e.PROVIDER_NAME PROVIDER_NAME,");
            strSql.Append("t.ROLE_ID ");
			strSql.Append(" FROM T_BASE_PROVIDER_ROLE t");
            strSql.Append(" LEFT JOIN t_base_provider_dictionary e ON e.PROVIDER_ID = t.PROVIDER_ID");
            strSql.Append(" LEFT JOIN t_base_provider_type a ON a.PRO_TYPE_ID = t.PRO_TYPE_ID");
            strSql.Append(" where 1=1 ");
            if (!string.IsNullOrEmpty(model.ROLE_ID))
            {
                strSql.Append("and  ROLE_ID ='" + model.ROLE_ID + "'");
            }
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
		}
		#endregion  BasicMethod
	}
}