private void button2_Click(object sender, EventArgs e)
{
QuanLyController quanLy = new QuanLyController();
XemAllThongKe allThongKe = new XemAllThongKe(quanLy.ThongTinTD(dateTimePicker1.Value));
allThongKe.FThongTinTieuDung();
allThongKe.Show();
}
private void LoadView()
{
quanLy = new QuanLyController(0);
tbDsNhanvien.DataSource = quanLy.viewNhanVien;
tbDsNhanvien.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbDsNhanvien.ReadOnly = true;
tbDsNhanvien.Columns["Giới tính"].Visible = false;
}
//Nghiem Thu
public void SetViewNghiemThu(NguoiDung ng)
{
this.nguoiDung = ng;
this.quanLy = new QuanLyController();
lbTen.Text = nguoiDung.Tn_dung;
LoadComboxPhong();
id_tthai = 4;
LoadDataTable(nguoiDung);
btNghiemThu.Visible = true;
LoadComboxTrangThaiNghiemThu();
}
private void cbPhong_SelectedIndexChanged(object sender, EventArgs e)
{
phong = (Phong)cbPhong.SelectedItem;
this.quanLy = new QuanLyController(phong.Id_phong, dateTime.Value);
data = quanLy.viewThongKeChi;
tbViewThongKeChi.DataSource = data;
tbViewThongKeChi.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbViewThongKeChi.Columns["Kế toán"].Visible = false;
tbViewThongKeChi.Columns["t_phong"].Visible = false;
tbViewThongKeChi.Columns["ngay_giao_tien"].Visible = false;
}
public void SetNguoiDung(NguoiDung ng)
{
this.nguoiDung = ng;
lbTen.Text = nguoiDung.Tn_dung;
//lấy dữ liệu phòng
this.quanLy = new QuanLyController();
LoadComboxPhong();
loadComboxTrangThai();
id_tthai = 1;
LoadDataTable(ng);
btNghiemThu.Visible = false;
}
private void cbPhong_SelectedIndexChanged(object sender, EventArgs e)
{
Phong p = (Phong)cbPhong.SelectedItem;
this.quanLy = new QuanLyController(this.nguoiDung, p.Id_phong, id_tthai);
tbTieuDung.DataSource = quanLy.viewTieuDung;
tbTieuDung.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
if (tbTieuDung.Rows.Count > 1)
{
tbTieuDung.ReadOnly = true;
LoadDataTextBox(tbTieuDung.Rows[0]);
}
}
private void LoadCombox()
{
//load danh sách phòng
quanLy = new QuanLyController();
cbPhong.DataSource = quanLy.ArrPhong();
cbPhong.DisplayMember = "t_phong";
cbPhong.ValueMember = "id_phong";
//load danh sach chức vụ
cbQuyen.Items.Add("Nhân viên");
cbQuyen.Items.Add("Kế toán");
cbQuyen.Items.Add("Quản lý");
}
private void LoadTablePhong()
{
this.quanLyPhong = new QuanLyController(0);
tbPhong.DataSource = quanLyPhong.phong;
tbPhong.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbPhong.Columns["id"].Visible = false;
tbPhong.Columns["Số lượng nhân viên"].Visible = false;
if (tbPhong.Rows.Count > 1)
{
LoadData(tbPhong.Rows[0]);
LoadTable((int)tbPhong.Rows[0].Cells["id"].Value);
}
}
private void LoadDataTable(NguoiDung ng)
{
Phong p = (Phong)cbPhong.SelectedItem;
this.quanLy = new QuanLyController(ng, p.Id_phong, id_tthai);
tbTieuDung.DataSource = quanLy.viewTieuDung;
tbTieuDung.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbTieuDung.Columns["id"].Visible = false;
if (tbTieuDung.Rows.Count > 1)
{
tbTieuDung.ReadOnly = true;
LoadDataTextBox(tbTieuDung.Rows[0]);
}
}
public void SetNguoiDung(NguoiDung ng)
{
this.nguoiDung = ng;
this.quanLy = new QuanLyController();
LoadComboxPhong();
phong = (Phong)cbPhong.SelectedItem;
this.quanLy = new QuanLyController(phong.Id_phong, dateTime.Value);
data = quanLy.viewThongKeChi;
tbViewThongKeChi.DataSource = data;
tbViewThongKeChi.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbViewThongKeChi.Columns["Kế toán"].Visible = false;
tbViewThongKeChi.Columns["t_phong"].Visible = false;
tbViewThongKeChi.Columns["ngay_giao_tien"].Visible = false;
}
private void LoadTable(int id_phong)
{
this.quanLy = new QuanLyController(id_phong);
//custom bang nhanvien
tbNhanVien.DataSource = quanLy.viewNhanVien;
tbNhanVien.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbNhanVien.Columns["Tài Khoản"].Visible = false;
tbNhanVien.Columns["Mật khẩu"].Visible = false;
tbNhanVien.Columns["Phòng"].Visible = false;
tbTieuDungPhong.DataSource = quanLy.viewTieuDung;
tbTieuDungPhong.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbTieuDungPhong.Columns["Giá"].Visible = false;
tbTieuDungPhong.Columns["Đề nghị"].Visible = false;
tbTieuDungPhong.Columns["Ngày duyệt"].Visible = false;
tbTieuDungPhong.Columns["Trạng thái"].Visible = false;
tbTieuDungPhong.Columns["id"].Visible = false;
}
public QuanLy_UnitTest()
{
data_test = new Data_Test();
controller = new QuanLyController();
}
