using?System;
using?System.Data.SqlClient;
using?System.Data;
using?System.Configuration;
using?System.xml;
using?System.Windows.Forms;
using?System.ComponentModel;
using?System.Collections;
using?System.Diagnostics;
using?System.Text;
using?DataManager.Properties;

namespace?DataManager
{
	///?

	///?

	public?class?DataAccess
	{
		
		public?DataAccess（）
		{

		}	
		///?

		///?配置數據庫連接字符串
		///?

????????public?static?string?ConnectionString?=?Settings.Default.ConnectionString.ToString（）;

????????public?SqlConnection?myConn;
????????public?SqlCommand?myCommand;
????????public?SqlDataAdapter?myAda;
????????public?SqlDataReader?myReader;
????????public?DataSet?ds;
????????public?DataTable?dt;
????????public?DataRow?dr;
????????public?string?FileName;
????????public?int?FileSize;

????????public?string?UserName;
????????public?string?TrueName;
????????public?string?Dept_Name;
????????public?string?Dept_Id;
????????//**********************************>>?數據庫操作函數?<<**********************************//
????????///?

????????///?打開數據庫連接
????????///?

????????public?void?open（）
????????{
????????????myConn?=?new?SqlConnection（ConnectionString）;
????????????myConn.Open（）;
????????}
????????public?SqlDataReader?GetReader（string?str_Sql）
????????{
????????????open（）;
????????????myCommand?=?new?SqlCommand（str_Sql?myConn）;
????????????try
????????????{
????????????????myReader?=?myCommand.ExecuteReader（CommandBehavior.CloseConnection）;
????????????}
????????????catch
????????????{
????????????????throw;
????????????}
????????????return?myReader;
????????}
????????///?

????????///?執行一個Sql語句返回一個DataSet對象
????????///?

????????///?sql語句
????????///?
????????public?DataSet?GetDs（string?str_Sql）
????????{
????????????open（）;
????????????myAda?=?new?SqlDataAdapter（str_Sql?myConn）;
????????????ds?=?new?DataSet（）;
????????????myAda.Fill（ds）;
????????????myConn.Close（）;
????????????return?ds;
????????}
????????///?

????????///?執行一個Sql語句返回一個DataSet對象
????????///?

????????///?sql語句
????????///?內寸表名稱
????????///?DataSet對象
????????public?DataSet?GetDs（string?str_Sql?string?str_Table）
????????{
????????????open（）;
????????????myAda?=?new?SqlDataAdapter（str_Sql?myConn）;
????????????ds?=?new?DataSet（）;
????????????myAda.Fill（ds?str_Table）;
????????????myConn.Close（）;
????????????return?ds;
????????}

????????///?

????????///?獲得包含在DataSet對象的映謝表集合中的index為0的映謝表
????????///?

????????///?打開表Sql語句
????????public?void?GetTable（string?str_Sql）
????????{
????????????dt?=?GetDs（str_Sql）.Tables[0];
????????}
????????///?

????????///?通過傳Sql語句關鍵key值獲得表中一行的數據
????????///?

????????///?