private void InvoiceForm_Load(object sender, EventArgs e)
{
FillServiceList();
FillGameProperties();
printDocument.PrintPage += new PrintPageEventHandler(printDocument_PrintPage);
ServicesDataGrid.ClearSelection();
}
private void FillServiceList(DateTime reportDate)
{
DateTime dayBegin = new DateTime(reportDate.Year, reportDate.Month, reportDate.Day);
DateTime dayEnd = dayBegin.AddSeconds(86399);
string queryText = "SELECT sr.servicename,sum(u.quantity) as quantity,'unit'as units, sr.price,'equal' as equal, sr.price*sum(u.quantity) as amount,'uah' as uah " +
"FROM services sr,serviceusing u,sessions s " +
"WHERE u.sessionID=s.ID AND sr.ID=u.serviceID AND s.start>=? AND s.finish<=? AND u.quantity>0 GROUP BY servicename,price";
OleDbDataAdapter adapter = new OleDbDataAdapter(queryText, connectionString);
adapter.SelectCommand.Parameters.AddWithValue("?", dayBegin);
adapter.SelectCommand.Parameters.AddWithValue("?", dayEnd);
DataSet dataset = new DataSet();
adapter.Fill(dataset, "services");
ServicesDataGrid.DataSource = dataset.Tables["services"].DefaultView;
ServicesDataGrid.Columns["servicename"].Width = 150;
ServicesDataGrid.Columns["quantity"].Width = 30;
ServicesDataGrid.Columns["quantity"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
ServicesDataGrid.Columns["units"].Width = 60;
ServicesDataGrid.Columns["units"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
ServicesDataGrid.Columns["price"].Width = 50;
ServicesDataGrid.Columns["price"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
ServicesDataGrid.Columns["equal"].Width = 35;
ServicesDataGrid.Columns["equal"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
ServicesDataGrid.Columns["amount"].Width = 50;
ServicesDataGrid.Columns["amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
ServicesDataGrid.Columns["uah"].Width = 60;
ServicesDataGrid.Columns["uah"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
for (int i = 0; i < ServicesDataGrid.RowCount; i++)
{
ServicesDataGrid[2, i].Value = "шт. x ";
ServicesDataGrid[4, i].Value = " = ";
ServicesDataGrid[6, i].Value = "грн.";
}
ServicesDataGrid.Columns["amount"].DefaultCellStyle.Font = new Font("Times New Roman", 14, FontStyle.Bold);
ServicesDataGrid.Columns["amount"].DefaultCellStyle.ForeColor = Color.Maroon;
ServicesDataGrid.Columns["uah"].DefaultCellStyle.Font = new Font("Times New Roman", 14, FontStyle.Bold);
ServicesDataGrid.Columns["uah"].DefaultCellStyle.ForeColor = Color.Maroon;
ServicesDataGrid.ClearSelection();
}
