using?System;
using?System.Collections;
using?System.Configuration;
using?System.Data;
using?System.Linq;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.HtmlControls;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.xml.Linq;
using?System.Data.Linq;

public?partial?class?BookInformation?:?System.Web.UI.Page
{
????private?int?bookID?=?-1;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Request.Params[“BookID“]?!=?null）
????????{
????????????if?（Int32.TryParse（Request.Params[“BookID“].ToString（）?out?bookID）?==?false）
????????????{
????????????????return;
????????????}
????????}
????????if?（!Page.IsPostBack）
????????{
????????????DataPageBind（bookID）;
????????????Datalist2（）;
????????}
????????if?（Session[“Username“]?!=?null）
????????{
????????????this.Panel未登錄.Visible?=?false;
????????????this.Panel已登錄.Visible?=?true;
????????????Lb用戶名.Text?=?Session[“Username“].ToString（）;
????????}
????}
????private?void?Datalist2（）
????{
????????string?sql?=?“select?*?from?Image“;
????????baseclass.BindDA（da?sql?“image“）;
????}
????private?void?DataPageBind（int?bookID）
????{
????????Book?book?=?new?Book（）;
????????ProjClass?prj?=?new?ProjClass（）;
????????string?sql?=?“select?*?from?Book?where?ID=“?+?bookID?+?““;
????????book?=?prj.GetBookInfoByID（sql）;
????????tbCreateDate.Text?=?book.CreateDate.ToString（）;
????????txtName.Text?=?book.Name;
????????tbOutprice.Text?=?book.Outprice.ToString（）;
????????tbSell.Text?=?book.Sell;
????????tbBName.Text?=?book.BName;
????????tbDesn.Text?=?book.Desn;
????????tbRemark.Text?=?book.Remark;
????????WebShoppingDBDataContext?db?=?new?WebShoppingDBDataContext（baseclass.conn）;
????????///添加導入數據選項
????????DataLoadOptions?dlo?=?new?DataLoadOptions（）;
????????dlo.LoadWith（p?=>?p.Pictures）;
????????db.LoadOptions?=?dlo;
????????///獲取商品信息
????????var?query?=?from?p?in?db.Book
????????????????????where?p.ID?==?bookID
????????????????????select?p;
????????if?（query.Count（）?>=?1）
????????{???///顯示商品的圖片
????????????imgBook.ImageUrl?=?“~/Admin/Book/ShowPicture.aspx?PictureID=“?+?query.First（）.PictureID.Value.ToString（）;
????????????///保存圖片的ID值
????????????ViewState[“PictureID“]?=?query.First（）.PictureID;
????????}
????}

????protected?void?but登陸_Click（object?sender?EventArgs?e）
????{
????????string?sql?=?“select?*?from?Users?where?Username=‘“?+?tbname.Text?+?“‘?and?Password=‘“?+?tbpwd.Text?+?“‘“;
????????if?（baseclass.CheckGM（sql））
????????{
????????????this.Panel未登錄.Visible?=?false;
????????????this.Panel已登錄.Visible?=?true;
????????????Lb用戶名.Text?=?this.tbname.Text.Trim（）;
????????????ProjClass?prj?=?new?ProjClass（）;
????????????string?sqll?=?“select?*?from?Users?where?Username=‘“?+?tbname.Text?+?“‘“;
????????????Users?user?=?prj.GetUserByName（sqll）;
????????????Session[“usersID“]?=?user.ID;
????????????Session[“Username“]?=?user.Username;
?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-01-25?10:01??BookShop\
?????目錄???????????0??2013-02-22?10:46??BookShop\Admin\
?????目錄???????????0??2013-02-16?09:53??BookShop\Admin\Book\
?????文件????????9376??2013-04-11?14:02??BookShop\Admin\Book\AddBook.aspx
?????文件????????2058??2013-02-22?10:58??BookShop\Admin\Book\AddBook.aspx.cs
?????文件????????2772??2013-06-09?19:42??BookShop\Admin\Book\AddCategory.aspx
?????文件????????1671??2013-06-09?19:43??BookShop\Admin\Book\AddCategory.aspx.cs
?????文件????????3950??2013-04-11?14:33??BookShop\Admin\Book\BookCategory.aspx
?????文件????????1138??2013-04-11?14:32??BookShop\Admin\Book\BookCategory.aspx.cs
?????文件????????5091??2013-03-15?17:12??BookShop\Admin\Book\BookInfo.aspx
?????文件????????1553??2013-02-24?11:19??BookShop\Admin\Book\BookInfo.aspx.cs
?????文件????????2211??2013-03-03?11:16??BookShop\Admin\Book\BookLeft.aspx
?????文件?????????544??2013-03-06?12:02??BookShop\Admin\Book\BookLeft.aspx.cs
?????文件?????????608??2013-03-03?11:18??BookShop\Admin\Book\BookMain.aspx
?????文件?????????291??2013-03-03?11:13??BookShop\Admin\Book\BookMain.aspx.cs
?????文件????????5774??2013-05-10?17:46??BookShop\Admin\Book\BookManage.aspx
?????文件????????3256??2013-05-10?17:46??BookShop\Admin\Book\BookManage.aspx.cs
?????文件????????3101??2013-03-02?22:42??BookShop\Admin\Book\BookPicture.aspx
?????文件????????4809??2013-03-03?10:22??BookShop\Admin\Book\BookPicture.aspx.cs
?????文件????????4000??2013-06-09?19:39??BookShop\Admin\Book\Category.aspx
?????文件????????2567??2013-03-06?15:20??BookShop\Admin\Book\Category.aspx.cs
?????文件????????2456??2013-02-19?17:02??BookShop\Admin\Book\CommentInfo.aspx
?????文件?????????517??2013-02-19?17:02??BookShop\Admin\Book\CommentInfo.aspx.cs
?????文件????????3444??2013-02-21?18:49??BookShop\Admin\Book\CommentManage.aspx
?????文件????????2279??2013-02-24?14:32??BookShop\Admin\Book\CommentManage.aspx.cs
?????文件????????9206??2013-02-21?23:11??BookShop\Admin\Book\EditBook.aspx
?????文件????????2556??2013-05-08?09:22??BookShop\Admin\Book\EditBook.aspx.cs
?????文件????????2783??2013-02-18?22:08??BookShop\Admin\Book\EditCategory.aspx
?????文件????????1885??2013-06-09?19:33??BookShop\Admin\Book\EditCategory.aspx.cs
?????文件????????3956??2013-04-12?11:51??BookShop\Admin\Book\OrderManage.aspx
?????文件????????2159??2013-05-06?18:57??BookShop\Admin\Book\OrderManage.aspx.cs
............此處省略393個文件信息