private void us_object2grid(US_DM_NHAN_SU i_us, int i_grid_row)
        {
            DataRow v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData;

            i_us.Me2DataRow(v_dr);
            m_obj_trans.DataRow2GridRow(v_dr, i_grid_row);
        }
        private void delete_dm_nhan_su()
        {
            if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg))
            {
                return;
            }
            if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row))
            {
                return;
            }
            if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted)
            {
                return;
            }
            US_DM_NHAN_SU v_us = new US_DM_NHAN_SU();

            grid2us_object(v_us, m_fg.Row);
            try
            {
                v_us.BeginTransaction();
                v_us.Delete();
                v_us.CommitTransaction();
                m_fg.Rows.Remove(m_fg.Row);
            }
            catch (Exception v_e)
            {
                v_us.Rollback();
                CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
                                                                              new CDBClientDBExceptionInterpret());
                v_objErrHandler.showErrorMessage();
            }
        }
        private void save_data()
        {
            var v_count_left                       = m_lbox_nhan_vien_left.Items.Count;
            var v_count_right                      = m_lbox_nhan_vien_right.Items.Count;
            var v_id_don_vi_left                   = m_cbo_don_vi_left.SelectedValue;
            var v_id_don_vi_right                  = m_cbo_don_vi_right.SelectedValue;
            var v_us_dm_du_lieu_nhan_vien          = new US_V_DM_DU_LIEU_NHAN_VIEN();
            var v_ds_dm_du_lieu_nhan_vien          = new DS_V_DM_DU_LIEU_NHAN_VIEN();
            var v_us_dm_nhan_su                    = new US_DM_NHAN_SU();
            var v_ds_dm_nhan_su                    = new DS_DM_NHAN_SU();
            var v_danh_sach_nhan_vien_left_new     = new collection(1);
            var v_danh_sach_nhan_vien_left_old     = new collection(1);
            var v_danh_sach_nhan_vien_left_insert  = new collection(1);
            var v_danh_sach_nhan_vien_left_delete  = new collection(1);
            var v_danh_sach_nhan_vien_right_new    = new collection(1);
            var v_danh_sach_nhan_vien_right_old    = new collection(1);
            var v_danh_sach_nhan_vien_right_insert = new collection(1);
            var v_danh_sach_nhan_vien_right_delete = new collection(1);

            v_us_dm_nhan_su.FillDataset(v_ds_dm_nhan_su);
            v_us_dm_du_lieu_nhan_vien.FillDatasetByIdDonVi(v_ds_dm_du_lieu_nhan_vien, CIPConvert.ToDecimal(v_id_don_vi_left));
            ////-- Lưu nhân sự đơn vị LEFT
            //+ Danh sách nhân viên mới trong ListBox
            if (v_count_left > 0)
            {
                v_danh_sach_nhan_vien_left_new = new collection(v_count_left);
                foreach (var v_item in m_lbox_nhan_vien_left.Items)
                {
                    var v_ma_nhan_vien = get_ma_nhan_vien(v_item.ToString());
                    var v_nhan_vien    = (DS_DM_NHAN_SU.DM_NHAN_SURow)(v_ds_dm_nhan_su.DM_NHAN_SU.Select("MA_NV = " + v_ma_nhan_vien)[0]);
                    v_danh_sach_nhan_vien_left_new.insert(v_nhan_vien.ID.ToString());
                }

                //+ Danh sách nhân viên cũ trước khi thay đổi ListBox
                var v_count_nhan_vien = v_ds_dm_du_lieu_nhan_vien.V_DM_DU_LIEU_NHAN_VIEN.Count;
                if (v_count_nhan_vien > 0)
                {
                    var v_nhan_vien =
                        (v_ds_dm_du_lieu_nhan_vien.V_DM_DU_LIEU_NHAN_VIEN.Rows);
                    v_danh_sach_nhan_vien_left_old = new collection(v_count_nhan_vien);
                    foreach (DS_V_DM_DU_LIEU_NHAN_VIEN.V_DM_DU_LIEU_NHAN_VIENRow v_item in v_nhan_vien)
                    {
                        v_danh_sach_nhan_vien_left_old.insert(v_item.ID.ToString());
                    }
                }
                //+ Danh sách nhân viên thêm mới
                v_danh_sach_nhan_vien_left_insert =
                    new collection(v_danh_sach_nhan_vien_left_new.countInANotInB(v_danh_sach_nhan_vien_left_old));
                v_danh_sach_nhan_vien_left_insert =
                    v_danh_sach_nhan_vien_left_new.InANotInB(v_danh_sach_nhan_vien_left_old);
                for (int i = 0; i < v_danh_sach_nhan_vien_left_insert.getIndex(); i++)
                {
                    decimal v_id = CIPConvert.ToDecimal(v_danh_sach_nhan_vien_left_insert.s[i]);
                    v_us_dm_du_lieu_nhan_vien.FillDatasetByIdDonVi(v_ds_dm_du_lieu_nhan_vien, v_id);
                }
            }
            //+ Danh sách nhân viên sẽ bị xoá
            v_danh_sach_nhan_vien_left_delete = v_danh_sach_nhan_vien_left_old.InANotInB(v_danh_sach_nhan_vien_left_new);
        }
 public void display_for_insert(US_DM_NHAN_SU ip_m_us_dm_nhan_su)
 {
     m_e_form_mode   = DataEntryFormMode.InsertDataState;
     m_e_file_mode   = DataEntryFileMode.UploadFile;
     m_us_dm_nhan_su = ip_m_us_dm_nhan_su;
     view_info_Nhan_Su();
     this.ShowDialog();
 }
        private void grid2us_object(US_DM_NHAN_SU i_us, int i_grid_row)
        {
            DataRow v_dr;

            v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData;
            m_obj_trans.GridRow2DataRow(i_grid_row, v_dr);
            i_us.DataRow2Me(v_dr);
        }
