資源簡介
沈陽大學的ASP.NET課程設計。
網上圖書銷售系統包含數據庫。使用SQL2005數據庫。
包含文檔以及程序,保證可以運行。

代碼片段和文件信息
using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
public?partial?class?DDList?:?System.Web.UI.Page
{
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
????????//?在此處放置用戶代碼以初始化頁面
????????if?(!Page.IsPostBack)
????????{
????????????DataTable?tmpda?=?new?DataTable();
????????????tmpda?=?Database.Get_Table(“select?*?from?gwcxxspxx??where?gwcxx.spbh=spxx.spbh?and?gwcxx.hydlm=‘“?+?Session[“UserID“].ToString()?+?“‘“);
????????????this.GridView1.DataSource?=?tmpda;
????????????this.GridView1.DataBind();
????????????this.GridView1.Columns[1].Visible?=?false;
????????????tmpda?=?Database.Get_Table(“select?*?from?hyxx?where?hydlm=‘“?+?Session[“UserID“].ToString()?+?“‘“);
????????????//從數據庫中計算出購物車中當前人員的總數量和總金額
????????????tmpda?=?Database.Get_Table(“select?sum(gwcxx.sl)sum(gwcxx.sl?*?spxx.spjg)?from?gwcxxspxx??where?gwcxx.spbh=spxx.spbh?and?gwcxx.hydlm=‘“?+?Session[“UserID“].ToString()?+?“‘“);
????????????if?(tmpda.Rows.Count?>?0)
????????????{
????????????????this.TextBox3.Text?=?tmpda.Rows[0][0].ToString();
????????????????this.TextBox4.Text?=?tmpda.Rows[0][1].ToString();
????????????}
????????????//初始化顯示控件內容
????????????this.TextBox1.Text?=?Guid.NewGuid().ToString();
????????????this.TextBox2.Text?=?Session[“UserID“].ToString();
????????????this.TextBox6.Text?=?DateTime.Now.Date.ToShortDateString();
????????????this.linkButton2.Attributes.Add(“onclick“?“return?confirm(‘訂單生成以后只能等待確認您不能再繼續操作是否確認生成訂單?‘);“);
????????}
????}
????protected?void?linkButton1_Click(object?sender?EventArgs?e)
????{
????????Response.Redirect(“GwcList.aspx“);
????}
????protected?void?linkButton2_Click(object?sender?EventArgs?e)
????{
????????if?(this.GridView1.Rows.Count?>?0)
????????{
????????????//循環保存購物車中的記錄到訂單明細表中
????????????for?(int?i?=?0;?i?????????????{
????????????????string?aa?=?“insert?into?hyddmx(ddbhspbhslje)?values(‘“?+?this.TextBox1.Text?+?“‘“?+?Convert.ToInt32(this.GridView1.Rows[i].Cells[1].Text)?+?““?+?Convert.ToDecimal(this.GridView1.Rows[i].Cells[4].Text)?+?““?+?Convert.ToDecimal(this.GridView1.Rows[i].Cells[3].Text)?*?Convert.ToDecimal(this.GridView1.Rows[i].Cells[4].Text)?+?“)“;
????????????????Database.ExecSql(“insert?into?hyddmx(ddbhspbhslje)?values(‘“?+?this.TextBox1.Text?+?“‘“?+?Convert.ToInt32(this.GridView1.Rows[i].Cells[1].Text)?+?““?+?Convert.ToDecimal(this.GridView1.Rows[i].Cells[4].Text)?+?““?+?Convert.ToDecimal(this.GridView1.Rows[i].Cells[3].Text)?*?Convert.ToDecimal(this.GridView1.Rows[i].Cells[4].Text)?+?“)“);
????????????}
????????????//保存訂單主表信息
????????????Database.ExecSql(“insert?into?hyddhz(ddbhhydlmzslzjeddrq)?values(‘“?+?this.TextBox1.Text?+?“‘‘“?+?Session[“UserID“].ToString()?+?“‘“?+?Convert.ToDecimal(t
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????467??2010-03-13?18:30??網上圖書銷售系統\Admin\Admindier.aspx
?????文件????????416??2010-03-13?17:46??網上圖書銷售系統\Admin\Admindier.aspx.cs
?????文件???????2727??2011-04-17?18:52??網上圖書銷售系統\Admin\AdminEdit.aspx
?????文件???????3293??2011-04-25?18:46??網上圖書銷售系統\Admin\AdminEdit.aspx.cs
?????文件??????12655??2014-03-17?19:25??網上圖書銷售系統\Admin\AdminLeft.aspx
?????文件????????440??2010-03-13?17:38??網上圖書銷售系統\Admin\AdminLeft.aspx.cs
?????文件???????3056??2011-04-17?18:51??網上圖書銷售系統\Admin\AdminList.aspx
?????文件???????2354??2011-04-17?18:58??網上圖書銷售系統\Admin\AdminList.aspx.cs
?????文件????????446??2010-03-14?11:23??網上圖書銷售系統\Admin\AdminMain.aspx
?????文件????????416??2010-03-13?17:14??網上圖書銷售系統\Admin\AdminMain.aspx.cs
?????文件???????1251??2010-03-13?23:15??網上圖書銷售系統\Admin\AdminTop.aspx
?????文件????????532??2010-03-13?23:17??網上圖書銷售系統\Admin\AdminTop.aspx.cs
?????文件???????2309??2011-04-17?19:08??網上圖書銷售系統\Admin\A_news.aspx
?????文件???????3078??2011-04-19?21:10??網上圖書銷售系統\Admin\A_news.aspx.cs
?????文件???????3070??2011-04-17?19:19??網上圖書銷售系統\Admin\A_newslist.aspx
?????文件???????2349??2011-04-20?09:52??網上圖書銷售系統\Admin\A_newslist.aspx.cs
?????文件???????3566??2011-04-21?11:34??網上圖書銷售系統\Admin\DDList.aspx
?????文件???????3409??2011-04-25?18:44??網上圖書銷售系統\Admin\DDList.aspx.cs
?????文件???????4344??2011-05-04?20:36??網上圖書銷售系統\Admin\DDSee.aspx
?????文件???????2043??2010-04-20?00:52??網上圖書銷售系統\Admin\DDSee.aspx.cs
?????文件????????176??2007-12-17?16:20??網上圖書銷售系統\Admin\Img\add.gif
?????文件???????2038??2007-09-20?15:17??網上圖書銷售系統\Admin\Img\admin_left_1.gif
?????文件???????1131??2007-09-20?15:17??網上圖書銷售系統\Admin\Img\admin_left_2.gif
?????文件???????1998??2007-09-20?15:17??網上圖書銷售系統\Admin\Img\admin_left_3.gif
?????文件???????2012??2007-09-20?15:17??網上圖書銷售系統\Admin\Img\admin_left_4.gif
?????文件??????19456??2009-02-28?19:11??網上圖書銷售系統\Admin\Img\Thumbs.db
?????文件???????2872??2007-09-20?16:00??網上圖書銷售系統\Admin\Img\ti
?????文件???????1995??2007-09-20?15:17??網上圖書銷售系統\Admin\Img\ti
?????文件???????2950??2011-04-22?17:00??網上圖書銷售系統\Admin\liuyan.aspx
?????文件???????2314??2011-04-22?17:03??網上圖書銷售系統\Admin\liuyan.aspx.cs
............此處省略172個文件信息
評論
共有 條評論