protected void Boton_Excel_Dios_Click(object sender, EventArgs e)
        {
            StringBuilder sb = new StringBuilder();
            StringWriter sw = new StringWriter(sb);
            HtmlTextWriter htw = new HtmlTextWriter(sw);

            Page page = new Page();
            HtmlForm form = new HtmlForm();
            GridView_Dios.DataSourceID = string.Empty;
            GridView_Dios.EnableViewState = false;
            GridView_Dios.AllowPaging = false;
            GridView_Dios.DataSource = LBPD.Logica_Mostrar_Precios();
            GridView_Dios.DataBind();
            page.EnableEventValidation = false;
            page.DesignerInitialize();
            page.Controls.Add(form);
            form.Controls.Add(GridView_Dios);
            page.RenderControl(htw);
            Response.Clear();
            Response.Buffer = true;
            Response.ContentType = "applicattion/vnd.ms-excel";
            Response.AddHeader("Content-Disposition", "attachment;filename=data.xls");
            Response.Charset = "UTF-8";
            Response.ContentEncoding = Encoding.Default;
            Response.Write(sb.ToString());
            Response.End();
        }

 protected override void Render(HtmlTextWriter writer)
 {
     Literal itmCaption = new Literal();
     itmCaption.Text = "<label for=\"" + this.ClientID + "\" class=\"" + this.CaptionCssClass + "\">" + this.Caption + "</label>";
     itmCaption.RenderControl(writer);
     base.Render(writer);
 }

 /// <summary>
 /// Accordions the HTML.
 /// </summary>
 /// <param name="html">The HTML.</param>
 /// <param name="items">The items.</param>
 /// <param name="headertemplete">The headertemplete.</param>
 /// <param name="itemtemplete">The itemtemplete.</param>
 public static void AccordionHtml(this HtmlHelper html, List<AccordionItem> items, Func<AccordionItem, string> headertemplete, Func<AccordionLeafItem, string> itemtemplete)
 {
     if (items != null)
     {
         StringBuilder buffer = new StringBuilder();
         HtmlTextWriter writer = new HtmlTextWriter(new StringWriter(buffer));
         foreach (AccordionItem item in items)
         {
             writer.AddAttribute(HtmlTextWriterAttribute.Class, "accordionheadercontainer");
             writer.RenderBeginTag(HtmlTextWriterTag.Div);
             writer.Write(headertemplete(item));
             writer.RenderEndTag();
             writer.AddAttribute(HtmlTextWriterAttribute.Class, "accordionbody");
             writer.AddStyleAttribute(HtmlTextWriterStyle.Display, "none");
             writer.RenderBeginTag(HtmlTextWriterTag.Div);
             writer.RenderBeginTag(HtmlTextWriterTag.Ul);
             foreach (AccordionLeafItem leafitem in item.Children)
             {
                 writer.AddAttribute(HtmlTextWriterAttribute.Class, "accordionitemcontainer");
                 writer.RenderBeginTag(HtmlTextWriterTag.Li);
                 writer.Write(itemtemplete(leafitem));
                 writer.RenderEndTag();
             }
             writer.RenderEndTag();
             writer.RenderEndTag();
         }
         HttpContext.Current.Response.Write(buffer.ToString());
     }
 }

        //- #Render -//
        /// <summary>
        /// Removes viewstate, event validation and the ASP.NET form element from the page
        /// </summary>
        /// <param name="originalWriter">The original writer.</param>
        protected override void Render(HtmlTextWriter originalWriter)
        {
            var stringWriter = new StringWriter(CultureInfo.CurrentCulture);
            var htmlTextWriter = new HtmlTextWriter(stringWriter);
            //+
            base.Render(htmlTextWriter);
            htmlTextWriter.Close();
            //+
            String data = stringWriter.GetStringBuilder().ToString();
            String pattern = @"<div>([\r\n\s]*)<input type=""hidden"" name=""__VIEWSTATE"" id=""__VIEWSTATE"" value=""(?<viewstate>[+/=a-z0-9]+)"" />([\r\n\s]*)</div>";
            data = Regex.Replace(data, pattern, String.Empty, RegexOptions.IgnoreCase);
            pattern = @"<div>([\r\n\s]*)<input type=""hidden"" name=""__EVENTVALIDATION"" id=""__EVENTVALIDATION"" value=""(?<eventvalidation>[+/=a-z0-9]+)"" />([\r\n\s]*)</div>";
            data = Regex.Replace(data, pattern, String.Empty, RegexOptions.IgnoreCase);
            pattern = @"<form name=""ctl([\d]+)"" method=""post"" action="""" id=""ctl([\d]+)"">([\r\n\s]*)";
            data = Regex.Replace(data, pattern, String.Empty, RegexOptions.IgnoreCase);
            if (!EnableState)
            {
                pattern = @"<form name=""ctl([\d]+)"" method=""post"">([\r\n\s]*)";
                data = Regex.Replace(data, pattern, String.Empty, RegexOptions.IgnoreCase);
            }
            pattern = @"([\r\n\s]*)</form>";
            String replacement = String.Empty;
            if (EnableState)
            {
                replacement = new StateArea().GetRenderData() + @"
</form>";
            }
            data = Regex.Replace(data, pattern, replacement, RegexOptions.IgnoreCase);
            //+
            originalWriter.Write(data);
        }

 protected void btnPDF_Click(object sender, ImageClickEventArgs e)
 {
     Response.ContentType = "application/pdf";
     Response.AddHeader("content-disposition", "attachment;filename=UserDetails.pdf");
     Response.Cache.SetCacheability(HttpCacheability.NoCache);
     var sw = new StringWriter();
     var hw = new HtmlTextWriter(sw);
     gvdetails.AllowPaging = false;
     gvdetails.DataBind();
     gvdetails.RenderControl(hw);
     gvdetails.HeaderRow.Style.Add("width", "15%");
     gvdetails.HeaderRow.Style.Add("font-size", "10px");
     gvdetails.Style.Add("text-decoration", "none");
     gvdetails.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
     gvdetails.Style.Add("font-size", "8px");
     var sr = new StringReader(sw.ToString());
     var pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f, 0f);
     var htmlparser = new HTMLWorker(pdfDoc);
     PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
     pdfDoc.Open();
     htmlparser.Parse(sr);
     pdfDoc.Close();
     Response.Write(pdfDoc);
     Response.End();
 }

 public void Render(
     HtmlTextWriter writer,
     TypeSignature signature,
     TypeRenderOption options)
 {
     Render(writer, signature, options, false);
 }

 protected override void Render(HtmlTextWriter writer)
 {
     int num;
     int.TryParse(HttpContext.Current.Request.QueryString.Get("id"), out num);
     ActivityInfo activity = VshopBrowser.GetActivity(num);
     if (activity != null)
     {
         string format = "<div class=\"qb_mb10 qb_flex\"><input type=\"text\" class=\"mod_input flex_box\" style=\"height:35px;\" placeholder=\"您的{0}\" id=\"{1}\"></div>";
         StringBuilder builder = new StringBuilder();
         builder.AppendFormat("<input type=\"hidden\" id=\"id\" value=\"{0}\">", num);
         if (!string.IsNullOrEmpty(activity.Item1))
         {
             builder.AppendFormat(format, activity.Item1, "item1");
         }
         if (!string.IsNullOrEmpty(activity.Item2))
         {
             builder.AppendFormat(format, activity.Item2, "item2");
         }
         if (!string.IsNullOrEmpty(activity.Item3))
         {
             builder.AppendFormat(format, activity.Item3, "item3");
         }
         if (!string.IsNullOrEmpty(activity.Item4))
         {
             builder.AppendFormat(format, activity.Item4, "item4");
         }
         if (!string.IsNullOrEmpty(activity.Item5))
         {
             builder.AppendFormat(format, activity.Item5, "item5");
         }
         writer.Write(builder.ToString());
     }
 }

        protected override void Render(HtmlTextWriter writer)
        {
            switch (((OrderStatus) this.PurchaseStatusCode))
            {
                case OrderStatus.WaitBuyerPay:
                    base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/UnPaymentPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
                    break;

                case OrderStatus.BuyerAlreadyPaid:
                    base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/UnShippingPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
                    break;

                case OrderStatus.SellerAlreadySent:
                    base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/DeliveredPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
                    break;

                case OrderStatus.Closed:
                    base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/ClosedPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
                    break;

                case OrderStatus.Finished:
                    base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/FinishedPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
                    break;
            }
            base.Render(writer);
        }

 protected override void AddAttributesToRender(HtmlTextWriter writer)
 {
     string associatedControlID = this.AssociatedControlID;
     if (associatedControlID.Length != 0)
     {
         if (this.AssociatedControlInControlTree)
         {
             Control control = this.FindControl(associatedControlID);
             if (control == null)
             {
                 if (!base.DesignMode)
                 {
                     throw new HttpException(System.Web.SR.GetString("LabelForNotFound", new object[] { associatedControlID, this.ID }));
                 }
             }
             else
             {
                 writer.AddAttribute(HtmlTextWriterAttribute.For, control.ClientID);
             }
         }
         else
         {
             writer.AddAttribute(HtmlTextWriterAttribute.For, associatedControlID);
         }
     }
     base.AddAttributesToRender(writer);
 }

        private void ExportToPDF()
        {
            using (StringWriter sw = new StringWriter())
            {
                using (HtmlTextWriter hw = new HtmlTextWriter(sw))
                {
                    //To Export all pages
                    this.gvExportToPdf.AllowPaging = false;
                    //this.BindGridView();

                    this.gvExportToPdf.RenderControl(hw);
                    StringReader sr = new StringReader(sw.ToString());
                    Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
                    HTMLWorker htmlparser = new HTMLWorker(pdfDoc);

                    Response.ContentType = "application/pdf";
                    Response.AddHeader("content-disposition", "attachment;filename=DashboardReport.pdf");
                    Response.Cache.SetCacheability(HttpCacheability.NoCache);
                    PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
                    pdfDoc.Open();
                    htmlparser.Parse(sr);
                    pdfDoc.Close();
                    Response.Write(pdfDoc);
                    Response.End();
                }
            }
        }

 private string CreateSummary() {
     StringWriter stringWriter = new StringWriter();
     HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
     htmlWriter.AddAttribute(HtmlTextWriterAttribute.Class,
         "table table-bordered");
     htmlWriter.RenderBeginTag(HtmlTextWriterTag.Table);
     htmlWriter.AddAttribute(HtmlTextWriterAttribute.Class, "success");
     htmlWriter.RenderBeginTag(HtmlTextWriterTag.Tr);
     htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
     htmlWriter.Write("Requests");
     htmlWriter.RenderEndTag();
     htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
     htmlWriter.Write(requestCount);
     htmlWriter.RenderEndTag();
     htmlWriter.RenderEndTag();
     htmlWriter.AddAttribute(HtmlTextWriterAttribute.Class, "success");
     htmlWriter.RenderBeginTag(HtmlTextWriterTag.Tr);
     htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
     htmlWriter.Write("Total Time");
     htmlWriter.RenderEndTag();
     htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
     htmlWriter.Write("{0:F5} seconds", totalTime);
     htmlWriter.RenderEndTag();
     htmlWriter.RenderEndTag();
     htmlWriter.RenderEndTag();
     return stringWriter.ToString();
 }

        /// <summary>
        /// Outputs server control content to a provided <see cref="T:System.Web.UI.HtmlTextWriter" /> object and stores tracing information about the control if tracing is enabled.
        /// </summary>
        /// <param name="writer">The <see cref="T:System.Web.UI.HtmlTextWriter" /> object that receives the control content.</param>
        public override void RenderControl( HtmlTextWriter writer )
        {
            if ( this.Visible )
            {
                string alertType = NotificationBoxType.ToString().ToLower();

                bool showMessage = !string.IsNullOrWhiteSpace( Heading ) || !string.IsNullOrWhiteSpace( Title ) || !string.IsNullOrWhiteSpace( this.Text );

                if ( showMessage )
                {
                    writer.AddAttribute( "class", "alert alert-" + alertType );
                    writer.RenderBeginTag( HtmlTextWriterTag.Div );

                    if ( !string.IsNullOrWhiteSpace( Heading ) )
                    {
                        writer.RenderBeginTag( HtmlTextWriterTag.H4 );
                        writer.Write( Heading );
                        writer.RenderEndTag();
                    }

                    if ( !string.IsNullOrWhiteSpace( Title ) )
                    {
                        writer.RenderBeginTag( HtmlTextWriterTag.Strong );
                        writer.Write( Title + " ");
                        writer.RenderEndTag();
                    }

                    base.RenderControl( writer );

                    writer.RenderEndTag();
                }
            }
        }

        public void GetEmployeesAccessMasterGrid()
        {
            Grid mastergrid = new Grid
                                  {
                                      DataSourceId = "Employees",
                                      ID = "test",
                                      Page = Testpage,
                                      ConnectionString = ConnectionAccessOleDb
                                  };
            Testpage.Controls.Add(mastergrid);

            Grid slavegrid = new Grid
                                 {
                                     DataSourceId = "Territories",
                                     ID = "test2",
                                     Page = Testpage,
                                     MasterGrid = "test",
                                     ConnectionString = ConnectionAccessOleDb
                                 };
            Testpage.Controls.Add(slavegrid);

            StringBuilder sb = new StringBuilder();
            StringWriter sw = new StringWriter(sb);
            HtmlTextWriter gridwriter = new HtmlTextWriter(sw);
            mastergrid.RenderControl(gridwriter);

            sb = new StringBuilder();
            sw = new StringWriter(sb);
            gridwriter = new HtmlTextWriter(sw);
            slavegrid.RenderControl(gridwriter);

            Assert.Greater(mastergrid.MasterTable.Rows.Count, 1);
            Assert.IsTrue(mastergrid.MasterTable.GotSchema);
            Assert.IsFalse(slavegrid.MasterTable.GotSchema);
        }

        public new void ProcessRequest(IHttpRequest httpReq, IHttpResponse httpRes, string operationName)
        {
            EndpointHost.Config.AssertFeatures(Feature.Metadata);

            var operations = EndpointHost.ServiceOperations;

            if (httpReq.QueryString["xsd"] != null)
            {
                var xsdNo = Convert.ToInt32(httpReq.QueryString["xsd"]);
                var schemaSet = XsdUtils.GetXmlSchemaSet(operations.AllOperations.Types);
                var schemas = schemaSet.Schemas();
                var i = 0;
                if (xsdNo >= schemas.Count)
                {
                    throw new ArgumentOutOfRangeException("xsd");
                }
                httpRes.ContentType = "text/xml";
                foreach (XmlSchema schema in schemaSet.Schemas())
                {
                    if (xsdNo != i++) continue;
                    schema.Write(httpRes.Output);
                    break;
                }
                return;
            }

            var writer = new HtmlTextWriter(httpRes.Output);
            httpRes.ContentType = "text/html";
            ProcessOperations(writer, httpReq);
            writer.Flush();
        }

        private void RenderCurrencySign(HtmlTextWriter writer)
        {
            var cs = GetCurrencySign();

            if (!string.IsNullOrEmpty(cs))
                writer.Write(cs + " ");
        }

        protected void btnExcel_Click(object sender, EventArgs e)
        {
            //Create a dummy GridView
            GridView GridView1 = new GridView();
            GridView1.AllowPaging = false;
            GridView1.DataSource = BindGridView();
            GridView1.DataBind();

            Response.Clear();
            Response.Buffer = true;
            Response.AddHeader("content-disposition",
             "attachment;filename=" + DateTime.Now.Year + "-Newly_Hired" + ".xls");
            Response.Charset = "";
            Response.ContentType = "application/vnd.ms-excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(sw);

            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                //Apply text style to each Row
                GridView1.Rows[i].Attributes.Add("class", "textmode");
            }
            GridView1.RenderControl(hw);

            //style to format numbers to string
            string style = @"<style> .textmode { mso-number-format:\@; } </style>";
            Response.Write(style);
            Response.Output.Write(sw.ToString());
            Response.Flush();
            Response.End();
        }

		public string Render ()
		{
			StringWriter sw = new StringWriter ();
			HtmlTextWriter tw = new HtmlTextWriter (sw);
			Render (tw);
			return sw.ToString ();
		}

		public new void ProcessRequest(IHttpRequest httpReq, IHttpResponse httpRes, string operationName)
    	{
            if (!AssertAccess(httpReq, httpRes, httpReq.QueryString["op"])) return;

			var operationTypes = EndpointHost.Metadata.GetAllTypes();

    		if (httpReq.QueryString["xsd"] != null)
    		{
				var xsdNo = Convert.ToInt32(httpReq.QueryString["xsd"]);
                var schemaSet = XsdUtils.GetXmlSchemaSet(operationTypes);
    			var schemas = schemaSet.Schemas();
    			var i = 0;
    			if (xsdNo >= schemas.Count)
    			{
    				throw new ArgumentOutOfRangeException("xsd");
    			}
    			httpRes.ContentType = "text/xml";
    			foreach (XmlSchema schema in schemaSet.Schemas())
    			{
    				if (xsdNo != i++) continue;
    				schema.Write(httpRes.OutputStream);
    				break;
    			}
    			return;
    		}

			using (var sw = new StreamWriter(httpRes.OutputStream))
			{
				var writer = new HtmlTextWriter(sw);
				httpRes.ContentType = "text/html";
				ProcessOperations(writer, httpReq, httpRes);
			}
    	}

    /// <summary>
    /// 导出Excel
    /// </summary>
    protected void btnExport_Click(object sender, EventArgs e)
    {
        try
        {
            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=\""
                + System.Web.HttpUtility.UrlEncode("高位货架库位使用情况列表", System.Text.Encoding.UTF8) + ".xls\"");

            HttpContext.Current.Response.Charset = "GB2312";
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
            HttpContext.Current.Response.ContentType = "application/ms-excel";  //image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword

            this.grid.AllowPaging = false;
            this.BindGrid();
            this.panel1.Page.EnableViewState = false;
            System.IO.StringWriter sw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
            this.panel1.RenderControl(hw);
            HttpContext.Current.Response.Write(sw.ToString());
            HttpContext.Current.Response.End();
        }
        catch
        {

        }
    }

        /// <Summary>RenderEditMode renders the Edit mode of the control</Summary>
        /// <Param name="writer">A HtmlTextWriter.</Param>
        protected override void RenderEditMode( HtmlTextWriter writer )
        {
            PortalSettings _portalSettings = Globals.GetPortalSettings();

            //Get the Pages
            ArrayList tabs = Globals.GetPortalTabs(_portalSettings.PortalId, true, true, false, false, false);

            //Render the Select Tag
            ControlStyle.AddAttributesToRender(writer);
            writer.AddAttribute(HtmlTextWriterAttribute.Name, this.UniqueID);
            writer.RenderBeginTag(HtmlTextWriterTag.Select);

            for (int tabIndex = 0; tabIndex <= tabs.Count - 1; tabIndex++)
            {
                TabInfo tab = (TabInfo)tabs[tabIndex];

                //Add the Value Attribute
                writer.AddAttribute(HtmlTextWriterAttribute.Value, tab.TabID.ToString());

                if (tab.TabID == IntegerValue)
                {
                    //Add the Selected Attribute
                    writer.AddAttribute(HtmlTextWriterAttribute.Selected, "selected");
                }

                //Render Option Tag
                writer.RenderBeginTag(HtmlTextWriterTag.Option);
                writer.Write(tab.TabName);
                writer.RenderEndTag();
            }

            //Close Select Tag
            writer.RenderEndTag();
        }