Exemple #6
0
        private void load_data(US_DM_NHAN_SU ip_us_dm_nhan_su)
        {
            US_V_GD_QUA_TRINH_LAM_VIEC v_us = new US_V_GD_QUA_TRINH_LAM_VIEC();

            v_us.DataRow2Me((DataRow)m_grv_qua_trinh_lam_viec.Rows[1].UserData);

            m_txt_tim_kiem.Text = ip_us_dm_nhan_su.strMA_NV + ", " + ip_us_dm_nhan_su.strHO_DEM + " " + ip_us_dm_nhan_su.strTEN;

            load_data_2_grid(ip_us_dm_nhan_su);
        }
        private void xuat_word()
        {
            if (m_us.dcID == -1)
            {
                BaseMessages.MsgBox_Infor("Phải lưu thông tin hợp đồng trước khi in.");
                return;
            }
            US_GD_HOP_DONG   v_us_gd_hop_dong = new US_GD_HOP_DONG(m_us.dcID);
            US_DM_NHAN_SU    v_us_dm_nhan_su  = new US_DM_NHAN_SU(v_us_gd_hop_dong.dcID_NHAN_SU);
            US_CM_DM_TU_DIEN v_us_tu_dien     = new US_CM_DM_TU_DIEN(v_us_gd_hop_dong.dcID_LOAI_HOP_DONG);

            m_sfd_in_hop_dong.Filter = "(*.doc)|*.doc|(*.docx)|*.docx";
            m_sfd_in_hop_dong.Title  = "Lưu Hợp Đồng Lao Động";
            DialogResult result = m_sfd_in_hop_dong.ShowDialog();

            if (result == DialogResult.OK)
            {
                CWordReport v_obj_word = new CWordReport("THR_Hopdonglaodong_KTH_v2_TU.docx", m_sfd_in_hop_dong.FileName);

                v_obj_word.AddFindAndReplace("<HO_TEN>", v_us_dm_nhan_su.strHO_DEM + " " + v_us_dm_nhan_su.strTEN);
                if (v_us_dm_nhan_su.datNGAY_SINH > DateTime.Parse("1/1/1900") && v_us_dm_nhan_su.datNGAY_SINH != null)
                {
                    v_obj_word.AddFindAndReplace("<NGAY_SINH>", v_us_dm_nhan_su.datNGAY_SINH.ToShortDateString());
                }
                else
                {
                    v_obj_word.AddFindAndReplace("<NGAY_SINH>", "");
                }
                v_obj_word.AddFindAndReplace("<CHO_O>", v_us_dm_nhan_su.strCHO_O);
                v_obj_word.AddFindAndReplace("<CMTND>", v_us_dm_nhan_su.strCMND);
                v_obj_word.AddFindAndReplace("<NGAY_CAP>", v_us_dm_nhan_su.datNGAY_CAP_CMND.ToShortDateString());
                v_obj_word.AddFindAndReplace("<NOI_CAP>", v_us_dm_nhan_su.strNOI_CAP_CMND);
                v_obj_word.AddFindAndReplace("<MOBILE>", v_us_dm_nhan_su.strDI_DONG);
                v_obj_word.AddFindAndReplace("<LOAI_HOP_DONG>", v_us_tu_dien.strTEN);
                v_obj_word.AddFindAndReplace("<NGAY_KY>", v_us_gd_hop_dong.datNGAY_KY_HOP_DONG.ToShortDateString());
                v_obj_word.AddFindAndReplace("<CHUYEN_NGANH>", v_us_dm_nhan_su.strCHUYEN_NGANH);
                v_obj_word.AddFindAndReplace("<MA_PHONG>", "...");
                v_obj_word.AddFindAndReplace("<MA_BAN>", "...");
                v_obj_word.AddFindAndReplace("<MA_NHAN_VIEN>", v_us_dm_nhan_su.strMA_NV);

                if (v_us_gd_hop_dong.datNGAY_KY_HOP_DONG > DateTime.Parse("1/1/1900") && v_us_gd_hop_dong.datNGAY_KY_HOP_DONG != null)
                {
                    v_obj_word.AddFindAndReplace("<NGAY>", v_us_gd_hop_dong.datNGAY_KY_HOP_DONG.Day.ToString());
                    v_obj_word.AddFindAndReplace("<THANG>", v_us_gd_hop_dong.datNGAY_KY_HOP_DONG.Month.ToString());
                    v_obj_word.AddFindAndReplace("<NAM>", v_us_gd_hop_dong.datNGAY_KY_HOP_DONG.Year.ToString());
                }
                else
                {
                    v_obj_word.AddFindAndReplace("<NGAY>", "...");
                    v_obj_word.AddFindAndReplace("<THANG>", "...");
                    v_obj_word.AddFindAndReplace("<NAM>", "...");
                    v_obj_word.Export2Word("", false);
                }
            }
        }
