private void DayHeader(DateTime dtRpt, bool fAM, bool fPM, string KitchenLocation) { int cJobs = 0; int cServings = 0; string Sql = "Select Count(*) As Cnt, " + "(IsNull(Sum(NumMenServing), 0) + IsNull(Sum(NumWomenServing), 0) + IsNull(Sum(NumChildServing), 0)) As NumServings " + "From mcJobs Where JobDate = " + DB.PutDtTm(dtRpt) + " " + (fAM ? "And Datepart(hour, Coalesce(DepartureTime, MealTime, '1/1/1 00:00:01')) < 12 " : string.Empty) + (fPM ? "And Datepart(hour, Coalesce(DepartureTime, MealTime, '1/1/1 00:00:01')) >= 12 " : string.Empty) + "And CancelledDtTm Is Null"; try { DataTable dt = db.DataTable(Sql); DataRow dr = dt.Rows[0]; cJobs = DB.Int32(dr["Cnt"]); cServings = DB.Int32(dr["NumServings"]); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } if (cJobs > 0) { if (fNewPage) { Response.Write( "<div style='page-break-before: always;'><img width='1' height='1' src='Images/Space.gif' alt='' /></div>"); } string Desc = KitchenLocation; Response.Write( //WebPage.Table("width='760' align='center'" + (fNewPage ? " style='page-break-before: always;" : "") + "'") + WebPage.Table("width='500' align='center'") + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td width='30%' valign='bottom'>\n" + WebPage.Tabs(3) + WebPage.Span(Desc, "RptNotice") + "\n" + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(2) + "<td align='center'>\n" + WebPage.Tabs(3) + WebPage.Div("Production Sheets", "center", "RptTitle") + WebPage.Tabs(4) + WebPage.Table("class='RptSubTitleBorder' style='padding-left: 2px; padding-right: 2px;'") + WebPage.Tabs(5) + "<tr><td class='RptSubTitle'>" + (fAM ? "AM " : string.Empty) + (fPM ? "PM " : string.Empty) + Fmt.DayOfWeek(dtRpt) + ", " + Fmt.Dt(dtRpt) + "</td></tr>\n" + WebPage.Tabs(3) + WebPage.TableEnd() + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(2) + "<td width='30%' valign='bottom' align='right'>" + WebPage.Span(Fmt.Num(cJobs), "RptNotice") + " Jobs, " + WebPage.Span(Fmt.Num(cServings), "RptNotice") + " Servings</td>\n" + WebPage.Tabs(1) + "</tr>\n" + WebPage.TableEnd() + WebPage.SpaceTable(1, 40) ); fNewPage = true; } }