/// <summary>
/// 文档格式预定义好的，只填写内容
/// </summary>
/// <param name="obj"></param>
/// <summary>
/// 开关跳闸记录簿
/// </summary>
/// <param name="nrList"></param>
public static void ExportExcel(sdjls_dgjcjl dgjc,IList<sdjls_dgjcjlnr> nrList)
{
#region 开关跳闸记录
ExcelAccess ex = new ExcelAccess();
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = Application.StartupPath + "\\00记录模板\\送电09登杆检查记录.xls";
ex.Open(fname);
int row = 1;
//加页
int pageindex = 1;
if (pageindex < Ecommon.GetPagecount(nrList.Count, 17))
{
pageindex = Ecommon.GetPagecount(nrList.Count, 17);
}
for (int j = 1; j <= pageindex; j++)
{
ex.ActiveSheet(1);
if (j > 1)
{
ex.CopySheet(1, 1);
}
ex.SetCellValue(dgjc.LineName, 3, 3);
ex.SetCellValue(dgjc.LineVol, 3, 8);
}
for (int j = 1; j <= pageindex; j++)
{
ex.ActiveSheet(j);
//ex.ReNameWorkSheet(j, "Sheet" + (j));
int prepageindex = j - 1;
//主题
int starow = prepageindex * 17 + 1;
int endrow = j * 17;
if (nrList.Count > endrow)
{
for (int i = 0; i < 17; i++)
{
ex.SetCellValue(nrList[starow - 1 + i].jcrq.Year.ToString(), row + 5 + i, 1);
ex.SetCellValue(nrList[starow - 1 + i].jcrq.Month.ToString(), row + 5 + i, 2);
ex.SetCellValue(nrList[starow - 1 + i].jcrq.Day.ToString(), row + 5 + i, 3);
ex.SetCellValue(nrList[starow - 1 + i].qsgtbh, row + 5 + i, 4);
ex.SetCellValue(nrList[starow - 1 + i].zzgtbh, row + 5 + i, 5);
ex.SetCellValue(nrList[starow - 1 + i].jcjg, row + 5 + i, 6);
ex.SetCellValue(nrList[starow - 1 + i].jcr, row + 5 + i, 7);
ex.SetCellValue(nrList[starow - 1 + i].bz, row + 5 + i, 8);
}
}
else if (nrList.Count <= endrow && nrList.Count >= starow)
{
for (int i = 0; i < nrList.Count - starow + 1; i++)
{
ex.SetCellValue(nrList[starow - 1 + i].jcrq.Year.ToString(), row + 5 + i, 1);
ex.SetCellValue(nrList[starow - 1 + i].jcrq.Month.ToString(), row + 5 + i, 2);
ex.SetCellValue(nrList[starow - 1 + i].jcrq.Day.ToString(), row + 5 + i, 3);
ex.SetCellValue(nrList[starow - 1 + i].qsgtbh, row + 5 + i, 4);
ex.SetCellValue(nrList[starow - 1 + i].zzgtbh, row + 5 + i, 5);
ex.SetCellValue(nrList[starow - 1 + i].jcjg, row + 5 + i, 6);
ex.SetCellValue(nrList[starow - 1 + i].jcr, row + 5 + i, 7);
ex.SetCellValue(nrList[starow - 1 + i].bz, row + 5 + i, 8);
}
}
}
ex.ActiveSheet(1);
ex.ShowExcel();
#endregion
}
void gridViewOperation_CreatingObjectEvent(sdjls_dgjcjl obj) {
//obj.OrgCode = MainHelper.User.OrgCode;
//obj.OrgName = MainHelper.User.OrgName;
}
