Tạo report trong phần mềm Quản lý quán cafe với C# Winform
Lập trình phần mềm Quản lý quán cafe với C# Winform
5.0 (4 đánh giá)
Tác giả/Dịch giả:
HowKteam
Học nhanh
HowKteam
Danh sách bài học
Tạo report trong phần mềm Quản lý quán cafe với C# Winform
Không có gì tuyệt vời hơn là luyện tập với ví dụ thực tế. Nào cùng nhau thử thách bản thân với phần mềm: Quản lý quán cafe
Bạn nên có kiến thức về:
- Lập trình Winform cơ bản
- Delegate – Event
- SQL server
- Xử lý ngày tháng năm
Code data.sql
CREATE DATABASE QuanLyQuanCafe
GO
USE QuanLyQuanCafe
GO
-- Food
-- Table
-- FoodCategory
-- Account
-- Bill
-- BillInfo
CREATE TABLE TableFood
(
id INT IDENTITY PRIMARY KEY,
name NVARCHAR(100) NOT NULL DEFAULT N'Bàn chưa có tên',
status NVARCHAR(100) NOT NULL DEFAULT N'Trống' -- Trống || Có người
)
GO
CREATE TABLE Account
(
UserName NVARCHAR(100) PRIMARY KEY,
DisplayName NVARCHAR(100) NOT NULL DEFAULT N'Kter',
PassWord NVARCHAR(1000) NOT NULL DEFAULT 0,
Type INT NOT NULL DEFAULT 0 -- 1: admin && 0: staff
)
GO
CREATE TABLE FoodCategory
(
id INT IDENTITY PRIMARY KEY,
name NVARCHAR(100) NOT NULL DEFAULT N'Chưa đặt tên'
)
GO
CREATE TABLE Food
(
id INT IDENTITY PRIMARY KEY,
name NVARCHAR(100) NOT NULL DEFAULT N'Chưa đặt tên',
idCategory INT NOT NULL,
price FLOAT NOT NULL DEFAULT 0
FOREIGN KEY (idCategory) REFERENCES dbo.FoodCategory(id)
)
GO
CREATE TABLE Bill
(
id INT IDENTITY PRIMARY KEY,
DateCheckIn DATE NOT NULL DEFAULT GETDATE(),
DateCheckOut DATE,
idTable INT NOT NULL,
status INT NOT NULL DEFAULT 0 -- 1: đã thanh toán && 0: chưa thanh toán
FOREIGN KEY (idTable) REFERENCES dbo.TableFood(id)
)
GO
CREATE TABLE BillInfo
(
id INT IDENTITY PRIMARY KEY,
idBill INT NOT NULL,
idFood INT NOT NULL,
count INT NOT NULL DEFAULT 0
FOREIGN KEY (idBill) REFERENCES dbo.Bill(id),
FOREIGN KEY (idFood) REFERENCES dbo.Food(id)
)
GO
INSERT INTO dbo.Account
( UserName ,
DisplayName ,
PassWord ,
Type
)
VALUES ( N'K9' , -- UserName - nvarchar(100)
N'RongK9' , -- DisplayName - nvarchar(100)
N'1' , -- PassWord - nvarchar(1000)
1 -- Type - int
)
INSERT INTO dbo.Account
( UserName ,
DisplayName ,
PassWord ,
Type
)
VALUES ( N'staff' , -- UserName - nvarchar(100)
N'staff' , -- DisplayName - nvarchar(100)
N'1' , -- PassWord - nvarchar(1000)
0 -- Type - int
)
GO
CREATE PROC USP_GetAccountByUserName
@userName nvarchar(100)
AS
BEGIN
SELECT * FROM dbo.Account WHERE UserName = @userName
END
GO
EXEC dbo.USP_GetAccountByUserName @userName = N'k9' -- nvarchar(100)
GO
CREATE PROC USP_Login
@userName nvarchar(100), @passWord nvarchar(100)
AS
BEGIN
SELECT * FROM dbo.Account WHERE UserName = @userName AND PassWord = @passWord
END
GO
-- thêm bàn
DECLARE @i INT = 0
WHILE @i <= 10
BEGIN
INSERT dbo.TableFood ( name)VALUES ( N'Bàn ' + CAST(@i AS nvarchar(100)))
SET @i = @i + 1
END
GO
CREATE PROC USP_GetTableList
AS SELECT * FROM dbo.TableFood
GO
UPDATE dbo.TableFood SET STATUS = N'Có người' WHERE id = 9
EXEC dbo.USP_GetTableList
GO
-- thêm category
INSERT dbo.FoodCategory
( name )
VALUES ( N'Hải sản' -- name - nvarchar(100)
)
INSERT dbo.FoodCategory
( name )
VALUES ( N'Nông sản' )
INSERT dbo.FoodCategory
( name )
VALUES ( N'Lâm sản' )
INSERT dbo.FoodCategory
( name )
VALUES ( N'Sản sản' )
INSERT dbo.FoodCategory
( name )
VALUES ( N'Nước' )
-- thêm món ăn
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Mực một nắng nước sa tế', -- name - nvarchar(100)
1, -- idCategory - int
120000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Nghêu hấp xả', 1, 50000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Dú dê nướng sữa', 2, 60000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Heo rừng nướng muối ớt', 3, 75000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Cơm chiên mushi', 4, 999999)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'7Up', 5, 15000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Cafe', 5, 12000)
-- thêm bill
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
3 , -- idTable - int
0 -- status - int
)
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
4, -- idTable - int
0 -- status - int
)
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
GETDATE() , -- DateCheckOut - date
5 , -- idTable - int
1 -- status - int
)
-- thêm bill info
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 5, -- idBill - int
1, -- idFood - int
2 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 5, -- idBill - int
3, -- idFood - int
4 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 5, -- idBill - int
5, -- idFood - int
1 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 6, -- idBill - int
1, -- idFood - int
2 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 6, -- idBill - int
6, -- idFood - int
2 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 7, -- idBill - int
5, -- idFood - int
2 -- count - int
)
GO
CREATE PROC USP_InsertBill
@idTable INT
AS
BEGIN
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status,
discount
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
@idTable , -- idTable - int
0, -- status - int
0
)
END
GO
CREATE PROC USP_InsertBillInfo
@idBill INT, @idFood INT, @count INT
AS
BEGIN
DECLARE @isExitsBillInfo INT
DECLARE @foodCount INT = 1
SELECT @isExitsBillInfo = id, @foodCount = b.count
FROM dbo.BillInfo AS b
WHERE idBill = @idBill AND idFood = @idFood
IF (@isExitsBillInfo > 0)
BEGIN
DECLARE @newCount INT = @foodCount + @count
IF (@newCount > 0)
UPDATE dbo.BillInfo SET count = @foodCount + @count WHERE idFood = @idFood
ELSE
DELETE dbo.BillInfo WHERE idBill = @idBill AND idFood = @idFood
END
ELSE
BEGIN
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( @idBill, -- idBill - int
@idFood, -- idFood - int
@count -- count - int
)
END
END
GO
DELETE dbo.BillInfo
DELETE dbo.Bill
CREATE TRIGGER UTG_UpdateBillInfo
ON dbo.BillInfo FOR INSERT, UPDATE
AS
BEGIN
DECLARE @idBill INT
SELECT @idBill = idBill FROM Inserted
DECLARE @idTable INT
SELECT @idTable = idTable FROM dbo.Bill WHERE id = @idBill AND status = 0
DECLARE @count INT
SELECT @count = COUNT(*) FROM dbo.BillInfo WHERE idBill = @idBill
IF (@count > 0)
BEGIN
PRINT @idTable
PRINT @idBill
PRINT @count
UPDATE dbo.TableFood SET status = N'Có người' WHERE id = @idTable
END
ELSE
BEGIN
PRINT @idTable
PRINT @idBill
PRINT @count
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable
end
END
GO
CREATE TRIGGER UTG_UpdateBill
ON dbo.Bill FOR UPDATE
AS
BEGIN
DECLARE @idBill INT
SELECT @idBill = id FROM Inserted
DECLARE @idTable INT
SELECT @idTable = idTable FROM dbo.Bill WHERE id = @idBill
DECLARE @count int = 0
SELECT @count = COUNT(*) FROM dbo.Bill WHERE idTable = @idTable AND status = 0
IF (@count = 0)
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable
END
GO
ALTER TABLE dbo.Bill
ADD discount INT
UPDATE dbo.Bill SET discount = 0
GO
CREATE PROC USP_SwitchTabel
@idTable1 INT, @idTable2 int
AS BEGIN
DECLARE @idFirstBill int
DECLARE @idSeconrdBill INT
DECLARE @isFirstTablEmty INT = 1
DECLARE @isSecondTablEmty INT = 1
SELECT @idSeconrdBill = id FROM dbo.Bill WHERE idTable = @idTable2 AND status = 0
SELECT @idFirstBill = id FROM dbo.Bill WHERE idTable = @idTable1 AND status = 0
PRINT @idFirstBill
PRINT @idSeconrdBill
PRINT '-----------'
IF (@idFirstBill IS NULL)
BEGIN
PRINT '0000001'
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
@idTable1 , -- idTable - int
0 -- status - int
)
SELECT @idFirstBill = MAX(id) FROM dbo.Bill WHERE idTable = @idTable1 AND status = 0
END
SELECT @isFirstTablEmty = COUNT(*) FROM dbo.BillInfo WHERE idBill = @idFirstBill
PRINT @idFirstBill
PRINT @idSeconrdBill
PRINT '-----------'
IF (@idSeconrdBill IS NULL)
BEGIN
PRINT '0000002'
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
@idTable2 , -- idTable - int
0 -- status - int
)
SELECT @idSeconrdBill = MAX(id) FROM dbo.Bill WHERE idTable = @idTable2 AND status = 0
END
SELECT @isSecondTablEmty = COUNT(*) FROM dbo.BillInfo WHERE idBill = @idSeconrdBill
PRINT @idFirstBill
PRINT @idSeconrdBill
PRINT '-----------'
SELECT id INTO IDBillInfoTable FROM dbo.BillInfo WHERE idBill = @idSeconrdBill
UPDATE dbo.BillInfo SET idBill = @idSeconrdBill WHERE idBill = @idFirstBill
UPDATE dbo.BillInfo SET idBill = @idFirstBill WHERE id IN (SELECT * FROM IDBillInfoTable)
DROP TABLE IDBillInfoTable
IF (@isFirstTablEmty = 0)
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable2
IF (@isSecondTablEmty= 0)
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable1
END
GO
ALTER TABLE dbo.Bill ADD totalPrice FLOAT
DELETE dbo.BillInfo
DELETE dbo.Bill
GO
CREATE PROC USP_GetListBillByDate
@checkIn date, @checkOut date
AS
BEGIN
SELECT t.name AS [Tên bàn], b.totalPrice AS [Tổng tiền], DateCheckIn AS [Ngày vào], DateCheckOut AS [Ngày ra], discount AS [Giảm giá]
FROM dbo.Bill AS b,dbo.TableFood AS t
WHERE DateCheckIn >= @checkIn AND DateCheckOut <= @checkOut AND b.status = 1
AND t.id = b.idTable
END
GO
CREATE PROC USP_UpdateAccount
@userName NVARCHAR(100), @displayName NVARCHAR(100), @password NVARCHAR(100), @newPassword NVARCHAR(100)
AS
BEGIN
DECLARE @isRightPass INT = 0
SELECT @isRightPass = COUNT(*) FROM dbo.Account WHERE USERName = @userName AND PassWord = @password
IF (@isRightPass = 1)
BEGIN
IF (@newPassword = NULL OR @newPassword = '')
BEGIN
UPDATE dbo.Account SET DisplayName = @displayName WHERE UserName = @userName
END
ELSE
UPDATE dbo.Account SET DisplayName = @displayName, PassWord = @newPassword WHERE UserName = @userName
end
END
GO
CREATE TRIGGER UTG_DeleteBillInfo
ON dbo.BillInfo FOR DELETE
AS
BEGIN
DECLARE @idBillInfo INT
DECLARE @idBill INT
SELECT @idBillInfo = id, @idBill = Deleted.idBill FROM Deleted
DECLARE @idTable INT
SELECT @idTable = idTable FROM dbo.Bill WHERE id = @idBill
DECLARE @count INT = 0
SELECT @count = COUNT(*) FROM dbo.BillInfo AS bi, dbo.Bill AS b WHERE b.id = bi.idBill AND b.id = @idBill AND b.status = 0
IF (@count = 0)
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable
END
GO
CREATE FUNCTION [dbo].[fuConvertToUnsign1] ( @strInput NVARCHAR(4000) ) RETURNS NVARCHAR(4000) AS BEGIN IF @strInput IS NULL RETURN @strInput IF @strInput = '' RETURN @strInput DECLARE @RT NVARCHAR(4000) DECLARE @SIGN_CHARS NCHAR(136) DECLARE @UNSIGN_CHARS NCHAR (136) SET @SIGN_CHARS = N'ăâđêôơưàảãạáằẳẵặắầẩẫậấèẻẽẹéềểễệế ìỉĩịíòỏõọóồổỗộốờởỡợớùủũụúừửữựứỳỷỹỵý ĂÂĐÊÔƠƯÀẢÃẠÁẰẲẴẶẮẦẨẪẬẤÈẺẼẸÉỀỂỄỆẾÌỈĨỊÍ ÒỎÕỌÓỒỔỖỘỐỜỞỠỢỚÙỦŨỤÚỪỬỮỰỨỲỶỸỴÝ' +NCHAR(272)+ NCHAR(208) SET @UNSIGN_CHARS = N'aadeoouaaaaaaaaaaaaaaaeeeeeeeeee iiiiiooooooooooooooouuuuuuuuuuyyyyy AADEOOUAAAAAAAAAAAAAAAEEEEEEEEEEIIIII OOOOOOOOOOOOOOOUUUUUUUUUUYYYYYDD' DECLARE @COUNTER int DECLARE @COUNTER1 int SET @COUNTER = 1 WHILE (@COUNTER <=LEN(@strInput)) BEGIN SET @COUNTER1 = 1 WHILE (@COUNTER1 <=LEN(@SIGN_CHARS)+1) BEGIN IF UNICODE(SUBSTRING(@SIGN_CHARS, @COUNTER1,1)) = UNICODE(SUBSTRING(@strInput,@COUNTER ,1) ) BEGIN IF @COUNTER=1 SET @strInput = SUBSTRING(@UNSIGN_CHARS, @COUNTER1,1) + SUBSTRING(@strInput, @COUNTER+1,LEN(@strInput)-1) ELSE SET @strInput = SUBSTRING(@strInput, 1, @COUNTER-1) +SUBSTRING(@UNSIGN_CHARS, @COUNTER1,1) + SUBSTRING(@strInput, @COUNTER+1,LEN(@strInput)- @COUNTER) BREAK END SET @COUNTER1 = @COUNTER1 +1 END SET @COUNTER = @COUNTER +1 END SET @strInput = replace(@strInput,' ','-') RETURN @strInput END
GO
CREATE PROC USP_GetListBillByDateAndPage
@checkIn date, @checkOut date, @page int
AS
BEGIN
DECLARE @pageRows INT = 10
DECLARE @selectRows INT = @pageRows
DECLARE @exceptRows INT = (@page - 1) * @pageRows
;WITH BillShow AS( SELECT b.ID, t.name AS [Tên bàn], b.totalPrice AS [Tổng tiền], DateCheckIn AS [Ngày vào], DateCheckOut AS [Ngày ra], discount AS [Giảm giá]
FROM dbo.Bill AS b,dbo.TableFood AS t
WHERE DateCheckIn >= @checkIn AND DateCheckOut <= @checkOut AND b.status = 1
AND t.id = b.idTable)
SELECT TOP (@selectRows) * FROM BillShow WHERE id NOT IN (SELECT TOP (@exceptRows) id FROM BillShow)
END
GO
CREATE PROC USP_GetNumBillByDate
@checkIn date, @checkOut date
AS
BEGIN
SELECT COUNT(*)
FROM dbo.Bill AS b,dbo.TableFood AS t
WHERE DateCheckIn >= @checkIn AND DateCheckOut <= @checkOut AND b.status = 1
AND t.id = b.idTable
END
GO
CREATE PROC USP_GetListBillByDateForReport
@checkIn date, @checkOut date
AS
BEGIN
SELECT t.name, b.totalPrice, DateCheckIn, DateCheckOut, discount
FROM dbo.Bill AS b,dbo.TableFood AS t
WHERE DateCheckIn >= @checkIn AND DateCheckOut <= @checkOut AND b.status = 1
AND t.id = b.idTable
END
GO
Code fAdmin.cs
using QuanLyQuanCafe.DAO;
using QuanLyQuanCafe.DTO;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace QuanLyQuanCafe
{
public partial class fAdmin : Form
{
BindingSource foodList = new BindingSource();
BindingSource accountList = new BindingSource();
public Account loginAccount;
public fAdmin()
{
InitializeComponent();
LoadData();
}
#region methods
List<Food> SearchFoodByName(string name)
{
List<Food> listFood = FoodDAO.Instance.SearchFoodByName(name);
return listFood;
}
void LoadData()
{
dtgvFood.DataSource = foodList;
dtgvAccount.DataSource = accountList;
LoadDateTimePickerBill();
LoadListBillByDate(dtpkFromDate.Value, dtpkToDate.Value);
LoadListFood();
LoadAccount();
LoadCategoryIntoCombobox(cbFoodCategory);
AddFoodBinding();
AddAccountBinding();
}
void AddAccountBinding()
{
txbUserName.DataBindings.Add(new Binding("Text", dtgvAccount.DataSource, "UserName", true, DataSourceUpdateMode.Never));
txbDisplayName.DataBindings.Add(new Binding("Text", dtgvAccount.DataSource, "DisplayName", true, DataSourceUpdateMode.Never));
numericUpDown1.DataBindings.Add(new Binding("Value", dtgvAccount.DataSource, "Type", true, DataSourceUpdateMode.Never));
}
void LoadAccount()
{
accountList.DataSource = AccountDAO.Instance.GetListAccount();
}
void LoadDateTimePickerBill()
{
DateTime today = DateTime.Now;
dtpkFromDate.Value = new DateTime(today.Year, today.Month, 1);
dtpkToDate.Value = dtpkFromDate.Value.AddMonths(1).AddDays(-1);
}
void LoadListBillByDate(DateTime checkIn, DateTime checkOut)
{
dtgvBill.DataSource = BillDAO.Instance.GetBillListByDate(checkIn, checkOut);
}
void AddFoodBinding()
{
txbFoodName.DataBindings.Add(new Binding("Text", dtgvFood.DataSource, "Name", true, DataSourceUpdateMode.Never));
txbFoodID.DataBindings.Add(new Binding("Text", dtgvFood.DataSource, "ID", true, DataSourceUpdateMode.Never));
nmFoodPrice.DataBindings.Add(new Binding("Value", dtgvFood.DataSource, "Price", true, DataSourceUpdateMode.Never));
}
void LoadCategoryIntoCombobox(ComboBox cb)
{
cb.DataSource = CategoryDAO.Instance.GetListCategory();
cb.DisplayMember = "Name";
}
void LoadListFood()
{
foodList.DataSource = FoodDAO.Instance.GetListFood();
}
void AddAccount(string userName, string displayName, int type)
{
if (AccountDAO.Instance.InsertAccount(userName, displayName, type))
{
MessageBox.Show("Thêm tài khoản thành công");
}
else
{
MessageBox.Show("Thêm tài khoản thất bại");
}
LoadAccount();
}
void EditAccount(string userName, string displayName, int type)
{
if (AccountDAO.Instance.UpdateAccount(userName, displayName, type))
{
MessageBox.Show("Cập nhật tài khoản thành công");
}
else
{
MessageBox.Show("Cập nhật tài khoản thất bại");
}
LoadAccount();
}
void DeleteAccount(string userName)
{
if (loginAccount.UserName.Equals(userName))
{
MessageBox.Show("Vui lòng đừng xóa chính bạn chứ");
return;
}
if (AccountDAO.Instance.DeleteAccount(userName))
{
MessageBox.Show("Xóa tài khoản thành công");
}
else
{
MessageBox.Show("Xóa tài khoản thất bại");
}
LoadAccount();
}
void ResetPass(string userName)
{
if (AccountDAO.Instance.ResetPassword(userName))
{
MessageBox.Show("Đặt lại mật khẩu thành công");
}
else
{
MessageBox.Show("Đặt lại mật khẩu thất bại");
}
}
#endregion
#region events
private void btnAddAccount_Click(object sender, EventArgs e)
{
string userName = txbUserName.Text;
string displayName = txbDisplayName.Text;
int type = (int)numericUpDown1.Value;
AddAccount(userName, displayName, type);
}
private void btnDeleteAccount_Click(object sender, EventArgs e)
{
string userName = txbUserName.Text;
DeleteAccount(userName);
}
private void btnEditAccount_Click(object sender, EventArgs e)
{
string userName = txbUserName.Text;
string displayName = txbDisplayName.Text;
int type = (int)numericUpDown1.Value;
EditAccount(userName, displayName, type);
}
private void btnResetPassword_Click(object sender, EventArgs e)
{
string userName = txbUserName.Text;
ResetPass(userName);
}
private void btnShowAccount_Click(object sender, EventArgs e)
{
LoadAccount();
}
private void btnSearchFood_Click(object sender, EventArgs e)
{
foodList.DataSource = SearchFoodByName(txbSearchFoodName.Text);
}
private void txbFoodID_TextChanged(object sender, EventArgs e)
{
try
{
if (dtgvFood.SelectedCells.Count > 0)
{
int id = (int)dtgvFood.SelectedCells[0].OwningRow.Cells["CategoryID"].Value;
Category cateogory = CategoryDAO.Instance.GetCategoryByID(id);
cbFoodCategory.SelectedItem = cateogory;
int index = -1;
int i = 0;
foreach (Category item in cbFoodCategory.Items)
{
if (item.ID == cateogory.ID)
{
index = i;
break;
}
i++;
}
cbFoodCategory.SelectedIndex = index;
}
}
catch { }
}
private void btnAddFood_Click(object sender, EventArgs e)
{
string name = txbFoodName.Text;
int categoryID = (cbFoodCategory.SelectedItem as Category).ID;
float price = (float)nmFoodPrice.Value;
if (FoodDAO.Instance.InsertFood(name, categoryID, price))
{
MessageBox.Show("Thêm món thành công");
LoadListFood();
if (insertFood != null)
insertFood(this, new EventArgs());
}
else
{
MessageBox.Show("Có lỗi khi thêm thức ăn");
}
}
private void btnEditFood_Click(object sender, EventArgs e)
{
string name = txbFoodName.Text;
int categoryID = (cbFoodCategory.SelectedItem as Category).ID;
float price = (float)nmFoodPrice.Value;
int id = Convert.ToInt32(txbFoodID.Text);
if (FoodDAO.Instance.UpdateFood(id, name, categoryID, price))
{
MessageBox.Show("Sửa món thành công");
LoadListFood();
if (updateFood != null)
updateFood(this, new EventArgs());
}
else
{
MessageBox.Show("Có lỗi khi sửa thức ăn");
}
}
private void btnDeleteFood_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txbFoodID.Text);
if (FoodDAO.Instance.DeleteFood(id))
{
MessageBox.Show("Xóa món thành công");
LoadListFood();
if (deleteFood != null)
deleteFood(this, new EventArgs());
}
else
{
MessageBox.Show("Có lỗi khi xóa thức ăn");
}
}
private void btnShowFood_Click(object sender, EventArgs e)
{
LoadListFood();
}
private void btnViewBill_Click(object sender, EventArgs e)
{
LoadListBillByDate(dtpkFromDate.Value, dtpkToDate.Value);
}
private event EventHandler insertFood;
public event EventHandler InsertFood
{
add { insertFood += value; }
remove { insertFood -= value; }
}
private event EventHandler deleteFood;
public event EventHandler DeleteFood
{
add { deleteFood += value; }
remove { deleteFood -= value; }
}
private event EventHandler updateFood;
public event EventHandler UpdateFood
{
add { updateFood += value; }
remove { updateFood -= value; }
}
#endregion
private void btnFristBillPage_Click(object sender, EventArgs e)
{
txbPageBill.Text = "1";
}
private void btnLastBillPage_Click(object sender, EventArgs e)
{
int sumRecord = BillDAO.Instance.GetNumBillListByDate(dtpkFromDate.Value, dtpkToDate.Value);
int lastPage = sumRecord / 10;
if (sumRecord % 10 != 0)
lastPage++;
txbPageBill.Text = lastPage.ToString();
}
private void txbPageBill_TextChanged(object sender, EventArgs e)
{
dtgvBill.DataSource = BillDAO.Instance.GetBillListByDateAndPage(dtpkFromDate.Value, dtpkToDate.Value, Convert.ToInt32(txbPageBill.Text));
}
private void btnPrevioursBillPage_Click(object sender, EventArgs e)
{
int page = Convert.ToInt32(txbPageBill.Text);
if (page > 1)
page--;
txbPageBill.Text = page.ToString();
}
private void btnNextBillPage_Click(object sender, EventArgs e)
{
int page = Convert.ToInt32(txbPageBill.Text);
int sumRecord = BillDAO.Instance.GetNumBillListByDate(dtpkFromDate.Value, dtpkToDate.Value);
if (page < sumRecord)
page++;
txbPageBill.Text = page.ToString();
}
private void fAdmin_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'QuanLyQuanCafeDataSet2.USP_GetListBillByDateForReport' table. You can move, or remove it, as needed.
this.USP_GetListBillByDateForReportTableAdapter.Fill(this.QuanLyQuanCafeDataSet2.USP_GetListBillByDateForReport, dtpkFromDate.Value, dtpkToDate.Value);
this.rpViewer.RefreshReport();
}
}
}
Code fAdmin.Designer.cs
namespace QuanLyQuanCafe
{
partial class fAdmin
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
this.tpAccount = new System.Windows.Forms.TabPage();
this.panel23 = new System.Windows.Forms.Panel();
this.btnResetPassword = new System.Windows.Forms.Button();
this.panel25 = new System.Windows.Forms.Panel();
this.numericUpDown1 = new System.Windows.Forms.NumericUpDown();
this.label11 = new System.Windows.Forms.Label();
this.panel26 = new System.Windows.Forms.Panel();
this.txbDisplayName = new System.Windows.Forms.TextBox();
this.label12 = new System.Windows.Forms.Label();
this.panel27 = new System.Windows.Forms.Panel();
this.txbUserName = new System.Windows.Forms.TextBox();
this.label13 = new System.Windows.Forms.Label();
this.panel28 = new System.Windows.Forms.Panel();
this.btnShowAccount = new System.Windows.Forms.Button();
this.btnEditAccount = new System.Windows.Forms.Button();
this.btnDeleteAccount = new System.Windows.Forms.Button();
this.btnAddAccount = new System.Windows.Forms.Button();
this.panel29 = new System.Windows.Forms.Panel();
this.dtgvAccount = new System.Windows.Forms.DataGridView();
this.tpTable = new System.Windows.Forms.TabPage();
this.panel11 = new System.Windows.Forms.Panel();
this.panel21 = new System.Windows.Forms.Panel();
this.cbTableStatus = new System.Windows.Forms.ComboBox();
this.label9 = new System.Windows.Forms.Label();
this.panel13 = new System.Windows.Forms.Panel();
this.txbTableName = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.panel14 = new System.Windows.Forms.Panel();
this.textBox3 = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.panel19 = new System.Windows.Forms.Panel();
this.btnShowTable = new System.Windows.Forms.Button();
this.btnEditTable = new System.Windows.Forms.Button();
this.btnDeleteTable = new System.Windows.Forms.Button();
this.btnAddTable = new System.Windows.Forms.Button();
this.panel20 = new System.Windows.Forms.Panel();
this.dtgvTable = new System.Windows.Forms.DataGridView();
this.tbFoodCategory = new System.Windows.Forms.TabPage();
this.panel12 = new System.Windows.Forms.Panel();
this.panel15 = new System.Windows.Forms.Panel();
this.textBox2 = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.panel16 = new System.Windows.Forms.Panel();
this.txbCategoryID = new System.Windows.Forms.TextBox();
this.label8 = new System.Windows.Forms.Label();
this.panel17 = new System.Windows.Forms.Panel();
this.btnShowCategory = new System.Windows.Forms.Button();
this.btnEditCategory = new System.Windows.Forms.Button();
this.btnDeleteCategory = new System.Windows.Forms.Button();
this.btnAddCategory = new System.Windows.Forms.Button();
this.panel18 = new System.Windows.Forms.Panel();
this.dtgvCategory = new System.Windows.Forms.DataGridView();
this.tpFood = new System.Windows.Forms.TabPage();
this.panel6 = new System.Windows.Forms.Panel();
this.txbSearchFoodName = new System.Windows.Forms.TextBox();
this.btnSearchFood = new System.Windows.Forms.Button();
this.panel5 = new System.Windows.Forms.Panel();
this.panel10 = new System.Windows.Forms.Panel();
this.nmFoodPrice = new System.Windows.Forms.NumericUpDown();
this.label4 = new System.Windows.Forms.Label();
this.panel9 = new System.Windows.Forms.Panel();
this.cbFoodCategory = new System.Windows.Forms.ComboBox();
this.label3 = new System.Windows.Forms.Label();
this.panel8 = new System.Windows.Forms.Panel();
this.txbFoodName = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.panel7 = new System.Windows.Forms.Panel();
this.txbFoodID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.panel4 = new System.Windows.Forms.Panel();
this.btnShowFood = new System.Windows.Forms.Button();
this.btnEditFood = new System.Windows.Forms.Button();
this.btnDeleteFood = new System.Windows.Forms.Button();
this.btnAddFood = new System.Windows.Forms.Button();
this.panel3 = new System.Windows.Forms.Panel();
this.dtgvFood = new System.Windows.Forms.DataGridView();
this.tpBill = new System.Windows.Forms.TabPage();
this.panel2 = new System.Windows.Forms.Panel();
this.btnViewBill = new System.Windows.Forms.Button();
this.dtpkToDate = new System.Windows.Forms.DateTimePicker();
this.dtpkFromDate = new System.Windows.Forms.DateTimePicker();
this.panel1 = new System.Windows.Forms.Panel();
this.txbPageBill = new System.Windows.Forms.TextBox();
this.btnNextBillPage = new System.Windows.Forms.Button();
this.btnPrevioursBillPage = new System.Windows.Forms.Button();
this.btnLastBillPage = new System.Windows.Forms.Button();
this.btnFristBillPage = new System.Windows.Forms.Button();
this.dtgvBill = new System.Windows.Forms.DataGridView();
this.tcAdmin = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.rpViewer = new Microsoft.Reporting.WinForms.ReportViewer();
this.QuanLyQuanCafeDataSet2 = new QuanLyQuanCafe.QuanLyQuanCafeDataSet2();
this.USP_GetListBillByDateForReportBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.USP_GetListBillByDateForReportTableAdapter = new QuanLyQuanCafe.QuanLyQuanCafeDataSet2TableAdapters.USP_GetListBillByDateForReportTableAdapter();
this.tpAccount.SuspendLayout();
this.panel23.SuspendLayout();
this.panel25.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.numericUpDown1)).BeginInit();
this.panel26.SuspendLayout();
this.panel27.SuspendLayout();
this.panel28.SuspendLayout();
this.panel29.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvAccount)).BeginInit();
this.tpTable.SuspendLayout();
this.panel11.SuspendLayout();
this.panel21.SuspendLayout();
this.panel13.SuspendLayout();
this.panel14.SuspendLayout();
this.panel19.SuspendLayout();
this.panel20.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvTable)).BeginInit();
this.tbFoodCategory.SuspendLayout();
this.panel12.SuspendLayout();
this.panel15.SuspendLayout();
this.panel16.SuspendLayout();
this.panel17.SuspendLayout();
this.panel18.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvCategory)).BeginInit();
this.tpFood.SuspendLayout();
this.panel6.SuspendLayout();
this.panel5.SuspendLayout();
this.panel10.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.nmFoodPrice)).BeginInit();
this.panel9.SuspendLayout();
this.panel8.SuspendLayout();
this.panel7.SuspendLayout();
this.panel4.SuspendLayout();
this.panel3.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvFood)).BeginInit();
this.tpBill.SuspendLayout();
this.panel2.SuspendLayout();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvBill)).BeginInit();
this.tcAdmin.SuspendLayout();
this.tabPage1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.QuanLyQuanCafeDataSet2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.USP_GetListBillByDateForReportBindingSource)).BeginInit();
this.SuspendLayout();
//
// tpAccount
//
this.tpAccount.Controls.Add(this.panel23);
this.tpAccount.Controls.Add(this.panel28);
this.tpAccount.Controls.Add(this.panel29);
this.tpAccount.Location = new System.Drawing.Point(4, 22);
this.tpAccount.Name = "tpAccount";
this.tpAccount.Padding = new System.Windows.Forms.Padding(3);
this.tpAccount.Size = new System.Drawing.Size(650, 413);
this.tpAccount.TabIndex = 4;
this.tpAccount.Text = "Tài khoản";
this.tpAccount.UseVisualStyleBackColor = true;
//
// panel23
//
this.panel23.Controls.Add(this.btnResetPassword);
this.panel23.Controls.Add(this.panel25);
this.panel23.Controls.Add(this.panel26);
this.panel23.Controls.Add(this.panel27);
this.panel23.Location = new System.Drawing.Point(360, 62);
this.panel23.Name = "panel23";
this.panel23.Size = new System.Drawing.Size(285, 346);
this.panel23.TabIndex = 6;
//
// btnResetPassword
//
this.btnResetPassword.Location = new System.Drawing.Point(204, 153);
this.btnResetPassword.Name = "btnResetPassword";
this.btnResetPassword.Size = new System.Drawing.Size(75, 46);
this.btnResetPassword.TabIndex = 4;
this.btnResetPassword.Text = "Đặt lại mật khẩu";
this.btnResetPassword.UseVisualStyleBackColor = true;
this.btnResetPassword.Click += new System.EventHandler(this.btnResetPassword_Click);
//
// panel25
//
this.panel25.Controls.Add(this.numericUpDown1);
this.panel25.Controls.Add(this.label11);
this.panel25.Location = new System.Drawing.Point(3, 103);
this.panel25.Name = "panel25";
this.panel25.Size = new System.Drawing.Size(279, 44);
this.panel25.TabIndex = 3;
//
// numericUpDown1
//
this.numericUpDown1.Location = new System.Drawing.Point(127, 8);
this.numericUpDown1.Maximum = new decimal(new int[] {
1,
0,
0,
0});
this.numericUpDown1.Name = "numericUpDown1";
this.numericUpDown1.Size = new System.Drawing.Size(33, 20);
this.numericUpDown1.TabIndex = 1;
//
// label11
//
this.label11.AutoSize = true;
this.label11.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label11.Location = new System.Drawing.Point(3, 9);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(116, 19);
this.label11.TabIndex = 0;
this.label11.Text = "Loại tài khoản";
//
// panel26
//
this.panel26.Controls.Add(this.txbDisplayName);
this.panel26.Controls.Add(this.label12);
this.panel26.Location = new System.Drawing.Point(3, 53);
this.panel26.Name = "panel26";
this.panel26.Size = new System.Drawing.Size(279, 44);
this.panel26.TabIndex = 2;
//
// txbDisplayName
//
this.txbDisplayName.Location = new System.Drawing.Point(127, 8);
this.txbDisplayName.Name = "txbDisplayName";
this.txbDisplayName.Size = new System.Drawing.Size(149, 20);
this.txbDisplayName.TabIndex = 1;
//
// label12
//
this.label12.AutoSize = true;
this.label12.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label12.Location = new System.Drawing.Point(3, 9);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(104, 19);
this.label12.TabIndex = 0;
this.label12.Text = "Tên hiển thị:";
//
// panel27
//
this.panel27.Controls.Add(this.txbUserName);
this.panel27.Controls.Add(this.label13);
this.panel27.Location = new System.Drawing.Point(3, 3);
this.panel27.Name = "panel27";
this.panel27.Size = new System.Drawing.Size(279, 44);
this.panel27.TabIndex = 1;
//
// txbUserName
//
this.txbUserName.Location = new System.Drawing.Point(127, 8);
this.txbUserName.Name = "txbUserName";
this.txbUserName.Size = new System.Drawing.Size(149, 20);
this.txbUserName.TabIndex = 1;
//
// label13
//
this.label13.AutoSize = true;
this.label13.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label13.Location = new System.Drawing.Point(3, 9);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(118, 19);
this.label13.TabIndex = 0;
this.label13.Text = "Tên tài khoản:";
//
// panel28
//
this.panel28.Controls.Add(this.btnShowAccount);
this.panel28.Controls.Add(this.btnEditAccount);
this.panel28.Controls.Add(this.btnDeleteAccount);
this.panel28.Controls.Add(this.btnAddAccount);
this.panel28.Location = new System.Drawing.Point(5, 4);
this.panel28.Name = "panel28";
this.panel28.Size = new System.Drawing.Size(349, 52);
this.panel28.TabIndex = 5;
//
// btnShowAccount
//
this.btnShowAccount.Location = new System.Drawing.Point(246, 3);
this.btnShowAccount.Name = "btnShowAccount";
this.btnShowAccount.Size = new System.Drawing.Size(75, 46);
this.btnShowAccount.TabIndex = 3;
this.btnShowAccount.Text = "Xem";
this.btnShowAccount.UseVisualStyleBackColor = true;
this.btnShowAccount.Click += new System.EventHandler(this.btnShowAccount_Click);
//
// btnEditAccount
//
this.btnEditAccount.Location = new System.Drawing.Point(165, 3);
this.btnEditAccount.Name = "btnEditAccount";
this.btnEditAccount.Size = new System.Drawing.Size(75, 46);
this.btnEditAccount.TabIndex = 2;
this.btnEditAccount.Text = "Sửa";
this.btnEditAccount.UseVisualStyleBackColor = true;
this.btnEditAccount.Click += new System.EventHandler(this.btnEditAccount_Click);
//
// btnDeleteAccount
//
this.btnDeleteAccount.Location = new System.Drawing.Point(84, 3);
this.btnDeleteAccount.Name = "btnDeleteAccount";
this.btnDeleteAccount.Size = new System.Drawing.Size(75, 46);
this.btnDeleteAccount.TabIndex = 1;
this.btnDeleteAccount.Text = "Xóa";
this.btnDeleteAccount.UseVisualStyleBackColor = true;
this.btnDeleteAccount.Click += new System.EventHandler(this.btnDeleteAccount_Click);
//
// btnAddAccount
//
this.btnAddAccount.Location = new System.Drawing.Point(3, 3);
this.btnAddAccount.Name = "btnAddAccount";
this.btnAddAccount.Size = new System.Drawing.Size(75, 46);
this.btnAddAccount.TabIndex = 0;
this.btnAddAccount.Text = "Thêm";
this.btnAddAccount.UseVisualStyleBackColor = true;
this.btnAddAccount.Click += new System.EventHandler(this.btnAddAccount_Click);
//
// panel29
//
this.panel29.Controls.Add(this.dtgvAccount);
this.panel29.Location = new System.Drawing.Point(5, 62);
this.panel29.Name = "panel29";
this.panel29.Size = new System.Drawing.Size(349, 346);
this.panel29.TabIndex = 4;
//
// dtgvAccount
//
this.dtgvAccount.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvAccount.Location = new System.Drawing.Point(3, 3);
this.dtgvAccount.Name = "dtgvAccount";
this.dtgvAccount.Size = new System.Drawing.Size(343, 340);
this.dtgvAccount.TabIndex = 0;
//
// tpTable
//
this.tpTable.Controls.Add(this.panel11);
this.tpTable.Controls.Add(this.panel19);
this.tpTable.Controls.Add(this.panel20);
this.tpTable.Location = new System.Drawing.Point(4, 22);
this.tpTable.Name = "tpTable";
this.tpTable.Padding = new System.Windows.Forms.Padding(3);
this.tpTable.Size = new System.Drawing.Size(650, 413);
this.tpTable.TabIndex = 3;
this.tpTable.Text = "Bàn ăn";
this.tpTable.UseVisualStyleBackColor = true;
//
// panel11
//
this.panel11.Controls.Add(this.panel21);
this.panel11.Controls.Add(this.panel13);
this.panel11.Controls.Add(this.panel14);
this.panel11.Location = new System.Drawing.Point(360, 62);
this.panel11.Name = "panel11";
this.panel11.Size = new System.Drawing.Size(285, 346);
this.panel11.TabIndex = 9;
//
// panel21
//
this.panel21.Controls.Add(this.cbTableStatus);
this.panel21.Controls.Add(this.label9);
this.panel21.Location = new System.Drawing.Point(3, 103);
this.panel21.Name = "panel21";
this.panel21.Size = new System.Drawing.Size(279, 44);
this.panel21.TabIndex = 3;
//
// cbTableStatus
//
this.cbTableStatus.FormattingEnabled = true;
this.cbTableStatus.Location = new System.Drawing.Point(125, 9);
this.cbTableStatus.Name = "cbTableStatus";
this.cbTableStatus.Size = new System.Drawing.Size(151, 21);
this.cbTableStatus.TabIndex = 1;
//
// label9
//
this.label9.AutoSize = true;
this.label9.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label9.Location = new System.Drawing.Point(3, 9);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(91, 19);
this.label9.TabIndex = 0;
this.label9.Text = "Trạng thái:";
//
// panel13
//
this.panel13.Controls.Add(this.txbTableName);
this.panel13.Controls.Add(this.label5);
this.panel13.Location = new System.Drawing.Point(3, 53);
this.panel13.Name = "panel13";
this.panel13.Size = new System.Drawing.Size(279, 44);
this.panel13.TabIndex = 2;
//
// txbTableName
//
this.txbTableName.Location = new System.Drawing.Point(125, 8);
this.txbTableName.Name = "txbTableName";
this.txbTableName.Size = new System.Drawing.Size(151, 20);
this.txbTableName.TabIndex = 1;
//
// label5
//
this.label5.AutoSize = true;
this.label5.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label5.Location = new System.Drawing.Point(3, 9);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(77, 19);
this.label5.TabIndex = 0;
this.label5.Text = "Tên bàn:";
//
// panel14
//
this.panel14.Controls.Add(this.textBox3);
this.panel14.Controls.Add(this.label6);
this.panel14.Location = new System.Drawing.Point(3, 3);
this.panel14.Name = "panel14";
this.panel14.Size = new System.Drawing.Size(279, 44);
this.panel14.TabIndex = 1;
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(125, 8);
this.textBox3.Name = "textBox3";
this.textBox3.ReadOnly = true;
this.textBox3.Size = new System.Drawing.Size(151, 20);
this.textBox3.TabIndex = 1;
//
// label6
//
this.label6.AutoSize = true;
this.label6.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label6.Location = new System.Drawing.Point(3, 9);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(31, 19);
this.label6.TabIndex = 0;
this.label6.Text = "ID:";
//
// panel19
//
this.panel19.Controls.Add(this.btnShowTable);
this.panel19.Controls.Add(this.btnEditTable);
this.panel19.Controls.Add(this.btnDeleteTable);
this.panel19.Controls.Add(this.btnAddTable);
this.panel19.Location = new System.Drawing.Point(5, 4);
this.panel19.Name = "panel19";
this.panel19.Size = new System.Drawing.Size(349, 52);
this.panel19.TabIndex = 8;
//
// btnShowTable
//
this.btnShowTable.Location = new System.Drawing.Point(246, 3);
this.btnShowTable.Name = "btnShowTable";
this.btnShowTable.Size = new System.Drawing.Size(75, 46);
this.btnShowTable.TabIndex = 3;
this.btnShowTable.Text = "Xem";
this.btnShowTable.UseVisualStyleBackColor = true;
//
// btnEditTable
//
this.btnEditTable.Location = new System.Drawing.Point(165, 3);
this.btnEditTable.Name = "btnEditTable";
this.btnEditTable.Size = new System.Drawing.Size(75, 46);
this.btnEditTable.TabIndex = 2;
this.btnEditTable.Text = "Sửa";
this.btnEditTable.UseVisualStyleBackColor = true;
//
// btnDeleteTable
//
this.btnDeleteTable.Location = new System.Drawing.Point(84, 3);
this.btnDeleteTable.Name = "btnDeleteTable";
this.btnDeleteTable.Size = new System.Drawing.Size(75, 46);
this.btnDeleteTable.TabIndex = 1;
this.btnDeleteTable.Text = "Xóa";
this.btnDeleteTable.UseVisualStyleBackColor = true;
//
// btnAddTable
//
this.btnAddTable.Location = new System.Drawing.Point(3, 3);
this.btnAddTable.Name = "btnAddTable";
this.btnAddTable.Size = new System.Drawing.Size(75, 46);
this.btnAddTable.TabIndex = 0;
this.btnAddTable.Text = "Thêm";
this.btnAddTable.UseVisualStyleBackColor = true;
//
// panel20
//
this.panel20.Controls.Add(this.dtgvTable);
this.panel20.Location = new System.Drawing.Point(5, 62);
this.panel20.Name = "panel20";
this.panel20.Size = new System.Drawing.Size(349, 346);
this.panel20.TabIndex = 7;
//
// dtgvTable
//
this.dtgvTable.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvTable.Location = new System.Drawing.Point(3, 3);
this.dtgvTable.Name = "dtgvTable";
this.dtgvTable.Size = new System.Drawing.Size(343, 340);
this.dtgvTable.TabIndex = 0;
//
// tbFoodCategory
//
this.tbFoodCategory.Controls.Add(this.panel12);
this.tbFoodCategory.Controls.Add(this.panel17);
this.tbFoodCategory.Controls.Add(this.panel18);
this.tbFoodCategory.Location = new System.Drawing.Point(4, 22);
this.tbFoodCategory.Name = "tbFoodCategory";
this.tbFoodCategory.Padding = new System.Windows.Forms.Padding(3);
this.tbFoodCategory.Size = new System.Drawing.Size(650, 413);
this.tbFoodCategory.TabIndex = 2;
this.tbFoodCategory.Text = "Danh mục";
this.tbFoodCategory.UseVisualStyleBackColor = true;
//
// panel12
//
this.panel12.Controls.Add(this.panel15);
this.panel12.Controls.Add(this.panel16);
this.panel12.Location = new System.Drawing.Point(360, 62);
this.panel12.Name = "panel12";
this.panel12.Size = new System.Drawing.Size(285, 346);
this.panel12.TabIndex = 6;
//
// panel15
//
this.panel15.Controls.Add(this.textBox2);
this.panel15.Controls.Add(this.label7);
this.panel15.Location = new System.Drawing.Point(3, 53);
this.panel15.Name = "panel15";
this.panel15.Size = new System.Drawing.Size(279, 44);
this.panel15.TabIndex = 2;
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(125, 8);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(151, 20);
this.textBox2.TabIndex = 1;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label7.Location = new System.Drawing.Point(3, 9);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(124, 19);
this.label7.TabIndex = 0;
this.label7.Text = "Tên danh mục:";
//
// panel16
//
this.panel16.Controls.Add(this.txbCategoryID);
this.panel16.Controls.Add(this.label8);
this.panel16.Location = new System.Drawing.Point(3, 3);
this.panel16.Name = "panel16";
this.panel16.Size = new System.Drawing.Size(279, 44);
this.panel16.TabIndex = 1;
//
// txbCategoryID
//
this.txbCategoryID.Location = new System.Drawing.Point(125, 8);
this.txbCategoryID.Name = "txbCategoryID";
this.txbCategoryID.ReadOnly = true;
this.txbCategoryID.Size = new System.Drawing.Size(151, 20);
this.txbCategoryID.TabIndex = 1;
//
// label8
//
this.label8.AutoSize = true;
this.label8.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label8.Location = new System.Drawing.Point(3, 9);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(31, 19);
this.label8.TabIndex = 0;
this.label8.Text = "ID:";
//
// panel17
//
this.panel17.Controls.Add(this.btnShowCategory);
this.panel17.Controls.Add(this.btnEditCategory);
this.panel17.Controls.Add(this.btnDeleteCategory);
this.panel17.Controls.Add(this.btnAddCategory);
this.panel17.Location = new System.Drawing.Point(5, 4);
this.panel17.Name = "panel17";
this.panel17.Size = new System.Drawing.Size(349, 52);
this.panel17.TabIndex = 5;
//
// btnShowCategory
//
this.btnShowCategory.Location = new System.Drawing.Point(246, 3);
this.btnShowCategory.Name = "btnShowCategory";
this.btnShowCategory.Size = new System.Drawing.Size(75, 46);
this.btnShowCategory.TabIndex = 3;
this.btnShowCategory.Text = "Xem";
this.btnShowCategory.UseVisualStyleBackColor = true;
//
// btnEditCategory
//
this.btnEditCategory.Location = new System.Drawing.Point(165, 3);
this.btnEditCategory.Name = "btnEditCategory";
this.btnEditCategory.Size = new System.Drawing.Size(75, 46);
this.btnEditCategory.TabIndex = 2;
this.btnEditCategory.Text = "Sửa";
this.btnEditCategory.UseVisualStyleBackColor = true;
//
// btnDeleteCategory
//
this.btnDeleteCategory.Location = new System.Drawing.Point(84, 3);
this.btnDeleteCategory.Name = "btnDeleteCategory";
this.btnDeleteCategory.Size = new System.Drawing.Size(75, 46);
this.btnDeleteCategory.TabIndex = 1;
this.btnDeleteCategory.Text = "Xóa";
this.btnDeleteCategory.UseVisualStyleBackColor = true;
//
// btnAddCategory
//
this.btnAddCategory.Location = new System.Drawing.Point(3, 3);
this.btnAddCategory.Name = "btnAddCategory";
this.btnAddCategory.Size = new System.Drawing.Size(75, 46);
this.btnAddCategory.TabIndex = 0;
this.btnAddCategory.Text = "Thêm";
this.btnAddCategory.UseVisualStyleBackColor = true;
//
// panel18
//
this.panel18.Controls.Add(this.dtgvCategory);
this.panel18.Location = new System.Drawing.Point(5, 62);
this.panel18.Name = "panel18";
this.panel18.Size = new System.Drawing.Size(349, 346);
this.panel18.TabIndex = 4;
//
// dtgvCategory
//
this.dtgvCategory.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvCategory.Location = new System.Drawing.Point(3, 3);
this.dtgvCategory.Name = "dtgvCategory";
this.dtgvCategory.Size = new System.Drawing.Size(343, 340);
this.dtgvCategory.TabIndex = 0;
//
// tpFood
//
this.tpFood.Controls.Add(this.panel6);
this.tpFood.Controls.Add(this.panel5);
this.tpFood.Controls.Add(this.panel4);
this.tpFood.Controls.Add(this.panel3);
this.tpFood.Location = new System.Drawing.Point(4, 22);
this.tpFood.Name = "tpFood";
this.tpFood.Padding = new System.Windows.Forms.Padding(3);
this.tpFood.Size = new System.Drawing.Size(650, 413);
this.tpFood.TabIndex = 1;
this.tpFood.Text = "Thức ăn";
this.tpFood.UseVisualStyleBackColor = true;
//
// panel6
//
this.panel6.Controls.Add(this.txbSearchFoodName);
this.panel6.Controls.Add(this.btnSearchFood);
this.panel6.Location = new System.Drawing.Point(361, 3);
this.panel6.Name = "panel6";
this.panel6.Size = new System.Drawing.Size(283, 52);
this.panel6.TabIndex = 3;
//
// txbSearchFoodName
//
this.txbSearchFoodName.Location = new System.Drawing.Point(3, 17);
this.txbSearchFoodName.Name = "txbSearchFoodName";
this.txbSearchFoodName.Size = new System.Drawing.Size(199, 20);
this.txbSearchFoodName.TabIndex = 5;
//
// btnSearchFood
//
this.btnSearchFood.Location = new System.Drawing.Point(208, 3);
this.btnSearchFood.Name = "btnSearchFood";
this.btnSearchFood.Size = new System.Drawing.Size(75, 46);
this.btnSearchFood.TabIndex = 4;
this.btnSearchFood.Text = "Tìm";
this.btnSearchFood.UseVisualStyleBackColor = true;
this.btnSearchFood.Click += new System.EventHandler(this.btnSearchFood_Click);
//
// panel5
//
this.panel5.Controls.Add(this.panel10);
this.panel5.Controls.Add(this.panel9);
this.panel5.Controls.Add(this.panel8);
this.panel5.Controls.Add(this.panel7);
this.panel5.Location = new System.Drawing.Point(361, 61);
this.panel5.Name = "panel5";
this.panel5.Size = new System.Drawing.Size(285, 346);
this.panel5.TabIndex = 2;
//
// panel10
//
this.panel10.Controls.Add(this.nmFoodPrice);
this.panel10.Controls.Add(this.label4);
this.panel10.Location = new System.Drawing.Point(3, 153);
this.panel10.Name = "panel10";
this.panel10.Size = new System.Drawing.Size(279, 44);
this.panel10.TabIndex = 4;
//
// nmFoodPrice
//
this.nmFoodPrice.Location = new System.Drawing.Point(91, 8);
this.nmFoodPrice.Maximum = new decimal(new int[] {
100000000,
0,
0,
0});
this.nmFoodPrice.Name = "nmFoodPrice";
this.nmFoodPrice.Size = new System.Drawing.Size(185, 20);
this.nmFoodPrice.TabIndex = 1;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label4.Location = new System.Drawing.Point(3, 9);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(40, 19);
this.label4.TabIndex = 0;
this.label4.Text = "Giá:";
//
// panel9
//
this.panel9.Controls.Add(this.cbFoodCategory);
this.panel9.Controls.Add(this.label3);
this.panel9.Location = new System.Drawing.Point(3, 103);
this.panel9.Name = "panel9";
this.panel9.Size = new System.Drawing.Size(279, 44);
this.panel9.TabIndex = 3;
//
// cbFoodCategory
//
this.cbFoodCategory.FormattingEnabled = true;
this.cbFoodCategory.Location = new System.Drawing.Point(91, 9);
this.cbFoodCategory.Name = "cbFoodCategory";
this.cbFoodCategory.Size = new System.Drawing.Size(185, 21);
this.cbFoodCategory.TabIndex = 1;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label3.Location = new System.Drawing.Point(3, 9);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(93, 19);
this.label3.TabIndex = 0;
this.label3.Text = "Danh mục:";
//
// panel8
//
this.panel8.Controls.Add(this.txbFoodName);
this.panel8.Controls.Add(this.label2);
this.panel8.Location = new System.Drawing.Point(3, 53);
this.panel8.Name = "panel8";
this.panel8.Size = new System.Drawing.Size(279, 44);
this.panel8.TabIndex = 2;
//
// txbFoodName
//
this.txbFoodName.Location = new System.Drawing.Point(91, 8);
this.txbFoodName.Name = "txbFoodName";
this.txbFoodName.Size = new System.Drawing.Size(185, 20);
this.txbFoodName.TabIndex = 1;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label2.Location = new System.Drawing.Point(3, 9);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(82, 19);
this.label2.TabIndex = 0;
this.label2.Text = "Tên món:";
//
// panel7
//
this.panel7.Controls.Add(this.txbFoodID);
this.panel7.Controls.Add(this.label1);
this.panel7.Location = new System.Drawing.Point(3, 3);
this.panel7.Name = "panel7";
this.panel7.Size = new System.Drawing.Size(279, 44);
this.panel7.TabIndex = 1;
//
// txbFoodID
//
this.txbFoodID.Location = new System.Drawing.Point(91, 8);
this.txbFoodID.Name = "txbFoodID";
this.txbFoodID.ReadOnly = true;
this.txbFoodID.Size = new System.Drawing.Size(185, 20);
this.txbFoodID.TabIndex = 1;
this.txbFoodID.TextChanged += new System.EventHandler(this.txbFoodID_TextChanged);
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label1.Location = new System.Drawing.Point(3, 9);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(31, 19);
this.label1.TabIndex = 0;
this.label1.Text = "ID:";
//
// panel4
//
this.panel4.Controls.Add(this.btnShowFood);
this.panel4.Controls.Add(this.btnEditFood);
this.panel4.Controls.Add(this.btnDeleteFood);
this.panel4.Controls.Add(this.btnAddFood);
this.panel4.Location = new System.Drawing.Point(6, 3);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(349, 52);
this.panel4.TabIndex = 1;
//
// btnShowFood
//
this.btnShowFood.Location = new System.Drawing.Point(246, 3);
this.btnShowFood.Name = "btnShowFood";
this.btnShowFood.Size = new System.Drawing.Size(75, 46);
this.btnShowFood.TabIndex = 3;
this.btnShowFood.Text = "Xem";
this.btnShowFood.UseVisualStyleBackColor = true;
this.btnShowFood.Click += new System.EventHandler(this.btnShowFood_Click);
//
// btnEditFood
//
this.btnEditFood.Location = new System.Drawing.Point(165, 3);
this.btnEditFood.Name = "btnEditFood";
this.btnEditFood.Size = new System.Drawing.Size(75, 46);
this.btnEditFood.TabIndex = 2;
this.btnEditFood.Text = "Sửa";
this.btnEditFood.UseVisualStyleBackColor = true;
this.btnEditFood.Click += new System.EventHandler(this.btnEditFood_Click);
//
// btnDeleteFood
//
this.btnDeleteFood.Location = new System.Drawing.Point(84, 3);
this.btnDeleteFood.Name = "btnDeleteFood";
this.btnDeleteFood.Size = new System.Drawing.Size(75, 46);
this.btnDeleteFood.TabIndex = 1;
this.btnDeleteFood.Text = "Xóa";
this.btnDeleteFood.UseVisualStyleBackColor = true;
this.btnDeleteFood.Click += new System.EventHandler(this.btnDeleteFood_Click);
//
// btnAddFood
//
this.btnAddFood.Location = new System.Drawing.Point(3, 3);
this.btnAddFood.Name = "btnAddFood";
this.btnAddFood.Size = new System.Drawing.Size(75, 46);
this.btnAddFood.TabIndex = 0;
this.btnAddFood.Text = "Thêm";
this.btnAddFood.UseVisualStyleBackColor = true;
this.btnAddFood.Click += new System.EventHandler(this.btnAddFood_Click);
//
// panel3
//
this.panel3.Controls.Add(this.dtgvFood);
this.panel3.Location = new System.Drawing.Point(6, 61);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(349, 346);
this.panel3.TabIndex = 0;
//
// dtgvFood
//
this.dtgvFood.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvFood.Location = new System.Drawing.Point(3, 3);
this.dtgvFood.Name = "dtgvFood";
this.dtgvFood.Size = new System.Drawing.Size(343, 340);
this.dtgvFood.TabIndex = 0;
//
// tpBill
//
this.tpBill.Controls.Add(this.panel2);
this.tpBill.Controls.Add(this.panel1);
this.tpBill.Location = new System.Drawing.Point(4, 22);
this.tpBill.Name = "tpBill";
this.tpBill.Padding = new System.Windows.Forms.Padding(3);
this.tpBill.Size = new System.Drawing.Size(650, 413);
this.tpBill.TabIndex = 0;
this.tpBill.Text = "Doanh thu";
this.tpBill.UseVisualStyleBackColor = true;
//
// panel2
//
this.panel2.Controls.Add(this.btnViewBill);
this.panel2.Controls.Add(this.dtpkToDate);
this.panel2.Controls.Add(this.dtpkFromDate);
this.panel2.Location = new System.Drawing.Point(6, 6);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(638, 26);
this.panel2.TabIndex = 1;
//
// btnViewBill
//
this.btnViewBill.Location = new System.Drawing.Point(282, 0);
this.btnViewBill.Name = "btnViewBill";
this.btnViewBill.Size = new System.Drawing.Size(75, 23);
this.btnViewBill.TabIndex = 2;
this.btnViewBill.Text = "Thống kê";
this.btnViewBill.UseVisualStyleBackColor = true;
this.btnViewBill.Click += new System.EventHandler(this.btnViewBill_Click);
//
// dtpkToDate
//
this.dtpkToDate.Location = new System.Drawing.Point(435, 3);
this.dtpkToDate.Name = "dtpkToDate";
this.dtpkToDate.Size = new System.Drawing.Size(200, 20);
this.dtpkToDate.TabIndex = 1;
//
// dtpkFromDate
//
this.dtpkFromDate.Location = new System.Drawing.Point(3, 3);
this.dtpkFromDate.Name = "dtpkFromDate";
this.dtpkFromDate.Size = new System.Drawing.Size(200, 20);
this.dtpkFromDate.TabIndex = 0;
//
// panel1
//
this.panel1.Controls.Add(this.txbPageBill);
this.panel1.Controls.Add(this.btnNextBillPage);
this.panel1.Controls.Add(this.btnPrevioursBillPage);
this.panel1.Controls.Add(this.btnLastBillPage);
this.panel1.Controls.Add(this.btnFristBillPage);
this.panel1.Controls.Add(this.dtgvBill);
this.panel1.Location = new System.Drawing.Point(6, 38);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(638, 369);
this.panel1.TabIndex = 0;
//
// txbPageBill
//
this.txbPageBill.Location = new System.Drawing.Point(282, 343);
this.txbPageBill.Name = "txbPageBill";
this.txbPageBill.ReadOnly = true;
this.txbPageBill.Size = new System.Drawing.Size(75, 20);
this.txbPageBill.TabIndex = 5;
this.txbPageBill.Text = "1";
this.txbPageBill.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
this.txbPageBill.TextChanged += new System.EventHandler(this.txbPageBill_TextChanged);
//
// btnNextBillPage
//
this.btnNextBillPage.Location = new System.Drawing.Point(479, 343);
this.btnNextBillPage.Name = "btnNextBillPage";
this.btnNextBillPage.Size = new System.Drawing.Size(75, 23);
this.btnNextBillPage.TabIndex = 4;
this.btnNextBillPage.Text = "Next";
this.btnNextBillPage.UseVisualStyleBackColor = true;
this.btnNextBillPage.Click += new System.EventHandler(this.btnNextBillPage_Click);
//
// btnPrevioursBillPage
//
this.btnPrevioursBillPage.Location = new System.Drawing.Point(84, 343);
this.btnPrevioursBillPage.Name = "btnPrevioursBillPage";
this.btnPrevioursBillPage.Size = new System.Drawing.Size(75, 23);
this.btnPrevioursBillPage.TabIndex = 3;
this.btnPrevioursBillPage.Text = "Previours";
this.btnPrevioursBillPage.UseVisualStyleBackColor = true;
this.btnPrevioursBillPage.Click += new System.EventHandler(this.btnPrevioursBillPage_Click);
//
// btnLastBillPage
//
this.btnLastBillPage.Location = new System.Drawing.Point(560, 344);
this.btnLastBillPage.Name = "btnLastBillPage";
this.btnLastBillPage.Size = new System.Drawing.Size(75, 23);
this.btnLastBillPage.TabIndex = 2;
this.btnLastBillPage.Text = "Last";
this.btnLastBillPage.UseVisualStyleBackColor = true;
this.btnLastBillPage.Click += new System.EventHandler(this.btnLastBillPage_Click);
//
// btnFristBillPage
//
this.btnFristBillPage.Location = new System.Drawing.Point(3, 343);
this.btnFristBillPage.Name = "btnFristBillPage";
this.btnFristBillPage.Size = new System.Drawing.Size(75, 23);
this.btnFristBillPage.TabIndex = 1;
this.btnFristBillPage.Text = "First";
this.btnFristBillPage.UseVisualStyleBackColor = true;
this.btnFristBillPage.Click += new System.EventHandler(this.btnFristBillPage_Click);
//
// dtgvBill
//
this.dtgvBill.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
this.dtgvBill.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvBill.Location = new System.Drawing.Point(3, 3);
this.dtgvBill.Name = "dtgvBill";
this.dtgvBill.Size = new System.Drawing.Size(632, 335);
this.dtgvBill.TabIndex = 0;
//
// tcAdmin
//
this.tcAdmin.Controls.Add(this.tpBill);
this.tcAdmin.Controls.Add(this.tpFood);
this.tcAdmin.Controls.Add(this.tbFoodCategory);
this.tcAdmin.Controls.Add(this.tpTable);
this.tcAdmin.Controls.Add(this.tpAccount);
this.tcAdmin.Controls.Add(this.tabPage1);
this.tcAdmin.Location = new System.Drawing.Point(12, 12);
this.tcAdmin.Name = "tcAdmin";
this.tcAdmin.SelectedIndex = 0;
this.tcAdmin.Size = new System.Drawing.Size(658, 439);
this.tcAdmin.TabIndex = 0;
//
// tabPage1
//
this.tabPage1.Controls.Add(this.rpViewer);
this.tabPage1.Location = new System.Drawing.Point(4, 22);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(650, 413);
this.tabPage1.TabIndex = 5;
this.tabPage1.Text = "Report";
this.tabPage1.UseVisualStyleBackColor = true;
//
// rpViewer
//
reportDataSource1.Name = "DataSet1";
reportDataSource1.Value = this.USP_GetListBillByDateForReportBindingSource;
this.rpViewer.LocalReport.DataSources.Add(reportDataSource1);
this.rpViewer.LocalReport.ReportEmbeddedResource = "QuanLyQuanCafe.Report2.rdlc";
this.rpViewer.Location = new System.Drawing.Point(0, 0);
this.rpViewer.Name = "rpViewer";
this.rpViewer.Size = new System.Drawing.Size(650, 417);
this.rpViewer.TabIndex = 0;
//
//
// QuanLyQuanCafeDataSet2
//
this.QuanLyQuanCafeDataSet2.DataSetName = "QuanLyQuanCafeDataSet2";
this.QuanLyQuanCafeDataSet2.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// USP_GetListBillByDateForReportBindingSource
//
this.USP_GetListBillByDateForReportBindingSource.DataMember = "USP_GetListBillByDateForReport";
this.USP_GetListBillByDateForReportBindingSource.DataSource = this.QuanLyQuanCafeDataSet2;
//
// USP_GetListBillByDateForReportTableAdapter
//
this.USP_GetListBillByDateForReportTableAdapter.ClearBeforeFill = true;
//
// fAdmin
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(674, 463);
this.Controls.Add(this.tcAdmin);
this.Name = "fAdmin";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Admin";
this.Load += new System.EventHandler(this.fAdmin_Load);
this.tpAccount.ResumeLayout(false);
this.panel23.ResumeLayout(false);
this.panel25.ResumeLayout(false);
this.panel25.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.numericUpDown1)).EndInit();
this.panel26.ResumeLayout(false);
this.panel26.PerformLayout();
this.panel27.ResumeLayout(false);
this.panel27.PerformLayout();
this.panel28.ResumeLayout(false);
this.panel29.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvAccount)).EndInit();
this.tpTable.ResumeLayout(false);
this.panel11.ResumeLayout(false);
this.panel21.ResumeLayout(false);
this.panel21.PerformLayout();
this.panel13.ResumeLayout(false);
this.panel13.PerformLayout();
this.panel14.ResumeLayout(false);
this.panel14.PerformLayout();
this.panel19.ResumeLayout(false);
this.panel20.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvTable)).EndInit();
this.tbFoodCategory.ResumeLayout(false);
this.panel12.ResumeLayout(false);
this.panel15.ResumeLayout(false);
this.panel15.PerformLayout();
this.panel16.ResumeLayout(false);
this.panel16.PerformLayout();
this.panel17.ResumeLayout(false);
this.panel18.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvCategory)).EndInit();
this.tpFood.ResumeLayout(false);
this.panel6.ResumeLayout(false);
this.panel6.PerformLayout();
this.panel5.ResumeLayout(false);
this.panel10.ResumeLayout(false);
this.panel10.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.nmFoodPrice)).EndInit();
this.panel9.ResumeLayout(false);
this.panel9.PerformLayout();
this.panel8.ResumeLayout(false);
this.panel8.PerformLayout();
this.panel7.ResumeLayout(false);
this.panel7.PerformLayout();
this.panel4.ResumeLayout(false);
this.panel3.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvFood)).EndInit();
this.tpBill.ResumeLayout(false);
this.panel2.ResumeLayout(false);
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvBill)).EndInit();
this.tcAdmin.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.QuanLyQuanCafeDataSet2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.USP_GetListBillByDateForReportBindingSource)).EndInit();
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.TabPage tpAccount;
private System.Windows.Forms.Panel panel23;
private System.Windows.Forms.Button btnResetPassword;
private System.Windows.Forms.Panel panel25;
private System.Windows.Forms.NumericUpDown numericUpDown1;
private System.Windows.Forms.Label label11;
private System.Windows.Forms.Panel panel26;
private System.Windows.Forms.TextBox txbDisplayName;
private System.Windows.Forms.Label label12;
private System.Windows.Forms.Panel panel27;
private System.Windows.Forms.TextBox txbUserName;
private System.Windows.Forms.Label label13;
private System.Windows.Forms.Panel panel28;
private System.Windows.Forms.Button btnShowAccount;
private System.Windows.Forms.Button btnEditAccount;
private System.Windows.Forms.Button btnDeleteAccount;
private System.Windows.Forms.Button btnAddAccount;
private System.Windows.Forms.Panel panel29;
private System.Windows.Forms.DataGridView dtgvAccount;
private System.Windows.Forms.TabPage tpTable;
private System.Windows.Forms.Panel panel11;
private System.Windows.Forms.Panel panel21;
private System.Windows.Forms.ComboBox cbTableStatus;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.Panel panel13;
private System.Windows.Forms.TextBox txbTableName;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Panel panel14;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Panel panel19;
private System.Windows.Forms.Button btnShowTable;
private System.Windows.Forms.Button btnEditTable;
private System.Windows.Forms.Button btnDeleteTable;
private System.Windows.Forms.Button btnAddTable;
private System.Windows.Forms.Panel panel20;
private System.Windows.Forms.DataGridView dtgvTable;
private System.Windows.Forms.TabPage tbFoodCategory;
private System.Windows.Forms.Panel panel12;
private System.Windows.Forms.Panel panel15;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Panel panel16;
private System.Windows.Forms.TextBox txbCategoryID;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Panel panel17;
private System.Windows.Forms.Button btnShowCategory;
private System.Windows.Forms.Button btnEditCategory;
private System.Windows.Forms.Button btnDeleteCategory;
private System.Windows.Forms.Button btnAddCategory;
private System.Windows.Forms.Panel panel18;
private System.Windows.Forms.DataGridView dtgvCategory;
private System.Windows.Forms.TabPage tpFood;
private System.Windows.Forms.Panel panel6;
private System.Windows.Forms.TextBox txbSearchFoodName;
private System.Windows.Forms.Button btnSearchFood;
private System.Windows.Forms.Panel panel5;
private System.Windows.Forms.Panel panel10;
private System.Windows.Forms.NumericUpDown nmFoodPrice;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Panel panel9;
private System.Windows.Forms.ComboBox cbFoodCategory;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Panel panel8;
private System.Windows.Forms.TextBox txbFoodName;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Panel panel7;
private System.Windows.Forms.TextBox txbFoodID;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Button btnShowFood;
private System.Windows.Forms.Button btnEditFood;
private System.Windows.Forms.Button btnDeleteFood;
private System.Windows.Forms.Button btnAddFood;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.DataGridView dtgvFood;
private System.Windows.Forms.TabPage tpBill;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Button btnViewBill;
private System.Windows.Forms.DateTimePicker dtpkToDate;
private System.Windows.Forms.DateTimePicker dtpkFromDate;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.TextBox txbPageBill;
private System.Windows.Forms.Button btnNextBillPage;
private System.Windows.Forms.Button btnPrevioursBillPage;
private System.Windows.Forms.Button btnLastBillPage;
private System.Windows.Forms.Button btnFristBillPage;
private System.Windows.Forms.DataGridView dtgvBill;
private System.Windows.Forms.TabControl tcAdmin;
private System.Windows.Forms.TabPage tabPage1;
private Microsoft.Reporting.WinForms.ReportViewer rpViewer;
private System.Windows.Forms.BindingSource USP_GetTableListBindingSource;
private System.Windows.Forms.BindingSource USP_GetListBillByDateForReportBindingSource;
private QuanLyQuanCafeDataSet2 QuanLyQuanCafeDataSet2;
private QuanLyQuanCafeDataSet2TableAdapters.USP_GetListBillByDateForReportTableAdapter USP_GetListBillByDateForReportTableAdapter;
}
}
Bài sau chúng ta sẽ cùng nhau tìm hiểu cách đóng gói phần mềm.
Đừng quên: “Luyện tập – Thử thách – Không ngại khó”
Tải xuống
Tài liệu
Nhằm phục vụ mục đích học tập Offline của cộng đồng, Kteam hỗ trợ tính năng lưu trữ nội dung bài học Tạo report trong phần mềm Quản lý quán cafe với C# Winform dưới dạng file PDF trong link bên dưới.
Ngoài ra, bạn cũng có thể tìm thấy các tài liệu được đóng góp từ cộng đồng ở mục TÀI LIỆU trên thư viện Howkteam.com
Đừng quên like và share để ủng hộ Kteam và tác giả nhé!
Project
Nếu việc thực hành theo hướng dẫn không diễn ra suôn sẻ như mong muốn. Bạn cũng có thể tải xuống PROJECT THAM KHẢO ở link bên dưới!
Thảo luận
Nếu bạn có bất kỳ khó khăn hay thắc mắc gì về khóa học, đừng ngần ngại đặt câu hỏi trong phần bên dưới hoặc trong mục HỎI & ĐÁP trên thư viện Howkteam.com để nhận được sự hỗ trợ từ cộng đồng.
Nội dung bài viết
Tác giả/Dịch giả
Khóa học
Lập trình phần mềm Quản lý quán cafe với C# Winform
Bạn đã học qua LẬP TRÌNH C# CƠ BẢN? Xong nốt cả LẬP TRÌNH WINFORM lẫn SQL?
Bạn đã chán các bài tập căn bản, muốn thực hành các kiến thức đã học vào một dự án thực tế?
Hay đơn giản bạn là chủ quán café, mong muốn tự tạo nên phần mềm dành cho chính mình sử dụng?
Vậy còn chần chừ gì không tham gia ngay khóa học LẬP TRÌNH PHẦN MỀM QUÁN CAFÉ VỚI C# WINFORM?
Đánh giá
https://photos.app.goo.gl/dFQ5ZHFxyWLrHfcR8
ad ơi xem giúp mình cái lỗi này dc ko
cho mình hỏi, VS của mình lúc đầu không có "Reportviewer" nên mình lên mạng tìm cài thêm thêm vào, cài được ròi nhưng nhưng có phần Design phải là xao?