appparameters.cs

基于C/S的医疗卫生管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime.CompilerServices;

using Sybase.DataWindow;

using Qeb.Control;
using Qeb.DBProxy;
using Qeb.Support;
using Qeb.Support.Common;

namespace Qeb.GY
{
    /// <summary>
    /// 应用参数
    /// </summary>
    public class AppParameters
    {
        private static QDataStore m_DsAppParam = null;

        private AppParameters()
        {
        }

        [MethodImpl(MethodImplOptions.Synchronized)]
        private static void InitDs()
        {
            m_DsAppParam = new QDataStore();
            m_DsAppParam.LibraryList = PBL.GyPbl;
            m_DsAppParam.DataWindowObject = GyDataObjects.D_Gy_XtCs;
            try
            {
                DbProxyClient proxy = App.DbProxy;
                proxy.AddRetrieveParam("p_yyid", App.yyId);
                proxy.Retrieve(m_DsAppParam);
            }
            catch(Exception ex)
            {
                throw new Exception("初始化系统参数发生异常："+ex.Message);
            }
        }
        
        /// <summary>
        /// 根据当前应用ID，参数ID取参数, 参数值IsNullOrEmpty时，返回默认值
        /// </summary>
        /// <param name="csId">参数ID</param>
        /// <returns></returns>
        public static string GetParam(string csId,string defaultValue)
        {
            return GetParam(csId, App.yyId, defaultValue);
        }

        /// <summary>
        /// 根据指定的应用ID，参数ID取参数,参数值IsNullOrEmpty时，返回默认值
        /// 如需取公用参数，应用ID请传入0000
        /// </summary>
        /// <param name="csId">参数ID</param>
        /// <param name="yyId">应用ID</param>
        /// <returns></returns>
        public static string GetParam(string csId,string yyId,string defaultValue)
        {
            if (csId == null)
                throw new Exception("入参错误，参数ID Is Null");
            if (m_DsAppParam == null)
            {
                InitDs();
            }

            string csz = defaultValue;
            int findRow = m_DsAppParam.FindRow("csid='" + csId + "'", 1, m_DsAppParam.RowCount);
            if (findRow > 0)
            {
                if (!m_DsAppParam.IsItemNull(findRow, "csz"))
                {
                    csz = m_DsAppParam.GetItemString(findRow, "csz");
                 }
            }
            else
            {
                string sql =  "SELECT CSZ FROM GY_CS WHERE YYID='"+yyId+"' AND CSID='"+csId+"'";
                DbProxyClient proxy = App.DbProxy;
                proxy.Clear();
                csz = proxy.ExecuteScalar(sql);
                int row = m_DsAppParam.InsertRow(0);
                m_DsAppParam.SetItemString(row, "csid", csId);
                m_DsAppParam.SetItemString(row, "yyid", yyId);
                m_DsAppParam.SetItemString(row, "csz", csz);
            }

            if (string.IsNullOrEmpty(csz))
                return defaultValue;
            else
                return csz;
        }
    }
}