頁面介紹展示:
以上是餐飲管理系統(tǒng)制作圖片介紹,接下來是代碼部分。
menu.aspx
%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="menu.aspx.cs" Inherits="menu" Title="無標(biāo)題頁" %> 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="創(chuàng)菜日期" 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>優(yōu)惠價格/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
%@ Page Language="C#" MasterPageFile="~/Land-zhuce.master" AutoEventWireup="true" CodeFile="menuCar.aspx.cs" Inherits="menuCar" Title="無標(biāo)題頁" %> 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> 份數(shù)/td> td> 保存份數(shù)/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="繼續(xù)購物" OnClick="shoppingbtn_Click">/asp:Button> asp:Button id="delallbtn" runat="server" Text="清空購物車" OnClick="delallbtn_Click">/asp:Button> asp:Button id="orderbtn" runat="server" Text="結(jié)算中心" 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
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('沒有得到數(shù)據(jù),請重試!')/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)//若購物車有此產(chǎn)品則提示用戶 // { // Response.Write("script>alert('你已經(jīng)購買了此產(chǎn)品,只要更改數(shù)量就行!')/script>"); // } // else//若購物車沒有此產(chǎn)品則將此產(chǎn)品的相關(guān)信息插入購物車 // { // Response.Write("沒有??!"); // } //} //catch (Exception) //{ // Response.Write("script>alert('沒有得到數(shù)據(jù),請重試!')/script>"); //} DataListBind();//綁定數(shù)據(jù) //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();//綁定數(shù)據(jù) // 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('數(shù)量修改成功!')/script>"); DataListBind();//綁定數(shù)據(jù) // total_money();//計算價格 } else Response.Write("script>alert('數(shù)量修改失敗,請檢查!')/script>"); } else { } } }
[ASP/Basic]代碼
//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餐飲管理系統(tǒng)制作關(guān)鍵代碼,代碼不夠完整,本文的目的只是想給大家一個啟發(fā),制作餐飲管理系統(tǒng)的思路,希望能真正的幫助到大家。
標(biāo)簽:青海 贛州 崇左 衢州 汕尾 洛陽 南寧 巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《ASP.NET餐飲管理系統(tǒng)制作代碼分享》,本文關(guān)鍵詞 ASP.NET,餐飲,管理系統(tǒng),制作,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請?zhí)峁┫嚓P(guān)信息告之我們,我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無關(guān)。