45fan.com - 路饭网

搜索: 您的位置主页 > 电脑频道 > 编程代码 > 阅读资讯:如何在ASP.NET餐饮管理系统中制作代码?

如何在ASP.NET餐饮管理系统中制作代码?

2016-06-04 07:59:48 来源:www.45fan.com 【

如何在ASP.NET餐饮管理系统中制作代码?

页面介绍展示:

如何在ASP.NET餐饮管理系统中制作代码?

如何在ASP.NET餐饮管理系统中制作代码?

如何在ASP.NET餐饮管理系统中制作代码?

如何在ASP.NET餐饮管理系统中制作代码?

以上是餐饮管理系统制作图片介绍,接下来是代码部分。

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"> 
< 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

<%@ 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

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餐饮管理系统制作关键代码,代码不够完整,本文的目的只是想给大家一个启发,制作餐饮管理系统的思路,希望能真正的帮助到大家。


本文地址:http://www.45fan.com/bcdm/52194.html
Tags: 制作 ASP.NET 餐饮
编辑:路饭网
推广内容
推荐阅读
热门推荐
推荐文章
关于我们 | 联系我们 | 友情链接 | 网站地图 | Sitemap | App | 返回顶部