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 = ""
}));
}
