private void writeDataToBankCashsubLedger() { BankCashsubLedgerTable record = new BankCashsubLedgerTable(); record.tradingDate = this.dateTime.Value.ToString("yyyyMMdd"); record.bankID = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName("BASE_BANK_LIST", this.comboBoxBank.Text); record.tradingDate = this.dateTime.Value.ToString("yyyyMMdd"); record.billNumber = this.textBoxPaymentOrderNumber.Text; record.vouchersNumber = this.textBoxVouchersNumber.Text; record.billName = PAYMENT_ORDER_BILL_NAME; record.billTypeID = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName("BASE_PAYMENT_TYPE_LIST", comboBoxPaymentType.Text);; if (this.comboBoxPaymentType.Text.IndexOf("采购入库") != -1) { // 如果是采购入库,则需要采集原始单据号 record.sourceBillNumber = this.textBoxSourceOrderNumber.Text; } else if (this.comboBoxPaymentType.Text.IndexOf("应付") != -1) { // 如果是应付账款,则需要记录往来单位名称 record.exchangesUnit = getExchangesUnitID(); } else if (this.comboBoxPaymentType.Text.IndexOf("其他") != -1 || this.comboBoxPaymentType.Text.IndexOf("其它") != -1) { // 如果是其他付款,则需要记录其他付款条目到备注字段 record.note = this.textBoxSourceOrderNumber.Text; } record.turnover = Convert.ToDouble(this.textBoxTransactionAmount.Text); record.makeOrderStaff = DbPublic.getInctance().getCurrentLoginUserID(); BankCashsubLedger.getInctance().insert(record); }
private void initUserInterfaceValue() { if (m_isBankBill) { m_bankRecord = BankCashsubLedger.getInctance().getBankCashsubLedgerInfoFromOrderNumber(m_billNumber); // 如果单据已审核,则允许用户修改此单据 if (m_bankRecord.isReview == "1") { setAllActiveEnableAttribute(false); } this.textBoxPaymentOrderNumber.Text = m_bankRecord.billNumber; this.textBoxVouchersNumber.Text = m_bankRecord.vouchersNumber; this.dateTime.Text = m_bankRecord.tradingDate; this.comboBoxPaymentType.Text = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_PAYMENT_TYPE_LIST", m_bankRecord.billTypeID); comboBoxPaymentType_SelectedIndexChanged(this.comboBoxPaymentType, null); if (this.comboBoxPaymentType.Text.IndexOf("采购入库") != -1) { this.textBoxSourceOrderNumber.Text = m_bankRecord.sourceBillNumber; } else if (this.comboBoxPaymentType.Text.IndexOf("应付") != -1) { this.textBoxSourceOrderNumber.Text = m_bankRecord.exchangesUnitName; } else if (this.comboBoxPaymentType.Text.IndexOf("其他") != -1 || this.comboBoxPaymentType.Text.IndexOf("其它") != -1) { this.textBoxSourceOrderNumber.Text = m_bankRecord.note; } this.comboBoxPaymentObject.Text = "银行存款"; this.comboBoxBank.Text = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_BANK_LIST", m_bankRecord.bankID); comboBoxPaymentObject_SelectedIndexChanged(this.comboBoxPaymentObject, null); this.textBoxTransactionAmount.Text = Convert.ToString(m_bankRecord.turnover); this.textBoxMakeOrderStaff.Text = m_bankRecord.makeOrderStaffName; this.textBoxOrderReview.Text = m_bankRecord.orderReviewName; } else { m_cashRecord = CashCashsubLedger.getInctance().getCashCashsubLedgerInfoFromOrderNumber(m_billNumber); // 如果单据已审核,则允许用户修改此单据 if (m_cashRecord.isReview == "1") { setAllActiveEnableAttribute(false); } this.textBoxPaymentOrderNumber.Text = m_cashRecord.billNumber; this.textBoxVouchersNumber.Text = m_cashRecord.vouchersNumber; this.dateTime.Text = m_cashRecord.tradingDate; this.comboBoxPaymentType.Text = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_PAYMENT_TYPE_LIST", m_cashRecord.billTypeID); comboBoxPaymentType_SelectedIndexChanged(this.comboBoxPaymentType, null); if (this.comboBoxPaymentType.Text.IndexOf("采购入库") != -1) { this.textBoxSourceOrderNumber.Text = m_cashRecord.sourceBillNumber; } else if (this.comboBoxPaymentType.Text.IndexOf("应付") != -1) { this.textBoxSourceOrderNumber.Text = m_cashRecord.exchangesUnitName; } else if (this.comboBoxPaymentType.Text.IndexOf("其他") != -1 || this.comboBoxPaymentType.Text.IndexOf("其它") != -1) { this.textBoxSourceOrderNumber.Text = m_cashRecord.note; } this.comboBoxPaymentObject.Text = "库存现金"; this.textBoxTransactionAmount.Text = Convert.ToString(m_cashRecord.turnover); this.textBoxMakeOrderStaff.Text = m_cashRecord.makeOrderStaffName; this.textBoxOrderReview.Text = m_cashRecord.orderReviewName; } }
private void updateDataGridView(bool isALLTableData) { SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>(); if (m_isCashDetail) { SortedDictionary <int, CashCashsubLedgerTable> cashDetail = new SortedDictionary <int, CashCashsubLedgerTable>(); if (isALLTableData) { cashDetail = CashCashsubLedger.getInctance().getAllCashCashsubLedgerInfo(); } else { cashDetail = CashCashsubLedger.getInctance().getAllReviewCashCashsubLedgerInfo(); } m_dataGridRecordCount = cashDetail.Count; for (int index = 0; index < cashDetail.Count; index++) { CashCashsubLedgerTable record = new CashCashsubLedgerTable(); record = (CashCashsubLedgerTable)cashDetail[index]; ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.tradingDate); temp.Add(record.billName); temp.Add(record.billNumber); temp.Add(record.billTypeName); temp.Add(record.exchangesUnitName); temp.Add(record.turnover); temp.Add(record.balance); temp.Add(record.makeOrderStaffName); temp.Add(record.orderReviewName); sortedDictionaryList.Add(index, temp); } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } else { SortedDictionary <int, BankCashsubLedgerTable> bankDetail = new SortedDictionary <int, BankCashsubLedgerTable>(); if (isALLTableData) { bankDetail = BankCashsubLedger.getInctance().getAllBankCashsubLedgerInfo(); } else { bankDetail = BankCashsubLedger.getInctance().getAllReviewBankCashsubLedgerInfo(); } m_dataGridRecordCount = bankDetail.Count; for (int index = 0; index < bankDetail.Count; index++) { BankCashsubLedgerTable record = new BankCashsubLedgerTable(); record = (BankCashsubLedgerTable)bankDetail[index]; ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.tradingDate); temp.Add(record.billName); temp.Add(record.billNumber); temp.Add(record.billTypeName); temp.Add(record.exchangesUnitName); temp.Add(record.turnover); temp.Add(record.bankName); temp.Add(record.balance); temp.Add(record.makeOrderStaffName); temp.Add(record.orderReviewName); sortedDictionaryList.Add(index, temp); } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } }