public void sua(EC_tb_Loai q) { string sql = (@"UPDATE tb_Loai SET tenloai =N'" + q.TENLOAI + "' where maloai =N'" + q.MALOAI + "'"); cn.ExcuteNonQuery(sql); }
public void themoilg(EC_tb_Loai lg) { if (!lgsql.Equals(lg.MALOAI)) { lgsql.themmoi(lg); } 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_Loai q) { cn.ExcuteNonQuery("DELETE FROM [tb_Loai] WHERE [maloai] = N'" + q.MALOAI + "'"); }
public void themmoi(EC_tb_Loai q) { cn.ExcuteNonQuery(@"INSERT INTO tb_Loai (maloai, tenloai) VALUES (N'" + q.MALOAI + "',N'" + q.TENLOAI + "')"); }
public void xoalg(EC_tb_Loai lg) { lgsql.xoa(lg); }
public void sualg(EC_tb_Loai lg) { lgsql.sua(lg); }