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


namespace?BLL
{
????public?class?UserManage
????{
????????DBAccess?DBA?=?new?DBAccess（）;
????????private?string?_msg;

????????public?string?msg
????????{
????????????get
????????????{
????????????????return?_msg;
????????????}
????????????set
????????????{
????????????????_msg?=?value;
????????????}
????????}

????????//構造函數
????????public?UserManage（）?{?}



????????public?bool?ChkLogin（string?strUid?string?strPwd?string?strRole）
????????{
????????????string?SQLStr?=?““;

????????????if?（strRole?==?“用戶“）
????????????{
????????????????SQLStr?=?“SELECT?*?FROM?Users?Where?UserName=‘“?+?strUid?+?“‘?and?Password?=?‘“?+?strPwd?+?“‘“;
????????????}
????????????else
????????????{
????????????????SQLStr?=?“SELECT?*?FROM?Admin?Where?UserName=‘“?+?strUid?+?“‘?and?Password?=?‘“?+?strPwd?+?“‘“;
????????????}

????????????DataTable?dt?=?DBA.GetDataTable（SQLStr）;


????????????if?（dt.Rows.Count?!=?0）
????????????{
????????????????return?true;
????????????}
????????????else
????????????{
????????????????return?false;
????????????}
????????}

????????public?DataSet?GetDataSet（）
????????{
????????????string?SQLStr?=?SQLStr?=?“select?*?from?Users“;
????????????return?DBA.GetDataSet（SQLStr）;

????????}

????????public?DataSet?GetUser（string?UserId）
????????{
????????????string?SQLStr?=?SQLStr?=?“select?*?from?Users?where?UserName=‘“?+?UserId?+?“‘“;
????????????return?DBA.GetDataSet（SQLStr）;
????????}


????????public?void?UpdateExeSql（string?vid?string?v0?string?v1?string?v2?string?v3?string?v4?string?v5?string?v6?string?v7）
????????{
????????????string?SQLStr1?=?“select?*?from?users?where?id=“?+?vid;
????????????string?SQLStr?=?“update?Users?set?UserName=‘“?+?v0?+?“‘Password=‘“?+?v1?+?“‘RealName=‘“?+?v2?+?“‘?Sex=‘“;
????????????SQLStr?=?SQLStr?+?v3?+?“‘Tel=‘“?+?v4?+?“‘Email=‘“?+?v5?+?“‘Address=‘“?+?v6?+?“‘Note=‘“?+?v7?+?“‘where?id=“?+?vid;
????????????//DBA.ExeSql（SQLStr）;
????????????if?（DBA.ExeSqlRows（SQLStr1）?>?0）
????????????{
????????????????DBA.ExeSql（SQLStr）;
????????????????msg?=?“操作成功!“;
????????????}
????????????else
????????????{
????????????????msg?=?“沒有更新!“;
????????????}
????????}


????????public?void?InsertExeSql（string?v0?string?v1?string?v2?string?v3?string?v4?string?v5?string?v6?string?v7）
????????{
????????????string?SQLStr1?=?“SELECT?UserName?FROM?Users?where?UserName=‘“?+?v0?+?“‘“;

????????????string?SQLStr?=?“insert?into?Users（UserNamePasswordRealNameSexTelEmailAddressNote）values（‘“;
????????????SQLStr?=?SQLStr?+?v0?+?“‘‘“?+?v1?+?“‘‘“?+?v2?+?“‘‘“?+?v3?+?“‘‘“?+?v4?+?“‘‘“?+?v5?+?“‘‘“?+?v6?+?“‘‘“?+?v7?+?“‘）“;

????????????if?（DBA.ExeSqlRows（SQLStr1）?==?0）
????????????{
????????????????DBA.ExeSql（SQLStr）;
????????????????msg?=?“操作成功!“;
????????????}
????????????else
????????????{

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-06-23?22:49??Asp?三層架構\
?????目錄???????????0??2012-06-13?23:06??Asp?三層架構\Bin\
?????文件???????20480??2012-06-12?15:32??Asp?三層架構\Bin\BLL.dll
?????文件??????????66??2012-06-13?23:06??Asp?三層架構\Bin\BLL.dll.refresh
?????文件???????15872??2012-06-12?15:32??Asp?三層架構\Bin\BLL.pdb
?????文件???????16384??2012-06-12?15:32??Asp?三層架構\Bin\DAL.dll
?????文件???????17920??2012-06-12?15:32??Asp?三層架構\Bin\DAL.pdb
?????目錄???????????0??2012-06-14?00:20??Asp?三層架構\UserManage\
?????目錄???????????0??2012-06-12?16:37??Asp?三層架構\UserManage\App_Data\
?????目錄???????????0??2012-06-12?19:21??Asp?三層架構\UserManage\BLL\
?????目錄???????????0??2012-06-12?19:21??Asp?三層架構\UserManage\BLL\bin\
?????目錄???????????0??2012-06-12?19:21??Asp?三層架構\UserManage\BLL\bin\Debug\
?????文件???????20480??2012-06-12?15:32??Asp?三層架構\UserManage\BLL\bin\Debug\BLL.dll
?????文件???????15872??2012-06-12?15:32??Asp?三層架構\UserManage\BLL\bin\Debug\BLL.pdb
?????文件???????16384??2012-06-12?15:32??Asp?三層架構\UserManage\BLL\bin\Debug\DAL.dll
?????文件???????17920??2012-06-12?15:32??Asp?三層架構\UserManage\BLL\bin\Debug\DAL.pdb
?????文件????????2144??2012-06-12?15:32??Asp?三層架構\UserManage\BLL\BLL.csproj
?????目錄???????????0??2012-06-13?12:37??Asp?三層架構\UserManage\BLL\obj\
?????文件?????????156??2012-06-12?16:18??Asp?三層架構\UserManage\BLL\obj\BLL.csproj.FileList.txt
?????文件?????????975??2012-06-13?12:37??Asp?三層架構\UserManage\BLL\obj\BLL.csproj.FileListAbsolute.txt
?????目錄???????????0??2012-06-13?12:36??Asp?三層架構\UserManage\BLL\obj\Debug\
?????文件???????20480??2012-06-12?15:32??Asp?三層架構\UserManage\BLL\obj\Debug\BLL.dll
?????文件???????15872??2012-06-12?15:32??Asp?三層架構\UserManage\BLL\obj\Debug\BLL.pdb
?????文件????????6385??2012-06-13?12:36??Asp?三層架構\UserManage\BLL\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2012-06-12?16:37??Asp?三層架構\UserManage\BLL\obj\Debug\TempPE\
?????目錄???????????0??2012-06-12?19:21??Asp?三層架構\UserManage\BLL\Properties\
?????文件????????1305??2012-06-12?14:04??Asp?三層架構\UserManage\BLL\Properties\AssemblyInfo.cs
?????文件????????3314??2012-06-12?14:13??Asp?三層架構\UserManage\BLL\UserManage.cs
?????目錄???????????0??2012-06-14?00:20??Asp?三層架構\UserManage\BookCodeDB\
?????文件?????2490368??2012-06-14?00:20??Asp?三層架構\UserManage\BookCodeDB\BookCodeDB_Data.MDF
?????文件?????4325376??2012-06-14?00:20??Asp?三層架構\UserManage\BookCodeDB\BookCodeDB_Log.LDF
............此處省略51個文件信息