private void StartTherm(string p_strNumberOfTherms, string p_strTitle) { m_frmTherm = new frmTherm((frmDialog)ParentForm, p_strTitle); m_frmTherm.Text = p_strTitle; m_frmTherm.lblMsg.Text = ""; m_frmTherm.lblMsg2.Text = ""; m_frmTherm.Visible = false; m_frmTherm.btnCancel.Visible = false; m_frmTherm.btnCancel.Enabled = false; m_frmTherm.lblMsg.Visible = true; m_frmTherm.progressBar1.Minimum = 0; m_frmTherm.progressBar1.Visible = true; m_frmTherm.progressBar1.Maximum = 10; if (p_strNumberOfTherms == "2") { m_frmTherm.progressBar2.Size = m_frmTherm.progressBar1.Size; m_frmTherm.progressBar2.Left = m_frmTherm.progressBar1.Left; m_frmTherm.progressBar2.Top = Convert.ToInt32(m_frmTherm.progressBar1.Top + (m_frmTherm.progressBar1.Height * 3)); m_frmTherm.lblMsg2.Top = m_frmTherm.progressBar2.Top + m_frmTherm.progressBar2.Height + 5; m_frmTherm.Height = m_frmTherm.lblMsg2.Top + m_frmTherm.lblMsg2.Height + m_frmTherm.btnCancel.Height + 50; m_frmTherm.btnCancel.Top = m_frmTherm.ClientSize.Height - m_frmTherm.btnCancel.Height - 5; m_frmTherm.lblMsg2.Show(); m_frmTherm.progressBar2.Visible = true; } m_frmTherm.AbortProcess = false; m_frmTherm.Refresh(); m_frmTherm.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; ((frmDialog)ParentForm).Enabled = false; m_frmTherm.Visible = true; }
public void create_travel_times() { int intRandomNumber; string strRandomNumber; string strRandomSave; string strMDBFile; string strConn; string strSQL; //string strPsiteRailTravel_YN="N"; int x; int y; System.Data.OleDb.OleDbConnection p_conn; p_conn = new System.Data.OleDb.OleDbConnection(); ado_data_access p_ado = new ado_data_access(); utils p_utils = new utils(); strMDBFile = this.m_frmMain.frmProject.uc_project1.txtRootDirectory.Text + "\\gis\\db\\gis_travel_times.mdb"; strConn = p_ado.getMDBConnString(strMDBFile, "admin", ""); p_ado.OpenConnection(strConn, ref p_conn); p_ado.SqlNonQuery(p_conn, "delete from travel_time"); if (p_ado.m_intError == 0) { p_ado.CreateDataSet(p_conn, "select * from plot", "plot"); if (p_ado.m_intError == 0) { p_ado.AddSQLQueryToDataSet(p_conn, ref p_ado.m_OleDbDataAdapter, ref p_ado.m_DataSet, "select * from processing_site where ucase(name) like 'TEST%'", "processing_site"); if (p_ado.m_intError == 0) { this.m_frmTherm = new frmTherm(); this.m_frmTherm.AbortProcess = false; this.m_frmTherm.progressBar1.Minimum = 1; this.m_frmTherm.progressBar1.Maximum = p_ado.m_DataSet.Tables["plot"].Rows.Count; m_frmTherm.btnCancel.Visible = true; m_frmTherm.Show(); m_frmTherm.Focus(); m_frmTherm.Text = "Generating Random Travel Times"; m_frmTherm.Refresh(); this.m_frmTherm.btnCancel.Click += new System.EventHandler(this.ThermCancel); for (x = 0; x <= p_ado.m_DataSet.Tables["plot"].Rows.Count - 1; x++) { this.m_frmTherm.Increment(x + 1); strRandomSave = ""; for (y = 0; y <= p_ado.m_DataSet.Tables["processing_site"].Rows.Count - 1; y++) { for (;;) { intRandomNumber = p_utils.RandomNumber(1, 18); strRandomNumber = Convert.ToString(intRandomNumber); intRandomNumber = p_utils.RandomNumber(0, 9); strRandomNumber += "." + Convert.ToString(intRandomNumber); intRandomNumber = p_utils.RandomNumber(0, 9); strRandomNumber += Convert.ToString(intRandomNumber); if (strRandomNumber != strRandomSave) { strRandomSave = strRandomNumber; break; } } strSQL = "insert into travel_time (psite_id,biosum_plot_id,travel_mode,travel_time) VALUES "; strSQL += "(" + p_ado.m_DataSet.Tables["processing_site"].Rows[y]["psite_id"].ToString() + ",'" + p_ado.m_DataSet.Tables["plot"].Rows[x]["biosum_plot_id"].ToString() + "',1" + "," + strRandomNumber + ");"; p_ado.SqlNonQuery(p_conn, strSQL); } System.Windows.Forms.Application.DoEvents(); if (this.m_frmTherm.AbortProcess == true) { break; } } int intStart = 1; this.m_frmTherm.progressBar1.Maximum = p_ado.m_DataSet.Tables["processing_site"].Rows.Count; strRandomSave = ""; for (x = 0; x <= p_ado.m_DataSet.Tables["processing_site"].Rows.Count - 1; x++) { this.m_frmTherm.Increment(x + 1); for (y = intStart; y <= p_ado.m_DataSet.Tables["processing_site"].Rows.Count - 1; y++) { strSQL = ""; if (p_ado.m_DataSet.Tables["processing_site"].Rows[y]["trancd"].ToString().Trim() == "2") { strSQL = "insert into travel_time (psite_id,railhead_id,travel_mode,travel_time) values "; } else if (p_ado.m_DataSet.Tables["processing_site"].Rows[y]["trancd"].ToString().Trim() == "3") { strSQL = "insert into travel_time (psite_id,collector_id,travel_mode,travel_time) values "; } if (strSQL.Trim().Length > 0) { for (;;) { intRandomNumber = p_utils.RandomNumber(1, 18); strRandomNumber = Convert.ToString(intRandomNumber); intRandomNumber = p_utils.RandomNumber(0, 9); strRandomNumber += "." + Convert.ToString(intRandomNumber); intRandomNumber = p_utils.RandomNumber(0, 9); strRandomNumber += Convert.ToString(intRandomNumber); if (strRandomNumber != strRandomSave) { strRandomSave = strRandomNumber; break; } } strSQL += "(" + p_ado.m_DataSet.Tables["processing_site"].Rows[x]["psite_id"].ToString() + "," + p_ado.m_DataSet.Tables["processing_site"].Rows[y]["psite_id"].ToString() + ",2" + "," + strRandomNumber + ");"; p_ado.SqlNonQuery(p_conn, strSQL); if (p_ado.m_intError != 0) { break; } } } if (p_ado.m_intError != 0) { break; } intStart++; System.Windows.Forms.Application.DoEvents(); if (this.m_frmTherm.AbortProcess == true) { break; } } if (p_ado.m_intError != 0) { } else { MessageBox.Show("Finished Generating Travel Times"); } this.m_frmTherm.Close(); this.m_frmTherm = null; } p_ado.m_DataSet.Clear(); p_ado.m_DataSet = null; p_ado.m_OleDbDataAdapter.Dispose(); p_ado.m_OleDbDataAdapter = null; p_conn.Close(); p_ado.m_OleDbConnection = null; } } p_conn = null; p_ado = null; p_utils = null; }