有一个字段下面没有获取姓名,发现是方法没写
.net版本
var counts = list.Count;
list = list.Skip((page - 1) * rows).Take(rows).ToList();
DataTable dt = DataTableHelper.ListToDataTable(list);
dt.Columns.Add("verifyuserName");//认证人姓名
dt.Columns.Add("vipNumberID");//根据会员卡号去找与客户id对应的客户id
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var model1 = DBHelpToModel<T_USER>.Select().Where(m => m.id == row["verifyuser"].ToString()).SingleOrDefault();
var model2 = DBHelpToModel<B_CUSTOMER_INFO>.Select().Where(m => m.customer_id_number != null).Where(m => m.customer_id_number.Trim() == row["vipcard"].ToString().Trim()).SingleOrDefault();
if (model1 != null)
{
row["verifyuserName"] = model1.user_name;
}
if (model2 != null)
{
row["vipNumberID"] = model2.id;
}
}
}
改成Java版本,直接改for each里面内容,上面的for each都不用管
for (BuserVO item:list){
Tuser model1=tuserMapper.selectList(new QueryWrapper<Tuser>().eq("id",item.getVerifyuser())).stream().findFirst().orElse(null);
BcustomerInfo model2=bcustomerInfoMapper.selectList(new QueryWrapper<BcustomerInfo>().eq("customer_id_number",item.getVipcard())).stream().findFirst().orElse(null);
if(model1!=null){
item.setVerifyUserName(model1.getUserName());
}
if(model2!=null){
item.setVipNumberID(model2.getId());
}
}