private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvHangHoa.DataSource = sql.getDataTable("HangHoa");
// DATA.SqlConn sql = new DATA.SqlConn();
// dgvHangHoa.DataSource = sql.getDataTable("HangHoa");
}
private void btnSearch_GiangDay_Click(object sender, EventArgs e)
{
if (cbOption_GiangDay.Text.Equals(""))
{
MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (cbOption_GiangDay.Text.Equals("Mã giáo viên"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "GiangDay";
string key = "magiaovien";
dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'");
LockControl();
}
if (cbOption_GiangDay.Text.Equals("Mã lớp học"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "GiangDay";
string key = "malop";
dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'");
LockControl();
}
if (cbOption_GiangDay.Text.Equals("Mã môn học"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "GiangDay";
string key = "mamonhoc";
dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'");
LockControl();
}
}
private void btnSearch_HocSinh_Click(object sender, EventArgs e)
{
if (cbOption.Text.Equals(""))
{
MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (cbOption.Text.Equals("Mã học sinh"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "HocSinh";
string key = "mahocsinh";
dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'");
LockControl();
}
if (cbOption.Text.Equals("Tên học sinh"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "HocSinh";
string key = "hoten";
dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'");
LockControl();
}
if (cbOption.Text.Equals("Mã lớp"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "HocSinh";
string key = "malop";
dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'");
LockControl();
}
}
private void btnSearch_ChucVu_Click(object sender, EventArgs e)
{
if (cbOption_ChucVu.Text.Equals(""))
{
MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (cbOption_ChucVu.Text.Equals("Mã chức vụ"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "ChucVu";
string key = "machucvu";
dgvChucVu.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_ChucVu.Text.Trim() + "%'");
LockControl();
}
}
private void btnThongKe_Click(object sender, EventArgs e)
{
dgvThongKe.Height = 362;
if (cbOption_ThongKe.Text.Equals("Học sinh - Lớp Học"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.TK("select a.mahocsinh,a.hoten,a.diachi,b.tenlop from HocSinh as a,Lop as b where a.malop = b.malop");
dgvThongKe.AutoResizeColumns();
dgvThongKe.AutoResizeRows();
}
if (cbOption_ThongKe.Text.Equals("Giáo Viên - Chức Vụ"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.TK("select a.magiaovien,a.tengiaovien,a.trinhdo,b.tenchucvu,a.sdt from GiaoVien as a, ChucVu as b where a.machucvu=b.machucvu");
}
if (cbOption_ThongKe.Text.Equals("Danh sách môn học"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.TK("select a.mamonhoc,a.tenmonhoc,b.malop,b.sotiet,b.thu,b.tiet from MonHoc as a,GiangDay as b where a.mamonhoc=b.mamonhoc");
}
if (cbOption_ThongKe.Text.Equals("Số lượng học sinh theo lớp"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.TK("select b.malop,b.tenlop,count(a.mahocsinh) as 'sohocsinh' from HocSinh as a,Lop as b where a.malop=b.malop group by b.malop, b.tenlop");
}
if (cbOption_ThongKe.Text.Equals("Số giáo viên theo chức vụ"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.TK("select b.machucvu,b.tenchucvu,count(a.magiaovien) as 'sogiaovien' from GiaoVien as a,ChucVu as b where a.machucvu=b.machucvu group by b.machucvu, b.tenchucvu");
}
if (cbOption_ThongKe.Text.Equals("Học lực của học sinh theo học kỳ"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.TK("select b.hocki,a.mahocsinh,a.hoten,b.mamonhoc,b.diemtrungbinh from HocSinh as a,BangDiem as b where a.mahocsinh=b.mahocsinh");
}
if (cbOption_ThongKe.Text.Equals("Sô tiết dạy của giáo viên trong 1 tuần"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.TK("select a.magiaovien,a.tengiaovien,count(b.sotiet) as 'soluongtiet' from GiaoVien as a,GiangDay as b where a.magiaovien=b.magiaovien group by a.magiaovien, a.tengiaovien");
}
}
private void btnThongKe_Click(object sender, EventArgs e)
{
if (cbOption_ThongKe.Text.Equals("Số lượng hàng hóa"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.Statistic("select sum(a.soluong) as 'Số lượng hàng hóa' from (select count(MaHH) soluong from HangHoa group by MaHH) a");
}
if (cbOption_ThongKe.Text.Equals("Số lượng nhân viên"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.Statistic("select sum(a.soluong) as 'Số lượng phiếu xuất' from (select count(MaPX) soluong from PhieuXuat group by MaPX) a");
}
if (cbOption_ThongKe.Text.Equals("Số lượng phiếu nhập"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.Statistic("select sum(a.soluong) as 'Số lượng phiếu nhập' from (select count(MaPN) soluong from PhieuNhap group by MaPN) a");
}
if (cbOption_ThongKe.Text.Equals("Số lượng phiếu xuất"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.Statistic("select sum(a.soluong) as 'Số lượng phiếu xuất' from (select count(MaPX) soluong from PhieuXuat group by MaPX) a");
}
if (cbOption_ThongKe.Text.Equals("Số lượng hàng hóa theo nhà cung cấp"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.Statistic("select d.TenNCC, c.soluong from NhaCungCap d, (select a.MaNCC, (a.MaNCC) as soluong from HangHoa a, NhaCungCap b where a.MaNCC = b.MaNCC group by a.MaNCC) c where d.MaNCC = c.MaNCC");
}
if (cbOption_ThongKe.Text.Equals("Số lượng nhà cung cấp"))
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvThongKe.DataSource = sql.Statistic("select sum(a.soluong) as 'Số lượng nhà cung cấp' from(select count(MaNCC) soluong from NhaCungCap group by MaNCC) a");
}
}
private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvMonHoc.DataSource = sql.getDataTable("MonHoc");
}
private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvGiangDay.DataSource = sql.getDataTable("GiangDay");
}
private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvBangDiem.DataSource = sql.getDataTable("BangDiem");
}
private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvHocSinh.DataSource = sql.getDataTable("HocSinh");
}
private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
// dgvNhapHang.DataSource = sql.getDataTable("NhanVien");
// Liên kết với 2 bảng Phiếu nhập và Chi tiết nhập
}
private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvChucVu.DataSource = sql.getDataTable("ChucVu");
}
private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
}
private void loadDataGirdView()
{
DATA.SqlConn sql = new DATA.SqlConn();
dgvNhanVien.DataSource = sql.getDataTable("NhanVien");
}
