private void load() { string sql = "SELECT [PKEY],[TRADING_DATE],[BILL_NUMBER],[VOUCHERS_NUMBER],[BILL_NAME],[BILL_TYPE_ID],[SOURCE_BILL_NUMBER],[EXCHANGES_UNIT],"; sql += "[TURNOVER],[BALANCE],[MAKE_ORDER_STAFF],[ORDERR_EVIEW],[IS_REVIEW],[NOTE] FROM [dbo].[CASH_CASHSUB_LEDGER] ORDER BY TRADING_DATE"; m_cashCashsubLedgerList.Clear(); using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql)) { foreach (DataRow row in dataTable.Rows) { CashCashsubLedgerTable record = new CashCashsubLedgerTable(); record.pkey = DbDataConvert.ToInt32(row["PKEY"]); record.tradingDate = DbDataConvert.ToDateTime(row["TRADING_DATE"]).ToString("yyyy-MM-dd"); record.billNumber = DbDataConvert.ToString(row["BILL_NUMBER"]); record.vouchersNumber = DbDataConvert.ToString(row["VOUCHERS_NUMBER"]); record.billName = DbDataConvert.ToString(row["BILL_NAME"]); record.billTypeID = DbDataConvert.ToInt32(row["BILL_TYPE_ID"]); record.sourceBillNumber = DbDataConvert.ToString(row["SOURCE_BILL_NUMBER"]); record.exchangesUnit = DbDataConvert.ToInt32(row["EXCHANGES_UNIT"]); if (record.billName == "付款单") { record.billTypeName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_PAYMENT_TYPE_LIST", record.billTypeID); record.exchangesUnitName = Supplier.getInctance().getSupplierNameFromPkey(record.exchangesUnit); } else { record.billTypeName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_RECEIVABLE_TYPE_LIST", record.billTypeID); record.exchangesUnitName = Customer.getInctance().getCustomerNameFromPkey(record.exchangesUnit); } record.turnover = DbDataConvert.ToDouble(row["TURNOVER"]); record.makeOrderStaff = DbDataConvert.ToInt32(row["MAKE_ORDER_STAFF"]); record.makeOrderStaffName = Staff.getInctance().getStaffNameFromPkey(record.makeOrderStaff); record.isReview = DbDataConvert.ToString(row["IS_REVIEW"]); record.note = DbDataConvert.ToString(row["NOTE"]); if (record.isReview == "1") { record.balance = DbDataConvert.ToDouble(row["BALANCE"]); record.orderReview = DbDataConvert.ToInt32(row["ORDERR_EVIEW"]); record.orderReviewName = Staff.getInctance().getStaffNameFromPkey(record.orderReview); } m_cashCashsubLedgerList.Add(m_cashCashsubLedgerList.Count, record); } } }
public CashCashsubLedgerTable getCashCashsubLedgerInfoFromOrderNumber(string billNumber) { if (m_cashCashsubLedgerList.Count == 0) { load(); } CashCashsubLedgerTable bill = new CashCashsubLedgerTable(); foreach (KeyValuePair <int, CashCashsubLedgerTable> index in m_cashCashsubLedgerList) { if (index.Value.billNumber == billNumber) { bill = index.Value; } } return(bill); }
public void insert(CashCashsubLedgerTable record) { if (checkBillIsExist(record.billNumber)) { delete(record.billNumber); } string insert = "INSERT INTO [dbo].[CASH_CASHSUB_LEDGER]([TRADING_DATE],[BILL_NUMBER],[VOUCHERS_NUMBER],[BILL_NAME],"; insert += "[BILL_TYPE_ID],[SOURCE_BILL_NUMBER],[EXCHANGES_UNIT],[TURNOVER],[MAKE_ORDER_STAFF],[IS_REVIEW],[NOTE]) VALUES("; insert += "'" + record.tradingDate + "',"; insert += "'" + record.billNumber + "',"; insert += "'" + record.vouchersNumber + "',"; insert += "'" + record.billName + "',"; insert += record.billTypeID + ","; insert += "'" + record.sourceBillNumber + "',"; insert += record.exchangesUnit + ","; insert += record.turnover + ","; insert += record.makeOrderStaff + ", 0 ,"; insert += "'" + record.note + "'"; insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); load(); MessageBoxExtend.messageOK("数据保存成功"); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }