SHARE
TWEET

Untitled

a guest Mar 1st, 2017 187 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     var _List := (from arec in fDatamodule.DataAdapter.GetTable<lpv8oelib.Data.admanage>
  2.               where (arec.InvoiceDate>=d1)
  3.               where (arec.InvoiceDate<=d2)
  4.  
  5.               join brec in fDataModule.dataAdapter.GetTable<lpv8oelib.data.aprecbills>
  6.               on new class(F1 := arec.ReconID,F2 := arec.ApplyToBill) equals new class(F1 := brec.ReconID,F2 := brec.BillNumber)
  7.  
  8.             join prec in fDatamodule.DataAdapter.GetTable<lpv8oelib.data.pubfile>
  9.             on arec.PubNumber equals prec.PubNumber
  10.  
  11.             into pajoin
  12.  
  13.             from parec in pajoin
  14.             select new class (AdNumber := arec.AdNumber,
  15.                               EntryYear := arec.EntryYear,
  16.                               ReconID := arec.ReconID,
  17.                               BillNum := arec.ApplyToBill,
  18.                               PayType := parec.PaymentType,
  19.                               IsReconciled := arec.IsReconciled,
  20.                               InvoiceNumber := arec.InvoiceNumber,
  21.                               InvoiceDate := arec.InvoiceDate,
  22.                               PubNumber := arec.PubNumber,
  23.                               PubName := parec.PubName,
  24.                               CheckDate := arec.CheckDate,
  25.                               CheckNumber := arec.CheckNumber,
  26.                               GrossBilled := arec.GrossBilled,
  27.                               NetBilled := arec.NetBilled,
  28.                               NetRecon := arec.NetRecon,
  29.                               Revenue := arec.Revenue,
  30.                               Margin := arec.Margin,
  31.                               FullAdNumber := arec.AdNumber+arec.EntryYear )).ToList;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top