public void PrepareData(List <DataRow> dr) { foreach (DataRow r in dr) { Catalogs c = new Catalogs(); DataTable dt = db.SelectTable("SELECT * FROM (((tblbookauthor ba INNER JOIN tblauthor a ON ba.authorID=a.authorID)" + " RIGHT JOIN tblbook b ON ba.bookID=b.bookID) LEFT JOIN tblpublisher p ON p.publisherID=b.publisherID)" + " LEFT JOIN tblsubject s ON b.subjectID=s.subjectID WHERE b.bookID =" + r["bookID"].ToString() + ";"); if (dt != null) { if (dt.Rows.Count > 0) { ApplyInfo(dt, c); c.CreateDocument(); reports.Add(c); } } } Catalogs main = reports[0]; if (reports.Count > 1) { for (int i = 1; i < reports.Count; i++) { main.Pages.AddRange(reports[i].Pages); } } main.ShowPreviewDialog(); }
private void ApplyInfo(DataTable dt, Catalogs c) { if (dt.Rows.Count > 0) { DataRow ro = dt.Rows[0]; c.lblDeweyAuthor.Text = (!ro["deweyDecimal"].ToString().Equals("")?ro["deweyDecimal"].ToString() + Environment.NewLine:"") + (!ro["cattersNo"].ToString().Equals("")?ro["cattersNo"].ToString() + Environment.NewLine :"") + ro["yearOfPublication"].ToString(); c.lblDeweySubject.Text = (!ro["deweyDecimal"].ToString().Equals("") ? ro["deweyDecimal"].ToString() + Environment.NewLine : "") + (!ro["cattersNo"].ToString().Equals("") ? ro["cattersNo"].ToString() + Environment.NewLine : "") + ro["yearOfPublication"].ToString(); c.lblDeweyTitle.Text = (!ro["deweyDecimal"].ToString().Equals("") ? ro["deweyDecimal"].ToString() + Environment.NewLine : "") + (!ro["cattersNo"].ToString().Equals("") ? ro["cattersNo"].ToString() + Environment.NewLine : "") + ro["yearOfPublication"].ToString(); c.lblDetailsAuthor.Text += GetAuthor(dt, lblDetailsAuthor.Text, true) + Environment.NewLine; c.lblDetailsAuthor.Text += " " + ro["title"].ToString() + GetAuthor(dt, lblDetailsAuthor.Text, false) + Environment.NewLine; c.lblDetailsAuthor.Text += ro["address"].ToString() + " : " + ro["publisherName"].ToString() + ", " + (ro["isCopyright"].ToString().Equals("0") ? "" : "c") + ro["yearOfPublication"].ToString() + "." + Environment.NewLine; c.lblDetailsAuthor.Text += " " + ro["pages"].ToString() + " p. : " + ro["typeOfIllustration"].ToString() + Environment.NewLine; c.lblDetailsAuthor.Text += Environment.NewLine + (!ro["noteArea"].ToString().Equals("")?" " + ro["noteArea"].ToString() + Environment.NewLine:""); c.lblDetailsAuthor.Text += " " + (!ro["ISBN"].ToString().Equals("") ? "ISBN: " + ro["ISBN"].ToString() + Environment.NewLine : "") + Environment.NewLine; c.lblDetailsAuthor.Text += " " + "1. " + ro["subjectName"].ToString(); c.lblDetailsSubject.Text += " " + ro["subjectName"].ToString().ToUpper() + Environment.NewLine; c.lblDetailsSubject.Text += GetAuthor(dt, lblDetailsSubject.Text, true) + Environment.NewLine; c.lblDetailsSubject.Text += " " + ro["title"].ToString() + GetAuthor(dt, lblDetailsAuthor.Text, false) + Environment.NewLine; c.lblDetailsSubject.Text += ro["address"].ToString() + " : " + ro["publisherName"].ToString() + ", " + (ro["isCopyright"].ToString().Equals("0") ? "" : "c") + ro["yearOfPublication"].ToString() + "." + Environment.NewLine; c.lblDetailsSubject.Text += " " + ro["pages"].ToString() + " p. : " + ro["typeOfIllustration"].ToString() + Environment.NewLine; c.lblDetailsSubject.Text += Environment.NewLine + (!ro["noteArea"].ToString().Equals("") ? " " + ro["noteArea"].ToString() + Environment.NewLine : ""); c.lblDetailsSubject.Text += " " + (!ro["ISBN"].ToString().Equals("")?"ISBN: " + ro["ISBN"].ToString():""); c.lblDetailsTitle.Text += " " + ro["title"].ToString() + Environment.NewLine; c.lblDetailsTitle.Text += GetAuthor(dt, lblDetailsTitle.Text, true) + Environment.NewLine; c.lblDetailsTitle.Text += " " + ro["title"].ToString() + GetAuthor(dt, lblDetailsAuthor.Text, false) + Environment.NewLine; c.lblDetailsTitle.Text += ro["address"].ToString() + " : " + ro["publisherName"].ToString() + ", " + (ro["isCopyright"].ToString().Equals("0") ? "" : "c") + ro["yearOfPublication"].ToString() + "." + Environment.NewLine; c.lblDetailsTitle.Text += " " + ro["pages"].ToString() + " p. : " + ro["typeOfIllustration"].ToString() + Environment.NewLine; c.lblDetailsTitle.Text += Environment.NewLine + (!ro["noteArea"].ToString().Equals("") ? " " + ro["noteArea"].ToString() + Environment.NewLine : ""); c.lblDetailsTitle.Text += " " + (!ro["ISBN"].ToString().Equals("") ? "ISBN: " + ro["ISBN"].ToString() : ""); if (ro["subjectName"].ToString().ToLower().Equals("fiction")) { c.pnlSubject.Dispose(); } } }