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