public void TestFill_1()
{
Student stu = new Student {
ClassName = "软件研发部", Name = "库管员", Birthday = DateTime.Today, Name2 = "测试人员"
};
List <Grade> gradeList = new List <Grade> {
new Grade {
Name = "DVD光盘", Brand = "紫光", UnitName = "个", Quantity = 10, Price = 5.0
}, new Grade {
Name = "计算机", Brand = "Dell", UnitName = "台", Quantity = 1, Price = 5000.0
}
, new Grade {
Name = "硬盘", Brand = "华硕", Spec = "2T", UnitName = "个", Quantity = 1, Price = 600.0
}, new Grade {
Name = "液晶显示器", Brand = "Dell", Spec = "21寸宽屏", UnitName = "台", Quantity = 1, Price = 2000.0
}
};
stu.Total = gradeList.Sum(g => g.Quantity * g.Price);
GradeExport_1 gExport = new GradeExport_1(configFile, tableId);
gExport.ExportId = "1";
gExport.Fill <Student>(AppDomain.CurrentDomain.BaseDirectory.TrimEnd('\\') + "\\Excel\\fill.xls", AppDomain.CurrentDomain.BaseDirectory.TrimEnd('\\') + "\\Excel\\fill1.xls", gradeList, stu);
gExport.Fill <Student>(AppDomain.CurrentDomain.BaseDirectory.TrimEnd('\\') + "\\Excel\\fill.xlsx", AppDomain.CurrentDomain.BaseDirectory.TrimEnd('\\') + "\\Excel\\fill1.xlsx", gradeList, stu);
}
public void TestExport_1()
{
List <Grade> gradeList = new List <Grade> {
new Grade {
ClassId = "一班", StudentId = "1", Html = 60
}, new Grade {
ClassId = "二班", StudentId = "1", Java = 70
}
};
GradeExport_1 gExport = new GradeExport_1(configFile, tableId);
gExport.ExportId = "2";
gExport.Export(AppDomain.CurrentDomain.BaseDirectory.TrimEnd('\\') + "\\Excel\\export.xls", gradeList);
}
