private void getDesc()
{
if (m_oAdo.m_OleDbDataReader.IsClosed == false)
{
return;
}
m_oAdo.m_strSQL = Queries.GenericSelectSQL(m_oQueries.m_oReference.m_strRefHarvestMethodTable, "description", "TRIM(method)='" + cmbMethod.Text.Trim() + "' AND steep_yn = 'N'");
this.txtDesc.Text = m_oAdo.getSingleStringValueFromSQLQuery(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL, "temp");
}
public void LoadValues()
{
string strNotes = "";
FIA_Biosum_Manager.ado_data_access oAdo = new ado_data_access();
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 (ScenarioType.Trim().ToUpper() == "OPTIMIZER")
{
oAdo.m_strSQL = "SELECT notes FROM scenario WHERE TRIM(scenario_id)='" + this.ReferenceOptimizerScenarioForm.uc_scenario1.strScenarioId.Trim() + "'";
}
else
{
oAdo.m_strSQL = "SELECT notes FROM scenario WHERE TRIM(scenario_id)='" + this.ReferenceProcessorScenarioForm.uc_scenario1.strScenarioId.Trim() + "'";
}
strNotes = oAdo.getSingleStringValueFromSQLQuery(oAdo.m_OleDbConnection, oAdo.m_strSQL, "scenario");
oAdo.m_OleDbConnection.Close();
while (oAdo.m_OleDbConnection.State != System.Data.ConnectionState.Closed)
{
oAdo.m_OleDbConnection.Close();
System.Threading.Thread.Sleep(1000);
}
oAdo = null;
this.txtNotes.Text = strNotes;
}