日期:2014-05-17 浏览次数:21373 次
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>();