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

using WMS.IData.ISystemManage;
using Oracle.ManagedDataAccess.Client;

namespace WMS.SqlServerData.SystemManageData
{
    public class SystemParamsData : ISystemParams
    {

        #region  BasicMethod

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataTable GetSysParamsList(SystemParamsModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select PARAMTYPE,PARAMCOMMENTS,PARAMVALUE,SYSUSER,PARAMDATE,PARAMMENU ");
            strSql.Append(" FROM T_SYS_PARAM where 1 =1 ");
            if (!string.IsNullOrEmpty(model.PARAMMENU))
            {
                strSql.Append(" and PARAMMENU='" + model.PARAMMENU + "'");
            }
            if (!string.IsNullOrEmpty(model.PARAMTYPE))
            {
                strSql.Append(" and PARAMTYPE ='" + model.PARAMTYPE + "'");
            }
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }

        /// <summary>
        /// 根据类型查值
        /// </summary>
        /// <param name="paramType"></param>
        /// <returns></returns>
        public string GetParamValue(string paramType)
        {
            string strSql = "";
            strSql = "select PARAMVALUE from T_SYS_PARAM where PARAMTYPE='" + paramType + "'";

            DataTable tab = SystemDataObject.Instance.GetDataTable(strSql);
            string strValue = string.Empty;
            try
            {
                if (tab.Rows.Count>0)
                {
                    strValue = tab.Rows[0][0].ToString();
                }
                
            }
            catch (Exception ex)
            {
               
            }
           
            return strValue;
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void AddSysParamsData(SystemParamsModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_SYS_PARAM(");
            strSql.Append("PARAMTYPE,PARAMCOMMENTS,PARAMVALUE,SYSUSER,PARAMDATE,PARAMMENU)");
            strSql.Append(" values (");
            strSql.Append(":PARAMTYPE,:PARAMCOMMENTS,:PARAMVALUE,:SYSUSER,:PARAMDATE,:PARAMMENU)");
            OracleParameter[] parameters = {
					new OracleParameter(":PARAMTYPE",OracleDbType.Varchar2,20),
					new OracleParameter(":PARAMCOMMENTS",OracleDbType.Varchar2,200),
					new OracleParameter(":PARAMVALUE",OracleDbType.Varchar2,2000),
					new OracleParameter(":SYSUSER",OracleDbType.Varchar2,200),
					new OracleParameter(":PARAMDATE", OracleDbType.Date),
					new OracleParameter(":PARAMMENU",OracleDbType.Varchar2,20)};
            parameters[0].Value = model.PARAMTYPE;
            parameters[1].Value = model.PARAMCOMMENTS;
            parameters[2].Value = model.PARAMVALUE;
            parameters[3].Value = model.SYSUSER;
            parameters[4].Value = model.PARAMDATE;
            parameters[5].Value = model.PARAMMENU;

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


        //有问题 未处理  主键 条件
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void UpdateSysParamsData(SystemParamsModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_SYS_PARAM set ");
            strSql.Append("PARAMTYPE=:PARAMTYPE,");
            strSql.Append("PARAMCOMMENTS=:PARAMCOMMENTS,");
            strSql.Append("PARAMVALUE=:PARAMVALUE,");
            strSql.Append("SYSUSER=:SYSUSER,");
            strSql.Append("PARAMDATE=:PARAMDATE,");
            strSql.Append("PARAMMENU=:PARAMMENU");
            strSql.Append(" where PARAMTYPE=:PARAMTYPE and PARAMMENU=:PARAMMENU ");
            OracleParameter[] parameters = {
					new OracleParameter(":PARAMTYPE",OracleDbType.Varchar2,20),
					new OracleParameter(":PARAMCOMMENTS",OracleDbType.Varchar2,200),
					new OracleParameter(":PARAMVALUE",OracleDbType.Varchar2,2000),
					new OracleParameter(":SYSUSER",OracleDbType.Varchar2,200),
					new OracleParameter(":PARAMDATE", OracleDbType.Date),
					new OracleParameter(":PARAMMENU",OracleDbType.Varchar2,20)};
            parameters[0].Value = model.PARAMTYPE;
            parameters[1].Value = model.PARAMCOMMENTS;
            parameters[2].Value = model.PARAMVALUE;
            parameters[3].Value = model.SYSUSER;
            parameters[4].Value = model.PARAMDATE;
            parameters[5].Value = model.PARAMMENU;

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

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void DeleteSysParamsData(SystemParamsModel model)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_SYS_PARAM ");
            strSql.Append(" where PARAMTYPE=:PARAMTYPE and PARAMMENU=:PARAMMENU ");
            OracleParameter[] parameters = {
					new OracleParameter(":PARAMTYPE",OracleDbType.Varchar2,20),
					new OracleParameter(":PARAMMENU",OracleDbType.Varchar2,20)			};
            parameters[0].Value = model.PARAMTYPE;
            parameters[1].Value = model.PARAMMENU;
            SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
        }

        /// <summary>
        /// 删除整张表所有数据
        /// </summary>
        public void DeleteSy()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from t_Sys_Param ");
            SystemDataObject.Instance.ExecuteSql(strSql.ToString());
        }

        #endregion
    }
}