日期:2014-05-17 浏览次数:21525 次
listEntity = db.ExecuteStoreQuery<Object>("select t.toclientid,t.customname,t.customphone,t.customaddress from jc_goodstoclient t where not exists (select ftc.toclientid from jc_fromreftoclient ftc where ftc.toclientid=t.toclientid and ftc.fromclientid=:fromclientid) and t.status=:status and t.companycode=:companycode and t.mnemonic=:mnemonic", new System.Data.Objects.ObjectParameter[]{
new System.Data.Objects.ObjectParameter ("fromclientid",nvc["FROMCLIENTID"]),
new System.Data.Objects.ObjectParameter ("status","1"),
new System.Data.Objects.ObjectParameter ("companycode",useEntity.CompanyCode),
new System.Data.Objects.ObjectParameter ("mnemonic",nvc["MNEMONIC"])
}).Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList<Object>();