資源簡介
ajax .net asp asp.net c# SQl2005 最新基礎技術構建的,三層架構分類寫的,可以給初學Web開發分層的同道參考!特別還希望有在方面特長的高手指教!這次我把數據庫全部上傳上來,SQL2005的分頁存儲過程!
代碼片段和文件信息
using?System;
using?System.Web;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?DAL;
namespace?BLL
{
????public?class?Admin
????{
????????//==========properties==========
????????private?string?_username;
????????private?string?_password;
????????public?string?username
????????{
????????????get?{?return?_username;?}
????????????set
????????????{
????????????????if?(value.Length?>?16)?_username?=?value.Substring(0?16);
????????????????else?_username?=?value;
????????????}
????????}
????????public?string?password
????????{
????????????get?{?return?_password;?}
????????????set
????????????{
????????????????if?(value.Length?>?16)?_password?=?value.Substring(0?16);
????????????????else?_password?=?value;
????????????}
????????}
????????
????????//==========methods==========
????????//login
????????public?static?bool?Login(string?username?string?password)
????????{
????????????string?sql?=?“select?password?from?admin?where?username=@username“;
????????????SqlParameter[]?pars?=?new?SqlParameter[]
????????????{
????????????????new?SqlParameter(“username“?username)
????????????};
????????????object?pwd?=?DBHelp.ExecuteScalar(sql?pars);
????????????if?(pwd?==?null)?return?false;
????????????else?if?(pwd.ToString()?==?password)
????????????{
????????????????HttpCookie?cookie?=?new?HttpCookie(“admin_login“);
????????????????cookie.Value?=?username;
????????????????HttpContext.Current.Response.Cookies.Add(cookie);
????????????????return?true;
????????????}
????????????else
????????????????return?false;
????????}
????????//logout
????????public?static?void?Logout()
????????{
????????????HttpCookie?cookie?=?new?HttpCookie(“admin_login“);
????????????cookie.Expires?=?DateTime.Now.AddYears(-1);
????????????HttpContext.Current.Response.Cookies.Add(cookie);
????????}
????????//get?current?admin
????????public?static?Admin?GetCurrentAdmin()
????????{
????????????HttpCookie?cookie?=?HttpContext.Current.Request.Cookies[“admin_login“];
????????????if?(cookie?==?null)?return?null;
????????????if?(cookie.Value?==?null)?return?null;
????????????string?sql?=?“select?password?from?admin?where?username=@username“;
????????????SqlParameter[]?pars?=?new?SqlParameter[]
????????????{
????????????????new?SqlParameter(“username“?cookie.Value)
????????????};
????????????object?pwd?=?DBHelp.ExecuteScalar(sql?pars);
????????????if?(pwd?==?null)?return?null;
????????????Admin?a?=?new?Admin();
????????????a.username?=?cookie.Value;
????????????a.password?=?pwd.ToString();
????????????return?a;
????????}
????????//update
????????public?bool?Update()
????????{
????????????string?sql?=?“update?admin?set?password=@password?where?username=@username“;
????????????SqlParameter[]?pars?=?new?SqlParameter[]
????????????{
????????????????new?SqlParameter(“username“?username)
????????????????new?SqlParameter(“password“?pass
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-04-15?18:19??MusicOnline\
?????目錄???????????0??2012-05-07?23:11??MusicOnline\BLL\
?????文件????????3530??2012-04-12?11:19??MusicOnline\BLL\Admin.cs
?????目錄???????????0??2012-04-15?18:19??MusicOnline\BLL\bin\
?????目錄???????????0??2012-04-15?18:19??MusicOnline\BLL\bin\Debug\
?????文件???????19456??2012-04-12?11:20??MusicOnline\BLL\bin\Debug\BLL.dll
?????文件???????48640??2012-04-12?11:20??MusicOnline\BLL\bin\Debug\BLL.pdb
?????文件????????5632??2012-04-12?11:20??MusicOnline\BLL\bin\Debug\DAL.dll
?????文件???????13824??2012-04-12?11:20??MusicOnline\BLL\bin\Debug\DAL.pdb
?????文件????????2842??2012-04-12?11:19??MusicOnline\BLL\BLL.csproj
?????文件???????11990??2012-05-07?23:11??MusicOnline\BLL\Customer.cs
?????文件????????7949??2012-04-12?11:19??MusicOnline\BLL\Music.cs
?????目錄???????????0??2012-04-15?18:19??MusicOnline\BLL\obj\
?????目錄???????????0??2012-04-15?18:22??MusicOnline\BLL\obj\Debug\
?????文件????????1159??2012-04-12?11:20??MusicOnline\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt
?????文件???????19456??2012-04-12?11:20??MusicOnline\BLL\obj\Debug\BLL.dll
?????文件???????48640??2012-04-12?11:20??MusicOnline\BLL\obj\Debug\BLL.pdb
?????文件????????3782??2012-04-12?11:20??MusicOnline\BLL\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2012-04-15?18:22??MusicOnline\BLL\obj\Debug\TempPE\
?????目錄???????????0??2012-04-15?18:19??MusicOnline\BLL\Properties\
?????文件????????1348??2012-04-12?11:19??MusicOnline\BLL\Properties\AssemblyInfo.cs
?????文件????????2971??2012-04-12?11:19??MusicOnline\BLL\Tag.cs
?????目錄???????????0??2012-04-15?18:19??MusicOnline\DAL\
?????目錄???????????0??2012-04-15?18:19??MusicOnline\DAL\bin\
?????目錄???????????0??2012-04-15?18:19??MusicOnline\DAL\bin\Debug\
?????文件????????5632??2012-04-12?11:20??MusicOnline\DAL\bin\Debug\DAL.dll
?????文件???????13824??2012-04-12?11:20??MusicOnline\DAL\bin\Debug\DAL.pdb
?????文件????????2532??2012-04-12?11:19??MusicOnline\DAL\DAL.csproj
?????文件????????2896??2012-04-12?11:19??MusicOnline\DAL\DBHelp.cs
?????目錄???????????0??2012-04-15?18:19??MusicOnline\DAL\obj\
?????目錄???????????0??2012-04-15?18:22??MusicOnline\DAL\obj\Debug\
............此處省略193個文件信息
評論
共有 條評論