static public CashBalanceLastMonth getInctance() { if (m_instance == null) { m_instance = new CashBalanceLastMonth(); } return(m_instance); }
public static double getCashBalanceLaseMonth() { double balance = 0; SortedDictionary <int, CashBalanceLastMonthTable> CashBalanceLastMonthList = CashBalanceLastMonth.getInctance().getAllCashBalanceLastMonthInfo(); if (CashBalanceLastMonthList.Count > 0) { balance = CashBalanceLastMonthList[0].balance; } return(balance); }
public void update(int pkey, double accountBalanec) { string update = "UPDATE [dbo].[INIT_CASH_BALANCE] SET "; update += "[CASH_BALANCE] = " + accountBalanec; update += " WHERE PKEY = " + Convert.ToString(pkey); try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); // 结转损益表插入现金期初数据 CashBalanceLastMonth.getInctance().delete(); CashBalanceLastMonth.getInctance().insert(accountBalanec, "初始余额"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
public void insert(double cashBalanec) { string insert = "INSERT INTO [dbo].[INIT_CASH_BALANCE] ([OBJECT_NAME],[CASH_BALANCE]) VALUES ('库存现金', "; insert += cashBalanec; insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); // 结转损益表插入现金期初数据 CashBalanceLastMonth.getInctance().delete(); CashBalanceLastMonth.getInctance().insert(cashBalanec, "初始余额"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }