public void See(SqlDataReader reader)
{
while (reader.Read())
{
String s = reader.GetString(0);
String[] str = s.Split(',');
for (int i = 0; i < str.Length; i++)
{
PayInf inf;
String[] h = str[i].Split('_');
if (h.Length == 2)
{
inf = new PayInf(Convert.ToDateTime(h[0]), Convert.ToDouble(h[1]));
}
else if (h.Length > 2)
{
inf = new PayInf(Convert.ToDateTime(h[0]), Convert.ToDouble(h[1]), h[2]);
}
else
{
break;
}
list.Add(inf);
//count++;
}
YearComparer yc = new YearComparer();
list.Sort(yc);
for (int i = 0; i < list.Count; i++)
{
dataGridViewInf.Rows.Add(list[i].Date.ToShortDateString(), list[i].Pay, list[i].Notice);
}
}
reader.Close();
}
public void Pay_FormClosing(object sender, FormClosingEventArgs e)
{
YearComparer comparer = new YearComparer();
list.Sort(comparer);
String str = "'";
if (list.Count > 0)
{
str += list[0].Date.ToShortDateString() + "_" + list[0].Pay.ToString();
if (list[0].Notice != "")
{
str += "_" + list[0].Notice;
}
}
for (int i = 1; i < list.Count; i++)
{
str += "," + list[i].Date.ToShortDateString() + "_" + list[i].Pay.ToString();
if (list[i].Notice != "")
{
str += "_" + list[i].Notice;
}
}
str += "'";
command.CommandText = "UPDATE Payments SET List = " + str + " WHERE Contract_num = '" + contract + "'";
command.ExecuteNonQuery();
command.CommandText = "SELECT List FROM Payments WHERE Contract_num = '" + contract + "'";
SqlDataReader reader = command.ExecuteReader();
Program.form.SqlReadDate(reader);
Act act = new Act(contract, "", "", connection);
//act.Calc(connection, contract);
act.Dispose();
Program.form.setButtonAct(true);
}
