頁面介紹展示：
以上是餐飲管理系統制作圖片介紹，接下來是代碼部分。
menu.aspx
?
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="menu.aspx.cs" Inherits="menu" Title="無標題頁" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <form id="form1" runat="server"> < style="height: 300px"> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Height="299px" Width="544px" AllowPaging="True" PageSize="4"> <PagerSettings FirstPageText="首頁" LastPageText="末頁" Mode="NextPreviousFirstLast" NextPageText="下一頁" PreviousPageText="上一頁" /> <Columns> <asp:BoundField DataField="menuID" HeaderText="序號" InsertVisible="False" ReadOnly="True" SortExpression="menuID" /> <asp:BoundField DataField="menuName" HeaderText="菜名" SortExpression="menuName" /> <asp:ImageField DataImageUrlField="menuPhoto" HeaderText="圖片" ControlStyle-Height="30px" ControlStyle-Width="70px" SortExpression="menuPhoto" > <ControlStyle Height="30px" Width="70px"></ControlStyle> </asp:ImageField> <asp:BoundField DataField="menuCooker" HeaderText="廚師" SortExpression="menuCooker" /> <asp:BoundField DataField="menuStyle" HeaderText="菜系" SortExpression="menuStyle" /> <asp:BoundField DataField="menuPrice" HeaderText="價格" SortExpression="menuPrice" /> <asp:BoundField DataField="menuDate" HeaderText="創菜日期" SortExpression="menuDate" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>" SelectCommand="SELECT [menuID], [menuName], [menuPhoto], [menuCooker], [menuStyle], [menuPrice], [menuDate] FROM [Menus]"> </asp:SqlDataSource> </> </form> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server"> < style=" height:300px "> <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource2"> <HeaderTemplate > <table border="1" style="width: 104%; height: 36px"> <tr> <td>圖片</td> <td>菜名</td> <td>原價格</td> <td>優惠價格</td> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td style="width: 90px"> <asp:Image ID="Image1" runat="server" Height="88px" ImageUrl='<%# Eval("menuPhoto") %>' Width="88px" /> </td> <td style="width: 40px"> <asp:Label ID="Label1" runat="server" Text='<%# Eval("menuName") %>'></asp:Label> </td> <td style="width: 50px"> <asp:Label ID="Label2" runat="server" Text='<%# Eval("menuPrice") %>'></asp:Label> </td> <td style="width: 50px"> <asp:Label ID="Label3" runat="server" Text='<%# Eval("menuNewPrice") %>'></asp:Label> </td> </tr> </ItemTemplate> <FooterTemplate></table></FooterTemplate> </asp:DataList> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>" SelectCommand="SELECT [menuName], [menuPhoto], [menuNewPrice], [menuPrice] FROM [Menus] WHERE ([menuNewPrice] IS NOT NULL)"> </asp:SqlDataSource> </> </asp:Content> |
menuCar.aspx
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
?<%@ Page Language="C#" MasterPageFile="~/Land-zhuce.master" AutoEventWireup="true" CodeFile="menuCar.aspx.cs" Inherits="menuCar" Title="無標題頁" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <form id="form1" runat="server"> < style="height:350px"> <table id="Table1" cellSpacing="1" cellPadding="0" width="530" align="center" border="0"> <TR> <TD align="center"> <asp:label id="Label1" runat="server" Font-Size="X-Large" Font-Names="華文行楷" ForeColor="Blue">訂餐車</asp:label></TD> </TR> <TR> <TD align="center"> <asp:DataList ID="DataList1" runat="server" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" DataKeyField="ID" onupdatecommand="DataList1_UpdateCommand" OnDeleteCommand="DataList1_DeleteCommand" AllowPaging="true" PageSize="4" RepeatColumns="4"> <%-- <AlternatingItemStyle BackColor="PaleGoldenrod" /> <SelectedItemStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />--%> <HeaderTemplate> <table border="1" style="width: 100%"> <tr> <td style="width: 25px"> 序號</td> <td style="width: 33px"> 菜名</td> <td style="width: 49px"> 圖片</td> <td style="width: 30px"> 付費</td> <td> 份數</td> <td> 保存份數</td> <td> 刪除</td> </tr> </HeaderTemplate> <HeaderStyle BackColor="Tan" Font-Bold="True" /> <ItemTemplate> <tr> <td><%# DataBinder.Eval(Container.DataItem ,"goodID") %></td> <td><%# DataBinder.Eval(Container.DataItem ,"menuName") %></td> <%-- <td><%# DataBinder.Eval(Container.DataItem ,"menuPhoto") %></td>--%> <td><asp:Image ID="Image1" runat="server" Width="60px" Height="40px" ImageUrl='<%# DataBinder.Eval(Container.DataItem ,"menuPhUrl") %>'></asp:Image></td> <td><%# DataBinder.Eval(Container.DataItem ,"payMoney") %></td> <td><asp:TextBox ID="txtCount" runat="server" Width="32px" Text='<%# DataBinder.Eval(Container.DataItem ,"number") %>'></asp:TextBox></td> <td><asp:Button ID="bnMod" runat="server" Text="保存修改" CommandName="Update"></asp:Button></td> <td><asp:Button ID="Button1" runat="server" Text="刪除" CommandName= "Delete"/></td> </tr> </ItemTemplate> <FooterTemplate></table></FooterTemplate> <FooterStyle BackColor="Tan" /> </asp:DataList> </TD> </TR> <TR> <TD align="center" height="40">總金額： <asp:TextBox id="total_money_txt" runat="server" Width="82px"></asp:TextBox> <asp:Button id="shoppingbtn" runat="server" Text="繼續購物" OnClick="shoppingbtn_Click"></asp:Button> <asp:Button id="delallbtn" runat="server" Text="清空購物車" OnClick="delallbtn_Click"></asp:Button> <asp:Button id="orderbtn" runat="server" Text="結算中心" OnClick="orderbtn_Click"></asp:Button></TD> </TR> <TR> <TD align="center"></TD> </TR> <TR> <TD align="center"> </TD> </TR> </table> </> </form> </asp:Content> |
menuCar.aspx.cs
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
?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; public partial class menuCar : System.Web.UI.Page { String SqlStr; DB db = new DB(); DataSet Ds = new DataSet(); public void DataListBind() { SqlStr = "select * from OrderMenu where customerName='" + Session["UserName"] + "'"; //Ds = db.GetDataTableBySql(SqlStr); DataSet das = Dataoperator.getRows(SqlStr); DataList1.DataSource = das; DataList1.DataBind(); //try //{ // this.DataList1.DataSource = Ds.Tables[0].DefaultView; // this.DataList1.DataBind(); //} //catch (Exception) //{ // Response.Write("<script>alert('沒有得到數據,請重試！')</script>"); //} } protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { SqlStr = "select * from OrderMenu"; Ds = db.GetDataTableBySql(SqlStr); //try //{ // if (Ds.Tables[0].Rows.Count != 0)//若購物車有此產品則提示用戶 // { // Response.Write("<script>alert('你已經購買了此產品，只要更改數量就行！')</script>"); // } // else//若購物車沒有此產品則將此產品的相關信息插入購物車 // { // Response.Write("沒有！！"); // } //} //catch (Exception) //{ // Response.Write("<script>alert('沒有得到數據，請重試！')</script>"); //} DataListBind();//綁定數據 //total_money();//計算價格 } } protected void shoppingbtn_Click(object sender, EventArgs e) { Response.Redirect("orderMainMenu.aspx"); } protected void delallbtn_Click(object sender, EventArgs e) { } protected void orderbtn_Click(object sender, EventArgs e) { Response.Redirect("menuorder.aspx"); } protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e) { //String book_id = this.DataList1.DataKeys[e.Item.ItemIndex].ToString(); //SqlStr = "delete from 購物車表 where 圖書編號='" + book_id + "'"; //Boolean Del_Result; //Del_Result = db.UpdateDataBySql(SqlStr); //if (Del_Result == true) //{ // Response.Write("<script>alert('記錄刪除成功！')</script>"); // DataListBind();//綁定數據 // total_money();//計算價格 //} //else // Response.Write("<script>alert('記錄刪除失敗，請檢查！')</script>"); } protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e) { String book_id = this.DataList1.DataKeys[e.Item.ItemIndex].ToString(); TextBox count = (TextBox)this.DataList1.Items[e.Item.ItemIndex].FindControl("txtcount"); string SqlStr1 = "select * from Menus where menuNumber='" + Session["menu_number"] + "'"; Ds = Dataoperator.getRows(SqlStr1); if (Ds.Tables[0].Rows.Count>0) { int pric = Convert.ToInt32(Ds.Tables[0].Rows[0][6]); int mon = Convert.ToInt32(count.Text) * pric; //Session["payMon"] = mon.ToString(); //total_money_txt.Text = mon.ToString(); SqlStr = "update OrderMenu set number='" + Convert.ToInt32(count.Text) + "',payMoney='" + mon + "' where ID='" + book_id + "'"; Boolean Update_Result; Update_Result = db.UpdateDataBySql(SqlStr); if (Update_Result == true) { Response.Write("<script>alert('數量修改成功！')</script>"); DataListBind();//綁定數據 // total_money();//計算價格 } else Response.Write("<script>alert('數量修改失敗，請檢查！')</script>"); } else { } } } |
[ASP/Basic]代碼
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
//menuorder.aspx protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { //Session["Username"] = "ning"; // DataGridViewBind(); //total_money(); string sql = "select * from menuView where customerName='" + Session["UserName"] + "'"; Ds = Dataoperator.getRows(sql); int i = Ds.Tables[0].Rows.Count; int tem = 0; for (int j = 0; j < i; j++) { tem = Convert.ToInt32(Ds.Tables[0].Rows[j][5].ToString()) + tem; } total_money_txt.Text = tem.ToString(); } } protected void orderbtn_Click(object sender, EventArgs e) { string sql = "select * from menuView where customerName='" + Session["UserName"] + "'"; Ds = Dataoperator.getRows(sql); int i = Ds.Tables[0].Rows.Count; string strgoodid=""; string strcustomername = ""; string strmenuname = ""; string strnumber = ""; string deldate = ""; int strpaymoney = 0; if (i > 0) { bool te = false; for (int j = 0; j < i; j++) { strgoodid = Ds.Tables[0].Rows[j][0].ToString(); strcustomername = Ds.Tables[0].Rows[j][1].ToString(); strmenuname = Ds.Tables[0].Rows[j][2].ToString(); strnumber = Ds.Tables[0].Rows[j][3].ToString(); deldate = Ds.Tables[0].Rows[j][4].ToString(); strpaymoney = Convert.ToInt32(Ds.Tables[0].Rows[j][5]); tem++; string songdate = Calendar1.SelectedDate.ToString(); string stylePay = ddlpayment.SelectedValue.ToString(); string sakmenu = remarktxtbox.Text; string sqlind = "insert into IndentMenu values('" + strgoodid + "','" + strcustomername + "','" + strmenuname + "','" + strnumber + "','" + deldate + "','" + strpaymoney + "','" + songdate + "','" + stylePay + "','" + sakmenu + "')"; te = Dataoperator.exSql(sqlind); } if (te) { MessageBox.ShowPath("menuIndent.aspx"); } else { MessageBox.Show("存儲錯誤.."); } } else { MessageBox.Show("出錯了啊！！"); } } |
以上就是ASP.NET餐飲管理系統制作關鍵代碼，代碼不夠完整，本文的目的只是想給大家一個啟發，制作餐飲管理系統的思路，希望能真正的幫助到大家。