Exemple #8
0
 private void load_info_staff(US_DM_NHAN_SU ip_us)
 {
     if (ip_us.dcID == -1)
     {
         return;
     }
     m_lbl_ma_nhan_vien.Text = ip_us.strMA_NV;
     m_lbl_ho_va_ten.Text    = ip_us.strHO_DEM + ' ' + ip_us.strTEN;
     m_lbl_ngay_sinh.Text    = ip_us.datNGAY_SINH.ToShortDateString();
     m_lbl_dia_chi.Text      = ip_us.strCHO_O;
 }
Exemple #9
0
        private void load_data_2_custom_source_ma_nhan_vien()
        {
            US_DM_NHAN_SU v_us = new US_DM_NHAN_SU();
            DS_DM_NHAN_SU v_ds = new DS_DM_NHAN_SU();

            v_us.FillDataset(v_ds);
            for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
            {
                DataRow dr = v_ds.Tables[0].Rows[i];
                m_txt_ma_ns.AutoCompleteCustomSource.Add(dr["MA_NV"].ToString());
            }
        }
Exemple #10
0
 public void display_for_insert(US_DM_NHAN_SU ip_us_dm_nhan_su)
 {
     // insert 1 nhân viên từ f201
     m_e_form_mode = DataEntryFormMode.InsertDataState;
     m_e_file_mode = DataEntryFileMode.UploadFile;
     load_data_2_control();
     m_txt_ma_ns.Text        = ip_us_dm_nhan_su.strMA_NV;
     m_txt_ma_ns.BackColor   = SystemColors.Info;
     m_txt_ma_ns.ReadOnly    = true;
     m_txt_ma_du_an.ReadOnly = false;
     m_txt_ma_du_an.Enabled  = true;
     this.ShowDialog();
 }
        private void us_object_2_form(US_GD_HOP_DONG ip_us_gd_hop_dong)
        {
            m_str_id_hop_dong_old = ip_us_gd_hop_dong.dcID;

            m_us.dcID = ip_us_gd_hop_dong.dcID;
            m_txt_ma_hop_dong.Text       = ip_us_gd_hop_dong.strMA_HOP_DONG;
            m_txt_nguoi_ky.Text          = ip_us_gd_hop_dong.strNGUOI_KY;
            m_txt_chuc_vu_nguoi_ky.Text  = ip_us_gd_hop_dong.strCHUC_VU_NGUOI_KY;
            m_dat_ngay_co_hieu_luc.Value = ip_us_gd_hop_dong.datNGAY_CO_HIEU_LUC;
            m_dat_ngay_ky_hop_dong.Value = ip_us_gd_hop_dong.datNGAY_KY_HOP_DONG;

            US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU(ip_us_gd_hop_dong.dcID_NHAN_SU);

            m_lbl_ma_nhan_vien.Text = v_us_dm_nhan_su.strMA_NV;
            m_lbl_ho_va_ten.Text    = v_us_dm_nhan_su.strHO_DEM + " " + v_us_dm_nhan_su.strTEN;

            // DucVT
            m_lbl_email_co_quan.Text = v_us_dm_nhan_su.strEMAIL_CQ;

            // Lấy chức vụ bằng Id nhân sự
            DS_V_GD_QUA_TRINH_LAM_VIEC v_ds_gd_qua_trinh_lam_viec = new DS_V_GD_QUA_TRINH_LAM_VIEC();
            US_V_GD_QUA_TRINH_LAM_VIEC v_us_gd_qua_trinh_lam_viec = new US_V_GD_QUA_TRINH_LAM_VIEC();

            v_us_gd_qua_trinh_lam_viec.FillDataSet_Now_By_Ma_NV_Id_PN(v_ds_gd_qua_trinh_lam_viec, v_us_dm_nhan_su.strMA_NV, CAppContext_201.getCurrentIDPhapnhan());

            if (v_ds_gd_qua_trinh_lam_viec.V_GD_QUA_TRINH_LAM_VIEC.Rows.Count > 0)
            {
                m_lbl_ma_chuc_vu.Text = v_ds_gd_qua_trinh_lam_viec.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.TEN_CV].ToString();
                m_lbl_ma_don_vi.Text  = v_ds_gd_qua_trinh_lam_viec.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.TEN_DON_VI].ToString();
            }
            // ~DucVT

            m_cbo_loai_hop_dong.SelectedValue = ip_us_gd_hop_dong.dcID_LOAI_HOP_DONG;
            m_cbo_trang_thai.SelectedIndex    = (ip_us_gd_hop_dong.strTRANG_THAI_HOP_DONG.Equals("Y")) ? 0 : 1;
            m_lbl_phap_nhan.Text = new US_DM_PHAP_NHAN(ip_us_gd_hop_dong.dcID_PHAP_NHAN).strTEN_PHAP_NHAN;

            if (ip_us_gd_hop_dong.datNGAY_HET_HAN.Equals(DateTime.Parse("1/1/1900 12:00:00 AM")))
            {
                m_dat_ngay_het_han.Checked = false;
            }
            else
            {
                m_dat_ngay_het_han.Value   = ip_us_gd_hop_dong.datNGAY_HET_HAN;
                m_dat_ngay_het_han.Checked = true;
            }
            if (ip_us_gd_hop_dong.strLINK == "")
            {
                return;
            }
            m_lbl_file_name.Text = ip_us_gd_hop_dong.strLINK;
        }
