public DataTable GetDepartmentALL()
{
Connection con = new Connection();
var department = JsonConvert.DeserializeObject <List <Model.Question> >(con.Json(path));
List <Model.Question> dt = (from c in department select c).ToList();
return(ConvertToDataTable.ToDataTable(dt));
}
public DataTable GetDepartmentnameFromDepartmentID(int departmentID)
{
Connection con = new Connection();
var department = JsonConvert.DeserializeObject <List <Model.Question> >(con.Json(path));
List <Model.Question> dt = (from c in department where c.DepartmentID == departmentID select c).ToList();
return(ConvertToDataTable.ToDataTable(dt));
}
public JsonResult RenderToExcel(int code, DateTime startdt, DateTime enddt, string queryname, string content, string filename)
{
Response resp = new Response();
Log log = LogFactory.GetLogger("RenderToExcel");
#region
try
{
int totalnum;
if (code == 1) //是报文记录
{
List <TelegramLog> lst = new CWTelegramLog().FindPageList(0, 0, startdt, enddt, queryname, content, out totalnum);
if (lst.Count > 0)
{
List <TelegramLog> filterLst = new List <TelegramLog>();
if (totalnum > 1000)
{
filterLst = lst.Skip(0).Take(1000).ToList();
}
else
{
filterLst.AddRange(lst);
}
DataTable dt = ConvertToDataTable.ToDataTable <TelegramLog>(filterLst);
string path = ExcelUtility.Instance.RenderDataTableToExcel(dt, "报文日志报表", filename, 12);
resp.Code = 1;
resp.Message = "数据导出成功，记录数- " + filterLst.Count + " ,文件路径- " + path;
}
else
{
resp.Message = "没有记录要导出.";
}
}
else if (code == 2) //是操作记录
{
List <OperateLog> lst = new CWOperateRecordLog().FindPageList(0, 0, startdt, enddt, queryname, content, out totalnum);
if (lst.Count > 0)
{
List <OperateLog> filterLst = new List <OperateLog>();
if (totalnum > 1000)
{
filterLst = lst.Skip(0).Take(1000).ToList();
}
else
{
filterLst.AddRange(lst);
}
DataTable dt = ConvertToDataTable.ToDataTable <OperateLog>(filterLst);
string path = ExcelUtility.Instance.RenderDataTableToExcel(dt, "操作日志报表", filename, 4);
resp.Code = 1;
resp.Message = "数据导出成功，记录数- " + filterLst.Count + " ,文件路径- " + path;
}
else
{
resp.Message = "没有记录要导出.";
}
}
}
catch (Exception ex)
{
log.Error("报表，导出到EXCEL异常：" + ex.ToString());
resp.Message = "数据导出失败，请联供应商！";
}
#endregion
return(Json(resp, JsonRequestBehavior.AllowGet));
}