private void rptInvoice_FetchData(object sender, DataDynamics.ActiveReports.ActiveReport.FetchEventArgs eArgs)
{
if (rsInvoiceDetail.EOF())
{
eArgs.EOF = true;
return;
}
Fields["PurOrderNo"].Value = rsInvoiceDetail["PurOrderNo"];
string purInfo = "";
if (rsInvoiceDetail["PurOrderNo"] != DBNull.Value)
{
purInfo = rsInvoiceDetail["PurOrderNo"].ToString() + "\r\t";
}
if (rsInvoiceDetail["PurOrderDate"] != DBNull.Value)
{
purInfo += System.Convert.ToDateTime(rsInvoiceDetail["PurOrderDate"]).ToString("dd-MM-yyyy");
}
Fields["PurInfo"].Value = purInfo;
Fields["PurOrderLineNo"].Value = rsInvoiceDetail["PurOrderLineNo"];
Fields["Quantity"].Value = rsInvoiceDetail["Quantity"];
Fields["Description"].Value = rsInvoiceDetail["Description"];
Fields["UOM"].Value = rsInvoiceDetail["UOM"];
Fields["VATAmt"].Value = rsInvoiceDetail["VATAmt"];
Fields["VATRate"].Value = rsInvoiceDetail["VATRate"];
Fields["New_NettValue"].Value = rsInvoiceDetail["New_NettValue"];
Fields["TotalAmt"].Value = rsInvoiceDetail["TotalAmt"];
Fields["Discount"].Value = rsInvoiceDetail["Discount"];
Fields["Rate"].Value = rsInvoiceDetail["Rate"];
Fields["PurOrderDate"].Value = rsInvoiceDetail["PurOrderDate"];
Fields["BuyersProdCode"].Value = rsInvoiceDetail["BuyersProdCode"];
Fields["SuppliersProdCode"].Value = rsInvoiceDetail["SuppliersProdCode"];
Fields["New_DespatchNoteNumber"].Value = rsInvoiceDetail["New_DespatchNoteNumber"];
Fields["New_DespatchDate"].Value = rsInvoiceDetail["New_DespatchDate"];
Fields["New_Type"].Value = rsInvoiceDetail["New_Type"];
Fields["New_Definable1"].Value = Convert.ToString(rsInvoiceDetail["New_Definable1"]);
Fields["New_DiscountPercent2"].Value = rsInvoiceDetail["New_DiscountPercent2"];
eArgs.EOF = false;
rsInvoiceDetail.MoveNext();
}
//=======================================================================
#region DebitNoteNL_FetchData
private void DebitNoteNL_FetchData(object sender, DataDynamics.ActiveReports.ActiveReport.FetchEventArgs eArgs)
{
int i = 0;
for (i = 0; i < ds2.Tables[1].Rows.Count; i++)
{
if (ds2.Tables[1].Rows[i]["PurOrderNo"] != DBNull.Value)
{
Fields["PurOrderNo"].Value = ds2.Tables[1].Rows[i]["PurOrderNo"];
}
if (ds2.Tables[1].Rows[i]["debitNoteLineNo"] != DBNull.Value)
{
Fields["PurOrderLineNo"].Value = ds2.Tables[1].Rows[i]["debitNoteLineNo"];
}
if (ds2.Tables[1].Rows[i]["Quantity"] != DBNull.Value)
{
Fields["Quantity"].Value = ds2.Tables[1].Rows[i]["Quantity"];
}
if (ds2.Tables[1].Rows[i]["DDescription"] != DBNull.Value)
{
Fields["Description"].Value = ds2.Tables[1].Rows[i]["DDescription"];
}
if (ds2.Tables[1].Rows[i]["NettValue"] != DBNull.Value)
{
Fields["New_NettValue"].Value = ds2.Tables[1].Rows[i]["NettValue"];
}
if (ds2.Tables[1].Rows[i]["New_Definable1"] != DBNull.Value)
{
Fields["Color"].Value = ds2.Tables[1].Rows[i]["New_Definable1"];
}
//if(ds2.Tables[1].Rows[i]["TotalAmt"] != DBNull.Value)
// Fields["TotalAmt"].Value = ds2.Tables[1].Rows[i]["TotalAmt"] ;
if (ds2.Tables[1].Rows[i]["Price"] != DBNull.Value)
{
Fields["Rate"].Value = ds2.Tables[1].Rows[i]["Price"];
}
if (ds2.Tables[1].Rows[i]["BuyersProdCode"] != DBNull.Value)
{
Fields["BuyersProdCode"].Value = ds2.Tables[1].Rows[i]["BuyersProdCode"];
}
}
}
private void NewlookDebitNote_FetchData(object sender, DataDynamics.ActiveReports.ActiveReport.FetchEventArgs eArgs)
{
if (rsInvoiceDetail.EOF())
{
eArgs.EOF = true;
return;
}
Fields["PurOrderNo"].Value = rsInvoiceDetail["PurOrderNo"];
Fields["PurOrderLineNo"].Value = rsInvoiceDetail["debitNoteLineNo"];
Fields["Quantity"].Value = rsInvoiceDetail["Quantity"];
Fields["Description"].Value = rsInvoiceDetail["DDescription"];
Fields["New_NettValue"].Value = rsInvoiceDetail["NettValue"];
Fields["Color"].Value = rsInvoiceDetail["New_Definable1"];
Fields["Rate"].Value = rsInvoiceDetail["Price"];
Fields["BuyersProdCode"].Value = rsInvoiceDetail["BuyersProdCode"];
eArgs.EOF = false;
rsInvoiceDetail.MoveNext();
}
