public static System.IO.StringWriter CreateExcel_HTML(
DataTable Dt
, ClsExcel_Columns Columns)
{
System.IO.StringWriter Sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter Htw = new System.Web.UI.HtmlTextWriter(Sw);
System.Web.UI.WebControls.Table Tb = new System.Web.UI.WebControls.Table();
System.Web.UI.WebControls.TableRow Tbr_Header = new System.Web.UI.WebControls.TableRow();
foreach (ClsExcel_Columns.Str_Columns?Obj in Columns.pObj)
{
System.Web.UI.WebControls.TableCell Tbc = new System.Web.UI.WebControls.TableCell();
Tbc.Text = Obj.Value.FieldDesc;
Tbr_Header.Cells.Add(Tbc);
}
Tb.Rows.Add(Tbr_Header);
foreach (DataRow Dr in Dt.Rows)
{
System.Web.UI.WebControls.TableRow Tbr = new System.Web.UI.WebControls.TableRow();
foreach (ClsExcel_Columns.Str_Columns?Obj in Columns.pObj)
{
System.Web.UI.WebControls.TableCell Tbc = new System.Web.UI.WebControls.TableCell();
Tbc.Text = Dr[Obj.Value.FieldName].ToString();
Tbr.Cells.Add(Tbc);
}
Tb.Rows.Add(Tbr);
}
Tb.RenderControl(Htw);
return(Sw);
}
public static void Export(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
Table table = new Table();
if (gv.HeaderRow != null)
{
table.Rows.Add(gv.HeaderRow);
}
foreach (GridViewRow row in gv.Rows)
{
GridViewExportUtil.PrepareControlForExport(row);
table.Rows.Add(row);
}
if (gv.FooterRow != null)
{
GridViewExportUtil.PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
table.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
public override string GetDesignTimeHtml()
{
var style = new TableStyle();
var table = new Table();
var component = Component as DeluxeSearch;
var writer = new StringWriter();
var html = new HtmlTextWriter(writer);
if (null != component)
{
if (component.Categories.Count > 0)
{
foreach (var item in component.Categories)
{
var cell = new TableCell();
var row = new TableRow();
cell.Text = string.Format("{0}:{1}", item.DataTextField, item.DataSourceID);
row.Cells.Add(cell);
table.Rows.Add(row);
}
}
else
{
var cell = new TableCell();
var row = new TableRow();
cell.Text = component.ID;
row.Cells.Add(cell);
table.Rows.Add(row);
}
table.ApplyStyle(style);
table.RenderControl(html);
}
return writer.ToString();
}
// ReSharper restore MemberCanBePrivate.Global
// ReSharper restore UnaccessedField.Global
public void loadBoardTable(Table theTable)
{
TextWriter ourTextWriter2 = new StringWriter();
HtmlTextWriter ourHtmlWriter2 = new HtmlTextWriter(ourTextWriter2);
theTable.RenderControl(ourHtmlWriter2);
newBoardHTML = ourTextWriter2.ToString();
}
public static void ExportExcell(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
Table tb = new Table();
TableRow tr1 = new TableRow();
TableCell cell1 = new TableCell();
cell1.Controls.Add(gv);
tr1.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = " ";
TableRow tr2 = new TableRow();
tr2.Cells.Add(cell2);
tb.Rows.Add(tr1);
tb.Rows.Add(tr2);
tb.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
HttpContext.Current.Response.Write(style);
HttpContext.Current.Response.Output.Write(sw.ToString());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
protected void btn_exportarExcel_Click(object sender, EventArgs e)
{
DataView view = new DataView();
view.Table = (DataTable)ViewState["lista"];
GridView gv = new GridView();
gv.DataSource = view;
gv.DataBind();
string fileName = "rutas_generadas.xls";
PrepareControlForExport(gv);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("Content-type", "application / xls");
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.Cache.SetCacheability(System.Web.HttpCacheability.Public);
HttpContext.Current.Response.ContentType = "application/ms-excel";
try
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = gv.GridLines;
if (gv.HeaderRow != null)
{
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
table.Rows.Add(row);
}
if (gv.FooterRow != null)
{
PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
gv.GridLines = GridLines.Both;
table.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
catch (HttpException ex)
{
throw ex;
}
}
public IHtmlString RenderBody()
{
var table = new System.Web.UI.WebControls.Table();
var stringWriter = new StringWriter();
table.Rows.AddRange(GenerateTBody().ToArray());
table.RenderControl(new HtmlTextWriter(stringWriter));
return(new HtmlString(stringWriter.ToString()));
}
/// <summary>
/// This Method Exports The Given Grid View to Excel File Without Formatting
/// </summary>
/// <returns>Excel File</returns>
public static void ExporttoExcel_Withoutformatting(GridView gv)
{
try
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename=cgnicin.xls"));
HttpContext.Current.Response.ContentType = "application/ms-excel";
gv.AllowPaging = false;
gv.DataBind();
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// Create a form to contain the grid
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = GridLines.Both;
table.CaptionAlign = TableCaptionAlign.Right;
table.Caption = "Generated By http://cg.nic.in on " + System.DateTime.Now.ToString("dd MMMM yyyy") + " at " + System.DateTime.Now.ToString("h:mm:ss tt");
// add the header row to the table
if (gv.HeaderRow != null)
{
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
table.Rows.Add(row);
}
// add the footer row to the table
if (gv.FooterRow != null)
{
PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
catch (ThreadAbortException)
{
}
catch (Exception e)
{
Gen_Error_Rpt.Write_Error("Class:Utilitie | Method: ExporttoExcel_Withoutformatting | Error:", e);
}
}
/// <summary>
/// Gets the design time HTML code.
/// </summary>
/// <returns>A string containing the HTML to render.</returns>
public override string GetDesignTimeHtml()
{
PagedControl pagerBuilder = (PagedControl)base.Component;
StringBuilder stringBuilder = new StringBuilder();
StringWriter stringWriter = new StringWriter();
HtmlTextWriter writer = new HtmlTextWriter(stringWriter);
// Initialize the structure.
System.Web.UI.WebControls.Table pagerPanel = new System.Web.UI.WebControls.Table();
System.Web.UI.WebControls.TableRow pagerPanelRow = new System.Web.UI.WebControls.TableRow();
System.Web.UI.WebControls.TableCell pagerPanelInfoCell = new System.Web.UI.WebControls.TableCell();
System.Web.UI.WebControls.TableCell pagerPanelNavigationCell = new System.Web.UI.WebControls.TableCell();
pagerPanelRow.Cells.Add(pagerPanelInfoCell);
pagerPanelRow.Cells.Add(pagerPanelNavigationCell);
pagerPanel.Rows.Add(pagerPanelRow);
// Initialize structure appearance
pagerPanel.ApplyStyle(pagerBuilder.PagerStyle);
pagerPanel.Width = pagerBuilder.Width;
pagerPanel.Height = pagerBuilder.Height;
pagerPanel.HorizontalAlign = pagerBuilder.HorizontalAlign;
pagerPanel.CellPadding = pagerBuilder.CellPadding;
pagerPanel.CellSpacing = pagerBuilder.CellSpacing;
pagerPanelRow.CssClass = pagerBuilder.PanelCssClass;
//pagerBuilder.InfoPanelStyle.MergeWith(pagerBuilder.PagerStyle);
//pagerPanelInfoCell.ApplyStyle(pagerBuilder.InfoPanelStyle);
pagerPanelInfoCell.ApplyStyle(pagerBuilder.PagerStyle);
pagerPanelInfoCell.HorizontalAlign = pagerBuilder.InfoPanelHorizontalAlign;
pagerPanelInfoCell.VerticalAlign = pagerBuilder.InfoPanelVerticalAlign;
pagerPanelInfoCell.Visible = !pagerBuilder.InfoPanelDisabled;
//pagerBuilder.NavPanelStyle.MergeWith(pagerBuilder.PagerStyle);
//pagerPanelNavigationCell.ApplyStyle(pagerBuilder.NavPanelStyle);
pagerPanelNavigationCell.ApplyStyle(pagerBuilder.PagerStyle);
pagerPanelNavigationCell.HorizontalAlign = pagerBuilder.NavPanelHorizontalAlign;
pagerPanelNavigationCell.VerticalAlign = pagerBuilder.NavPanelVerticalAlign;
// Initialize the info panel
pagerBuilder.BuildInfo(pagerPanelInfoCell, true);
// Initialize the navigation panel
pagerBuilder.BuildNavigation(pagerPanelNavigationCell);
// Add the whole structure to the control collection
pagerPanel.RenderControl(writer);
return(stringWriter.ToString());
}
public static void Export(string fileName, GridView gv, HttpResponse response)
{
gv.AllowPaging = false;
gv.DataBind();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename=" + fileName + ".xls"));
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// Create a form to contain the grid
Table table = new Table();
// add the header row to the table
if (gv.HeaderRow != null)
{
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
table.Rows.Add(row);
}
// add the footer row to the table
if (gv.FooterRow != null)
{
PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
}
}
protected override void Render(HtmlTextWriter output)
{
double num4 = this.TableWidth.Value;
double num = Math.Round((double) ((70.0 * num4) / 100.0));
double num2 = Math.Round((double) ((this.RatingPercent * num) / 100.0));
double num3 = Math.Round((double) (num - num2));
Table child = new Table();
TableRow row = new TableRow();
TableRow row2 = new TableRow();
TableCell cell = new TableCell();
TableCell cell2 = new TableCell();
TableCell cell3 = new TableCell();
row2.ControlStyle.CopyFrom(this.ItemStyle);
cell.ColumnSpan = 2;
if (this.Rating == 0.0)
{
cell.Text = string.Format(ResourceManager.GetString("RatingResults"), this.Rating, this.MaxRating);
}
else
{
cell.Text = string.Format(ResourceManager.GetString("RatingResults"), this.Rating.ToString("##.##"), this.MaxRating);
}
row2.Cells.Add(cell);
child.Rows.Add(row2);
cell3.ControlStyle.Font.Size = FontUnit.XXSmall;
cell3.Text = " " + this.MaxRating.ToString();
child.CellPadding = 0;
child.CellSpacing = 3;
child.BorderWidth = 0;
child.Width = Unit.Pixel((int) num);
System.Web.UI.WebControls.Image image = new System.Web.UI.WebControls.Image();
image.ImageUrl = GlobalConfig.ImagesPath + "PositiveRatingBar.gif";
image.Width = Unit.Pixel((int) num2);
image.Height = 12;
cell2.Controls.Add(image);
image = new System.Web.UI.WebControls.Image();
image.ImageUrl = GlobalConfig.ImagesPath + "NegativeRatingBar.gif";
image.Width = Unit.Pixel((int) num3);
image.Height = 12;
cell2.Controls.Add(image);
row.ControlStyle.CopyFrom(this.ItemStyle);
row.Cells.Add(cell2);
row.Cells.Add(cell3);
child.Controls.Add(row);
this.Controls.Add(child);
child.RenderControl(output);
}
/// <summary>
///
/// </summary>
/// <param name="fileName"></param>
/// <param name="gv"></param>
public static void Export(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// Create a table to contain the grid
Table table = new Table();
// include the gridline settings
table.GridLines = gv.GridLines;
// add the header row to the table
if (gv.HeaderRow != null)
{
GridViewExportUtil.PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gv.Rows)
{
GridViewExportUtil.PrepareControlForExport(row);
table.Rows.Add(row);
}
// add the footer row to the table
if (gv.FooterRow != null)
{
GridViewExportUtil.PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
public static void Export(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
//HttpContext.Current.Response.Charset = "utf-8";
using (var sw = new StringWriter())
{
using (var htw = new HtmlTextWriter(sw))
{
// Create a form to contain the grid
var table = new Table
{
GridLines = GridLines.Both //单元格之间添加实线
};
// add the header row to the table
if (gv.HeaderRow != null)
{
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
table.Rows.Add(row);
}
// add the footer row to the table
if (gv.FooterRow != null)
{
PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
protected override void Render(HtmlTextWriter output)
{
double num4 = this.TableWidth.Value;
double num = Math.Round((double) ((70.0 * num4) / 100.0));
double num2 = Math.Round((double) ((this.Progress * num) / 100.0));
double num3 = Math.Round((double) (num - num2));
Table child = new Table();
TableRow row = new TableRow();
TableCell cell = new TableCell();
child.CellPadding = 0;
child.CellSpacing = 0;
child.BorderWidth = 0;
child.Width = Unit.Pixel((int) num);
Image image = new Image();
if (this.BarColor == null)
{
image.ImageUrl = GlobalConfig.ImagesPath + "bar/BarOn_red.gif";
}
else
{
image.ImageUrl = GlobalConfig.ImagesPath + "bar/BarOn_" + this.BarColor + ".gif";
}
image.Width = Unit.Pixel((int) num2);
image.Height = 14;
cell.Controls.Add(image);
image = new Image();
image.ImageUrl = GlobalConfig.ImagesPath + "bar/BarOff.gif";
image.Width = Unit.Pixel((int) num3);
image.Height = 14;
cell.Controls.Add(image);
row.ControlStyle.CopyFrom(this.ItemStyle);
row.Cells.Add(cell);
cell = new TableCell();
if (this.Progress == 0)
{
cell.Text = " 0%";
}
else
{
cell.Text = " " + this.Progress.ToString("##.##") + "%";
}
cell.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cell);
child.Controls.Add(row);
this.Controls.Add(child);
child.RenderControl(output);
}
/// <summary>
/// Generates the table.
/// </summary>
/// <param name="cssClass">The CSS class.</param>
/// <returns>HtmlString.</returns>
/// <exception cref="System.Exception"></exception>
public HtmlString GenerateTable(string cssClass = "")
{
var classname = !string.IsNullOrWhiteSpace(cssClass) ? string.Format("table {0}", cssClass) : "table";
var table = new System.Web.UI.WebControls.Table
{
CssClass = classname
};
#region Generate THEAD
table.Rows.Add(GenerateTHead());
#endregion
#region Generate TBODY
var rows = GenerateTBody();
foreach (var row in rows)
{
table.Rows.Add(row);
}
#endregion
#region Generate TFOOT
//table.Rows.Add(GenerateTFoot());
#endregion
try
{
var strWriter = new StringWriter();
table.RenderControl(new HtmlTextWriter(strWriter));
var html = new HtmlString(strWriter.ToString());
return(html);
}
catch (Exception ex)
{
throw new Exception(string.Format("Problems generating table. Exception: {0}{2}, Message: {1}{2}", ex, ex.Message, Environment.NewLine));
}
}
public static void Export(string fileName, GridView gv)
{
string style = @"<style> .text { mso-number-format:\@; } </style> ";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
System.Web.UI.WebControls.Table tbl = new System.Web.UI.WebControls.Table();
if (gv.HeaderRow != null)
{
PrepareControlForExport(gv.HeaderRow);
tbl.Rows.Add(gv.HeaderRow);
}
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
tbl.Rows.Add(row);
}
if (gv.FooterRow != null)
{
PrepareControlForExport(gv.FooterRow);
tbl.Rows.Add(gv.FooterRow);
}
tbl.RenderControl(htw);
HttpContext.Current.Response.Write(style);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
/// <summary>
/// 将此控件呈现给指定的输出参数。
/// </summary>
/// <param name="writer"> 要写出到的 HTML 编写器 </param>
private void Render_TopToBottom(HtmlTextWriter writer)
{
this.RenderBeginTag(writer);
if (this.Htmls.Count > 0)
{
System.Web.UI.WebControls.Table tableArray = new System.Web.UI.WebControls.Table();
tableArray.Width = System.Web.UI.WebControls.Unit.Parse("100%");
tableArray.BorderWidth = System.Web.UI.WebControls.Unit.Parse("0px");
tableArray.CellPadding = 0;
tableArray.CellSpacing = 0;
for (int i = 0; i < this.Htmls.Count; i++)
{
System.Web.UI.WebControls.TableRow trowArray = new System.Web.UI.WebControls.TableRow();
tableArray.Rows.Add(trowArray);
System.Web.UI.WebControls.TableCell tc = new System.Web.UI.WebControls.TableCell();
tc.Text = this.Htmls[i];
trowArray.Cells.Add(tc);
if (this.Interval != System.Web.UI.WebControls.Unit.Empty)//插入 HTML 代码块 之间的间隔距离。
{
System.Web.UI.WebControls.TableRow sptrowArray = new System.Web.UI.WebControls.TableRow();
tableArray.Rows.Add(sptrowArray);
System.Web.UI.WebControls.TableCell sptc = new System.Web.UI.WebControls.TableCell();
sptc.Text = "<div style=\"HEIGHT:" + this.Interval.ToString() + "\" />";
sptrowArray.Cells.Add(sptc);
}
}
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
tableArray.RenderControl(htw);
writer.Write(sw.ToString());
}
writer.Write(@"<script type=""text/javascript"">
HtmlRotator('" + this.ClientID + @"', 3, " + this.PlaySpeed.ToString() + @", " + this.PauseTime.ToString() + ", " + this.StopOnMouseOver.ToString().ToLower() + @");
</script>
");
this.RenderEndTag(writer);
}
//public
/// <summary>
/// Render this control to the output parameter specified.
/// </summary>
/// <param name="output"> The HTML writer to write out to </param>
protected override void Render(HtmlTextWriter output)
{
if (Context.User.Identity.IsAuthenticated)
{
NdiMenuItem item0 =
new NdiMenuItem(0, "Felhasználói adatok", "Felhasználói adatok", "UserData.aspx", "_images/userdataS.gif",
"_images/userdataL.gif");
NdiMenuItem item1 =
new NdiMenuItem(1, "Felhasználói adatok módosítása", "Felhasználói adatok módosítása", "UserDataModify.aspx",
"_images/userdataModS.gif",
"_images/userdataModL.gif");
NdiMenuItem item2 =
new NdiMenuItem(2, "Jelszó változtatás", "Jelszó változtatás", "UserPassword.aspx", "_images/passChangeS.gif",
"_images/passChangeL.gif");
Table table = new Table();
table.CellPadding = 0;
table.CellSpacing = 0;
table.CssClass = "almenu";
TableRow row1 = new TableRow();
TableCell cell0 = CreateCell(item0);
TableCell cell2 = CreateCell(item2);
TableCell cell1 = CreateCell(item1);
table.Rows.Add(row1);
row1.Cells.Add(cell0);
row1.Cells.Add(cell1);
row1.Cells.Add(cell2);
table.Width = Unit.Percentage(100);
table.RenderControl(output);
}
}
public void ExportToExcel(string column, string order)
{
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-us");// Thread.CurrentThread.CurrentUICulture;
GridView grdProductList = new GridView();
grdProductList.AutoGenerateColumns = false;
#region Columns
BoundField bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "SaleOrderCode";
bf.HeaderText = "OV";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "PurchaseOrderItemCode";
bf.HeaderText = "Producto";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "PurchaseOrderCode";
bf.HeaderText = "OC";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "Quantity";
bf.HeaderText = "Cantidad";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "CustomerCode";
bf.HeaderText = "Cliente";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "GAP";
bf.HeaderText = "GAP";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "WayOfDelivery";
bf.HeaderText = "Modo Envio";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "SaleOrderDeliveryDate";
bf.HeaderText = "Entrega OV";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "PurchaseOrderArrivalDate";
bf.HeaderText = "Llegada OC";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "OrderDate";
bf.HeaderText = "Creación";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
#endregion
if (!string.IsNullOrEmpty(column))
{
grdProductList.DataSource = ShowAlert(column, order);
}
else
{
grdProductList.DataSource = ShowAlert4();
}
grdProductList.DataBind();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename=OVNoCumplimentadas.xls"));
HttpContext.Current.Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = grdProductList.GridLines;
//Set the Cell format
string codeFormat = @"<style>.cF { mso-number-format:'\@'; }</style>";
// add the header row to the table
if (grdProductList.HeaderRow != null)
{
PrepareControlForExport(grdProductList.HeaderRow);
table.Rows.Add(grdProductList.HeaderRow);
table.Rows[0].ForeColor = Color.FromArgb(102, 102, 102);
for (int i = 0; i < table.Rows[0].Cells.Count; i++)
{
table.Rows[0].Cells[i].BackColor = Color.FromArgb(225, 224, 224);
}
}
// add each of the data rows to the table
foreach (GridViewRow row in grdProductList.Rows)
{
PrepareControlForExport(row);
int pos = table.Rows.Add(row);
table.Rows[pos].Cells[0].Attributes.Add("class", "cF");
table.Rows[pos].Cells[1].Attributes.Add("class", "cF");
table.Rows[pos].Cells[2].Attributes.Add("class", "cF");
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response adding de style
HttpContext.Current.Response.Write(codeFormat + sw.ToString());
HttpContext.Current.Response.End();
}
public void BindData(int IdClanak)
{
DataSet ds = new DataSet();
DataSet ds2 = new DataSet();
SqlCommand cmd = new SqlCommand("Select Id,Pitanje,Datum from Pitanja where IdClanak="+ IdClanak, connection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
SqlCommand cmd2 = null;
SqlDataAdapter da2;
DataTable dt = new DataTable();
int idpitanje;
Table t = new Table();
DataTable dataTable = new DataTable();
DataRow dr;
dt.Columns.Add("Id");
dt.Columns.Add("Question");
dt.Columns.Add("Date");
dt.Columns.Add("IdType");
dt.Columns.Add("Type");
//dt.Columns.Add("Ocjena");
//dt.Columns.Add("josjednacolona");
da.Fill(dataTable);
da.Fill(ds, "Pitanja");
//ds = da.GetOrderStatus(iOrderId);
if (ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (dataTable != null)
{
dr = dt.NewRow();
dr["Id"] = ds.Tables[0].Rows[i]["Id"].ToString();
dr["Question"] = ds.Tables[0].Rows[i]["Pitanje"].ToString();
dr["Date"] = ds.Tables[0].Rows[i]["Datum"].ToString();
dr["IdType"] = 1;
dr["Type"] = "Pitanje postavljeno dana: ";
// = ds.Tables[0].Rows[i]["Pitanje"].ToString();
//dr["Answer"] = txtAnswer.Text;
dt.Rows.Add(dr);
dt.AcceptChanges();
gvPitanjaOdgovori.DataSource = dt;
gvPitanjaOdgovori.DataBind();
// gvPitanjaOdgovori.Rows[0].Cells[0].BackColor = System.Drawing.Color.Red;
}
idpitanje = (int)ds.Tables[0].Rows[i]["Id"];
cmd2 = new SqlCommand("Select Id,Odgovor,Datum from Odgovori where IdPitanje=" + idpitanje, connection);
da2 = new SqlDataAdapter(cmd2);
da2.Fill(ds2, "Odgovori");
TableRow tr = new TableRow();
TableCell td = new TableCell { Text = ds.Tables[0].Rows[i]["Pitanje"].ToString() };
tr.Cells.Add(td);
t.Rows.Add(tr);
for (int j = 0; j < ds2.Tables[0].Rows.Count; j++)
{
if (dataTable != null)
{
dr = dt.NewRow();
dr["Id"] = ds2.Tables[0].Rows[j]["Id"].ToString();
dr["Question"] = ds2.Tables[0].Rows[j]["Odgovor"].ToString();
dr["Date"] = ds2.Tables[0].Rows[j]["Datum"].ToString();
dr["IdType"] = 2;
dr["Type"] = "Odgovoreno dana: ";
//dr["Answer"] = txtAnswer.Text;
dt.Rows.Add(dr);
dt.AcceptChanges();
gvPitanjaOdgovori.DataSource = dt;
gvPitanjaOdgovori.DataBind();
// gvPitanjaOdgovori.Rows[0].Cells[0].BackColor = System.Drawing.Color.Yellow;
}
TableRow tr1 = new TableRow();
TableCell td1 = new TableCell { Text = "-------" + ds2.Tables[0].Rows[j]["Odgovor"].ToString() };
tr1.Cells.Add(td1);
t.Rows.Add(tr1);
}
ds2 = new DataSet();
}
using (StringWriter sw = new StringWriter())
{
t.RenderControl(new HtmlTextWriter(sw));
string html = sw.ToString();
}
}
else
{
//lblinform.Text = "No data found.";
}
for (int d = 0; d<gvPitanjaOdgovori.Rows.Count; d++)
{
for (int j = 0; j < gvPitanjaOdgovori.Rows[d].Cells.Count; j++)
{
if (gvPitanjaOdgovori.Rows[d].Cells[3].Text.ToString()=="1")
gvPitanjaOdgovori.Rows[d].Cells[2].BackColor = System.Drawing.Color.Lavender;
else
gvPitanjaOdgovori.Rows[d].Cells[2].BackColor = System.Drawing.Color.Honeydew;
}
}
MyPanel.Controls.Add(t);
}
protected void LBExportToExcel_Click(object sender, EventArgs e)
{
try
{
string fileName = "Employee_Report" + System.DateTime.Now + ".xls";
string Extension = ".xls";
if (Extension == ".xls")
{
for (int i = 0; i < GVEmployee.Columns.Count; i++)
{
GVEmployee.Columns[i].Visible = true;
}
BindGVEmployees();
clsConnectionSql.PrepareControlForExport(GVEmployee);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.Cache.SetCacheability(System.Web.HttpCacheability.Public);
HttpContext.Current.Response.ContentType = "application/ms-excel";
try
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
//Create a form to contain the grid
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = GVEmployee.GridLines;
//add the header row to the table
if (GVEmployee.HeaderRow != null)
{
clsConnectionSql.PrepareControlForExport(GVEmployee.HeaderRow);
table.Rows.Add(GVEmployee.HeaderRow);
}
//add each of the data rows to the table
foreach (GridViewRow row in GVEmployee.Rows)
{
clsConnectionSql.PrepareControlForExport(row);
table.Rows.Add(row);
}
//add the footer row to the table
if (GVEmployee.FooterRow != null)
{
clsConnectionSql.PrepareControlForExport(GVEmployee.FooterRow);
table.Rows.Add(GVEmployee.FooterRow);
}
//render the table into the htmlwriter
GVEmployee.GridLines = GridLines.Both;
table.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
catch (HttpException ex)
{
ShowMessage(ex.Message, MessageType.Error);
}
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, MessageType.Error);
}
}
public void generar(Object Sender, EventArgs e)
{
string [] pr = new string[2];
pr[0] = pr[1] = "";
Press frontEnd = new Press(new DataSet(), reportTitle);
frontEnd.PreHeader(tabPreHeader, Grid.Width, pr);
frontEnd.Firmas(tabFirmas, Grid.Width);
lb.Text = "";
Año = Convert.ToInt32(año.SelectedValue.ToString());
Mes = Convert.ToInt32(DBFunctions.SingleData("SELECT pmes_mes FROM DBXSCHEMA.pmes WHERE pmes_nombre='" + mes.SelectedValue.ToString() + "' "));
dia = Convert.ToInt32(Dia.Text.ToString());
///////////////////////////////////////////////////////
this.PrepararTabla();
this.PrepararTabla1();
this.PrepararTabla2();
this.PrepararTabla4();
lineas = new DataSet();
lineas2 = new DataSet();
lineas3 = new DataSet();
lineas4 = new DataSet();
DBFunctions.Request(lineas, IncludeSchema.NO, "Select MREM.MCAT_PLACA AS PLACA,MREM.NUM_REM AS NUMERO,MREM.VALO_FLET AS REMESA from DBXSCHEMA.MREMESA MREM where year(MREM_FECHA)=" + Año + " AND MONTH(MREM_FECHA)=" + Mes + " AND DAY(MREM_FECHA)=" + dia + " "); //remesa
DBFunctions.Request(lineas2, IncludeSchema.NO, "SELECT MAN.MCAT_PLACA AS PLACA,MAN.MAN_CODIGO AS NUMERO,MAN.MAN_VALOTOTAL AS VALOR from DBXSCHEMA.MANTICIPO MAN WHERE year(MAN_FECHA)=" + Año + " AND MONTH(MAN_FECHA)=" + Mes + " AND DAY(MAN_FECHA)=" + dia + " "); //anticipo
DBFunctions.Request(lineas3, IncludeSchema.NO, "select MAU.MCAT_PLACA AS PLACA,MAU.MAU_CODIGO AS NUMERO,MAU.MAU_VALOTOT AS VALOR from DBXSCHEMA.MAUTORIZACION MAU WHERE year(MAU_FECHA)=" + Año + " AND MONTH(MAU_FECHA)=" + Mes + " AND DAY(MAU_FECHA)=" + dia + " "); //autorizacion de servicio
DBFunctions.Request(lineas4, IncludeSchema.NO, "select DRUT.MCAT_PLACA,DRUT.DRUT_PLANILLA,DRUT.DRUT_CODIGO from DBXSCHEMA.DRUTA DRUT WHERE year(DRUT.DRUT_FECHA)=" + Año + " AND MONTH(DRUT.DRUT_FECHA)=" + Mes + " AND DAY(DRUT.DRUT_FECHA)=" + dia + " "); // tiquetes
/////////////////////////TABLAS//////////////////////////
/////////////////// TABLA 1 /////////////////////////////
for (int i = 0; i < lineas.Tables[0].Rows.Count; i++)
{
//Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores
DataRow fila;
fila = resultado.NewRow();
double valor = 0;
string ValorFormato = null;
valor = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[2].ToString());
ValorFormato = String.Format("{0:C}", valor);
fila["BUS"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString();
fila["NUMERO"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString();
fila["VALOR"] = ValorFormato.ToString();
resultado.Rows.Add(fila);
}
///////////////////////TABLA 2///////////////////////////
for (int a = 0; a < lineas2.Tables[0].Rows.Count; a++)
{
//Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores
DataRow fila2;
fila2 = resultado2.NewRow();
double valor2 = 0;
string ValorFormato2 = null;
valor2 = Convert.ToDouble(lineas2.Tables[0].Rows[a].ItemArray[2].ToString());
ValorFormato2 = String.Format("{0:C}", valor2);
fila2["BUS1"] = lineas2.Tables[0].Rows[a].ItemArray[0].ToString();
fila2["NUMERO1"] = lineas2.Tables[0].Rows[a].ItemArray[1].ToString();
fila2["VALOR1"] = ValorFormato2.ToString();
resultado2.Rows.Add(fila2);
}
/////////////////// TABLA 3 /////////////////////
for (int b = 0; b < lineas3.Tables[0].Rows.Count; b++)
{
//Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores
DataRow fila3;
fila3 = resultado3.NewRow();
double valor3 = 0;
string ValorFormato3 = null;
valor3 = Convert.ToDouble(lineas3.Tables[0].Rows[b].ItemArray[2].ToString());
ValorFormato3 = String.Format("{0:C}", valor3);
fila3["BUS2"] = lineas3.Tables[0].Rows[b].ItemArray[0].ToString();
fila3["NUMERO2"] = lineas3.Tables[0].Rows[b].ItemArray[1].ToString();
fila3["VALOR2"] = ValorFormato3.ToString();
resultado3.Rows.Add(fila3);
}
/////////////////// TABLA 4 /////////////////////
for (int c = 0; c < lineas4.Tables[0].Rows.Count; c++)
{
int codigoruta = Convert.ToInt32(lineas4.Tables[0].Rows[c].ItemArray[2].ToString());
int Puestos = Convert.ToInt32(DBFunctions.SingleData("SELECT count(*) AS NUMERO from DBXSCHEMA.DTIQUETE where DRUT_CODIGO=" + codigoruta + " and TTIQ_CODIGO=1"));
int codigoMruta = Convert.ToInt32(DBFunctions.SingleData("select MRUT_CODIGO FROM DBXSCHEMA.DRUTA WHERE DRUT_CODIGO=" + codigoruta + " "));
double precio = Convert.ToDouble(DBFunctions.SingleData("select MRUT_VALOR from DBXSCHEMA.MRUTA WHERE MRUT_CODIGO=" + codigoMruta + ""));
double total = precio * Puestos;
//Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores
DataRow fila4;
fila4 = resultado4.NewRow();
string ValorFormato4 = null;
ValorFormato4 = String.Format("{0:C}", total);
fila4["BUS4"] = lineas4.Tables[0].Rows[c].ItemArray[0].ToString();
fila4["TOTAL"] = Puestos;
fila4["VALOR4"] = ValorFormato4.ToString();
resultado4.Rows.Add(fila4);
}
///////////// FIN TABLAS ////////////////////
Grid.DataSource = resultado;
Grid.DataBind();
StringBuilder SB = new StringBuilder();
StringWriter SW = new StringWriter(SB);
HtmlTextWriter htmlTW = new HtmlTextWriter(SW);
tabPreHeader.RenderControl(htmlTW);
Grid.RenderControl(htmlTW);
tabFirmas.RenderControl(htmlTW);
string strRep;
strRep = SB.ToString();
Session.Clear();
Session["Rep"] = strRep;
toolsHolder.Visible = true;
//////////////////////////////
Grid1.DataSource = resultado2;
Grid1.DataBind();
Grid1.RenderControl(htmlTW);
//////////////////////////////
Grid2.DataSource = resultado3;
Grid2.DataBind();
Grid2.RenderControl(htmlTW);
//////////////////////////////
Grid3.DataSource = resultado4;
Grid3.DataBind();
Grid3.RenderControl(htmlTW);
////////////////////////////////
}
public void ExportToExcel(string column, string order)
{
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-us");// Thread.CurrentThread.CurrentUICulture;
GridView grdProductList = new GridView();
grdProductList.AutoGenerateColumns = false;
#region Columns
BoundField bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "ProductCode";
bf.HeaderText = "Producto";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "ProductName";
bf.HeaderText = "Descripción";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "Group";
bf.HeaderText = "Grupo";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "Sales";
bf.HeaderText = "VTA. 12M";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "CuatrimestralSales";
bf.HeaderText = "VTA. 12M/3";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "SaleMonths";
bf.HeaderText = "Vida del Producto";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "RepositionLevel";
bf.HeaderText = "N. Reposición";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "Result";
bf.HeaderText = "Diferencía %";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "ProductCountryCode";
bf.HeaderText = "Código de País";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "OrderInfo";
bf.HeaderText = "Información de Orden de Venta (Cant. Ordenes/%/N. Orden)";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
#endregion
grdProductList.DataSource = ShowAlert(column, order);
grdProductList.DataBind();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename=DiferenciaEnNivelDeReposición.xls"));
HttpContext.Current.Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = grdProductList.GridLines;
//Set the Cell format
string codeFormat = @"<style>.cF { mso-number-format:'\@'; }</style>";
// add the header row to the table
if (grdProductList.HeaderRow != null)
{
PrepareControlForExport(grdProductList.HeaderRow);
table.Rows.Add(grdProductList.HeaderRow);
table.Rows[0].ForeColor = Color.FromArgb(102, 102, 102);
for (int i = 0; i < table.Rows[0].Cells.Count; i++)
{
table.Rows[0].Cells[i].BackColor = Color.FromArgb(225, 224, 224);
}
}
// add each of the data rows to the table
List <AlertReposition> arLSt = grdProductList.DataSource as List <AlertReposition>;
foreach (GridViewRow row in grdProductList.Rows)
{
PrepareControlForExport(row);
int pos = table.Rows.Add(row);
table.Rows[pos].Cells[0].Attributes.Add("class", "cF");
//ver esto
AlertReposition ar = arLSt[pos - 1];
if (ar != null && ar.IsConflicted)
{
for (int i = 0; i < table.Rows[pos].Cells.Count; i++)
{
table.Rows[pos].Cells[i].BackColor = Color.FromArgb(250, 128, 114);
}
}
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response adding de style
HttpContext.Current.Response.Write(codeFormat + sw.ToString());
HttpContext.Current.Response.End();
}
private void ExportToExcel(string fileName, Microsoft.SharePoint.WebControls.SPGridView spGV)
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
Table table = new Table();
if (spGV.HeaderRow != null)
{
table.Rows.Add(spGV.HeaderRow);
}
foreach (GridViewRow gvRow in spGV.Rows)
{
table.Rows.Add(gvRow);
}
if (spGV.FooterRow != null)
{
table.Rows.Add(spGV.FooterRow);
}
table.BorderWidth = 1;
foreach (TableRow tr in table.Rows)
{
foreach (TableCell td in tr.Cells)
{
td.BorderWidth = 1;
}
}
//htw.RenderBeginTag(HtmlTextWriterTag.Span);
//htw.Write("Test");
//htw.RenderEndTag();
table.RenderControl(htw);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Charset = Encoding.UTF8.ToString();
HttpContext.Current.Response.ContentEncoding = Encoding.UTF8;
Response.Write("<html><head><meta http-equiv=Content-Type content=\"text/html; charset=utf-8\">");
HttpContext.Current.Response.Write(sw.ToString());
Response.Write("</body></html>");
HttpContext.Current.Response.End();
}
}
}
//public
/// <summary>
/// Render this control to the output parameter specified.
/// </summary>
/// <param name="output"> The HTML writer to write out to </param>
protected override void Render(HtmlTextWriter output)
{
NdiMenuItem item0 =
new NdiMenuItem(0, "Állás keresések listája", "Elérhetõ állás keresések szûréssel", "JobFinds.aspx", "_images/searchKexWordS.gif",
"_images/searchKexWordL.gif");
NdiMenuItem item1 =
new NdiMenuItem(1, "Új állás keresés rögzítése", "Új állás keresés rögzítése", "JobFindCreate.aspx", "_images/searchFreeTextS.gif",
"_images/searchFreeTextL.gif");
NdiMenuItem item2 =
new NdiMenuItem(2, "Milyen keresésekre válaszoltam", "Milyen keresésekre válaszoltam", "JobFindMyAnswers.aspx", "_images/searchQuestionFormS.gif",
"_images/searchQuestionFormL.gif");
NdiMenuItem item3 =
new NdiMenuItem(3, "Saját állás kereséseim", "Saját állás kereséseim", "JobFindsFromMe.aspx", "_images/searchQuestionFormS.gif",
"_images/searchQuestionFormL.gif");
Table table = new Table();
table.CellPadding = 0;
table.CellSpacing = 0;
table.CssClass = "almenu";
TableRow row1 = new TableRow();
TableRow row2 = new TableRow();
TableCell cell0 = CreateCell(item0);
TableCell cell1 = CreateCell(item1);
TableCell cell2 = CreateCell(item2);
TableCell cell3 = CreateCell(item3);
table.Rows.Add(row2);
table.Rows.Add(row1);
if (item0.Index == m_selectedindex)
row1.Cells.Add(cell0);
else
row2.Cells.Add(cell0);
if (item1.Index == m_selectedindex)
row1.Cells.Add(cell1);
else
row2.Cells.Add(cell1);
if (item2.Index == m_selectedindex)
row1.Cells.Add(cell2);
else
row2.Cells.Add(cell2);
if (item3.Index == m_selectedindex)
row1.Cells.Add(cell3);
else
row2.Cells.Add(cell3);
if (row1.Cells != null && row1.Cells.Count > 0 && row2.Cells != null && row2.Cells.Count > 0)
{
row1.Cells[0].ColumnSpan = row2.Cells.Count;
}
table.Width = Unit.Percentage(100);
table.RenderControl(output);
}
public static System.IO.StringWriter CreateExcel_HTML(
DataTable Dt
, ClsExcel_Columns Columns)
{
System.IO.StringWriter Sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter Htw = new System.Web.UI.HtmlTextWriter(Sw);
System.Web.UI.WebControls.Table Tb = new System.Web.UI.WebControls.Table();
System.Web.UI.WebControls.TableRow Tbr_Header = new System.Web.UI.WebControls.TableRow();
foreach (ClsExcel_Columns.Str_Columns? Obj in Columns.pObj)
{
System.Web.UI.WebControls.TableCell Tbc = new System.Web.UI.WebControls.TableCell();
Tbc.Text = Obj.Value.FieldDesc;
Tbr_Header.Cells.Add(Tbc);
}
Tb.Rows.Add(Tbr_Header);
foreach (DataRow Dr in Dt.Rows)
{
System.Web.UI.WebControls.TableRow Tbr = new System.Web.UI.WebControls.TableRow();
foreach (ClsExcel_Columns.Str_Columns? Obj in Columns.pObj)
{
System.Web.UI.WebControls.TableCell Tbc = new System.Web.UI.WebControls.TableCell();
Tbc.Text = Dr[Obj.Value.FieldName].ToString();
Tbr.Cells.Add(Tbc);
}
Tb.Rows.Add(Tbr);
}
Tb.RenderControl(Htw);
return Sw;
}
private void ExportToExcel(GridState gs, IList <IFilter> filters)
{
Thread.CurrentThread.CurrentCulture = Thread.CurrentThread.CurrentUICulture;
GridView grdProductList = new GridView();
grdProductList.AutoGenerateColumns = false;
BoundField bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "Code";
bf.HeaderText = "Código";
bf.HtmlEncode = false;
// bf.DataFormatString = "{0:00000000}";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(600);
bf.DataField = "FinalInfo";
bf.HeaderText = "Modelo";
bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
grdProductList.Columns.Add(bf);
//si sos Admin
ExecutePermissionValidator epv = new ExecutePermissionValidator();
epv.ClassType = typeof(ProductListView);
epv.KeyIdentifier = Config.CanExportAll;
bool canExporAll = PermissionManager.Check(epv);
if (canExporAll)
{
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(150);
bf.DataField = "Provider";
bf.HeaderText = "Proveedor";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(50);
bf.DataField = "Index";
bf.HeaderText = "Index";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:F2}";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(70);
bf.DataField = "Type";
bf.HeaderText = "Frecuencia";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(30);
bf.DataField = "PricePurchaseCurrency";
bf.HeaderText = "M. TP";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(70);
bf.DataField = "PricePurchase";
bf.HeaderText = "TP";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:F2}";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(30);
bf.DataField = "PriceSuggestCurrency";
bf.HeaderText = "M. GRP";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(70);
bf.DataField = "PriceSuggest";
bf.HeaderText = "GRP";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:F2}";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(30);
bf.DataField = "PriceListCurrency";
bf.HeaderText = "M. PV";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(70);
bf.DataField = "PriceSell";
bf.HeaderText = "PV";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:F2}";
grdProductList.Columns.Add(bf);
}
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(10);
bf.DataField = "PriceListCurrency";
bf.HeaderText = "M. PL";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(70);
bf.DataField = "Price";
bf.HeaderText = "PL";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:F2}";
grdProductList.Columns.Add(bf);
if (canExporAll)
{
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(30);
bf.DataField = "PriceListCurrency";
bf.HeaderText = "M. CTM";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(70);
bf.DataField = "CTM";
bf.HeaderText = "CTM";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:F2}";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(70);
bf.DataField = "CTR";
bf.HeaderText = "CTR";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:F2}";
grdProductList.Columns.Add(bf);
//bf = new BoundField();
//bf.ItemStyle.Width = Unit.Pixel(70);
//bf.DataField = "Status";
//bf.HeaderText = "Estado";
//grdProductList.Columns.Add(bf);
}
//***************//
grdProductList.DataSource = GetFiltered(gs, filters);
grdProductList.DataBind();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename=ListadePrecios.xls"));
HttpContext.Current.Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = grdProductList.GridLines;
//Set the Cell format
string codeFormat = @"<style>.cF { mso-number-format:'\@'; }</style>";
// add the header row to the table
if (grdProductList.HeaderRow != null)
{
PrepareControlForExport(grdProductList.HeaderRow);
table.Rows.Add(grdProductList.HeaderRow);
table.Rows[0].ForeColor = System.Drawing.Color.FromArgb(102, 102, 102);
for (int i = 0; i < table.Rows[0].Cells.Count; i++)
{
table.Rows[0].Cells[i].BackColor = System.Drawing.Color.FromArgb(225, 224, 224);
}
}
// add each of the data rows to the table
foreach (GridViewRow row in grdProductList.Rows)
{
PrepareControlForExport(row);
int pos = table.Rows.Add(row);
table.Rows[pos].Cells[0].Attributes.Add("class", "cF");
table.Rows[pos].Cells[0].HorizontalAlign = HorizontalAlign.Right;
table.Rows[pos].Cells[0].Width = 95;
table.Rows[pos].Cells[1].Width = 600;
table.Rows[pos].Cells[2].Width = 110;
table.Rows[pos].Cells[2].HorizontalAlign = HorizontalAlign.Left;
table.Rows[pos].Cells[4].HorizontalAlign = HorizontalAlign.Right;
table.Rows[pos].Cells[5].HorizontalAlign = HorizontalAlign.Right;
table.Rows[pos].Cells[7].HorizontalAlign = HorizontalAlign.Right;
table.Rows[pos].Cells[9].HorizontalAlign = HorizontalAlign.Right;
table.Rows[pos].Cells[11].HorizontalAlign = HorizontalAlign.Right;
table.Rows[pos].Cells[13].HorizontalAlign = HorizontalAlign.Right;
//Set Euro Symbol Correctly
if (row.Cells[13].Text == "€")
{
table.Rows[pos].Cells[13].Text = "€";
}
if (canExporAll)
{
if (row.Cells[5].Text == "€")
{
table.Rows[pos].Cells[5].Text = "€";
}
if (row.Cells[7].Text == "€")
{
table.Rows[pos].Cells[7].Text = "€";
}
if (row.Cells[9].Text == "€")
{
table.Rows[pos].Cells[9].Text = "€";
}
if (row.Cells[11].Text == "€")
{
table.Rows[pos].Cells[11].Text = "€";
}
}
table.Rows[pos].Cells[3].Attributes.Add("class", "pF");
table.Rows[pos].Cells[3].Width = 110;
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response adding de style
HttpContext.Current.Response.Write(codeFormat + sw.ToString());
HttpContext.Current.Response.End();
}
protected void btn_export_Click(object sender, EventArgs e)
{
DataView view = new DataView();
view.Table = (DataTable)this.ViewState["listar"];
if (view.Count > 0)
{
GridView gv = new GridView();
gv.DataSource = view;
gv.DataBind();
string fileName = "Reporte_Ottawa.xls";
string Extension = ".xls";
if (Extension == ".xls")
{
PrepareControlForExport(gv);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.Cache.SetCacheability(System.Web.HttpCacheability.Public);
HttpContext.Current.Response.ContentType = "application/ms-excel";
try
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = gv.GridLines;
if (gv.HeaderRow != null)
{
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
table.Rows.Add(row);
}
if (gv.FooterRow != null)
{
PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
gv.GridLines = GridLines.Both;
table.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
catch (HttpException ex)
{
throw ex;
}
}
}
else
{
string texto = "Debe cargar datos antes de exportar!";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", string.Format("alert('{0}');", texto), true);
}
}
protected void btnExportar_Click(object sender, EventArgs e)
{
DataView view = new DataView();
view.Table = (DataTable)this.ViewState["lista"];
view.Table.Columns.Remove(view.Table.Columns["ID"]);
view.Table.Columns.Remove(view.Table.Columns["EXCLUYENTES"]);
view.Table.Columns.Remove(view.Table.Columns["NO_EXCLUYENTES"]);
view.Table.Columns.Remove(view.Table.Columns["CARACTERISTICAS"]);
view.Table.Columns.Remove(view.Table.Columns["COMU_ID"]);
view.Table.Columns.Remove(view.Table.Columns["REGI_ID"]);
GridView gv = new GridView();
gv.DataSource = view;
gv.DataBind();
string fileName = "Reporte_Locales.xls";
string Extension = ".xls";
if (Extension == ".xls")
{
PrepareControlForExport(gv);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.Cache.SetCacheability(System.Web.HttpCacheability.Public);
HttpContext.Current.Response.ContentType = "application/ms-excel";
try
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = gv.GridLines;
if (gv.HeaderRow != null)
{
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
table.Rows.Add(row);
}
if (gv.FooterRow != null)
{
PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
gv.GridLines = GridLines.Both;
table.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
catch (HttpException ex)
{
throw ex;
}
}
}
/// <summary>
/// Creates html table to hold passed in feature info, and stream back to client.
/// </summary>
/// <param name="ftr">feature object</param>
private void CreateInfoTable(Feature ftr)
{
//create a table control and populat it with the column name/value(s) from the feature returned and
// and the name of the layer where the feature belong
System.Web.UI.WebControls.Table infoTable = new System.Web.UI.WebControls.Table();
//set table attribute/styles
infoTable.CellPadding = 4;
infoTable.Font.Name = "Arial";
infoTable.Font.Size = new FontUnit(8);
infoTable.BorderWidth = 1;
//infoTable.BorderStyle = BorderStyle.Outset;
System.Drawing.Color backColor = Color.Bisque;
//add the first row, the layer name/value where the selected feature belongs
TableRow r = new TableRow();
r.BackColor = backColor;
TableCell c = new TableCell();
c.Font.Bold = true;
c.ForeColor = Color.Indigo;
c.Text = "Layer Name";
r.Cells.Add(c);
c = new TableCell();
//the feature returned is from a resultset table whose name is got from appending _2
//to the real table name, so below is to get the real table name.
string alias = ftr.Table.Alias;
c.Text = alias.Substring(0, alias.Length - 2);
c.Font.Bold = true;
r.Cells.Add(c);
infoTable.Rows.Add(r);
foreach (Column col in ftr.Columns)
{
String upAlias = col.Alias.ToUpper();
//don't display obj, MI_Key or MI_Style columns
if (upAlias != "OBJ" && upAlias != "MI_STYLE" && upAlias != "MI_KEY")
{
r = new TableRow();
r.BackColor = backColor;
r.Cells.Clear();
c = new TableCell();
c.Text = col.Alias;
c.Font.Bold = true;
c.ForeColor = Color.RoyalBlue;
r.Cells.Add(c);
c = new TableCell();
c.Text = ftr[col.Alias].ToString();
r.Cells.Add(c);
infoTable.Rows.Add(r);
}
}
//stream the html table back to client
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
infoTable.RenderControl(hw);
String strHTML = sw.ToString();
HttpContext.Current.Response.Output.Write(strHTML);
}
/// <summary>
/// Generates the pager links.
/// </summary>
/// <param name="writer">The writer.</param>
private void GeneratePagerLinks(HtmlTextWriter writer)
{
var mainTable = new Table { CssClass = "PagerTable" };
var mainTableRow = new TableRow();
mainTable.Rows.Add(mainTableRow);
var previousColumn = new TableCell { CssClass = "PagerFirstColumn" };
int iStart = this.CurrentPageIndex - 2;
int iEnd = this.CurrentPageIndex + 3;
if (iStart < 0)
{
iStart = 0;
}
if (iEnd > this.PageCount)
{
iEnd = this.PageCount;
}
var ulFirstElement = new HtmlGenericControl("ul");
ulFirstElement.Attributes.Add("class", "FilesPager");
// First Page
if (iStart > 0)
{
var liFirstElement = new HtmlGenericControl("li");
liFirstElement.Attributes.Add("class", "FirstPage");
var firstPageLink = new HyperLink
{
ID = "FirstPageLink",
ToolTip = string.Format("{0}{1}", Localization.GetString("GoTo.Text", this.RessourceFile, this.LanguageCode), Localization.GetString("FirstPage.Text", this.RessourceFile, this.LanguageCode)),
Text = string.Format("« {0}", Localization.GetString("FirstPage.Text", this.RessourceFile, this.LanguageCode)),
NavigateUrl =
this.Page.ClientScript.GetPostBackClientHyperlink(this, string.Format("Page_{0}", 0), false)
};
liFirstElement.Controls.Add(firstPageLink);
ulFirstElement.Controls.Add(liFirstElement);
}
// Previous Page
if (this.CurrentPageIndex > iStart)
{
var liPrevElement = new HtmlGenericControl("li");
liPrevElement.Attributes.Add("class", "PreviousPage");
var lastPrevLink = new HyperLink
{
ID = "PreviousPageLink",
ToolTip = string.Format("{0}{1}", Localization.GetString("GoTo.Text", this.RessourceFile, this.LanguageCode), Localization.GetString("PreviousPage.Text", this.RessourceFile, this.LanguageCode)),
Text = string.Format("< {0}", Localization.GetString("PreviousPage.Text", this.RessourceFile, this.LanguageCode)),
NavigateUrl =
this.Page.ClientScript.GetPostBackClientHyperlink(
this, string.Format("Page_{0}", this.CurrentPageIndex - 1), false)
};
liPrevElement.Controls.Add(lastPrevLink);
ulFirstElement.Controls.Add(liPrevElement);
}
// Add Column
previousColumn.Controls.Add(ulFirstElement);
mainTableRow.Cells.Add(previousColumn);
// Second Page Numbers Column
var ulSecondElement = new HtmlGenericControl("ul");
var pageNumbersColumn = new TableCell { CssClass = "PagerNumbersColumn", HorizontalAlign = HorizontalAlign.Center };
ulSecondElement.Attributes.Add("class", "FilesPager");
for (int i = iStart; i < iEnd; i++)
{
var liElement = new HtmlGenericControl("li");
liElement.Attributes.Add("class", i.Equals(this.CurrentPageIndex) ? "ActivePage" : "NormalPage");
var page = (i + 1).ToString();
var pageLink = new HyperLink
{
ID = string.Format("NextPageLink{0}", page),
ToolTip = string.Format("{0}: {1}", Localization.GetString("GoTo.Text", this.RessourceFile, this.LanguageCode), page),
Text = page,
NavigateUrl =
this.Page.ClientScript.GetPostBackClientHyperlink(this, string.Format("Page_{0}", i), false)
};
liElement.Controls.Add(pageLink);
ulSecondElement.Controls.Add(liElement);
}
// Add Column
pageNumbersColumn.Controls.Add(ulSecondElement);
mainTableRow.Cells.Add(pageNumbersColumn);
// Last Page Column
var ulThirdElement = new HtmlGenericControl("ul");
ulThirdElement.Attributes.Add("class", "FilesPager");
var lastColumn = new TableCell { CssClass = "PagerLastColumn" };
// Next Page
if (this.CurrentPageIndex < (this.PageCount - 1))
{
var liNextElement = new HtmlGenericControl("li");
liNextElement.Attributes.Add("class", "NextPage");
var lastNextLink = new HyperLink
{
ID = "NextPageLink",
ToolTip = string.Format("{0}{1}", Localization.GetString("GoTo.Text", this.RessourceFile, this.LanguageCode), Localization.GetString("NextPage.Text", this.RessourceFile, this.LanguageCode)),
Text = string.Format("{0} >", Localization.GetString("NextPage.Text", this.RessourceFile, this.LanguageCode)),
NavigateUrl =
this.Page.ClientScript.GetPostBackClientHyperlink(
this, string.Format("Page_{0}", (this.CurrentPageIndex + 2 - 1)), false)
};
liNextElement.Controls.Add(lastNextLink);
ulThirdElement.Controls.Add(liNextElement);
}
if (iEnd < this.PageCount)
{
var liLastElement = new HtmlGenericControl("li");
liLastElement.Attributes.Add("class", "LastPage");
var lastPageLink = new HyperLink
{
ID = "LastPageLink",
ToolTip =
string.Format(
"{0}{1}",
Localization.GetString("GoTo.Text", this.RessourceFile, this.LanguageCode),
Localization.GetString("LastPage.Text", this.RessourceFile, this.LanguageCode)),
Text =
string.Format(
"{0} »",
Localization.GetString("LastPage.Text", this.RessourceFile, this.LanguageCode)),
NavigateUrl =
this.Page.ClientScript.GetPostBackClientHyperlink(
this, string.Format("Page_{0}", (this.PageCount - 1)), false)
};
liLastElement.Controls.Add(lastPageLink);
ulThirdElement.Controls.Add(liLastElement);
}
// Add Column
lastColumn.Controls.Add(ulThirdElement);
mainTableRow.Cells.Add(lastColumn);
// Render Complete Control
mainTable.RenderControl(writer);
}
public static void ExportToExcel(string fileName, List<Listing> AdminList)
{
//The Clear method erases any buffered HTML output.
HttpContext.Current.Response.Clear();
//The AddHeader method adds a new HTML header and value to the response sent to the client.
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName + ".xls"));
//The ContentType property specifies the HTTP content type for the response.
HttpContext.Current.Response.ContentType = "application/ms-excel";
//Implements a TextWriter for writing information to a string. The information is stored in an underlying StringBuilder.
using (StringWriter sw = new StringWriter())
{
//Writes markup characters and text to an ASP.NET server control output stream. This class provides formatting capabilities that ASP.NET server controls use when rendering markup to clients.
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// Create a form to contain the List
Table table = new Table();
TableRow row = new TableRow();
foreach (PropertyInfo proinfo in new Listing().GetType().GetProperties())
{
TableHeaderCell hcell = new TableHeaderCell();
hcell.Text = proinfo.Name;
row.Cells.Add(hcell);
}
table.Rows.Add(row);
// add each of the data item to the table
foreach (Listing lst in AdminList)
{
TableRow row1 = new TableRow();
TableCell cellStaffID = new TableCell();
cellStaffID.Text = "" + lst.StaffID;
TableCell cellStaffName = new TableCell();
cellStaffName.Text = "" + lst.StaffName;
TableCell cellSuperName = new TableCell();
cellSuperName.Text = "" + lst.SupervisorName;
TableCell cellType = new TableCell();
cellType.Text = "" + lst.ApplicationType;
TableCell cellTitle = new TableCell();
cellTitle.Text = "" + lst.Title;
TableCell cellDate = new TableCell();
cellDate.Text = "" + lst.DateRequest;
TableCell cellStatus = new TableCell();
cellStatus.Text = "" + lst.Status;
TableCell cellSAP = new TableCell();
cellSAP.Text = "" + lst.PostedSAPStatus;
row1.Cells.Add(cellStaffID);
row1.Cells.Add(cellStaffName);
row1.Cells.Add(cellSuperName);
row1.Cells.Add(cellType);
row1.Cells.Add(cellTitle);
row1.Cells.Add(cellDate);
row1.Cells.Add(cellStatus);
row1.Cells.Add(cellSAP);
table.Rows.Add(row1);
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
}
}
/// <summary>
/// Creates html table to hold passed in feature info, and stream back to client.
/// </summary>
/// <param name="ftr">feature object</param>
private void CreateInfoTable(Feature ftr)
{
//create a table control and populat it with the column name/value(s) from the feature returned and
// and the name of the layer where the feature belong
System.Web.UI.WebControls.Table infoTable = new System.Web.UI.WebControls.Table();
//set table attribute/styles
infoTable.CellPadding = 4;
infoTable.Font.Name = "Arial";
infoTable.Font.Size = new FontUnit(8);
infoTable.BorderWidth = 1;
//infoTable.BorderStyle = BorderStyle.Outset;
System.Drawing.Color backColor = Color.Bisque;
//add the first row, the layer name/value where the selected feature belongs
TableRow r = new TableRow();
r.BackColor = backColor;
TableCell c = new TableCell();
c.Font.Bold = true;
c.ForeColor = Color.Indigo;
c.Text = "Layer Name";
r.Cells.Add(c);
c = new TableCell();
//the feature returned is from a resultset table whose name is got from appending _2
//to the real table name, so below is to get the real table name.
string alias = ftr.Table.Alias;
c.Text = alias.Substring(0, alias.Length-2);
c.Font.Bold = true;
r.Cells.Add(c);
infoTable.Rows.Add(r);
foreach(Column col in ftr.Columns)
{
String upAlias = col.Alias.ToUpper();
//don't display obj, MI_Key or MI_Style columns
if(upAlias != "OBJ" && upAlias != "MI_STYLE" && upAlias != "MI_KEY")
{
r = new TableRow();
r.BackColor = backColor;
r.Cells.Clear();
c = new TableCell();
c.Text = col.Alias;
c.Font.Bold = true;
c.ForeColor = Color.RoyalBlue;
r.Cells.Add(c);
c = new TableCell();
c.Text = ftr[col.Alias].ToString();
r.Cells.Add(c);
infoTable.Rows.Add(r);
}
}
//stream the html table back to client
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
infoTable.RenderControl(hw);
String strHTML = sw.ToString();
HttpContext.Current.Response.Output.Write(strHTML);
}
private void ExportExcel()
{
#region Declare
string keyword = txtKeyword.Value;
var obj = _ProjectData.GetListByYearOrder(Utils.CIntDef(ddlNam.SelectedValue), _Field, _Search);
double tongNoNam = 0;
double tongPhiDV1 = 0, tongPhiDV2 = 0, tongPhiDV3 = 0, tongPhiDV4 = 0, tongPhiDV5 = 0, tongPhiDV6 = 0,
tongPhiDV7 = 0, tongPhiDV8 = 0, tongPhiDV9 = 0, tongPhiDV10 = 0, tongPhiDV11 = 0, tongPhiDV12 = 0, tongPhiDV13 = 0;
double tongDaTT1 = 0, tongDaTT2 = 0, tongDaTT3 = 0, tongDaTT4 = 0, tongDaTT5 = 0, tongDaTT6 = 0,
tongDaTT7 = 0, tongDaTT8 = 0, tongDaTT9 = 0, tongDaTT10 = 0, tongDaTT11 = 0, tongDaTT12 = 0, tongDaTT13 = 0;
double tongConNo1 = 0, tongConNo2 = 0, tongConNo3 = 0, tongConNo4 = 0, tongConNo5 = 0, tongConNo6 = 0,
tongConNo7 = 0, tongConNo8 = 0, tongConNo9 = 0, tongConNo10 = 0, tongConNo11 = 0, tongConNo12 = 0, tongConNo13 = 0;
double tongNo = 0;
string name_ = "CongNoKeToan" + ddlNam.SelectedValue;
//Tạo bảng
Table tb = new Table();
//Định dạng bảng
tb.CellPadding = 4;
tb.GridLines = GridLines.Both;
tb.Font.Name = "Times New Roman";
TableCell cell;
TableRow row;
int header = 0;
#endregion
#region Header
row = new TableRow();
row.Font.Bold = true;
row.Font.Size = 18;
cell = new TableCell();
cell.Height = 40;
cell.Text = "DANH SÁCH TỔNG HỢP BCT NĂM " + ddlNam.SelectedValue;
cell.HorizontalAlign = HorizontalAlign.Center;
cell.ColumnSpan = 5;
row.Cells.Add(cell);
cell = new TableCell();
cell.ColumnSpan = 9;
row.Cells.Add(cell);
for (int t = 0; t < 12; t++)
{
cell = new TableCell();
cell.Text = "T" + (t + 1);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.ColumnSpan = 4;
row.Cells.Add(cell);
}
cell = new TableCell();
cell.Text = "BCTC";
cell.HorizontalAlign = HorizontalAlign.Center;
cell.ColumnSpan = 4;
row.Cells.Add(cell);
header++;
tb.Rows.Add(row);
#endregion
#region Title
row = new TableRow();
row.Font.Bold = true;
row.Font.Size = 12;
row.Style.Value = "vertical-align: middle";
List<InfoCells> _iHeader = new List<InfoCells>();
_iHeader.Add(new InfoCells { Header = "STT", Width = 45 });
_iHeader.Add(new InfoCells { Header = "Tình Trạng", Width = 100 });
_iHeader.Add(new InfoCells { Header = "Tên khách hàng", Width = 300 });
_iHeader.Add(new InfoCells { Header = "Quản lý thuế", Width = 120 });
_iHeader.Add(new InfoCells { Header = "MST", Width = 80 });
_iHeader.Add(new InfoCells { Header = "Địa chỉ", Width = 250 });
_iHeader.Add(new InfoCells { Header = "Giám đốc", Width = 120 });
_iHeader.Add(new InfoCells { Header = "Điện thoại liên lạc", Width = 120 });
_iHeader.Add(new InfoCells { Header = "Email", Width = 120 });
_iHeader.Add(new InfoCells { Header = "Phí", Width = 100 });
_iHeader.Add(new InfoCells { Header = "Tháng bắt đầu thu", Width = 100 });
_iHeader.Add(new InfoCells { Header = "NV Kế Toán", Width = 100 });
_iHeader.Add(new InfoCells { Header = "Năm " + (Utils.CIntDef(ddlNam.SelectedValue) - 1), Width = 100 });
//Từng tháng
for (int imonth = 0; imonth < 13; imonth++)
{
_iHeader.Add(new InfoCells { Header = "Phí dịch vụ", Width = 100 });
_iHeader.Add(new InfoCells { Header = "Đã thanh toán", Width = 100 });
_iHeader.Add(new InfoCells { Header = "Ngày TT", Width = 100 });
_iHeader.Add(new InfoCells { Header = "Còn nợ", Width = 100 });
}
_iHeader.Add(new InfoCells { Header = "TỔNG NỢ", Width = 100 });
_iHeader.Add(new InfoCells { Header = "NVKD", Width = 100 });
_iHeader.Add(new InfoCells { Header = "NV Giao Nhận", Width = 100 });
_iHeader.Add(new InfoCells { Header = "Ghi chú", Width = 200 });
int ktemp1 = 0;
int ktemp2 = 0;
for (int k = 0; k < _iHeader.Count; k++)
{
cell = new TableCell();
if (k < 12 || k > 65)
{
cell.BackColor = System.Drawing.Color.FromName("#99CCFF");
}
else if (k == 12)
{
cell.BackColor = System.Drawing.Color.FromName("#00CC00");
}
else if (k > 12 && 52 > (k - 13))
{
if (ktemp2 < 4)
{
if (ktemp1 % 2 == 0)
{
cell.BackColor = System.Drawing.Color.FromName("#FFFF00");
ktemp1 += 2;
ktemp2++;
}
else
{
cell.BackColor = System.Drawing.Color.FromName("#FF9900");
ktemp1 += 2;
ktemp2++;
}
}
else
{
ktemp1++;
ktemp2 = 0;
if (ktemp1 % 2 == 0)
{
cell.BackColor = System.Drawing.Color.FromName("#FFFF00");
ktemp1 += 2;
ktemp2++;
}
else
{
cell.BackColor = System.Drawing.Color.FromName("#FF9900");
ktemp1 += 2;
ktemp2++;
}
}
}
else
{
cell.BackColor = System.Drawing.Color.FromName("#DA8347");
}
cell.Height = 60;
cell.Width = _iHeader[k].Width;
cell.Text = _iHeader[k].Header;
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
}
header++;
tb.Rows.Add(row);
#endregion
for (int i = 0; i < obj.Count; i++)
{
#region Items
row = new TableRow();
row.Font.Size = 10;
row.Style.Value = "vertical-align: middle";
List<InfoCells> _items = new List<InfoCells>();
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].STT) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].TINH_TRANG) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].TEN_KH) });
_items.Add(new InfoCells { Field = getPropertyName(obj[i].QL_THUE_DIST) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].MST) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].DIA_CHI) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].GIAM_DOC) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].DIEN_THOAI) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].EMAIL) });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].THANG_BD_THU).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = GetUser(obj[i].NV_KT) });
tongNoNam += Utils.CDblDef(obj[i].NO_NAM_TRUOC);
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NO_NAM_TRUOC) });
tongPhiDV1 += Utils.CDblDef(obj[i].PHI_DV_1);
tongDaTT1 += Utils.CDblDef(obj[i].DA_TT1_1) + Utils.CDblDef(obj[i].DA_TT1_2) + Utils.CDblDef(obj[i].DA_TT1_3) + Utils.CDblDef(obj[i].DA_TT1_4);
tongConNo1 += Utils.CDblDef(obj[i].CON_NO_1);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_1) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT1_1) + Utils.CDblDef(obj[i].DA_TT1_2) + Utils.CDblDef(obj[i].DA_TT1_3) + Utils.CDblDef(obj[i].DA_TT1_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_1).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_1) });
tongPhiDV2 += Utils.CDblDef(obj[i].PHI_DV_2);
tongDaTT2 += Utils.CDblDef(obj[i].DA_TT2_1) + Utils.CDblDef(obj[i].DA_TT2_2) + Utils.CDblDef(obj[i].DA_TT2_3) + Utils.CDblDef(obj[i].DA_TT2_4);
tongConNo2 += Utils.CDblDef(obj[i].CON_NO_2);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_2) });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].DA_TT2_1 + obj[i].DA_TT2_2 + obj[i].DA_TT2_3 + obj[i].DA_TT2_4) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_2).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_2) });
tongPhiDV3 += Utils.CDblDef(obj[i].PHI_DV_3);
tongDaTT3 += Utils.CDblDef(obj[i].DA_TT3_1) + Utils.CDblDef(obj[i].DA_TT3_2) + Utils.CDblDef(obj[i].DA_TT3_3) + Utils.CDblDef(obj[i].DA_TT3_4);
tongConNo3 += Utils.CDblDef(obj[i].CON_NO_3);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_3) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT3_1) + Utils.CDblDef(obj[i].DA_TT3_2) + Utils.CDblDef(obj[i].DA_TT3_3) + Utils.CDblDef(obj[i].DA_TT3_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_3).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_3) });
tongPhiDV4 += Utils.CDblDef(obj[i].PHI_DV_4);
tongDaTT4 += Utils.CDblDef(obj[i].DA_TT4_1) + Utils.CDblDef(obj[i].DA_TT4_2) + Utils.CDblDef(obj[i].DA_TT4_3) + Utils.CDblDef(obj[i].DA_TT4_4);
tongConNo4 += Utils.CDblDef(obj[i].CON_NO_4);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_4) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT4_1) + Utils.CDblDef(obj[i].DA_TT4_2) + Utils.CDblDef(obj[i].DA_TT4_3) + Utils.CDblDef(obj[i].DA_TT4_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_4).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_4) });
tongPhiDV5 += Utils.CDblDef(obj[i].PHI_DV_5);
tongDaTT5 += Utils.CDblDef(obj[i].DA_TT5_1) + Utils.CDblDef(obj[i].DA_TT5_2) + Utils.CDblDef(obj[i].DA_TT5_3) + Utils.CDblDef(obj[i].DA_TT5_4);
tongConNo5 += Utils.CDblDef(obj[i].CON_NO_5);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_5) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT5_1) + Utils.CDblDef(obj[i].DA_TT5_2) + Utils.CDblDef(obj[i].DA_TT5_3) + Utils.CDblDef(obj[i].DA_TT5_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_5).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_5) });
tongPhiDV6 += Utils.CDblDef(obj[i].PHI_DV_6);
tongDaTT6 += Utils.CDblDef(obj[i].DA_TT6_1) + Utils.CDblDef(obj[i].DA_TT6_2) + Utils.CDblDef(obj[i].DA_TT6_3) + Utils.CDblDef(obj[i].DA_TT6_4);
tongConNo6 += Utils.CDblDef(obj[i].CON_NO_6);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_6) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT6_1) + Utils.CDblDef(obj[i].DA_TT6_2) + Utils.CDblDef(obj[i].DA_TT6_3) + Utils.CDblDef(obj[i].DA_TT6_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_6).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_6) });
tongPhiDV7 += Utils.CDblDef(obj[i].PHI_DV_7);
tongDaTT7 += Utils.CDblDef(obj[i].DA_TT7_1) + Utils.CDblDef(obj[i].DA_TT7_2) + Utils.CDblDef(obj[i].DA_TT7_3) + Utils.CDblDef(obj[i].DA_TT7_4);
tongConNo7 += Utils.CDblDef(obj[i].CON_NO_7);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_7) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT7_1) + Utils.CDblDef(obj[i].DA_TT7_2) + Utils.CDblDef(obj[i].DA_TT7_3) + Utils.CDblDef(obj[i].DA_TT7_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_7).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_7) });
tongPhiDV8 += Utils.CDblDef(obj[i].PHI_DV_8);
tongDaTT8 += Utils.CDblDef(obj[i].DA_TT8_1) + Utils.CDblDef(obj[i].DA_TT8_2) + Utils.CDblDef(obj[i].DA_TT8_3) + Utils.CDblDef(obj[i].DA_TT8_4);
tongConNo8 += Utils.CDblDef(obj[i].CON_NO_8);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_8) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT8_1) + Utils.CDblDef(obj[i].DA_TT8_2) + Utils.CDblDef(obj[i].DA_TT8_3) + Utils.CDblDef(obj[i].DA_TT8_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_8).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_8) });
tongPhiDV9 += Utils.CDblDef(obj[i].PHI_DV_9);
tongDaTT9 += Utils.CDblDef(obj[i].DA_TT9_1) + Utils.CDblDef(obj[i].DA_TT9_2) + Utils.CDblDef(obj[i].DA_TT9_3) + Utils.CDblDef(obj[i].DA_TT9_4);
tongConNo9 += Utils.CDblDef(obj[i].CON_NO_9);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_9) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT9_1) + Utils.CDblDef(obj[i].DA_TT9_2) + Utils.CDblDef(obj[i].DA_TT9_3) + Utils.CDblDef(obj[i].DA_TT9_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_9).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_9) });
tongPhiDV10 += Utils.CDblDef(obj[i].PHI_DV_10);
tongDaTT10 += Utils.CDblDef(obj[i].DA_TT10_1) + Utils.CDblDef(obj[i].DA_TT10_2) + Utils.CDblDef(obj[i].DA_TT10_3) + Utils.CDblDef(obj[i].DA_TT10_4);
tongConNo10 += Utils.CDblDef(obj[i].CON_NO_10);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_10) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT10_1) + Utils.CDblDef(obj[i].DA_TT10_2) + Utils.CDblDef(obj[i].DA_TT10_3) + Utils.CDblDef(obj[i].DA_TT10_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_10).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_10) });
tongPhiDV11 += Utils.CDblDef(obj[i].PHI_DV_11);
tongDaTT11 += Utils.CDblDef(obj[i].DA_TT11_1) + Utils.CDblDef(obj[i].DA_TT11_2) + Utils.CDblDef(obj[i].DA_TT11_3) + Utils.CDblDef(obj[i].DA_TT11_4);
tongConNo11 += Utils.CDblDef(obj[i].CON_NO_11);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_11) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT11_1) + Utils.CDblDef(obj[i].DA_TT11_2) + Utils.CDblDef(obj[i].DA_TT11_3) + Utils.CDblDef(obj[i].DA_TT11_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_11).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_11) });
tongPhiDV12 += Utils.CDblDef(obj[i].PHI_DV_12);
tongDaTT12 += Utils.CDblDef(obj[i].DA_TT12_1) + Utils.CDblDef(obj[i].DA_TT12_2) + Utils.CDblDef(obj[i].DA_TT12_3) + Utils.CDblDef(obj[i].DA_TT12_4);
tongConNo12 += Utils.CDblDef(obj[i].CON_NO_12);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_12) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT12_1) + Utils.CDblDef(obj[i].DA_TT12_2) + Utils.CDblDef(obj[i].DA_TT12_3) + Utils.CDblDef(obj[i].DA_TT12_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_12).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_12) });
tongPhiDV13 += Utils.CDblDef(obj[i].PHI_DV_BCTC);
tongDaTT13 += Utils.CDblDef(obj[i].DA_TT13_1) + Utils.CDblDef(obj[i].DA_TT13_2) + Utils.CDblDef(obj[i].DA_TT13_3) + Utils.CDblDef(obj[i].DA_TT13_4);
tongConNo13 += Utils.CDblDef(obj[i].CON_NO_BCTC);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].PHI_DV_BCTC) });
_items.Add(new InfoCells { Field = fun.Getprice(Utils.CDblDef(obj[i].DA_TT13_1) + Utils.CDblDef(obj[i].DA_TT13_2) + Utils.CDblDef(obj[i].DA_TT13_3) + Utils.CDblDef(obj[i].DA_TT13_4)) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].NGAY_TT_BCTC).Replace("12:00:00 AM", "").Trim() });
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].CON_NO_BCTC) });
tongNo += Utils.CDblDef(obj[i].TONG_NO);
_items.Add(new InfoCells { Field = fun.Getprice(obj[i].TONG_NO) });
_items.Add(new InfoCells { Field = GetUser(obj[i].NV_KD) });
_items.Add(new InfoCells { Field = GetUser(obj[i].NV_GN) });
_items.Add(new InfoCells { Field = Utils.CStrDef(obj[i].GHI_CHU) });
int jtemp1 = 0;
int jtemp2 = 0;
for (int j = 0; j < _items.Count; j++)
{
cell = new TableCell();
if (j < 12 || j > 65)
{
if (j == 0 || j == 3 || j == 4)
cell.Style.Value = "text-align: center";
cell.BackColor = System.Drawing.Color.FromName("#fff");
}
else if (j == 12)
cell.BackColor = System.Drawing.Color.FromName("#00CC00");
else if (j > 12 && 52 > (j - 13))
{
if (jtemp2 < 4)
{
if (jtemp1 % 2 == 0)
{
cell.BackColor = System.Drawing.Color.FromName("#FFFF00");
jtemp1 += 2;
jtemp2++;
}
else
{
cell.BackColor = System.Drawing.Color.FromName("#FF9900");
jtemp1 += 2;
jtemp2++;
}
}
else
{
jtemp1++;
jtemp2 = 0;
if (jtemp1 % 2 == 0)
{
cell.BackColor = System.Drawing.Color.FromName("#FFFF00");
jtemp1 += 2;
jtemp2++;
}
else
{
cell.BackColor = System.Drawing.Color.FromName("#FF9900");
jtemp1 += 2;
jtemp2++;
}
}
}
else
{
cell.BackColor = System.Drawing.Color.FromName("#DA8347");
}
cell.Text = _items[j].Field;
row.Cells.Add(cell);
}
tb.Rows.Add(row);
#endregion
}
#region Footer
row = new TableRow();
row.BackColor = System.Drawing.Color.FromName("#C79393");
row.Font.Size = 10;
row.Style.Value = "vertical-align: middle";
row.Font.Bold = true;
cell = new TableCell();
cell.Height = 40;
cell.Text = "Tổng cộng doanh thu DV hàng tháng";
cell.HorizontalAlign = HorizontalAlign.Center;
cell.ColumnSpan = 5;
row.Cells.Add(cell);
cell = new TableCell();
cell.ColumnSpan = 7;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongNoNam);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV1);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT1);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo1);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV2);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT2);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo2);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV3);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT3);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo3);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV4);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT4);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo4);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV5);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT5);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo5);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV6);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT6);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo6);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV7);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT7);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo7);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV8);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT8);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo8);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV9);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT9);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo9);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV10);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT10);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo10);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV11);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT11);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo11);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV12);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT12);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo12);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongPhiDV13);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongDaTT13);
row.Cells.Add(cell);
cell = new TableCell();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongConNo13);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = fun.Getprice(tongNo);
row.Cells.Add(cell);
tb.Rows.Add(row);
#endregion
#region Process
Response.Clear();
Response.Buffer = true;
string ex_ = "xls";
Response.AddHeader("Content-Disposition", "attachment; filename=" + name_ + "." + ex_);
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "UTF-8";
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter ht = new System.Web.UI.HtmlTextWriter(sw);
ht.WriteLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");
tb.RenderControl(ht);
Response.Write(sw.ToString());
Response.End();
#endregion
}
private void RenderWeekTable(List<TaskData> lstTasks)
{
Table tblInfoCallender = new Table();
string[] dayLabels = EnumDay.getDaysOfTheWeek();
TableRow tableHRow = new TableRow();
for (int iCell = 0; iCell < 8; iCell++)
{
TableCell tableCell = new TableCell();
if(iCell>0){
Label label = new Label();
label.Text = dayLabels[iCell-1];
tableCell.Controls.Add(label);
}
tableHRow.Cells.Add(tableCell);
}
tblInfoCallender.Rows.Add(tableHRow);
//Make the rows
for (int iRow = 0; iRow < 24; iRow++)
{
TableRow tableRow = new TableRow();
for(int iCell=0; iCell < 8; iCell++){
TableCell tableCell = new TableCell();
if (iCell == 0)
{
Label lblHour = new Label();
lblHour.Text = iRow + ":00";
tableCell.Controls.Add(lblHour);
tableCell.CssClass = "hour";
}
else
{
Label lblId = new Label();
lblId.ID = "lblId" + iRow.ToString() + iCell.ToString();
lblId.Text = "";
tableCell.Controls.Add(lblId);
tableCell.CssClass = "calendarCell";
}
tableRow.Cells.Add(tableCell);
}
tblInfoCallender.Rows.Add(tableRow);
}
DateTime now = DateTime.Now;
for(int i=0;i<lstTasks.Count;i++){
TaskData data = lstTasks[i];
//Check the day
TableCell tableCell = null;
switch (data.Repeat)
{
case (int)EnumSchedule.Task.Once:
tableCell = tblInfoCallender.Rows[data.Date.Hour+1].Cells[(int)data.Date.DayOfWeek];
tableCell.BackColor = (Color)System.Drawing.ColorTranslator.FromHtml("#d41926");
createTaskImageButton(tableCell, data,i);
//RenderInfoCell(tableCell, data);
break;
case (int)EnumSchedule.Task.Dailey:
for (int iDayOfWeek = 1; iDayOfWeek < 8; iDayOfWeek++)
{
tableCell = tblInfoCallender.Rows[data.Date.Hour + 1].Cells[iDayOfWeek];
tableCell.BackColor = (Color)System.Drawing.ColorTranslator.FromHtml("#a19f9f");
createTaskImageButton(tableCell, data, i + 100 + iDayOfWeek);
//RenderInfoCell(tableCell, data);
}
break;
case (int)EnumSchedule.Task.Weekley:
tableCell = tblInfoCallender.Rows[data.Date.Hour+1].Cells[(int)data.RepeatDayOftheWeek+1];
tableCell.BackColor = (Color)System.Drawing.ColorTranslator.FromHtml("#a19f9f");
createTaskImageButton(tableCell, data,i);
//RenderInfoCell(tableCell, data);
break;
case (int)EnumSchedule.Task.Monthly:
DateTime monthTime = new DateTime(now.Year,now.Month,(int)data.RepeatDay);
tableCell = tblInfoCallender.Rows[data.Date.Hour + 1].Cells[(int)monthTime.DayOfWeek + 1];
tableCell.BackColor = (Color)System.Drawing.ColorTranslator.FromHtml("#a19f9f");
createTaskImageButton(tableCell, data,i);
//RenderInfoCell(tableCell, data);
break;
case (int)EnumSchedule.Task.Annually:
DateTime yearTime = new DateTime(now.Year, (int)data.RepeatMonth, (int)data.RepeatDay);
tableCell = tblInfoCallender.Rows[data.Date.Hour + 1].Cells[(int)yearTime.DayOfWeek + 1];
tableCell.BackColor = (Color)System.Drawing.ColorTranslator.FromHtml("#a19f9f");
createTaskImageButton(tableCell, data,i);
//RenderInfoCell(tableCell,data);
break;
}
}
TextWriter textWriter = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(textWriter);
tblInfoCallender.RenderControl(htmlTextWriter);
containerCalendar.InnerHtml = textWriter.ToString();
}
protected void ExportWord(GridView gridView)
{
HttpContext.Current.Response.Clear();
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
curContext.Response.AddHeader("content-disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode("StaffAppraisal.doc"));
HttpContext.Current.Response.ContentType = "application/ms-word";
// Create a table to contain the grid
Table table = new Table();
// include the gridline settings
table.GridLines = gridView.GridLines;
// add the header row to the table
if (gridView.HeaderRow != null)
{
PrepareControlForExport(gridView.HeaderRow);
gridView.HeaderRow.Style.Add("background", "black");
table.Rows.Add(gridView.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gridView.Rows)
{
PrepareControlForExport(row);
table.Rows.Add(row);
}
// add the footer row to the table
if (gridView.FooterRow != null)
{
PrepareControlForExport(gridView.FooterRow);
table.Rows.Add(gridView.FooterRow);
}
for (int i = 0; i <= gridView.Rows.Count; i++)
{
table.Rows[i].Cells[0].Visible = false;
}
using (StringWriter stringWriter = new StringWriter())
{
using (HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter))
{
// render the table into the htmlwriter
table.RenderControl(htmlWriter);
// render the htmlwriter into the response
curContext.Response.Write(stringWriter.ToString());
curContext.Response.End();
}
}
}
private void RenderTable(HttpContext context, Table table)
{
StringWriter writer1 = new StringWriter();
HtmlTextWriter writer2 = new HtmlTextWriter(writer1);
table.RenderControl(writer2);
context.Response.Write("<div class='tableDetail'>");
context.Response.Write(writer1.ToString());
context.Response.Write("</div>");
}
protected override void Render(HtmlTextWriter w)
{
EnsureChildControls();
Table t = new Table();
t.BorderWidth = 0;
t.CellPadding = 0;
t.CellSpacing = 0;
TableRow r = null;
TableCell c = null;
r = new TableRow();
c = new TableCell();
c.Controls.Add(img);
r.Cells.Add(c);
t.Rows.Add(r);
r = new TableRow();
c = new TableCell();
c.Controls.Add(lnk);
r.Cells.Add(c);
t.Rows.Add(r);
t.RenderControl(w);
}
private void RenderErrors(HtmlTextWriter writer)
{
Debug.Assert(writer != null);
//
// Create a table to display error information in each row.
//
Table table = new Table();
table.ID = "ErrorLog";
table.CellSpacing = 0;
//
// Create the table row for headings.
//
TableRow headRow = new TableRow();
headRow.Cells.Add(FormatCell(new TableHeaderCell(), "Host", "host-col"));
headRow.Cells.Add(FormatCell(new TableHeaderCell(), "Code", "code-col"));
headRow.Cells.Add(FormatCell(new TableHeaderCell(), "Type", "type-col"));
headRow.Cells.Add(FormatCell(new TableHeaderCell(), "Error", "error-col"));
headRow.Cells.Add(FormatCell(new TableHeaderCell(), "User", "user-col"));
headRow.Cells.Add(FormatCell(new TableHeaderCell(), "Date", "date-col"));
headRow.Cells.Add(FormatCell(new TableHeaderCell(), "Time", "time-col"));
table.Rows.Add(headRow);
//
// Generate a table body row for each error.
//
for (int errorIndex = 0; errorIndex < _errorEntryList.Count; errorIndex++)
{
ErrorLogEntry errorEntry = (ErrorLogEntry) _errorEntryList[errorIndex];
Error error = errorEntry.Error;
TableRow bodyRow = new TableRow();
bodyRow.CssClass = errorIndex % 2 == 0 ? "even-row" : "odd-row";
//
// Format host and status code cells.
//
bodyRow.Cells.Add(FormatCell(new TableCell(), error.HostName, "host-col"));
bodyRow.Cells.Add(FormatCell(new TableCell(), error.StatusCode.ToString(), "code-col", Mask.NullString(HttpWorkerRequest.GetStatusDescription(error.StatusCode))));
bodyRow.Cells.Add(FormatCell(new TableCell(), ErrorDisplay.HumaneExceptionErrorType(error), "type-col", error.Type));
//
// Format the message cell, which contains the message
// text and a details link pointing to the page where
// all error details can be viewed.
//
TableCell messageCell = new TableCell();
messageCell.CssClass = "error-col";
Label messageLabel = new Label();
messageLabel.Text = this.Server.HtmlEncode(error.Message);
HyperLink detailsLink = new HyperLink();
detailsLink.NavigateUrl = BasePageName + "/detail?id=" + HttpUtility.UrlEncode(errorEntry.Id);
detailsLink.Text = "Details…";
messageCell.Controls.Add(messageLabel);
messageCell.Controls.Add(new LiteralControl(" "));
messageCell.Controls.Add(detailsLink);
bodyRow.Cells.Add(messageCell);
//
// Format the user, date and time cells.
//
bodyRow.Cells.Add(FormatCell(new TableCell(), error.User, "user-col"));
bodyRow.Cells.Add(FormatCell(new TableCell(), error.Time.ToShortDateString(), "date-col",
error.Time.ToLongDateString()));
bodyRow.Cells.Add(FormatCell(new TableCell(), error.Time.ToShortTimeString(), "time-col",
error.Time.ToLongTimeString()));
//
// Finally, add the row to the table.
//
table.Rows.Add(bodyRow);
}
table.RenderControl(writer);
}
public void ExportToExcel(AlertPurchaseOrderType?type, string provider, string product, string purchaseOrder, DateTime?fromDate, DateTime?untilDate, bool?license, string column, string order, WayOfDelivery?wayOfDelivery)
{
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-us");// Thread.CurrentThread.CurrentUICulture;
GridView grdProductList = new GridView();
grdProductList.AutoGenerateColumns = false;
#region Columns
BoundField bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "PurchaseOrderCode";
bf.HeaderText = "OC";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "PurchaseOrderProviderCode";
bf.HeaderText = "Código de Proveedor";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "ProductCode";
bf.HeaderText = "Producto";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "ProductDescription";
bf.HeaderText = "Descripción";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "Quantity";
bf.HeaderText = "Cantidad";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "ArrivalDate";
bf.HeaderText = "Confirmación";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:dd/MM/yyyy}";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "PurchaseOrderDate";
bf.HeaderText = "Creada";
bf.HtmlEncode = false;
bf.DataFormatString = "{0:dd/MM/yyyy}";
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "GAP";
bf.HeaderText = "GAP";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "WayOfDelivery";
bf.HeaderText = "Modo Envío";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "Type";
bf.HeaderText = "Status";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
#endregion
grdProductList.DataSource = Search(type, provider, product, purchaseOrder, fromDate, untilDate, license, column, order, wayOfDelivery);
grdProductList.DataBind();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename=SeguimientoOC.xls"));
HttpContext.Current.Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = grdProductList.GridLines;
//Set the Cell format
string codeFormat = @"<style>.cF { mso-number-format:'\@'; }</style>";
// add the header row to the table
if (grdProductList.HeaderRow != null)
{
PrepareControlForExport(grdProductList.HeaderRow);
table.Rows.Add(grdProductList.HeaderRow);
table.Rows[0].ForeColor = Color.FromArgb(102, 102, 102);
for (int i = 0; i < table.Rows[0].Cells.Count; i++)
{
table.Rows[0].Cells[i].BackColor = Color.FromArgb(225, 224, 224);
}
}
// add each of the data rows to the table
foreach (GridViewRow row in grdProductList.Rows)
{
PrepareControlForExport(row);
int pos = table.Rows.Add(row);
table.Rows[pos].Cells[1].Attributes.Add("class", "cF");
table.Rows[pos].Cells[2].Attributes.Add("class", "cF");
table.Rows[pos].Cells[3].Width = 300;
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response adding de style
HttpContext.Current.Response.Write(codeFormat + sw.ToString());
HttpContext.Current.Response.End();
}
public void ExportToExcel(string column, string order, int type)
{
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-us");// Thread.CurrentThread.CurrentUICulture;
GridView grdProductList = new GridView();
grdProductList.AutoGenerateColumns = false;
#region Columns
BoundField bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "ProductCode";
bf.HeaderText = "Producto";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
if (type == 1)
{
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "StandardCost";
bf.HeaderText = "Costo Standard";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(295);
bf.DataField = "Subtotal";
bf.HeaderText = "SubTotal";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
}
else
{
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "NegativeDate";
bf.HeaderText = "Fecha de Quiebre";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
}
bf = new BoundField();
bf.ItemStyle.Width = Unit.Pixel(95);
bf.DataField = "Quantity";
bf.HeaderText = "Cantidad";
bf.HtmlEncode = false;
grdProductList.Columns.Add(bf);
#endregion
if (!string.IsNullOrEmpty(column))
{
grdProductList.DataSource = ShowAlert(column, order, type);
}
else
{
if (type == 1)
{
grdProductList.DataSource = ShowAlert3();
}
else
{
grdProductList.DataSource = ShowAlert5();
}
}
grdProductList.DataBind();
HttpContext.Current.Response.Clear();
if (type == 1)
{
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename=ProductosConStockNegativo.xls"));
}
else
{
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename=StockQueCaeraDelSafety.xls"));
}
HttpContext.Current.Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = grdProductList.GridLines;
//Set the Cell format
string codeFormat = @"<style>.cF { mso-number-format:'\@'; }</style>";
// add the header row to the table
if (grdProductList.HeaderRow != null)
{
PrepareControlForExport(grdProductList.HeaderRow);
table.Rows.Add(grdProductList.HeaderRow);
table.Rows[0].ForeColor = Color.FromArgb(102, 102, 102);
for (int i = 0; i < table.Rows[0].Cells.Count; i++)
{
table.Rows[0].Cells[i].BackColor = Color.FromArgb(225, 224, 224);
}
}
// add each of the data rows to the table
foreach (GridViewRow row in grdProductList.Rows)
{
PrepareControlForExport(row);
int pos = table.Rows.Add(row);
table.Rows[pos].Cells[0].Attributes.Add("class", "cF");
if (type == 1)
{
table.Rows[pos].Cells[1].Text = "$ " + table.Rows[pos].Cells[1].Text;
table.Rows[pos].Cells[2].Text = "$ " + table.Rows[pos].Cells[2].Text;
table.Rows[pos].Cells[1].HorizontalAlign = HorizontalAlign.Left;
table.Rows[pos].Cells[2].HorizontalAlign = HorizontalAlign.Left;
table.Rows[pos].Cells[3].HorizontalAlign = HorizontalAlign.Left;
}
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response adding de style
HttpContext.Current.Response.Write(codeFormat + sw.ToString());
HttpContext.Current.Response.End();
}
protected void generar(Object Sender, EventArgs e)
{
string [] pr = new string[2];
pr[0] = pr[1] = "";
Press frontEnd = new Press(new DataSet(), reportTitle);
frontEnd.PreHeader(tabPreHeader, Grid.Width, pr);
frontEnd.Firmas(tabFirmas, Grid.Width);
lb.Text = "";
//////////////FECHA////////////
int Año1 = Convert.ToInt32(añoI.SelectedValue.ToString());
int Año2 = Convert.ToInt32(añoF.SelectedValue.ToString());
int Mes1 = Convert.ToInt32(DBFunctions.SingleData("select PMES_MES from DBXSCHEMA.PMES WHERE PMES_NOMBRE='" + mesI.SelectedValue.ToString() + "'"));
int Mes2 = Convert.ToInt32(DBFunctions.SingleData("select PMES_MES from DBXSCHEMA.PMES WHERE PMES_NOMBRE='" + mesF.SelectedValue.ToString() + "'"));
int dia1 = 1;
int dia2 = 1;
string dia1S = diaI.Text;
string dia2S = diaF.Text;
if (dia1S.ToString().Equals(null) || dia1S.ToString().Equals("0"))
{
dia1 = 1;
}
else
{
dia1 = Convert.ToInt32(diaI.Text.ToString());
}
if (dia2S.ToString().Equals(null) || dia2S.ToString().Equals("0"))
{
dia2 = Convert.ToInt32(DateTime.Now.Day);
}
else
{
dia2 = Convert.ToInt32(diaF.Text.ToString());
}
string fecha = Año1 + "-" + Mes1 + "-" + dia1;
string fecha2 = Año2 + "-" + Mes2 + "-" + dia2;
///////////////////////////////
/////opciones de estado comparendo
if (pago.Checked.Equals(true))
{
queryEstado = "AND MCOM_ESTADO =1";
}
if (nopago.Checked.Equals(true))
{
queryEstado = "AND MCOM_ESTADO =3";
}
if (proceso.Checked.Equals(true))
{
queryEstado = "AND MCOM_ESTADO =2";
}
if (todos.Checked.Equals(true))
{
queryEstado = " ";
}
//////////////////////////////////////////////////
////seleccion conductor
conductoresS = conductor.SelectedValue.ToString();
if (conductoresS.Equals("0"))
{
queryF = "select MCOM_FECHACOM,MCOM_INFRACCION,MCOM_CONDUCTOR,MCOM_ESTADO,MCOM_NUMCOM FROM DBXSCHEMA.MCOMPARENDOS WHERE MCOM_FECHACOM BETWEEN '" + fecha + "' AND '" + fecha2 + "' " + queryEstado + " ";
}
else
{
string nit = DBFunctions.SingleData("select MNIT.MNIT_NIT FROM DBXSCHEMA.MNIT MNIT WHERE MNIT.MNIT_NOMBRES CONCAT ' ' CONCAT coalesce(MNIT.MNIT_NOMBRE2,'') CONCAT ' ' CONCAT MNIT.MNIT_APELLIDOS CONCAT ' 'CONCAT coalesce(MNIT.MNIT_APELLIDO2,'') ='" + conductoresS + "' ");
queryF = "select MCOM_FECHACOM,MCOM_INFRACCION,MCOM_CONDUCTOR,MCOM_ESTADO,MCOM_NUMCOM FROM DBXSCHEMA.MCOMPARENDOS WHERE MCOM_FECHACOM BETWEEN '" + fecha + "' AND '" + fecha2 + "' " + queryEstado + " AND MCOM_CONDUCTOR='" + nit + "' ";
}
///////////////////////////////////////////////////////
this.PrepararTabla();
lineas = new DataSet();
DBFunctions.Request(lineas, IncludeSchema.NO, " " + queryF + " ");
for (int i = 0; i < lineas.Tables[0].Rows.Count; i++)
{
string infraccion = null;
int codigoinfraccion = 0;
double valorcomparendo = 0;
codigoinfraccion = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[1].ToString());
infraccion = DBFunctions.SingleData("Select DESC_COMPARENDO from DBXSCHEMA.TCOMPARENDO WHERE COD_COMPARENDO=" + codigoinfraccion + " ");
valorcomparendo = Convert.ToDouble(DBFunctions.SingleData("Select VALO_COMPARENDO from DBXSCHEMA.TCOMPARENDO WHERE COD_COMPARENDO=" + codigoinfraccion + " "));
string estadoIn = null;
int estadoInfraccion = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[3].ToString());
estadoIn = DBFunctions.SingleData("Select DESC_ESTACOMPA from DBXSCHEMA.TESTADO_COMPARENDO WHERE COD_ESTACOMPA=" + estadoInfraccion + " ");
string nombreco = DBFunctions.SingleData("select MNIT.MNIT_NOMBRES CONCAT ' ' CONCAT coalesce(MNIT.MNIT_NOMBRE2,'') CONCAT ' ' CONCAT MNIT.MNIT_APELLIDOS CONCAT ' 'CONCAT coalesce(MNIT.MNIT_APELLIDO2,'') AS NOMBRE FROM DBXSCHEMA.MNIT MNIT WHERE MNIT.MNIT_NIT='" + lineas.Tables[0].Rows[i].ItemArray[2].ToString() + "' ");
//Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores
DataRow fila;
fila = resultado.NewRow();
string ValorFormato = null;
ValorFormato = String.Format("{0:C}", valorcomparendo);
fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString();
fila["NUMCOMPARENDO"] = lineas.Tables[0].Rows[i].ItemArray[4].ToString();
fila["INFRACCION"] = infraccion.ToString();
fila["VALOR"] = ValorFormato.ToString();
fila["CONDUCTOR"] = nombreco.ToString();
fila["ESTADO"] = estadoIn.ToString();
resultado.Rows.Add(fila);
}
//fin sentencia FOR
Grid.DataSource = resultado;
Grid.DataBind();
StringBuilder SB = new StringBuilder();
StringWriter SW = new StringWriter(SB);
HtmlTextWriter htmlTW = new HtmlTextWriter(SW);
tabPreHeader.RenderControl(htmlTW);
Grid.RenderControl(htmlTW);
tabFirmas.RenderControl(htmlTW);
string strRep;
strRep = SB.ToString();
Session.Clear();
Session["Rep"] = strRep;
toolsHolder.Visible = true;
}
protected void generar(Object Sender, EventArgs e)
{
string [] pr = new string[2];
pr[0] = pr[1] = "";
Press frontEnd = new Press(new DataSet(), reportTitle);
frontEnd.PreHeader(tabPreHeader, Grid.Width, pr);
frontEnd.Firmas(tabFirmas, Grid.Width);
lb.Text = "";
///////////////////////////////////////////////////////
this.PrepararTabla();
lineas = new DataSet();
string fecha = Convert.ToDateTime(FechaInicio.Text).ToString("yyyy-MM-dd");
string fecha1 = Convert.ToDateTime(FechaFinal.Text).ToString("yyyy-MM-dd");
try
{
DBFunctions.Request(lineas, IncludeSchema.NO, "select distinct mbus.mbus_numero as NUMEROBUS,drut.mcat_placa as PLACA,tciu.tciu_nombre as CIUDADORIGEN,tciu1.tciu_nombre as CIUDADDESTINO,mrut.mrut_valor as VALOR,drut.drut_horasal as HORASALIDA,drut.drut_fecha as FECHA,drut.drut_codigo as CODIGORUTA,drut.drut_planilla as NUMEROPLANILLA,drut.drut_codrelevante as RELEVANTE from dbxschema.druta drut,dbxschema.druta drut1,dbxschema.dtiquete dtiq,dbxschema.mruta mrut, dbxschema.tciudad tciu,dbxschema.tciudad tciu1,dbxschema.tciudad tciu2,dbxschema.mbusafiliado mbus where drut.drut_fecha between '" + fecha + "' and '" + fecha1 + "' and drut.drut_codigo=drut.drut_codigo and drut.mrut_codigo=mrut.mrut_codigo and mrut.tciu_cod=tciu.tciu_codigo and mrut.tciu_coddes=tciu1.tciu_codigo and mbus.mcat_placa=drut.mcat_placa and tciu.tciu_nombre=(select tciu.TCIU_nombre from dbxschema.MOFICINA mofi,dbxschema.tciudad tciu where mofi_codigo='" + ddlagencia.SelectedValue + "'and tciu.tciu_codigo=mofi.tciu_codigo)order by drut.drut_fecha,tciu1.tciu_nombre");
}
catch (Exception t)
{
Response.Write("<script language:javascript>alert('No se Encuentra Ningun Reporte De esta Bus'); </script>" + t.Message);
}
for (int i = 0; i < lineas.Tables[0].Rows.Count; i++)
{
//Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores
string lineas1 = DBFunctions.SingleData("Select count (*) from DBXSCHEMA.DTIQUETE where drut_codigo=" + lineas.Tables[0].Rows[i][7].ToString() + "");
string lineas2 = DBFunctions.SingleData("Select count(*)from dbxschema.dtiquete where drut_codigo=" + lineas.Tables[0].Rows[i].ItemArray[7].ToString() + " and test_codigo='RS'");
int puestosre = 0;
int puestos = 0;
if (lineas2.Length == 0)
{
puestosre = 0;
puestos = Convert.ToInt32(lineas1);
}
else
{
puestos = Convert.ToInt32(lineas1);
puestosre = Convert.ToInt32(lineas2);
}
string capacidad = DBFunctions.SingleData("SELECT pcat.pcat_capacidad FROM dbxschema.pcatalogovehiculo pcat,dbxschema.druta druta,dbxschema.mruta mruta,dbxschema.mbusafiliado mbus,dbxschema.mcatalogovehiculo mcat WHERE druta.drut_codigo=" + lineas.Tables[0].Rows[i][7].ToString() + " and druta.mrut_codigo=mruta.mrut_codigo and druta.mcat_placa=mbus.mcat_placa and mbus.mcat_placa=mcat.mcat_placa and pcat.pcat_codigo=mcat.pcat_codigo");
string disponibilidad = ((System.Convert.ToInt32(capacidad)) - (System.Convert.ToInt32(DBFunctions.SingleData("SELECT COUNT(*) FROM dpuestoruta WHERE drut_codigo=" + lineas.Tables[0].Rows[i][7].ToString() + " AND (test_codigo<>'LI')").Trim()))).ToString();
DataRow fila;
fila = resultado.NewRow();
fila["NUMERO BUS"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString();
fila["PLACA"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString();
fila["ORIGEN"] = lineas.Tables[0].Rows[i].ItemArray[2].ToString();
fila["DESTINO"] = lineas.Tables[0].Rows[i].ItemArray[3].ToString();
fila["VALOR"] = lineas.Tables[0].Rows[i].ItemArray[4].ToString();
fila["HORA SALIDA"] = lineas.Tables[0].Rows[i].ItemArray[5].ToString();
fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[6].ToString();
fila["CODIGO RUTA"] = lineas.Tables[0].Rows[i].ItemArray[7].ToString();
fila["NUMERO PLANILLA"] = lineas.Tables[0].Rows[i].ItemArray[8].ToString();
fila["RELEVANTE"] = lineas.Tables[0].Rows[i].ItemArray[9].ToString();
fila["NUMERO DE PASAJEROS"] = puestos - puestosre;
fila["DISPONIBLES"] = disponibilidad;
fila["TOTAL"] = puestos * Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[4]);
resultado.Rows.Add(fila);
}
//fin sentencia FOR
Grid.DataSource = resultado;
Grid.DataBind();
StringBuilder SB = new StringBuilder();
StringWriter SW = new StringWriter(SB);
HtmlTextWriter htmlTW = new HtmlTextWriter(SW);
tabPreHeader.RenderControl(htmlTW);
Grid.RenderControl(htmlTW);
tabFirmas.RenderControl(htmlTW);
string strRep;
strRep = SB.ToString();
Session.Clear();
Session["Rep"] = strRep;
toolsHolder.Visible = true;
}
public override string GetDesignTimeHtml()
{
StringWriter sw = new StringWriter();
HtmlTextWriter writer = new HtmlTextWriter(sw);
Table menu = new Table();
menu.CellSpacing = menuInstance.ItemSpacing;
menu.CellPadding = menuInstance.ItemPadding;
// Display the Menu based on its specified Layout
if (menuInstance.Layout == MenuLayout.Vertical)
{
for (int i = 1; i <= 5; i++)
{
TableRow tr = new TableRow();
TableCell td = new TableCell();
td.ApplyStyle(menuInstance.UnselectedMenuItemStyle);
// The style is overwritten by anything specifically set in menuitem
if (menuInstance.BackColor != Color.Empty)
td.BackColor = menuInstance.BackColor;
if (menuInstance.Font != null)
td.Font.CopyFrom(menuInstance.Font);
if (menuInstance.ForeColor != Color.Empty)
td.ForeColor = menuInstance.ForeColor;
if (menuInstance.Height != Unit.Empty)
td.Height = menuInstance.Height;
if (menuInstance.Width != Unit.Empty)
td.Width = menuInstance.Width;
if (menuInstance.CssClass != String.Empty)
td.CssClass = menuInstance.CssClass;
else if (menuInstance.DefaultCssClass != String.Empty)
td.CssClass = menuInstance.DefaultCssClass;
if (menuInstance.BorderColor != Color.Empty)
td.BorderColor = menuInstance.BorderColor;
if (menuInstance.BorderStyle != BorderStyle.NotSet)
td.BorderStyle = menuInstance.BorderStyle;
if (menuInstance.BorderWidth != Unit.Empty)
td.BorderWidth = menuInstance.BorderWidth;
td.Text = "Menu Item " + i.ToString();
tr.Cells.Add(td);
menu.Rows.Add(tr);
}
}
else
{
TableRow tr = new TableRow();
for (int i = 1; i <= 5; i++)
{
TableCell td = new TableCell();
td.ApplyStyle(menuInstance.UnselectedMenuItemStyle);
// The style is overwritten by anything specifically set in menuitem
if (menuInstance.BackColor != Color.Empty)
td.BackColor = menuInstance.BackColor;
if (menuInstance.Font != null)
td.Font.CopyFrom(menuInstance.Font);
if (menuInstance.ForeColor != Color.Empty)
td.ForeColor = menuInstance.ForeColor;
if (menuInstance.Height != Unit.Empty)
td.Height = menuInstance.Height;
if (menuInstance.Width != Unit.Empty)
td.Width = menuInstance.Width;
if (menuInstance.CssClass != String.Empty)
td.CssClass = menuInstance.CssClass;
else if (menuInstance.DefaultCssClass != String.Empty)
td.CssClass = menuInstance.DefaultCssClass;
if (menuInstance.BorderColor != Color.Empty)
td.BorderColor = menuInstance.BorderColor;
if (menuInstance.BorderStyle != BorderStyle.NotSet)
td.BorderStyle = menuInstance.BorderStyle;
if (menuInstance.BorderWidth != Unit.Empty)
td.BorderWidth = menuInstance.BorderWidth;
td.Text = "Menu Item " + i.ToString();
tr.Cells.Add(td);
}
menu.Rows.Add(tr);
}
menu.RenderControl(writer);
return sw.ToString();
}
private void RenderCollection(HtmlTextWriter writer,
NameValueCollection collection, string id, string title)
{
Debug.Assert(writer != null);
Debug.AssertStringNotEmpty(id);
Debug.AssertStringNotEmpty(title);
//
// If the collection isn't there or it's empty, then bail out.
//
if (collection == null || collection.Count == 0)
return;
//
// Surround the entire section with a <div> element.
//
writer.AddAttribute(HtmlTextWriterAttribute.Id, id);
writer.RenderBeginTag(HtmlTextWriterTag.Div);
//
// Write out the table caption.
//
writer.AddAttribute(HtmlTextWriterAttribute.Class, "table-caption");
writer.RenderBeginTag(HtmlTextWriterTag.P);
this.HtmlEncode(title, writer);
writer.RenderEndTag(); // </p>
writer.WriteLine();
//
// Some values can be large and add scroll bars to the page
// as well as ruin some formatting. So we encapsulate the
// table into a scrollable view that is controlled via the
// style sheet.
//
writer.AddAttribute(HtmlTextWriterAttribute.Class, "scroll-view");
writer.RenderBeginTag(HtmlTextWriterTag.Div);
//
// Create a table to display the name/value pairs of the
// collection in 2 columns.
//
Table table = new Table();
table.CellSpacing = 0;
//
// Create the header row and columns.
//
TableRow headRow = new TableRow();
TableHeaderCell headCell;
headCell = new TableHeaderCell();
headCell.Wrap = false;
headCell.Text = "Name";
headCell.CssClass = "name-col";
headRow.Cells.Add(headCell);
headCell = new TableHeaderCell();
headCell.Wrap = false;
headCell.Text = "Value";
headCell.CssClass = "value-col";
headRow.Cells.Add(headCell);
table.Rows.Add(headRow);
//
// Create a row for each entry in the collection.
//
string[] keys = collection.AllKeys;
Array.Sort(keys, StringComparer.InvariantCulture);
for (int keyIndex = 0; keyIndex < keys.Length; keyIndex++)
{
string key = keys[keyIndex];
TableRow bodyRow = new TableRow();
bodyRow.CssClass = keyIndex % 2 == 0 ? "even-row" : "odd-row";
TableCell cell;
//
// Create the key column.
//
cell = new TableCell();
cell.Text = HtmlEncode(key);
cell.CssClass = "key-col";
bodyRow.Cells.Add(cell);
//
// Create the value column.
//
cell = new TableCell();
cell.Text = HtmlEncode(collection[key]);
cell.CssClass = "value-col";
bodyRow.Cells.Add(cell);
table.Rows.Add(bodyRow);
}
//
// Write out the table and close container tags.
//
table.RenderControl(writer);
writer.RenderEndTag(); // </div>
writer.WriteLine();
writer.RenderEndTag(); // </div>
writer.WriteLine();
}
protected override void Render(HtmlTextWriter w)
{
try
{
EnsureChildControls();
Table t = new Table();
t.BorderWidth = 0;
t.CellPadding = 0;
t.CellSpacing = 0;
TableRow r = null;
TableCell c = null;
r = new TableRow();
c = new TableCell();
c.Controls.Add(gv);
r.Cells.Add(c);
t.Rows.Add(r);
t.RenderControl(w);
}
catch (Exception ex)
{
UWeb.Error(w, ex);
}
}
//public
/// <summary>
/// Render this control to the output parameter specified.
/// </summary>
/// <param name="output"> The HTML writer to write out to </param>
protected override void Render(HtmlTextWriter output)
{
NdiMenuItem item0 =
new NdiMenuItem(0, "Szabadszöveges keresés", "Szabadszöveges", "SearchFreetext.aspx", "_images/searchFreeTextS.gif",
"_images/searchFreeTextL.gif");
NdiMenuItem item1 =
new NdiMenuItem(1, "Kulcsszavas keresés", "Kulcsszavas", "SearchKeyword.aspx", "_images/searchKexWordS.gif",
"_images/searchKexWordL.gif");
NdiMenuItem item2 =
new NdiMenuItem(2, "Tematikus keresés", "Tematikus", "SearchByQuestionForm.aspx", "_images/searchQuestionFormS.gif",
"_images/searchQuestionFormL.gif");
NdiMenuItem item3 =
new NdiMenuItem(3, "Megyék szerinti keresés", "Megyék szerint", "SearchMap.aspx", "_images/searchMapS.gif",
"_images/searchMapL.gif");
NdiMenuItem item4 =
new NdiMenuItem(4, "Szervezetek listája", "Szervezetek", "OrganisationList.aspx", "_images/searchOrganisationS.gif",
"_images/searchOrganisationL.gif");
NdiMenuItem item5 =
new NdiMenuItem(5, "Programok listája", "Programok", "ProgramList.aspx", "_images/searchProgramS.gif",
"_images/searchProgramL.gif");
NdiMenuItem item6 =
new NdiMenuItem(6, "Szakemberek listája", "Szakemberek", "ExpertList.aspx", "_images/searchExpertS.gif",
"_images/searchExpertL.gif");
Table table = new Table();
table.CellPadding = 0;
table.CellSpacing = 0;
table.CssClass = "almenu";
TableRow row1 = new TableRow();
TableRow row2 = new TableRow();
TableCell cell0 = CreateCell(item0);
TableCell cell2 = CreateCell(item2);
TableCell cell3 = CreateCell(item3);
TableCell cell4 = CreateCell(item4);
TableCell cell5 = CreateCell(item5);
TableCell cell6 = CreateCell(item6);
table.Rows.Add(row2);
table.Rows.Add(row1);
if (item0.Index == m_selectedindex)
row1.Cells.Add(cell0);
else
row2.Cells.Add(cell0);
// A keyword menu configból jön
if (GetMenuVisibility("SearchKeywordMenu.Visibility"))
{
TableCell cell1 = CreateCell(item1);
if (item1.Index == m_selectedindex)
row1.Cells.Add(cell1);
else
row2.Cells.Add(cell1);
}
if (item2.Index == m_selectedindex)
row1.Cells.Add(cell2);
else
row2.Cells.Add(cell2);
if (item3.Index == m_selectedindex)
row1.Cells.Add(cell3);
else
row2.Cells.Add(cell3);
if (item4.Index == m_selectedindex)
row1.Cells.Add(cell4);
else
row2.Cells.Add(cell4);
if (item5.Index == m_selectedindex)
row1.Cells.Add(cell5);
else
row2.Cells.Add(cell5);
if (Context != null && Context.User != null && Context.User.Identity != null && Context.User.Identity.IsAuthenticated)
{
if (item6.Index == m_selectedindex)
row1.Cells.Add(cell6);
else
row2.Cells.Add(cell6);
}
if(row1.Cells != null && row1.Cells.Count> 0 && row2.Cells != null && row2.Cells.Count > 0)
{
row1.Cells[0].ColumnSpan = row2.Cells.Count;
}
table.Width = Unit.Percentage(100);
table.RenderControl(output);
}
private void RenderCollection(HtmlTextWriter w, NameValueCollection c, string id, string title)
{
if (c == null || c.Count == 0) return;
w.AddAttribute(HtmlTextWriterAttribute.Id, id);
w.RenderBeginTag(HtmlTextWriterTag.Div);
w.AddAttribute(HtmlTextWriterAttribute.Class, "table-caption");
w.RenderBeginTag(HtmlTextWriterTag.P);
this.Server.HtmlEncode(title, w);
w.RenderEndTag(); // </p>
w.WriteLine();
w.AddAttribute(HtmlTextWriterAttribute.Class, "scroll-view");
w.RenderBeginTag(HtmlTextWriterTag.Div);
Table table = new Table();
table.CellSpacing = 0;
string[] keys = c.AllKeys;
Array.Sort(keys, Comparer.DefaultInvariant);
int i = 0;
foreach (var key in keys)
{
string value = c[key];
if (!String.IsNullOrEmpty(value) && !IsHidden(key))
{
bool unimportant = IsUnimportant(key);
string matchingKeys = "";
if (!unimportant)
{
matchingKeys = GetMatchingKeys(c, value);
if (matchingKeys != null)
{
_hidden_keys += matchingKeys.Replace(", ", "|") + "|";
}
}
TableRow bodyRow = new TableRow();
if (unimportant)
bodyRow.CssClass = "unimportant-row";
else
{
i++;
bodyRow.CssClass = i % 2 == 0 ? "even-row" : "odd-row";
}
TableCell cell;
// key
cell = new TableCell();
if (!String.IsNullOrEmpty(matchingKeys))
cell.Text = Server.HtmlEncode(matchingKeys);
else
cell.Text = Server.HtmlEncode(key);
cell.CssClass = "key-col";
bodyRow.Cells.Add(cell);
// value
cell = new TableCell();
cell.Text = PrepareCell(value);
cell.CssClass = "value-col";
bodyRow.Cells.Add(cell);
table.Rows.Add(bodyRow);
}
}
table.RenderControl(w);
w.RenderEndTag(); // </div>
w.WriteLine();
w.RenderEndTag(); // </div>
w.WriteLine();
}
/// <summary>
/// Parses out the survey HTML for use in an email or printing.
/// </summary>
/// <param name="responseHeaderId">The response header id.</param>
/// <param name="title">The title.</param>
/// <param name="displayName">The display name.</param>
/// <returns>
/// A string containing table based html that represents a survey.
/// </returns>
private string GenerateTableBasedSurvey(int responseHeaderId, string title, string displayName)
{
var builder = new StringBuilder();
string body = this.Localize("SurveyCompleted_Body.Text");
if (body != null)
{
body = body.Replace(Utility.UserNameMarker, displayName);
body = body.Replace(Utility.SurveyInformationMarker, title);
var survey = new SurveyRepository().LoadReadOnlySurvey(responseHeaderId, this.ModuleId);
var table = new Table();
var sb = new StringBuilder();
var writer = new HtmlTextWriter(new StringWriter(sb));
survey.Render(table, new DnnLocalizer(this.LocalResourceFile));
table.RenderControl(writer);
body = body.Replace(Utility.SurveyTableMarker, sb.ToString());
builder.Append(body);
}
////Because the output of the controls are type "input" the disabled, checked and selected properties must be changed
////to just disabled, checked and selected to be recognized by certain email clients i.e. Hotmail.
return
builder.ToString().Replace('"', '\'').Replace(Environment.NewLine, string.Empty).Replace("\t", string.Empty).Replace(
"='selected'", string.Empty).Replace("='disabled'", string.Empty).Replace("='checked'", string.Empty);
}
protected void btn_export_Click(object sender, EventArgs e)
{
DataView view = new DataView();
view.Table = (DataTable)this.ViewState["lista"];
if (view.Count == 0)
{
utils.ShowMessage2(this, "exportar", "warn_sinFilas"); return;
}
view.Table.Columns.Remove(view.Table.Columns["ID_SOLICITUDANDEN"]);
view.Table.Columns.Remove(view.Table.Columns["USUA_ID"]);
view.Table.Columns.Remove(view.Table.Columns["ORDEN"]);
view.Table.Columns.Remove(view.Table.Columns["ID_ESTADOANDEN"]);
view.Table.Columns.Remove(view.Table.Columns["ESTADOANDEN"]);
view.Table.Columns.Remove(view.Table.Columns["ID_ESTADOSOLICITUD"]);
view.Table.Columns.Remove(view.Table.Columns["SOLI_FH_CREACION_2"]);
view.Table.Columns.Remove(view.Table.Columns["FECHA_RESERVA_ANDEN_2"]);
view.Table.Columns.Remove(view.Table.Columns["FECHA_PUESTA_ANDEN_2"]);
view.Table.Columns.Remove(view.Table.Columns["ID_TRANSPORTISTA"]);
view.Table.Columns.Remove(view.Table.Columns["PLAY_ID"]);
view.Table.Columns.Remove(view.Table.Columns["PLAYA"]);
view.Table.Columns.Remove(view.Table.Columns["ID_LUGAR"]);
GridView gv = new GridView();
gv.DataSource = view;
gv.DataBind();
string fileName = "reporte_Carga.xls";
PrepareControlForExport(gv);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("Content-type", "application / xls");
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.Cache.SetCacheability(System.Web.HttpCacheability.Public);
HttpContext.Current.Response.ContentType = "application/ms-excel";
try
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
System.Web.UI.WebControls.Table table = new System.Web.UI.WebControls.Table();
table.GridLines = gv.GridLines;
if (gv.HeaderRow != null)
{
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
table.Rows.Add(row);
}
if (gv.FooterRow != null)
{
PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
gv.GridLines = GridLines.Both;
table.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
catch (HttpException ex)
{
throw ex;
}
}
public override string GetDesignTimeHtml()
{
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Table t = new Table();
t.BorderColor = Color.Navy;
t.BackColor = ColorTranslator.FromHtml("#B6C9E7");
t.BorderStyle = BorderStyle.Solid;
TableRow tr = new TableRow();
tr.Width = 120;
tr.Height = 150;
TableCell td = new TableCell();
td.Text = string.Format("<strong>ScottWater</strong><br>Book Control<br>{0}",bc.ID);
td.VerticalAlign = VerticalAlign.Middle;
td.HorizontalAlign = HorizontalAlign.Center;
tr.Cells.Add(td);
t.Rows.Add(tr);
t.RenderControl(htw);
return sw.ToString();
}
protected void ShowRequests(IList data)
{
Table t = new Table {
CellPadding = 0,
CellSpacing = 0,
Width = Unit.Percentage(100.0)
};
AddCell(AddRow(t), System.Web.SR.GetString("Trace_Application_Trace"));
string applicationPath = this._request.ApplicationPath;
int length = applicationPath.Length;
AddCell(AddRow(t), "<h2>" + HttpUtility.HtmlEncode(applicationPath.Substring(1)) + "<h2><p>");
AddCell(AddRow(t), "[ <a href=\"Trace.axd?clear=1\" class=\"link\">" + System.Web.SR.GetString("Trace_Clear_Current") + "</a> ]");
string text = " ";
if (HttpRuntime.HasAppPathDiscoveryPermission())
{
text = System.Web.SR.GetString("Trace_Physical_Directory") + this._request.PhysicalApplicationPath;
}
TableCell cell = AddCell(AddRow(t), text);
t.RenderControl(this._writer);
t = new Table {
CellPadding = 0,
CellSpacing = 0,
Width = Unit.Percentage(100.0)
};
TableRow trow = AddRow(t);
cell = AddHeaderCell(trow, "<h3><b>" + System.Web.SR.GetString("Trace_Requests_This") + "</b></h3>");
cell.ColumnSpan = 5;
cell.CssClass = "alt";
cell.HorizontalAlign = HorizontalAlign.Left;
cell = AddHeaderCell(trow, System.Web.SR.GetString("Trace_Remaining") + " " + HttpRuntime.Profile.RequestsRemaining.ToString(NumberFormatInfo.InvariantInfo));
cell.CssClass = "alt";
cell.HorizontalAlign = HorizontalAlign.Right;
trow = AddRow(t);
trow.HorizontalAlign = HorizontalAlign.Left;
trow.CssClass = "subhead";
AddHeaderCell(trow, System.Web.SR.GetString("Trace_No"));
AddHeaderCell(trow, System.Web.SR.GetString("Trace_Time_of_Request"));
AddHeaderCell(trow, System.Web.SR.GetString("Trace_File"));
AddHeaderCell(trow, System.Web.SR.GetString("Trace_Status_Code"));
AddHeaderCell(trow, System.Web.SR.GetString("Trace_Verb"));
AddHeaderCell(trow, " ");
bool flag = true;
for (int i = 0; i < data.Count; i++)
{
DataSet set = (DataSet) data[i];
trow = AddRow(t);
if (flag)
{
trow.CssClass = "alt";
}
AddCell(trow, (i + 1).ToString(NumberFormatInfo.InvariantInfo));
AddCell(trow, (string) set.Tables["Trace_Request"].Rows[0]["Trace_Time_of_Request"]);
AddCell(trow, ((string) set.Tables["Trace_Request"].Rows[0]["Trace_Url"]).Substring(length));
AddCell(trow, set.Tables["Trace_Request"].Rows[0]["Trace_Status_Code"].ToString());
AddCell(trow, (string) set.Tables["Trace_Request"].Rows[0]["Trace_Request_Type"]);
TableCell cell2 = AddCell(trow, string.Empty);
HtmlAnchor child = new HtmlAnchor {
HRef = "Trace.axd?id=" + i,
InnerHtml = "<nobr>" + System.Web.SR.GetString("Trace_View_Details")
};
child.Attributes["class"] = "link";
cell2.Controls.Add(child);
flag = !flag;
}
t.RenderControl(this._writer);
}
