public DataTable GetProjectManpowerReport(ProjectReportSearch search)
{
var projectIDs = "";
if (search.projectIds != null)
{
search.projectIds.ForEach(item => {
projectIDs += "," + item;
});
projectIDs = projectIDs.TrimStart(',');
}
DataTable dt = new DataTable();
EnsureConnectionOpen();
using (var command = CreateCommand("Proc_ProjectManpowerReport", CommandType.StoredProcedure,
new SqlParameter("startDate", search.startDate), new SqlParameter("endDate", search.endDate),
new SqlParameter("projectIDs", projectIDs), new SqlParameter("currentUserID", search.currentUserID)))
{
using (var da = new SqlDataAdapter(command))
{
da.Fill(dt);
}
}
return(dt);
}
public ActionResult GetReport(ProjectReportSearch search)
{
search.currentUserID = Common.CommonHelper.CurrentUser;
DataTable dt = _reportAppService.GetProjectManpowerReport(search);
string JSONresult = JsonConvert.SerializeObject(dt);
return(Json(new { data = JSONresult }, JsonRequestBehavior.AllowGet));
}
public FileResult GetExcelForReport(ProjectReportSearch search)
{
search.currentUserID = Common.CommonHelper.CurrentUser;
DataTable dt = _reportAppService.GetProjectReport(search);
string sheetName = "项目工时统计报表";
var book = Common.CommonHelper.CreateHSSFromDataTable(sheetName, dt, new List <int>()
{
}, true);
MemoryStream ms = new MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return(File(ms, "application/vnd.ms-excel", sheetName + ".xls"));
}