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 ();
}