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);
}
