/*
?*?創(chuàng)建人：劉運江
?*?創(chuàng)建時間：2010-09-22?16：19
?*?說明：管理員數(shù)據(jù)表操作類
?*/
using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?Model;

namespace?DAL
{
????public?class?AdminDAO
????{
????????private?SQLHelper?sqlhelp?=?null;
????????public?AdminDAO（）
????????{
????????????sqlhelp?=?new?SQLHelper（）;
????????}

????????#region?取出所有管理員
????????///?

????????///?取出所有管理員
????????///?

????????///?
????????public?DataTable?SelectAll_Admin（）
????????{
????????????DataTable?dt?=?new?DataTable（）;
????????????string?cmdText?=?“select?*?from?tb_Admin“;
????????????dt?=?sqlhelp.ExecuteQuery（cmdText?CommandType.Text）;
????????????return?dt;
????????}
????????#endregion

????????#region?根據(jù)用戶名取出管理員信息
????????///?

????????///?根據(jù)用戶名取出管理員信息
????????///?

????????///?用戶名
????????///?
????????public?DataTable?SelectBySysName_Admin（string?userName）
????????{
????????????DataTable?dt?=?new?DataTable（）;
????????????string?cmdText?=?“select?*?from?tb_Admin?where?userName=@userName“;
????????????SqlParameter[]?paras?=?new?SqlParameter[]
????????????{
????????????????new?SqlParameter（“@userName“userName）
????????????};
????????????dt?=?sqlhelp.ExecuteQuery（cmdText?paras?CommandType.Text）;
????????????return?dt;
????????}
????????#endregion

????????#region?根據(jù)用戶ID取出用戶名和密碼
????????///?

????????///?根據(jù)用戶ID取出用戶名和密碼
????????///?

????????///?用戶ID
????????///?
????????public?Admin?SelectById_Admin（string?id）
????????{
????????????Admin?a?=?new?Admin（）;
????????????DataTable?dt?=?new?DataTable（）;
????????????string?cmdText?=?“select?*?from?tb_Admin?where?id=@id“;
????????????SqlParameter[]?paras?=?new?SqlParameter[]
????????????{
????????????????new?SqlParameter（“@id“id）
????????????};
????????????dt?=?sqlhelp.ExecuteQuery（cmdText?paras?CommandType.Text）;
????????????a.Id?=?id;
????????????a.UserName?=?dt.Rows[0][“userName“].ToString（）;
????????????a.PassWord?=?dt.Rows[0][“passWord“].ToString（）;
????????????a.Name?=?dt.Rows[0][“name“].ToString（）;
????????????return?a;
????????}
????????#endregion

????????#region?修改用戶名密碼
????????///?

????????///?修改用戶名密碼
????????///?

????????///?用戶ID
????????///?用戶xing名
????????///?用戶名
????????///?密碼
????????///?
????????public?bool?Updata_Admin（string?idstring?name?string?userName?string?passWord）
????????{
????????????bool?flag?=?false;
????????????string?cmdText?=?“UPDATE?Admin?SET?name?=?@name?userName?=?@userName?passWord?=?@passWord?where?id=@id“;?
????????????SqlParameter[]?paras?=?new?SqlParameter[]
????????????{
????????????????new?SqlParameter（“@id“id）
??????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2010-10-30?23:08??在線考試系統(tǒng)\
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\
?????文件????????6223??2010-09-23?18:09??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\AdminDAO.cs
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\bin\
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\bin\Debug\
?????文件???????36864??2010-09-25?11:34??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\bin\Debug\DAL.dll
?????文件???????60928??2010-09-25?11:34??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\bin\Debug\DAL.pdb
?????文件???????????9??2010-09-24?16:36??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\bin\Debug\Desktop_1.ini
?????文件???????20480??2010-09-25?11:34??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\bin\Debug\Model.dll
?????文件???????38400??2010-09-25?11:34??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\bin\Debug\Model.pdb
?????文件???????????9??2010-09-24?16:36??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\bin\Desktop_1.ini
?????文件????????4339??2010-09-23?14:03??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\ClassDAO.cs
?????文件????????2528??2010-09-23?12:07??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\DAL.csproj
?????文件???????????9??2010-09-24?16:36??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\Desktop_1.ini
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\
?????文件?????????160??2010-10-03?13:49??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\DAL.csproj.FileList.txt
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\
?????文件???????36864??2010-09-25?11:34??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\DAL.dll
?????文件???????60928??2010-09-25?11:34??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\DAL.pdb
?????文件???????????9??2010-09-24?16:36??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\Desktop_1.ini
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\Refactor\
?????文件???????20480??2010-09-24?18:32??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\Refactor\DAL.dll
?????文件???????????9??2010-09-24?16:36??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\Refactor\Desktop_1.ini
?????文件????????2500??2010-09-25?11:34??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\TempPE\
?????文件???????????9??2010-09-24?16:36??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Debug\TempPE\Desktop_1.ini
?????文件???????????9??2010-09-24?16:36??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\obj\Desktop_1.ini
?????目錄???????????0??2010-10-16?14:42??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\Properties\
?????文件????????1325??2010-09-22?16:17??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\Properties\AssemblyInfo.cs
?????文件???????????9??2010-09-24?16:36??在線考試系統(tǒng)\在線考試系統(tǒng)\DAL\Properties\Desktop_1.ini
............此處省略159個文件信息