/// <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++;
}