Exemple #12
0
        private void chon_nhan_su()
        {
            DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
            US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU();

            v_us_dm_nhan_su.FillDataset_search_by_ma_nv(v_ds_dm_nhan_su, m_txt_ma_nv.Text.Trim());
            if (v_ds_dm_nhan_su.Tables[0].Rows.Count == 0)
            {
                return;
            }

            m_txt_ho_ten.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["HO_DEM"] + " " +
                                v_ds_dm_nhan_su.Tables[0].Rows[0]["TEN"];
        }
Exemple #13
0
        private void load_custom_source_2_m_txt_tim_kiem()
        {
            DS_DM_NHAN_SU v_ds = new DS_DM_NHAN_SU();
            US_DM_NHAN_SU v_us = new US_DM_NHAN_SU();

            v_us.FillDataset(v_ds);
            int count = v_ds.Tables["DM_NHAN_SU"].Rows.Count;
            AutoCompleteStringCollection v_acsc_search = new AutoCompleteStringCollection();

            foreach (DataRow dr in v_ds.DM_NHAN_SU)
            {
                v_acsc_search.Add(dr[DM_NHAN_SU.MA_NV].ToString());
            }
            m_txt_ma_nv.AutoCompleteCustomSource = v_acsc_search;
        }
Exemple #14
0
        private void load_data_2_grid(US_DM_NHAN_SU ip_us_dm_nhan_su)
        {
            m_ds_qua_trinh_lam_viec = new DS_V_GD_QUA_TRINH_LAM_VIEC();
            m_us_qua_trinh_lam_viec.FillDatasetByManhanvien(m_ds_qua_trinh_lam_viec, ip_us_dm_nhan_su.strMA_NV, CIPConvert.ToDatetime("01/01/1800"), DateTime.Now);
            m_grv_qua_trinh_lam_viec.Redraw = false;
            m_obj_trans = get_trans_object(m_grv_qua_trinh_lam_viec);

            CGridUtils.Dataset2C1Grid(m_ds_qua_trinh_lam_viec, m_grv_qua_trinh_lam_viec, m_obj_trans);
            m_grv_qua_trinh_lam_viec.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.None // chỗ này dùng hàm count tức là để đếm, có thể dùng các hàm khác thay thế
                                              , 0
                                              , (int)e_col_Number.MA_NV            // chỗ này là tên trường mà mình nhóm
                                              , (int)e_col_Number.TEN_CV           // chỗ này là tên trường mà mình Count
                                              , "{0}"
                                              );
            m_grv_qua_trinh_lam_viec.Redraw = true;
        }
