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

namespace?BLL
{
????public?class?SqlAdmin
????{
????????public?bool?checkin（string?namestring?password）
????????{
????????????string?sql?=?“select?*?from?manage?where?aname=‘“?+?name?+?“‘?and?apassword?=‘“?+?password?+?“‘“;
????????????????SqlDataReader?dr?=?DBOperation.getReader（sql）;
????????????????if?（dr.Read（））
????????????????{
????????????????????return?true;
????????????????}????????????
????????????????return?false;
????????}
????????public?bool?insert（string?name）
????????{
????????????string?sql?=?“select?*?from?manage?where?aname=‘“?+?name?+?“‘“;
????????????SqlDataReader?dr?=?DBOperation.getReader（sql）;
????????????if?（dr.Read（））
????????????{
????????????????return?true;
????????????}
????????????return?false;
????????}
????????public?bool?checkup（string?namestring?id）
????????{
????????????string?sql?=?“select?*?from?manage?where?aname=‘“?+?name?+?“‘a(chǎn)nd?id!=“+id;
????????????SqlDataReader?dr?=?DBOperation.getReader（sql）;
????????????if?（dr.Read（））
????????????{
????????????????return?true;
????????????}
????????????return?false;
????????}
????????public?DataSet?FindAll（）
????????{
????????????string?sql?=?“select?*?from?manage“;
????????????return?DBOperation.getDataSet（sql?“manage“）;
????????}
????????public?adm?FindByid（string?id）
????????{

????????????string?sql?=?“select?*?from??manage?where?id=“?+?id;
????????????DataSet?ds?=?DBOperation.getDataSet（sql?“manage“）;
????????????adm?a?=?new?adm（）;
????????????a.Aname?=?ds.Tables[0].Rows[0][1].ToString（）;
????????????a.Apassword?=?ds.Tables[0].Rows[0][2].ToString（）;
????????????return?a;
????????}
????????public?void?Delete（string?id）
????????{
????????????string?sql?=?“delete?from?manage?where?id=“?+?id;
????????????DBOperation.execSQL（sql）;
????????}

????????public?DataSet?Find（adm?a）//
????????{
????????????string?sql;
????????????sql?=?“select?*?from?manage?where?id?>‘“?+?0?+?“‘“;
????????????if?（a.Aname?!=?““）
????????????????sql?+=?“?and?aname?like?‘%“?+?a.Aname?+?“%‘“;
????????????if?（a.Apassword?!=?““）
????????????????sql?+=?“?and?aname?like?‘“?+?a.Apassword?+?“‘“;
????????????return?DBOperation.getDataSet（sql?“Administrator“）;
????????}
????????public?int?update（adm?a）
????????{
????????????string?sql?=?“update?manage?set?aname=‘“?+?a.Aname?+?“‘a(chǎn)password=‘“?+?a.Apassword?+?“‘where?id=‘“+a.Id+“‘“;
????????????int?num?=?DBOperation.execSQL（sql）;
????????????return?num;
????????}

????????public?void?add（adm?a）
????????{
????????????string?sql?=?“insert?into?manage（anameapassword）?values（‘“?+?a.Aname?+?“‘‘“?+?a.Apassword?+?“‘）“;
????????????DBOperation.execSQL（sql）;
????????}
????????
????}
}

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

?????文件??????11776??2012-10-27?21:03??VoteSystem\BLL\bin\Debug\BLL.dll

?????文件??????46592??2012-10-27?21:03??VoteSystem\BLL\bin\Debug\BLL.pdb

?????文件???????8192??2012-10-27?21:03??VoteSystem\BLL\bin\Debug\DAL.dll

?????文件??????52736??2012-10-27?21:03??VoteSystem\BLL\bin\Debug\DAL.pdb

?????文件???????2653??2012-06-17?00:39??VoteSystem\BLL\BLL.csproj

?????文件???????1872??2012-10-27?21:03??VoteSystem\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt

?????文件??????11776??2012-10-27?21:03??VoteSystem\BLL\obj\Debug\BLL.dll

?????文件??????46592??2012-10-27?21:03??VoteSystem\BLL\obj\Debug\BLL.pdb

?????文件???????5680??2012-10-27?21:03??VoteSystem\BLL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????9981??2012-10-27?21:03??VoteSystem\BLL\obj\Debug\ResolveAssemblyReference.cache

?????文件???????1338??2012-06-08?08:41??VoteSystem\BLL\Properties\AssemblyInfo.cs

?????文件???????2857??2012-06-18?10:19??VoteSystem\BLL\SqlAdmin.cs

?????文件???????2229??2012-06-18?01:00??VoteSystem\BLL\SqlOperation.cs

?????文件???????2352??2012-06-18?11:14??VoteSystem\BLL\SqlOption.cs

?????文件???????1704??2012-06-17?00:16??VoteSystem\BLL\SqlUsers.cs

?????文件???????1470??2012-06-18?08:45??VoteSystem\BLL\SqlVote.cs

?????文件????????619??2012-06-18?10:19??VoteSystem\DAL\adm.cs

?????文件???????8192??2012-10-27?21:03??VoteSystem\DAL\bin\Debug\DAL.dll

?????文件??????52736??2012-10-27?21:03??VoteSystem\DAL\bin\Debug\DAL.pdb

?????文件???????2489??2012-06-15?15:50??VoteSystem\DAL\DAL.csproj

?????文件???????2253??2012-06-17?00:45??VoteSystem\DAL\DBOperation.cs

?????文件???????1370??2012-10-27?21:03??VoteSystem\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt

?????文件???????8192??2012-10-27?21:03??VoteSystem\DAL\obj\Debug\DAL.dll

?????文件??????52736??2012-10-27?21:03??VoteSystem\DAL\obj\Debug\DAL.pdb

?????文件???????5615??2012-10-27?21:03??VoteSystem\DAL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1338??2012-06-08?08:41??VoteSystem\DAL\Properties\AssemblyInfo.cs

?????文件???????1460??2012-06-12?11:03??VoteSystem\DAL\randomCode.cs

?????文件????????638??2012-06-12?11:03??VoteSystem\DAL\users.cs

?????文件????????768??2012-06-08?16:44??VoteSystem\DAL\vote_title.cs

?????文件????????955??2012-06-15?15:47??VoteSystem\DAL\xoption.cs

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