private void button3_Click(object sender, EventArgs e)
{
Object_Library obj = new Object_Library();
obj.Object_Library_Name = textBox6.Text;
obj.Object_KKS = textBox5.Text;
try
{
obj.Parent_Object_Id = db.Object_Library
.FirstOrDefault(o => o.Object_Library_Name == comboBox2.SelectedValue.ToString()).Object_Library_Id;
}
catch (Exception)
{ }
db.Object_Library.Add(obj);
db.SaveChanges();
MessageBox.Show("Добавлено");
}
private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application ObjExcel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook ObjWorkBook;
Microsoft.Office.Interop.Excel.Worksheet ObjWorkSheet;
//Книга.
ObjWorkBook = ObjExcel.Workbooks.Add(System.Reflection.Missing.Value);
//Таблица.
ObjWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)ObjWorkBook.Sheets[1];
ObjWorkSheet.Cells[1, 1] = "Название объекта";
ObjWorkSheet.Cells[1, 2] = "Код";
int n = 2;
List <string> nodes = new List <string>();
foreach (var obje in db.Object)
{
if (db.Station_Object.Any(so => so.Station_Id == UserData.station && so.Object_Id == obje.Object_Id))
{
string objName = db.Object_Library
.FirstOrDefault(o => o.Object_Library_Id == obje.Object_Library_Id)
.Object_Library_Name;
try
{
string kks = "";
string curName = objName;
while (true)
{
Object_Library ol = db.Object_Library.FirstOrDefault(o => o.Object_Library_Name == curName);
nodes.Add(curName);
if (ol.Parent_Object_Id != null)
{
curName = db.Object_Library
.FirstOrDefault(o => o.Object_Library_Id == ol.Parent_Object_Id)
.Object_Library_Name;
continue;
}
break;
}
string nam = objName;
kks = "";
try
{
kks += db.Station.FirstOrDefault(s => s.Station_Id == UserData.station).Station_KKS
.ToString().Substring(0,
db.Station.FirstOrDefault(s => s.Station_Id == UserData.station).Station_KKS
.ToString()
.IndexOf(' '));
kks += " ";
kks += db.Object
.FirstOrDefault(
o => o.Object_Library_Id ==
db.Object_Library.FirstOrDefault(ol => ol.Object_Library_Name == nam)
.Object_Library_Id&&
db.Station_Object.Any(
so => so.Object_Id == o.Object_Id && so.Station_Id == UserData.station))
.Amount;
}
catch (Exception ew)
{
}
string name;
for (int j = nodes.Count - 1; j >= 0; j--)
{
name = nodes[j].ToString();
kks += db.Object_Library.FirstOrDefault(o => o.Object_Library_Name == name)
.Object_KKS[0];
}
ObjWorkSheet.Cells[n, 1] = objName;
ObjWorkSheet.Cells[n, 2] = kks;
n++;
kks = "";
nodes.Clear();
}
catch (Exception exception)
{
}
}
}
ObjExcel.Visible = true;
ObjExcel.UserControl = true;
}
