public List <ReportingDocumentDTO> GetReports(String filter) { List <ReportingDocumentDTO> reportList = new List <ReportingDocumentDTO>(); String query = "SELECT DocCode, DocName, PaperSize, Width, Height FROM RDOC WHERE " + filter; if (String.IsNullOrEmpty(filter)) { query = "SELECT DocCode, DocName, PaperSize FROM RDOC"; } SqlCommand command = new SqlCommand(query, sqlServerConnection); SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { ReportingDocumentDTO report = new ReportingDocumentDTO(); report.DocCode = GetStringValue(dataReader, "DocCode"); report.DocName = GetStringValue(dataReader, "DocName"); report.PaperSize = GetStringValue(dataReader, "PaperSize"); report.Width = GetSmallIntValue(dataReader, "Width"); report.Height = GetSmallIntValue(dataReader, "Height"); reportList.Add(report); } dataReader.Close(); return(reportList); }
public Form2() { InitializeComponent(); dataConnector = new DataConnector(); dataConnector.OpenConnection("sqlServer"); ReportingDocumentDAO reportingDocumentDAO = new ReportingDocumentDAO(dataConnector.SqlServerConnection); ReportingElementDAO reportingElementDAO = new ReportingElementDAO(dataConnector.SqlServerConnection); ReportingDocumentDTO reportDoc = reportingDocumentDAO.GetReport(docCode); Bitmap bmp = new Bitmap(reportDoc.Width, reportDoc.Height); Graphics graphs = Graphics.FromImage(bmp); graphs.Clear(System.Drawing.Color.White); List <ReportingElementDTO> elementList = reportingElementDAO.GetElements(docCode, "Type=10"); foreach (ReportingElementDTO element in elementList) { Rectangle rect = new Rectangle(element.left, element.top, element.width, element.height); graphs.FillRectangle(new SolidBrush(System.Drawing.Color.LightYellow), rect); if (element.borderTop > 0) { graphs.DrawRectangle(new Pen(System.Drawing.Color.Black, element.borderTop), rect); } if (element.borderBottom > 0) { graphs.DrawRectangle(new Pen(System.Drawing.Color.Black, element.borderBottom), rect); } if (element.borderLeft > 0) { graphs.DrawRectangle(new Pen(System.Drawing.Color.Black, element.borderLeft), rect); } if (element.borderRight > 0) { graphs.DrawRectangle(new Pen(System.Drawing.Color.Black, element.borderRight), rect); } } List <ReportingElementDTO> imageList = reportingElementDAO.GetElements(docCode, "Type=11"); foreach (ReportingElementDTO image in imageList) { Rectangle rect = new Rectangle(image.left, image.top, image.width, image.height); Bitmap bitmap = new Bitmap(bitmapPath + image.caption); graphs.DrawImage(bitmap, rect); } graphs.Flush(); imgReport.Image = bmp; dataConnector.CloseConnection(); }
public ReportingDocumentDTO GetReport(String docCode) { ReportingDocumentDTO report = null; String query = "SELECT DocCode, DocName, PaperSize, Width, Height FROM RDOC WHERE DocCode='" + docCode + "'"; SqlCommand command = new SqlCommand(query, sqlServerConnection); SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.Read()) { report = new ReportingDocumentDTO(); report.DocCode = GetStringValue(dataReader, "DocCode"); report.DocName = GetStringValue(dataReader, "DocName"); report.PaperSize = GetStringValue(dataReader, "PaperSize"); report.Width = GetSmallIntValue(dataReader, "Width"); report.Height = GetSmallIntValue(dataReader, "Height"); } dataReader.Close(); return(report); }