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_V_DM_DU_LIEU_NHAN_VIEN(); m_us.FillDataset(m_ds); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; set_search_textbox_style(); m_lbl_so_nhan_vien.Text = lay_so_ban_ghi().ToString(); }
private void load_data_2_grid_ds(eDetailMode ip_e_detail_mode) { var v_str_search = m_fg.Rows[m_fg.Row][(int)e_col_Number.NGACH].ToString(); decimal v_dc_id_ttld = decimal.Parse(m_fg.Rows[m_fg.Row][(int)e_col_Number.ID_TTLD].ToString()); decimal v_dc_id_cv = decimal.Parse(m_fg.Rows[m_fg.Row][(int)e_col_Number.ID_CV].ToString()); m_ds_ds = new DS_V_DM_DU_LIEU_NHAN_VIEN(); switch (ip_e_detail_mode) { case eDetailMode.TANG: m_us_ds.FillDatasetNVNghiviec( m_ds_ds , v_str_search , m_dat_tu_ngay.Value.Date , m_dat_den_ngay.Value.Date , v_dc_id_ttld , CAppContext_201.getCurrentIDPhapnhan() , decimal.Parse(m_cbo_don_vi.SelectedValue.ToString()) , v_dc_id_cv); break; case eDetailMode.GIAM: m_us_ds.FillDatasetNVNghiviec_2( m_ds_ds , v_str_search , m_dat_tu_ngay.Value.Date , m_dat_den_ngay.Value.Date , v_dc_id_ttld , CAppContext_201.getCurrentIDPhapnhan() , decimal.Parse(m_cbo_don_vi.SelectedValue.ToString()) , v_dc_id_cv); break; default: break; } m_fg_danh_sach.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds_ds, m_fg_danh_sach, m_obj_trans_ds); m_fg_danh_sach.Redraw = true; m_lbl_soluongns.Text = m_ds_ds.V_DM_DU_LIEU_NHAN_VIEN.Count.ToString(); //m_fg_danh_sach.Subtotal(AggregateEnum.Count, 0, -1, (int)e_col_Number_ds.MA_CV); }
private void tim_kiem_theo_gioi_tinh() { m_ds = new DS_V_DM_DU_LIEU_NHAN_VIEN(); var v_str_search = m_txt_tim_kiem.Text.Trim(); var v_str_month = Regex.Match(v_str_search, @"\d+").Value; if (!v_str_month.Equals("")) { v_str_search = v_str_month; } m_us.FillDatasetConvention(v_str_search, get_gender(), m_ds); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; set_search_textbox_style(); m_lbl_so_nhan_vien.Text = lay_so_ban_ghi().ToString(); }
private void load_data_2_lbox_nhan_vien_right(decimal ip_dc_ma_don_vi) { var v_us = new US_V_DM_DU_LIEU_NHAN_VIEN(); var v_ds = new DS_V_DM_DU_LIEU_NHAN_VIEN(); v_us.FillDatasetByIdDonVi(v_ds, ip_dc_ma_don_vi); int v_row_count = v_ds.Tables[0].Rows.Count; m_lbox_nhan_vien_right.Items.Clear(); for (int i = 0; i < v_row_count; i++) { DataRow v_dr = v_ds.Tables[0].Rows[i]; m_lbox_nhan_vien_right.Items.Add(v_dr[V_DM_DU_LIEU_NHAN_VIEN.MA_NV] + "-" + v_dr[V_DM_DU_LIEU_NHAN_VIEN.HO_DEM] + " " + v_dr[V_DM_DU_LIEU_NHAN_VIEN.TEN]); } if (m_lbox_nhan_vien_right.Items.Count > 0) { m_lbox_nhan_vien_right.SelectedIndex = 0; } }