求助,linq简化

[yj258213056]

哪位大哥帮忙看看下面的代码怎么简化,关键是这句

XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID))

怎么能只查询一次呢?

var data = sendDetails.Select(m => new
                {
                    CheltemName = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).CheltemBaseInfo.ChineseName,
                    ProductSpec = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).SupplierProductSpe,
                    RFID = m.RFID,
                    CabinetCode = m.CabinetSendDataInfo.CabinetCode,
                    DangerousLevel = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).CheltemBaseInfo.DangerousLevel,
                    InTime = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).InTime,
                    Remark = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).Remark
                });
                return data.ToList();

[yj258213056]

引用 4 楼 t101lian 的回复:

[quote=引用 楼主 yj258213056 的回复:] 哪位大哥帮忙看看下面的代码怎么简化,关键是这句

XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID))

怎么能只查询一次呢?

var data = sendDetails.Select(m => new
                {
                    CheltemName = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).CheltemBaseInfo.ChineseName,
                    ProductSpec = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).SupplierProductSpe,
                    RFID = m.RFID,
                    CabinetCode = m.CabinetSendDataInfo.CabinetCode,
                    DangerousLevel = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).CheltemBaseInfo.DangerousLevel,
                    InTime = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).InTime,
                    Remark = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).Remark
                });
                return data.ToList();

C++ ? ，，不好意思，，看错了， 不懂[/quote] C#

[yj258213056]

引用 5 楼 q107770540 的回复:

here we go:

var data= from m in sendDetails
          let x=XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID))
          select new 
          {
               CheltemName = x.ChineseName,
                    ProductSpec = x.SupplierProductSpe,
                    RFID = m.RFID,
                    CabinetCode = m.CabinetSendDataInfo.CabinetCode,
                    DangerousLevel = x.CheltemBaseInfo.DangerousLevel,
                    InTime = x.InTime,
                    Remark = x.Remark
          }

  return data.ToList();

非常感谢,嘿嘿. 原来还有个linq专区啊..

[yj258213056]

人工置顶,难道都去吃饭了么

[t101lian]

也碰到类似的问题，，还没解决。。 友情帮顶吧

[t101lian]

  var result = from a in AinfoList
                         join m in MinfoList on a.AID equals m.HangListid
                         join sa in AinfoSellLsit on m.OrderFormId equals sa.ASID
                         join u in UinfoList on m.BeatedUserID equals u.UserId
                         join b in BinfoList on a.UserName equals b.IDcard
                         select new
                         {
                             ID = DateTime.Now.ToString("yyyyMMdd") + "0000" + m.ID + m.Num,
                             GoodName = DateTime.Now.ToString("yyyyMMdd") + a.AName,
                             UserName = b.UserName,
                             B_Phone = b.Phone,
                             B_Bail = 2000,
                             u.NickName,
                             U_Phone = u.Phone,
                             U_Bail = m.Bail,
                             m.BuyAddress,
                             m.Num,
                             IDQ = m.ID
                         };


            this.gv.DataSource = result;

看起来你那比我这里复杂多啦

[t101lian]

引用 楼主 yj258213056 的回复:

哪位大哥帮忙看看下面的代码怎么简化,关键是这句

XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID))

怎么能只查询一次呢?

var data = sendDetails.Select(m => new
                {
                    CheltemName = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).CheltemBaseInfo.ChineseName,
                    ProductSpec = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).SupplierProductSpe,
                    RFID = m.RFID,
                    CabinetCode = m.CabinetSendDataInfo.CabinetCode,
                    DangerousLevel = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).CheltemBaseInfo.DangerousLevel,
                    InTime = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).InTime,
                    Remark = XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID)).Remark
                });
                return data.ToList();

C++ ? ，，不好意思，，看错了， 不懂

[q107770540]

here we go:

var data= from m in sendDetails
          let x=XpoSession.FindObject<CheltemInInfo>(CriteriaOperator.Parse("RFID=?", m.RFID))
          select new 
          {
               CheltemName = x.ChineseName,
                    ProductSpec = x.SupplierProductSpe,
                    RFID = m.RFID,
                    CabinetCode = m.CabinetSendDataInfo.CabinetCode,
                    DangerousLevel = x.CheltemBaseInfo.DangerousLevel,
                    InTime = x.InTime,
                    Remark = x.Remark
          }

  return data.ToList();

[q107770540]

Any questions about LINQ, please ask questions here: http://bbs.csdn.net/forums/LINQ