connectiondata.cs

独立完成考勤管理软件加打卡系统（C＃） 是打卡加管理系统软件

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Diagnostics;
using System.Security.Cryptography;
namespace WindowsApplication
{
	public class ConnectionData
	{
		#region 连接数据库的所有变量....
		public string strConnection="Workstation id=localhost;Integrated security=SSPI;DataBase=SystemODBC;";
		public System.Data.SqlClient.SqlConnection  dsCon=new SqlConnection();
		public SqlCommandBuilder sqlCmdBld=null;
		private string strsql="";
		#endregion
		#region 类构结函数
		public ConnectionData()
		{
			
		}
		public ConnectionData(string strSql)
		{
            this.strsql=strSql;
		}
		#endregion
		#region 返回类型为DataSet...传递一个查询，修改，插入，更新的字符串和一个表字符串.
		public DataSet ExcuteDataSetResult(string strSql,string strTableName)
		{
			dsCon.ConnectionString=strConnection;
			dsCon.Open();
			SqlDataAdapter myDataAdapter=new SqlDataAdapter(strSql,dsCon);
			DataSet ds=new DataSet();
			try
			{
				myDataAdapter.Fill(ds,strTableName);
			}
			catch(Exception exe)
			{
				exe.ToString();
			}
			finally
			{
				if(dsCon.State.Equals(ConnectionState.Open))
				{
					dsCon.Close();
				}
				myDataAdapter.Dispose();
			}
			return ds;
		}
		#endregion
		#region 	//返回类型为DataTable...传递一个查询，修改，插入，更新的字符串和一个表字符串
		public DataTable ExcuteDataTableResult(string strSql,string strTableName)
		{
			dsCon.ConnectionString=strConnection;
			dsCon.Open();
			SqlDataAdapter myDataAdapter=new SqlDataAdapter(strSql,dsCon);
			DataSet ds=new DataSet();
			DataTable dsTable=new DataTable();
			try
			{
				myDataAdapter.Fill(ds,strTableName);
				dsTable=ds.Tables[0];
			}
			catch(Exception exe)
			{
				exe.ToString();
			}
			finally
			{
				if(dsCon.State.Equals(ConnectionState.Open))
				{
					dsCon.Close();
				}
				myDataAdapter.Dispose();
			}
			return dsTable;
		}
		#endregion
		#region //返回类型为int传递一个查询，修改，插入，更新的字符串和一个表字符串
		public int ExcuteStrSql(string strSql)
		{
			dsCon.ConnectionString=strConnection;
			dsCon.Open();
			try
			{
				SqlCommand com=new SqlCommand(strSql,dsCon);
				com.ExecuteNonQuery();
				return 1;
			}
			catch(Exception exe)
			{
				exe.ToString();
				return 0;
			}
			finally
			{
				if(dsCon.State.Equals(ConnectionState.Open))
				{
					dsCon.Close();
				}
			}
		}
		#endregion
		#region 执行一个字符串返回一个SqlDataReader
		//执行一条语句,返回一个SqlDataReader;
		public SqlDataReader ExcuteDataReader(string strSql)
		{
			try
			{
				dsCon.ConnectionString=strConnection;
				dsCon.Open();
				SqlCommand myCommand=new SqlCommand(strSql,dsCon);
				SqlDataReader myRead=myCommand.ExecuteReader();
				return myRead;
			}
			catch(SqlException exe)
			{
				throw new Exception(exe.Message);
			}
			finally
			{
				dsCon.Close();
			}
		}
		#endregion
		#region 执行一个字符串返回一个Object对象
		public object ExcuteStrSqlObject(string strSql)
		{
			object result=null;
			try
			{
				dsCon.ConnectionString=strConnection;
				dsCon.Open();
				SqlCommand com=new SqlCommand(strSql,dsCon);
				result=com.ExecuteScalar();
			}
			catch(Exception elses)
			{
				elses.ToString();
			}
			finally
			{
				if(dsCon.State.Equals(ConnectionState.Open))
				{
					dsCon.Close();
				}
			}
			return result;
		}
		#endregion
		#region 根据DataSet和TableName名称修改数据库返回一个DataSet
		public DataSet  UpdateDataSet(DataSet changeDataSet,string tableName)
		{
			try
			{
				dsCon.ConnectionString=strConnection;
				dsCon.Open();
				SqlDataAdapter sqldataAdapter=new SqlDataAdapter(strsql,dsCon);
				sqlCmdBld=new SqlCommandBuilder(sqldataAdapter);
				sqldataAdapter.Update(changeDataSet,tableName);
			}
			catch(Exception elses)
			{
				elses.ToString();
			}
			finally
			{
				if(dsCon.State.Equals(ConnectionState.Open))
				{
					dsCon.Close();
				}
			}
			return changeDataSet;
		}
		#endregion
	}
}