public void sua(EC_tb_Dichvusocuutaicho key) { string sql = (@"UPDATE dbo.DICHVUSOCUUTAICHO SET TenLoaiDV =N'" + key.TENLOAIDV + "' where MaLoaiDVSoCuu ='" + key.MALOAIDVSOCUU + "'"); cn.ExcuteNonQuery(sql); }
public void themoi(EC_tb_Dichvusocuutaicho key) { if (!keysql.kiemtra(key.MALOAIDVSOCUU)) { keysql.themmoi(key); MessageBox.Show("Đã Lưu Thành Công", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public void xoa(EC_tb_Dichvusocuutaicho key) { keysql.xoa(key); }
public void sua(EC_tb_Dichvusocuutaicho key) { keysql.sua(key); MessageBox.Show("Đã Sửa Thành Công", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public void xoa(EC_tb_Dichvusocuutaicho key) { cn.ExcuteNonQuery("DELETE FROM dbo.DICHVUSOCUUTAICHO WHERE [MaLoaiDVSoCuu] = '" + key.MALOAIDVSOCUU + "'"); }
public void themmoi(EC_tb_Dichvusocuutaicho key) { cn.ExcuteNonQuery(@"INSERT INTO dbo.DICHVUSOCUUTAICHO (MaLoaiDVSoCuu,TenLoaiDV) VALUES ('" + key.MALOAIDVSOCUU + "',N'" + key.TENLOAIDV + "')"); }