public static JsonStatus PrintDataTable()
{
JsonStatus js = new JsonStatus();
//PrintDocment objPrintDocment = new PrintDocment();
//objPrintDocment.PrintPage += new PrintPageEventHandler
return(js);
}
public static JsonStatus OutExecl(string path, DataTable dt, string[] titles, string fileName)
{
JsonStatus js = new JsonStatus();
try
{
object missing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
app.Application.Workbooks.Add(true);
Microsoft.Office.Interop.Excel.Workbook book = (Microsoft.Office.Interop.Excel.Workbook)app.ActiveWorkbook;
Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.ActiveSheet;
sheet.Cells[1, 1] = "序号";
for (int i = 0; i < titles.Length; i++)
{
sheet.Cells[1, i + 2] = titles[i];
}
for (int i = 0; i < dt.Rows.Count; i++)
{
sheet.Cells[i + 2, 1] = i + 1;
for (int j = 0; j < dt.Columns.Count; j++)
{
sheet.Cells[i + 2, j + 2] = dt.Rows[i][j];
}
}
string fn = DateTime.Now.ToString("yyyyMMddhhmmss") + "@" + fileName;
string filename = path + "/" + fn + ".xlsx";
if (File.Exists(filename))
{
File.Delete(filename);
}
book.SaveCopyAs(filename);
//关闭文件
book.Close(false, missing, missing);
//退出excel
app.Quit();
js.status = "1";
js.msg = fn;
}
catch (Exception e)
{
js.status = "0";
js.msg = "导出失败！未知错误！" + e.Message;
}
return(js);
}
public JsonStatus ClearSystemIn(string path)
{
JsonStatus js = new JsonStatus();
try
{
Directory.Delete(path, true);
Directory.CreateDirectory(path);
js.status = "1";
js.msg = "清除成功！";
}
catch
{
js.status = "0";
js.msg = "清除失败！未知错误！";
}
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
return(js);
}
