Exemple #1
0
        /// <summary>
        /// 获取配置信息
        /// <auth>Yanqiao.Cai</auth>
        /// <date>2012-12-03</date>
        /// <param name="key"></param>
        /// <returns></returns>
        private string GetConfigValueByKey(string key)
        {
            try
            {
                if (!string.IsNullOrEmpty(key))
                {
                    string        sqlStr    = " select * from appcfg where configkey = @key ";
                    DbParameter[] sqlParams = new DbParameter[]
                    {
                        new SqlParameter("@key", SqlDbType.Char, 32)
                    };
                    sqlParams[0].Value = key;
                    DS_SqlHelper.DefaultDataAccess();
                    DataTable dt = DS_SqlHelper.ExecuteDataTable(sqlStr, sqlParams, CommandType.Text);
                    if (null != dt && dt.Rows.Count > 0)
                    {
                        return(null == dt.Rows[0]["value"] ? string.Empty : dt.Rows[0]["value"].ToString());
                    }
                }

                return(string.Empty);
            }
            catch (Exception ex)
            {
                io.WriteLog(ex.Message);
                throw ex;
            }
        }