public static void Create(db_dataContext context, string deviceName, string folderName) { var deviceReport = folderName == null; exApp = new Excel.Application(); exApp.SheetsInNewWorkbook = 1; exApp.Workbooks.Add(); Excel.Worksheet sheet = exApp.Workbooks[1].Worksheets.Item[1]; var device = context.storage.First(s => s.name == deviceName); var index = 1; sheet.Range["A1", "A1"].Value = "Устройство: " + device.name; sheet.Range["A2", "A2"].Value = "Тип: " + context.mediaTypes.First(t => t.id == device.type).name; sheet.Range["A3", "A3"].Value = "Ёмкость: " + device.capacityMb + " МБ"; foreach (var folder in context.folders.ToList() .Where(f => deviceReport ? device.folders.Contains(f) : f.name == folderName)) { sheet.Range["B" + index, "B" + index].Value = folder.name; if (folder.files.Count == 0) { index++; } foreach (var file in folder.files.Where(file => folder.files.Contains(file))) { sheet.Range["C" + index, "C" + index].Value = file.name + file.extension; sheet.Range["D" + index, "D" + index].Value = "(размер: " + file.sizeKb + " кБ)"; index++; } } exApp.Visible = true; }
private void AddButton_OnClick(object sender, RoutedEventArgs e) { ServerName = textBoxName.Text; context = new db_dataContext( @"metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=""data source=" + textBoxName.Text + @";initial catalog=db_data;user id=sa;password=1;MultipleActiveResultSets=True;App=EntityFramework"""); Close(); }