//Sửa public void sua(EC_tb_Chamcong key) { string sql = (@"UPDATE dbo.CHAMCONG SET NghiCoPhep =N'" + key.NGHICOPHEP + "' where MaChamCong ='" + key.MACHAMCONG + "'"); cn.ExcuteNonQuery(sql); }
// Xóa public void xoa(EC_tb_Chamcong key) { cn.ExcuteNonQuery("DELETE FROM dbo.CHAMCONG WHERE [MaChamCong] = '" + key.MACHAMCONG + "'"); }
// Thêm mới public void themmoi(EC_tb_Chamcong key) { cn.ExcuteNonQuery(@"INSERT INTO dbo.CHAMCONG (MaChamCong,MaNhanVien,NgayChamCong,NghiCoPhep) VALUES ('" + key.MACHAMCONG + "','" + key.MANHANVIEN + "','" + key.NGAYCHAMCONG + "',N'" + key.NGHICOPHEP + "')"); }
//Sửa public void sua(EC_tb_Chamcong key) { val.sua(key); MessageBox.Show("Đã Sửa Thành Công", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Information); }
// Xóa public void xoa(EC_tb_Chamcong key) { val.xoa(key); }
// Thêm mới public void themmoi(EC_tb_Chamcong key) { val.themmoi(key); MessageBox.Show("Đã Lưu Thành Công", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Information); }