public static void save_errors_results(ClassE classE1_1, string msgResults, string msgErrors) { string commandString; string msgResultsRep = msgResults.Replace("<br/>", "\n"); string msgErrorsRep = msgErrors.Replace("<br/>", "\n"); msgResultsRep = DbUse.removeRedColor(msgResultsRep); commandString = "UPDATE zstblresults SET zstblresults.results = '" + msgResultsRep + "';"; classE1_1.runsql(commandString); commandString = "UPDATE zstblresults SET zstblresults.errors = '" + msgErrorsRep + "';"; classE1_1.runsql(commandString); }
protected void FillAllowableComponentsDdl(AjaxControlToolkit.ComboBox ddl) { { ClassE calc = new ClassE(GetDirectory() + userDir); calc = new ClassE(GetDirectory() + userDir); calc.runsql("DELETE tblPossibleComp.* from tblPossibleComp;"); try { calc.MakePossibleTable(int.Parse(dropListProducts.SelectedValue)); } catch (Exception) { } calc.Close(); } OleDbConnection connec = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + GetDirectory() + userDir + MAIN_USER_DATABASE + ";"); string commandRouting = "Select tblPossibleComp.* from tblPossibleComp ORDER BY ProdDesc;"; OleDbCommand cmd = new OleDbCommand(commandRouting, connec); OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); // { try { connec.Open(); DataTable ds = new DataTable(); adapter.Fill(ds); if (ddl != null) { ddl.Items.Clear(); for (int i = 0; i < ds.Rows.Count; i++) { ListItem item = new ListItem(ds.Rows[i]["ProdDesc"].ToString(), ds.Rows[i]["ProdID"].ToString()); ddl.Items.Add(item); } } connec.Close(); } catch (Exception ex) { try { connec.Close(); connec = null; } catch { } string message = ex.Message; } } }
protected void SetAllowableComponentData() { { ClassE calc = new ClassE(GetDirectory() + userDir); calc = new ClassE(GetDirectory() + userDir); calc.runsql("DELETE * FROM tblPossibleComp;"); try { calc.MakePossibleTable(int.Parse(dropListProducts.SelectedValue)); } catch (Exception) { } calc.Close(); } OleDbConnection connec = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + GetDirectory() + userDir + MAIN_USER_DATABASE + ";"); string commandRouting = "SELECT tblPossibleComp.* from tblPossibleComp ORDER BY ProdDesc;"; OleDbCommand cmd = new OleDbCommand(commandRouting, connec); OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); // { try { connec.Open(); DataTable dt = new DataTable(); adapter.Fill(dt); DataView dv = dt.DefaultView; //need to bind this to a droplist connec.Close(); } catch (Exception ex) { try { connec.Close(); connec = null; } catch { } string message = ex.Message; } } }
protected override void SetData() { { ClassE calc = new ClassE(GetDirectory() + userDir); calc.setGlobalVar(); calc.runsql("DELETE * FROM tblbomTree;"); if (dropListProducts.Items.Count > 0 && dropListProducts.SelectedItem == null) { dropListProducts.SelectedIndex = 0; } try { calc.MakeIbomTree(0, int.Parse(dropListProducts.SelectedValue), 0); } catch (Exception) { } calc.Close(); } if (!checkAllSubComponents.Checked) { tableQueryString += " WHERE Show = -1"; } base.SetData(); }
protected override void SetData() { { ClassE calc = new ClassE(GetDirectory() + userDir); calc.setGlobalVar(); calc.runsql("DELETE * FROM tblbomTree;"); if (dropListProducts.Items.Count > 0 && dropListProducts.SelectedItem == null) { dropListProducts.SelectedIndex = 0; } try { calc.MakeIbomTree(0, int.Parse(dropListProducts.SelectedValue), 0); } catch (Exception) { } calc.Close(); } if (!checkAllSubComponents.Checked) { //tableQueryString += " WHERE Show = -1"; tableQueryString += " WHERE Level = 1"; } else { tableQueryString += " WHERE Level >= 1"; } base.SetData(); GridViewRow myRow = grid.FooterRow; TextBox myText = (TextBox)myRow.Cells[2].Controls[0].Controls[0]; myText.Text = "1"; }