Exemple #15
0
        private void auto_suggest_text()
        {
            US_DM_NHAN_SU us_dm_nhan_su = new US_DM_NHAN_SU();
            DS_DM_NHAN_SU ds_dm_nhan_su = new DS_DM_NHAN_SU();

            us_dm_nhan_su.FillDataset(ds_dm_nhan_su);
            var v_acsc_search = new AutoCompleteStringCollection();

            foreach (var v_rows in ds_dm_nhan_su.DM_NHAN_SU)
            {
                v_acsc_search.Add(v_rows[DM_NHAN_SU.HO_DEM] + " - " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
                v_acsc_search.Add(v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.HO_DEM] + " " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
                v_acsc_search.Add(v_rows[DM_NHAN_SU.MA_NV] + " - " + v_rows[DM_NHAN_SU.HO_DEM] + " " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
            }
            m_txt_tim_kiem_nhan_vien.AutoCompleteCustomSource = v_acsc_search;
        }
Exemple #16
0
        private void load_custom_source_2_m_txt_tim_kiem()
        {
            DS_DM_NHAN_SU m_ds_ns = new DS_DM_NHAN_SU();
            US_DM_NHAN_SU m_us_ns = new US_DM_NHAN_SU();

            m_us_ns.FillDataset(m_ds_ns);
            //  int count = m_ds_qua_trinh_lam_viec.Tables["V_GD_QUA_TRINH_LAM_VIEC"].Rows.Count;
            AutoCompleteStringCollection v_acsc_search = new AutoCompleteStringCollection();

            foreach (DataRow dr in m_ds_ns.DM_NHAN_SU)
            {
                v_acsc_search.Add(dr[DM_NHAN_SU.MA_NV].ToString());
                v_acsc_search.Add(dr[DM_NHAN_SU.HO_DEM].ToString() + " " + dr[DM_NHAN_SU.TEN].ToString());
                v_acsc_search.Add(dr[DM_NHAN_SU.TEN].ToString());
            }
            m_txt_tim_kiem.AutoCompleteCustomSource = v_acsc_search;
        }
Exemple #17
0
        private void chon_nhan_su()
        {
            string[]      v_strs          = m_txt_ma_ns.Text.Split('-');
            DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
            US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU();

            v_us_dm_nhan_su.FillDataset_search_by_ma_nv(v_ds_dm_nhan_su, v_strs[v_strs.Length - 1].Trim());
            if (v_ds_dm_nhan_su.Tables[0].Rows.Count == 0)
            {
                return;
            }
            m_lbl_ma_nhan_vien.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["MA_NV"].ToString();
            m_lbl_ho_va_ten.Text    = v_ds_dm_nhan_su.Tables[0].Rows[0]["HO_DEM"] + " " +
                                      v_ds_dm_nhan_su.Tables[0].Rows[0]["TEN"];
            m_lbl_ngay_sinh.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["NGAY_SINH"].ToString().Split(' ')[0];
            m_lbl_dia_chi.Text   = v_ds_dm_nhan_su.Tables[0].Rows[0]["CHO_O"].ToString();
        }
Exemple #18
0
 public void display_chon_phap_nhan(US_DM_NHAN_SU i_us)
 {
     m_us_nhan_su = i_us;
     m_cmd_them_cap_bac.Visible    = false;
     m_cmd_them_chuc_vu.Visible    = false;
     m_cmd_them_du_an.Visible      = false;
     m_cmd_them_hop_dong.Visible   = false;
     m_cmd_them_trang_thai.Visible = false;
     m_cmd_phap_nhan_te.Visible    = true;
     m_cmd_phap_nhan_te.Enabled    = true;
     m_cmd_phap_nhan_tu.Visible    = true;
     m_cmd_phap_nhan_tu.Enabled    = true;
     this.Text        = "F201 - Chọn pháp nhân";
     this.MinimumSize = new Size(470, 194);
     this.MaximumSize = new Size(470, 194);
     this.Size        = new Size(470, 194);
     this.Show();
 }
Exemple #19
0
        private void auto_suggest_text()
        {
            m_txt_ma_ns.AutoCompleteMode   = AutoCompleteMode.Suggest;
            m_txt_ma_ns.AutoCompleteSource = AutoCompleteSource.CustomSource;
            AutoCompleteStringCollection coll = new AutoCompleteStringCollection();
            US_DM_NHAN_SU v_us_dm_nhan_su     = new US_DM_NHAN_SU();
            DS_DM_NHAN_SU v_ds_dm_nhan_su     = new DS_DM_NHAN_SU();

            v_us_dm_nhan_su.FillDataset_search(v_ds_dm_nhan_su, m_txt_ma_ns.Text);
            var v_rows = v_ds_dm_nhan_su.Tables[0].Rows;

            for (int i = 0; i < v_rows.Count - 1; i++)
            {
                coll.Add(v_rows[i]["HO_DEM"] + " - " + v_rows[i]["TEN"] + " - " + v_rows[i]["MA_NV"]);
                coll.Add(v_rows[i]["TEN"] + " - " + v_rows[i]["HO_DEM"] + " " + v_rows[i]["TEN"] + " - " + v_rows[i]["MA_NV"]);
            }
            m_txt_ma_ns.AutoCompleteCustomSource = coll;
        }
Exemple #20
0
        private void form_2_us_nhan_vien()
        {
            m_us.dcID_DU_AN   = m_us_du_an.dcID;
            m_us.strMA_DU_AN  = m_us_du_an.strMA_DU_AN;
            m_us.strTEN_DU_AN = m_us_du_an.strTEN_DU_AN;


            US_DM_NHAN_SU v_us_nhan_su = new US_DM_NHAN_SU();
            DS_DM_NHAN_SU v_ds_nhan_su = new DS_DM_NHAN_SU();

            v_us_nhan_su.FillDataset_search_by_ma_nv(v_ds_nhan_su, m_lbl_ma_nhan_vien.Text);
            if (v_ds_nhan_su.DM_NHAN_SU.Rows.Count > 0)
            {
                m_us.dcID_NHAN_SU = (decimal)v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.ID];
                m_us.strMA_NV     = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString();
                m_us.strHO_DEM    = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.HO_DEM].ToString();
                m_us.strTEN       = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.TEN].ToString();
            }

            m_us.dcID_VI_TRI = (decimal)m_cbo_vi_tri.SelectedValue;
            m_us.strVI_TRI   = m_cbo_vi_tri.Text;

            US_V_GD_TRANG_THAI_LAO_DONG v_us_trang_thai_ld = new US_V_GD_TRANG_THAI_LAO_DONG();
            DS_V_GD_TRANG_THAI_LAO_DONG v_ds_trang_thai_ld = new DS_V_GD_TRANG_THAI_LAO_DONG();

            v_us_trang_thai_ld.FillDatasetByManhanvien_trang_thai_hien_tai(v_ds_trang_thai_ld, m_lbl_ma_nhan_vien.Text, CAppContext_201.getCurrentIDPhapnhan());
            if (v_ds_trang_thai_ld.V_GD_TRANG_THAI_LAO_DONG.Rows.Count > 0)
            {
                m_us.strTRANG_THAI_LAO_DONG = v_ds_trang_thai_ld.V_GD_TRANG_THAI_LAO_DONG.Rows[0][V_GD_TRANG_THAI_LAO_DONG.TRANG_THAI_LAO_DONG].ToString();
            }

            m_us.datTHOI_DIEM_TG = m_dat_tham_gia.Value;
            m_us.datTHOI_DIEM_KT = m_dat_ngay_kt.Value;
            m_us.dcTHOI_GIAN_TG  = CIPConvert.ToDecimal(m_txt_thoi_gian_tham_gia.Text);

            m_us.dcID_DANH_HIEU = (decimal)m_cbo_danh_hieu.SelectedValue;
            m_us.strDANH_HIEU   = m_cbo_danh_hieu.Text;

            m_us.strMA_QUYET_DINH = m_txt_ma_quyet_dinh.Text;
            m_us.strLOAI_QD       = m_lbl_loai_quyet_dinh.Text;
            m_us.strMO_TA         = m_txt_mo_ta.Text;
        }
        private void us_object_to_form()
        {
            m_txt_ma_nv.Text = m_us.strMA_NV;
            DS_DM_NHAN_SU m_ds_nhan_su = new DS_DM_NHAN_SU();
            US_DM_NHAN_SU m_us_nhan_su = new US_DM_NHAN_SU();

            m_us_nhan_su.FillDataset(m_ds_nhan_su, "WHERE MA_NV = N'" + m_txt_ma_nv.Text.ToString() + "'");
            id_nhan_su             = decimal.Parse(m_ds_nhan_su.DM_NHAN_SU.Rows[0][0].ToString());
            m_txt_ho_ten.Text      = m_us.strHO_DEM + " " + m_us.strTEN;
            m_txt_ma_nv.BackColor  = SystemColors.Info;
            m_txt_ma_nv.ReadOnly   = true;
            m_txt_ho_ten.BackColor = SystemColors.Info;
            m_txt_ho_ten.ReadOnly  = true;
            BKI_HRM.DS.DS_CM_DM_TU_DIEN v_ds_loai_quyet_dinh = new BKI_HRM.DS.DS_CM_DM_TU_DIEN();
            BKI_HRM.US.US_CM_DM_TU_DIEN v_us_loai_quyet_dinh = new BKI_HRM.US.US_CM_DM_TU_DIEN();

            v_us_loai_quyet_dinh.FillDataset_load_loai_quyet_dinh(v_ds_loai_quyet_dinh, "Tất cả", "N");
            m_cbo_loai_quyet_dinh.DataSource    = v_ds_loai_quyet_dinh.CM_DM_TU_DIEN;
            m_cbo_loai_quyet_dinh.DisplayMember = CM_DM_TU_DIEN.TEN;
            m_cbo_loai_quyet_dinh.ValueMember   = CM_DM_TU_DIEN.ID;
        }
