public BoundField buildBoundField(SelectedColumns.Column col, int width)
{
BoundField bf = new BoundField();
bf.DataField = col.dbFieldName;
bf.HeaderText = col.HeaderText;
bf.HeaderStyle.CssClass = "SP_dataLabel_Header";
bf.HeaderStyle.Wrap = false;
bf.HeaderStyle.HorizontalAlign = col.horizontalAlign;
bf.ItemStyle.Font.Size = FontUnit.Point(8);
bf.ItemStyle.CssClass = "SP_dataLabel";
if (width > 0)
{
bf.ItemStyle.Width = Unit.Percentage(width);
}
bf.ItemStyle.Wrap = col.wrap;
bf.ItemStyle.HorizontalAlign = col.horizontalAlign;
if (col.dataFormat.Length > 0)
{
bf.DataFormatString = col.dataFormat;
}
return(bf);
}
public TemplateField makeLabelTemplate(bool makeFooter, SelectedColumns.Column col, ITemplate template)
{
TemplateField tempField = new TemplateField();
tempField.HeaderText = col.HeaderText;
if (col.dbSortFieldName.Length > 0)
{
tempField.SortExpression = col.dbSortFieldName;
tempField.HeaderTemplate = new GridViewTemplate_Anchor("lbSort_" + col.dbSortFieldName, col.HeaderText, col.toolTip);
}
tempField.HeaderStyle.Wrap = col.wrap;
tempField.HeaderStyle.HorizontalAlign = col.horizontalAlign;
tempField.HeaderStyle.Font.Bold = false;
tempField.HeaderStyle.CssClass = "SP_dataLabel_Header";
tempField.ItemStyle.Wrap = col.wrap; // false;
tempField.ItemStyle.CssClass = "SP_dataLabel";
tempField.ItemStyle.HorizontalAlign = col.horizontalAlign;
tempField.ItemTemplate = template; // new GridViewTemplate_Label(col.dbFieldName);
if (makeFooter)
{
tempField.FooterStyle.CssClass = "SP_dataLabel";
tempField.FooterStyle.Wrap = false;
tempField.FooterStyle.HorizontalAlign = HorizontalAlign.Right;
tempField.FooterTemplate = new GridViewTemplate_FooterLabel("sum" + col.dbFieldName);
}
return(tempField);
}
private void fnSave()
{
for (int i = 0; i < tblSearch.Rows.Count; i++)
{
CheckBox cb = (CheckBox)tblSearch.Rows[i].FindControl(tblSearch.ID + "_cbID_" + i);
SelectedColumns.Column c = ColsSearch.getColumn((string)ViewState[cb.ID]);
if (c != null)
{
c.selected = cb.Checked;
}
}
ColsSearch.reOrder();
myCook.SetCookieSQL("SearchResultsSearch", ColsSearch.getCookie());
for (int i = 0; i < tblExcel.Rows.Count; i++)
{
CheckBox cb = (CheckBox)tblExcel.Rows[i].FindControl(tblExcel.ID + "_cbID_" + i);
SelectedColumns.Column c = ColsExcel.getColumn((string)ViewState[cb.ID]);
if (c != null)
{
c.selected = cb.Checked;
}
}
ColsExcel.reOrder();
myCook.SetCookieSQL("SearchResultsExcel", ColsExcel.getCookie());
setColumnSelectFields();
}
protected void moveExcel_Click(object sender, CommandEventArgs e)
{
SelectedColumns.Column c = ColsExcel.getColumn((string)e.CommandArgument);
if (e.CommandName == "Up")
{
ColsExcel.MoveUp(c);
}
else
{
ColsExcel.MoveDown(c);
}
myCook.SetCookieSQL("SearchResultsExcel", ColsExcel.getCookie());
setColumnSelectFields();
}
public PlaceHolder buildStatistics(DataTable dt, int rollingDays, string BP, string stepUsers)
{
GridView gv = MakeGrid(0);
SelectedColumns.Column col = new SelectedColumns.Column("onTimePercent", "", "On Time(%)", false, HorizontalAlign.Right, 0);
col.dataFormat = "{0:N0}";
gv.Columns.Add(buildBoundField(col, 0));
col = new SelectedColumns.Column("pastDue", "", "Past Due", false, HorizontalAlign.Right, 0);
gv.Columns.Add(buildBoundField(col, 0));
col = new SelectedColumns.Column("dueToday", "", "Due Today", false, HorizontalAlign.Right, 0);
gv.Columns.Add(buildBoundField(col, 0));
col = new SelectedColumns.Column("dueThisWeek", "", "Due This Week", false, HorizontalAlign.Right, 0);
gv.Columns.Add(buildBoundField(col, 0));
col = new SelectedColumns.Column("avgDaysToComplete", "", "Avg Days to Complete", false, HorizontalAlign.Right, 0);
col.dataFormat = "{0:N2}";
gv.Columns.Add(buildBoundField(col, 0));
col = new SelectedColumns.Column("numberCompleted", "", "Number Completed", false, HorizontalAlign.Right, 0);
gv.Columns.Add(buildBoundField(col, 0));
col = new SelectedColumns.Column("avgStepDaysToComplete", "", "Avg Days to Sign Off", false, HorizontalAlign.Right, 0);
col.dataFormat = "{0:N0}";
gv.Columns.Add(buildBoundField(col, 0));
gv.DataSource = dt;
gv.DataBind();
PlaceHolder phMetrics = new PlaceHolder();
phMetrics.Controls.Add(gv);
return(phMetrics);
}
private void buildTableRow(Table tbl, SelectedColumns.Column c, int offset)
{
TableRow tr = new TableRow();
tr.CssClass = "SP_Row";
TableCell tc = new TableCell();
if (offset == 0)
{
tc.CssClass = "SP_itemLabelCell";
Label lbl1 = new Label();
switch (tbl.ID)
{
case "tblSearch":
lbl1.Text = "Search";
break;
case "tblExcel":
lbl1.Text = "Excel";
break;
}
lbl1.CssClass = "SP_itemLabel2";
tc.Controls.Add(lbl1);
}
tr.Cells.Add(tc);
tc = new TableCell();
tc.CssClass = "SP_dataLabelCell";
CheckBox cb = new CheckBox();
cb.CssClass = "SP_dataLabel";
if (!string.IsNullOrEmpty(c.HeaderText))
{
cb.Text = c.HeaderText;
}
else
{
cb.Text = c.dbFieldName;
}
cb.ID = tbl.ID + "_cbID_" + offset;
ViewState[cb.ID] = c.dbFieldName;
cb.Checked = c.selected;
cb.Enabled = !c.required;
tc.Controls.Add(cb);
tr.Cells.Add(tc);
if (c.selected)
{
tc = new TableCell();
tc.CssClass = "SP_dataLabelCell";
ImageButton ib;
ib = new ImageButton();
ib.CssClass = "SP_dataLabel";
ib.ImageUrl = "images/Move Up (Arrow)16.png";
ib.CommandArgument = c.dbFieldName;
ib.CommandName = "Up";
switch (tbl.ID)
{
case "tblSearch":
ib.Command += moveSearch_Click;
break;
case "tblExcel":
ib.Command += moveExcel_Click;
break;
}
ib.ID = tbl.ID + "_ibID_Up_" + c.dbFieldName;
tc.Controls.Add(ib);
tr.Cells.Add(tc);
tc = new TableCell();
tc.CssClass = "SP_dataLabelCell";
ib = new ImageButton();
ib.CssClass = "SP_dataLabel";
ib.ImageUrl = "images/Move Down (Arrow)16.png";
ib.CommandArgument = c.dbFieldName;
ib.CommandName = "Down";
switch (tbl.ID)
{
case "tblSearch":
ib.Command += moveSearch_Click;
break;
case "tblExcel":
ib.Command += moveExcel_Click;
break;
}
ib.ID = tbl.ID + "_ibID_Down_" + c.dbFieldName;
tc.Controls.Add(ib);
tr.Cells.Add(tc);
}
else
{
tc = new TableCell();
tc.ColumnSpan = 2;
tc.CssClass = "SP_dataLabelCell";
tr.Cells.Add(tc);
}
tbl.Rows.Add(tr);
}
