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;  }   }

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>");  }}

#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