Exemple #22
0
        private void form_to_us_object_v_trang_thai_ld()
        {
            //m_us_trang_thai_ld.dcID = m_us_v_trang_thai_ld.dcID;
            //m_us_trang_thai_ld.dcID_NHAN_SU = m_us_v_trang_thai_ld.dcID_NHAN_SU;
            if (m_us_v_trang_thai_ld.dcID == 0)
            {
                DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
                US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU();
                v_us_dm_nhan_su.FillDataset_search_by_ma_nv(v_ds_dm_nhan_su, m_txt_ma_nv.Text);
                m_us_v_trang_thai_ld.dcID_NHAN_SU = (decimal)v_ds_dm_nhan_su.Tables[0].Rows[0].ItemArray[0];
            }
            m_us_v_trang_thai_ld.dcID_PHAP_NHAN      = CAppContext_201.getCurrentIDPhapnhan();
            m_us_v_trang_thai_ld.dcID_TRANG_LAO_DONG = CIPConvert.ToDecimal(m_cbo_trang_thai_moi.SelectedValue);
            if (m_txt_ma_quyet_dinh.Text.Trim() != "")
            {
                m_us_v_trang_thai_ld.dcID_QUYET_DINH = m_us_quyet_dinh.dcID;
            }
            else
            {
                m_us_v_trang_thai_ld.SetID_QUYET_DINHNull();
            }
            m_us_v_trang_thai_ld.datNGAY_CO_HIEU_LUC = m_dat_ngay_co_hieu_luc.Value;

            if (m_dat_ngay_het_hieu_luc.Checked)
            {
                m_us_v_trang_thai_ld.datNGAY_HET_HIEU_LUC = m_dat_ngay_het_hieu_luc.Value;
            }
            else
            {
                m_us_v_trang_thai_ld.SetNGAY_HET_HIEU_LUCNull();
            }
            if (m_ckb_trang_thai_hien_tai_yn.Checked == true)
            {
                m_us_v_trang_thai_ld.strTRANG_THAI_HIEN_TAI = "Y";
            }
            else
            {
                m_us_v_trang_thai_ld.strTRANG_THAI_HIEN_TAI = "N";
            }
        }
Exemple #23
0
 public void display_them_nhan_vien(US_DM_NHAN_SU i_us)
 {
     m_cmd_them_hop_dong.Visible = false;
     m_us_nhan_su = i_us;
     this.Show();
 }