bazar.Accrual.UpdateIncomes C# (CSharp) Method

UpdateIncomes() protected method

protected UpdateIncomes ( ) : void
return void
        protected void UpdateIncomes()
        {
            if(NewAccrual)
                return;

            logger.Info("Получаем таблицу приходных ордеров...");

            string sql = "SELECT credit_slips.*, cash.name as cash " +
                    "FROM credit_slips " +
                    "LEFT JOIN cash ON credit_slips.cash_id = cash.id " +
                    "WHERE credit_slips.accrual_id = @id";

            MySqlCommand cmd = new MySqlCommand(sql, QSMain.connectionDB);
            cmd.Parameters.AddWithValue("@id", entryNumber.Text);

            MySqlDataReader rdr = cmd.ExecuteReader();

            IncomeListStore.Clear();
            while (rdr.Read())
            {
                IncomeListStore.AppendValues(rdr.GetInt32("id"),
                                             String.Format ("Приходный ордер № {0}", rdr["id"]),
                                             DateTime.Parse(rdr["date"].ToString()).ToShortDateString(),
                                             rdr["cash"].ToString (),
                                             null,
                                             String.Format ("{0:C}",rdr.GetDecimal ("sum")),
                                             rdr.GetDecimal ("sum"));
            }
            rdr.Close();

            logger.Info("Ok");
            CalculateIncomeSum ();
        }