/*------------------------------------------------------------------
-- COPYRIGHT (C) 2011-2022  Hanhe
-- ALL RIGHTS RESERVED.
-- Hanhe
-- CREATE DATE: 2010/07/27
-- CREATE MAN:	wz
-- 系统参数配置表
-- MODIFY HISTORY:
-- MODIFY DATE:
-- MODIFY MAN:	
-- MODIFY DESC:
-- MODIFY DATE:
-- MODIFY MAN:	
-- MODIFY DESC:
---------------------------------------------------------------------*/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Common;
using System.Data;
using HanHe.Utility.Data;
using HH.WMS.Entitys.Common;
 

namespace HH.WMS.DAL.Func
{
    public class CommonDAL : BaseDAL
    {
        
        #region 判断数据库中是否存在某张表
        /// <summary>
        /// 判断数据库中是否存在某张表
        /// </summary>
        /// <param name="TableName">表名</param>
        /// <returns>存在返回true,失败返回false</returns>
        /// <history>[HanHe(ZMM)] CREATED 2015/11/04</history>
        public bool ExsistTable(string TableName)
        {
            string Sql = "select count(*) from sysobjects where id = object_id(N'[" + TableName + "]') and OBJECTPROPERTY(id, N'IsUserTable') = 1";
            DbCommand cmd = DataAccess.GetSqlStringCommand(Sql);
            object obj = DataAccess.ExecuteScalar(cmd);
            if (Convert.ToInt32(obj) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        #endregion
        
        
        #region 获取/设置全局参数
        /// <summary>
        /// 获取全局参数
        /// </summary>
        /// <param name="strKey">参数键</param>
        /// <returns>参数值</returns>
        /// <history>[HanHe(HHC)] CREATED 2016/09/29</history>
        public string GetGlobalVar(string strKey)
        {
            string strSql = @"SELECT CN_S_VALUE FROM TN_TASK_GLOBALVAR WHERE CN_S_KEY='{0}' ";
            strSql = string.Format(strSql, strKey);

            DbCommand cmd = DataAccess.GetSqlStringCommand(strSql);
            object obj = DataAccess.ExecuteScalar(cmd);
            if (null != obj)
            {
                return obj.ToString();
            }
            return "";
        }

        /// <summary>
        /// 设置全局参数
        /// </summary>
        /// <param name="strKey">参数键</param>
        /// <param name="strValue">参数值</param>
        /// <param name="trans">事务</param>
        /// <returns>true：成功  false:失败</returns>
        /// <history>[HanHe(HHC)] CREATED 2016/09/29</history>
        public bool SetGlobalVar(string strKey, string strValue, DbTransaction trans = null)
        {
            SqlExecuteResult result = new SqlExecuteResult();
            try
            {
                string strSql = @"DECLARE NUM NUMBER; 
                              BEGIN
                                SELECT COUNT(1) INTO NUM FROM TN_TASK_GLOBALVAR WHERE CN_S_KEY='{0}'; 
                                IF NUM>0 THEN
                                    UPDATE TN_TASK_GLOBALVAR SET CN_S_VALUE='{1}' WHERE CN_S_KEY='{0}' ;
                                ELSE 
                                    INSERT INTO TN_TASK_GLOBALVAR(CN_S_KEY,CN_S_VALUE) VALUES('{0}', '{1}');
                                END IF;
                              END;";
                strSql = string.Format(strSql, strKey, strValue);

                DbCommand cmd = DataAccess.GetSqlStringCommand(strSql);
                result = ExecuteCommand(cmd, trans);
            }
            catch (Exception ex)
            {
                result.Success = false;
                result.Exception = ex;
            }
            return result.Success;
        }
        #endregion

    }
}