public void Cap_Nhat_Trang_Thai(TrangThai_MODEL TT) { string A = Convert.ToString(TT.TRANG_THAI1); string sql = "UPDATE TRANG_THAI SET TRANG_THAI='" + A + "' WHERE TEN_TAI_KHOAN='" + TT.TEN_TAI_KHOAN1 + "' AND MA_CHUC_NANG='" + TT.MA_CHUC_NANG1 + "'"; K.Thao_Tac_Du_Lieu(sql); }
public void Them_Trang_Thai(TrangThai_MODEL TT) { string A = Convert.ToString(TT.TRANG_THAI1); string sql = "INSERT INTO TRANG_THAI VALUES('" + TT.TEN_TAI_KHOAN1 + "','" + TT.MA_CHUC_NANG1 + "', '" + A + "' )"; K.Thao_Tac_Du_Lieu(sql); }