工具栏
// 按钮不可按tool.SharedProps.Enabled = false;
Grid
// Grid中记录时间// 建议SQL Server中使用字符字段(没有深入测试,只是字符字段可行),然后设置Grid的属性中,列的Style属性为Time或TimeWithSpin// 使用代码为Grid列排序// 应该先将所有列的VisiblePosition设置为0,再重新设置每一列的值;而且要先从前往后的顺序排列。// 表格// 是否允许修改ltGrid1.DisplayLayout.Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False;// 是否允许换行ltGrid1.DisplayLayout.Override.CellMultiLine = Infragistics.Win.DefaultableBoolean.False;// 多层表格下,第2层表格不显示列头,第1层表格只在第一行显示列头ltGrid1.DisplayLayout.Bands[0].Override.HeaderPlacement = HeaderPlacement.FixedOnTop;ltGrid1.DisplayLayout.Bands[1].ColHeadersVisible = false;// 列// 新绑定的数据列是否显示对应表格列ltGrid1.DisplayLayout.NewColumnLoadStyle = NewColumnLoadStyle.Hide;// 禁止列进行排序ltGrid1.DisplayLayout.Bands[0].Columns["总库存"].SortIndicator = SortIndicator.Disabled;// 在bool类型的列上,显示全选按钮ultraGridColumn423.Header.CheckBoxVisibility = Infragistics.Win.UltraWinGrid.HeaderCheckBoxVisibility.Always;// 最后一列填充满GridltGrid1.DisplayLayout.AutoFitStyle = AutoFitStyle.ExtendLastColumn;// 显示合计summarySettings1.DisplayFormat = "{0}";summarySettings1.GroupBySummaryValueAppearance = appearance2;summarySettings1.ShowCalculatingText = Infragistics.Win.DefaultableBoolean.False;summarySettings1.SummaryDisplayArea = Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.BottomFixed;ultraGridBand1.Summaries.AddRange(new Infragistics.Win.UltraWinGrid.SummarySettings[] {summarySettings1});ultraGridBand1.SummaryFooterCaption = "";// 行// Grid中获取过滤后的行UltraGridRow[] rows = grid.Rows.GetFilteredInNonGroupByRows();// 单元格// 某个单元格是否可以修改ltGrid1.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;// 某个单元格的颜色ltGrid1.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = Color.Aqua;// 允许树状结构grid1.DisplayLayout.ViewStyle = ViewStyle.MultiBand;// 设置最大层数grid1.DisplayLayout.MaxBandDepth = 2;// 树状结构展开和收缩foreach (var row in ltGrid1.Rows){ row.Expanded = true; row.ExpandAll(); row.CollapseAll();}
Excel导出
// 打开保存窗口,得到保存文件路径String fileName = "";SaveFileDialog dialog = new SaveFileDialog();dialog.FileName = txtAssmItemNoPrefix.Text; // 默认文件名dialog.Filter = "Excel Worksheets|*.xls"; // 文件类型过滤器if (dialog.ShowDialog() == DialogResult.OK) fileName = dialog.FileName;dialog.Dispose();// 可以把Excel模版放到资源文件中var buffer = Properties.Resources.Excel模版;using (Stream output = File.OpenWrite(fileName)){ output.Write(buffer, 0, buffer.Length);}// 打开Excel表Workbook workbook = Workbook.Load(fileName);// 选择工作表Worksheet sheetHeader = workbook.Worksheets[0];// 去掉合并单元格sheetHeader.MergedCellsRegions.Remove(sheetHeader.Rows[0].GetCellAssociatedMergedCellsRegion(0));// 增加合并单元格WorksheetMergedCellsRegion sheetRegion = sheetHeader.MergedCellsRegions.Add(0, 0, 0, 12);// 合并单元格赋值sheetRegion.Value = "标题1";// 水平居中sheetRegion.CellFormat.Alignment = HorizontalCellAlignment.Center;// 垂直居中sheetRegion.CellFormat.VerticalAlignment = VerticalCellAlignment.Center;// 自动换行sheetRegion.CellFormat.WrapText = ExcelDefaultableBoolean.True;// 行高sheetHeader.Rows[1].Height = sheetHeader.Rows[1].Height * 3;// 行和列都是从0开始// 单元格赋值sheetHeader.Rows[1].Cells[1].Value = DateTime.Now;//订货日期sheetHeader.Rows[1].Cells[2].Value = "文字";//销售员// 水平居中sheetHeader.Rows[1].Cells[2].CellFormat.Alignment = HorizontalCellAlignment.Center;// 垂直居中sheetHeader.Rows[1].Cells[2].CellFormat.VerticalAlignment = VerticalCellAlignment.Center;// 自动换行sheetHeader.Rows[1].Cells[2].CellFormat.WrapText = ExcelDefaultableBoolean.True;// 保存Excelworkbook.Save(fileName);