using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?W1
{
????public?partial?class?bill?:?Form
????{
????????private?static?string?constr?=?“Data?Source=?.?;Initial?Catalog=RestaurantDateLibrary;Integrated?Security?=True“;
????????public?bill（）
????????{
????????????InitializeComponent（）;
????????}
????????private?void?RefreshDataGridView1（）
????????{
????????????string?CommandText?=?“select?DishID?as?菜品編號??DishName??as?菜品名稱?TableName?as?餐桌名稱?DishPrice?as?菜品單價?DishSum?as?數量?DishAllPrice?as?菜品總價?Remark?as?備注?from?Meals?“;
????????????SqlConnection?conn?=?new?SqlConnection（constr）;
????????????try
????????????{
????????????????conn.Open（）;
????????????????SqlDataAdapter?Adapter?=?new?SqlDataAdapter（CommandText?conn）;
????????????????DataSet?ds?=?new?DataSet（）;
????????????????Adapter.Fill（ds?“Meal“）;
????????????????dataGridView1.DataSource?=?ds;
????????????????dataGridView1.DataMember?=?“Meal“;

????????????????DataTable?dt?=?ds.Tables[“Meal“];
????????????????int?Rows?=?dt.Rows.Count;
????????????????int?Columns?=?dt.Columns.Count;
????????????}
????????????catch?（SqlException?err）
????????????{
????????????????MessageBox.Show（err.ToString（））;
????????????}
????????????finally
????????????{
????????????????conn.Close（）;//關閉數據庫
????????????}
????????}


????????private?void?bill_Load（object?sender?EventArgs?e）
????????{
????????????RefreshDataGridView1（）;

????????????string?CommandText?=?“select?TableID?as?餐桌編號??UserID??as?用戶賬號?TableName?as?餐桌名稱?TableState?as?餐桌狀態?TablePrice?as?餐桌價格?PresetTime?as?預定時間?from?Dintable?“;
????????????SqlConnection?conn?=?new?SqlConnection（constr）;
????????????try
????????????{
????????????????conn.Open（）;
????????????????SqlDataAdapter?Adapter?=?new?SqlDataAdapter（CommandText?conn）;
????????????????DataSet?ds?=?new?DataSet（）;
????????????????Adapter.Fill（ds?“dintable“）;
????????????????dataGridView2.DataSource?=?ds;
????????????????dataGridView2.DataMember?=?“dintable“;

????????????????DataTable?dt?=?ds.Tables[“dintable“];
????????????????int?Rows?=?dt.Rows.Count;
????????????????int?Columns?=?dt.Columns.Count;
????????????}
????????????catch?（SqlException?err）
????????????{
????????????????MessageBox.Show（err.ToString（））;
????????????}
????????????finally
????????????{
????????????????conn.Close（）;//關閉數據庫
????????????}
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????string?CommandText?=?“DELETE?*?FROM?Dintable?where??UserID?=?‘“?+?denglu.userID.Trim（）?+?“‘“;
????????????SqlConnection?conn?=?new?SqlConnection（constr）;
????????????SqlCommand?cmd?=?new?SqlCommand（CommandText?conn）;//對ＳＱＬ數據源執行命令
????????????try
????????????{
????????????????conn.Open（）;//打開數據庫連接
???????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-01-25?17:42??C#代碼\
?????目錄???????????0??2017-01-25?17:41??C#代碼\W1\
?????目錄???????????0??2017-02-14?14:36??C#代碼\W1\W1\
?????文件?????????537??2016-12-22?20:20??C#代碼\W1\W1\App.config
?????文件?????????515??2017-01-14?17:28??C#代碼\W1\W1\Program.cs
?????目錄???????????0??2017-02-13?18:06??C#代碼\W1\W1\Properties\
?????文件????????1346??2016-12-20?17:32??C#代碼\W1\W1\Properties\AssemblyInfo.cs
?????文件????????4346??2017-02-13?18:06??C#代碼\W1\W1\Properties\Resources.Designer.cs
?????文件????????6951??2017-02-13?18:06??C#代碼\W1\W1\Properties\Resources.resx
?????文件????????1747??2016-12-22?20:20??C#代碼\W1\W1\Properties\Settings.Designer.cs
?????文件????????1024??2016-12-22?20:20??C#代碼\W1\W1\Properties\Settings.settings
?????文件????????7403??2016-12-31?13:10??C#代碼\W1\W1\Register.Designer.cs
?????文件????????3542??2016-12-31?13:49??C#代碼\W1\W1\Register.cs
?????文件????????5817??2016-12-31?13:10??C#代碼\W1\W1\Register.resx
?????目錄???????????0??2017-02-13?18:06??C#代碼\W1\W1\Resources\
?????文件???????72369??2017-02-13?18:06??C#代碼\W1\W1\Resources\廚師.jpg
?????文件???????69462??2017-01-25?18:00??C#代碼\W1\W1\Resources\樣例.png
?????文件??????414701??2016-12-20?17:34??C#代碼\W1\W1\Resources\歡飲界面1.png
?????文件???????79949??2017-01-14?17:00??C#代碼\W1\W1\Resources\點餐界面.png
?????文件??????493397??2017-01-01?13:56??C#代碼\W1\W1\RestaurantDateLibraryDataSet.Designer.cs
?????文件???????????3??2017-01-01?13:41??C#代碼\W1\W1\RestaurantDateLibraryDataSet.xsc
?????文件??????106035??2017-01-01?13:41??C#代碼\W1\W1\RestaurantDateLibraryDataSet.xsd
?????文件???????????3??2017-01-01?13:41??C#代碼\W1\W1\RestaurantDateLibraryDataSet.xss
?????文件??????493394??2017-01-01?14:12??C#代碼\W1\W1\RestaurantDateLibraryDataSet1.Designer.cs
?????文件???????????3??2017-01-01?14:12??C#代碼\W1\W1\RestaurantDateLibraryDataSet1.xsc
?????文件??????106031??2017-01-01?14:12??C#代碼\W1\W1\RestaurantDateLibraryDataSet1.xsd
?????文件???????????3??2017-01-01?14:12??C#代碼\W1\W1\RestaurantDateLibraryDataSet1.xss
?????目錄???????????0??2017-02-14?14:41??C#代碼\W1\W1\Service?References\
?????文件???????14680??2017-01-09?22:27??C#代碼\W1\W1\Table.Designer.cs
?????文件????????5868??2017-01-09?22:27??C#代碼\W1\W1\Table.cs
?????文件????????6681??2017-01-09?22:27??C#代碼\W1\W1\Table.resx
............此處省略176個文件信息