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

using WMS.IData.ISystemManage;

namespace WMS.SqlServerData.SystemManageData
{
    public class RoleDictionaryData : IRoleDictionary
    {

        /// <summary>
        /// 获得数据列表
        /// </summary>
        /// <param name="model">角色维护Model</param>
        /// <returns></returns>
        public DataTable GetRoleDictionaryListData(RoleDictionaryModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ROLE_ID,ROLE_NAME,ROLE_DESC ");
            strSql.Append(" FROM T_BASE_ROLEDICTIONARY WHERE 1 = 1 ");
            if (!string.IsNullOrEmpty(model.ROLE_ID))
            {
                strSql.Append(" and ROLE_ID = '" + model.ROLE_ID + "'");
            }
            strSql.Append(" order by ROLE_ID desc");
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }


        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="ROLE_ID">角色ID</param>
        /// <returns></returns>
        public string ExistsRoleDictionary(string ROLE_ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from T_BASE_ROLEDICTIONARY");
            strSql.Append(" where ROLE_ID='" + ROLE_ID + "'");
            DataTable table = SystemDataObject.Instance.GetDataTable(strSql.ToString());

            if (table != null)
            {
                if (table.Rows.Count > 0)
                {
                    return table.Rows[0][0].ToString();
                }
            }
            return "0";
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <param name="model">角色维护Model</param>
        public void AddRoleDictionary(RoleDictionaryModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_BASE_ROLEDICTIONARY(");
            strSql.Append("ROLE_ID,ROLE_NAME,ROLE_DESC)");
            strSql.Append(" values (");
            strSql.Append(":ROLE_ID,:ROLE_NAME,:ROLE_DESC)");
            OracleParameter[] parameters = {
					new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20),
					new OracleParameter(":ROLE_NAME",OracleDbType.Varchar2,30),
					new OracleParameter(":ROLE_DESC",OracleDbType.Varchar2,300)};
            parameters[0].Value = model.ROLE_ID;
            parameters[1].Value = model.ROLE_NAME;
            parameters[2].Value = model.ROLE_DESC;

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


        /// <summary>
        /// 增加多条数据
        /// </summary>
        /// <param name="list"></param>
        public void AddRoleDictionaryList(List<RoleDictionaryModel> list)
        {
            List<string> sqlstrlist = new List<string>();
            List<OracleParameter[]> sqlstrpara = new List<OracleParameter[]>();
            StringBuilder strSql = new StringBuilder();
            foreach (RoleDictionaryModel model in list)
            {
                strSql.Append("insert into T_BASE_ROLEDICTIONARY(");
                strSql.Append("ROLE_ID,ROLE_NAME,ROLE_DESC)");
                strSql.Append(" values (");
                strSql.Append(":ROLE_ID,:ROLE_NAME,:ROLE_DESC)");
                OracleParameter[] parameters = {
					new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20),
					new OracleParameter(":ROLE_NAME",OracleDbType.Varchar2,30),
					new OracleParameter(":ROLE_DESC",OracleDbType.Varchar2,300)};
                parameters[0].Value = model.ROLE_ID;
                parameters[1].Value = model.ROLE_NAME;
                parameters[2].Value = model.ROLE_DESC;
                sqlstrlist.Add(strSql.ToString());
                sqlstrpara.Add(parameters);
                strSql.Clear();
            }
           // SystemDataObject.Instance.ExecuteList(sqlstrlist, sqlstrpara);
        }





        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// <param name="model">角色维护Model</param>
        public void UpdateRoleDictionary(RoleDictionaryModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_BASE_ROLEDICTIONARY set ");
            strSql.Append("ROLE_ID=:ROLE_ID,");
            strSql.Append("ROLE_NAME=:ROLE_NAME,");
            strSql.Append("ROLE_DESC=:ROLE_DESC");
            strSql.Append(" where ROLE_ID=:ROLE_ID ");
            OracleParameter[] parameters = {
					new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20),
					new OracleParameter(":ROLE_NAME",OracleDbType.Varchar2,30),
					new OracleParameter(":ROLE_DESC",OracleDbType.Varchar2,300)};
            parameters[0].Value = model.ROLE_ID;
            parameters[1].Value = model.ROLE_NAME;
            parameters[2].Value = model.ROLE_DESC;
            SystemDataObject.Instance.ExecuteSqlCommit(strSql.ToString(),parameters);
        }


        /// <summary>
        /// 更新多条数据
        /// </summary>
        /// <param name="list"></param>
        public void UpdateRoleDictionaryList(List<RoleDictionaryModel> list)
        {
            List<string> sqlstrlist = new List<string>();
            List<OracleParameter[]> sqlstrpara = new List<OracleParameter[]>();
            StringBuilder strSql = new StringBuilder();
            foreach (RoleDictionaryModel model in list)
            {
                strSql.Append("update T_BASE_ROLEDICTIONARY set ");
                strSql.Append("ROLE_ID=:ROLE_ID,");
                strSql.Append("ROLE_NAME=:ROLE_NAME,");
                strSql.Append("ROLE_DESC=:ROLE_DESC");
                strSql.Append(" where ROLE_ID=:ROLE_ID ");
                OracleParameter[] parameters = {
					new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20),
					new OracleParameter(":ROLE_NAME",OracleDbType.Varchar2,30),
					new OracleParameter(":ROLE_DESC",OracleDbType.Varchar2,300)};
                parameters[0].Value = model.ROLE_ID;
                parameters[1].Value = model.ROLE_NAME;
                parameters[2].Value = model.ROLE_DESC;
                sqlstrlist.Add(strSql.ToString());
                sqlstrpara.Add(parameters);
                strSql.Clear();
            }
            //SystemDataObject.Instance.ExecuteList(sqlstrlist, sqlstrpara);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        /// <param name="ROLE_ID">角色ID</param>
        public void DeleteRoleDictionary(string ROLE_ID)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_BASE_ROLEDICTIONARY ");
            strSql.Append(" where ROLE_ID=:ROLE_ID ");
            OracleParameter[] parameters = {
					new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20)			};
            parameters[0].Value = ROLE_ID;
            SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 批量删除数据
        /// </summary>
        /// <param name="list">角色维护Model集合</param>
        public void DeleteRoleDictionaryList(RoleDictionaryModel list)
        {
   
            List<OracleParameter[]> sqlstrparam = new List<OracleParameter[]>();
  
            //foreach (RoleDictionaryModel model in list)
            //{
            string strSql = "delete from T_BASE_ROLEDICTIONARY where ROLE_ID ='" + list.ROLE_ID + "'";
                   
               
               
            //}
            SystemDataObject.Instance.ExecuteSql(strSql);
        }
    }
}