private void btnSave_Click(object sender, EventArgs e) { if (txtMucluong.Text == "") { MessageBox.Show("Mời bạn nhập mức lương!", "Thông báo"); } else { luong = new BusinessLayer.LuongBns(); luong.MucLuong = Convert.ToSingle(txtMucluong.Text.ToString()); MessageBox.Show("Mời bạn nhập mức lương!", "Thông báo"); luong.Insert(); dt = luong.Select(); dgrvLuong.DataSource = dt.DefaultView; txtMucluong.Enabled = false; btnAdd.Enabled = true; btnEdit.Enabled = true; btnDelete.Enabled = true; btnSave.Enabled = false; btnCancel.Enabled = false; tv = ""; } }
// public void fillDataControl(Control ctrl) { foreach (Control ctrlChild in ctrl.Controls) { if (ctrlChild.Name.Equals("cbbChucvu")) { chucvu = new BusinessLayer.ChucVuBsn(); da = chucvu.GetDataAdapter(); da.Fill(ds, "ChucVu"); cbbChucvu.DataSource = ds; cbbChucvu.DisplayMember = "ChucVu.TenCV"; cbbChucvu.ValueMember = "ChucVu.MaCv"; } if (ctrlChild.Name.Equals("cbbMucluong")) { luong = new BusinessLayer.LuongBns(); da = luong.GetDataAdapter(); da.Fill(ds, "Luong"); cbbMucluong.DataSource = ds; cbbMucluong.DisplayMember = "Luong.Luong"; cbbMucluong.ValueMember = "Luong.MaLuong"; } if (ctrlChild.Name.Equals("cbbTrinhdo")) { trinhdo = new BusinessLayer.TrinhDoBsn(); da = trinhdo.GetDataAdapter(); da.Fill(ds, "TrinhDo"); cbbTrinhdo.DataSource = ds; cbbTrinhdo.DisplayMember = "TrinhDo.LoaiTrinhDo"; cbbTrinhdo.ValueMember = "TrinhDo.MaTrinhDo"; } if (ctrlChild.Name.Equals("cmbChuyenMon")) { chuyenmon = new BusinessLayer.ChuyenMonBsn(); da = chuyenmon.GetDataAdapter(); da.Fill(ds, "ChuyenMon"); cmbChuyenMon.DataSource = ds; cmbChuyenMon.DisplayMember = "ChuyenMon.TenChuyenMon"; cmbChuyenMon.ValueMember = "ChuyenMon.MaChuyenMon"; } if (ctrlChild.Name.Equals("cbbMaphong")) { phong = new BusinessLayer.PhongBsn(); da = phong.GetDataAdapter(); da.Fill(ds, "Phong"); cbbMaphong.DataSource = ds; cbbMaphong.DisplayMember = "Phong.TenPhong"; cbbMaphong.ValueMember = "Phong.MaPhong"; } if (ctrlChild.Name.Equals("cbbGioitinh")) { cbbGioitinh.DataSource = new BindingSource(gioitinh, null); cbbGioitinh.DisplayMember = "key"; cbbGioitinh.ValueMember = "value"; } fillDataControl(ctrlChild); } }
private void Luong_Load(object sender, EventArgs e) { txtMaluong.Enabled = false; txtMucluong.Enabled = false; btnSave.Enabled = false; btnCancel.Enabled = false; // luong = new BusinessLayer.LuongBns(); dt = luong.Select(); fillControls(dt, 0); dgrvLuong.DataSource = dt.DefaultView; this.Cursor = Cursors.Default; }
// public void Delete(BusinessLayer.LuongBns luong) { try { cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "DELETE FROM " + this.tableName + " WHERE MaLuong=" + luong.MaLuong; dt = new DataTable(); dt = GetData(cmd); } catch (Exception) { MessageBox.Show("Dữ liệu đang được sử dụng"); } finally { closeConnect(); } }
// public void Update(BusinessLayer.LuongBns luong) { try { cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE " + this.tableName + " SET MaLuong= " + luong.MaLuong + ", luong= " + luong.MucLuong; dt = new DataTable(); dt = GetData(cmd); MessageBox.Show("Sửa thành công"); } catch (Exception) { MessageBox.Show("Sửa thất bại"); } finally { closeConnect(); } }
// public void Insert(BusinessLayer.LuongBns luong) { try { cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO " + this.tableName + "(" + this.fieldList + ") values ('" + luong.MucLuong.ToString() + "')"; dt = new DataTable(); dt = GetData(cmd); MessageBox.Show("thêm mới thành công", "Thông báo"); //conn.Close(); } catch (Exception) { MessageBox.Show("Bị trùng khóa, thêm mới thất bại", "Thông báo"); } finally { closeConnect(); // conn.Close(); } }
// public void fillDataControl(Control ctrl) { foreach (Control ctrlChild in ctrl.Controls) { if (ctrlChild.Name.Equals("cbbChucvu")) { chucvu = new BusinessLayer.ChucVuBsn(); da = chucvu.GetDataAdapter(); da.Fill(ds, "ChucVu"); cbbChucvu.DataSource = ds; cbbChucvu.DisplayMember = "ChucVu.TenCV"; cbbChucvu.ValueMember = "ChucVu.MaCv"; } if (ctrlChild.Name.Equals("cbbMucluong")) { luong = new BusinessLayer.LuongBns(); da = luong.GetDataAdapter(); da.Fill(ds, "Luong"); cbbMucluong.DataSource = ds; cbbMucluong.DisplayMember = "Luong.Luong"; cbbMucluong.ValueMember = "Luong.MaLuong"; } if (ctrlChild.Name.Equals("cbbTrinhdo")) { trinhdo = new BusinessLayer.TrinhDoBsn() ; da = trinhdo.GetDataAdapter(); da.Fill(ds, "TrinhDo"); cbbTrinhdo.DataSource = ds; cbbTrinhdo.DisplayMember = "TrinhDo.LoaiTrinhDo"; cbbTrinhdo.ValueMember = "TrinhDo.MaTrinhDo"; } if (ctrlChild.Name.Equals("cmbChuyenMon")) { chuyenmon = new BusinessLayer.ChuyenMonBsn() ; da = chuyenmon.GetDataAdapter(); da.Fill(ds, "ChuyenMon"); cmbChuyenMon.DataSource = ds; cmbChuyenMon.DisplayMember = "ChuyenMon.TenChuyenMon"; cmbChuyenMon.ValueMember = "ChuyenMon.MaChuyenMon"; } if (ctrlChild.Name.Equals("cbbMaphong")) { phong = new BusinessLayer.PhongBsn(); da = phong.GetDataAdapter(); da.Fill(ds, "Phong"); cbbMaphong.DataSource = ds; cbbMaphong.DisplayMember = "Phong.TenPhong"; cbbMaphong.ValueMember = "Phong.MaPhong"; } if (ctrlChild.Name.Equals("cbbGioitinh")) { cbbGioitinh.DataSource = new BindingSource(gioitinh, null); cbbGioitinh.DisplayMember = "key"; cbbGioitinh.ValueMember = "value"; } fillDataControl(ctrlChild); } }