private void Form1_Load(object sender, EventArgs e) { _context = new dbMarkEntities(); TreeNode root = new TreeNode("Банк Нефтей"); treeView1.Nodes.Add(root); foreach (var item in _context.LIBRARY) { TreeNode b = new TreeNode(); b.ImageKey = item.LIBRARY_ID.ToString(); b.Text = item.TTL; root.Nodes.Add(b); var query = _context.URALS.Where(s => s.LIBRARY_ID == item.LIBRARY_ID); //TODO: сортировка нефтей foreach (var crude in query) { TreeNode c = new TreeNode(); c.ImageKey = crude.NEFT_ID.ToString(); c.Text = crude.TTL; b.Nodes.Add(c); var query2 = _context.CUT_URALS.Where(s => s.NEFT_ID == crude.NEFT_ID); foreach (var frac in query2) { TreeNode d = new TreeNode(); d.ImageKey = frac.CUT_ID.ToString(); d.Text = frac.TTL; c.Nodes.Add(d); } } foreach (var a in root.Nodes) { } } }
private void button1_Click(object sender, EventArgs e) { toggleSwitch1.Enabled = false; var sul = Convert.ToDouble(textBoxSUL.Text); var _350 = Convert.ToDouble(textBox350.Text); var par = Convert.ToDouble(textBoxPAR.Text); var spg = Convert.ToDouble(textBoxSPG.Text); var cst = Convert.ToDouble(textBoxCST.Text); dataGridView1.ColumnHeadersVisible = false; dataGridView1.DataSource = null; dataGridView1.Columns.Clear(); dataGridView1.Rows.Clear(); dataGridView1.Columns.Add("Название", "Название нефти"); dataGridView1.Columns[0].Width = 627; _context = new dbMarkEntities(); label7.Text = "Нефти-аналоги по индексу"; DataTable rowsTable = new DataTable(); int targetIndex = SetIndex(sul, _350, par); var indexLibraryOils = _context.URALS.Where(p => p.LIBRARY_ID == 163); //var c = _context.CUT_URALS.Where(p => p.LIBRARY_ID == 163); //var a = _context.ANLGX; var query = from i in indexLibraryOils join c in _context.CUT_URALS.Where(p => p.TTL == "НЕФТЬ В ЦЕЛОМ") on i.NEFT_ID equals c.NEFT_ID select new { cutId = c.CUT_ID, oilName = i.TTL }; var query2 = from q in query join c in _context.CUT_PROP.Where(p => p.PROP_ID == 574) on q.cutId equals c.CUT_ID select new { index = c.XVALUE, oilName = q.oilName }; var query3 = query2.Where(p => p.index == targetIndex); foreach (var b in query3) { dataGridView1.Rows.Add(b.oilName); } }
public Form2() { InitializeComponent(); _context = new dbMarkEntities(); }