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