public void sua(EC_tb_Que q) { string sql = (@"UPDATE tb_Que SET tenque =N'" + q.TENQUE + "' where maque =N'" + q.MAQUE + "'"); cn.ExcuteNonQuery(sql); }
public void themoilg(EC_tb_Que lg) { if (!lgsql.Equals(lg.MAQUE)) { 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 xoalg(EC_tb_Que lg) { lgsql.xoa(lg); }
public void sualg(EC_tb_Que lg) { lgsql.sua(lg); }
public void xoa(EC_tb_Que q) { cn.ExcuteNonQuery("DELETE FROM [tb_que] WHERE [maque] = N'" + q.MAQUE + "'"); }
public void themmoi(EC_tb_Que q) { cn.ExcuteNonQuery(@"INSERT INTO tb_Que (maque, tenque) VALUES (N'" + q.MAQUE + "',N'" + q.TENQUE + "')"); }