public ThuChi.Domain.ThuChi Execute()
{
ThuChi.Domain.ThuChi data = null;
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM ThuChi WHERE ThuChiId='" + item.Ngay + "'";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
data = new ThuChi.Domain.ThuChi
{
Ngay = Convert.ToDateTime(reader["Ngay"]),
Thu = Convert.ToInt32(reader["Thu"]),
Chi = Convert.ToInt32(reader["Chi"])
};
}
}
conn.Close();
}
}
return(data);
}
private void bunifuTileButton4_Click(object sender, EventArgs e)
{
using (var cmd = new ThuChiListBusiness())
{
cmd.Ngay = this.Datepicker1.Value.ToShortDateString();
var data = cmd.Execute();
var tmp = new ThuChi.Domain.ThuChi();
foreach (var item in data)
{
tmp.Thu += item.Thu;
tmp.Chi += item.Chi;
tmp.Ngay = item.Ngay;
}
this.thuChiBindingSource.DataSource = tmp;
}
}
