public US_EXCEL_IMPORT_HOC_VIEN(decimal i_dbID) { pm_objDS = new DS_EXCEL_IMPORT_HOC_VIEN(); 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]); }
public US_EXCEL_IMPORT_HOC_VIEN() { pm_objDS = new DS_EXCEL_IMPORT_HOC_VIEN(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
private void load_data_2_grid() { m_ds = new DS_EXCEL_IMPORT_HOC_VIEN(); m_us.FillDataset(m_ds); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; }
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_EXCEL_IMPORT_HOC_VIEN(); 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.EXCEL_IMPORT_HOC_VIEN.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 kiem_tra_du_lieu(DS_EXCEL_IMPORT_HOC_VIEN ip_ds) { m_flag_du_lieu_is_ok = true; CellStyle v_style_not_ok = m_fg.Styles.Add("LoiDuLieu"); v_style_not_ok.BackColor = Color.Pink; CellStyle v_style_ok_ma_hv = m_fg.Styles.Add("Ma_HV"); v_style_ok_ma_hv.BackColor = Color.DeepSkyBlue; CellStyle v_style_ok = m_fg.Styles.Add("OK"); v_style_ok.BackColor = Color.White; //Buoc 1: Check null for(int i = m_fg.Rows.Fixed; i < m_fg.Rows.Count; i++) { for(int j = m_fg.Cols.Fixed; j < m_fg.Cols.Count; j++) { if(m_fg.Rows[i][j] == null || m_fg.Rows[i][j].ToString() == "") { m_fg.SetCellStyle(i, j, v_style_not_ok); m_flag_du_lieu_is_ok = false; } else { m_fg.SetCellStyle(i, (int)e_col_Number.MA_HOC_VIEN, v_style_ok); } } } //Buoc 2: Check Ma hoc vien da ton tai chua DS_DM_HOC_SINH v_ds_hs = new DS_DM_HOC_SINH(); v_ds_hs.Clear(); v_ds_hs.EnforceConstraints = false; US_DM_HOC_SINH v_us_hs = new US_DM_HOC_SINH(); v_us_hs.FillDataset(v_ds_hs); DataView v_dv_db = v_ds_hs.DM_HOC_SINH.DefaultView; v_dv_db.Sort = "MA_DOI_TUONG"; for(int i = m_fg.Rows.Fixed; i < m_fg.Rows.Count; i++) { int v_row = v_dv_db.Find(m_fg.Rows[i][(int)e_col_Number.MA_HOC_VIEN].ToString()); if(v_row > 0) { m_flag_du_lieu_is_ok = false; m_fg.SetCellStyle(i, (int)e_col_Number.MA_HOC_VIEN, v_style_ok_ma_hv); } else { m_fg.SetCellStyle(i, (int)e_col_Number.MA_HOC_VIEN, v_style_ok); } } }