XinYu_LZMES_Client/Core.LZMes.Client.UIL/Weight_DBManager.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Core.LZMes.Client.UIL
{
    public class Weight_DBManager
    {
        #region "Property"
        static string _JLConnStr = "";
        static string _SQConnStr = "";
        static string _XCConnStr = "";
        static string _LogName = "新钢MES系统酸轧二级接口服务";
        static System.Data.OleDb.OleDbConnection _JLConn;
        static System.Data.OleDb.OleDbConnection _SQConn;
        static System.Data.OleDb.OleDbConnection _XCConn;
        public static string LogName
        {
            get
            {
                return _LogName;
            }
        }
        public static string JLConnStr
        {
            get
            {
                return _JLConnStr;
            }
            set
            {
                _JLConnStr = value;
                _JLConn = new System.Data.OleDb.OleDbConnection(value);
            }
        }
        public static string SQConnStr
        {
            get
            {
                return _SQConnStr;
            }
            set
            {
                _SQConnStr = value;
                _SQConn = new System.Data.OleDb.OleDbConnection(value);
            }
        }
        public static string XCConnStr
        {
            get
            {
                return _XCConnStr;
            }
            set
            {
                _XCConnStr = value;
                _XCConn = new System.Data.OleDb.OleDbConnection(value);
            }
        }
        public static System.Data.OleDb.OleDbConnection SQConn
        {
            get
            {
                try
                {
                    if (_SQConn.State == System.Data.ConnectionState.Closed)
                    {
                        _SQConn.Dispose();
                        _SQConn = new System.Data.OleDb.OleDbConnection(_SQConnStr);
                        _SQConn.Open();
                    }
                    return _SQConn;
                }
                catch (System.Exception ex)
                {
                    System.Diagnostics.EventLog.WriteEntry(_LogName, "三期热轧数据连接失败：" + ex.ToString(), System.Diagnostics.EventLogEntryType.Error);
                    return null;
                }
            }
        }
        public static System.Data.OleDb.OleDbConnection JLConn
        {
            get
            {
                try
                {
                    if (_JLConn.State == System.Data.ConnectionState.Closed)
                    {
                        _JLConn.Dispose();
                        _JLConn = new System.Data.OleDb.OleDbConnection(_JLConnStr);
                        _JLConn.Open();
                    }
                    return _JLConn;
                }
                catch (System.Exception ex)
                {
                    System.Diagnostics.EventLog.WriteEntry(_LogName, "计量接口数据连接失败：" + ex.ToString(), System.Diagnostics.EventLogEntryType.Error);
                    return null;
                }
            }
        }
        public static System.Data.OleDb.OleDbConnection XCConn
        {
            get
            {
                try
                {
                    if (_XCConn.State == System.Data.ConnectionState.Closed)
                    {
                        _XCConn.Dispose();
                        _XCConn = new System.Data.OleDb.OleDbConnection(_XCConnStr);
                        _XCConn.Open();
                    }
                    return _XCConn;
                }
                catch (System.Exception ex)
                {
                    System.Diagnostics.EventLog.WriteEntry(_LogName, "产销数据连接失败：" + ex.ToString(), System.Diagnostics.EventLogEntryType.Error);
                    return null;
                }
            }
        }

        #endregion
    }
}