public async Task <DataTable> GetSampleMSFDapperMethodAsync(SampleReportParameter reportParameter)
{
DataTable table = new DataTable(reportParameter.ReportName);
StringBuilder sql = new StringBuilder(@"select '产品研发' as 开发类型, a.xuqiusjr AS 姓名,a.renwuly as 类型,sum(a.yujigs) as 标准工时,sum(a.shijigs) as 实际工时 from mcrp_prod.prod_renwu a inner join mcrp_sys.sys_yonghuxx k on a.xuqiusjrid=k.id where k.zuofeibz=0 and k.yiyuanyhbz=0 and a.zuofeibz=0 and a.zhuangtai='已完成'");
sql.Append(" and a.chanpinid=:ChanPinID");
if (!string.IsNullOrEmpty(reportParameter.BuMenID))
{
sql.Append(" and k.gongsiid=:BuMenID");
}
sql.Append(" group by a.xuqiusjr,a.renwuly");
var reader = await _dbConnection.ExecuteReaderAsync(sql.ToString(), reportParameter);
table.Load(reader);
return(table);
}
public async Task <IActionResult> GetGongZuoLTJAsync([FromQuery] SampleReportParameter reportParameter)
{
string reportFile = Path.Combine(SampleReportConstant.CONST_REPORT_FRX_ROOT, $"jixiaotj-global-{reportParameter.ReportName.ToLower().ToString()}.frx");
if (string.IsNullOrWhiteSpace(reportParameter.ReportName))
{
return(BadRequest($"报表名{reportParameter.ReportName}-不存在"));
}
if (!System.IO.File.Exists(reportFile))
{
return(BadRequest($"{reportFile},报表文件不存在"));
}
DataTable dataSet = await _dapperMSFService.GetSampleMSFDapperMethodAsync(reportParameter);
WebReport WebReport = new WebReport();
WebReport.Report.Load(reportFile);
WebReport.Report.RegisterData(dataSet, "Reports");
ViewBag.WebReport = WebReport;
return(View("Report"));
}
