public US_CM_DM_BANG_CHI_TIET_CUOI_THANG(decimal i_dbID) { pm_objDS = new DS_CM_DM_BANG_CHI_TIET_CUOI_THANG(); 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_CM_DM_BANG_CHI_TIET_CUOI_THANG() { pm_objDS = new DS_CM_DM_BANG_CHI_TIET_CUOI_THANG(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
private void load_danh_sach_excel() { if(m_dgl_open_file.ShowDialog() == DialogResult.OK) { string v_str_path_and_file_name = m_dgl_open_file.FileName; string v_str_file_name = v_str_path_and_file_name.Substring(v_str_path_and_file_name.LastIndexOf("\\") + 1, v_str_path_and_file_name.Length - v_str_path_and_file_name.LastIndexOf("\\") - 1); CExcelReport v_xls_file = new CExcelReport(v_str_path_and_file_name); DS_CM_DM_BANG_CHI_TIET_CUOI_THANG v_ds_cm_dm_bang_chi_tiet_cuoi_thang = new DS_CM_DM_BANG_CHI_TIET_CUOI_THANG(); try { m_lbl_loading.Visible = true; v_ds_cm_dm_bang_chi_tiet_cuoi_thang.EnforceConstraints = false; v_xls_file.Export2DatasetDSPhongThi(v_ds_cm_dm_bang_chi_tiet_cuoi_thang, v_ds_cm_dm_bang_chi_tiet_cuoi_thang.CM_DM_BANG_CHI_TIET_CUOI_THANG.TableName, 2); //DataSet v_ds_cm_dm_bang_modify = ModifyDateToUSFormat(v_ds_cm_dm_bang_chi_tiet_cuoi_thang); CGridUtils.Dataset2C1Grid(v_ds_cm_dm_bang_chi_tiet_cuoi_thang, m_fg_load_file, m_obj_trans_xls); m_i_flag = 0; m_lbl_tong_so_luong.Text = CIPConvert.ToStr(m_fg_load_file.Rows.Count - 1); m_lbl_loading.Visible = false; } catch(Exception v_e) { if(v_e.Message.ToString() == "Cannot set Column 'STT' to be null. Please use DBNull instead.") BaseMessages.MsgBox_Error(THONG_BAO.ER_COT_STT_DE_TRONG); else CSystemLog_301.ExceptionHandle(v_e); } } }