rendered paste body if( BatchID.Text != "" )
{
this.utvBatchLookup.Nodes.Add( "General Ledger Batch" );
this.utvBatchLookup.Nodes.Add( "Invoice Batch" );
this.utvBatchLookup.Nodes.Add( "General Ledger Batch Detail" );
// Load the Tree
DataSet ds = clsGL._GL_Batch( CompNo, BatchID.Text );
this.utvBatchLookup.Nodes[ 0 ].Nodes.SetDataBinding( ds, ds.Tables[ 0 ].TableName );
ds = clsGL._Gl_Batch_Invoices( CompNo, BatchID.Text );
this.utvBatchLookup.Nodes[ 1 ].Nodes.SetDataBinding( ds, ds.Tables[ 0 ].TableName );
// this.utvBatchLookup.SetDataBinding( ds, ds.Tables[ 0 ].TableName );
//this.ultraTree1.SetDataBinding(ds, ds.Tables[0].TableName);
//
// this.ugvTenderPayment.DataSource = _Tender_Payments();
// this.ugvROA.DataSource = _ROA_Detail();
// this.ugvMiscAdjustments.DataSource = _MiscAdjustments_Detail();
}
#region GL invoices
public static DataSet _Gl_Batch_Invoices(int CompNo, string BatchNo)
{
DataSet objDs = new DataSet();
DataTable dtMain = new DataTable();
DataTable dtSub = new DataTable();
DataRow drCat;
int iTotal = 0;
/* Sales
CompanyID, OrderID, OrderTypeID, OrderTypeSubID, OrderStageID, OrderProgressID, OrderStatus, TransferNo, InvoiceNo, sContactID, bCustomerID,
bCustomerName, Re, Terms, CustomerPoNo, WebOrderNo, InvoiceTypeID, PoNo, Reoccur, sMaintenance, TaxGroup, TotalCost, SubTotalSell,
FreightTotal, GrandTotalSell, Paid, oPay, oPayAmount, TenderName, PaymentID, InvoiceDate, OrderedDate, PrintedDate, FaxedDate, EmailedDate,
ShippingIn, SellLevel, ServiceTagNo, EnteredByID, SalesNo, SalesCompanyNo, LabourBilled, DailyBatchNo, DailyBatchNoDate, ConsolidatedBatchNo,
ConsolidatedBatchDate
*/
dtMain.Columns.Add( "InvoiceDate", typeof( string ) ); // 0
dtMain.Columns.Add( "bCustomerID", typeof( string ) ); // 1
dtMain.Columns.Add( "OrderID", typeof( string ) ); // 2
dtMain.Columns.Add( "TenderName", typeof( string ) ); // 3
dtMain.Columns.Add( "Paid", typeof( string ) ); // 4
dtMain.Columns.Add( "bCustomerName", typeof( string ) ); // 5
dtMain.Columns.Add( "InvoiceNo", typeof( string ) ); // 6
dtMain.Columns.Add( "GrandTotalSell", typeof( string ) ); // 7
dtMain.Columns.Add( "TenderID", typeof( string ) ); // 8
dtMain.Columns.Add( "OrderStageID", typeof( string ) ); //9
dtMain.Columns.Add( "TenderColor", typeof( string ) ); // 10
dtMain.Columns.Add( "OrderTypeID", typeof( string ) ); // 11
// Payment Detail
//CompanyID, PaymentID, PaymentRecNo, OrderID, InvoiceNo, CustomerID, CompanyName, TransactionDate, TransactionTypeID, TransactionType,
// TransactionNo, BatchNo, TenderType, TenderMethod, TenderAmount, DepositNo, DepositDate, ConsolidatedBatchNo, ConsolidatedBatchDate, UserID, StationID
dtSub.Columns.Add( "PaymentID", typeof( string ) ); // 0
dtSub.Columns.Add( "OrderID", typeof( string ) ); // 1
dtSub.Columns.Add( "InvoiceNo", typeof( string ) ); // 2
dtSub.Columns.Add( "TenderMethod", typeof( string ) ); // 3
dtSub.Columns.Add( "TransactionNo", typeof( string ) ); // 4
dtSub.Columns.Add( "AppliedDate", typeof( string ) ); // 5
dtSub.Columns.Add( "TenderAmount", typeof( string ) ); // 6
dtSub.Columns.Add( "TransactionDate", typeof( string ) ); // 7
dtSub.Columns.Add( "UserID", typeof( string ) ); // 8
dtSub.Columns.Add( "StationID", typeof( string ) ); // 9
dtSub.Columns.Add( "TenderColor", typeof( string ) ); // 10
try
{
SqlDataReader oRd, oRdP;
// sales
clsTLK.clsTableSelect( "Sales",
"CompanyID = " + "'" + CompNo + "'" + " ) AND ( " +
"ConsolidatedBatchNo = " + "'" + BatchNo + "'",
"CompanyID, OrderStageID, InvoiceNo ",
"CompanyID, OrderID, OrderTypeID, OrderStageID, InvoiceNo, bCustomerID, bCustomerName, GrandTotalSell, Paid, TenderName, TenderID, InvoiceDate " );
//, OrderTypeSubID, OrderProgressID, OrderStatus, TransferNo , sContactID Re, Terms, CustomerPoNo, WebOrderNo, InvoiceTypeID, PoNo, Reoccur, sMaintenance, TaxGroup, TotalCost, SubTotalSell,FreightTotal, OrderedDate, PrintedDate, FaxedDate, EmailedDate,ShippingIn, SellLevel, ServiceTagNo, EnteredByID, SalesNo, SalesCompanyNo, LabourBilled, DailyBatchNo, DailyBatchNoDate, ConsolidatedBatchNo,ConsolidatedBatchDate, oPay, oPayAmount
oRd = clsTLK.TLSql.ExecuteReader( CommandBehavior.CloseConnection );
if( oRd.HasRows )
{
while( oRd.Read() )
{
iTotal++;
drCat = dtMain.NewRow();
drCat[ 0 ] = clsCon.MMMDDYYYY( oRd[ 11 ].ToString() ); // InvoiceDate
drCat[ 1 ] = oRd[ 5 ].ToString(); // bCustomerID
drCat[ 2 ] = oRd[ 1 ].ToString(); // OrderID
drCat[ 3 ] = oRd[ 9 ].ToString(); // TenderName
drCat[ 4 ] = oRd[ 8 ].ToString(); // Paid
drCat[ 5 ] = oRd[ 6 ].ToString(); // bCustomerName
drCat[ 6 ] = oRd[ 4 ].ToString(); // InvoiceNo
drCat[ 7 ] = oRd[ 7 ].ToString(); // GrandTotalSell
drCat[ 8 ] = oRd[ 10 ].ToString(); // TenderID
drCat[ 9 ] = oRd[ 3 ].ToString(); // OrderStageID
cls_Color.Color_Tender( CompNo, oRd[ 10 ].ToString() ); // TenderColor
drCat[ 10 ] = cls_Color.Back;
drCat[ 11 ] = oRd[ 2 ].ToString(); // OrderTypeID
dtMain.Rows.Add( drCat );
// Payment Detail
string sdf = oRd[ 1 ].ToString();
clsTLK.clsTableSelect( "PaymentDetail",
"CompanyID = " + "'" + CompNo + "'" + " ) AND ( " +
"OrderID = " + "'" + oRd[ 1 ].ToString() + "'",
"CompanyID, PaymentID",
"PaymentID, OrderID, InvoiceNo , TenderMethod,TransactionNo, AppliedDate ,TenderAmount, TransactionDate, UserID, StationID, TenderType"
);
oRdP = clsTLK.TLSql.ExecuteReader( CommandBehavior.CloseConnection );
if( oRdP.HasRows )
{
while( oRdP.Read() )
{
// if( oRdP[ 6 ].ToString() != "" )
// dcTotPay += clsCon.Rou_2D( oRdP[ 6 ].ToString() );
drCat = dtSub.NewRow();
drCat[ 0 ] = Convert.ToString( oRdP[ 0 ] ); //PaymentID
drCat[ 1 ] = Convert.ToString( oRdP[ 1 ] ); //OrderID
drCat[ 2 ] = Convert.ToString( oRdP[ 2 ] ); //InvoiceNo
drCat[ 3 ] = Convert.ToString( oRdP[ 3 ] ); //TenderMethod
drCat[ 4 ] = Convert.ToString( oRdP[ 4 ] ); // TransactionNo
// AppliedDate
if( oRdP[ 5 ].ToString() != "" )
{
drCat[ 5 ] = clsCon.ddd_MMMDDYY_PM( oRdP[ 5 ].ToString() );
}
else
drCat[ 5 ] = "";
drCat[ 6 ] = Convert.ToString( oRdP[ 6 ] ); // TenderAmount
//TransactionDate
if( oRdP[ 7 ].ToString() != "" )
{
// fddgfd = oRdP[ 7 ].ToString();
drCat[ 7 ] = clsCon.ddd_MMMDDYY_PM( oRdP[ 7 ].ToString() );
}
else
drCat[ 7 ] = "";
// UserID
if( oRdP[ 8 ].ToString() != "" )
{
drCat[ 8 ] = clsTLK.clsTableGetOneFieldData( "SysName",
"SysCompanyID = " + "'" + oRd[ 0 ].ToString() + "'" + " ) AND ( " + "SysNameID = " + "'" + oRdP[ 8 ].ToString() + "'",
"SysCompanyID, SysNameID",
"SysLoginName" );
// drCat[ 5 ] = clsTLK.GetOneFieldData;
}
else
drCat[ 8 ] = "";
drCat[ 9 ] = Convert.ToString( oRdP[ 9 ] ); // StationID
cls_Color.Color_Tender( CompNo, oRdP[ 10 ].ToString() ); // TenderColor
drCat[ 10 ] = cls_Color.Back;
dtSub.Rows.Add( drCat );
}
}
oRdP.Close();
}
}
oRd.Close();
// InvoiceNoOfRec.Text = iTotal.ToString();
// InvoiceSelectedNo.Text = "0";
}
catch( SqlException ex )
{
MessageBox.Show( "Database error has occurred: " + ex.ToString() );
//System.Diagnostics.Debug.WriteLine( ex.ToString() );
}
objDs.Tables.Add( dtMain );
objDs.Tables.Add( dtSub );
objDs.Relations.Add( "GL_SalesInv", objDs.Tables[ 0 ].Columns[ 2 ], objDs.Tables[ 1 ].Columns[ 1 ], false );
return objDs;
}
#endregion GL invoices