/// <summary> /// 表格底部信息输出 /// </summary> protected override void BuildFooter() { TempRow = Sheet.CreateRow(NextRowIndex); // // 单位负责人签字 // TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("单位负责人签字:")); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); // // 填表人签字 // TempCell = TempRow.CreateCell(5); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("填表人签字:")); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 5, 8)); // // 填表日期 // TempCell = TempRow.CreateCell(9); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("填表日期:")); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 9, 10)); //TempCell = TempRow.CreateCell(0); //TempCell.CellStyle = FooterCellStyle; //TempCell.SetCellValue(string.Format("打印日期:{0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); //Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 5)); NextRowIndex++; }
protected override void BuildFooter() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = FooterCellStyle; TempCell.SetCellValue(string.Format("打印日期:{0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 5)); NextRowIndex++; }
protected override void BuildFooter() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = FooterCellStyle; TempCell.SetCellValue("注:请各校打印此表加盖公章,需纸制文档与电子文档各一份。"); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 6)); NextRowIndex++; }
protected override void BuildTitle() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = HeaderStyle; TempCell.SetCellValue("资产维修单"); //设置单元格的高度 TempRow.Height = 30 * 20; Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 5)); NextRowIndex++; }
protected override void BuildHeader() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("编号:{0}", _borrowDto.BorrowInfo.EntityId.ToString().PadLeft(8, '0'))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); TempCell = TempRow.CreateCell(2); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("借用日期:{0}", _borrowDto.BorrowInfo.BorrowDate.ToString("yyyy-MM-dd"))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 3)); TempCell = TempRow.CreateCell(4); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("预计归还日期:{0}", _borrowDto.BorrowInfo.BorrowLong.ToString("yyyy-MM-dd"))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 4, 5)); NextRowIndex++; TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("借用人:{0}", _borrowDto.BorrowInfo.BorrowPerson)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); TempCell = TempRow.CreateCell(2); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("所在部门:{0}", _borrowDto.BorrowInfo.BorrowDeparitment)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 3)); TempCell = TempRow.CreateCell(4); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("联系方式:{0}", _borrowDto.BorrowInfo.BorrowPersonPhone)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 4, 5)); //设置单元格的宽度 Sheet.SetColumnWidth(0, 20 * 256); Sheet.SetColumnWidth(1, 20 * 256); Sheet.SetColumnWidth(2, 20 * 256); Sheet.SetColumnWidth(3, 20 * 256); Sheet.SetColumnWidth(4, 20 * 256); Sheet.SetColumnWidth(5, 20 * 256); NextRowIndex++; TempRow = Sheet.CreateRow(NextRowIndex); TempRow.CreateCell(0).SetCellValue(string.Format("借用用途:{0}", _borrowDto.BorrowInfo.BorrowUse)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 5)); NextRowIndex++; }
protected override void BuildHeader() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("编号:{0}", _repairDto.RepairInfo.EntityId.ToString().PadLeft(8, '0'))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); TempCell = TempRow.CreateCell(2); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("报修日期:{0}", _repairDto.RepairInfo.RepairDate.ToString("yyyy-MM-dd"))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 3)); TempCell = TempRow.CreateCell(4); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("维修日期:{0}", _repairDto.RepairInfo.ServicesDate.ToString("yyyy-MM-dd"))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 4, 5)); NextRowIndex++; TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("维修人:{0}", _repairDto.RepairInfo.ServicesPerson)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); TempCell = TempRow.CreateCell(2); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("联系方式:{0}", _repairDto.RepairInfo.ServicesPersonPhone)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 3)); //设置单元格的宽度 Sheet.SetColumnWidth(0, 20 * 256); Sheet.SetColumnWidth(1, 20 * 256); Sheet.SetColumnWidth(2, 20 * 256); Sheet.SetColumnWidth(3, 20 * 256); Sheet.SetColumnWidth(4, 20 * 256); Sheet.SetColumnWidth(5, 20 * 256); NextRowIndex++; TempRow = Sheet.CreateRow(NextRowIndex); TempRow.CreateCell(0).SetCellValue(string.Format("维修说明:{0}", _repairDto.RepairInfo.ServicesMemo)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 5)); NextRowIndex++; }
protected override void BuildHeader() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("编号:{0}", _acquireDto.AquairInfo.EntityId.ToString().PadLeft(8, '0'))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); TempCell = TempRow.CreateCell(2); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("领用日期:{0}", _acquireDto.AquairInfo.AcquireDate.ToString("yyyy-MM-dd"))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 3)); TempCell = TempRow.CreateCell(4); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("退还日期:{0}", _acquireDto.AquairInfo.SendBackDate.ToString("yyyy-MM-dd"))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 4, 5)); NextRowIndex++; TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("退还人:{0}", _acquireDto.AquairInfo.SendBackPerson)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); /*TempCell = TempRow.CreateCell(2); * TempCell.CellStyle = CommCellStyle; * TempCell.SetCellValue(string.Format("联系方式:{0}", _borrowDto.BorrowInfo.re)); * Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 4, 5));*/ //设置单元格的宽度 Sheet.SetColumnWidth(0, 20 * 256); Sheet.SetColumnWidth(1, 20 * 256); Sheet.SetColumnWidth(2, 20 * 256); Sheet.SetColumnWidth(3, 20 * 256); Sheet.SetColumnWidth(4, 20 * 256); Sheet.SetColumnWidth(5, 20 * 256); NextRowIndex++; TempRow = Sheet.CreateRow(NextRowIndex); TempRow.CreateCell(0).SetCellValue(string.Format("退还说明:{0}", _acquireDto.AquairInfo.SendBackMemo)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 5)); NextRowIndex++; }
protected override void BuildTitle() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = HeaderStyle; TempCell.SetCellValue("海淀区行政事业单位国有资产处理明细表"); //设置单元格的高度 TempRow.Height = 30 * 20; IFont font = Workbook.CreateFont(); font.FontName = "宋体"; font.FontHeightInPoints = 19; font.Boldweight = (short)FontBoldWeight.Bold; TempCell.CellStyle.SetFont(font); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 10)); NextRowIndex++; }
protected override void BuildHeader() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("编号:{0}", _inventoryDto.InventoryInfo.EntityId.ToString().PadLeft(8, '0'))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); TempCell = TempRow.CreateCell(2); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("盘点日期:{0}", _inventoryDto.InventoryInfo.InventoryOperationDate.ToString("yyyy-MM-dd"))); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 3)); TempCell = TempRow.CreateCell(4); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("盘点人:{0}", _inventoryDto.InventoryInfo.InventoryOperationPerson)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 4, 5)); NextRowIndex++; TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("盘点部门:{0}", _inventoryDto.InventoryInfo.InventoryDepartment)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); TempCell = TempRow.CreateCell(2); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("操作部门:{0}", _inventoryDto.InventoryInfo.InventoryOperationDepartment)); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 3)); //TempCell.SetCellValue(string.Format("联系方式:{0}", _inventoryDto.InventoryInfo.)); //Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 3)); //设置单元格的宽度 Sheet.SetColumnWidth(0, 20 * 256); Sheet.SetColumnWidth(1, 20 * 256); Sheet.SetColumnWidth(2, 20 * 256); Sheet.SetColumnWidth(3, 20 * 256); Sheet.SetColumnWidth(4, 20 * 256); Sheet.SetColumnWidth(5, 20 * 256); NextRowIndex++; }
protected override void BuildHeader() { TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(0); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("填报单位名称(公章):")); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 0, 1)); // // 单位名称 // TempCell = TempRow.CreateCell(2); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(title); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 2, 4)); // 合并单元格 // // 编号 // //TempRow = Sheet.CreateRow(NextRowIndex); TempCell = TempRow.CreateCell(8); TempCell.CellStyle = CommCellStyle; TempCell.SetCellValue(string.Format("编号:")); Sheet.AddMergedRegion(new CellRangeAddress(NextRowIndex, NextRowIndex, 8, 9)); //设置单元格的宽度 //Sheet.SetColumnWidth(0, 20 * 10); // 序号 Sheet.SetColumnWidth(1, 20 * 300); // 资产名称 Sheet.SetColumnWidth(2, 20 * 256); // 资产名称 Sheet.SetColumnWidth(3, 20 * 256); // 资产名称 Sheet.SetColumnWidth(4, 20 * 256); // 规格型号 Sheet.SetColumnWidth(11, 20 * 300); // 处置单编号 NextRowIndex++; }