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();
}
