JsonHelper Read More
日志帮助类（内容很杂） Read More
public class XmlOp { //声明一个XmlDocument空对象 protected XmlDocument XmlDoc = new XmlDocument(); /// <summary> /// 构造函数，导入Xml文件 /// </summary> /// <param name="xmlFile">文件虚拟路径</param> public XmlOp(string xmlFile) { try { ... Read More
报表中的SQL查询 Read More
统计报表 Read More
private static Stream ExportDataTableToExcel(DataTable sourceTable, string sheetName) { HSSFWorkbook workbook = new HSSFWorkbook(); MemoryStream ms = new MemoryStream(); ISheet sheet = workbook.CreateSheet(sheetName); IRow headerRow = sheet.Create... Read More
private static Stream ExportDataTableToExcel(DataTable sourceTable, string sheetName) { HSSFWorkbook workbook = new HSSFWorkbook(); MemoryStream ms = new MemoryStream(); ISheet sheet = workbook.CreateSheet(sheetName); IRow headerRow = sheet.C... Read More
///<summary> ///将DataTable中的数据导出到指定的Excel文件中 ///</summary> ///<param name="page">Web页面对象</param> ///<param name="tab">包含被导出数据的DataTable对象</param> ///<param name="FileName">Excel文件的名称</param> public static void ... Read More