using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;

namespace?人事管理
{
????class?data
????{
????????//private?String?SqlConnectionString;
????????private?SqlConnection?con;
????????public?SqlConnection?link（）
????????{
????????????SqlConnection?con?=?new?SqlConnection（“database=WorkerManage;server=（local）;USER?ID=sa;“）;
????????????con.Open（）;
????????????//Open（）;
????????????return?con;
????????}

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

????????/////?打開(kāi)數(shù)據(jù)庫(kù)連接。
????????/////?

????????//private?void?Open（）
????????//{
????????//????//?open?connection
????????//????if?（con?==?null?||?con.State?==?ConnectionState.Closed）
????????//????{
????????//????????con?=?new?SqlConnection（“database=WorkerManage;server=（local）;USER?ID=sa;“）;
????????//????????con.Open（）;
????????//????}
????????//}

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

????????/////?關(guān)閉數(shù)據(jù)庫(kù)連接。
????????/////?

????????//public?void?Close（）
????????//{
????????//????if?（con?!=?null）
????????//????{
????????//????????con.Close（）;
????????//????????this.Dispose（）;
????????//????}
????????//}

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

????????/////?Release?resources.
????????/////?釋放資源。
????????/////?

????????//public?void?Dispose（）
????????//{
????????//????//?make?sure?connection?is?closed
????????//????if?（con?!=?null）
????????//????{
????????//????????con.Dispose（）;
????????//????????con?=?null;
????????//????}
????????//}

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

????????/////?創(chuàng)建command對(duì)象以便執(zhí)行sql語(yǔ)句。
????????/////?Created?by?wujq.
????????/////?

????????/////?Sql?Text.		
????????/////?Command?object.
????????//private?SqlCommand?CreateCommand（string?sql）
????????//{
????????//????//?make?sure?connection?is?open
????????//????Open（）;
????????//????SqlCommand?cmd?=?new?SqlCommand（sql?con）;
????????//????cmd.CommandType?=?CommandType.Text;
????????//????return?cmd;
????????//}

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

????????/////?查詢(xún)返回DATASET
????????/////?

????????/////?sql語(yǔ)句
????????/////?DataSet對(duì)象
????????//public?DataSet?QueryDataSet（string?sql）
????????//{
????????//????SqlCommand?cmd?=?CreateCommand（sql）;
????????//????DataSet?ds?=?new?DataSet（）;
????????//????try
????????//????{
????????//????????SqlDataAdapter?dataAdapter?=?new?SqlDataAdapter（cmd）;
????????//????????dataAdapter.Fill（ds）;
????????//????}
????????//????catch?（Exception?ex）
????????//????{
????????//????????ex.Message.ToString（）;
????????//????????ds?=?null;
????????//????}
????????//????finally
????????//????{
????????//????????this.Close（）;
????????//????}
????????//????return?ds;
????????//}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

?????文件????????438??2008-06-02?13:56??人事管理\sql\addworkmanage.sql

?????文件????????310??2008-06-02?17:22??人事管理\sql\compensationView.sql

?????文件????????613??2008-06-05?08:55??人事管理\sql\select.txt

?????文件????????608??2008-06-05?08:55??人事管理\sql\SELECT_money.sql

?????文件????????137??2008-06-02?17:58??人事管理\sql\SystemEventView.sql

?????文件??????????0??2008-06-04?12:22??人事管理\sql\transaction.txt

?????文件????????416??2008-05-29?09:22??人事管理\sql\UP_DragDepartment.sql

?????文件????????325??2008-06-02?17:10??人事管理\sql\WorkerAttendanceView.sql

?????文件????????406??2008-06-04?13:13??人事管理\sql\WorkerCompensationManage1View.txt

?????文件????????390??2008-06-02?17:00??人事管理\sql\WorkerCompensationManageView.sql

?????文件????????423??2008-06-02?18:16??人事管理\sql\WorkerLeaveView.sql

?????文件????????513??2008-06-05?08:52??人事管理\sql\WorkerOvertimeView.sql

?????文件????????326??2008-05-28?15:22??人事管理\sql\創(chuàng)建數(shù)據(jù)庫(kù).sql

?????文件???????8966??2008-06-05?08:01??人事管理\sql\建表.sql

?????文件????????233??2008-05-21?14:26??人事管理\sql\視圖3.14.sql

?????文件????????201??2008-05-21?14:27??人事管理\sql\視圖3.15.sql

?????文件????????226??2008-05-21?14:27??人事管理\sql\視圖3.16.sql

?????文件????????297??2008-05-21?14:27??人事管理\sql\視圖3.17.sql

?????文件????????184??2008-05-21?14:41??人事管理\sql\視圖3.18.sql

?????目錄??????????0??2008-10-15?20:18??人事管理\sql

?????文件???????3150??2008-06-26?10:45??人事管理\下載說(shuō)明.txt

?????文件????????369??2008-05-22?16:04??人事管理\人事管理\app.config

?????文件???????1569??2008-06-05?15:00??人事管理\人事管理\AttendanceManage\selectwork.cs

?????文件???????6400??2008-06-05?15:00??人事管理\人事管理\AttendanceManage\selectwork.Designer.cs

?????文件??????39293??2008-06-05?15:00??人事管理\人事管理\AttendanceManage\selectwork.resx

?????文件???????1474??2008-06-05?15:00??人事管理\人事管理\AttendanceManage\SetAttendanceType.cs

?????文件???????4950??2008-06-05?15:00??人事管理\人事管理\AttendanceManage\SetAttendanceType.Designer.cs

?????文件??????49573??2008-06-05?15:00??人事管理\人事管理\AttendanceManage\SetAttendanceType.resx

?????文件???????3956??2008-06-06?08:36??人事管理\人事管理\AttendanceManage\workmanege.cs

?????文件???????6230??2008-06-06?08:36??人事管理\人事管理\AttendanceManage\workmanege.Designer.cs

............此處省略167個(gè)文件信息