using System;
using System.Data.SqlClient;
using System.Data;

namespace DataServer
{
	/// <summary>
	/// DBConnect 的摘要說明。
	/// </summary>
	public class DBConnect
	{
		private static DBConnect _Instance = null ;
		private string m_strConnstr;
		public SqlConnection cn = new SqlConnection();
		public DBConnect()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
		public static DBConnect Instance()
		{
			if (_Instance == null)
				_Instance = new DBConnect() ;
			return _Instance ;
		}
		public bool Connect()
		{
			string ServerName = DBConnectXml.Instance().GetNode("ServerName");
			string DataBase = DBConnectXml.Instance().GetNode("DataBase");
			string LogID = DBConnectXml.Instance().GetNode("LogID");
			string PWD = DBConnectXml.Instance().GetNode("PWD");
			m_strConnstr = "data source=" + ServerName + ";initial catalog=" + DataBase + ";password=" + PWD + ";persist security info=True;user id=" + LogID;
			cn.ConnectionString = m_strConnstr;
			try
			{
				cn.Open();
				return true;
			}
			catch(Exception)
			{
				return false;
			}
		}
	}
}