SqlFunc.JsonField问题 返回
var DTReportImageInfos = await _db.Queryable<DTReportImageInfo>()
.Where(d => DTReports.Contains(d.RNO))
.Select(x => new
{
x.ID,
s = SqlFunc.JsonField(x.ImageUpInfo, "value")
})
.ToListAsync();
为什么查询不到里面的value呢?我不想指定位置查询因为他是一个数组来的我现在想找到他的:医票票据号码这里怎么办呢?
用的是mysql
这个是他数据库字段的值
[{"fieName":"医票诊断日期","value":"已付款","Candidatevalue":""},{"fieName":"医票疾病诊断","value":"123123","Candidatevalue":""},{"fieName":"医票就诊医院","value":"请登录江苏省财政电子票据公共服务平台 (http://einvoice,jsezt,cn)。财政电子票据可作为报销凭证,","Candidatevalue":""},{"fieName":"医票诊疗方式","value":"门诊","Candidatevalue":""},{"fieName":"医票就诊天数","value":"1222111","Candidatevalue":""},{"fieName":"医票票据代码","value":"32060124","Candidatevalue":""},{"fieName":"医票票据号码","value":"1138628133","Candidatevalue":""},{"fieName":"医票校验码","value":"112942","Candidatevalue":""},{"fieName":"医票交款人","value":"陈之梧","Candidatevalue":""},{"fieName":"医票开票日期","value":"2025-10-26","Candidatevalue":""},{"fieName":"医票票据金额","value":"600.00","Candidatevalue":""},{"fieName":"医票社保支付(含农合)","value":"60.00","Candidatevalue":""},{"fieName":"医票自付二/乙类自负","value":"100","Candidatevalue":""},{"fieName":"医票丙类自负/自费","value":"80","Candidatevalue":""}]
热忱回答(3)
-
fate sta VIP0
2026/3/18你 这个是集合,filedName是用于单个{}
0 回复 -
fate sta VIP0
2026/3/18复杂的可以看文档:扩展函数
0 回复 -
night VIP0
2026/3/19@fate sta:还有其他方法吗?我不想写sql语句想用linq来实现
0 回复