private void simpleButton_Print_Click(object sender, EventArgs e) { var depotName = listBoxControl_Depots.GetItemText(listBoxControl_Depots.SelectedIndex); var depotDate = Convert.ToDateTime(dateEdit_DepotDate.EditValue); var sscc = string.Empty; if (gridView_SSCC.GetRowCellValue(gridView_SSCC.FocusedRowHandle, gridView_SSCC.Columns[0]) != null) { sscc = gridView_SSCC.GetRowCellValue(gridView_SSCC.FocusedRowHandle, gridView_SSCC.Columns[0]).ToString(); } if (!string.IsNullOrEmpty(sscc)) { var tableInfo = new ReportDataSetTableInfo(depotName, depotDate.ToString("dd/MM/yyyy dddd"), sscc); DataTable dtInfo = tableInfo.GetTableInfo(); var tableProducts = new DatabaseConnectionSI(); DataTable dtProducts = tableProducts.GetSsccProducts(sscc); DataRow dr = dtInfo.Rows[0]; dr[6] = dtProducts.Rows.Count; DataSet ds = new DataSet(); ds.Tables.Add(dtInfo); ds.Tables.Add(dtProducts); //ds.WriteXmlSchema(@"d:\ScotbeefSolutions\SSCC.xsd"); XtraReport report = new SSCCReport(); report.DataSource = ds; ReportPrintTool pt = new ReportPrintTool(report); pt.ShowPreview(); } }
private void GetDepots() { var connection = new DatabaseConnectionSI(); var depotTable = connection.GetDepotList(); listBoxControl_Depots.DisplayMember = connection.DisplayMember; listBoxControl_Depots.ValueMember = connection.ValueMember; listBoxControl_Depots.DataSource = depotTable; }
private void GetSSCCList() { var depotDate = Convert.ToDateTime(dateEdit_DepotDate.EditValue); string depotName = null; if (listBoxControl_Depots.SelectedValue != null) { depotName = listBoxControl_Depots.SelectedValue.ToString(); } if (depotName != null && depotDate != null) { var connection = new DatabaseConnectionSI(); var ssccTable = connection.GetSsccList(depotName, depotDate.ToString("MM/dd/yyyy")); gridControl_SSCC.DataSource = ssccTable; } }