private void InvoiceForm_Load(object sender, EventArgs e) { this.tbReceiver.Text = ""; this.dtpInvoice.Value = System.DateTime.Now; this.dtpInvoiceDue.Value = After10Days; this.Text = "Invoice "; invoiceDetails(); if (invoiceNumber != null && invoiceNumber.Length > 0) { String fields = "service, quantity, unit, a_price, total, vat"; adapter = new OleDbDataAdapter("Select " + fields + ", hasTax, invoice_date, due_date, receiver, summary, company_info, address, bank_details from InvoiceLog where invoice_number = @invoice_number", conn); adapter.SelectCommand.Parameters.Add("@invoice_number", OleDbType.VarWChar).Value = invoiceNumber; adapter.Fill(dataSet, "Invoice_View"); DataTable invoiceLog = dataSet.Tables["Invoice_View"]; if (invoiceLog.Rows.Count > 0) { Object[] itemArray = invoiceLog.Rows[0].ItemArray; DataColumnCollection columns1 = invoiceLog.Columns; cbTax.Checked = Boolean.Parse(itemArray[columns1.IndexOf("hasTax")].ToString()); tbReceiver.Text = itemArray[columns1.IndexOf("receiver")].ToString(); tbSummary.Text = itemArray[columns1.IndexOf("summary")].ToString(); tbCompanyInfo.Text = itemArray[columns1.IndexOf("company_info")].ToString(); tbAddress.Text = itemArray[columns1.IndexOf("address")].ToString(); tbBankDetails.Text = itemArray[columns1.IndexOf("bank_details")].ToString(); try { dtpInvoice.Value = DateTime.Parse(itemArray[columns1.IndexOf("invoice_date")].ToString()); } catch { } try { dtpInvoiceDue.Value = DateTime.Parse(itemArray[columns1.IndexOf("due_date")].ToString()); } catch { } MainWindow.DataGridView_Serialize(dataGridView, invoiceLog, fields); } else { loadDefault(); invoiceNumberChanged = true; } } else if (ccsNumber != null) { loadDefault(); } conn.Close(); MainWindow.DataGridView_LockColumn(dataGridView, "vat"); MainWindow.DataGridView_LockColumn(dataGridView, "total"); cbTax_CheckedChanged(cbTax, new EventArgs()); autoSuggestControl = new AutoSuggestControl(conn, "InvoiceData", new TextBox[] { tbReceiver, tbAddress, tbBankDetails, tbCompanyInfo }); kryptonPanel1.Controls.Add(autoSuggestControl); autoSuggestControl.BringToFront(); fileAttacher.displayAttached(item[IndexOf("attached")].ToString().Split(',')); }
private void CMRForm_Load(object sender, EventArgs e) { if (!isNew) { adapter = new OleDbDataAdapter("select * from CMRHistory where reference_number like @referenceNumber", conn); adapter.SelectCommand.Parameters.Add("@referenceNumber", OleDbType.VarWChar).Value = tbReference.Text; adapter.Fill(dataSet, "CMRHistory"); conn.Close(); tbConsignor.Text = Row_ValueByColumnName(CMRHistory_string.consignor); tbConsignee.Text = Row_ValueByColumnName(CMRHistory_string.consignee); dtpDate.Value = DateTime.Parse(Row_ValueByColumnName(CMRHistory_date.date)); tbTradeAccessRef.Text = Row_ValueByColumnName(CMRHistory_string.trade_access); tbCarrier.Text = Row_ValueByColumnName(CMRHistory_string.carrier); tbNotifyDeliveryAddr.Text = Row_ValueByColumnName(CMRHistory_string.notify_address); tbTrailerNum.Text = Row_ValueByColumnName(CMRHistory_string.trailer_number); tbPlaceOfLoading.Text = Row_ValueByColumnName(CMRHistory_string.place_loading); tbPlaceOfDischarge.Text = Row_ValueByColumnName(CMRHistory_string.place_discharge); tbBorderCrossing.Text = Row_ValueByColumnName(CMRHistory_string.border_crossing); tbTerms.Text = Row_ValueByColumnName(CMRHistory_string.terms_delivery); tbFinalDestination.Text = Row_ValueByColumnName(CMRHistory_string.final_destination); tbSpecialInstruction.Text = Row_ValueByColumnName(CMRHistory_string.special_instruction); dtpDate2.Value = DateTime.Parse(Row_ValueByColumnName(CMRHistory_date.date_signed)); tbIssuedAt.Text = Row_ValueByColumnName(CMRHistory_string.issued_at); tbSenderSignature.Text = Row_ValueByColumnName(CMRHistory_string.sender_signature); tbCarrierInstruction.Text = Row_ValueByColumnName(CMRHistory_string.carrier_instruction); MainWindow.DataGridView_Serialize(dataGridView, Table, "packages_kind,gross_weight"); } this.autoSuggestControl = new AutoSuggestControl(conn, "CMRData", new TextBox[] { tbConsignor, tbConsignee, tbCarrier, tbNotifyDeliveryAddr, tbTrailerNum, tbPlaceOfLoading, tbPlaceOfDischarge, tbBorderCrossing, tbTerms, tbFinalDestination, tbIssuedAt, tbSenderSignature }); this.kryptonPanel.Controls.Add(autoSuggestControl); autoSuggestControl.BringToFront(); }