Esempio n. 1
0
        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 { }
        }
Esempio n. 2
0
        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;
        }
Esempio n. 3
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;
        }
Esempio n. 4
0
        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;
        }
Esempio n. 5
0
        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 {}
        }
Esempio n. 6
0
        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 { }
        }