/// <summary>
/// FetchData Event
/// This event is raised every time a new record is processed. The FetchData has an EOF parameter
/// indicating whether the FetchData event should be raised. When working with bound
/// reports (reports using a DataControl), the EOF parameter is automatically set by the report;
/// however, when working with unbound reports this parameter needs to be controlled manually.
/// </summary>
private void EmployeeProfiles_FetchData(object sender, FetchEventArgs eArgs)
{
// The unbound custom field "Name" was created in DataInitialize.
// We use FetchData to set its value, to "TitleOfCourtest LastName, FirstName"
// TitleOfCourtesy, LastName and FirstName were added by ActiveReports from the data source.
Fields["Name"].Value = String.Format(System.Globalization.CultureInfo.CurrentCulture, "{0} {1}, {2}", this.Fields["TitleOfCourtesy"].Value, this.Fields["LastName"].Value, this.Fields["FirstName"].Value);
}
/// <summary>
/// HeadlineFetchingイベントの実行
/// </summary>
/// <param name="e">イベント</param>
private void OnHeadlineFetching(FetchEventArgs e)
{
if (HeadlineFetching != null)
{
HeadlineFetching(this, e);
}
}
// ------------
private void repOutputCompleteList_FetchData(object sender, FetchEventArgs eArgs)
{
_nOutputID = Convert.ToInt32(Fields["OutputID"].Value);
_bIsFrame = Convert.ToBoolean(Fields["IsFrame"].Value);
if (!Convert.IsDBNull(Fields["OutputDateConfirm"].Value))
{
_dOutputDateConfirm = Convert.ToDateTime(Fields["OutputDateConfirm"].Value);
}
else
{
_dOutputDateConfirm = null;
}
_nOutputSelectedInfo = Convert.ToInt32(Fields["OutputSelectedInfo"].Value);
_nOutputTrafficsInfo = Convert.ToInt32(Fields["OutputTrafficsInfo"].Value);
if (!Convert.IsDBNull(Fields["DateValid"].Value))
{
_dDateValid = Convert.ToDateTime(Fields["DateValid"].Value);
}
else
{
_dDateValid = null;
}
_nQnt = Convert.ToDecimal(Fields["Qnt"].Value);
_sChargeOrder = Fields["ChargeOrder"].Value.ToString();
}
/// <summary>
/// FetchData Event
/// This event is raised every time a new record is processed. The FetchData has an EOF parameter
/// indicating whether the FetchData event should be raised. When working with bound
/// reports (reports using a DataControl), the EOF parameter is automatically set by the report;
/// however, when working with unbound reports this parameter needs to be controlled manually.
/// </summary>
private void Invoice_FetchData(object sender, FetchEventArgs eArgs)
{
if (_RowCounter > _InvoiceDataArray.GetUpperBound(0))
{
eArgs.EOF = true;
return;
}
string[] _CurrentArray = _InvoiceDataArray[_RowCounter];
//Populate the fields used in data binding.
for (int i = 0; i < _CurrentArray.Length; i++)
{
double dblVal;
Fields[_FieldNameArray[i]].Value =
(Double.TryParse(_CurrentArray[i], NumberStyles.Float,
CultureInfo.InvariantCulture, out dblVal))
? dblVal.ToString(CultureInfo.CurrentCulture)
: _CurrentArray[i];
}
//Add unbound DiscountTotal field total to instance of the Fields collection (for data binding and summary totaling in the group footer.)
Fields["DiscountTotal"].Value =
Convert.ToDouble(Fields["UnitPrice"].Value, CultureInfo.CurrentCulture) *
Convert.ToInt32(Fields["Quantity"].Value, CultureInfo.InvariantCulture) *
Convert.ToDouble(Fields["Discount"].Value, CultureInfo.CurrentCulture);
/*It is important to set EOF to False if there are more records
* otherwise the default True value will be used and the report*/
_RowCounter++;
eArgs.EOF = false;
}
private void billInnerMoving_FetchData(object sender, FetchEventArgs eArgs)
{
_nOutputDocumentID = (int)Fields["OutputDocumentID"].Value;
_cBillNumber = Fields["BillNumber"].Value.ToString();
_nCnt = (int)Fields["Cnt"].Value;
_nOutputDocumentQnt = (decimal)Fields["OutputDocumentQnt"].Value;
_nOutputDocumentBox = (decimal)Fields["OutputDocumentBox"].Value;
_nOutputDocumentBrutto = (decimal)Fields["OutputDocumentBrutto"].Value;
_nOutputDocumentNetto = (decimal)Fields["OutputDocumentNetto"].Value;
_nAmount = (decimal)Fields["Amount"].Value;
_nCurrencyID = (int)Fields["CurrencyID"].Value;
_sCurrencyAlias = Fields["CurrencyAlias"].Value.ToString();
if ((bool)Fields["Weighting"].Value ||
(decimal)Fields["InBox"].Value != (int)(decimal)Fields["InBox"].Value)
{
txtDetailInBox.OutputFormat = "######0.000"; // InBox
txtDetailQnt.OutputFormat = "######0.000"; // Qnt
}
else
{
txtDetailInBox.OutputFormat = "######0"; // InBox
txtDetailQnt.OutputFormat = "######0"; // Qnt
}
if ((bool)Fields["Weighting"].Value)
{
txtDetailBox.Font = new Font(fntDefaultDetail, FontStyle.Italic);
}
else
{
txtDetailBox.Font = fntDefaultDetail;
}
}
//int x = 0;
//decimal sum = 0;
private void rptStockBalance_FetchData(object sender, FetchEventArgs eArgs)
{
//rptStockBalance rpt = new rptStockBalance();
//string controlValue = ((Label)rpt.Sections["detail"].Controls["lblNumberOfBags"]).Text;
//if (!string.IsNullOrEmpty(controlValue))
// sum = sum + decimal.Parse(controlValue);
}
// fetch data for each field from employee list
private void SectionReport1_FetchData(object sender, FetchEventArgs eArgs)
{
if (index < _Employees.Count)
{
var employee = _Employees[index++];
foreach (var property in _Properties)
{
Fields[property.Name].Value = property.GetValue(employee, null);
}
#region non property field helpers
#endregion
// non-property fields
txtBasePay.Text = employee.GetBasePay().ToString("#,##0.00");
if (employee is Manager)
{
var manager = employee as Manager;
txtBonusPay.Text = manager.GetBonusPay().ToString("#,##0.00");
txtCommPay.Text = manager.GetCommPay().ToString("#,##0.00");
}
else if (employee is SalesRep)
{
var salesRep = employee as SalesRep;
txtBonusPay.Text = "";
txtCommPay.Text = salesRep.GetCommPay().ToString("#,##0.00");
}
else
{
txtBonusPay.Text = "";
txtCommPay.Text = "";
}
eArgs.EOF = false;
}
}
/// <summary>
/// FetchData Event
/// This event is raised every time a new record is processed. The FetchData has an EOF parameter
/// indicating whether the FetchData event should be raised. When working with bound
/// reports (reports using a DataControl), the EOF parameter is automatically set by the report;
/// however, when working with unbound reports this parameter needs to be controlled manually.
/// </summary>
private void Invoice_FetchData(object sender, FetchEventArgs eArgs)
{
if (_RowCounter == _InvoiceData.Tables[0].Rows.Count)
{
//If the reader has reached the end of the data then
//set the eArgs.EOF flag to true and exit the procedure.
eArgs.EOF = true;
return;
}
else
{
//Populate the fields collection from the DataReader.
for (int i = 0; i < _InvoiceData.Tables[0].Columns.Count; i++)
{
Fields[_InvoiceData.Tables[0].Columns[i].ColumnName].Value = _InvoiceData.Tables[0].Rows[_RowCounter][i];
}
//Add unbound DiscountTotal field total to instance of the Fields collection (for data binding and summary totaling in the group footer.)
Fields["DiscountTotal"].Value =
Convert.ToDouble(Fields["UnitPrice"].Value, CultureInfo.CurrentCulture) *
Convert.ToInt32(Fields["Quantity"].Value, CultureInfo.InvariantCulture) *
Convert.ToDouble(Fields["Discount"].Value, CultureInfo.CurrentCulture);
//Set row counter.
eArgs.EOF = false;
_RowCounter++;
}
}
private void billPortrait_FetchData(object sender, FetchEventArgs eArgs)
{
_nOutputDocumentID = (int)Fields["OutputDocumentID"].Value;
_cBillNumber = Fields["BillNumber"].Value.ToString();
_nCnt = (int)Fields["Cnt"].Value;
_nOutputDocumentQnt = (decimal)Fields["OutputDocumentQnt"].Value;
_nOutputDocumentBox = (decimal)Fields["OutputDocumentBox"].Value;
_nOutputDocumentBrutto = (decimal)Fields["OutputDocumentBrutto"].Value;
_nOutputDocumentNetto = (decimal)Fields["OutputDocumentNetto"].Value;
_nAmount = (decimal)Fields["Amount"].Value;
_nCurrencyID = (int)Fields["CurrencyID"].Value;
_sCurrencyAlias = Fields["CurrencyAlias"].Value.ToString();
if ((bool)Fields["Weighting"].Value ||
Convert.ToDecimal(Fields["InBox"].Value) != Convert.ToInt32(Fields["InBox"].Value))
{
txtDetail04.Font = new Font(fntDefaultDetail.Name, fntDefaultDetail.Size - 2, FontStyle.Regular);
txtDetail04.OutputFormat = "# ### ##0.000"; // InBox
//txtDetail05.OutputFormat = "# ### ###"; // Box
txtDetail06.OutputFormat = "# ### ##0.000"; // Qnt
}
else
{
txtDetail04.Font = fntDefaultDetail;
txtDetail04.OutputFormat = "# ### ##0"; // InBox
//txtDetail05.OutputFormat = "# ### ##0.0"; // Box
txtDetail06.OutputFormat = "# ### ##0"; // Qnt
}
}
private void billPerversion_FetchData(object sender, FetchEventArgs eArgs)
{
_nOutputDocumentID = (int)Fields["OutputDocumentID"].Value;
_sBillNumber = Fields["BillNumber"].Value.ToString();
_nCnt = (int)Fields["Cnt"].Value;
_nOutputDocumentQnt = (decimal)Fields["OutputDocumentQnt"].Value;
_nOutputDocumentBox = (decimal)Fields["OutputDocumentBox"].Value;
_nOutputDocumentBrutto = (decimal)Fields["OutputDocumentBrutto"].Value;
_nOutputDocumentNetto = (decimal)Fields["OutputDocumentNetto"].Value;
_nAmount = (decimal)Fields["Amount"].Value;
_nCurrencyID = (int)Fields["CurrencyID"].Value;
_sCurrencyAlias = Fields["CurrencyAlias"].Value.ToString();
_nVatAllSum = (decimal)Fields["VatAllSum"].Value;
_nNoVatAllSum = (decimal)Fields["NoVatAllSum"].Value;
_nVat1Rate = (decimal)Fields["Vat1Rate"].Value;
_nVat1Sum = (decimal)Fields["Vat1Sum"].Value;
_nNoVat1Sum = (decimal)Fields["NoVat1Sum"].Value;
_nVat2Rate = (decimal)Fields["Vat2Rate"].Value;
_nVat2Sum = (decimal)Fields["Vat2Sum"].Value;
_nNoVat2Sum = (decimal)Fields["NoVat2Sum"].Value;
if ((bool)Fields["Weighting"].Value ||
(decimal)Fields["InBox"].Value != (int)(decimal)Fields["InBox"].Value)
{
txtDetailInBox.OutputFormat = "######0.000"; // InBox
txtDetailQnt.OutputFormat = "######0.000"; // Qnt
}
else
{
txtDetailInBox.OutputFormat = "######0"; // InBox
txtDetailQnt.OutputFormat = "######0"; // Qnt
}
}
protected void BaseReport_FetchData(object sender, FetchEventArgs eArgs)
{
try
{
if (_invoiceFileStream.Peek() >= 0)
{
//Read a line from the stream, and creats an array string.
string _currentLine = _invoiceFileStream.ReadLine();
string[] _currentArray = _currentLine.Split(new char[] { ',' });
//Store the Value property of Field object number of the array.
for (int i = 0; i < _currentArray.Length; i++)
{
Fields[_fieldNameArray[i]].Value = _currentArray[i];
}
//Set EOF to false and continue to read the data.
eArgs.EOF = false;
}
else
{
_invoiceFileStream.Close();
eArgs.EOF = true;
}
}
catch
{
//Close the stream when the it has exceeded the time to read the last line.
_invoiceFileStream.Close();
//Set EOF to true and quit reading the data.
eArgs.EOF = true;
}
}
private void TripReturnBill_FetchData(object sender, FetchEventArgs eArgs)
{
nTripReturnID = (int)Fields["TripReturnID"].Value;
bWeighting = (bool)Fields["Weighting"].Value;
if (bWeighting)
{
txtInBox.OutputFormat = "#####0.000";
txtQntRestWished.OutputFormat = "#####0.000";
txtGoodAlias.Font =
txtArticul.Font =
txtInBox.Font =
txtQntRestWished.Font =
new Font(fntDefaultDetail, FontStyle.Italic);
}
else
{
txtInBox.OutputFormat = "######";
txtQntRestWished.OutputFormat = "######";
txtGoodAlias.Font =
txtArticul.Font =
txtInBox.Font =
txtQntRestWished.Font =
fntDefaultDetail;
}
}
private void ObjectFetched(object sender, FetchEventArgs e)
{
this.Invoke(new MethodInvoker(delegate
{
lblStatus.Text = "Fetching objects: " + e.DBObject.Name;
}));
}
private void facture_FetchData(object sender, FetchEventArgs eArgs)
{
_nOutputDocumentID = (int)Fields["OutputDocumentID"].Value;
_sFactureNumber = Fields["FactureNumber"].Value.ToString();
_bFactoring = (bool)Fields["Factoring"].Value;
sDateBring = Fields["DateBring"].Value.ToString();
// ¬Ќ»ћјЌ»≈, ¬–≈ћ≈ЌЌјя «ј√Ћ”Ў ј!
// »змен¤ем признак факторинга в зависимости от хоста
// ќставл¤ем этот признак только дл¤ »нко-∆уковский
sHostShortCode = Fields["HostShortCode"].Value.ToString();
if (sHostShortCode.Length < 2 || !sHostShortCode.StartsWith("02"))
{
_bFactoring = false;
}
sPayeeINN = Fields["PayeeINN"].Value.ToString();
sPayerINN = Fields["PayerINN"].Value.ToString();
nSum = (decimal)Fields["Amount"].Value;
dDate = (DateTime)Fields["DateOutput"].Value;
sIsoCode = Fields["CurrencyISODigitalCode"].Value.ToString();
if ((bool)Fields["Weighting"].Value ||
Convert.ToDecimal(Fields["InBox"].Value) != Convert.ToInt32(Fields["InBox"].Value))
{
txtDetailQnt.OutputFormat = "# ### ##0.000"; // Qnt
}
else
{
txtDetailQnt.OutputFormat = "# ### ##0"; // Qnt
}
}
private void TripOutputsBalance_FetchData(object sender, FetchEventArgs eArgs)
{
bWeighting = (bool)Fields["Weighting"].Value ||
Convert.ToInt32(Fields["InBox"].Value) != Convert.ToDecimal(Fields["InBox"].Value);
if (bWeighting)
{
txtInBox.OutputFormat =
txtQntConfirmed.OutputFormat =
txtQntActed.OutputFormat =
txtQntBrought.OutputFormat =
txtQntReturned.OutputFormat =
txtQntDiff.OutputFormat =
"### ### ##0.000";
}
else
{
txtInBox.OutputFormat =
txtQntConfirmed.OutputFormat =
txtQntActed.OutputFormat =
txtQntBrought.OutputFormat =
txtQntReturned.OutputFormat =
txtQntDiff.OutputFormat =
"### ### ###";
}
}
/// <summary>
/// HeadlineFetchedイベントの実行
/// </summary>
/// <param name="e">イベント</param>
private void OnHeadlineFetched(FetchEventArgs e)
{
if (HeadlineFetched != null)
{
HeadlineFetched(this, e);
}
}
// save current record's CLient ID
private void rptProducedItem_FetchData(object sender, FetchEventArgs eArgs)
{
if (Fields["TypeID"].Value != null)
{
_EOID = Fields["TypeID"].Value.ToString();
_EOName = Fields["TypeName"].Value.ToString();
}
}
private void TransportAct_FetchData(object sender, FetchEventArgs eArgs)
{
_nCurrencyID = (int)Fields["DeliveryCurrencyID"].Value;
_sCurrencyAlias = Fields["DeliveryCurrencyAlias"].Value.ToString();
_nDeliveryPrice = (decimal)Fields["DeliveryPrice"].Value;
_nDeliveryVatSum = (decimal)Fields["DeliveryVatSum"].Value;
}
//<summary>
// FetchData Event
// This event is raised every time a new record is processed. The FetchData has an EOF parameter
// indicating whether the FetchData event should be raised. When working with bound reports (reports using a DataControl),
// the EOF parameter is automatically set by the report; however, when working with unbound reports
// this parameter needs to be controlled manually.
// </summary>
private void OrdersReport_FetchData(object sender, FetchEventArgs eArgs)
{
// Gather the value to be calculated from the bound data base.
double quantity = Convert.ToDouble(Fields["Quantity"].Value, CultureInfo.CurrentCulture);
double unitPrice = Convert.ToDouble(Fields["UnitPrice"].Value, CultureInfo.CurrentCulture);
double discount = Convert.ToDouble(Fields["Discount"].Value, CultureInfo.CurrentCulture);
// Perform the calculation for the calculated field.
Fields["ExtendedPrice"].Value = ((quantity * unitPrice) - (quantity * unitPrice * discount));
}
private void ObjectFetched(object sender, FetchEventArgs e)
{
Console.WriteLine(e.DBObject.Name);
this.Invoke(new MethodInvoker(delegate
{
ListViewItem lvi = lwProgress.Items[lwProgress.Items.Count - 1];
lvi.SubItems[0].Text = "Fetching objects: " + e.DBObject.Name;
}));
}
private void rpt_FetchData(object sender, FetchEventArgs e)
{
var changed = !ParentCustomerCodeBuffer.Equals(Fields[nameof(CustomerGroup.ParentCustomerCode)].Value);
txtParentCustomerCode.Visible = changed;
txtParentCustomerName.Visible = changed;
txtParentCustomerKana.Visible = changed;
ParentCustomerCodeBuffer = Fields[nameof(CustomerGroup.ParentCustomerCode)].Value.ToString();
}
private void XlsFormulaReport_FetchData(object sender, FetchEventArgs eArgs)
{
string image_path = "";
if (i_ReportLigne == 0)
{
this.Fields["FieldDate"].Value = DateTime.Now.ToString();
dt = F_accueil.Export_DataTable;
//image_path = dt.Rows[i]["Image_path"].ToString();
eArgs.EOF = false;
Page_H = 0; //pourquoi ?
//i++;
}
if (i_ReportLigne == dt.Rows.Count)
{
eArgs.EOF = true;
i_ReportLigne = 0;
return;
}
else
{
if (dt.Rows[i_ReportLigne].RowState != DataRowState.Deleted)
{
deleted_row = false;
if (detail.BackColor == Color.Transparent)
{
detail.BackColor = Color.Silver;
}
else
{
detail.BackColor = Color.Transparent;
}
image_path = dt.Rows[i_ReportLigne]["Image_path"].ToString();
Image img = System.Drawing.Bitmap.FromFile(image_path);
this.picture1.Image = img;
this.Fields["refArticle"].Value = dt.Rows[i_ReportLigne]["REFARTICLE"].ToString();
this.Fields["designation"].Value = dt.Rows[i_ReportLigne]["designation"].ToString();
this.Fields["taille"].Value = dt.Rows[i_ReportLigne]["taille"].ToString();
this.Fields["poid"].Value = dt.Rows[i_ReportLigne]["pdsmetal"].ToString();
this.Fields["prix"].Value = dt.Rows[i_ReportLigne]["prix"].ToString();
//this.Fields["prix"].Value = dt.Rows[i_ReportLigne]["PrixClient"].ToString();
this.Fields["stock"].Value = dt.Rows[i_ReportLigne]["dispo"].ToString();
this.Fields["Comments"].Value = dt.Rows[i_ReportLigne]["Commentaires"].ToString();
this.Fields["PrixClient"].Value = dt.Rows[i_ReportLigne]["Formule_PrixClient"].ToString();
}
else
{
deleted_row = true;
}
eArgs.EOF = false;
}
i_ReportLigne++;
//return;
}
private void billLandscape_FetchData(object sender, FetchEventArgs eArgs)
{
_nOutputDocumentID = (int)Fields["OutputDocumentID"].Value;
_cBillNumber = Fields["BillNumber"].Value.ToString();
sDateBring = Fields["DateBring"].Value.ToString();
_nCnt = (int)Fields["Cnt"].Value;
_nOutputDocumentQnt = (decimal)Fields["OutputDocumentQnt"].Value;
_nOutputDocumentBox = (decimal)Fields["OutputDocumentBox"].Value;
_nOutputDocumentBrutto = (decimal)Fields["OutputDocumentBrutto"].Value;
_nOutputDocumentNetto = (decimal)Fields["OutputDocumentNetto"].Value;
//_nAmount = (decimal)Fields["Amount"].Value;
_nAmount = (decimal)Fields["PriceAllSum"].Value;
_nCurrencyID = (int)Fields["CurrencyID"].Value;
_sCurrencyAlias = Fields["CurrencyAlias"].Value.ToString();
// є и дата договора
if (Fields["ContractNumber"].Value != null && Fields["ContractNumber"].Value.ToString().Length > 0)
{
_sContractNumberDate += "дог. є " + Fields["ContractNumber"].Value.ToString();
}
if (_sContractNumberDate.Length > 0 && Fields["ContractDate"].Value != null && Fields["ContractDate"].Value != DBNull.Value)
{
_sContractNumberDate += " от " + Convert.ToDateTime(Fields["ContractDate"].Value).ToString("dd.MM.yyyy");
}
txtContractNumberDate.Text = _sContractNumberDate;
if ((bool)Fields["Weighting"].Value ||
(decimal)Fields["InBox"].Value != (int)(decimal)Fields["InBox"].Value)
{
//txtDetailInBox.Font = new Font(fntDefaultDetail.Name, fntDefaultDetail.Size - 2, FontStyle.Regular);
txtDetailInBox.OutputFormat = "######0.000"; // InBox
//txtDetailBox.OutputFormat = "#######"; // Box
txtDetailQnt.OutputFormat = "######0.000"; // Qnt
}
else
{
//txtDetailInBox.Font = fntDefaultDetail;
txtDetailInBox.OutputFormat = "######0"; // InBox
//txtDetailBox.OutputFormat = "######0.0"; // Box
txtDetailQnt.OutputFormat = "######0"; // Qnt
}
if ((bool)Fields["Weighting"].Value)
{
txtDetailBox.Font = new Font(fntDefaultDetail, FontStyle.Italic);
}
else
{
txtDetailBox.Font = fntDefaultDetail;
}
}
void StationList_HeadlineFetching(object sender, FetchEventArgs e)
{
if (e.IsUnknownContentSize == false)
{
mainStatusBar.Text = string.Format("ヘッドライン取得 \"{0}\" {1}KB / {2}KB", StationList.FetchingStationName, e.FetchedSize / 1024, e.ContentSize / 1024);
}
else
{
mainStatusBar.Text = string.Format("ヘッドライン取得 \"{0}\" {1}KB", StationList.FetchingStationName, e.FetchedSize / 1024);
}
mainStatusBar.Refresh();
}
private void rptConfigSubTypes_FetchData(object sender, FetchEventArgs eArgs)
{
_output = "";
if (_ReportType == "Food")
{
if (Fields["VolumeUnitType"].Value != null && Fields["VolumeUnitType"].Value.ToString() != "" && Fields["VolumeUnitType"].Value.ToString() != "0")
{
DataTable dt = VWA4Common.DB.Retrieve("SELECT DisplayFullName FROM UnitsVolume WHERE ID = " +
Fields["VolumeUnitType"].Value.ToString());
string res = "";
if (dt != null && dt.Rows.Count > 0)
{
res = dt.Rows[0][0].ToString();
}
_output = decimal.Parse(Fields["VolumeWeight"].Value.ToString()).ToString("0.00") + "lbs / " +
decimal.Parse(Fields["VolumeUnits"].Value.ToString()).ToString("0") + res;
}
}
else if (_ReportType == "Loss")
{
_output = ((bool)Fields["OverproductionFlag"].Value ? "Overproduction" : "");
if (_output == "")
{
_output = ((bool)Fields["TrimWasteFlag"].Value ? "TrimWaste" : "");
}
else
{
_output += ((bool)Fields["TrimWasteFlag"].Value ? ", TrimWaste" : "");
}
if (_output == "")
{
_output = ((bool)Fields["HandlingFlag"].Value ? "Handling" : "");
}
else
{
_output += ((bool)Fields["HandlingFlag"].Value ? ", Handling" : "");
}
}
else if (_ReportType == "Container")
{
if (Fields["VolumeUnitType"].Value != null && Fields["VolumeUnitType"].Value.ToString() != "" && Fields["VolumeUnitType"].Value.ToString() != "0")
{
string displayName = "";
DataTable dt = VWA4Common.DB.Retrieve("SELECT DisplayFullName FROM UnitsVolume WHERE ID = " +
Fields["VolumeUnitType"].Value.ToString());
if (dt != null && dt.Rows.Count > 0)
{
displayName = dt.Rows[0][0].ToString();
}
_output = decimal.Parse(Fields["Volume"].Value.ToString()).ToString("0.00") + " " + displayName;
}
}
}
// ------------
private void repOutputControlList_FetchData(object sender, FetchEventArgs eArgs)
{
_nOutputID = Convert.ToInt32(Fields["OutputID"].Value);
_bIsFrame = Convert.ToBoolean(Fields["IsFrame"].Value);
if (!Convert.IsDBNull(Fields["OutputDateConfirm"].Value))
{
_dOutputDateConfirm = Convert.ToDateTime(Fields["OutputDateConfirm"].Value);
}
else
{
_dOutputDateConfirm = null;
}
}
private void billMX3_FetchData(object sender, FetchEventArgs eArgs)
{
if (Fields["Measure"].Value.ToString().ToLower().Contains("êã"))
{
txtQnt.Font = new Font(fntDefaultDetail.Name, fntDefaultDetail.Size - 1, FontStyle.Regular);
txtQnt.OutputFormat = "######0.000";
}
else
{
txtQnt.Font = fntDefaultDetail;
txtQnt.OutputFormat = "######0";
}
txtNettoSum.OutputFormat = "######0.0";
}
private void OnFetch(object sender, FetchEventArgs e)
{
OFXRequest request = e.Request;
OFXResponse response = e.Response;
rtbRaw.Text = response.Raw;
if (response.Success)
{
//Graphical stuff
}
tcMain.SelectedTab = tabpageRaw;
}
private void billPerversion_FetchData(object sender, FetchEventArgs eArgs)
{
_nOutputDocumentID = (int)Fields["OutputDocumentID"].Value;
_sBillNumber = Fields["BillNumber"].Value.ToString();
_nCnt = (int)Fields["Cnt"].Value;
_nOutputDocumentQnt = (decimal)Fields["OutputDocumentQnt"].Value;
_nOutputDocumentBox = (decimal)Fields["OutputDocumentBox"].Value;
_nOutputDocumentBrutto = (decimal)Fields["OutputDocumentBrutto"].Value;
_nOutputDocumentNetto = (decimal)Fields["OutputDocumentNetto"].Value;
_nAmount = (decimal)Fields["Amount"].Value;
_nCurrencyID = (int)Fields["CurrencyID"].Value;
_sCurrencyAlias = Fields["CurrencyAlias"].Value.ToString();
_nVatAllSum = (decimal)Fields["VatAllSum"].Value;
_nNoVatAllSum = (decimal)Fields["NoVatAllSum"].Value;
_nVat1Rate = (decimal)Fields["Vat1Rate"].Value;
_nVat1Sum = (decimal)Fields["Vat1Sum"].Value;
_nNoVat1Sum = (decimal)Fields["NoVat1Sum"].Value;
_nVat2Rate = (decimal)Fields["Vat2Rate"].Value;
_nVat2Sum = (decimal)Fields["Vat2Sum"].Value;
_nNoVat2Sum = (decimal)Fields["NoVat2Sum"].Value;
if ((bool)Fields["Weighting"].Value ||
(decimal)Fields["InBox"].Value != (int)(decimal)Fields["InBox"].Value)
{
//txtDetailInBox.Font = new Font(fntDefaultDetail.Name, fntDefaultDetail.Size - 2, FontStyle.Regular);
txtDetailInBox.OutputFormat = "######0.000"; // InBox
//txtDetailBox.OutputFormat = "#######"; // Box
txtDetailQnt.OutputFormat = "######0.000"; // Qnt
}
else
{
//txtDetailInBox.Font = fntDefaultDetail;
txtDetailInBox.OutputFormat = "######0"; // InBox
//txtDetailBox.OutputFormat = "######0.0"; // Box
txtDetailQnt.OutputFormat = "######0"; // Qnt
}
/*
* if ((bool)Fields["Weighting"].Value)
* {
* txtDetailBox.Font = new Font(fntDefaultDetail, FontStyle.Italic);
* }
* else
* {
* txtDetailBox.Font = fntDefaultDetail;
* }
*/
}
private void billM15_FetchData(object sender, FetchEventArgs eArgs)
{
if ((bool)Fields["Weighting"].Value)
{
txtQnt.Font = new Font(fntDefaultDetail.Name, fntDefaultDetail.Size - 1, FontStyle.Regular);
txtQnt.OutputFormat = "######0.000";
}
else
{
txtQnt.Font = fntDefaultDetail;
txtQnt.OutputFormat = "######0";
}
txtNettoSum.OutputFormat = "######0.0";
}
