private void chon_nhan_su() { string[] v_strs = m_txt_tim_kiem_nhan_vien.Text.Split('-'); DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU(); m_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"]; // DucVT m_lbl_email_co_quan.Text = v_ds_dm_nhan_su.Tables[0].Rows[0][DM_NHAN_SU.EMAIL_CQ].ToString(); // Lấy chức vụ bằng Id nhân sự DS_V_GD_QUA_TRINH_LAM_VIEC v_ds_gd_qtlv = new DS_V_GD_QUA_TRINH_LAM_VIEC(); US_V_GD_QUA_TRINH_LAM_VIEC v_us_gd_qtlv = new US_V_GD_QUA_TRINH_LAM_VIEC(); v_us_gd_qtlv.FillDataSet_Now_By_Ma_NV_Id_PN(v_ds_gd_qtlv, v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString(), CAppContext_201.getCurrentIDPhapnhan()); if (v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows.Count > 0) { m_lbl_ma_chuc_vu.Text = v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_CV].ToString(); m_lbl_ma_don_vi.Text = v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_DON_VI].ToString(); } // ~DucVT }
private void load_info_staff_to_form() { string[] v_strs = m_txt_tim_kiem_nhan_vien.Text.Split('-'); DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU(); m_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_us_dm_nhan_su.DataRow2Me(v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0]); load_info_staff(m_us_dm_nhan_su); // DucVT // Lấy chức vụ bằng Id nhân sự DS_V_GD_QUA_TRINH_LAM_VIEC v_ds_gd_qtlv = new DS_V_GD_QUA_TRINH_LAM_VIEC(); US_V_GD_QUA_TRINH_LAM_VIEC v_us_gd_qtlv = new US_V_GD_QUA_TRINH_LAM_VIEC(); v_us_gd_qtlv.FillDataSet_Now_By_Ma_NV_Id_PN(v_ds_gd_qtlv, v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString(), CAppContext_201.getCurrentIDPhapnhan()); if (v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows.Count > 0) { m_lbl_ma_chuc_vu.Text = v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_CV].ToString(); m_lbl_ma_don_vi.Text = v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_DON_VI].ToString(); } // ~DucVT }
// Event private methods private void load_file_excel() { if (m_ofd_exel_file.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { // Reset lại ds mới nếu chọn lại file excel khác m_ds = new DS_DM_NHAN_SU(); m_lbl_loading_mes.Visible = true; CExcelReport v_excel_rpt = new CExcelReport(m_ofd_exel_file.FileName); m_ds.EnforceConstraints = false; v_excel_rpt.Export2DatasetDS_by_DucVT(m_ds, m_ds.DM_NHAN_SU.TableName, 2); m_fg.Redraw = false; //Gán DataSource //m_fg.DataSource = m_ds.DM_NHAN_SU; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; m_lbl_loading_mes.Visible = false; } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } } }
private void view_info_Nhan_Su(decimal ip_id_nhan_su) { DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU(); m_us_dm_nhan_su.FillDatasetByID(v_ds_dm_nhan_su, ip_id_nhan_su); m_lbl_ma_nhan_vien.Text = v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString(); m_lbl_ho_va_ten.Text = v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.HO_DEM].ToString() + " " + v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.TEN].ToString(); // DucVT m_lbl_email_co_quan.Text = v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.EMAIL_CQ].ToString(); // 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_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString(), 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.MA_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.MA_DON_VI].ToString(); } // ~DucVT }
public void FillDatasetByID(DS_DM_NHAN_SU op_ds_dm_nhan_su, decimal ip_dc_id) { CStoredProc cstored = new CStoredProc("pr_DM_NHAN_SU_Search_by_ID"); cstored.addDecimalInputParam("@ID_NS", ip_dc_id); cstored.fillDataSetByCommand(this, op_ds_dm_nhan_su); }
public void FillDataset_search_by_ma_nv(DS_DM_NHAN_SU op_ds_dm_nhan_su, string ip_str_search) { CStoredProc cstored = new CStoredProc("pr_DM_NHAN_SU_Search_by_ma_ns"); cstored.addNVarcharInputParam("@ip_str_search", ip_str_search); cstored.fillDataSetByCommand(this, op_ds_dm_nhan_su); }
private void form_2_us_object() { m_us.strMA_HOP_DONG = m_txt_ma_hop_dong.Text.Trim(); m_us.dcID_LOAI_HOP_DONG = (decimal)m_cbo_loai_hop_dong.SelectedValue; m_us.dcID_PHAP_NHAN = CAppContext_201.getCurrentIDPhapnhan(); m_us.datNGAY_CO_HIEU_LUC = m_dat_ngay_co_hieu_luc.Value; m_us.strTRANG_THAI_HOP_DONG = m_cbo_trang_thai.SelectedIndex.Equals(0) ? "Y" : "N"; m_us.strNGUOI_KY = m_txt_nguoi_ky.Text.Trim(); m_us.strCHUC_VU_NGUOI_KY = m_txt_chuc_vu_nguoi_ky.Text.Trim(); m_us.datNGAY_KY_HOP_DONG = m_dat_ngay_ky_hop_dong.Value; if (m_us_dm_nhan_su.dcID == -1) { DS_DM_NHAN_SU m_ds_dm_nhan_su = new DS_DM_NHAN_SU(); m_us_dm_nhan_su.FillDataset_search_by_ma_nv(m_ds_dm_nhan_su, m_lbl_ma_nhan_vien.Text); m_us.dcID_NHAN_SU = (decimal)m_ds_dm_nhan_su.Tables[0].Rows[0].ItemArray[0]; } else { m_us.dcID_NHAN_SU = m_us_dm_nhan_su.dcID; } if (m_dat_ngay_het_han.Checked == false) { m_us.SetNGAY_HET_HANNull(); } else { m_us.datNGAY_HET_HAN = m_dat_ngay_het_han.Value; } m_us.strLINK = m_lbl_file_name.Text; }
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); }
private void load_data_2_grid() { m_ds = new DS_DM_NHAN_SU(); m_us.FillDataset(m_ds); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; }
public void FillDatasetSearch(DS_DM_NHAN_SU op_ds, string ip_ma_nv) { CStoredProc v_sp = new CStoredProc("pr_RPT_NHAN_VIEN_CHUA_CHUC_VU_TRANG_THAI"); v_sp.addNVarcharInputParam("@ip_ma_nv", ip_ma_nv); v_sp.fillDataSetByCommand(this, op_ds); }
private void load_data_2_grid() { m_ds = new DS_DM_NHAN_SU(); m_us.FillDatasetSearch(m_ds, HelperDucVT.CUtils.get_ma_nv(m_txt_search.Text)); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; m_lbl_so_luong_nv_chua_chuc_vu_trang_thai.Text = m_ds.Tables[0].Rows.Count.ToString(); }
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()); } }
public US_DM_NHAN_SU(decimal i_dbID) { pm_objDS = new DS_DM_NHAN_SU(); pm_strTableName = c_TableName; IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName); v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang); SqlCommand v_cmdSQL; v_cmdSQL = v_objMkCmd.getSelectCmd(); this.FillDatasetByCommand(pm_objDS, v_cmdSQL); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[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"]; }
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; }
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; }
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(); }
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; }
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; }
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; }
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"; } }
/// <summary> /// Tạo custom source cho autocomplete với dữ liệu từ DM_NHAN_SU /// </summary> /// <param name="ip_type">Loại Custom Source muốn tạo</param> /// <returns>Custom source autocomplete của bảng DM_NHAN_SU</returns> public static AutoCompleteStringCollection create_csac_nhan_su(Int16 ip_type = 0) { // Initialize AutoCompleteStringCollection v_acsc = new AutoCompleteStringCollection(); try { // Fill dataset DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU(); new US_DM_NHAN_SU().FillDataset(v_ds_dm_nhan_su); // Create custom source // Tạo thêm type mới ở đây switch (ip_type) { case 0: foreach (var v_rows in v_ds_dm_nhan_su.DM_NHAN_SU) { v_acsc.Add(v_rows[DM_NHAN_SU.HO_DEM] + " - " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]); v_acsc.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.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]); } break; default: break; } } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); return(null); } return(v_acsc); }
private void kiem_tra_du_lieu() { if ((string)m_fg[1, 0] != "") { DS_DM_NHAN_SU v_ds_nhan_su_db = new DS_DM_NHAN_SU(); m_us.FillDataset(v_ds_nhan_su_db); CellStyle red_cell = m_fg.Styles.Add("v_blank"); red_cell.BackColor = Color.Red; CellStyle green_cell = m_fg.Styles.Add("v_duplicate"); green_cell.BackColor = Color.Green; CellStyle default_cell = m_fg.Styles.Add("v_default"); default_cell.BackColor = Color.WhiteSmoke; int i_ma_nv = (int)e_col_Number.MA_NV; int i_ho_dem = (int)e_col_Number.HO_DEM; int i_ten = (int)e_col_Number.TEN; int i_id = (int)e_col_Number.ID; int i_id_headcount = (int)e_col_Number.ID_HEADCOUNT; bool is_error = false; // Clear Style và Format lại m_fg.Clear(ClearFlags.Style); m_fg.Cols[0].Width = 14; m_fg.Rows[0].Height = 35; m_fg.Cols[i_id].Visible = false; m_fg.Cols[i_id_headcount].Visible = false; m_fg.Cols[(int)e_col_Number.NGAY_SINH].Format = "dd/MM/yyyy"; m_fg.Cols[(int)e_col_Number.NGAY_SINH].DataType = typeof(DateTime); m_fg.Cols[(int)e_col_Number.NGAY_CAP_CMND].Format = "dd/MM/yyyy"; m_fg.Cols[(int)e_col_Number.NGAY_CAP_CMND].DataType = typeof(DateTime); // Tổ đỏ nền và cho phép sửa dữ liệu dòng đó. // Chú ý là chỉ cần đổi lại màu của các ô màu bị đổi trước đó (cụ thể là đổi các ô màu đỏ, xanh được tạo trước đó về màu trắng) foreach (Row v_row in m_fg.Rows) { if (v_row.Index > 0) { // Kiểm tra dữ liệu trống trong các cột mã nv, họ đệm, tên if ((string)v_row[i_ma_nv] == null) { m_fg.SetCellStyle(v_row.Index, i_ma_nv, red_cell); is_error = true; } if ((string)v_row[i_ho_dem] == null) { m_fg.SetCellStyle(v_row.Index, i_ho_dem, red_cell); is_error = true; } if ((string)v_row[i_ten] == null) { m_fg.SetCellStyle(v_row.Index, i_ten, red_cell); is_error = true; } // Nếu ô hiện tại bị bôi xanh thì không cần kiểm tra trùng nữa, việc này tránh dư thừa kiểm tra. // Kiểm tra dữ liệu trùng ở cột mã nv trên grid (file excel) for (int index = v_row.Index + 1; index < m_fg.Rows.Count; index++) { Row v_cur_row = m_fg.Rows[index]; if (((string)v_row[i_ma_nv]) == ((string)v_cur_row[i_ma_nv])) { m_fg.SetCellStyle(v_row.Index, i_ma_nv, green_cell); m_fg.SetCellStyle(v_cur_row.Index, i_ma_nv, green_cell); is_error = true; } } // Kiểm tra dữ liệu tồn tại trong cơ sở dữ liệu // Nếu ô hiện tại bị bôi xanh thì không cần kiểm tra trùng nữa, việc này tránh dư thừa kiểm tra. foreach (DataRow v_row_db in v_ds_nhan_su_db.DM_NHAN_SU.Rows) { if (((string)v_row[i_ma_nv]) == ((string)v_row_db[DM_NHAN_SU.MA_NV])) { m_fg.SetCellStyle(v_row.Index, i_ma_nv, green_cell); is_error = true; } } } } if (is_error) { m_fg.AllowEditing = true; m_fg.Redraw = true; throw new Exception("Có dữ liệu lỗi. Vui lòng kiểm tra lại"); } else { m_fg.Redraw = true; HelperDucVT.CUtils.show_success_message("Dữ liệu không có lỗi"); } } else { m_fg.Redraw = true; throw new Exception("Bạn cần chọn file excel trước"); } }
public US_DM_NHAN_SU() { pm_objDS = new DS_DM_NHAN_SU(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }