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(); }