private void InitializeVariantLocationDictionary() { m_ado = new ado_data_access(); dictVariantLocations = new Dictionary <string, List <string> >(); using (var conn = new OleDbConnection(m_ado.getMDBConnString( frmMain.g_oEnv.strApplicationDataDirectory.Trim() + frmMain.g_strBiosumDataDir + "\\" + Tables.Reference.DefaultBiosumReferenceDbFile, "", ""))) { conn.Open(); m_ado.SqlQueryReader(conn, "SELECT DISTINCT fvs_variant, fvsloccode FROM fiadb_fvs_variant;"); if (this.m_ado.m_intError == 0) { if (this.m_ado.m_OleDbDataReader.HasRows) { string variant = ""; string location = ""; while (this.m_ado.m_OleDbDataReader.Read()) { variant = m_ado.m_OleDbDataReader["fvs_variant"].ToString().Trim(); if (!dictVariantLocations.ContainsKey(variant)) { dictVariantLocations.Add(variant, new List <string>()); } location = m_ado.m_OleDbDataReader["fvsloccode"].ToString().Trim(); dictVariantLocations[variant].Add(location); } } } m_ado.m_OleDbDataReader.Dispose(); } m_ado = null; }
private void populate_state_combo() { this.cmbState.Items.Clear(); ado_data_access p_ado = new ado_data_access(); env p_env = new env(); string strConn = p_ado.getMDBConnString(p_env.strAppDir.Trim() + "\\db\\utils.mdb", "", ""); try { p_ado.SqlQueryReader(strConn, "select * from states order by stabv"); if (p_ado.m_OleDbDataReader.HasRows == true) { while (p_ado.m_OleDbDataReader.Read()) { string strState = p_ado.m_OleDbDataReader["stabv"].ToString().Trim() + " - " + p_ado.m_OleDbDataReader["state_name"].ToString(); this.cmbState.Items.Add(strState); } } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbConnection.Close(); p_ado.m_OleDbConnection.Dispose(); } catch { } p_ado = null; p_env = null; }
public void populate_scenario_listbox() { string strScenarioId = ""; string strDescription = ""; //string strScenarioMDBFile=""; string strScenarioPath = ""; System.Data.OleDb.OleDbConnection oConn = new System.Data.OleDb.OleDbConnection(); string strProjDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim(); string strScenarioDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\db"; string strFile = "scenario_" + ScenarioType + "_rule_definitions.mdb"; StringBuilder strFullPath = new StringBuilder(strScenarioDir); strFullPath.Append("\\"); strFullPath.Append(strFile); ado_data_access p_ado = new ado_data_access(); string strConn = p_ado.getMDBConnString(strFullPath.ToString(), "admin", ""); p_ado.SqlQueryReader(strConn, "select * from scenario"); if (p_ado.m_intError == 0) { try { this.lstScenario.Items.Clear(); while (p_ado.m_OleDbDataReader.Read()) { strScenarioId = p_ado.m_OleDbDataReader["scenario_id"].ToString(); //strScenarioMDBFile = p_ado.m_OleDbDataReader["file"].ToString(); strDescription = p_ado.m_OleDbDataReader["description"].ToString(); strScenarioPath = p_ado.m_OleDbDataReader["path"].ToString(); this.lstScenario.Items.Add(p_ado.m_OleDbDataReader["scenario_id"].ToString()); } this.lstScenario.SelectedIndex = this.lstScenario.Items.Count - 1; this.txtScenarioPath.Text = strScenarioPath; this.txtDescription.Text = strDescription; } catch (Exception caught) { intError = -1; strError = caught.Message; MessageBox.Show(strError); } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbDataReader = null; p_ado.m_OleDbCommand = null; p_ado.m_OleDbConnection.Close(); p_ado.m_OleDbConnection = null; } p_ado = null; }
private string getNextScenarioId() { System.Data.OleDb.OleDbConnection oConn = new System.Data.OleDb.OleDbConnection(); string strProjDir = frmMain.g_oFrmMain.getProjectDirectory(); string strScenarioDir = strProjDir + "\\" + ScenarioType + "\\db"; string strFile = "scenario_" + ScenarioType + "_rule_definitions.mdb"; System.Text.StringBuilder strFullPath = new System.Text.StringBuilder(strScenarioDir); strFullPath.Append("\\"); strFullPath.Append(strFile); ado_data_access oAdo = new ado_data_access(); string strConn = oAdo.getMDBConnString(strFullPath.ToString(), "admin", ""); oAdo.OpenConnection(strConn); string strSQL = "SELECT scenario_id from " + Tables.Scenario.DefaultScenarioTableName; System.Collections.Generic.IList <string> lstExistingScenarios = new System.Collections.Generic.List <string>(); oAdo.SqlQueryReader(oAdo.m_OleDbConnection, strSQL); if (oAdo.m_OleDbDataReader.HasRows) { // Load all of the existing scenarios into a list we can query while (oAdo.m_OleDbDataReader.Read()) { string strScenario = Convert.ToString(oAdo.m_OleDbDataReader["scenario_id"]).Trim(); if (!String.IsNullOrEmpty(strScenario)) { lstExistingScenarios.Add(strScenario); } } } oAdo.CloseConnection(oAdo.m_OleDbConnection); int i = 1; string strTestName; // keep incrementing the scenario name until we find one that doesn't exist while (i < (lstExistingScenarios.Count + 1)) { strTestName = "scenario" + Convert.ToString(i); if (!lstExistingScenarios.Contains(strTestName)) { break; } i++; } strTestName = "scenario" + Convert.ToString(i); return(strTestName); }
private void cmbVariant_SelectedIndexChanged(object sender, System.EventArgs e) { if (this.cmbVariant.Text.Trim().Length > 0) { this.m_strVariant = this.cmbVariant.Text.Trim().Substring(0, 2).ToString(); if (m_strVariant.Trim().Length > 0) { this.cmbFvsSpCd.Items.Clear(); // cache convertToSpcd int intMyConvertToSpcd = -1; if (m_intConvertToSpCd > 0) { intMyConvertToSpcd = m_intConvertToSpCd; } this.m_dictFvsCommonName.Clear(); m_ado.m_strSQL = "SELECT spcd,fvs_species,common_name,fvs_common_name " + "FROM " + m_strFvsTreeSpcTable + " " + "WHERE LEN(TRIM(fvs_species)) > 0 AND " + "LEN(TRIM(common_name)) > 0 AND " + "TRIM(fvs_variant) = '" + m_strVariant.Trim() + "' order by spcd;"; m_ado.SqlQueryReader(m_ado.m_OleDbConnection, m_ado.m_OleDbTransaction, m_ado.m_strSQL); if (m_ado.m_OleDbDataReader.HasRows) { while (m_ado.m_OleDbDataReader.Read()) { string strMySpCd = Convert.ToString(m_ado.m_OleDbDataReader["spcd"]); this.cmbFvsSpCd.Items.Add(strMySpCd + " - " + Convert.ToString(m_ado.m_OleDbDataReader["common_name"]) + " - " + m_ado.m_OleDbDataReader["fvs_species"]); if (!m_dictFvsCommonName.ContainsKey(strMySpCd)) { m_dictFvsCommonName.Add(strMySpCd, Convert.ToString(m_ado.m_OleDbDataReader["fvs_common_name"])); } } if (intMyConvertToSpcd > 0) { this.intConvertToSpCd = intMyConvertToSpcd; } } m_ado.m_OleDbDataReader.Close(); } } }
public int getNumberOfOptimizerTables(string strScenarioMDB, string strScenarioId) { int intCount = 0; System.Data.OleDb.OleDbConnection p_conn; ado_data_access p_ado = new ado_data_access(); p_conn = new System.Data.OleDb.OleDbConnection(); string strConn = p_ado.getMDBConnString(strScenarioMDB, "admin", ""); p_ado.OpenConnection(strConn, ref p_conn); if (p_ado.m_intError != 0) { p_ado = null; return(intCount); } string strSQL = "SELECT table_name FROM scenario_datasource WHERE " + " scenario_id = '" + strScenarioId + "';"; p_ado.SqlQueryReader(p_conn, strSQL); if (p_ado.m_intError == 0) { while (p_ado.m_OleDbDataReader.Read()) { if (p_ado.m_OleDbDataReader["table_name"] != System.DBNull.Value) { if (p_ado.m_OleDbDataReader["table_name"].ToString().Trim().Length > 0) { intCount++; } } } } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbDataReader = null; p_conn.Close(); p_conn = null; p_ado = null; return(intCount); }
//Get rx listing from project and make sure all FSOUT_rx* is present, TODO: otherwise? private ArrayList DbRxVerify() { ArrayList aryL = new ArrayList(); ado_data_access p_ado = new ado_data_access(); string strSQL = @"SELECT * FROM RX;"; try { p_ado.SqlQueryReader(string.Format(this.strDbConx, this.strPathMasterDbFile), strSQL); if (p_ado.m_intError == 0) { if (p_ado.m_OleDbDataReader.HasRows == true) { while (p_ado.m_OleDbDataReader.Read()) { aryL.Add(p_ado.m_OleDbDataReader["RX"].ToString().Trim()); } } else { //TODO: Log to file } } } catch (OLE.OleDbException ode) { p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbConnection.Close(); throw ode; } finally { p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbConnection.Close(); p_ado.m_OleDbDataReader = null; p_ado.m_OleDbConnection = null; p_ado = null; } return(aryL); }
private void RefreshForm() { string strScenarioDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\db"; string strFile = "scenario_" + ScenarioType + "_rule_definitions.mdb"; StringBuilder strFullPath = new StringBuilder(strScenarioDir); strFullPath.Append("\\"); strFullPath.Append(strFile); ado_data_access p_ado = new ado_data_access(); string strConn = p_ado.getMDBConnString(strFullPath.ToString(), "admin", ""); //string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFullPath.ToString() + ";User Id=admin;Password=;"; string strSQL = "select * from scenario where scenario_id = '" + this.lstScenario.SelectedItem.ToString() + "';"; p_ado.SqlQueryReader(strConn, strSQL); if (p_ado.m_intError == 0) { try { while (p_ado.m_OleDbDataReader.Read()) { this.txtDescription.Text = p_ado.m_OleDbDataReader["description"].ToString(); this.txtScenarioPath.Text = p_ado.m_OleDbDataReader["path"].ToString(); this.txtScenarioId.Text = p_ado.m_OleDbDataReader["scenario_id"].ToString(); //((frmScenario)this.ParentForm).uc_scenario_notes1.txtNotes.Text = p_ado.m_OleDbDataReader["notes"].ToString(); break; } p_ado.m_OleDbDataReader.Close(); } catch (Exception caught) { this.strError = caught.Message; this.intError = -1; MessageBox.Show(this.strError); } p_ado.m_OleDbDataReader = null; p_ado.m_OleDbCommand = null; p_ado.m_OleDbConnection.Close(); p_ado.m_OleDbConnection = null; } }
/// <summary> /// Populate listbox with the strColumn values /// </summary> /// <param name="p_oAdo"></param> /// <param name="p_oConn"></param> /// <param name="strSQL"></param> /// <param name="strColumn"></param> public void loadvalues(ado_data_access p_oAdo, System.Data.OleDb.OleDbConnection p_oConn, string strSQL, string strColumn) { listBox1.Items.Clear(); p_oAdo.SqlQueryReader(p_oConn, strSQL); if (p_oAdo.m_OleDbDataReader.HasRows) { while (p_oAdo.m_OleDbDataReader.Read()) { if (p_oAdo.m_OleDbDataReader[strColumn] != System.DBNull.Value && p_oAdo.m_OleDbDataReader[strColumn].ToString().Trim().Length > 0) { listBox1.Items.Add(p_oAdo.m_OleDbDataReader[strColumn].ToString().Trim()); } } } else { MessageBox.Show("No items to add to menu list", "FIA Bisoum"); } }
private void LoadCategoryListBox() { string str = ""; this.lstMajor.Items.Clear(); this.m_oAdo.m_strSQL = "SELECT * FROM " + this.m_oQueries.m_oFvs.m_strFvsCatTable; m_oAdo.SqlQueryReader(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL); if (m_oAdo.m_OleDbDataReader.HasRows) { while (m_oAdo.m_OleDbDataReader.Read()) { if (m_oAdo.m_OleDbDataReader["desc"] != System.DBNull.Value) { str = Convert.ToString(m_oAdo.m_OleDbDataReader["desc"]) + " " + Convert.ToString(m_oAdo.m_OleDbDataReader["min"]).Trim().PadLeft(3, '0') + "-" + Convert.ToString(m_oAdo.m_OleDbDataReader["max"]).Trim().PadLeft(3, '0'); this.lstMajor.Items.Add(str); } } } m_oAdo.m_OleDbDataReader.Close(); }
public uc_biosum_id(string strBiosumId) { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); this.m_biosumid = new Biosum_Id(); this.m_biosumid.strInvId = strBiosumId.ToString().Substring(0, 1); this.m_biosumid.strSecInvId = strBiosumId.ToString().Substring(1, 4); this.m_biosumid.strStateCd = strBiosumId.ToString().Substring(5, 2); this.m_biosumid.strNimsCycle = strBiosumId.ToString().Substring(7, 2); this.m_biosumid.strNimsSubCycle = strBiosumId.ToString().Substring(9, 2); this.m_biosumid.strCountyCd = strBiosumId.ToString().Substring(11, 3); this.m_biosumid.strPlot = strBiosumId.ToString().Substring(14, 7); this.m_biosumid.strPnwIdbForestOrBlmDistrict = strBiosumId.ToString().Substring(21, 3); if (strBiosumId.Trim().Length == BIOSUM_COND_ID_LENGTH) { this.m_biosumid.strCondId = strBiosumId.ToString().Substring(24, 1); this.lblCondId.Text = this.m_biosumid.strCondId; } else { this.m_biosumid.strCondId = "NA"; this.lblCondId.Text = "NA"; } switch (this.m_biosumid.strInvId) { case "1": this.lblInvSource.Text = "FIADB"; this.lblCycle.Text = this.m_biosumid.strNimsCycle; this.lblSubcycle.Text = this.m_biosumid.strNimsSubCycle; this.lblPNWOrBLM.Text = "NA"; break; case "2": this.lblInvSource.Text = "PNW IDB"; this.lblCycle.Text = "NA"; this.lblSubcycle.Text = "NA"; this.lblPNWOrBLM.Text = this.m_biosumid.strPnwIdbForestOrBlmDistrict; break; case "3": this.lblInvSource.Text = "NIMS"; this.lblCycle.Text = this.m_biosumid.strNimsCycle; this.lblSubcycle.Text = this.m_biosumid.strNimsSubCycle; this.lblPNWOrBLM.Text = "NA"; break; default: this.lblInvSource.Text = "Unknown"; this.lblCycle.Text = "NA"; this.lblSubcycle.Text = "NA"; this.lblPNWOrBLM.Text = "NA"; break; } env p_oEnv = new env(); ado_data_access p_ado = new ado_data_access(); string strFile = p_oEnv.strAppDir + "\\db\\ref_master.mdb"; string strConn = ""; strConn = p_ado.getMDBConnString(strFile, "admin", ""); string strSQL = "select inv_id_def from inventories where trim(ucase(inv_id)) = '" + this.m_biosumid.strSecInvId.Trim().ToUpper() + "';"; p_ado.SqlQueryReader(strConn, strSQL); if (p_ado.m_intError == 0) { if (p_ado.m_OleDbDataReader.HasRows == true) { p_ado.m_OleDbDataReader.Read(); this.lblYearMeasured.Text = p_ado.m_OleDbDataReader["inv_id_def"].ToString().Trim(); } else { this.lblYearMeasured.Text = this.m_biosumid.strSecInvId.Trim(); } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbConnection.Close(); } p_ado.m_OleDbDataReader = null; p_ado.m_OleDbConnection = null; p_ado = null; this.lblState.Text = this.ConvertStateCd(this.m_biosumid.strStateCd); this.lblCounty.Text = this.m_biosumid.strCountyCd; this.lblPlot.Text = this.m_biosumid.strPlot; // TODO: Add any initialization after the InitializeComponent call }
public void loadgrid(bool p_bScenarioCopy) { string[] strDeleteSQL = new string[25]; string strSQL = ""; int intArrayCount; int x = 0; string strConn = ""; string strScenarioMDB = ""; ado_data_access p_ado = new ado_data_access(); this.strScenarioId = ReferenceOptimizerScenarioForm.uc_scenario1.txtScenarioId.Text.Trim().ToLower(); /*************************************************** **scenario mdb connection ***************************************************/ if (p_ado.m_intError != 0) { return; } p_ado.getScenarioConnStringAndMDBFile(ref strScenarioMDB, ref strConn, frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim()); this.m_OleDbConnectionScenario = new System.Data.OleDb.OleDbConnection(); p_ado.OpenConnection(strConn, ref this.m_OleDbConnectionScenario); /************************************************************************* **get the treatment prescription mdb file,table, and connection strings *************************************************************************/ p_ado.getScenarioDataSourceConnStringAndTable(ref this.strRxMDBFile, ref this.strRxPackageTableName, ref this.strRxConn, "Treatment Packages", this.strScenarioId, this.m_OleDbConnectionScenario); this.m_OleDbRxConn = new System.Data.OleDb.OleDbConnection(); p_ado.OpenConnection(this.strRxConn, ref this.m_OleDbRxConn); if (p_ado.m_intError != 0) { this.m_OleDbConnectionScenario.Close(); this.m_OleDbConnectionScenario = null; this.m_OleDbRxConn = null; return; } strSQL = "select * from " + this.strRxPackageTableName; p_ado.SqlQueryReader(this.m_OleDbRxConn, strSQL); /******************************************************************************** **insert records into the scenario_last_tiebreak_rank table from the master rxpackage table ********************************************************************************/ if (p_ado.m_intError == 0) { this.m_DataSet = new System.Data.DataSet(); this.m_OleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(); while (p_ado.m_OleDbDataReader.Read()) { strSQL = "select * from scenario_last_tiebreak_rank " + " where scenario_id = '" + this.strScenarioId + "' and " + "rxpackage = '" + p_ado.m_OleDbDataReader["rxpackage"].ToString() + "';"; this.m_OleDbCommand = this.m_OleDbConnectionScenario.CreateCommand(); this.m_OleDbCommand.CommandText = strSQL; this.m_OleDbDataAdapter.SelectCommand = this.m_OleDbCommand; this.m_OleDbDataAdapter.Fill(this.m_DataSet, "scenario_last_tiebreak_rank"); /******************************************************************************* **if the master treatment record is not found in the scenario db than insert it *******************************************************************************/ if (this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Rows.Count == 0) { strSQL = "INSERT INTO scenario_last_tiebreak_rank (scenario_id," + "rxpackage, last_tiebreak_rank) VALUES " + "('" + this.strScenarioId + "'," + "'" + p_ado.m_OleDbDataReader["rxpackage"].ToString() + "'," + "0);"; p_ado.SqlNonQuery(this.m_OleDbConnectionScenario, strSQL); } this.m_DataSet.Tables.Clear(); } p_ado.m_OleDbDataReader.Close(); this.m_DataSet.Dispose(); this.m_OleDbDataAdapter.Dispose(); intArrayCount = 0; /**************************************************************************************************** **delete any prescriptions from the scenario db that do not exist in the master ****************************************************************************************************/ strSQL = "select * from scenario_last_tiebreak_rank where scenario_id = '" + this.strScenarioId + "';"; p_ado.SqlQueryReader(this.m_OleDbConnectionScenario, strSQL); if (p_ado.m_intError == 0) { this.m_DataSet = new System.Data.DataSet(); this.m_OleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(); while (p_ado.m_OleDbDataReader.Read()) { /************************************************************************ **query the scenario treatment in the master db. If it is not found **in the master db then delete the scenario treatment record ************************************************************************/ strSQL = "select * from " + this.strRxPackageTableName + " where rxpackage = '" + p_ado.m_OleDbDataReader["rxpackage"].ToString() + "';"; this.m_OleDbCommand = this.m_OleDbRxConn.CreateCommand(); this.m_OleDbCommand.CommandText = strSQL; this.m_OleDbDataAdapter.SelectCommand = this.m_OleDbCommand; this.m_OleDbDataAdapter.Fill(this.m_DataSet, this.strRxPackageTableName); if (this.m_DataSet.Tables[this.strRxPackageTableName].Rows.Count == 0) { strDeleteSQL[intArrayCount] = "DELETE FROM scenario_last_tiebreak_rank" + " WHERE scenario_id = '" + this.strScenarioId + "'" + " AND rxpackage = '" + p_ado.m_OleDbDataReader["rxpackage"] + "';"; intArrayCount++; } this.m_DataSet.Tables.Clear(); } p_ado.m_OleDbDataReader.Close(); this.m_DataSet.Dispose(); this.m_OleDbDataAdapter.Dispose(); /********************************************************************************** **if there were any treatments that were loaded into sql delete **arrays then perform the sql to delete the treatments out of the table **********************************************************************************/ if (intArrayCount > 0) { for (x = 0; x <= intArrayCount - 1; x++) { p_ado.SqlNonQuery(this.m_OleDbConnectionScenario, strDeleteSQL[x].ToString()); } } } /*************************************************************************************** **okay, now that the table has been validated and updated lets load the grid to **display the treatments to the user ***************************************************************************************/ this.m_DataSet = new System.Data.DataSet(); this.m_OleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(); this.m_OleDbCommand = this.m_OleDbRxConn.CreateCommand(); this.m_OleDbCommand.CommandText = "select * from " + this.strRxPackageTableName; this.m_OleDbDataAdapter.SelectCommand = this.m_OleDbCommand; this.m_OleDbDataAdapter.Fill(this.m_DataSet, this.strRxPackageTableName); this.m_OleDbCommand = this.m_OleDbConnectionScenario.CreateCommand(); strSQL = ""; for (x = 0; x <= this.m_DataSet.Tables[this.strRxPackageTableName].Rows.Count - 1; x++) { if (this.m_DataSet.Tables[this.strRxPackageTableName].Rows[x]["rxpackage"].ToString().Length > 0) { strSQL = "select scenario_id,rxpackage,last_tiebreak_rank from scenario_last_tiebreak_rank where scenario_id = '" + this.strScenarioId + "';"; break; } } /************************************************************ **if no records in the master prescription table then return ************************************************************/ if (strSQL.Length == 0) { this.m_DataSet.Clear(); this.m_DataSet.Dispose(); this.m_OleDbDataAdapter.Dispose(); this.m_OleDbCommand.Dispose(); this.m_OleDbConnectionScenario.Close(); this.m_OleDbConnectionScenario = null; this.m_OleDbRxConn.Close(); this.m_OleDbRxConn = null; return; } /******************************* **create the data sets *******************************/ this.m_OleDbCommand = this.m_OleDbConnectionScenario.CreateCommand(); this.m_OleDbCommand.CommandText = "select scenario_id,rxpackage,last_tiebreak_rank from scenario_last_tiebreak_rank where scenario_id = '" + this.strScenarioId + "';"; this.m_OleDbDataAdapter.SelectCommand = this.m_OleDbCommand; this.m_OleDbDataAdapter.Fill(this.m_DataSet, "scenario_last_tiebreak_rank"); /***************************************************************************** **add the description column to the scenario last tiebreak rank dataset *****************************************************************************/ this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Columns.Add("Description"); /******************************************************************************** **add the treatment description value to the scenrario rx last tiebreak rank data set. **the description is only in the master rx table and is added to the **scenario last tiebreak rank data set for information purposes. ********************************************************************************/ /*********************************************************************************** **for loop through the master db rx dataset adding the description field to the **scenenario db scenario_last_tiebreak_rank dataset ***********************************************************************************/ for (x = 0; x <= this.m_DataSet.Tables[this.strRxPackageTableName].Rows.Count - 1; x++) { if (this.m_DataSet.Tables[this.strRxPackageTableName].Rows[x]["rxpackage"].ToString().Length > 0) { /*************************************************************************************** **build the expression to filter only the scenario row that meets the expression ***************************************************************************************/ strSQL = "rxpackage = '" + this.m_DataSet.Tables[this.strRxPackageTableName].Rows[x]["rxpackage"] + "'"; /*************************************************************************************** **create a datarow that will hold the results from the query expression ***************************************************************************************/ System.Data.DataRow[] dr1; dr1 = this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Select(strSQL); /*************************************************************************************** **check to see if it found the master rx treatment in the sceanrio last tiebreak rank dataset ***************************************************************************************/ if (dr1.Length != 0) { /*************************************************************************************** **it found it, loop through the dataset and find the row that matches the row **returned from the search expression ***************************************************************************************/ for (int y = 0; y <= this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Rows.Count - 1; y++) { if (dr1[0]["rxpackage"] == this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Rows[y]["rxpackage"]) { /********************************************************************************** **update the description row/column with the master db rx table description value **********************************************************************************/ this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Rows[y]["description"] = this.m_DataSet.Tables[this.strRxPackageTableName].Rows[x]["description"]; break; } } this.m_DataSet.Tables["scenario_last_tiebreak_rank"].AcceptChanges(); } } } /************************************************************************************************** **place the dataset table into a view class so as to not allow new records to be appended **************************************************************************************************/ DataView firstView = new DataView(this.m_DataSet.Tables["scenario_last_tiebreak_rank"]); firstView.AllowNew = false; //cannot append new records firstView.AllowDelete = false; //cannot delete records /*************************************************************** **custom define the grid style ***************************************************************/ DataGridTableStyle tableStyle = new DataGridTableStyle(); /*********************************************************************** **map the data grid table style to the last tiebreak rank dataset ***********************************************************************/ tableStyle.MappingName = "scenario_last_tiebreak_rank"; tableStyle.AlternatingBackColor = frmMain.g_oGridViewAlternateRowBackgroundColor; tableStyle.BackColor = frmMain.g_oGridViewRowBackgroundColor; tableStyle.ForeColor = frmMain.g_oGridViewRowForegroundColor; tableStyle.SelectionBackColor = frmMain.g_oGridViewSelectedRowBackgroundColor; /****************************************************************************** **since the dataset has things like field name and number of columns, **we will use those to create new columnstyles for the columns in our grid ******************************************************************************/ //get the number of columns from the scenario_last_tiebreak_rank data set int numCols = this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Columns.Count; /*********************************************************************************** **assign the aColumnTextColumn as type DataGridColoredTextBoxColumn object class ***********************************************************************************/ DataGridColoredTextBoxColumn aColumnTextColumn; //loop through all the columns in the dataset for (int i = 0; i < numCols; ++i) { //create a new instance of the DataGridColoredTextBoxColumn class aColumnTextColumn = new DataGridColoredTextBoxColumn(); aColumnTextColumn.HeaderText = this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Columns[i].ColumnName; //all columns are read-only except the last_tiebreak_rank column if (aColumnTextColumn.HeaderText != "last_tiebreak_rank") { aColumnTextColumn.ReadOnly = true; } //assign the mappingname property the data sets column name aColumnTextColumn.MappingName = this.m_DataSet.Tables["scenario_last_tiebreak_rank"].Columns[i].ColumnName; //add the datagridcoloredtextboxcolumn object to the data grid table style object tableStyle.GridColumnStyles.Add(aColumnTextColumn); //set wider width for some columns switch (aColumnTextColumn.HeaderText) { case "scenario_id": aColumnTextColumn.Width = 150; break; case "Description": aColumnTextColumn.Width = 475; break; } } dataGrid1.BackgroundColor = frmMain.g_oGridViewBackgroundColor; dataGrid1.BackColor = frmMain.g_oGridViewRowBackgroundColor; if (frmMain.g_oGridViewFont != null) { dataGrid1.Font = frmMain.g_oGridViewFont; } // make the dataGrid use our new tablestyle and bind it to our table this.dataGrid1.TableStyles.Clear(); this.dataGrid1.TableStyles.Add(tableStyle); // If this is a copied scenario, we will have a reference form to get the values if (p_bScenarioCopy == true) { if (ReferenceOptimizerScenarioForm.m_oOptimizerScenarioItem_Collection.Item(0).m_oLastTieBreakRankItem_Collection != null) { OptimizerScenarioItem.LastTieBreakRankItem_Collection oLastTieBreakRankItem_Collection = ReferenceOptimizerScenarioForm.m_oOptimizerScenarioItem_Collection.Item(0).m_oLastTieBreakRankItem_Collection; for (int i = 0; i < firstView.Count - 1; ++i) { for (x = 0; x <= oLastTieBreakRankItem_Collection.Count - 1; x++) { if (oLastTieBreakRankItem_Collection.Item(x).RxPackage.Equals(firstView[i]["rxpackage"])) { firstView[i]["last_tiebreak_rank"] = oLastTieBreakRankItem_Collection.Item(x).LastTieBreakRank; } } } } } this.dataGrid1.DataSource = firstView; this.dataGrid1.Expand(-1); } }
public void loadvalues(bool p_bScenarioCopy) { int x; ProcessorScenarioTools oTools = new ProcessorScenarioTools(); //Reset m_oProcessorScenarioItem_Collection so we don't get duplicates when we loadAll down below m_oProcessorScenarioItem_Collection = new ProcessorScenarioItem_Collection(); lvProcessorScenario.Items.Clear(); System.Windows.Forms.ListViewItem entryListItem = null; this.m_oLvAlternateColors.InitializeRowCollection(); this.m_oLvAlternateColors.ReferenceAlternateBackgroundColor = frmMain.g_oGridViewAlternateRowBackgroundColor; this.m_oLvAlternateColors.ReferenceAlternateForegroundColor = frmMain.g_oGridViewRowForegroundColor; this.m_oLvAlternateColors.ReferenceBackgroundColor = frmMain.g_oGridViewRowBackgroundColor; this.m_oLvAlternateColors.ReferenceForegroundColor = frmMain.g_oGridViewRowForegroundColor; this.m_oLvAlternateColors.ReferenceSelectedRowBackgroundColor = frmMain.g_oGridViewSelectedRowBackgroundColor; this.m_oLvAlternateColors.ReferenceListView = this.lvProcessorScenario; this.m_oLvAlternateColors.CustomFullRowSelect = true; if (frmMain.g_oGridViewFont != null) { this.lvProcessorScenario.Font = frmMain.g_oGridViewFont; } ado_data_access oAdo = new ado_data_access(); string strProcessorScenario = ""; string strFullDetailsYN = "N"; if (p_bScenarioCopy == false) { string[] strScenarioArray = null; if (!ReferenceOptimizerScenarioForm.m_bProcessorUsingSqlite) { strScenarioArray = loadScenarioArray(oAdo); } else { strScenarioArray = loadScenarioArraySqlite(); } if (strScenarioArray == null) { return; } for (x = 0; x <= strScenarioArray.Length - 1; x++) { // //LOAD PROJECT DATATASOURCES INFO // m_oQueries.m_oFvs.LoadDatasource = true; m_oQueries.m_oFIAPlot.LoadDatasource = true; m_oQueries.m_oProcessor.LoadDatasource = true; m_oQueries.m_oReference.LoadDatasource = true; m_oQueries.LoadDatasources(true, ReferenceOptimizerScenarioForm.m_bProcessorUsingSqlite, "processor", strScenarioArray[x]); if (!ReferenceOptimizerScenarioForm.m_bProcessorUsingSqlite) { m_oQueries.m_oDataSource.CreateScenarioRuleDefinitionTableLinks( m_oQueries.m_strTempDbFile, frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim(), "P"); oTools.LoadAll(m_oQueries.m_strTempDbFile, m_oQueries, strScenarioArray[x], m_oProcessorScenarioItem_Collection); } else { oTools.LoadAllSqlite(m_oQueries, strScenarioArray[x], m_oProcessorScenarioItem_Collection); } } } else { foreach (ProcessorScenarioItem psItem in ReferenceOptimizerScenarioForm.m_oOptimizerScenarioItem.m_oProcessorScenarioItem_Collection) { m_oProcessorScenarioItem_Collection.Add(psItem); if (psItem.Selected == true) { strProcessorScenario = psItem.ScenarioId; strFullDetailsYN = psItem.DisplayFullDetailsYN; } } } for (x = 0; x <= m_oProcessorScenarioItem_Collection.Count - 1; x++) { entryListItem = lvProcessorScenario.Items.Add(" "); entryListItem.UseItemStyleForSubItems = false; this.m_oLvAlternateColors.AddRow(); this.m_oLvAlternateColors.AddColumns(x, lvProcessorScenario.Columns.Count); entryListItem.SubItems.Add(m_oProcessorScenarioItem_Collection.Item(x).ScenarioId); entryListItem.SubItems.Add(m_oProcessorScenarioItem_Collection.Item(x).Description); } this.m_oLvAlternateColors.ListView(); if (p_bScenarioCopy == false) { string strScenarioMDB = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + Tables.OptimizerScenarioRuleDefinitions.DefaultScenarioTableDbFile; string strConn = oAdo.getMDBConnString(strScenarioMDB, "", ""); oAdo.OpenConnection(strConn); if (oAdo.TableExist(oAdo.m_OleDbConnection, Tables.OptimizerScenarioRuleDefinitions.DefaultScenarioProcessorScenarioSelectTableName)) { oAdo.m_strSQL = "SELECT * FROM " + Tables.OptimizerScenarioRuleDefinitions.DefaultScenarioProcessorScenarioSelectTableName + " " + "WHERE TRIM(UCASE(scenario_id)) = '" + ReferenceOptimizerScenarioForm.uc_scenario1.txtScenarioId.Text.Trim().ToUpper() + "';"; oAdo.SqlQueryReader(oAdo.m_OleDbConnection, oAdo.m_strSQL); if (oAdo.m_OleDbDataReader.HasRows) { while (oAdo.m_OleDbDataReader.Read()) { if (oAdo.m_OleDbDataReader["processor_scenario_id"] != System.DBNull.Value && oAdo.m_OleDbDataReader["processor_scenario_id"].ToString().Trim().Length > 0) { strProcessorScenario = oAdo.m_OleDbDataReader["processor_scenario_id"].ToString().Trim(); } if (oAdo.m_OleDbDataReader["FullDetailsYN"] != System.DBNull.Value && oAdo.m_OleDbDataReader["FullDetailsYN"].ToString().Trim().Length > 0) { strFullDetailsYN = oAdo.m_OleDbDataReader["FullDetailsYN"].ToString().Trim(); } } } oAdo.m_OleDbDataReader.Close(); oAdo.CloseConnection(oAdo.m_OleDbConnection); } else { frmMain.g_oTables.m_oOptimizerScenarioRuleDef.CreateScenarioProcessorScenarioSelectTable(oAdo, oAdo.m_OleDbConnection, Tables.OptimizerScenarioRuleDefinitions.DefaultScenarioProcessorScenarioSelectTableName); } } if (lvProcessorScenario.Items.Count > 0) { for (x = 0; x <= lvProcessorScenario.Items.Count - 1; x++) { if (lvProcessorScenario.Items[x].SubItems[COL_SCENARIOID].Text.Trim().ToUpper() == strProcessorScenario.ToUpper()) { lvProcessorScenario.Items[x].Checked = true; for (int y = 0; y <= ReferenceOptimizerScenarioForm.uc_scenario_processor_scenario_select1.m_oProcessorScenarioItem_Collection.Count - 1; y++) { if (lvProcessorScenario.Items[x].SubItems[COL_SCENARIOID].Text.Trim().ToUpper() == ReferenceOptimizerScenarioForm.uc_scenario_processor_scenario_select1.m_oProcessorScenarioItem_Collection.Item(y).ScenarioId.Trim().ToUpper()) { ReferenceOptimizerScenarioForm.uc_scenario_cond_filter1.strLowSlope = ReferenceOptimizerScenarioForm.uc_scenario_processor_scenario_select1.m_oProcessorScenarioItem_Collection.Item(y).m_oHarvestMethod.SteepSlopePercent; ReferenceOptimizerScenarioForm.uc_scenario_cond_filter1.strSteepSlope = ReferenceOptimizerScenarioForm.uc_scenario_processor_scenario_select1.m_oProcessorScenarioItem_Collection.Item(y).m_oHarvestMethod.SteepSlopePercent; } } break; } } if (x <= lvProcessorScenario.Items.Count - 1) { lvProcessorScenario.Items[0].Selected = true; } } if (strFullDetailsYN == "Y") { chkFullDetails.Checked = true; } else { chkFullDetails.Checked = false; } }
public void LoadDataSourceTablesFromListBox(string strScenarioMDB, string strScenarioId, System.Windows.Forms.ListBox listBox1, string strDestinationLinkMDB) { string strSQL = ""; string strFullPathMDB = ""; string strConn = ""; int x = 0; int y = 0; bool lLoaded = false; this.m_intError = 0; this.m_intNumberOfOptimizerTables = this.getNumberOfOptimizerTables(strScenarioMDB, strScenarioId); //ado specific routines class ado_data_access p_ado = new ado_data_access(); //connect to mdb file containing data sources this.m_OleDbConnectionScenario = new System.Data.OleDb.OleDbConnection(); strConn = p_ado.getMDBConnString(strScenarioMDB, "admin", ""); p_ado.OpenConnection(strConn, ref this.m_OleDbConnectionScenario); if (p_ado.m_intError != 0) { this.m_intError = p_ado.m_intError; p_ado = null; return; } //go through each of the items in the listbox for (y = 0; y <= listBox1.Items.Count - 1; y++) { lLoaded = false; //see if the listbox item is already loaded into a dataset table and the linked mdb table if (this.m_intNumberOfOptimizerTablesLoaded != 0) { for (x = 0; x <= this.m_intNumberOfOptimizerTables - 1; x++) { if (this.m_strOptimizerTables[x].Trim().Length > 0) { if (listBox1.Items[y].ToString().Trim().ToLower() == this.m_strOptimizerTables[x].Trim().ToLower()) { lLoaded = true; break; } } } } if (lLoaded == false) { //query the MDB datasource table for Optimizer table names strSQL = "SELECT path, file,table_name FROM scenario_datasource WHERE " + " scenario_id = '" + strScenarioId + "' AND " + " table_name = '" + listBox1.Items[y] + "';"; p_ado.SqlQueryReader(this.m_OleDbConnectionScenario, strSQL); if (p_ado.m_intError == 0) { //read the record while (p_ado.m_OleDbDataReader.Read()) { //look to make sure we have the correct record if (listBox1.Items[y].ToString().Trim().ToUpper() == p_ado.m_OleDbDataReader["table_name"].ToString().Trim().ToUpper()) { strFullPathMDB = p_ado.m_OleDbDataReader["path"].ToString().Trim() + "\\" + p_ado.m_OleDbDataReader["file"].ToString().Trim(); if (System.IO.File.Exists(strFullPathMDB) == true) { //used to create a link to the table dao_data_access p_dao = new dao_data_access(); //create a link to the table in an mdb file p_dao.CreateTableLink(strDestinationLinkMDB, listBox1.Items[y].ToString().Trim(), strFullPathMDB, listBox1.Items[y].ToString().Trim()); p_dao = null; //connect to mdb file that will be used as the master table link file this.m_connMasterLink = new System.Data.OleDb.OleDbConnection(); strConn = p_ado.getMDBConnString(strDestinationLinkMDB, "admin", ""); p_ado.OpenConnection(strConn, ref this.m_connMasterLink); strSQL = "SELECT * FROM " + p_ado.m_OleDbDataReader["table_name"]; this.m_OleDbDataAdapter.SelectCommand = new System.Data.OleDb.OleDbCommand(strSQL, this.m_connMasterLink); try { this.m_OleDbDataAdapter.Fill(this.m_dsOptimizerTables, p_ado.m_OleDbDataReader["table_name"].ToString().Trim()); } catch (Exception e) { MessageBox.Show(e.Message, "Table", MessageBoxButtons.OK, MessageBoxIcon.Error); this.m_intError = -1; } this.m_strOptimizerTables[this.m_intNumberOfOptimizerTablesLoaded] = p_ado.m_OleDbDataReader["table_name"].ToString().Trim(); this.m_intNumberOfOptimizerTablesLoaded++; this.m_connMasterLink.Close(); this.m_connMasterLink = null; } else { MessageBox.Show(strFullPathMDB + " does not exist", "Scenario Data Source"); this.m_intError = -1; p_ado.m_OleDbDataReader.Close(); this.m_OleDbConnection.Close(); p_ado.m_OleDbCommand = null; p_ado.m_OleDbDataReader = null; p_ado = null; this.m_dsOptimizerTables.Clear(); this.m_dsOptimizerTables = null; this.m_OleDbDataAdapter.Dispose(); this.m_OleDbDataAdapter = null; return; } } } p_ado.m_OleDbDataReader.Close(); } } } p_ado.m_OleDbDataReader = null; p_ado.m_OleDbCommand = null; p_ado = null; this.m_OleDbConnectionScenario.Close(); }
public void SaveScenarioProperties() { bool bOptimizer; string strDesc = ""; string strSQL = ""; System.Text.StringBuilder strFullPath; m_intError = 0; //validate the input // //Optimization id // if (this.txtScenarioId.Text.Length == 0) { MessageBox.Show("Enter A Unique Optimization scenario Id"); this.txtScenarioId.Focus(); m_intError = -1; return; } // //check for duplicate scenario id // System.Data.OleDb.OleDbConnection oConn = new System.Data.OleDb.OleDbConnection(); string strProjDir = frmMain.g_oFrmMain.getProjectDirectory(); string strScenarioDir = strProjDir + "\\" + ScenarioType + "\\db"; string strFile = "scenario_" + ScenarioType + "_rule_definitions.mdb"; strFullPath = new System.Text.StringBuilder(strScenarioDir); strFullPath.Append("\\"); strFullPath.Append(strFile); ado_data_access oAdo = new ado_data_access(); string strConn = oAdo.getMDBConnString(strFullPath.ToString(), "admin", ""); oAdo.SqlQueryReader(strConn, "select scenario_id from scenario"); if (oAdo.m_OleDbDataReader.HasRows) { while (oAdo.m_OleDbDataReader.Read()) { if (oAdo.m_OleDbDataReader["scenario_id"] != System.DBNull.Value) { if (this.txtScenarioId.Text.Trim().ToUpper() == Convert.ToString(oAdo.m_OleDbDataReader["scenario_id"]).Trim().ToUpper()) { this.m_intError = -1; MessageBox.Show("Cannot have a duplicate Optimization scenario id"); oAdo.m_OleDbDataReader.Close(); oAdo.m_OleDbDataReader = null; oAdo = null; this.txtScenarioId.Focus(); return; } } } } else { } oAdo.m_OleDbDataReader.Close(); oAdo.m_OleDbDataReader = null; // //create the scenario path if it does not exist and //copy the scenario_results.mdb to it // try { if (!System.IO.Directory.Exists(this.txtScenarioPath.Text)) { System.IO.Directory.CreateDirectory(this.txtScenarioPath.Text); System.IO.Directory.CreateDirectory(this.txtScenarioPath.Text.ToString() + "\\db"); //copy default processor scenario_results database to the new project directory if (this.ScenarioType == "processor") { dao_data_access oDao = new dao_data_access(); string strDestFile = this.txtScenarioPath.Text + "\\" + Tables.ProcessorScenarioRun.DefaultHarvestCostsTableDbFile; oDao.CreateMDB(strDestFile); oDao.m_DaoWorkspace.Close(); oDao = null; string strScenarioResultsConn = oAdo.getMDBConnString(strDestFile, "", ""); System.Data.OleDb.OleDbConnection OleDbScenarioResultsConn = new System.Data.OleDb.OleDbConnection(); oAdo.OpenConnection(strScenarioResultsConn, ref OleDbScenarioResultsConn); frmMain.g_oTables.m_oProcessor.CreateHarvestCostsTable( oAdo, OleDbScenarioResultsConn, Tables.ProcessorScenarioRun.DefaultHarvestCostsTableName); frmMain.g_oTables.m_oProcessor.CreateTreeVolValSpeciesDiamGroupsTable( oAdo, OleDbScenarioResultsConn, Tables.ProcessorScenarioRun.DefaultTreeVolValSpeciesDiamGroupsTableName); OleDbScenarioResultsConn.Close(); OleDbScenarioResultsConn.Dispose(); } } } catch { MessageBox.Show("Error Creating Folder"); m_intError = -1; return; } // //copy the project data source values to the scenario data source // string strProjDBDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\db"; string strProjFile = "project.mdb"; StringBuilder strProjFullPath = new StringBuilder(strProjDBDir); strProjFullPath.Append("\\"); strProjFullPath.Append(strProjFile); string strProjConn = oAdo.getMDBConnString(strProjFullPath.ToString(), "admin", ""); System.Data.OleDb.OleDbConnection p_OleDbProjConn = new System.Data.OleDb.OleDbConnection(); oAdo.OpenConnection(strProjConn, ref p_OleDbProjConn); string strScenarioDBDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\db"; string strScenarioFile = "scenario_" + ScenarioType + "_rule_definitions.mdb"; StringBuilder strScenarioFullPath = new StringBuilder(strScenarioDBDir); strScenarioFullPath.Append("\\"); strScenarioFullPath.Append(strScenarioFile); string strScenarioConn = oAdo.getMDBConnString(strScenarioFullPath.ToString(), "admin", ""); oAdo.OpenConnection(strScenarioConn); if (oAdo.m_intError == 0) { if (this.txtDescription.Text.Trim().Length > 0) { strDesc = oAdo.FixString(this.txtDescription.Text.Trim(), "'", "''"); } strSQL = "INSERT INTO scenario (scenario_id,description,Path,File) VALUES " + "('" + this.txtScenarioId.Text.Trim() + "'," + "'" + strDesc + "'," + "'" + this.txtScenarioPath.Text.Trim() + "','scenario_" + ScenarioType + "_rule_definitions.mdb');"; oAdo.SqlNonQuery(oAdo.m_OleDbConnection, strSQL); oAdo.SqlQueryReader(p_OleDbProjConn, "select * from datasource"); if (oAdo.m_intError == 0) { try { while (oAdo.m_OleDbDataReader.Read()) { bOptimizer = false; switch (oAdo.m_OleDbDataReader["table_type"].ToString().Trim().ToUpper()) { case "PLOT": bOptimizer = true; break; case "CONDITION": bOptimizer = true; break; //case "FIRE AND FUEL EFFECTS": // bCore = true; // break; //case "HARVEST COSTS": // bCore = true; // break; case "ADDITIONAL HARVEST COSTS": bOptimizer = true; break; case "TREATMENT PRESCRIPTIONS": bOptimizer = true; break; //case "TREE VOLUMES AND VALUES BY SPECIES AND DIAMETER GROUPS": // bCore = true; // break; case "TRAVEL TIMES": bOptimizer = true; break; case "PROCESSING SITES": bOptimizer = true; break; //case "TREE SPECIES AND DIAMETER GROUPS DOLLAR VALUES": // bCore = true; // break; case "PLOT AND CONDITION RECORD AUDIT": if (ScenarioType == "optimizer") { bOptimizer = true; } break; case "PLOT, CONDITION AND TREATMENT RECORD AUDIT": if (ScenarioType == "optimizer") { bOptimizer = true; } break; case "TREE": if (ScenarioType == "processor") { bOptimizer = true; } break; case "HARVEST METHODS": if (ScenarioType == "processor") { bOptimizer = true; } break; case "TREATMENT PACKAGES": bOptimizer = true; break; //case "FVS TREE LIST FOR PROCESSOR": // if (ScenarioType=="processor") bCore=true; // break; case "TREE SPECIES": if (ScenarioType == "processor") { bOptimizer = true; } break; case "TREATMENT PRESCRIPTIONS HARVEST COST COLUMNS": if (ScenarioType == "processor") { bOptimizer = true; } break; case "FIA TREE SPECIES REFERENCE": if (ScenarioType == "processor") { bOptimizer = true; } break; default: break; } if (bOptimizer == true) { strSQL = "INSERT INTO scenario_datasource (scenario_id,table_type,Path,file,table_name) VALUES " + "('" + this.txtScenarioId.Text.Trim() + "'," + "'" + oAdo.m_OleDbDataReader["table_type"].ToString().Trim() + "'," + "'" + oAdo.m_OleDbDataReader["path"].ToString().Trim() + "'," + "'" + oAdo.m_OleDbDataReader["file"].ToString().Trim() + "'," + "'" + oAdo.m_OleDbDataReader["table_name"].ToString().Trim() + "');"; oAdo.SqlNonQuery(oAdo.m_OleDbConnection, strSQL); } } } catch (Exception caught) { m_intError = -1; m_strError = caught.Message; MessageBox.Show(strError); } oAdo.m_OleDbDataReader.Close(); oAdo.m_OleDbDataReader = null; oAdo.m_OleDbCommand = null; p_OleDbProjConn.Close(); p_OleDbProjConn = null; } if (ScenarioType.Trim().ToUpper() == "OPTIMIZER") { string strTemp = oAdo.FixString("SELECT @@PlotTable@@.* FROM @@PlotTable@@ WHERE @@PlotTable@@.plot_accessible_yn='Y'", "'", "''"); strSQL = "INSERT INTO scenario_plot_filter (scenario_id,sql_command,current_yn) VALUES " + "('" + this.txtScenarioId.Text.Trim() + "'," + "'" + strTemp + "'," + "'Y');"; oAdo.SqlNonQuery(oAdo.m_OleDbConnection, strSQL); strTemp = oAdo.FixString("SELECT @@CondTable@@.* FROM @@CondTable@@", "'", "''"); strSQL = "INSERT INTO scenario_cond_filter (scenario_id,sql_command,current_yn) VALUES " + "('" + this.txtScenarioId.Text.Trim() + "'," + "'" + strTemp + "'," + "'Y');"; oAdo.SqlNonQuery(oAdo.m_OleDbConnection, strSQL); } } oAdo.m_OleDbConnection.Close(); oAdo.m_OleDbConnection = null; oAdo = null; }
public void loadvalues(ProcessorScenarioItem oProcItem) { this.lstRxPackages.Clear(); this.m_oLvRowColors.InitializeRowCollection(); this.lstRxPackages.Columns.Add("", 2, HorizontalAlignment.Left); this.lstRxPackages.Columns.Add("Variant", 75, HorizontalAlignment.Left); this.lstRxPackages.Columns.Add("Package", 300, HorizontalAlignment.Left); this.lstRxPackages.Columns[COLUMN_CHECKBOX].Width = -2; // Create an instance of a ListView column sorter and assign it // to the ListView control. lvwColumnSorter = new ListViewColumnSorter(); this.lstRxPackages.ListViewItemSorter = lvwColumnSorter; m_oEnv = new env(); ado_data_access oAdo = new ado_data_access(); if (String.IsNullOrEmpty(oProcItem.ScenarioId)) { return; } string[] arr1 = new string[] { "PLOT" }; string strPlotTableName = ""; object oValue = frmMain.g_oDelegate.GetValueExecuteControlMethodWithParam(ReferenceOptimizerScenarioForm.uc_datasource1, "getDataSourceTableName", arr1, true); if (oValue != null) { string strValue = Convert.ToString(oValue); if (strValue != "false") { strPlotTableName = strValue; } } string strHarvestCostsPathAndFile = oProcItem.DbPath + "\\" + Tables.ProcessorScenarioRun.DefaultHarvestCostsTableDbFile; arr1 = new string[] { "CONDITION" }; string strCondTableName = ""; oValue = frmMain.g_oDelegate.GetValueExecuteControlMethodWithParam(ReferenceOptimizerScenarioForm.uc_datasource1, "getDataSourceTableName", arr1, true); if (oValue != null) { string strValue = Convert.ToString(oValue); if (strValue != "false") { strCondTableName = strValue; } } /************************************************************** **create a temporary MDB File that will contain table links **to the cond, plot, and harvest_costs tables **************************************************************/ dao_data_access p_dao = new dao_data_access(); if (System.IO.File.Exists(strHarvestCostsPathAndFile) && p_dao.TableExists(strHarvestCostsPathAndFile, Tables.ProcessorScenarioRun.DefaultHarvestCostsTableName)) { this.m_strTempMDBFile = this.ReferenceOptimizerScenarioForm.uc_datasource1.CreateMDBAndScenarioTableDataSourceLinks(m_oEnv.strTempDir); p_dao.CreateTableLink(this.m_strTempMDBFile, Tables.ProcessorScenarioRun.DefaultHarvestCostsTableName, strHarvestCostsPathAndFile, Tables.ProcessorScenarioRun.DefaultHarvestCostsTableName); p_dao = null; string strTempConn = oAdo.getMDBConnString(this.m_strTempMDBFile, "", ""); using (var oConn = new OleDbConnection(strTempConn)) { oConn.Open(); oAdo.m_strSQL = "SELECT DISTINCT plot.fvs_variant, harvest_costs.rxpackage, Count(*) AS [Count]" + " FROM (" + strCondTableName + " INNER JOIN " + strPlotTableName + " ON " + strCondTableName + ".biosum_plot_id = " + strPlotTableName + ".biosum_plot_id) " + " INNER JOIN " + Tables.ProcessorScenarioRun.DefaultHarvestCostsTableName + " ON " + strCondTableName + ".biosum_cond_id = " + Tables.ProcessorScenarioRun.DefaultHarvestCostsTableName + ".biosum_cond_id" + " GROUP BY FVS_VARIANT, RXPACKAGE"; oAdo.SqlQueryReader(oConn, oAdo.m_strSQL); if (oAdo.m_OleDbDataReader.HasRows == true) { while (oAdo.m_OleDbDataReader.Read()) { if (oAdo.m_OleDbDataReader["fvs_variant"] != System.DBNull.Value) { //null column this.lstRxPackages.Items.Add(" "); this.lstRxPackages.Items[lstRxPackages.Items.Count - 1].UseItemStyleForSubItems = false; this.lstRxPackages.Items[lstRxPackages.Items.Count - 1].Checked = true; this.m_oLvRowColors.AddRow(); this.m_oLvRowColors.AddColumns(lstRxPackages.Items.Count - 1, lstRxPackages.Columns.Count); //fvs_variant this.lstRxPackages.Items[lstRxPackages.Items.Count - 1].SubItems.Add(Convert.ToString(oAdo.m_OleDbDataReader["fvs_variant"])); this.m_oLvRowColors.ListViewSubItem(lstRxPackages.Items.Count - 1, COLUMN_FVS_VARIANT, lstRxPackages.Items[lstRxPackages.Items.Count - 1].SubItems[COLUMN_FVS_VARIANT], false); // rxPackage if (oAdo.m_OleDbDataReader["rxpackage"] != System.DBNull.Value) { this.lstRxPackages.Items[this.lstRxPackages.Items.Count - 1].SubItems.Add(oAdo.m_OleDbDataReader["rxpackage"].ToString()); } else { this.lstRxPackages.Items[this.lstRxPackages.Items.Count - 1].SubItems.Add(" "); } this.m_oLvRowColors.ListViewSubItem(lstRxPackages.Items.Count - 1, COLUMN_RXPACKAGE, lstRxPackages.Items[lstRxPackages.Items.Count - 1].SubItems[COLUMN_RXPACKAGE], false); } } } oAdo.m_OleDbDataReader.Close(); } } }
public void loadvalues() { int x; lvProcessorScenario.Items.Clear(); System.Windows.Forms.ListViewItem entryListItem = null; this.m_oLvAlternateColors.InitializeRowCollection(); this.m_oLvAlternateColors.ReferenceAlternateBackgroundColor = frmMain.g_oGridViewAlternateRowBackgroundColor; this.m_oLvAlternateColors.ReferenceAlternateForegroundColor = frmMain.g_oGridViewRowForegroundColor; this.m_oLvAlternateColors.ReferenceBackgroundColor = frmMain.g_oGridViewRowBackgroundColor; this.m_oLvAlternateColors.ReferenceForegroundColor = frmMain.g_oGridViewRowForegroundColor; this.m_oLvAlternateColors.ReferenceSelectedRowBackgroundColor = frmMain.g_oGridViewSelectedRowBackgroundColor; this.m_oLvAlternateColors.ReferenceListView = this.lvProcessorScenario; this.m_oLvAlternateColors.CustomFullRowSelect = true; if (frmMain.g_oGridViewFont != null) { this.lvProcessorScenario.Font = frmMain.g_oGridViewFont; } // //OPEN CONNECTION TO DB FILE CONTAINING Processor Scenario TABLE // //scenario mdb connection string strProcessorScenarioMDB = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\processor\\db\\scenario_processor_rule_definitions.mdb"; // //get a list of all the scenarios // ado_data_access oAdo = new ado_data_access(); oAdo.OpenConnection(oAdo.getMDBConnString(strProcessorScenarioMDB, "", "")); oAdo.SqlQueryReader(oAdo.m_OleDbConnection, "SELECT scenario_id,description " + "FROM scenario " + "WHERE scenario_id IS NOT NULL AND " + "LEN(TRIM(scenario_id)) > 0"); x = 0; if (oAdo.m_OleDbDataReader.HasRows) { while (oAdo.m_OleDbDataReader.Read()) { if (oAdo.m_OleDbDataReader["scenario_id"] != DBNull.Value && oAdo.m_OleDbDataReader["scenario_id"].ToString().Trim().Length > 0 && ReferenceCurrentScenarioItem.ScenarioId.Trim().ToUpper() != oAdo.m_OleDbDataReader["scenario_id"].ToString().Trim().ToUpper()) { entryListItem = lvProcessorScenario.Items.Add(" "); entryListItem.UseItemStyleForSubItems = false; this.m_oLvAlternateColors.AddRow(); this.m_oLvAlternateColors.AddColumns(x, lvProcessorScenario.Columns.Count); entryListItem.SubItems.Add(oAdo.m_OleDbDataReader["scenario_id"].ToString().Trim()); if (oAdo.m_OleDbDataReader["description"] != DBNull.Value && oAdo.m_OleDbDataReader["description"].ToString().Trim().Length > 0) { entryListItem.SubItems.Add(oAdo.m_OleDbDataReader["description"].ToString().Trim()); } else { entryListItem.SubItems.Add(" "); } x = x + 1; } } this.m_oLvAlternateColors.ListView(); } else { MessageBox.Show("!!No Scenarios To Copy!!", "FIA Bisoum"); btnCopy.Enabled = false; } oAdo.m_OleDbDataReader.Close(); oAdo.CloseConnection(oAdo.m_OleDbConnection); }
public void LoadDataSourceTables(string strScenarioMDB, string strScenarioId) { string strSQL = ""; string strFullPathMDB = ""; string strConn = ""; ado_data_access p_ado = new ado_data_access(); this.m_OleDbConnectionScenario = new System.Data.OleDb.OleDbConnection(); strConn = p_ado.getMDBConnString(strScenarioMDB, "admin", ""); p_ado.OpenConnection(strConn, ref this.m_OleDbConnectionScenario); if (p_ado.m_intError != 0) { p_ado = null; return; } strSQL = "SELECT table_name FROM scenario_datasource WHERE " + " scenario_id = '" + strScenarioId + "';"; p_ado.SqlQueryReader(this.m_OleDbConnectionScenario, strSQL); if (p_ado.m_intError == 0) { this.m_OleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(); this.m_dsOptimizerTables = new DataSet(); this.m_OleDbCommand = new System.Data.OleDb.OleDbCommand(); this.m_dsOptimizerTables.DataSetName = "LoadAllRecordsFromScenarioDataSource"; while (p_ado.m_OleDbDataReader.Read()) { if (p_ado.m_OleDbDataReader["table_name"] != System.DBNull.Value) { if (p_ado.m_OleDbDataReader["table_name"].ToString().Trim().Length > 0) { if (p_ado.m_OleDbDataReader["table_name"].ToString().Trim().ToUpper() == "PLOT" || p_ado.m_OleDbDataReader["table_name"].ToString().Trim().ToUpper() == "COND") { strFullPathMDB = p_ado.m_OleDbDataReader["path"].ToString().Trim() + "\\" + p_ado.m_OleDbDataReader["file"].ToString().Trim(); if (System.IO.File.Exists(strFullPathMDB) == true) { strConn = p_ado.getMDBConnString(strFullPathMDB, "admin", ""); p_ado.OpenConnection(strConn); if (p_ado.m_intError == 0) { this.m_OleDbDataAdapter.SelectCommand.CommandText = "select * from " + p_ado.m_OleDbDataReader["table_name"].ToString().Trim(); this.m_OleDbDataAdapter.Fill(this.m_dsOptimizerTables, p_ado.m_OleDbDataReader["table_name"].ToString().Trim()); } else { this.m_intError = -1; p_ado.m_OleDbDataReader.Close(); this.m_OleDbConnection.Close(); p_ado.m_OleDbCommand = null; p_ado.m_OleDbDataReader = null; p_ado = null; this.m_dsOptimizerTables.Clear(); this.m_dsOptimizerTables = null; this.m_OleDbDataAdapter.Dispose(); this.m_OleDbDataAdapter = null; return; } } else { //MessageBox.Show(strFullPathMDB + " does not exist","Scenario Data Source", MessageBoxIcon.Error, MessageBoxButtons.OK); MessageBox.Show(strFullPathMDB + " does not exist", "Scenario Data Source"); this.m_intError = -1; p_ado.m_OleDbDataReader.Close(); this.m_OleDbConnection.Close(); p_ado.m_OleDbCommand = null; p_ado.m_OleDbDataReader = null; p_ado = null; this.m_dsOptimizerTables.Clear(); this.m_dsOptimizerTables = null; this.m_OleDbDataAdapter.Dispose(); this.m_OleDbDataAdapter = null; return; } } } } } p_ado.m_OleDbDataReader.Close(); } p_ado.m_OleDbDataReader = null; p_ado.m_OleDbCommand = null; p_ado = null; this.m_OleDbConnectionScenario.Close(); }
public void CreateMDBAndCreateOptimizerTableDataSourceLinks(string strScenarioMDB, string strScenarioId, string strDestinationLinkDir) { string strSQL = ""; string strFullPathMDB = ""; string strConn = ""; //ado specific routines class ado_data_access p_ado = new ado_data_access(); //connect to mdb file containing data sources this.m_OleDbConnectionScenario = new System.Data.OleDb.OleDbConnection(); strConn = p_ado.getMDBConnString(strScenarioMDB, "admin", ""); p_ado.OpenConnection(strConn, ref this.m_OleDbConnectionScenario); if (p_ado.m_intError != 0) { this.m_intError = p_ado.m_intError; p_ado = null; return; } //used to get the temporary random file name utils p_utils = new utils(); //get temporary mdb file this.m_strRandomFileName = p_utils.getRandomFile(strDestinationLinkDir, "accdb"); p_utils = null; //used to create a link to the table dao_data_access p_dao = new dao_data_access(); //create a temporary mdb that will contain all //the links to the Optimizer tables p_dao.CreateMDB(this.m_strRandomFileName); //query the MDB datasource table for Optimizer table names and location of the table strSQL = "SELECT path, file,table_name FROM scenario_datasource WHERE " + " scenario_id = '" + strScenarioId + "';"; p_ado.SqlQueryReader(this.m_OleDbConnectionScenario, strSQL); if (p_ado.m_intError == 0) { //read the record while (p_ado.m_OleDbDataReader.Read()) { //look to make sure we have the correct record strFullPathMDB = p_ado.m_OleDbDataReader["path"].ToString().Trim() + "\\" + p_ado.m_OleDbDataReader["file"].ToString().Trim(); if (System.IO.File.Exists(strFullPathMDB) == true) { if (p_ado.m_OleDbDataReader["table_name"].ToString().Trim().ToUpper() == "PLOT" || p_ado.m_OleDbDataReader["table_name"].ToString().Trim().ToUpper() == "COND" || p_ado.m_OleDbDataReader["table_name"].ToString().Trim().ToUpper() == "FFE") { //create a link to the table in an mdb file p_dao.CreateTableLink(this.m_strRandomFileName, p_ado.m_OleDbDataReader["table_name"].ToString().Trim(), strFullPathMDB, p_ado.m_OleDbDataReader["table_name"].ToString().Trim()); } } } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbDataReader = null; } this.m_OleDbConnectionScenario.Close(); this.m_OleDbConnectionScenario = null; p_ado = null; p_dao = null; }
public void loadvalues(ado_data_access p_oAdo, System.Data.OleDb.OleDbConnection p_oConn, string p_strSelectSQL, string p_strDisplayColumn, string p_strSelectColumn, string p_strTable) { ((frmDialog)this.ParentForm).DialogResult = System.Windows.Forms.DialogResult.OK; p_oAdo.SqlQueryReader(p_oAdo.m_OleDbConnection, p_strSelectSQL); if (p_oAdo.m_intError != 0) { return; } if (p_oAdo.m_OleDbDataReader.HasRows) { this.listView1.Clear(); this.listView1.Columns.Add(" ", 10, HorizontalAlignment.Center); this.m_strFieldTypeAString_YN = new string[p_oAdo.m_OleDbDataReader.FieldCount]; for (int x = 0; x <= p_oAdo.m_OleDbDataReader.FieldCount - 1; x++) { this.m_strFieldTypeAString_YN[x] = p_oAdo.getIsTheFieldAStringDataType(p_oAdo.m_OleDbDataReader.GetFieldType(x).FullName.ToString()); this.listView1.Columns.Add(p_oAdo.m_OleDbDataReader.GetName(x).ToString(), 100, HorizontalAlignment.Left); if (p_oAdo.m_OleDbDataReader.GetName(x).ToString().Trim().ToUpper() == p_strDisplayColumn.Trim().ToUpper()) { this.m_intDisplayColumn = x; } if (p_oAdo.m_OleDbDataReader.GetName(x).ToString().Trim().ToUpper() == p_strSelectColumn.Trim().ToUpper()) { this.m_intSelectColumn = x; } } while (p_oAdo.m_OleDbDataReader.Read()) { if (p_oAdo.m_OleDbDataReader[0] != System.DBNull.Value) { if (p_oAdo.m_OleDbDataReader[0].ToString().Trim().Length > 0) { System.Windows.Forms.ListViewItem entryListItem = listView1.Items.Add("", 0); this.m_oLvAlternateColors.AddRow(); this.m_oLvAlternateColors.AddColumns(entryListItem.Index, listView1.Columns.Count); entryListItem.UseItemStyleForSubItems = false; this.m_oLvAlternateColors.ListViewSubItem(entryListItem.Index, 0, entryListItem.SubItems[entryListItem.SubItems.Count - 1], false); for (int x = 0; x <= p_oAdo.m_OleDbDataReader.FieldCount - 1; x++) { this.listView1.Items[entryListItem.Index].SubItems.Add(p_oAdo.m_OleDbDataReader[x].ToString().Trim()); this.m_oLvAlternateColors.ListViewSubItem(entryListItem.Index, x + 1, entryListItem.SubItems[entryListItem.SubItems.Count - 1], false); } this.listView1.Items[0].Selected = true; } } } } else { MessageBox.Show("No previous data to choose from", "FIA Biosum", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); ((frmDialog)this.ParentForm).DialogResult = System.Windows.Forms.DialogResult.Cancel; } }
public void SaveScenarioProperties() { string strTemp1; string strTemp2; string strSQL = ""; bool bCore = false; string strDesc = ""; if (this.lstScenario.Visible == true) //new scenario { //validate the input //Optimization id if (this.txtScenarioId.Text.Length == 0) { MessageBox.Show("Enter A Unique Optimization scenario Id"); this.txtScenarioId.Focus(); return; } //check for duplicate scenario id if (this.lstScenario.Items.Count > 0) { strTemp2 = this.txtScenarioId.Text.Trim(); for (int x = 0; x <= this.lstScenario.Items.Count - 1; x++) { strTemp1 = this.lstScenario.Items[x].ToString().Trim(); if (strTemp1.ToUpper() == strTemp2.ToUpper()) { MessageBox.Show("Cannot have a duplicate Optimization scenario id"); this.txtScenarioId.Focus(); return; } } } //make sure user entered scenario path if (this.txtScenarioPath.Text.Length > 0) { //create the scenario path if it does not exist and //copy the scenario_results.mdb to it try { if (!System.IO.Directory.Exists(this.txtScenarioPath.Text)) { System.IO.Directory.CreateDirectory(this.txtScenarioPath.Text); System.IO.Directory.CreateDirectory(this.txtScenarioPath.Text.ToString() + "\\db"); //copy default scenario_results database to the new project directory string strSourceFile = ((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.m_strProjectDirectory + "\\" + ScenarioType + "\\db\\scenario_results.mdb"; string strDestFile = this.txtScenarioPath.Text + "\\db\\scenario_results.mdb"; System.IO.File.Copy(strSourceFile, strDestFile, true); } } catch { MessageBox.Show("Error Creating Folder"); return; } } else { MessageBox.Show("Enter A Directory Location To Save Optimization scenario Files"); this.txtScenarioPath.Focus(); return; } //copy the project data source values to the scenario data source ado_data_access p_ado = new ado_data_access(); string strProjDBDir = ((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.m_strProjectDirectory + "\\db"; string strProjFile = "project.mdb"; StringBuilder strProjFullPath = new StringBuilder(strProjDBDir); strProjFullPath.Append("\\"); strProjFullPath.Append(strProjFile); string strProjConn = p_ado.getMDBConnString(strProjFullPath.ToString(), "admin", ""); System.Data.OleDb.OleDbConnection p_OleDbProjConn = new System.Data.OleDb.OleDbConnection(); p_ado.OpenConnection(strProjConn, ref p_OleDbProjConn); string strScenarioDBDir = ((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.m_strProjectDirectory + "\\" + ScenarioType + "\\db"; string strScenarioFile = "scenario_" + ScenarioType + "_rule_definitions.mdb"; StringBuilder strScenarioFullPath = new StringBuilder(strScenarioDBDir); strScenarioFullPath.Append("\\"); strScenarioFullPath.Append(strScenarioFile); string strScenarioConn = p_ado.getMDBConnString(strScenarioFullPath.ToString(), "admin", ""); p_ado.OpenConnection(strScenarioConn); if (p_ado.m_intError == 0) { if (this.txtDescription.Text.Trim().Length > 0) { strDesc = p_ado.FixString(this.txtDescription.Text.Trim(), "'", "''"); } strSQL = "INSERT INTO scenario (scenario_id,description,Path,File) VALUES " + "('" + this.txtScenarioId.Text.Trim() + "'," + "'" + strDesc + "'," + "'" + this.txtScenarioPath.Text.Trim() + "','scenario_" + ScenarioType + "_rule_definitions.mdb');"; //"'" + this.txtScenarioMDBFile.Text.Trim() + "');"; p_ado.SqlNonQuery(p_ado.m_OleDbConnection, strSQL); p_ado.SqlQueryReader(p_OleDbProjConn, "select * from datasource"); if (p_ado.m_intError == 0) { try { while (p_ado.m_OleDbDataReader.Read()) { bCore = false; switch (p_ado.m_OleDbDataReader["table_type"].ToString().Trim().ToUpper()) { case "PLOT": bCore = true; break; case "CONDITION": bCore = true; break; //case "FIRE AND FUEL EFFECTS": // bCore = true; // break; case "HARVEST COSTS": bCore = true; break; case "TREATMENT PRESCRIPTIONS": bCore = true; break; case "TREE VOLUMES AND VALUES BY SPECIES AND DIAMETER GROUPS": bCore = true; break; case "TRAVEL TIMES": bCore = true; break; case "PROCESSING SITES": bCore = true; break; case "TREE SPECIES AND DIAMETER GROUPS DOLLAR VALUES": bCore = true; break; case "PLOT AND CONDITION RECORD AUDIT": bCore = true; break; case "PLOT, CONDITION AND TREATMENT RECORD AUDIT": bCore = true; break; default: break; } if (bCore == true) { strSQL = "INSERT INTO scenario_datasource (scenario_id,table_type,Path,file,table_name) VALUES " + "('" + this.txtScenarioId.Text.Trim() + "'," + "'" + p_ado.m_OleDbDataReader["table_type"].ToString().Trim() + "'," + "'" + p_ado.m_OleDbDataReader["path"].ToString().Trim() + "'," + "'" + p_ado.m_OleDbDataReader["file"].ToString().Trim() + "'," + "'" + p_ado.m_OleDbDataReader["table_name"].ToString().Trim() + "');"; p_ado.SqlNonQuery(p_ado.m_OleDbConnection, strSQL); } } } catch (Exception caught) { intError = -1; strError = caught.Message; MessageBox.Show(strError); } if (p_ado.m_intError == 0) { if (ScenarioType.Trim().ToUpper() == "OPTIMIZER") { ((frmOptimizerScenario)ParentForm).uc_datasource1.strScenarioId = this.txtScenarioId.Text.Trim(); ((frmOptimizerScenario)ParentForm).uc_datasource1.strDataSourceMDBFile = ((frmMain)ParentForm.ParentForm).frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\db\\scenario_" + ScenarioType + "_rule_definitions.mdb"; ((frmOptimizerScenario)ParentForm).uc_datasource1.strDataSourceTable = "scenario_datasource"; ((frmOptimizerScenario)ParentForm).uc_datasource1.strProjectDirectory = ((frmMain)ParentForm.ParentForm).frmProject.uc_project1.txtRootDirectory.Text.Trim(); } else { this.ReferenceProcessorScenarioForm.uc_datasource1.strScenarioId = this.txtScenarioId.Text.Trim(); this.ReferenceProcessorScenarioForm.uc_datasource1.strDataSourceMDBFile = ((frmMain)ParentForm.ParentForm).frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\db\\scenario_" + ScenarioType + "_rule_definitions.mdb"; this.ReferenceProcessorScenarioForm.uc_datasource1.strDataSourceTable = "scenario_datasource"; this.ReferenceProcessorScenarioForm.uc_datasource1.strProjectDirectory = ((frmMain)ParentForm.ParentForm).frmProject.uc_project1.txtRootDirectory.Text.Trim(); } } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbDataReader = null; p_ado.m_OleDbCommand = null; p_OleDbProjConn.Close(); p_OleDbProjConn = null; } if (ScenarioType.Trim().ToUpper() == "OPTIMIZER") { string strTemp = p_ado.FixString("SELECT @@PlotTable@@.* FROM @@PlotTable@@ WHERE @@PlotTable@@.plot_accessible_yn='Y'", "'", "''"); strSQL = "INSERT INTO scenario_plot_filter (scenario_id,sql_command,current_yn) VALUES " + "('" + this.txtScenarioId.Text.Trim() + "'," + "'" + strTemp + "'," + "'Y');"; p_ado.SqlNonQuery(p_ado.m_OleDbConnection, strSQL); strTemp = p_ado.FixString("SELECT @@CondTable@@.* FROM @@CondTable@@", "'", "''"); strSQL = "INSERT INTO scenario_cond_filter (scenario_id,sql_command,current_yn) VALUES " + "('" + this.txtScenarioId.Text.Trim() + "'," + "'" + strTemp + "'," + "'Y');"; p_ado.SqlNonQuery(p_ado.m_OleDbConnection, strSQL); } } p_ado.m_OleDbConnection.Close(); p_ado.m_OleDbConnection = null; p_ado = null; this.btnCancel.Enabled = false; this.btnOpen.Enabled = true; this.lstScenario.Enabled = true; this.txtScenarioId.Visible = false; this.lblNewScenario.Visible = false; this.txtScenarioPath.Enabled = false; this.lstScenario.Items.Add(this.txtScenarioId.Text); this.lstScenario.SelectedIndex = this.lstScenario.Items.Count - 1; } else { ado_data_access p_ado = new ado_data_access(); System.Data.OleDb.OleDbConnection oConn = new System.Data.OleDb.OleDbConnection(); string strProjDir = ((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.m_strProjectDirectory; string strScenarioDir = ((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.m_strProjectDirectory + "\\" + ScenarioType + "\\db"; string strFile = "scenario_" + ScenarioType + "_rule_definitions.mdb"; if (ScenarioType.Trim().ToUpper() == "OPTIMIZER") { ((frmOptimizerScenario)ParentForm).uc_datasource1.strScenarioId = this.txtScenarioId.Text.Trim(); ((frmOptimizerScenario)ParentForm).uc_datasource1.strDataSourceMDBFile = strScenarioDir + "\\scenario_" + ScenarioType + "_rule_definitions.mdb"; ((frmOptimizerScenario)ParentForm).uc_datasource1.strDataSourceTable = "scenario_datasource"; ((frmOptimizerScenario)ParentForm).uc_datasource1.strProjectDirectory = strProjDir; } else { this.ReferenceProcessorScenarioForm.uc_datasource1.strScenarioId = this.txtScenarioId.Text.Trim(); this.ReferenceProcessorScenarioForm.uc_datasource1.strDataSourceMDBFile = strScenarioDir + "\\scenario_" + ScenarioType + "_rule_definitions.mdb"; this.ReferenceProcessorScenarioForm.uc_datasource1.strDataSourceTable = "scenario_datasource"; this.ReferenceProcessorScenarioForm.uc_datasource1.strProjectDirectory = strProjDir; } StringBuilder strFullPath = new StringBuilder(strScenarioDir); strFullPath.Append("\\"); strFullPath.Append(strFile); if (this.txtDescription.Text.Trim().Length > 0) { strDesc = p_ado.FixString(this.txtDescription.Text.Trim(), "'", "''"); } string strConn = p_ado.getMDBConnString(strFullPath.ToString(), "admin", ""); //string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFullPath.ToString() + ";User Id=admin;Password=;"; strSQL = "UPDATE scenario SET description = '" + strDesc + "' WHERE scenario_id = '" + this.txtScenarioId.Text.ToLower() + "';"; p_ado.SqlNonQuery(strConn, strSQL); p_ado = null; } if (ScenarioType.Trim().ToUpper() == "OPTIMIZER") { if (((frmOptimizerScenario)this.ParentForm).m_bScenarioOpen == false) { ((frmOptimizerScenario)this.ParentForm).Text = "Core Analysis: Optimization Scenario (" + this.txtScenarioId.Text.Trim() + ")"; ((frmOptimizerScenario)this.ParentForm).SetMenu("scenario"); ((frmOptimizerScenario)this.ParentForm).m_bScenarioOpen = true; this.lblTitle.Text = ""; this.Visible = false; } } else { if (this.ReferenceProcessorScenarioForm.m_bScenarioOpen == false) { this.ReferenceProcessorScenarioForm.Text = "Processor: Scenario (" + this.txtScenarioId.Text.Trim() + ")"; this.ReferenceProcessorScenarioForm.m_bScenarioOpen = true; this.lblTitle.Text = ""; this.Visible = false; } } }
public uc_processor_tree_spc_edit(ado_data_access p_ado, string p_strTreeSpcTable, string p_strFvsTreeSpcTable, string p_strVariant) { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); m_ado = p_ado; // Populate reference dictionary of spcd and fvs_common_name from fvs_tree_species m_dictFvsCommonName = new System.Collections.Generic.Dictionary <String, String>(); m_strTreeSpcTable = p_strTreeSpcTable; if (p_strVariant.Trim().Length > 0) { p_ado.m_strSQL = "SELECT spcd,fvs_species,common_name,fvs_common_name " + "FROM " + p_strFvsTreeSpcTable + " " + "WHERE LEN(TRIM(fvs_species)) > 0 AND " + "LEN(TRIM(common_name)) > 0 AND " + "TRIM(fvs_variant) = '" + p_strVariant.Trim() + "' order by spcd;"; p_ado.SqlQueryReader(p_ado.m_OleDbConnection, p_ado.m_OleDbTransaction, p_ado.m_strSQL); if (p_ado.m_OleDbDataReader.HasRows) { while (p_ado.m_OleDbDataReader.Read()) { string strMySpCd = Convert.ToString(p_ado.m_OleDbDataReader["spcd"]); this.cmbFvsSpCd.Items.Add(strMySpCd + " - " + Convert.ToString(p_ado.m_OleDbDataReader["common_name"]) + " - " + p_ado.m_OleDbDataReader["fvs_species"]); if (!m_dictFvsCommonName.ContainsKey(strMySpCd)) { m_dictFvsCommonName.Add(strMySpCd, Convert.ToString(p_ado.m_OleDbDataReader["fvs_common_name"])); } } } // Only show fvs variants on the form that exist in the fvs_tree_species table p_ado.m_strSQL = "SELECT distinct fvs_variant " + "FROM " + p_strFvsTreeSpcTable + " "; p_ado.SqlQueryReader(p_ado.m_OleDbConnection, p_ado.m_OleDbTransaction, p_ado.m_strSQL); if (p_ado.m_OleDbDataReader.HasRows) { // Copy all the combo box items into dictionary with variant as key System.Collections.Generic.IDictionary <String, String> dictVariantItems = new System.Collections.Generic.Dictionary <String, String>(); for (int i = 0; i < this.cmbVariant.Items.Count; i++) { string strKey = this.cmbVariant.GetItemText(this.cmbVariant.Items[i]).Substring(0, 2); if (!dictVariantItems.ContainsKey(strKey)) { dictVariantItems.Add(strKey, this.cmbVariant.GetItemText(this.cmbVariant.Items[i])); } } // Clear combo box items this.cmbVariant.Items.Clear(); while (p_ado.m_OleDbDataReader.Read()) { string strNextVariant = Convert.ToString(p_ado.m_OleDbDataReader["fvs_variant"]).Trim(); // Only add combo box items back that are in the fvs_species table if (dictVariantItems.ContainsKey(strNextVariant)) { this.cmbVariant.Items.Add(dictVariantItems[strNextVariant]); } } } p_ado.m_OleDbDataReader.Close(); } this.m_strFvsTreeSpcTable = p_strFvsTreeSpcTable; this.m_strVariant = p_strVariant; // TODO: Add any initialization after the InitializeComponent call }
public void loadnotes() { //set the buttons and menu options if (((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.txtShared.Text.Trim().Length > 0 && ((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.txtPersonal.Text.Trim().Length > 0) { this.tbrProjectNotes.Buttons[0].Enabled = true; this.tbrProjectNotes.Buttons[1].Enabled = true; this.tbrProjectNotes.Buttons[2].Enabled = true; this.menuItem1.Enabled = true; this.menuItem2.Enabled = true; this.menuItem3.Enabled = true; } else if (((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.txtShared.Text.Trim().Length > 0) { this.tbrProjectNotes.Buttons[0].Enabled = true; this.tbrProjectNotes.Buttons[1].Enabled = false; this.tbrProjectNotes.Buttons[2].Enabled = false; this.menuItem1.Enabled = true; this.menuItem2.Enabled = false; this.menuItem3.Enabled = false; this.tbrProjectNotes.Buttons[0].Pushed = true; this.tbrProjectNotes.Buttons[1].Pushed = false; this.tbrProjectNotes.Buttons[2].Pushed = false; } else if (((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.txtPersonal.Text.Trim().Length > 0) { this.tbrProjectNotes.Buttons[0].Enabled = false; this.tbrProjectNotes.Buttons[1].Enabled = true; this.tbrProjectNotes.Buttons[2].Enabled = false; this.menuItem1.Enabled = false; this.menuItem2.Enabled = true; this.menuItem3.Enabled = false; this.tbrProjectNotes.Buttons[0].Pushed = false; this.tbrProjectNotes.Buttons[1].Pushed = true; this.tbrProjectNotes.Buttons[2].Pushed = false; } else { this.tbrProjectNotes.Buttons[0].Enabled = false; this.tbrProjectNotes.Buttons[1].Enabled = false; this.tbrProjectNotes.Buttons[2].Enabled = false; this.menuItem1.Enabled = false; this.menuItem2.Enabled = false; this.menuItem3.Enabled = false; } if (this.m_bLoadNotes == true) { string strSQL = ""; string strConn = ""; //string str=""; ado_data_access p_ado = new ado_data_access(); string strMDB = ""; if (((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.txtPersonal.Text.Trim().Length > 0) { strMDB = ((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.txtPersonal.Text.Trim() + "\\personal_project_links_and_notes.mdb"; strConn = p_ado.getMDBConnString(strMDB, "admin", ""); //strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMDB + ";User Id=admin;Password=;"; p_ado.OpenConnection(strConn); if (p_ado.m_intError == 0) { strSQL = "SELECT TOP 1 * FROM notes;"; p_ado.SqlQueryReader(p_ado.m_OleDbConnection, strSQL); if (p_ado.m_intError != 0) { p_ado.m_OleDbConnection.Close(); } } if (p_ado.m_intError == 0) { while (p_ado.m_OleDbDataReader.Read()) { if (p_ado.m_OleDbDataReader["notes"] != System.DBNull.Value) { if (p_ado.m_OleDbDataReader["notes"].ToString().Trim().Length > 0) { this.txtNotesPersonal.Text = p_ado.m_OleDbDataReader["notes"].ToString(); } } } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbConnection.Close(); } } if (((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.txtShared.Text.Trim().Length > 0) { strMDB = ((frmMain)this.ParentForm.ParentForm).frmProject.uc_project1.txtShared.Text.Trim() + "\\shared_project_links_and_notes.mdb"; strConn = p_ado.getMDBConnString(strMDB, "admin", ""); //strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMDB + ";User Id=admin;Password=;"; p_ado.OpenConnection(strConn); if (p_ado.m_intError == 0) { strSQL = "SELECT TOP 1 * FROM notes;"; p_ado.SqlQueryReader(p_ado.m_OleDbConnection, strSQL); if (p_ado.m_intError != 0) { p_ado.m_OleDbConnection.Close(); } } if (p_ado.m_intError == 0) { while (p_ado.m_OleDbDataReader.Read()) { if (p_ado.m_OleDbDataReader["notes"] != System.DBNull.Value) { if (p_ado.m_OleDbDataReader["notes"].ToString().Trim().Length > 0) { this.txtNotesShared.Text = p_ado.m_OleDbDataReader["notes"].ToString(); } } } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbConnection.Close(); } } this.m_bLoadNotes = false; p_ado = null; } }
public void loadvalues() { m_bSyncd = false; ado_data_access oAdo = new ado_data_access(); int x = 0; int intPathNF = 0; int intRootNF = 0; this.lvDatasources.Clear(); ado_data_access p_ado = new ado_data_access(); this.lvDatasources.Columns.Add(" ", 2, HorizontalAlignment.Left); this.lvDatasources.Columns.Add("DataSource", 100, HorizontalAlignment.Left); this.lvDatasources.Columns.Add("Scenario", 100, HorizontalAlignment.Left); this.lvDatasources.Columns.Add("TableType", 50, HorizontalAlignment.Left); this.lvDatasources.Columns.Add("Path", 100, HorizontalAlignment.Left); this.lvDatasources.Columns.Add("PathFound", 100, HorizontalAlignment.Left); this.lvDatasources.Columns.Add("Synchronized", 100, HorizontalAlignment.Left); oAdo.OpenConnection(oAdo.getMDBConnString(m_strRandomPathAndFile, "", "")); oAdo.m_strSQL = "SELECT 'Project' AS DataSource, 'NA' AS Scenario,table_type AS TableType,path FROM project_datasource "; if (oAdo.TableExist(oAdo.m_OleDbConnection, "optimizer_scenario")) { oAdo.m_strSQL = oAdo.m_strSQL + "UNION " + "SELECT 'TreatmentOptimizer' AS DataSource, Scenario_Id AS Scenario,'NA' AS TableType,path FROM optimizer_scenario "; } if (oAdo.TableExist(oAdo.m_OleDbConnection, "optimizer_scenario_datasource")) { oAdo.m_strSQL = oAdo.m_strSQL + "UNION " + "SELECT 'TreatmentOptimizer' AS DataSource, Scenario_Id AS Scenario,table_type AS TableType, path FROM optimizer_scenario_datasource "; } if (oAdo.TableExist(oAdo.m_OleDbConnection, "processor_scenario")) { oAdo.m_strSQL = oAdo.m_strSQL + "UNION " + "SELECT 'Processor' AS DataSource, Scenario_Id AS Scenario,'NA' AS TableType,path FROM processor_scenario "; } if (oAdo.TableExist(oAdo.m_OleDbConnection, "processor_scenario_datasource")) { oAdo.m_strSQL = oAdo.m_strSQL + "UNION " + "SELECT 'Processor' AS DataSource, Scenario_Id AS Scenario,table_type AS TableType, path FROM processor_scenario_datasource "; } oAdo.SqlQueryReader(oAdo.m_OleDbConnection, oAdo.m_strSQL); if (oAdo.m_OleDbDataReader.HasRows) { while (oAdo.m_OleDbDataReader.Read()) { // Don't add appData data sources to the grid if (oAdo.m_OleDbDataReader["Path"].ToString().IndexOf("@@appdata@@") == -1) { System.Windows.Forms.ListViewItem entryListItem = this.lvDatasources.Items.Add(" "); entryListItem.UseItemStyleForSubItems = false; this.lvDatasources.Items[x].SubItems.Add(oAdo.m_OleDbDataReader["DataSource"].ToString()); this.lvDatasources.Items[x].SubItems.Add(oAdo.m_OleDbDataReader["Scenario"].ToString()); this.lvDatasources.Items[x].SubItems.Add(oAdo.m_OleDbDataReader["TableType"].ToString()); this.lvDatasources.Items[x].SubItems.Add(oAdo.m_OleDbDataReader["Path"].ToString()); if (System.IO.Directory.Exists(oAdo.m_OleDbDataReader["Path"].ToString().Trim())) { ListViewItem.ListViewSubItem FileStatusSubItem = entryListItem.SubItems.Add("Yes"); FileStatusSubItem.ForeColor = System.Drawing.Color.White; FileStatusSubItem.BackColor = System.Drawing.Color.Green; } else { ListViewItem.ListViewSubItem FileStatusSubItem = entryListItem.SubItems.Add("No"); FileStatusSubItem.ForeColor = System.Drawing.Color.White; FileStatusSubItem.BackColor = System.Drawing.Color.Red; intPathNF++; } if (oAdo.m_OleDbDataReader["Path"].ToString().ToUpper().Contains(lblCurrentProjectRootFolder.Text.Trim().ToUpper())) { ListViewItem.ListViewSubItem SyncStatusSubItem = entryListItem.SubItems.Add("Yes"); SyncStatusSubItem.ForeColor = System.Drawing.Color.White; SyncStatusSubItem.BackColor = System.Drawing.Color.Green; } else { ListViewItem.ListViewSubItem SyncStatusSubItem = entryListItem.SubItems.Add("No"); SyncStatusSubItem.ForeColor = System.Drawing.Color.White; SyncStatusSubItem.BackColor = System.Drawing.Color.Red; intRootNF++; } x++; } } lblFolderPaths.Text = intPathNF.ToString().Trim(); lblProjectRootFolderNotFound.Text = intRootNF.ToString().Trim(); oAdo.m_OleDbDataReader.Close(); } if (intRootNF > 0) { btnAnalyze.Enabled = true; } else { btnAnalyze.Enabled = false; } oAdo.m_OleDbConnection.Close(); oAdo = null; }
private void btnHarvestCosts_Click(object sender, System.EventArgs e) { string strScenarioId = ""; //string strScenarioMDB=""; string strConn = ""; string strSQL = ""; string strRandomPathAndFile = ""; string strHvstCostsTableName = ""; string strCondTableName = ""; string[] strColumnsToEditArray; string strColumnsToEditList = ""; string[] strAllColumnsArray; string strAllColumnsList = ""; string strScenarioConn = ""; int x, y; strScenarioId = this.ReferenceOptimizerScenarioForm.uc_scenario1.txtScenarioId.Text.Trim().ToLower(); /***************************************************************** **lets see if this harvest costs edit form is already open *****************************************************************/ utils p_oUtils = new utils(); p_oUtils.m_intLevel = 1; if (p_oUtils.FindWindowLike(frmMain.g_oFrmMain.Handle, "Treatment Optimizer: Edit Harvest Costs " + " (" + strScenarioId + ")", "*", true, false) > 0) { MessageBox.Show("!!Harvest Costs Edit Form Is Already Open!!", "Harvest Costs Edit Form", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); if (this.m_frmHarvestCosts.WindowState == System.Windows.Forms.FormWindowState.Minimized) { this.m_frmHarvestCosts.WindowState = System.Windows.Forms.FormWindowState.Normal; } this.m_frmHarvestCosts.Focus(); return; } ado_data_access p_ado = new ado_data_access(); strRandomPathAndFile = this.ReferenceOptimizerScenarioForm.uc_datasource1.CreateMDBAndScenarioTableDataSourceLinks(this.m_oEnv.strTempDir); if (strRandomPathAndFile.Trim().Length > 0) { strConn = p_ado.getMDBConnString(strRandomPathAndFile, "admin", ""); strHvstCostsTableName = this.ReferenceOptimizerScenarioForm.uc_datasource1.getDataSourceTableName("Harvest Costs"); if (strHvstCostsTableName.Trim().Length > 0) { strCondTableName = this.ReferenceOptimizerScenarioForm.uc_datasource1.getDataSourceTableName("Condition"); if (strCondTableName.Trim().Length > 0) { strColumnsToEditArray = new string[1]; strColumnsToEditList = ""; string strScenarioMDB = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text + "\\" + Tables.OptimizerScenarioRuleDefinitions.DefaultScenarioTableDbFile; strScenarioConn = p_ado.getMDBConnString(strScenarioMDB, "admin", ""); strSQL = "SELECT * FROM scenario_harvest_cost_columns WHERE " + " TRIM(scenario_id) = '" + strScenarioId.Trim() + "';"; p_ado.SqlQueryReader(strScenarioConn, strSQL); if (p_ado.m_OleDbDataReader.HasRows) { while (p_ado.m_OleDbDataReader.Read()) { if (p_ado.m_OleDbDataReader["ColumnName"] != System.DBNull.Value) { strColumnsToEditList = strColumnsToEditList + p_ado.m_OleDbDataReader["ColumnName"].ToString().Trim() + ","; } } } p_ado.m_OleDbDataReader.Close(); p_ado.m_OleDbDataReader = null; if (strColumnsToEditList.Trim().Length > 0) { strColumnsToEditList = strColumnsToEditList.Substring(0, strColumnsToEditList.Trim().Length - 1); strColumnsToEditArray = p_oUtils.ConvertListToArray(strColumnsToEditList, ","); } else { //strColumnsToEditArray = new string[2]; //strColumnsToEditArray[0] = "water_barring_roads_cpa"; //strColumnsToEditArray[1] = "brush_cutting_cpa"; } strAllColumnsList = p_ado.getFieldNames(strConn, "select * from " + strHvstCostsTableName); strAllColumnsArray = p_oUtils.ConvertListToArray(strAllColumnsList, ","); strSQL = ""; for (x = 0; x <= strAllColumnsArray.Length - 1; x++) { if (strAllColumnsArray[x].Trim().ToUpper() == "BIOSUM_COND_ID") { strSQL = "biosum_cond_id,"; strSQL = strSQL + "mid(biosum_cond_id,6,2) as statecd,mid(biosum_cond_id,12,3) as countycd,mid(biosum_cond_id,15,7) as plot,mid(biosum_cond_id,25,1) as condid,"; } else { for (y = 0; y <= strColumnsToEditArray.Length - 1; y++) { if (strAllColumnsArray[x].Trim().ToUpper() == strColumnsToEditArray[y].Trim().ToUpper()) { strSQL = strSQL + strColumnsToEditArray[y].Trim() + ","; } } } } strSQL = strSQL.Substring(0, strSQL.Trim().Length - 1); strSQL = "SELECT DISTINCT " + strSQL + " FROM " + strHvstCostsTableName; this.m_strColumnsToEdit = strColumnsToEditArray; this.m_intColumnsToEditCount = m_strColumnsToEdit.Length; string[] strRecordKeyField = new string[1]; strRecordKeyField[0] = "biosum_cond_id"; this.m_frmHarvestCosts = new frmGridView(); this.m_frmHarvestCosts.HarvestCostColumns = true; this.m_frmHarvestCosts.ReferenceOptimizerScenarioForm = this.ReferenceOptimizerScenarioForm; this.m_frmHarvestCosts.LoadDataSetToEdit(strConn, strSQL, strHvstCostsTableName, this.m_strColumnsToEdit, this.m_intColumnsToEditCount, strRecordKeyField); if (this.m_frmHarvestCosts.Visible == false) { this.m_frmHarvestCosts.MdiParent = this.ParentForm.ParentForm; this.m_frmHarvestCosts.Text = "Treatment Optimizer Analysis: Edit Harvest Costs " + " (" + strScenarioId + ")"; this.m_frmHarvestCosts.Show(); } this.m_frmHarvestCosts.Focus(); } } } p_oUtils = null; }
private void GetExistingColumns() { int x; string strCol = ""; string strFieldsList = ""; string[] strProcessorColumnsArray = null; System.Data.OleDb.OleDbConnection oConn = new System.Data.OleDb.OleDbConnection(); oConn.ConnectionString = m_oAdo.getMDBConnString(frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\processor\\db\\scenario_processor_rule_definitions.mdb", "", ""); m_oAdo.OpenConnection(oConn.ConnectionString, ref oConn); string strProcessorColumnsList = m_oAdo.CreateCommaDelimitedList(oConn, "SELECT DISTINCT ColumnName FROM scenario_harvest_cost_columns", ","); m_oAdo.CloseConnection(oConn); if (strProcessorColumnsList.Trim().Length > 0) { strFieldsList = strProcessorColumnsList; strProcessorColumnsArray = frmMain.g_oUtils.ConvertListToArray(strProcessorColumnsList, ","); } string strTable = m_oQueries.m_oDataSource.getValidDataSourceTableName("TREATMENT PRESCRIPTIONS HARVEST COST COLUMNS").Trim(); //string strTable = "scenario_harvest_cost_columns"; m_oAdo.m_strSQL = "SELECT DISTINCT ColumnName FROM " + strTable; m_oAdo.SqlQueryReader(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL); if (m_oAdo.m_OleDbDataReader.HasRows) { while (m_oAdo.m_OleDbDataReader.Read()) { if (m_oAdo.m_OleDbDataReader["ColumnName"] != System.DBNull.Value && Convert.ToString(m_oAdo.m_OleDbDataReader["ColumnName"]).Trim().Length > 0) { strCol = Convert.ToString(m_oAdo.m_OleDbDataReader["ColumnName"]).Trim().ToUpper(); if (strProcessorColumnsArray != null) { for (x = 0; x <= strProcessorColumnsArray.Length - 1; x++) { if (strProcessorColumnsArray[x] != null) { if (strProcessorColumnsArray[x].Trim().ToUpper() == strCol) { break; } } } if (x > strProcessorColumnsArray.Length - 1) { strFieldsList = strFieldsList + Convert.ToString(m_oAdo.m_OleDbDataReader["ColumnName"]).Trim() + ","; } } else { strFieldsList = strFieldsList + Convert.ToString(m_oAdo.m_OleDbDataReader["ColumnName"]).Trim() + ","; } } } } m_oAdo.m_OleDbDataReader.Close(); if (strFieldsList.Trim().Length > 0) { strFieldsList = strFieldsList.Substring(0, strFieldsList.Length - 1); string[] strFieldsArray = frmMain.g_oUtils.ConvertListToArray(strFieldsList, ","); } m_strHarvestTableColumnNameList = strFieldsList; }