private void frmThanhLyThietBi_Load(object sender, EventArgs e)
{
string strSelect = "exec Pro_LoaiThietBi";
MyPublics.OpenData(strSelect, dsLoaiThietBi, "LoaiThietBi");
DataRow drMoiLoai = dsLoaiThietBi.Tables["LoaiThietBi"].NewRow();
drMoiLoai["MA_LOAI"] = 0;
drMoiLoai["TEN_LOAI"] = "Mọi loại";
dsLoaiThietBi.Tables["LoaiThietBi"].Rows.InsertAt(drMoiLoai, 0);
cboLoaiThietBi.DataSource = dsLoaiThietBi.Tables["LoaiThietBi"];
cboLoaiThietBi.DisplayMember = "TEN_LOAI";
cboLoaiThietBi.ValueMember = "MA_LOAI";
dsTinhTrang.Tables.Add("DSTinhTrang");
dsTinhTrang.Tables["DSTinhTrang"].Columns.Add("TinhTrang");
dsTinhTrang.Tables["DSTinhTrang"].Rows.Add("Mới");
dsTinhTrang.Tables["DSTinhTrang"].Rows.Add("Cũ");
dsTinhTrang.Tables["DSTinhTrang"].Rows.Add("Hư");
cboTinhTrang.DataSource = dsTinhTrang;
cboTinhTrang.DisplayMember = "DSTinhTrang.TinhTrang";
cboTinhTrang.ValueMember = "DSTinhTrang.TinhTrang";
txtMaThietBi.MaxLength = 15;
NhanDuLieu();
dvThietBi.Table = dsThietBi.Tables["ThietBi"];
if (cboLoaiThietBi.SelectedIndex != 0)
{
dvThietBi.RowFilter = "MA_LOAI like '" + cboLoaiThietBi.SelectedValue + "' And TINHTRANG like 'Chờ thanh lý'";
}
else
{
dvThietBi.RowFilter = "MA_LOAI like '*' And TINHTRANG like 'Chờ thanh lý'";
}
dgvThietBi.DataSource = dvThietBi;
dgvThietBi.Width = 1158;
dgvThietBi.AllowUserToAddRows = false;
dgvThietBi.AllowUserToDeleteRows = false;
dgvThietBi.Columns[0].Width = 120;
dgvThietBi.Columns[0].HeaderText = "Mã số";
dgvThietBi.Columns[1].Width = 95;
dgvThietBi.Columns[1].HeaderText = "Mã Loại";
dgvThietBi.Columns[2].Width = 100;
dgvThietBi.Columns[2].HeaderText = "Tình Trạng";
dgvThietBi.Columns[3].Width = 60;
dgvThietBi.Columns[3].HeaderText = "TH Bảo Hành";
dgvThietBi.Columns[4].Width = 60;
dgvThietBi.Columns[4].HeaderText = "TL Hao Mòn";
dgvThietBi.Columns[5].Width = 100;
dgvThietBi.Columns[5].HeaderText = "Giá trị";
dgvThietBi.Columns[6].Width = 270;
dgvThietBi.Columns[6].HeaderText = "Tên Thiết Bị";
dgvThietBi.Columns[7].Width = 80;
dgvThietBi.Columns[7].HeaderText = "Mã Phòng";
dgvThietBi.Columns[8].Width = 60;
dgvThietBi.Columns[8].HeaderText = "Mã Bộ Môn";
dgvThietBi.Columns[9].Width = 150;
dgvThietBi.Columns[9].HeaderText = "Ngày Đặt";
dgvThietBi.EditMode = DataGridViewEditMode.EditProgrammatically;
GanDuLieu();
DieuKhienKhiBinhThuong();
}
private void frmPhong_Load(object sender, EventArgs e)
{
string strSelect = "Select MA_BM, TEN_BM From BOMON";
MyPublics.OpenData(strSelect, dsBoMon, "BOMON");
cboTenBoMon.DataSource = dsBoMon.Tables["BOMON"];
cboTenBoMon.DisplayMember = "TEN_BM";
cboTenBoMon.ValueMember = "MA_BM";
txtMaPhong.MaxLength = 5;
txtTenPhong.MaxLength = 30;
NhanDuLieu();
dvPhong.Table = dsPhong.Tables["PHONG"];
dvPhong.RowFilter = "MA_BM like '" + cboTenBoMon.SelectedValue + "'";
dgvPhongTheoBoMon.DataSource = dvPhong;
dgvPhongTheoBoMon.Width = 550;
dgvPhongTheoBoMon.AllowUserToAddRows = false;
dgvPhongTheoBoMon.AllowUserToDeleteRows = false;
dgvPhongTheoBoMon.Columns[0].Width = 100;
dgvPhongTheoBoMon.Columns[0].HeaderText = "Mã phòng";
dgvPhongTheoBoMon.Columns[1].Width = 150;
dgvPhongTheoBoMon.Columns[1].HeaderText = "Mã bộ môn";
dgvPhongTheoBoMon.Columns[2].Width = 261;
dgvPhongTheoBoMon.Columns[2].HeaderText = "Tên Phòng";
dgvPhongTheoBoMon.EditMode = DataGridViewEditMode.EditProgrammatically;
GanDuLieu();
DieuKhienKhiBinhThuong();
}
void SoCanBo()
{
DataSet dsCanBo = new DataSet();
DataView dvSoCanBo = new DataView();
string strSelect = "Select * From CANBO";
MyPublics.OpenData(strSelect, dsCanBo, "CANBO");
dvSoCanBo.Table = dsCanBo.Tables["CANBO"];
dvSoCanBo.RowFilter = "MA_BM Like '" + cboBoMon.SelectedValue.ToString() + "'";
txtSoCanBo.Text = dvSoCanBo.Count.ToString();
}
private void ThietBiThanhLy_Load(object sender, EventArgs e)
{
string strSelect = "exec Pro_ThietBiThanhLy";
MyPublics.OpenData(strSelect, dsThietBiThanhLy, "ThietBiThanhLy", daThietBiThanhLy);
bsThietBiThanhLy.DataSource = dsThietBiThanhLy;
bsThietBiThanhLy.DataMember = "ThietBiThanhLy";
txtViTri.Enabled = false;
txtViTri.BackColor = Color.White;
GanDuLieu();
DieuKhienKhiBinhThuong();
}
private void frmLoaiThietBi_Load(object sender, EventArgs e)
{
string strSelect = "Select * From LOAITHIETBI";
MyPublics.OpenData(strSelect, dsLoaiThietBi, "LoaiThietBi", daLoaiThietBi);
bsLoaiThietBi.DataSource = dsLoaiThietBi;
bsLoaiThietBi.DataMember = "LoaiThietBi";
txtMaLoai.MaxLength = 15;
txtTenLoai.MaxLength = 200;
txtViTri.Enabled = false;
txtViTri.BackColor = Color.White;
GanDuLieu();
DieuKhienKhiBinhThuong();
}
private void frmBoMon_Load(object sender, EventArgs e)
{
string strSelect = "Select * From BOMON";
MyPublics.OpenData(strSelect, dsBoMon, "BOMON", daBoMon);
bsBoMon.DataSource = dsBoMon;
bsBoMon.DataMember = "BOMON";
cboBoMon.DisplayMember = "TEN_BM";
cboBoMon.ValueMember = "MA_BM";
cboBoMon.DataSource = bsBoMon;
txtMaBoMon.MaxLength = 5;
txtTenBoMon.MaxLength = 40;
txtViTri.BackColor = Color.White;
GanDuLieu();
SoCanBo();
DieuKhienKhiBinhThuong();
}
private void frmCanBoTheoBoMon_Load(object sender, EventArgs e)
{
string strSelect = "Select MA_BM, TEN_BM From BOMON";
MyPublics.OpenData(strSelect, dsBoMon, "BOMON");
cboTenBoMon.DataSource = dsBoMon.Tables["BOMON"];
cboTenBoMon.DisplayMember = "TEN_BM";
cboTenBoMon.ValueMember = "MA_BM";
dsQuyenSudung.Tables.Add("DSQuyenSuDung");
dsQuyenSudung.Tables["DSQuyenSuDung"].Columns.Add("QUYENSD");
dsQuyenSudung.Tables["DSQuyenSuDung"].Rows.Add("AllAdmin");
dsQuyenSudung.Tables["DSQuyenSuDung"].Rows.Add("Admin");
dsQuyenSudung.Tables["DSQuyenSuDung"].Rows.Add("User");
cboQuyenSuDung.DataSource = dsQuyenSudung;
cboQuyenSuDung.DisplayMember = "DSQuyenSuDung.QUYENSD";
cboQuyenSuDung.ValueMember = "DSQuyenSuDung.QUYENSD";
txtMaCanBo.MaxLength = 5;
txtTenCanBo.MaxLength = 30;
NhanDuLieu();
dvCanBo.Table = dsCanBo.Tables["CANBO"];
dvCanBo.RowFilter = "MA_BM like '" + cboTenBoMon.SelectedValue + "'";
dgvCanBo.DataSource = dvCanBo;
dgvCanBo.Width = 808;
dgvCanBo.AllowUserToAddRows = false;
dgvCanBo.AllowUserToDeleteRows = false;
dgvCanBo.Columns[0].Width = 117;
dgvCanBo.Columns[0].HeaderText = "Mã cán bộ";
dgvCanBo.Columns[1].Width = 220;
dgvCanBo.Columns[1].HeaderText = "Tên cán bộ";
dgvCanBo.Columns[2].Width = 150;
dgvCanBo.Columns[2].HeaderText = "Bộ môn";
dgvCanBo.Columns[3].Width = 120;
dgvCanBo.Columns[3].HeaderText = "Mật khẩu";
dgvCanBo.Columns[4].Width = 140;
dgvCanBo.Columns[4].HeaderText = "Quyền sử dụng";
dgvCanBo.EditMode = DataGridViewEditMode.EditProgrammatically;
dgvCanBo.CellFormatting += new DataGridViewCellFormattingEventHandler(this.dgvCanBo_CellFormatting);
GanDuLieu();
DieuKhienKhiBinhThuong();
}
void NhanDuLieu()
{
string strSelect = "exec Pro_ThietBi";
MyPublics.OpenData(strSelect, dsThietBi, "ThietBi");
}
void NhanDuLieu()
{
string strSelect = "Select * From CANBO";
MyPublics.OpenData(strSelect, dsCanBo, "CANBO");
}
private void frmThietBiTheoLoai_Load(object sender, EventArgs e)
{
string strSelect = "Select MA_LOAI, TEN_LOAI From LOAITHIETBI";
MyPublics.OpenData(strSelect, dsLoaiThietBi, "LoaiThietBi");
cboLoaiThietBi.DataSource = dsLoaiThietBi.Tables["LoaiThietBi"];
cboLoaiThietBi.DisplayMember = "TEN_LOAI";
cboLoaiThietBi.ValueMember = "MA_LOAI";
strSelect = "Select MA_PHONG, MA_BM, TEN_PHONG From PHONG";
try
{
if (MyPublics.conMyConnection.State == ConnectionState.Closed)
{
MyPublics.conMyConnection.Open();
}
SqlCommand cmdCommand = new SqlCommand(strSelect, MyPublics.conMyConnection);
SqlDataReader drPhong = cmdCommand.ExecuteReader();
dsPhong.Tables.Add("Phong");
dsPhong.Tables["Phong"].Columns.Add("KHOA_CHINH");
dsPhong.Tables["Phong"].Columns.Add("TEN_PHONG");
if (drPhong.HasRows)
{
while (drPhong.Read())
{
dsPhong.Tables["Phong"].Rows.Add(drPhong.GetString(0) + "," + drPhong.GetString(1), drPhong.GetString(2));
}
}
MyPublics.conMyConnection.Close();
}
catch (Exception)
{
}
cboTenPhong.DataSource = dsPhong.Tables["Phong"];
cboTenPhong.DisplayMember = "TEN_PHONG";
cboTenPhong.ValueMember = "KHOA_CHINH";
dsTinhTrang.Tables.Add("DSTinhTrang");
dsTinhTrang.Tables["DSTinhTrang"].Columns.Add("TinhTrang");
dsTinhTrang.Tables["DSTinhTrang"].Rows.Add("Chờ thanh lý");
dsTinhTrang.Tables["DSTinhTrang"].Rows.Add("Mới");
dsTinhTrang.Tables["DSTinhTrang"].Rows.Add("Cũ");
dsTinhTrang.Tables["DSTinhTrang"].Rows.Add("Hư");
cboTinhTrang.DataSource = dsTinhTrang;
cboTinhTrang.DisplayMember = "DSTinhTrang.TinhTrang";
cboTinhTrang.ValueMember = "DSTinhTrang.TinhTrang";
txtMaThietBi.MaxLength = 15;
txtTenThietBi.MaxLength = 200;
NhanDuLieu();
dvThietBi.Table = dsThietBi.Tables["ThietBi"];
dvThietBi.RowFilter = "MA_LOAI like '" + cboLoaiThietBi.SelectedValue + "'";
dgvThietBi.DataSource = dvThietBi;
dgvThietBi.Width = 1250;
dgvThietBi.AllowUserToAddRows = false;
dgvThietBi.AllowUserToDeleteRows = false;
dgvThietBi.Columns[0].Width = 130;
dgvThietBi.Columns[0].HeaderText = "Mã số";
dgvThietBi.Columns[1].Width = 115;
dgvThietBi.Columns[1].HeaderText = "Mã Loại";
dgvThietBi.Columns[2].Width = 120;
dgvThietBi.Columns[2].HeaderText = "Tình Trạng";
dgvThietBi.Columns[3].Width = 100;
dgvThietBi.Columns[3].HeaderText = "TH Bảo Hành";
dgvThietBi.Columns[4].Width = 100;
dgvThietBi.Columns[4].HeaderText = "TL Hao Mòn";
dgvThietBi.Columns[5].Width = 100;
dgvThietBi.Columns[5].HeaderText = "Giá trị";
dgvThietBi.Columns[6].Width = 250;
dgvThietBi.Columns[6].HeaderText = "Tên Thiết Bị";
dgvThietBi.Columns[7].Width = 100;
dgvThietBi.Columns[7].HeaderText = "Mã Phòng";
dgvThietBi.Columns[8].Width = 100;
dgvThietBi.Columns[8].HeaderText = "Mã Bộ Môn";
dgvThietBi.Columns[9].Width = 170;
dgvThietBi.Columns[9].HeaderText = "Ngày Đặt";
dgvThietBi.EditMode = DataGridViewEditMode.EditProgrammatically;
GanDuLieu();
DieuKhienKhiBinhThuong();
}
void NhanDuLieu()
{
string strSelect = "Select * From THIETBI";
MyPublics.OpenData(strSelect, dsThietBi, "ThietBi");
}
void NhanDuLieu()
{
string strSelect = "Select * From PHONG";
MyPublics.OpenData(strSelect, dsPhong, "PHONG");
}
