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