protected void MakeResultsTree(string productId) { try { ClassE classE = new ClassE(GetDirectory() + userDir); classE.setGlobalVar(); int prodId = int.Parse(productId); classE.m_makeResultsTree(prodId); classE.place_tree(prodId); classE.Close(); } catch (Exception ex) { logFiles.ErrorLog(ex); Master.ShowErrorMessage("MPX internal error has occured."); } }
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"; }