溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
這篇文章將為大家詳細講解有關C#怎么實現餐飲管理系統，小編覺得挺實用的，因此分享給大家做個參考，希望大家閱讀完這篇文章后可以有所收獲。
部分代碼：
Dataoperator.cs
using System;
using System.Data;
using System.Configuration;
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;
using System.Data.SqlClient;
/// <summary>
///Dataoperator 的摘要說明
/// </summary>
public class Dataoperator
{
public Dataoperator()
{
//
//TODO: 在此處添加構造函數邏輯
//
}
public static SqlConnection creatcon()
{
string strcon = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection con = new SqlConnection(strcon);
return con;
}
/// 查詢的數據是否已經存在
/// </summary>
/// <param name="sql">需要執行的SQL語句</param>
/// <returns>返回布爾值，true表示已經存在，false表示不存在</returns>
public static bool isData(string sql)
{
//創建數據庫連接
SqlConnection con = creatcon();
//打開數據庫連接
con.Open();
//創建Command對象
SqlCommand com = new SqlCommand(sql, con);
//獲取ExecuteScalar方法所返回的值
int ex = Convert.ToInt32(com.ExecuteScalar());
//關閉數據庫連接
con.Close();
//判斷整型變量并返回相應的布爾值
if (ex > 0)
{
return true;
}
else
{
return false;
}
}
/// 執行數據庫中的更新、插入、刪除操作
/// </summary>
/// <param name="sql">需要執行的SQL語句</param>
/// <returns>返回布爾值，true表示已存在，false表示不存在</returns>
public static bool exSql(string sql)
{
SqlConnection con = creatcon();
con.Open();
SqlCommand com = new SqlCommand(sql, con);
int rows = Convert.ToInt32(com.ExecuteNonQuery());
if (rows > 0)
return true;
else
return false;
}
public static string getTier(string sql) //返回指定列的值
{
//SqlConnection con = creatcon()
//con.Open();
//SqlCommand cmd = new SqlCommand(sql, con);
////獲得記錄行
//SqlDataReader sdr = cmd.ExecuteReader();
//sdr.Read();
//string str = sdr[0].ToString();
//con.Close();
//return str;
SqlConnection con = creatcon();
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
sda.Fill(ds);
string str = ds.Tables[0].Rows[0][0].ToString();
return str;
}
public static DataSet getRows(string sql) //返回所查詢表中所有數據
{
//創建數據庫連接
SqlConnection con = creatcon();
//打開數據連接
//創建DataAdapter對象
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
//創建DataSet對象
DataSet ds = new DataSet();
//通過Fill方法
sda.Fill(ds);
//關閉數據庫連接
//返回DataSet對象
return ds;
}
}MessageBox.cs
using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
///MessageBox 的摘要說明
/// </summary>
public class MessageBox
{
public MessageBox()
{
//
//TODO: 在此處添加構造函數邏輯
//
}
public static void Show(string messageInfo)
{
HttpContext.Current.Response.Write("<script>alert('"+messageInfo+"')</script>");
}
public static void Show(string messageInfo, string pagePath)
{
HttpContext.Current.Response.Write("<script>alert('"+messageInfo+"');location='"+pagePath+"'</script>");
}
public static void ShowPath(string pagePath)
{
HttpContext.Current.Response.Write("<script>location='" + pagePath + "'</script>");
}
}UserInformation.designer.cs
#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
// 此代碼由工具生成。
// 運行庫版本:2.0.50727.1891
//
// 對此文件的更改可能會導致不正確的行為，并且如果
// 重新生成代碼，這些更改將會丟失。
// </auto-generated>
//------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
[System.Data.Linq.Mapping.DatabaseAttribute(Name="MenuLinq")]
public partial class UserInformationDataContext : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
#region Extensibility Method Definitions
partial void OnCreated();
partial void Insert用戶信息(用戶信息 instance);
partial void Update用戶信息(用戶信息 instance);
partial void Delete用戶信息(用戶信息 instance);
partial void Insert訂餐信息(訂餐信息 instance);
partial void Update訂餐信息(訂餐信息 instance);
partial void Delete訂餐信息(訂餐信息 instance);
partial void Insert菜樣信息(菜樣信息 instance);
partial void Update菜樣信息(菜樣信息 instance);
partial void Delete菜樣信息(菜樣信息 instance);
#endregion
public UserInformationDataContext() :
base(global::System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString, mappingSource)
{
OnCreated();
}
public UserInformationDataContext(string connection) :
base(connection, mappingSource)
{
OnCreated();
}
public UserInformationDataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}
public UserInformationDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public UserInformationDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public System.Data.Linq.Table<用戶信息> 用戶信息
{
get
{
return this.GetTable<用戶信息>();
}
}
public System.Data.Linq.Table<訂餐信息> 訂餐信息
{
get
{
return this.GetTable<訂餐信息>();
}
}
public System.Data.Linq.Table<菜樣信息> 菜樣信息
{
get
{
return this.GetTable<菜樣信息>();
}
}
}
[Table(Name="dbo.用戶信息")]
public partial class 用戶信息 : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _序號;
private string _用戶名;
private string _用戶密碼;
private string _郵箱;
private string _住址;
private string _手機號;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void On序號Changing(int value);
partial void On序號Changed();
partial void On用戶名Changing(string value);
partial void On用戶名Changed();
partial void On用戶密碼Changing(string value);
partial void On用戶密碼Changed();
partial void On郵箱Changing(string value);
partial void On郵箱Changed();
partial void On住址Changing(string value);
partial void On住址Changed();
partial void On手機號Changing(string value);
partial void On手機號Changed();
#endregion
public 用戶信息()
{
OnCreated();
}
[Column(Storage="_序號", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int 序號
{
get
{
return this._序號;
}
set
{
if ((this._序號 != value))
{
this.On序號Changing(value);
this.SendPropertyChanging();
this._序號 = value;
this.SendPropertyChanged("序號");
this.On序號Changed();
}
}
}
[Column(Storage="_用戶名", DbType="NChar(10)")]
public string 用戶名
{
get
{
return this._用戶名;
}
set
{
if ((this._用戶名 != value))
{
this.On用戶名Changing(value);
this.SendPropertyChanging();
this._用戶名 = value;
this.SendPropertyChanged("用戶名");
this.On用戶名Changed();
}
}
}
[Column(Storage="_用戶密碼", DbType="VarChar(50)")]
public string 用戶密碼
{
get
{
return this._用戶密碼;
}
set
{
if ((this._用戶密碼 != value))
{
this.On用戶密碼Changing(value);
this.SendPropertyChanging();
this._用戶密碼 = value;
this.SendPropertyChanged("用戶密碼");
this.On用戶密碼Changed();
}
}
}
[Column(Storage="_郵箱", DbType="VarChar(50)")]
public string 郵箱
{
get
{
return this._郵箱;
}
set
{
if ((this._郵箱 != value))
{
this.On郵箱Changing(value);
this.SendPropertyChanging();
this._郵箱 = value;
this.SendPropertyChanged("郵箱");
this.On郵箱Changed();
}
}
}
[Column(Storage="_住址", DbType="VarChar(50)")]
public string 住址
{
get
{
return this._住址;
}
set
{
if ((this._住址 != value))
{
this.On住址Changing(value);
this.SendPropertyChanging();
this._住址 = value;
this.SendPropertyChanged("住址");
this.On住址Changed();
}
}
}
[Column(Storage="_手機號", DbType="VarChar(50)")]
public string 手機號
{
get
{
return this._手機號;
}
set
{
if ((this._手機號 != value))
{
this.On手機號Changing(value);
this.SendPropertyChanging();
this._手機號 = value;
this.SendPropertyChanged("手機號");
this.On手機號Changed();
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
[Table(Name="dbo.訂餐信息")]
public partial class 訂餐信息 : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _序號;
private System.Nullable<int> _菜樣編號;
private string _菜名;
private string _菜樣圖片;
private System.Nullable<int> _份數;
private System.Nullable<int> _菜價;
private System.Nullable<int> _應付金額;
private string _訂餐日期;
private string _用戶名;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void On序號Changing(int value);
partial void On序號Changed();
partial void On菜樣編號Changing(System.Nullable<int> value);
partial void On菜樣編號Changed();
partial void On菜名Changing(string value);
partial void On菜名Changed();
partial void On菜樣圖片Changing(string value);
partial void On菜樣圖片Changed();
partial void On份數Changing(System.Nullable<int> value);
partial void On份數Changed();
partial void On菜價Changing(System.Nullable<int> value);
partial void On菜價Changed();
partial void On應付金額Changing(System.Nullable<int> value);
partial void On應付金額Changed();
partial void On訂餐日期Changing(string value);
partial void On訂餐日期Changed();
partial void On用戶名Changing(string value);
partial void On用戶名Changed();
#endregion
public 訂餐信息()
{
OnCreated();
}
[Column(Storage="_序號", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int 序號
{
get
{
return this._序號;
}
set
{
if ((this._序號 != value))
{
this.On序號Changing(value);
this.SendPropertyChanging();
this._序號 = value;
this.SendPropertyChanged("序號");
this.On序號Changed();
}
}
}
[Column(Storage="_菜樣編號", DbType="Int")]
public System.Nullable<int> 菜樣編號
{
get
{
return this._菜樣編號;
}
set
{
if ((this._菜樣編號 != value))
{
this.On菜樣編號Changing(value);
this.SendPropertyChanging();
this._菜樣編號 = value;
this.SendPropertyChanged("菜樣編號");
this.On菜樣編號Changed();
}
}
}
[Column(Storage="_菜名", DbType="NChar(10)")]
public string 菜名
{
get
{
return this._菜名;
}
set
{
if ((this._菜名 != value))
{
this.On菜名Changing(value);
this.SendPropertyChanging();
this._菜名 = value;
this.SendPropertyChanged("菜名");
this.On菜名Changed();
}
}
}
[Column(Storage="_菜樣圖片", DbType="NChar(30)")]
public string 菜樣圖片
{
get
{
return this._菜樣圖片;
}
set
{
if ((this._菜樣圖片 != value))
{
this.On菜樣圖片Changing(value);
this.SendPropertyChanging();
this._菜樣圖片 = value;
this.SendPropertyChanged("菜樣圖片");
this.On菜樣圖片Changed();
}
}
}
[Column(Storage="_份數", DbType="Int")]
public System.Nullable<int> 份數
{
get
{
return this._份數;
}
set
{
if ((this._份數 != value))
{
this.On份數Changing(value);
this.SendPropertyChanging();
this._份數 = value;
this.SendPropertyChanged("份數");
this.On份數Changed();
}
}
}
[Column(Storage="_菜價", DbType="Int")]
public System.Nullable<int> 菜價
{
get
{
return this._菜價;
}
set
{
if ((this._菜價 != value))
{
this.On菜價Changing(value);
this.SendPropertyChanging();
this._菜價 = value;
this.SendPropertyChanged("菜價");
this.On菜價Changed();
}
}
}
[Column(Storage="_應付金額", DbType="Int")]
public System.Nullable<int> 應付金額
{
get
{
return this._應付金額;
}
set
{
if ((this._應付金額 != value))
{
this.On應付金額Changing(value);
this.SendPropertyChanging();
this._應付金額 = value;
this.SendPropertyChanged("應付金額");
this.On應付金額Changed();
}
}
}
[Column(Storage="_訂餐日期", DbType="NVarChar(50)")]
public string 訂餐日期
{
get
{
return this._訂餐日期;
}
set
{
if ((this._訂餐日期 != value))
{
this.On訂餐日期Changing(value);
this.SendPropertyChanging();
this._訂餐日期 = value;
this.SendPropertyChanged("訂餐日期");
this.On訂餐日期Changed();
}
}
}
[Column(Storage="_用戶名", DbType="NChar(15)")]
public string 用戶名
{
get
{
return this._用戶名;
}
set
{
if ((this._用戶名 != value))
{
this.On用戶名Changing(value);
this.SendPropertyChanging();
this._用戶名 = value;
this.SendPropertyChanged("用戶名");
this.On用戶名Changed();
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
[Table(Name="dbo.菜樣信息")]
public partial class 菜樣信息 : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _序號;
private int _菜樣編號;
private string _菜名;
private string _菜樣類型;
private string _菜樣圖片;
private string _廚師;
private System.Nullable<int> _現在價格;
private System.Nullable<int> _優惠價格;
private string _創菜時間;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void On序號Changing(int value);
partial void On序號Changed();
partial void On菜樣編號Changing(int value);
partial void On菜樣編號Changed();
partial void On菜名Changing(string value);
partial void On菜名Changed();
partial void On菜樣類型Changing(string value);
partial void On菜樣類型Changed();
partial void On菜樣圖片Changing(string value);
partial void On菜樣圖片Changed();
partial void On廚師Changing(string value);
partial void On廚師Changed();
partial void On現在價格Changing(System.Nullable<int> value);
partial void On現在價格Changed();
partial void On優惠價格Changing(System.Nullable<int> value);
partial void On優惠價格Changed();
partial void On創菜時間Changing(string value);
partial void On創菜時間Changed();
#endregion
public 菜樣信息()
{
OnCreated();
}
[Column(Storage="_序號", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int 序號
{
get
{
return this._序號;
}
set
{
if ((this._序號 != value))
{
this.On序號Changing(value);
this.SendPropertyChanging();
this._序號 = value;
this.SendPropertyChanged("序號");
this.On序號Changed();
}
}
}
[Column(Storage="_菜樣編號", DbType="Int NOT NULL")]
public int 菜樣編號
{
get
{
return this._菜樣編號;
}
set
{
if ((this._菜樣編號 != value))
{
this.On菜樣編號Changing(value);
this.SendPropertyChanging();
this._菜樣編號 = value;
this.SendPropertyChanged("菜樣編號");
this.On菜樣編號Changed();
}
}
}
[Column(Storage="_菜名", DbType="NChar(10)")]
public string 菜名
{
get
{
return this._菜名;
}
set
{
if ((this._菜名 != value))
{
this.On菜名Changing(value);
this.SendPropertyChanging();
this._菜名 = value;
this.SendPropertyChanged("菜名");
this.On菜名Changed();
}
}
}
[Column(Storage="_菜樣類型", DbType="NChar(10)")]
public string 菜樣類型
{
get
{
return this._菜樣類型;
}
set
{
if ((this._菜樣類型 != value))
{
this.On菜樣類型Changing(value);
this.SendPropertyChanging();
this._菜樣類型 = value;
this.SendPropertyChanged("菜樣類型");
this.On菜樣類型Changed();
}
}
}
[Column(Storage="_菜樣圖片", DbType="NVarChar(50)")]
public string 菜樣圖片
{
get
{
return this._菜樣圖片;
}
set
{
if ((this._菜樣圖片 != value))
{
this.On菜樣圖片Changing(value);
this.SendPropertyChanging();
this._菜樣圖片 = value;
this.SendPropertyChanged("菜樣圖片");
this.On菜樣圖片Changed();
}
}
}
[Column(Storage="_廚師", DbType="NChar(15)")]
public string 廚師
{
get
{
return this._廚師;
}
set
{
if ((this._廚師 != value))
{
this.On廚師Changing(value);
this.SendPropertyChanging();
this._廚師 = value;
this.SendPropertyChanged("廚師");
this.On廚師Changed();
}
}
}
[Column(Storage="_現在價格", DbType="Int")]
public System.Nullable<int> 現在價格
{
get
{
return this._現在價格;
}
set
{
if ((this._現在價格 != value))
{
this.On現在價格Changing(value);
this.SendPropertyChanging();
this._現在價格 = value;
this.SendPropertyChanged("現在價格");
this.On現在價格Changed();
}
}
}
[Column(Storage="_優惠價格", DbType="Int")]
public System.Nullable<int> 優惠價格
{
get
{
return this._優惠價格;
}
set
{
if ((this._優惠價格 != value))
{
this.On優惠價格Changing(value);
this.SendPropertyChanging();
this._優惠價格 = value;
this.SendPropertyChanged("優惠價格");
this.On優惠價格Changed();
}
}
}
[Column(Storage="_創菜時間", DbType="NChar(20)")]
public string 創菜時間
{
get
{
return this._創菜時間;
}
set
{
if ((this._創菜時間 != value))
{
this.On創菜時間Changing(value);
this.SendPropertyChanging();
this._創菜時間 = value;
this.SendPropertyChanged("創菜時間");
this.On創菜時間Changed();
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
#pragma warning restore 1591C#是一個簡單、通用、面向對象的編程語言，它由微軟Microsoft開發，繼承了C和C++強大功能，并且去掉了一些它們的復雜特性，C#綜合了VB簡單的可視化操作和C++的高運行效率，以其強大的操作能力、優雅的語法風格、創新的語言特性和便捷的面向組件編程從而成為.NET開發的首選語言，但它不適用于編寫時間急迫或性能非常高的代碼，因為C#缺乏性能極高的應用程序所需要的關鍵功能。
關于“C#怎么實現餐飲管理系統”這篇文章就分享到這里了，希望以上內容可以對大家有一定的幫助，使各位可以學到更多知識，如果覺得文章不錯，請把它分享出去讓更多的人看到。
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
