private void f_insert()
{
try
{
DMNV_Oracle NV_Oracle = new DMNV_Oracle();
CDMNV nv = new CDMNV();
Capid_Oracle Id_oracle = new Capid_Oracle();
string s_id = Id_oracle.f_get("DMNV");
Id_oracle.f_update_one("DMNV");
nv.Ma = int.Parse(s_id).ToString("D4");
txtID.Text = nv.Ma;
nv.Hoten = txtHoTen.Text;
nv.Ngaysinh = dngaysinh.Value;
nv.Phai = cbPhai.SelectedIndex.ToString();
nv.Dienthoai = txtDienThoai.Text;
nv.Diachi = txtDiaChi.Text;
nv.Makp = cbDanhMucKP.SelectedValue.ToString();
nv.Nhom = cbNhom.SelectedValue.ToString();
nv.Chuyenkhoa = cbchuyenkhoa.SelectedValue.ToString();
nv.Ngonngu = txtNgoaiNgu.Text;
nv.Bangcap = txtbangcap.Text;
nv.Dtnuocngoai = txtdtnuocngoai.Text;
nv.Kinhnghiem = txtkinhnghiem.Text;
nv.Trinhdo = cbtrinhdo.SelectedValue.ToString();
NV_Oracle.f_insert(nv);
}
catch { }
}
private void f_init_addmodul()
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DMNV_Oracle nv_Oracle = new DMNV_Oracle();
DataTable dtdm_dichvu = nv_Oracle.f_get("");
listicd10.DataSource = dtdm_dichvu;
listicd10.DisplayMember = "HOTEN";
listicd10.ValueMember = "MA";
/*DataTable dtdm_khoaphong = dataOracle.d_getDMKhoaPhong();
* cbDanhMucKP.DataSource = dtdm_khoaphong;
* cbDanhMucKP.DisplayMember = "TEN";
* cbDanhMucKP.ValueMember = "ID";
* cbDanhMucKP.SelectedIndex = 0;*/
DataTable dtdm_dt_loai = dataOracle.d_getDMDT_LOAI(S_idnhom);
cbLoai.DataSource = dtdm_dt_loai;
cbLoai.DisplayMember = "TEN";
cbLoai.ValueMember = "ID";
cbLoai.SelectedIndex = 0;
}
private void f_load()
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DMNV_Oracle nv_Oracle = new DMNV_Oracle();
DataTable dtdm_dichvu = nv_Oracle.f_get("");
dgridChiTiet.DataSource = dtdm_dichvu;
}
private void f_load()
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DMNV_Oracle nv_Oracle = new DMNV_Oracle();
DataTable dtdm_dichvu = dmbd_oracle.getBYT_d_dmbd("");
dgridChiTiet.DataSource = dtdm_dichvu;
}
private void f_update()
{
try{
DMNV_Oracle NV_Oracle = new DMNV_Oracle();
CDMNV nv = new CDMNV();
nv.Ma = txtID.Text;
nv.Hoten = txtHoTen.Text;
nv.Ngaysinh = dngaysinh.Value;
nv.Phai = cbPhai.SelectedIndex.ToString();
nv.Dienthoai = txtDienThoai.Text;
nv.Diachi = txtDiaChi.Text;
nv.Makp = cbDanhMucKP.SelectedValue.ToString();
nv.Nhom = cbNhom.SelectedValue.ToString();
nv.Chuyenkhoa = cbchuyenkhoa.SelectedValue.ToString();
nv.Ngonngu = txtNgoaiNgu.Text;
nv.Bangcap = txtbangcap.Text;
nv.Dtnuocngoai = txtdtnuocngoai.Text;
nv.Kinhnghiem = txtkinhnghiem.Text;
nv.Trinhdo = cbtrinhdo.SelectedValue.ToString();
NV_Oracle.f_update(nv);
}catch {}
}
private void f_loadct()
{
try {
CDanhMucOracle dataOracle = new CDanhMucOracle();
DMNV_Oracle nv_Oracle = new DMNV_Oracle();
DataTable dtdm_chitiet = nv_Oracle.f_getbyid(txtID.Text);
txtHoTen.Text = dtdm_chitiet.Rows[0]["HOTEN"].ToString();
txtDiaChi.Text = dtdm_chitiet.Rows[0]["DIACHI"].ToString();
txtDienThoai.Text = dtdm_chitiet.Rows[0]["DIENTHOAI"].ToString();
dngaysinh.Value = m_format.DateTime_parse(dtdm_chitiet.Rows[0]["NGAYSINH"].ToString());
txtNgoaiNgu.Text = dtdm_chitiet.Rows[0]["NGONNGU"].ToString();
setList(cbchuyenkhoa, dtdm_chitiet.Rows[0]["CHUYENKHOA"].ToString());
txtbangcap.Text = dtdm_chitiet.Rows[0]["BANGCAP"].ToString();
txtdtnuocngoai.Text = dtdm_chitiet.Rows[0]["DTNUOCNGOAI"].ToString();
txtkinhnghiem.Text = dtdm_chitiet.Rows[0]["KINHNGHIEM"].ToString();
setList(cbtrinhdo, dtdm_chitiet.Rows[0]["TRINHDO"].ToString());
setList(cbDanhMucKP, dtdm_chitiet.Rows[0]["MAKP"].ToString());
setList(cbNhom, dtdm_chitiet.Rows[0]["MANHOM"].ToString());
string s_phai = dtdm_chitiet.Rows[0]["PHAI"].ToString();
cbPhai.SelectedIndex = int.Parse(s_phai);
}
catch { }
}