using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data.SqlClient;
using?System.Data;
namespace?TEmail.DataAccess
{
???public?class?UserDataAccess
????{
???????string?ST_ConnectionString;
???????SqlConnection?ST_dbconn;
???????SqlDataAdapter?ST_adapter;
???????public?UserDataAccess（）
???????{
???????????ST_ConnectionString?=?“Data?Source=localhost;Initial?Catalog=EmployeeSystem;User?ID=sa;Password=zhang159“;
???????????ST_dbconn?=?new?SqlConnection（ST_ConnectionString）;
???????}
???????///?

???????///?校驗管理員是否可以登錄
???????///?

???????///?用戶名
???????///?密碼
???????///?dataset
???????public?DataSet?UserLogin（string?namestring?pwdint?n）
???????{
??????????DataSet?ST_dd?=?new?DataSet（）;//創建一個數據集ST_dd
???????????ST_dbconn.Open（）;//打開連接
???????????string?sql?=?“SELECT?*?FROM?ST_Login?WHERE?ST_User=‘“+name+“‘?AND?ST_PassWord=‘“+pwd+“‘?AND?ST_Userclass=‘“+n+“‘“;
???????????ST_adapter?=?new?SqlDataAdapter（sqlST_dbconn）;//定義并初始化數據適配器
???????????//ST_adapter.SelectCommand?=?new?SqlCommand（sql?ST_dbconn）;
???????????//ST_adapter.SelectCommand.Parameters.Add（new?SqlParameter（“@Name“?SqlDbType.NVarChar?20））;
???????????//ST_adapter.SelectCommand.Parameters[“@Name“].Value?=?name;
???????????//ST_adapter.SelectCommand.Parameters.Add（new?SqlParameter（“@Pwd“?SqlDbType.NVarChar?20））;
???????????//ST_adapter.SelectCommand.Parameters[“@Pwd“].Value?=?pwd;
???????????ST_adapter.Fill（ST_dd）;								//將數據適配器中的數據填充到數據集ST_dd中
???????????//ST_dbconn.Close（）;//關閉連接
???????????return?ST_dd;
???????}
???????///?

???????///?校驗用戶是否可以登錄
???????///?

???????///?用戶名
???????///?密碼
???????///?DataSet
???????public?DataSet?UserLoginn（string?name?string?pwd）
???????{
???????????DataSet?ST_dd?=?new?DataSet（）;//創建一個數據集ST_dd
???????????ST_dbconn.Open（）;//打開連接
???????????string?sql?=?“SELECT?*?FROM?ST_Login?WHERE?ST_User=‘“?+?name?+?“‘?AND?ST_PassWord=‘“?+?pwd?+?“‘“;
???????????ST_adapter?=?new?SqlDataAdapter（sql?ST_dbconn）;//定義并初始化數據適配器
???????????//ST_adapter.SelectCommand?=?new?SqlCommand（sql?ST_dbconn）;
???????????//ST_adapter.SelectCommand.Parameters.Add（new?SqlParameter（“@Name“?SqlDbType.NVarChar?20））;
???????????//ST_adapter.SelectCommand.Parameters[“@Name“].Value?=?name;
???????????//ST_adapter.SelectCommand.Parameters.Add（new?SqlParameter（“@Pwd“?SqlDbType.NVarChar?20））;
???????????//ST_adapter.SelectCommand.Parameters[“@Pwd“].Value?=?pwd;
???????????ST_adapter.Fill（ST_dd）;								//將數據適配器中的數據填充到數據集ST_dd中
???????????//ST_dbconn.Close（）;//關閉連接
???????????return?ST_dd;
???????}
???????///?

???????///?添加新聞
???????///?

???????///?新聞標題
???????///?公司名稱
???????///?新聞內容
???????pu

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????6144??2010-05-02?20:20??TEmail\TEmail.DataAccess\bin\Debug\TEmail.DataAccess.dll

?????文件??????13824??2010-05-02?20:20??TEmail\TEmail.DataAccess\bin\Debug\TEmail.DataAccess.pdb

?????文件????????314??2010-05-02?20:20??TEmail\TEmail.DataAccess\obj\Debug\TEmail.DataAccess.csproj.FileListAbsolute.txt

?????文件???????6144??2010-05-02?20:20??TEmail\TEmail.DataAccess\obj\Debug\TEmail.DataAccess.dll

?????文件??????13824??2010-05-02?20:20??TEmail\TEmail.DataAccess\obj\Debug\TEmail.DataAccess.pdb

?????文件???????1366??2010-04-27?21:12??TEmail\TEmail.DataAccess\Properties\AssemblyInfo.cs

?????文件???????2518??2010-04-28?10:16??TEmail\TEmail.DataAccess\TEmail.DataAccess.csproj

?????文件????????168??2010-04-28?10:32??TEmail\TEmail.DataAccess\TEmail.DataAccess.csproj.user

?????文件???????5972??2010-05-02?20:18??TEmail\TEmail.DataAccess\UserDataAccess.cs

?????文件????????736??2010-05-02?20:18??TEmail\TEmail.Rule\add.cs

?????文件???????6144??2010-05-02?20:20??TEmail\TEmail.Rule\bin\Debug\TEmail.DataAccess.dll

?????文件??????13824??2010-05-02?20:20??TEmail\TEmail.Rule\bin\Debug\TEmail.DataAccess.pdb

?????文件???????4608??2010-05-02?20:20??TEmail\TEmail.Rule\bin\Debug\TEmail.Rule.dll

?????文件??????13824??2010-05-02?20:20??TEmail\TEmail.Rule\bin\Debug\TEmail.Rule.pdb

?????文件???????3184??2010-05-02?20:20??TEmail\TEmail.Rule\obj\Debug\ResolveAssemblyReference.cache

?????文件????????370??2010-05-02?20:20??TEmail\TEmail.Rule\obj\Debug\TEmail.Rule.csproj.FileListAbsolute.txt

?????文件???????4608??2010-05-02?20:20??TEmail\TEmail.Rule\obj\Debug\TEmail.Rule.dll

?????文件??????13824??2010-05-02?20:20??TEmail\TEmail.Rule\obj\Debug\TEmail.Rule.pdb

?????文件???????1354??2010-04-27?21:11??TEmail\TEmail.Rule\Properties\AssemblyInfo.cs

?????文件???????2773??2010-05-01?20:10??TEmail\TEmail.Rule\TEmail.Rule.csproj

?????文件???????1168??2010-05-01?20:52??TEmail\TEmail.Rule\UserRule.cs

?????文件???????4594??2010-04-28?16:45??TEmail\TEmail.sln

????..A..H.?????36864??2010-05-05?12:30??TEmail\TEmail.suo

?????文件????2293760??2010-04-28?10:38??TEmail\TEmail.web\App_Data\EmployeeSystem.mdf

?????文件?????573440??2010-04-28?10:38??TEmail\TEmail.web\App_Data\EmployeeSystem_log.LDF

?????文件???????6144??2010-05-02?20:20??TEmail\TEmail.web\Bin\TEmail.DataAccess.dll

?????文件??????13824??2010-05-02?20:20??TEmail\TEmail.web\Bin\TEmail.DataAccess.pdb

?????文件???????4608??2010-05-02?20:20??TEmail\TEmail.web\Bin\TEmail.Rule.dll

?????文件??????13824??2010-05-02?20:20??TEmail\TEmail.web\Bin\TEmail.Rule.pdb

?????文件????????661??2006-08-14?18:43??TEmail\TEmail.web\images\Admin_left_2.gif

............此處省略72個文件信息