使用ASP.NET编写一个餐饮管理系统？针对这个问题，这篇文章详细介绍了相对应的分析和解答，希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。
ASP.NET 是开源，跨平台，高性能，轻量级的 Web 应用构建框架，常用于通过 HTML、CSS、JavaScript 以及服务器脚本来构建网页和网站。
menu.aspx
<%@ 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">
< >
<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">
< >
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource2">
<HeaderTemplate >
<table border="1" >
<tr>
<td>图片</td>
<td>菜名</td>
<td>原价格</td>
<td>优惠价格</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td >
<asp:Image ID="Image1" runat="server" Height="88px"
ImageUrl='<%# Eval("menuPhoto") %>' Width="88px" />
</td>
<td >
<asp:Label ID="Label1" runat="server" Text='<%# Eval("menuName") %>'></asp:Label>
</td>
<td >
<asp:Label ID="Label2" runat="server" Text='<%# Eval("menuPrice") %>'></asp:Label>
</td>
<td >
<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="无标题页" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <form id="form1" runat="server"> < > <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" > <tr> <td > 序号</td> <td > 菜名</td> <td > 图片</td> <td > 付费</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
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]代码
//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编写一个餐饮管理系统问题的解答就分享到这里了，希望以上内容可以对大家有一定的帮助，如果你还有很多疑惑没有解开，可以关注亿速云行业资讯频道了解更多相关知识。
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
