public ActionResult Company(int id)
{
var tableName = "co";
DataRow row = MyExcel.GetDetails(tableName, id);
//пока не буду делать связки
return(View(row));
}
public ActionResult Exit(int id)
{
var tableName = "e";
DataRow row = MyExcel.GetDetails(tableName, id);
var fundsTmp = MyExcel.GetDetailsList("fe", $"[Номер выхода]='{id}'");
var fundsIds = String.Join(", ", fundsTmp.Select(x => $"'{x["Id"]}'").ToArray());
fundsIds = fundsIds != "" ? fundsIds : "NULL";
var funds = MyExcel.GetDetailsList("f_2", $"[Id] In ({fundsIds})");
ViewBag.funds = funds;
return(View(row));
}
private ActionResult DefaultDetais(string tableName, int id)
{
DataRow row = MyExcel.GetDetails(tableName, id);
return(View(row));
}