完整版的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 1591
源码下载： C#实现餐饮管理系统
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
dy("nrwz");