private DataTable GetDataTable()
{
//InvoiceSupplierCollection isC = new InvoiceSupplierCollection();
InvoiceSupplierQuery isQ = new InvoiceSupplierQuery("a");
isQ.es2.Connection.Name = "KENCANA";
InvoiceSupplierItemQuery isiQ = new InvoiceSupplierItemQuery("b");
isiQ.es2.Connection.Name = "KENCANA";
SupplierQuery sQ = new SupplierQuery("c");
sQ.es2.Connection.Name = "KENCANA";
isQ.Select(
isQ.InvoiceNo, sQ.SupplierName, isQ.InvoiceNotes, isiQ.TransactionNo.As("NO_POR"), isiQ.VerifyAmount, isiQ.PaymentAmount, isiQ.BankAccountNo.As("NO_BG"), isiQ.PPnAmount,
isiQ.PPh22Amount, isiQ.PPh23Amount,isQ.Isproces)
.InnerJoin(isiQ).On(isiQ.InvoiceNo == isQ.InvoiceNo)
.InnerJoin(sQ).On(sQ.SupplierID == isQ.SupplierID)
.Where(isQ.SRPayableStatus=="2" && isQ.IsVoid == false);
//isC.Load(isQ);
//foreach (InvoiceSupplier iS in isC)
//{
//}
DataTable dt = new DataTable();
try
{
dt = isQ.LoadDataTable();
}
catch (Exception ex)
{
string error = ex.Message;
}
return dt;
}
