public async Task <OutCase> GetCaseList(InCase model) { OutCase outCase = new OutCase { Info = new List <OutCase_Info>() }; var express_c = string.Empty; var data = await iOHZBRepository.QueryFirstOrDefaultAsync <OhZb>("select * from OH_ZB where CID>0 and ID=@Id", new { Id = model.ID }); if (data != null) { express_c = data.ExpressC; } var sql = await adsSpAj330304Repository.GetCaseInfo(DateTime.Parse(model.StartTime).ToString("yyyyMM") + "01", Method.GetDaysByMonth(model.EndTime), express_c); var spdata = (await adsSpAj330304Repository.QueryAsync <dynamic>(sql)).ToList(); _logger.LogWarning($"sql 语句返回 dynamic {JsonConvert.SerializeObject(data)}"); for (int i = 0; i < spdata.Count; i++) { outCase.Info.Add(new OutCase_Info { XH = (1 + i).ToString(), AH = spdata[i].ah, AY = spdata[i].ay, BMMC = spdata[i].bmmc, CBRMC = spdata[i].cbrmc, AJLX = spdata[i].ajlx, SPCX = spdata[i].spcx, SARQ = spdata[i].sarq, JARQ = spdata[i].jarq, }); } return(outCase); }
public async Task <IActionResult> GetCaseList([FromForm] InCase model) { var data = await forService.GetCaseList(model); return(Ok(new ResutModel <OutCase> { data = data, errorCode = 0, errorMsg = "" })); }