using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;

using?System.Data;
using?System.Data.SqlClient;
using?Models;
namespace?DAL
{
????///?

????///?管理員數據訪問類
????///?

???public?class?AdminService
????{
????????///?

????????///?根據用戶名或密碼登入
????????///?

????????///?
????????///?
????????public?Admin?AdminLogin（Admin?objAdmin）
????????{
????????????string?sql?=?“select?AdminName?from?Admins?where?LoginId={0}?and?LoginPwd=‘{1}‘“;
????????????sql?=?string.Format（sql?objAdmin.LoginId?objAdmin.LoginPwd）;
????????????try
????????????{
????????????????SqlDataReader?objReader?=?SQLHelper.GetReader（sql）;
????????????????if?（objReader.Read（））
????????????????{
????????????????????objAdmin.AdminName?=?objReader[“AdminName“].ToString（）;
????????????????}
????????????????else
????????????????{
????????????????????objAdmin?=?null;
????????????????}
????????????????objReader.Close（）;
????????????????return?objAdmin;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????throw?new?Exception（“數據訪問發生異常：“?+?ex.Message）;
????????????}

????????}
????????///?

????????///?修改密碼調用函數
????????///?

????????///?登入ID編號
????????///?新密碼
????????///?
????????public?int?ModifyPwd（string?newPwdstring?loginId）
????????{
????????????string?sql?=?“update?Admins?set?LoginPwd=‘{0}‘?where?LoginId=‘{1}‘“;
????????????sql?=?string.Format（sql?newPwd?loginId）;
????????????return?SQLHelper.Update（sql）;
????????}

????}
}

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

?????文件?????363008??2017-04-18?14:11??StudentManager\.vs\StudentManagerPro\v14\-孫正棟的電腦.suo

????..A..H.????366080??2017-06-04?17:50??StudentManager\.vs\StudentManagerPro\v14\.suo

?????文件???????1788??2017-04-04?16:48??StudentManager\DAL\AdminService.cs

?????文件???????4815??2017-04-14?22:35??StudentManager\DAL\AttendanceService.cs

?????文件??????21504??2017-04-16?21:54??StudentManager\DAL\bin\Debug\DAL.dll

?????文件??????42496??2017-04-16?21:54??StudentManager\DAL\bin\Debug\DAL.pdb

?????文件???????9216??2017-04-16?20:06??StudentManager\DAL\bin\Debug\Models.dll

?????文件??????32256??2017-04-16?20:06??StudentManager\DAL\bin\Debug\Models.pdb

?????文件???????2929??2017-04-11?22:00??StudentManager\DAL\DAL.csproj

?????文件???????1005??2017-04-03?11:48??StudentManager\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt

?????文件???????6372??2017-04-16?20:06??StudentManager\DAL\obj\Debug\DAL.csprojResolveAssemblyReference.cache

?????文件??????21504??2017-04-16?21:54??StudentManager\DAL\obj\Debug\DAL.dll

?????文件??????42496??2017-04-16?21:54??StudentManager\DAL\obj\Debug\DAL.pdb

?????文件???????6869??2017-06-04?10:36??StudentManager\DAL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????3895??2017-04-05?12:34??StudentManager\DAL\OleDbHelper.cs

?????文件???????1332??2017-04-03?11:21??StudentManager\DAL\Properties\AssemblyInfo.cs

?????文件???????5724??2017-04-16?21:54??StudentManager\DAL\ScoreListService.cs

?????文件??????11524??2017-04-16?19:06??StudentManager\DAL\SQLHelper.cs

?????文件???????1235??2017-04-16?19:09??StudentManager\DAL\StudentClassService.cs

?????文件??????10663??2017-04-14?21:55??StudentManager\DAL\StudentService.cs

?????文件??????21504??2017-04-16?21:54??StudentManager\ExcelPrint\bin\Debug\DAL.dll

?????文件??????42496??2017-04-16?21:54??StudentManager\ExcelPrint\bin\Debug\DAL.pdb

?????文件??????13824??2017-04-16?21:54??StudentManager\ExcelPrint\bin\Debug\ExcelPrint.dll

?????文件??????15872??2017-04-16?21:54??StudentManager\ExcelPrint\bin\Debug\ExcelPrint.pdb

?????文件???????9216??2017-04-16?20:06??StudentManager\ExcelPrint\bin\Debug\Models.dll

?????文件??????32256??2017-04-16?20:06??StudentManager\ExcelPrint\bin\Debug\Models.pdb

?????文件???????4664??2017-04-08?22:10??StudentManager\ExcelPrint\ExcelPrint.csproj

?????文件???????7572??2017-06-04?10:36??StudentManager\ExcelPrint\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1716??2017-04-08?22:10??StudentManager\ExcelPrint\obj\Debug\ExcelPrint.csproj.FileListAbsolute.txt

?????文件???????1735??2017-06-04?10:36??StudentManager\ExcelPrint\obj\Debug\ExcelPrint.csproj.ResolveComReference.cache

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