private CoQuan_DTO BiendoiCQ() { CoQuan_DTO cq = new CoQuan_DTO(); cq.Ma_cq = txtMacq.Text; cq.Ten_cq = cboTencq.Text; cq.Dia_chi = txtDchicq.Text; cq.Sdt = txtSdt.Text; cq.Fax = txtFax.Text; return(cq); }
// lấy dữ liệu mã cơ quan public string LayMacq(CoQuan_DTO cq) { string sql = "SELECT ma_cq FROM coquan WHERE ten_cq = N'" + cq.Ten_cq + "' AND dia_chi = N'" + cq.Dia_chi + "' AND sdt = '" + cq.Sdt + "' AND fax = '" + cq.Fax + "'"; return(KetNoiDB.Khoa.LayGiaTrị(sql)); }
// sửa dữ liệu cơ quan public void SuaCQ(CoQuan_DTO cq) { string sql = "UPDATE coquan SET ten_cq = N'" + cq.Ten_cq + "', dia_chi = N'" + cq.Dia_chi + "', sdt = '" + cq.Sdt + "', fax = '" + cq.Fax + "' WHERE ma_cq = '" + cq.Ma_cq + "'"; KetNoiDB.Khoa.ChayLenh(sql); }
// thêm dữ liệu cơ quan public void ThemCQ(CoQuan_DTO cq) { string sql = "INSERT INTO coquan (ten_cq, dia_chi, sdt, fax) VALUES(N'" + cq.Ten_cq + "',N'" + cq.Dia_chi + "','" + cq.Sdt + "','" + cq.Fax + "')"; KetNoiDB.Khoa.ChayLenh(sql); }