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) { if (!string.IsNullOrEmpty(this.ID) && this.Text.Length == 0) { this.Text = LocalizationUtility.GetText(this.ID); } base.Render(writer); }
/// <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(); }
protected override void RenderBeginTag(HtmlTextWriter writer) { writer.Indent++; // Div writer.AddAttribute(HtmlTextWriterAttribute.Id, this.Control.ClientID); // inject the asp.RadioButtonList css entries into the new HTML ouput generated. string cssClass = String.Empty; if (!string.IsNullOrEmpty(this.Control.CssClass)) { cssClass = Helpers.BuildClassList(cssClass, this.Control.CssClass); } RadioButtonList controlList = this.Control as RadioButtonList; if (controlList != null) { if (controlList.RepeatDirection == RepeatDirection.Horizontal) { cssClass = Helpers.BuildClassList(cssClass, CBootstrapFormInlineLayoutClassName); } } if (!string.IsNullOrEmpty(cssClass.Trim())) { writer.AddAttribute(HtmlTextWriterAttribute.Class, cssClass.Trim()); } }
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); }
internal static void WriteSkipLinkStart(HtmlTextWriter writer, Version renderingCompatibility, bool designMode, string skipLinkText, string spacerImageUrl, string clientID) { if (skipLinkText.Length != 0 && !designMode) { if (renderingCompatibility >= VersionUtil.Framework45) { writer.AddAttribute(HtmlTextWriterAttribute.Href, '#' + clientID + SkipLinkContentMark); writer.AddStyleAttribute(HtmlTextWriterStyle.Position, "absolute"); writer.AddStyleAttribute(HtmlTextWriterStyle.Left, "-10000px"); writer.AddStyleAttribute(HtmlTextWriterStyle.Top, "auto"); writer.AddStyleAttribute(HtmlTextWriterStyle.Width, "1px"); writer.AddStyleAttribute(HtmlTextWriterStyle.Height, "1px"); writer.AddStyleAttribute(HtmlTextWriterStyle.Overflow, "hidden"); writer.RenderBeginTag(HtmlTextWriterTag.A); writer.Write(skipLinkText); writer.RenderEndTag(); } else { writer.AddAttribute(HtmlTextWriterAttribute.Href, '#' + clientID + SkipLinkContentMark); writer.RenderBeginTag(HtmlTextWriterTag.A); writer.AddAttribute(HtmlTextWriterAttribute.Alt, skipLinkText); writer.AddAttribute(HtmlTextWriterAttribute.Src, spacerImageUrl); writer.AddStyleAttribute(HtmlTextWriterStyle.BorderWidth, "0px"); writer.AddAttribute(HtmlTextWriterAttribute.Width, "0"); writer.AddAttribute(HtmlTextWriterAttribute.Height, "0"); writer.RenderBeginTag(HtmlTextWriterTag.Img); writer.RenderEndTag(); writer.RenderEndTag(); } } }
public void Render(HtmlTextWriter writer) { if (_isAutomatedTool) { var console = new StringProgressStatus(); ProcessInternal(console); HttpContext.Current.Response.ContentType = "text/plain"; HttpContext.Current.Response.Write(Title + "\n\n"); HttpContext.Current.Response.Write(console.Output); if (console.HasErrors) { HttpContext.Current.Response.StatusCode = 500; HttpContext.Current.Response.TrySkipIisCustomErrors = true; } HttpContext.Current.Response.End(); } else { var console = new CustomStyledHtml5WebConsole(HttpContext.Current.Response); console.Title = Title; console.Render(ProcessInternal); } }
protected void AddParameter(string name, string value, HtmlTextWriter writer) { writer.AddAttribute(HtmlTextWriterAttribute.Name, name); writer.AddAttribute(HtmlTextWriterAttribute.Value, value); writer.RenderBeginTag(HtmlTextWriterTag.Param); writer.RenderEndTag(); }
/// <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.Text.Trim() != string.Empty ) { writer.AddAttribute( "class", "warning" ); writer.AddAttribute( "href", "#" ); writer.AddAttribute( "tabindex", "-1" ); foreach (var key in this.Style.Keys.OfType<HtmlTextWriterStyle>()) { writer.AddStyleAttribute( key, this.Style[key] ); } writer.RenderBeginTag( HtmlTextWriterTag.A ); writer.AddAttribute("class", "fa fa-exclamation-triangle"); writer.RenderBeginTag( HtmlTextWriterTag.I ); writer.RenderEndTag(); writer.RenderEndTag(); writer.AddAttribute( "class", "alert alert-warning warning-message" ); writer.AddAttribute( "style", "display:none" ); writer.RenderBeginTag( HtmlTextWriterTag.Div ); writer.RenderBeginTag( HtmlTextWriterTag.Small ); writer.Write( this.Text.Trim() ); writer.RenderEndTag(); writer.RenderEndTag(); } }
public static void PrintWebControl(Control ctrl, string Script) { StringWriter stringWrite = new StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); if (ctrl is WebControl) { Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ctrl).Width = w; } Page pg = new Page(); pg.EnableEventValidation = false; if (Script != string.Empty) { pg.ClientScript.RegisterStartupScript(pg.GetType(), "PrintJavaScript", Script); } HtmlForm frm = new HtmlForm(); pg.Controls.Add(frm); frm.Attributes.Add("runat", "server"); frm.Controls.Add(ctrl); pg.DesignerInitialize(); pg.RenderControl(htmlWrite); string strHTML = stringWrite.ToString(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write(strHTML); HttpContext.Current.Response.Write("<script>window.print();</script>"); HttpContext.Current.Response.End(); }
internal static void WriteSkipLinkEnd(HtmlTextWriter writer, bool designMode, string skipLinkText, string clientID) { if (skipLinkText.Length != 0 && !designMode) { writer.AddAttribute(HtmlTextWriterAttribute.Id, clientID + SkipLinkContentMark); // XHTML 1.1 needs id instead of name writer.RenderBeginTag(HtmlTextWriterTag.A); writer.RenderEndTag(); } }
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(); }
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 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(); }
/// <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()); } }
/// <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 { } }
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(); }
//- #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); }
public string Render () { StringWriter sw = new StringWriter (); HtmlTextWriter tw = new HtmlTextWriter (sw); Render (tw); return sw.ToString (); }
public void Render( HtmlTextWriter writer, TypeSignature signature, TypeRenderOption options) { Render(writer, signature, options, false); }
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 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(); } } }
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(); } } }
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); }
protected override void Render(HtmlTextWriter writer) { CartBL cartBL = new CartBL(); lblProductCount.Text = cartBL.GetProductsCount(Session["cartID"].ToString()).ToString(); lblCartPrice.Text = string.Format("{0:N2}", cartBL.GetTotal(Session["cartID"].ToString())); base.Render(writer); }
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); }
private void RenderCurrencySign(HtmlTextWriter writer) { var cs = GetCurrencySign(); if (!string.IsNullOrEmpty(cs)) writer.Write(cs + " "); }
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> /// <returns></returns> private void OutputDataToExcle(string strFilename) { string sWhereSQL = " And SignStatus=1"; if (txtUserSalaryOpCode.Text.Length > 0) { sWhereSQL = sWhereSQL + " And a.OpCode = '" + txtUserSalaryOpCode.Text + "'"; } //月份起始和月份结束同时不为空时,按区间查找数据 if (txtSalaryYears.Text.Length > 0 && txtSalaryYears2.Text.Length > 0) { sWhereSQL += " And a.SalaryYears >= '" + txtSalaryYears.Text + "'"; if (ddlImportRec.SelectedIndex > 0) { sWhereSQL += " And a.SalaryDate>='" + ddlImportRec.SelectedItem.Text + "'"; } sWhereSQL += " And a.SalaryYears <= '" + txtSalaryYears2.Text + "'"; if (ddlImportRec2.SelectedIndex > 0) { sWhereSQL += " And a.SalaryDate <= DateAdd(mi,3,'" + ddlImportRec2.SelectedItem.Text + "')"; } } //仅月份起始不为空时,只按月份起始查找数据 else if (txtSalaryYears.Text.Length > 0) { sWhereSQL += " And a.SalaryYears = '" + txtSalaryYears.Text + "'"; if (ddlImportRec.SelectedIndex > 0) { sWhereSQL += " And a.SalaryRecGuid ='" + ddlImportRec.SelectedValue.ToString() + "'"; } } //仅月份结束不为空时,只按月份结束查找数据 else if (txtSalaryYears2.Text.Length > 0) { sWhereSQL += " And a.SalaryYears = '" + txtSalaryYears2.Text + "'"; if (ddlImportRec2.SelectedIndex > 0) { sWhereSQL += " And a.SalaryRecGuid ='" + ddlImportRec2.SelectedValue.ToString() + "'"; } } //月份起始和月份结束同时不为空时,按区间查找数据 if (ddlPlatform.SelectedIndex == 2) { sWhereSQL += " And a.SignPlatform = 1 "; } else if (ddlPlatform.SelectedIndex == 1) { sWhereSQL += " And (a.SignPlatform = 0 or a.SignPlatform is null)"; } //如果不是从属与最高部门的员工,此页面只能查询其所属子部门员工的数据! SqlDataReader sdrUser = SysClass.SysUser.GetUserInfoByReader(SysClass.SysGlobal.GetCurrentOpCode()); if (sdrUser.Read()) { SqlDataReader sdrOrg = SysClass.SysOrgan.GetSingleOrganByReader(Convert.ToInt32(sdrUser["OrganID"])); if (sdrOrg.Read()) { if (sdrOrg["POrganID"].ToString() != "0") { sWhereSQL += " And b.OrganID = " + Convert.ToInt32(sdrUser["OrganID"]); } } sdrOrg.Close(); } sdrUser.Close(); DataSet ds = SysClass.SysUserSalary.GetUserSalaryLstByDataSet(sWhereSQL); //创建DataTable对象 DataTable dt = new DataTable("output"); //构建表结构,往表中添加列 dt.Columns.Add("序号", typeof(int)); dt.Columns.Add("工号", typeof(string)); dt.Columns.Add("姓名", typeof(string)); dt.Columns.Add("工资年月", typeof(string)); dt.Columns.Add("发放日期", typeof(string)); dt.Columns.Add("发放金额", typeof(decimal)); dt.Columns.Add("签收状态", typeof(string)); dt.Columns.Add("签收时间", typeof(string)); dt.Columns.Add("签收端", typeof(string)); for (int iLoop = 0; iLoop < ds.Tables[0].Rows.Count; iLoop++) { //创建DataRow对象 DataRow dr = dt.NewRow(); //新增数据 dr[0] = iLoop + 1; dr[1] = ds.Tables[0].Rows[iLoop]["OpCode"].ToString(); dr[2] = ds.Tables[0].Rows[iLoop]["OpName"].ToString(); dr[3] = ds.Tables[0].Rows[iLoop]["SalaryYears"].ToString(); string SalaryOnlyDate = ds.Tables[0].Rows[iLoop]["SalaryDate"].ToString(); dr[4] = SalaryOnlyDate.Length > 0 ? DateTime.Parse(SalaryOnlyDate).ToString("yyyy-MM-dd") : ""; dr[5] = ds.Tables[0].Rows[iLoop]["TotalSalary"].ToString(); dr[6] = "已签收"; dr[7] = ds.Tables[0].Rows[iLoop]["SignDate"].ToString(); string SignPlatform = ds.Tables[0].Rows[iLoop]["SignPlatform"].ToString(); dr[8] = SignPlatform == "1" ? "手机端" : "PC端"; //把数据添加到表结构中 dt.Rows.Add(dr); } System.Web.UI.WebControls.DataGrid dgExport = null; // 当前对话 System.Web.HttpContext curContext = System.Web.HttpContext.Current; // IO用于导出并返回excel文件 System.IO.StringWriter strWriter = null; System.Web.UI.HtmlTextWriter htmlWriter = null; // 设置编码和附件格式 curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); curContext.Response.Charset = "gb2312"; // 导出excel文件 strWriter = new System.IO.StringWriter(); htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter); // 为了解决dgData中可能进行了分页的情况,需要重新定义一个无分页的DataGrid dgExport = new System.Web.UI.WebControls.DataGrid(); dgExport.DataSource = dt.DefaultView; dgExport.AllowPaging = false; dgExport.DataBind(); // 返回客户端 dgExport.RenderControl(htmlWriter); curContext.Response.Clear(); curContext.Response.Buffer = true; curContext.Response.Write("上海动车段工资电子签收系统"); curContext.Response.AddHeader("Content-Disposition", "attachment;filename=" + strFilename); curContext.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=gb2312\"/>" + strWriter.ToString()); curContext.Response.Flush(); curContext.Response.End(); }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query DateTime _from = Master.FromDate; DateTime _to = Master.ToDate; string _client = Master.ClientNumber; string _clientName = Master.ClientName; string _div = Master.DivisionNumber; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _client, _div, _from.ToString("yyyy-MM-dd"), _to.ToString("yyyy-MM-dd") }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter div = new ReportParameter("ClientDivision", _div); ReportParameter from = new ReportParameter("StartPUDate", _from.ToString("yyyy-MM-dd")); ReportParameter to = new ReportParameter("EndPUDate", _to.ToString("yyyy-MM-dd")); ReportParameter clientName = new ReportParameter("ClientName", _clientName); report.SetParameters(new ReportParameter[] { client, div, from, to, clientName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=OnTimeByDay.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected override void Render(System.Web.UI.HtmlTextWriter writer) { base.Render(new RewriteForm(writer)); }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = this.cboClient.SelectedValue == "" ? null : this.cboClient.SelectedValue; DateTime _pustartdate = DateTime.Parse(this.txtFrom.Text); DateTime _puenddate = DateTime.Parse(this.txtTo.Text); //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = TITLE; report.EnableExternalImages = true; EnterpriseRGateway enterprise = new EnterpriseRGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, _pustartdate, _puenddate }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(SOURCE); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter pustartdate = new ReportParameter("PickupStartDate", _pustartdate.ToString("yyyy-MM-dd")); ReportParameter puenddate = new ReportParameter("PickupEndDate", _puenddate.ToString("yyyy-MM-dd")); report.SetParameters(new ReportParameter[] { client, pustartdate, puenddate }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=InboundTracking.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["STAFF_ID"])) { valObj = BLLTable <HR_STAFF> .Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, Request["STAFF_ID"]); if (valObj == null) { return; } txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal txtSTAFF_NO.Text = Convert.ToString(valObj.STAFF_NO);//Convert.ToString txtNAME.Text = Convert.ToString(valObj.STAFF_NAME);//Convert.ToString txtDEPT_ID.Text = Convert.ToString(valObj.DEPT_ID);//Convert.ToString txtGENDER.Text = valObj.GENDER.ToString(); txtPHOTO.Text = Convert.ToString(valObj.PHOTO);//Convert.ToString txtPOS_NAME.Text = Convert.ToString(valObj.POS_NAME);//Convert.ToString txtSTATION_CODE.Text = Convert.ToString(valObj.STATION_CODE);//Convert.ToString txtWORK_TYPE_CODE.Text = valObj.WORK_TYPE_CODE.ToString(); txtTECH_LEVEL_CODE.Text = Convert.ToString(valObj.TECH_LEVEL_CODE);//Convert.ToString txtYMD.Text = Convert.ToString(valObj.YMD);//Convert.ToString txtMOBILE.Text = Convert.ToString(valObj.MOBILE);//Convert.ToString txtOFFICE_TEL.Text = Convert.ToString(valObj.OFFICE_TEL);//Convert.ToString txtCERT_FLAG.Text = Convert.ToString(valObj.CERT_FLAG);//Convert.ToString txtFIXED_FLAG.Text = Convert.ToString(valObj.FIXED_FLAG);//Convert.ToString txtON_POS_FLAG.Text = Convert.ToString(valObj.ON_POS_FLAG);//Convert.ToString txtPROFESSION_CODE.Text = Convert.ToString(valObj.PROFESSION_CODE);//Convert.ToString txtPROFESSION_BGN_DATE.Text = Convert.ToString(valObj.PROFESSION_BGN_DATE);//Convert.ToString txtJOIN_DATE.Text = Convert.ToString(valObj.JOIN_DATE);//Convert.ToString txtPOLITICAL_STATUS_CODE.Text = Convert.ToString(valObj.POLITICAL_STATUS_CODE);//Convert.ToString txtTITLE_CODE.Text = Convert.ToString(valObj.TITLE_CODE);//Convert.ToString txtSTATUS_CODE.Text = Convert.ToString(valObj.STATUS_CODE);//Convert.ToString txtADDR.Text = Convert.ToString(valObj.ADDR);//Convert.ToString txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString txtNATION.Text = Convert.ToString(valObj.NATION);//Convert.ToString txtNATIVE_PLACE.Text = Convert.ToString(valObj.NATIVE_PLACE);//Convert.ToString txtPOST_NO.Text = Convert.ToString(valObj.POST_NO);//Convert.ToString txtDEGREE_CODE.Text = Convert.ToString(valObj.DEGREE_CODE);//Convert.ToString txtGRAD_SCHOOL.Text = Convert.ToString(valObj.GRAD_SCHOOL);//Convert.ToString txtGRAD_DATE.Text = Convert.ToString(valObj.GRAD_DATE);//Convert.ToString txtMAJOR.Text = Convert.ToString(valObj.MAJOR);//Convert.ToString txtADDTIME.Text = (valObj.AF_ADDTIME == DateTime.MinValue) ? "" : valObj.AF_ADDTIME.ToString("yyyy-MM-dd HH:mm"); txtEDITIME.Text = (valObj.AF_EDITTIME == DateTime.MinValue) ? "" : valObj.AF_EDITTIME.ToString("yyyy-MM-dd HH:mm"); txtREMARK.Text = Convert.ToString(valObj.REMARK);//Convert.ToString txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal } } catch (Exception ex) { litWarn.Text = ex.Message; } if (Request["ajax"] != null) { Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文 //Response.ContentType = "html/text"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); divC.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } } }
protected override void Render(System.Web.UI.HtmlTextWriter writer) { writer.Write("<table border=\"0\">"); SPUser currentUser = SPContext.Current.Web.CurrentUser; if (currentUser.IsSiteAdmin) { writer.Write("<tr><td><div class=\"UserSectionTitle\">PowerShell Script</div></td></tr>"); writer.Write("<tr>"); writer.Write("<td>"); writer.Write(string.Format(@"<a href id=""btnPopupScript"" value=""Script"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >Script ({1} rows)</a>", script.ClientID, String.IsNullOrEmpty(script.Value) ? "0" : (System.Text.RegularExpressions.Regex.Matches(script.Value, "\n").Count + 1).ToString())); script.RenderControl(writer); writer.Write("</td>"); writer.Write("</tr>"); writer.Write("<tr><td><div class=\"UserSectionHead\">Runas AppPool</div>"); runasAppPool.RenderControl(writer); writer.Write("</td></tr>"); } writer.Write("<tr><td><div class=\"UserSectionTitle\">Parameters</div></td></tr>"); //Parameter 1 if (currentUser.IsSiteAdmin || String.IsNullOrEmpty(parameterDescription1.Value) == false) { writer.Write("<tr><td><div class=\"UserSectionHead\">Parameter 1</div></td></tr>"); writer.Write("<tr>"); writer.Write("<td>"); parameterDescription1.RenderControl(writer); if (currentUser.IsSiteAdmin) { writer.Write(string.Format(@"<a id=""btnAddDescriptionParameter1"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >{1}</a>", parameterDescription1.ClientID, string.IsNullOrEmpty(parameterDescription1.Value) ? "add description" : parameterDescription1.Value)); } else { writer.Write(string.Format("<div>{0}</div>", parameterDescription1.Value)); } writer.Write("</td>"); writer.Write("</tr>"); writer.Write("<tr>"); writer.Write("<td>"); parameter1.RenderControl(writer); writer.Write("</td>"); writer.Write("</tr>"); } //Parameter 2 if (currentUser.IsSiteAdmin || String.IsNullOrEmpty(parameterDescription2.Value) == false) { writer.Write("<tr><td><div class=\"UserSectionHead\">Parameter 2</div></td></tr>"); writer.Write("<tr>"); writer.Write("<td>"); parameterDescription2.RenderControl(writer); if (currentUser.IsSiteAdmin) { writer.Write(string.Format(@"<a id=""btnAddDescriptionParameter2"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >{1}</a>", parameterDescription2.ClientID, string.IsNullOrEmpty(parameterDescription2.Value) ? "add description" : parameterDescription2.Value)); } else { writer.Write(string.Format("<div>{0}</div>", parameterDescription2.Value)); } writer.Write("</td>"); writer.Write("</tr>"); writer.Write("<tr>"); writer.Write("<td>"); parameter2.RenderControl(writer); writer.Write("</td>"); writer.Write("</tr>"); } //Parameter 3 if (currentUser.IsSiteAdmin || String.IsNullOrEmpty(parameterDescription3.Value) == false) { writer.Write("<tr><td><div class=\"UserSectionHead\">Parameter 3</div></td></tr>"); writer.Write("<tr>"); writer.Write("<td>"); parameterDescription3.RenderControl(writer); if (currentUser.IsSiteAdmin) { writer.Write(string.Format(@"<a id=""btnAddDescriptionParameter3"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >{1}</a>", parameterDescription3.ClientID, string.IsNullOrEmpty(parameterDescription3.Value) ? "add description" : parameterDescription3.Value)); } else { writer.Write(string.Format("<div>{0}</div>", parameterDescription3.Value)); } writer.Write("</td>"); writer.Write("</tr>"); writer.Write("<tr>"); writer.Write("<td>"); parameter3.RenderControl(writer); writer.Write("</td>"); writer.Write("</tr>"); } //Parameter 4 if (currentUser.IsSiteAdmin || String.IsNullOrEmpty(parameterDescription4.Value) == false) { writer.Write("<tr><td><div class=\"UserSectionHead\">Parameter 4</div></td></tr>"); writer.Write("<tr>"); writer.Write("<td>"); parameterDescription4.RenderControl(writer); if (currentUser.IsSiteAdmin) { writer.Write(string.Format(@"<a id=""btnAddDescriptionParameter1"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >{1}</a>", parameterDescription4.ClientID, string.IsNullOrEmpty(parameterDescription4.Value) ? "add description" : parameterDescription4.Value)); } else { writer.Write(string.Format("<div>{0}</div>", parameterDescription4.Value)); } writer.Write("</td>"); writer.Write("</tr>"); writer.Write("<tr>"); writer.Write("<td>"); parameter4.RenderControl(writer); writer.Write("</td>"); writer.Write("</tr>"); } writer.Write("</table>"); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["USER_ID"])) { valObj = BLLTable <SYS_USER> .Factory(conn).GetRowData(SYS_USER.Attribute.USER_ID, Request["USER_ID"]); if (valObj == null) { return; } txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal txtUSER_NAME.Text = Convert.ToString(valObj.USER_NAME);//Convert.ToString txtPASS.Text = Convert.ToString(valObj.PASS);//Convert.ToString txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString txtLOGIN_IPS.Text = Convert.ToString(valObj.LOGIN_IPS);//Convert.ToString txtSTATE_FLAG.Text = valObj.USE_FLAG.ToString(); txtEDITIME.Text = (valObj.EDITTIME == DateTime.MinValue) ? "" : valObj.EDITTIME.ToString("yyyy-MM-dd HH:mm"); txtADDTIME.Text = (valObj.ADDTIME == DateTime.MinValue) ? "" : valObj.ADDTIME.ToString("yyyy-MM-dd HH:mm"); txtUSER_TYPE.Text = valObj.USER_TYPE.ToString(); } } catch (Exception ex) { litWarn.Text = ex.Message; } if (Request["ajax"] != null) { Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文 //Response.ContentType = "html/text"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); divC.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _fromDate = DateTime.Parse(this.txtFrom.Text).ToString("yyyy-MM-dd"); string _toDate = DateTime.Parse(this.txtTo.Text).ToString("yyyy-MM-dd"); string _client = this.grdClients.SelectedRow.Cells[1].Text; string _div = this.grdClients.SelectedRow.Cells[2].Text; string _clientName = this.grdClients.SelectedRow.Cells[3].Text; string _shipper = "", _shipperName = ""; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = TITLE; report.EnableExternalImages = true; EnterpriseRGateway enterprise = new EnterpriseRGateway(); DataSet ds = new DataSet(); string usp = "", reportDS = "", reportFile = ""; if (this.ddlFreightType.SelectedValue.ToLower() == "tsort") { usp = USP_REPORT_VENDOR; reportDS = REPORT_DS_TSORT; switch (this.cboViewBy.SelectedItem.Text.ToLower()) { case "state": reportFile = REPORT_SRC_TSORT_STATE; break; case "zone": reportFile = REPORT_SRC_TSORT_ZONE; break; case "store": reportFile = REPORT_SRC_TSORT_STORE; break; } } else if (this.ddlFreightType.SelectedValue.ToLower() == "returns") { usp = USP_REPORT_AGENT; reportDS = REPORT_DS_RETURNS; switch (this.cboViewBy.SelectedItem.Text.ToLower()) { case "vendor": reportFile = REPORT_SRC_RETURNS_VENDOR; break; case "store": reportFile = REPORT_SRC_RETURNS_STORE; break; } } foreach (GridViewRow row in selectedShippers) { string __shipper = row.Cells[1].Text; _shipper = _shipper.Length == 0 ? __shipper : _shipper + ", " + __shipper; DataSet _ds = enterprise.FillDataset(usp, mTBLName, new object[] { _client, _div, __shipper, _fromDate, _toDate }); ds.Merge(_ds); } if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(reportFile); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter fromDate = new ReportParameter("StartPUDate", _fromDate); ReportParameter toDate = new ReportParameter("EndPUDate", _toDate); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter div = new ReportParameter("ClientDivision", _div); ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter shipper = new ReportParameter(this.ddlShipper.SelectedValue == "0" ? "VendorNumber" : "AgentNumber", _shipper); ReportParameter shipperName = new ReportParameter(this.ddlShipper.SelectedValue == "0" ? "VendorName" : "AgentName", _shipperName); report.SetParameters(new ReportParameter[] { client, div, fromDate, toDate, clientName, shipper, shipperName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, reportDS)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=Discrepancy.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
public override void RenderControl(System.Web.UI.HtmlTextWriter writer) { if (this.DesignMode) { base.RenderControl(writer); } else { Panel outerDiv = new Panel(); outerDiv.ID = ClientID; outerDiv.CssClass = this.CssClass; outerDiv.ApplyStyle(ControlStyle); if (tabs == null) { tabs = CreateTabs(); tabs.CreateStyle(Page, "#" + ClientID + " ul." + ClientID); } outerDiv.Controls.Add(tabs); /* * Dim lClear As New Literal * lClear.Text = "<div style=""clear:both""></div>" * outerDiv.Controls.Add(lClear) */ Panel innerDiv = new Panel(); innerDiv.CssClass = "container"; TabView view = GetCurrentView(); if (view != null) { innerDiv.ApplyStyle(view.ControlStyle); innerDiv.Style["border-top"] = "0 !important"; if (view.ControlStyle.BorderStyle == BorderStyle.None || view.ControlStyle.BorderStyle == BorderStyle.NotSet) { innerDiv.BorderStyle = TabBorderStyle; innerDiv.BorderWidth = TabBorderWidth; innerDiv.BorderColor = TabBorderColor; } //padding: top right bottom left if (!ContainerPaddingLeft.IsEmpty) { innerDiv.Style["padding-left"] = ContainerPaddingLeft.ToString(); } if (!ContainerPaddingRight.IsEmpty) { innerDiv.Style["padding-right"] = ContainerPaddingLeft.ToString(); } if (!ContainerPaddingTop.IsEmpty) { innerDiv.Style["padding-top"] = ContainerPaddingLeft.ToString(); } if (!ContainerPaddingBottom.IsEmpty) { innerDiv.Style["padding-bottom"] = ContainerPaddingLeft.ToString(); } } innerDiv.ScrollBars = ScrollBars.Auto; if (!outerDiv.Height.IsEmpty) { innerDiv.Height = new Unit(outerDiv.Height.Value - tabs.RealHeight.Value, UnitType.Pixel); outerDiv.Height = Unit.Empty; } /* * If outerDiv.Height.IsEmpty Then * If innerDiv.Height.IsEmpty Then * innerDiv.Height = New Unit(200 - tabs.RealHeight.Value, UnitType.Pixel) * End If * Else * innerDiv.Height = New Unit(outerDiv.Height.Value - tabs.RealHeight.Value, UnitType.Pixel) * End If */ Literal l = new Literal(); l.Text = "{0}"; innerDiv.Controls.Add(l); outerDiv.Controls.Add(innerDiv); System.IO.StringWriter htmlSW = new System.IO.StringWriter(); HtmlTextWriter html32 = new HtmlTextWriter(htmlSW); outerDiv.RenderControl(html32); string html = htmlSW.ToString(); writer.WriteLine(html.Substring(0, html.IndexOf("{0}"))); base.RenderControl(writer); writer.WriteLine(html.Substring(html.IndexOf("{0}") + 3)); } }
private void @__Render__control1(System.Web.UI.HtmlTextWriter @__w, System.Web.UI.Control parameterContainer) { @__w.Write("\r\n\r\n<link href=\"../_layouts/15/LeaveApplication/StyleSheet.css\" rel=\"stylesheet\" " + "/>\r\n\r\n\r\n"); System.Data.DataTable result = ViewState["Result"] as System.Data.DataTable; if (result != null && result.Rows.Count > 0) { @__w.Write(@" <div class=""Container""> <table> <tr class=""header""> <th colspan=""4""><h3 class=""font"">Leave Information</h3></th></tr> <tr class=""header""> <th class=""font""> Leave Type </th> <th class=""font""> Leave Balance </th> <th class=""font""> Leave Requested </th> <th class=""font""> Leave Utilized </th> </tr> "); foreach (System.Data.DataRow row in result.Rows) { @__w.Write("\r\n <tr class=\"data\">\r\n <td>\r\n "); @__w.Write(row["Leave Type"].ToString()); @__w.Write("\r\n </td>\r\n <td>\r\n "); @__w.Write(row["Balance Leave"].ToString()); @__w.Write("\r\n </td>\r\n <td>\r\n "); @__w.Write(row["Leave Requested"].ToString()); @__w.Write("\r\n </td>\r\n <td>\r\n "); @__w.Write(row["Leave utilized"].ToString()); @__w.Write("\r\n </td>\r\n </tr>\r\n "); } @__w.Write("\r\n </table>\r\n</div>\r\n"); } else { @__w.Write("\r\n<div class=\"Container\">\r\n <table>\r\n <tr class=\"data\">\r\n <t" + "d colspan=\"2\">\r\n "); parameterContainer.Controls[0].RenderControl(@__w); @__w.Write("\r\n </td>\r\n </tr>\r\n <tr class=\"header\">\r\n <th>" + "\r\n There is no records.\r\n </th>\r\n </tr>\r\n </" + "table>\r\n</div>\r\n"); } @__w.Write("<br />\r\n<br />\r\n\r\n"); parameterContainer.Controls[1].RenderControl(@__w); @__w.Write("\r\n"); parameterContainer.Controls[2].RenderControl(@__w); }
/// <summary> /// Renders the controls. /// </summary> /// <param name="parentControl">The parent control.</param> /// <param name="writer">The writer.</param> /// <param name="controls">The controls.</param> public override void RenderControls(System.Web.UI.Control parentControl, System.Web.UI.HtmlTextWriter writer, System.Web.UI.Control[] controls) { base.RenderControls(parentControl, writer, controls); }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = Master.ClientNumber; string _division = Master.Division; string _agent = Master.AgentNumber; string _region = Master.Region; string _district = Master.District; string _store = Master.StoreNumber; int _isException = this.chkExceptionsOnly.Checked ? 1 : 0; string _start = Master.StartDate; string _end = Master.EndDate; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _client, _division, _agent, _region, _district, _store, _start, _end, _isException }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter clientName = new ReportParameter("ClientName", Master.ClientName); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter division = new ReportParameter("Division", _division); ReportParameter agent = new ReportParameter("AgentNumber"); if (_agent != null) { agent.Values.Add(_agent); } ReportParameter region = new ReportParameter("Region"); if (_region != null) { region.Values.Add(_region); } ReportParameter district = new ReportParameter("District"); if (_district != null) { district.Values.Add(_district); } ReportParameter store = new ReportParameter("StoreNumber"); if (_store != null) { store.Values.Add(_store); } ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); ReportParameter isException = new ReportParameter("IsExceptionOnly", _isException.ToString()); report.SetParameters(new ReportParameter[] { client, division, agent, region, district, store, start, end, isException, clientName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=ScanningDetailByStore.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = Master.ClientNumber; string _division = Master.Division; string _agentnumber = Master.AgentNumber; string _subagentnumber = Master.SubAgentNumber; string _region = Master.Region; string _district = Master.District; string _store = Master.StoreNumber; string _start = Master.StartDate; string _end = Master.EndDate; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, _division, _agentnumber, _subagentnumber, _region, _district, _store, _start, _end }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter clientName = new ReportParameter("ClientName", Master.ClientName); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter division = new ReportParameter("Division", _division); ReportParameter agentnumber = new ReportParameter("AgentParentNumber", _agentnumber); ReportParameter subagentnumber = new ReportParameter("AgentNumber", _subagentnumber); ReportParameter region = new ReportParameter("Region"); if (_region != null) { region.Values.Add(_region); } ReportParameter district = new ReportParameter("District"); if (_district != null) { district.Values.Add(_district); } ReportParameter store = new ReportParameter("StoreNumber"); if (_store != null) { store.Values.Add(_store); } ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); report.SetParameters(new ReportParameter[] { client, division, agentnumber, subagentnumber, region, district, store, start, end, clientName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=OnTimeDeliverySummaryByAgent.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
/// <summary> /// Renders the control to the specified HTML writer. /// </summary> /// <param name="writer">The <see cref="T:System.Web.UI.HtmlTextWriter" /> object that receives the control content.</param> protected override void Render(System.Web.UI.HtmlTextWriter writer) { ControlHelper.EnsureCssClassPresent(this, "form-group"); InputSizesHelper.EnsureSizeClassPresent(this, this.InputSize, "form-group-"); base.Render(writer); }
protected override void RenderContents(System.Web.UI.HtmlTextWriter writer) { }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _fromDate = this.ddpPickups.FromDate.ToString("yyyy-MM-dd"); string _toDate = this.ddpPickups.ToDate.ToString("yyyy-MM-dd"); string _client = this.dgdClientShipper.ClientNumber; string _div = this.dgdClientShipper.ClientDivsionNumber; string _clientName = this.dgdClientShipper.ClientName; string _shipper = this.dgdClientShipper.ShipperNumber; string _shipperName = this.dgdClientShipper.ShipperName; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(); string reportFile = "", reportDS = ""; if (this.cboFreightType.SelectedValue == "0") { //Tsort- set dataset and report types reportDS = REPORT_DS_TSORT; switch (this.cboViewBy.SelectedItem.Text) { case "State": reportFile = REPORT_SRC_TSORT_STATE; break; case "Zone": reportFile = REPORT_SRC_TSORT_ZONE; break; case "Store": reportFile = REPORT_SRC_TSORT_STORE; break; } ds = enterprise.FillDataset(USP_REPORT_VENDOR, TBL_REPORT, new object[] { _client, _div, _shipper, _fromDate, _toDate }); } else if (this.cboFreightType.SelectedValue == "1") { //Returns- set dataset and report types reportDS = REPORT_DS_RETURNS; switch (this.cboViewBy.SelectedItem.Text) { case "Vendor": reportFile = REPORT_SRC_RETURNS_VENDOR; break; case "Store": reportFile = REPORT_SRC_RETURNS_STORE; break; } ds = enterprise.FillDataset(USP_REPORT_AGENT, TBL_REPORT, new object[] { _client, _div, _shipper, _fromDate, _toDate }); } if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(reportFile); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter fromDate = new ReportParameter("StartPUDate", _fromDate); ReportParameter toDate = new ReportParameter("EndPUDate", _toDate); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter div = new ReportParameter("ClientDivision", _div); ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter shipper = new ReportParameter((this.dgdClientShipper.FreightType == FreightType.Regular ? "VendorNumber" : "AgentNumber"), _shipper); ReportParameter shipperName = new ReportParameter((this.dgdClientShipper.FreightType == FreightType.Regular ? "VendorName" : "AgentName"), _shipperName); report.SetParameters(new ReportParameter[] { client, div, fromDate, toDate, clientName, shipper, shipperName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, reportDS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=Discrepancy.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected override void Render(System.Web.UI.HtmlTextWriter writer) { base.Render(writer); writer.Write(ScriptHelper.GetScript(macroEditor.Editor.GetValueSetterCommand("wopener.getNestedControlValue('" + selectorId + "')"))); }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _date = this.ddpPickups.ToDate.ToString("yyyy-MM-dd"); string _terminal = this.cboTerminal.SelectedValue; string _terminalName = this.cboTerminal.SelectedItem.Text; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _terminal, _date, }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter terminalID = new ReportParameter("TerminalID", _terminal); ReportParameter terminal = new ReportParameter("TerminalName", _terminalName); ReportParameter date = new ReportParameter("SortDate", _date); report.SetParameters(new ReportParameter[] { terminalID, date, terminal }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=DamagedCartons.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["ID"])) { valObj = BLLTable <WEC_ACTIVITY_SNCODE> .GetRowData(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["ID"]); if (valObj == null) { return; } txtID.Text = Convert.ToString(valObj.ID);//Convert.ToDecimal txtSN_CODE.Text = Convert.ToString(valObj.SN_CODE);//Convert.ToString txtAWARD_TYPE.Text = Convert.ToString(valObj.AWARD_TYPE);//Convert.ToString txtSTATUS.Text = valObj.STATUS.ToString(); txtPHONE.Text = Convert.ToString(valObj.PHONE);//Convert.ToString txtWX_CODE.Text = Convert.ToString(valObj.WX_CODE);//Convert.ToString txtZJ_TIME.Text = (valObj.ZJ_TIME == DateTime.MinValue) ? "" : valObj.ZJ_TIME.ToString("yyyy-MM-dd HH:mm"); txtSY_TIME.Text = (valObj.SY_TIME == DateTime.MinValue) ? "" : valObj.SY_TIME.ToString("yyyy-MM-dd HH:mm"); txtA_ID.Text = Convert.ToString(valObj.A_ID);//Convert.ToDecimal } } catch (Exception ex) { litWarn.Text = ex.Message; } if (Request["ajax"] != null) { Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文 //Response.ContentType = "html/text"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); divC.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _fromDate = this.ddpPickups.FromDate.ToString("yyyy-MM-dd"); string _toDate = this.ddpPickups.ToDate.ToString("yyyy-MM-dd"); string _client = this.dgdClientVendor.ClientNumber; string _div = (this.chkAllDivs.Checked) ? null : this.dgdClientVendor.ClientDivsionNumber; string _clientName = this.dgdClientVendor.ClientName; string _vendor = this.dgdClientVendor.VendorNumber; string _vendorName = this.dgdClientVendor.VendorName; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(); string reportFile = "", reportDS = "", usp = ""; switch (this.cboType.SelectedItem.Text) { case "Over": reportFile = REPORT_SRC_OVER; reportDS = REPORT_DS_OVER; usp = USP_REPORT_OVER; break; case "Short": reportFile = REPORT_SRC_SHORT; reportDS = REPORT_DS_SHORT; usp = USP_REPORT_SHORT; break; } ds = enterprise.FillDataset(usp, mTBLName, new object[] { _fromDate, _toDate, _vendor, _client, _div }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(reportFile); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter fromDate = new ReportParameter("Startdate", _fromDate); ReportParameter toDate = new ReportParameter("EndDate", _toDate); ReportParameter client = new ReportParameter("ClientNumber", _client + "-" + (_div == null?"All":_div) + " " + _clientName); ReportParameter div = new ReportParameter("DivisionNumber", (_div == null?"All":_div)); ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter vendor = new ReportParameter("VendorNumber", _vendor + " " + _vendorName); ReportParameter vendorName = new ReportParameter("VendorName", _vendorName); report.SetParameters(new ReportParameter[] { fromDate, toDate, vendor, client, div }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, reportDS)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=TimePeriodCartonCompare.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _clientName = this.dgdClientVendor.ClientName; string _pickupID = "", _termCode = ""; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = TITLE; report.EnableExternalImages = true; EnterpriseRGateway enterprise = new EnterpriseRGateway(); DataSet ds = new DataSet(this.mDSName); foreach (GridViewRow row in SelectedRows) { DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex]; _pickupID += (_pickupID.Length > 0 ? ", " : "") + dataKey["PickupID"].ToString(); _termCode = dataKey["TerminalCode"].ToString(); DataSet _ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { dataKey["TerminalCode"].ToString(), dataKey["PickupID"].ToString() }); ds.Merge(_ds); } if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(SOURCE); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter puID = new ReportParameter("PickupID", _pickupID); ReportParameter termCode = new ReportParameter("TerminalCode", _termCode); ReportParameter store = new ReportParameter("StoreNumber", this.txtStore.Text.Trim().Length > 0 ? this.txtStore.Text.Trim() : null); ReportParameter zone = new ReportParameter("ZoneCode", this.txtZone.Text.Trim().Length > 0 ? this.txtZone.Text.Trim().PadRight(2) : null); report.SetParameters(new ReportParameter[] { termCode, puID, clientName, store, zone }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=ASNTracking.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string dates = this.cboDateValue.SelectedValue; string _start = dates.Split(':')[0].Trim(); string _end = dates.Split(':')[1].Trim(); int _delivDays = Convert.ToInt32(this.cboDelivDays.Text); string _locType = this.cboLocType.Text; string _vendor = this.cboCustomer.SelectedValue; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _start, _end, _delivDays, _locType, _vendor }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); ReportParameter delivDays = new ReportParameter("DeliveryDays", _delivDays.ToString()); ReportParameter locType = new ReportParameter("LocationType", _locType); report.SetParameters(new ReportParameter[] { start, end, delivDays, locType }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=BNConsumerDirectCartonDetail.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; report.EnableHyperlinks = true; EnterpriseService enterprise = new EnterpriseService(); DataSet ds = new DataSet(this.mDSName); foreach (GridViewRow row in SelectedRows) { DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex]; DataSet _ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { dataKey["PickupID"].ToString() }); ds.Merge(_ds); } if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.SetParameters(new ReportParameter[] { new ReportParameter("PickupID", "0") }); report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName, "RGXVMSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=LOccitaneCartonInfo.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex, 4); } }
private void Inicializar() { if (this.Request.QueryString["Tipo"] == "SinAgrupar") { DsGuiasSeguimientoAdm ds = (DsGuiasSeguimientoAdm)Session["DsGuiasSeguimientoConsul"]; Head = new string[ds.Datos.Columns.Count]; Col = new string[ds.Datos.Columns.Count]; int i = 0; for (i = 1; i < 22 /*< ds.Datos.Columns.Count*/; i++) { Head[i] = ds.Datos.Columns[i].ColumnName; Col[i] = ds.Datos.Columns[i].ColumnName; //i++; } Title = "Seguimiento de guías - " + DateTime.Today.ToString("dd/MM/yyyy"); Datos = ds.Tables[0]; CustomExport(); } else if (this.Request.QueryString["Tipo"] == "AgrupaAgOri") { DataSet ds = (DataSet)Session["DsSeguimHG"]; DataTable datos = ds.Tables[0]; Head = new string[ds.Tables[1].Columns.Count]; Col = new string[ds.Tables[1].Columns.Count]; int i = 0; for (i = 1; i < 22 /*< ds.Datos.Columns.Count*/; i++) { Head[i] = ds.Tables[1].Columns[i].ColumnName; Col[i] = ds.Tables[1].Columns[i].ColumnName; //i++; } this.lblTitAgOri.Text = "Seguimiento de guías Agrupado por Agencia origen"; this.EnableViewState = false; AgenciaOrigenList.DataSource = ds.Tables[0]; AgenciaOrigenList.DataBind(); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.Charset = ""; Response.ContentEncoding = System.Text.Encoding.Default; Response.AddHeader("Content-Disposition", "filename=GuiasSeguimientoConsul.xls"); CreateHeader(); CreateTitle(); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.tblAgrupaAgOri.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } else if (this.Request.QueryString["Tipo"] == "AgrupaAgDst") { DataSet ds = (DataSet)Session["DsSeguimHG"]; DataTable datos = ds.Tables[0]; Head = new string[ds.Tables[1].Columns.Count]; Col = new string[ds.Tables[1].Columns.Count]; int i = 0; for (i = 1; i < 22 /*< ds.Datos.Columns.Count*/; i++) { Head[i] = ds.Tables[1].Columns[i].ColumnName; Col[i] = ds.Tables[1].Columns[i].ColumnName; //i++; } this.lblTitAgDest.Text = "Seguimiento de guías Agrupado por Agencia Destino"; this.EnableViewState = false; AgenciaDestinoList.DataSource = ds.Tables[0]; AgenciaDestinoList.DataBind(); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.Charset = ""; Response.ContentEncoding = System.Text.Encoding.Default; Response.AddHeader("Content-Disposition", "filename=GuiasSeguimientoConsul.xls"); CreateHeader(); CreateTitle(); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.tblAgenciaDestino.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } else if (this.Request.QueryString["Tipo"] == "AgrupaUVenta") { DataSet ds = (DataSet)Session["DsSeguimHG"]; DataTable datos = ds.Tables[0]; Head = new string[ds.Tables[1].Columns.Count]; Col = new string[ds.Tables[1].Columns.Count]; int i = 0; for (i = 1; i < 22 /*< ds.Datos.Columns.Count*/; i++) { Head[i] = ds.Tables[1].Columns[i].ColumnName; Col[i] = ds.Tables[1].Columns[i].ColumnName; //i++; } this.lblTitUV.Text = "Seguimiento de guías Agrupado por Unidad de Venta"; this.EnableViewState = false; UnidadVentaList.DataSource = ds.Tables[0]; UnidadVentaList.DataBind(); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.Charset = ""; Response.ContentEncoding = System.Text.Encoding.Default; Response.AddHeader("Content-Disposition", "filename=GuiasSeguimientoConsul.xls"); CreateHeader(); CreateTitle(); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.tblUnidadVenta.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } else if (this.Request.QueryString["Tipo"] == "AgrupaGuia") { DataSet ds = (DataSet)Session["DsSeguimHG"]; DataTable datos = ds.Tables[0]; Head = new string[5 /*ds.Tables[1].Columns.Count*/]; Col = new string[5 /*ds.Tables[1].Columns.Count*/]; /*int i = 0; * for(i=1; i < 4 ;i++) * { * Head[i] = ds.Tables[1].Columns[i].ColumnName; * Col[i] = ds.Tables[1].Columns[i].ColumnName; * //i++; * }*/ Head[0] = ds.Tables[1].Columns[2].ColumnName; Head[1] = ds.Tables[1].Columns[8].ColumnName; Head[2] = ds.Tables[1].Columns[9].ColumnName; Head[3] = ds.Tables[1].Columns[10].ColumnName; Head[4] = ds.Tables[1].Columns[7].ColumnName; Col[0] = ds.Tables[1].Columns[2].ColumnName; Col[1] = ds.Tables[1].Columns[8].ColumnName; Col[2] = ds.Tables[1].Columns[9].ColumnName; Col[3] = ds.Tables[1].Columns[10].ColumnName; Col[4] = ds.Tables[1].Columns[7].ColumnName; this.lblTitGuiaHis.Text = "Seguimiento de guías Agrupado por Históricos de guía."; this.EnableViewState = false; GuiaHisList.DataSource = ds.Tables[0]; GuiaHisList.DataBind(); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.Charset = ""; Response.ContentEncoding = System.Text.Encoding.Default; Response.AddHeader("Content-Disposition", "filename=GuiasSeguimientoConsul.xls"); CreateHeader(); CreateTitle(); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.tblGuiaHistorico.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _start = Master.FromDate.ToString("yyyy-MM-dd"); string _end = Master.ToDate.ToString("yyyy-MM-dd"); string _client = Master.ClientNumber; string _vendor = Master.VendorNumber; string _vendorLoc = Master.VendorLocationNumber; string _agent = Master.AgentNumber; string _agentLoc = Master.AgentLocationNumber; string _cutoffTime = DateTime.Now.ToString("yyyy-MM-dd"); //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _start, _end, _agentLoc, _agent, _client, _vendorLoc, _vendor, _cutoffTime }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); ReportParameter client = new ReportParameter("ClientNumber"); if (_client != null) { client.Values.Add(Master.ClientNumber + "- " + Master.ClientName); } ReportParameter vendor = new ReportParameter("VendorParentNumber"); if (_vendor != null) { vendor.Values.Add(Master.VendorName); } ReportParameter vendorLoc = new ReportParameter("VendorNumber"); if (_vendorLoc != null) { vendorLoc.Values.Add(Master.VendorName); } ReportParameter agent = new ReportParameter("AgentParentNumber"); if (_agent != null) { agent.Values.Add(Master.AgentName); } ReportParameter agentLoc = new ReportParameter("AgentNumber"); if (_agentLoc != null) { agentLoc.Values.Add(Master.AgentName); } ReportParameter cutoffTime = new ReportParameter("CutOFFTime", _cutoffTime); report.SetParameters(new ReportParameter[] { start, end, agent, agentLoc, client, vendor, vendorLoc, cutoffTime }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=ScanningSummaryByStore.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
private void @__Render__control1(System.Web.UI.HtmlTextWriter @__w, System.Web.UI.Control parameterContainer) { @__w.Write("\r\n\r\n<link rel=\"stylesheet\" href=\"../../_layouts/15/PagerStyle.css\" />\r\n<style typ" + "e=\"text/css\">\r\n .btn { font:14px \'Noto Sans\', \'Helvetica Neue\', Helvetica, Ar" + "ial, sans-serif !important; }\r\n .cDateBox { width:100px; }\r\n .rpsForm{text" + "-align:left;}\r\n</style>\r\n\r\n<script type=\"text/javascript\" src=\"../../_layouts/15" + "/MultiOperacion/Operacion.js\"></script>\r\n<script type=\"text/javascript\">\r\n do" + "cument.onkeydown = function () {\r\n if (window.event && (window.event.keyC" + "ode == 109 || window.event.keyCode == 56)) {\r\n window.event.keyCode =" + " 505;\r\n }\r\n\r\n if (window.event.keyCode == 505) {\r\n retu" + "rn false;\r\n }\r\n\r\n if (window.event && (window.event.keyCode == 13)" + ") {\r\n valor = document.activeElement.value;\r\n if (valor ==" + " undefined) { return false; } //Evita Enter en página. \r\n else {\r\n " + " if (document.activeElement.getAttribute(\'type\') == \'select-one\')\r\n " + " { return false; } //Evita Enter en select. \r\n if (" + "document.activeElement.getAttribute(\'type\') == \'button\')\r\n { retu" + "rn false; } //Evita Enter en button. \r\n if (document.activeElemen" + "t.getAttribute(\'type\') == \'radio\')\r\n { return false; } //Evita En" + "ter en radio. \r\n if (document.activeElement.getAttribute(\'type\') " + "== \'checkbox\')\r\n { return false; } //Evita Enter en checkbox. \r\n " + " if (document.activeElement.getAttribute(\'type\') == \'file\')\r\n " + " { return false; } //Evita Enter en file. \r\n if (docume" + "nt.activeElement.getAttribute(\'type\') == \'reset\')\r\n { return fals" + "e; } //Evita Enter en reset. \r\n if (document.activeElement.getAtt" + "ribute(\'type\') == \'submit\')\r\n { return false; } //Evita Enter en " + "submit. \r\n if (document.activeElement.getAttribute(\'type\') == \'in" + "put\')\r\n { return false; } //Evita Back en input. \r\n " + " else //Text, textarea o password \r\n {\r\n if (" + "document.activeElement.value.length == 0)\r\n\r\n { return false;" + " } //No realiza el backspace(largo igual a 0). \r\n }\r\n\r\n " + " if (document.getElementById(\'"); @__w.Write(txtNCertificado.ClientID); @__w.Write("\').val != \'\' && document.getElementById(\'"); @__w.Write(txtRUT.ClientID); @__w.Write("\').val != \'\' && document.getElementById(\'"); @__w.Write(txtRazonSocial.ClientID); @__w.Write("\').val != \'\') {\r\n document.getElementById(\'"); @__w.Write(btnBuscar.ClientID); @__w.Write(@"').click(); } } } } function MantenSesion() { SP.SOD.execute('sp.ui.dialog.js', 'SP.UI.ModalDialog.showWaitScreenWithNoClose', 'Por Favor Espere...', 'actualizando su solicitud', 120, 550); __doPostBack('', ''); return false; } setInterval(""MantenSesion()"", (1200000)); </script> "); parameterContainer.Controls[0].RenderControl(@__w); @__w.Write("\r\n\r\n"); parameterContainer.Controls[1].RenderControl(@__w); @__w.Write("\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n"); }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = this.dgdClientVendor.ClientNumber; string _div = this.dgdClientVendor.ClientDivsionNumber; string _clientName = this.dgdClientVendor.ClientName; string _pickupIDs = "", _vendor = "", _pudate = "", _punum = "", _pickups = ""; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(REPORT_DS); foreach (GridViewRow row in SelectedRows) { DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex]; _pickupIDs += (_pickupIDs.Length > 0 ? "," : "") + dataKey["PickupID"].ToString(); _vendor = dataKey["VendorNumber"].ToString(); _pudate = DateTime.Parse(dataKey["PUDate"].ToString()).ToString("MM/dd"); _punum = dataKey["PUNumber"].ToString(); _pickups += (_pickups.Length > 0 ? ", " : "") + _vendor + "-" + _pudate + "-" + _punum; //_pickupIDs += (_pickupIDs.Length > 0 ? "," : "") + dataKey["PickupID"].ToString(); OnExportReport() } DataSet _ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _pickupIDs }); ds.Merge(_ds); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter div = new ReportParameter("ClientDivision", _div); ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter pickups = new ReportParameter("Pickups", _pickups); report.SetParameters(new ReportParameter[] { client, div, clientName, pickups }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=MultiPickupDiscrepancy.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void Page_Load(object sender, System.EventArgs e) { try { // Put user code to initialize the page here DataSet dsExport = (DataSet)Session["MyDataSet"]; if (dsExport == null) { Response.Write("Your session has timed out. Please re-submit the page"); return; } DataView dv = dsExport.Tables[0].DefaultView; string erpt = (string)Session["MyReportType"]; string csrs = (string)Session["CSRs"]; Page.EnableViewState = false; //Turn off the view state. System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); hw.Write("<HTML><HEAD> <title>Sales & Service Payment Tool</title>"); hw.Write("<link rel=stylesheet type=text/css href=../style.css>"); //PT.Ch1 - START: Added by COGNIZANT - 7/02/2008 - To enable default printing of the Print Version hw.Write("<script language=javascript>"); hw.Write("window.print();"); hw.Write("</script>"); //PT.Ch1 - END hw.Write("</HEAD>"); hw.Write("<body>"); tblHeader.RenderControl(hw); hw.Write("<table width=606 bgcolor=LightYellow class=arial_12>"); hw.Write("<tr><td colspan=2><b>"); hw.Write(Session["RptTitle"]); hw.Write("</b></td></tr>"); hw.Write("<tr><td colspan=2> </td></tr>"); hw.Write("<tr><td>"); hw.Write("<b>Run Date:</b>"); hw.Write("</td><td>"); //TimeZoneChange.Ch2-Added Text MST Arizona at the end of the current date and time and DateRange by cognizant. hw.Write(DateTime.Now.ToString() + " " + "MST Arizona"); hw.Write("</td></tr>"); hw.Write("<tr><td>"); hw.Write("<b>Date Range:</b>"); hw.Write("</td><td>"); //TimeZoneChange.Ch2-Added Text MST Arizona at the end of the current date and time and DateRange by cognizant. hw.Write(Session["DateRange"] + " " + "MST Arizona"); hw.Write("</td></tr>"); //Code Added by Cognizant for Payment Type hw.Write("<tr><td>"); hw.Write("<b>Payment Type:</b>"); hw.Write("</td><td>"); hw.Write(Session["PaymentName"]); hw.Write("</td></tr>"); //Code Added by Cognizant for Payment Type if (csrs != String.Empty) { hw.Write("<tr><td>"); hw.Write("<b>Users:</b>"); hw.Write("</td><td>"); hw.Write(Session["CSRs"]); hw.Write("</td></tr>"); } hw.Write("</table>"); if (erpt == "4" || erpt == "10") { dgGrid.DataSource = dv; dgGrid.DataBind(); dgGrid.RenderControl(hw); } else if (erpt == "5" || erpt == "11") { dgGrid1.DataSource = dv; dgGrid1.DataBind(); dgGrid1.RenderControl(hw); } else { dgGrid2.DataSource = dv; dgGrid2.DataBind(); dgGrid2.RenderControl(hw); } hw.Write("</body></html>"); Response.Write(tw.ToString()); //Write the HTML back to the browser. Response.End(); } catch (Exception ex) { Logger.Log(ex); //Response.Write("Please try clicking the submit button and loading the report again. If that doesn't work , try closing the browser and run the report again."); //throw; } }
/// <summary> /// 数据导出到Excel /// </summary> /// <returns></returns> private void OutputDataToExcle(string strFilename) { string sWhereSQL = " "; if (SysClass.SysUserSalary.UserSalary_SignStatus != "-1") { sWhereSQL += " And SignStatus=" + SysClass.SysUserSalary.UserSalary_SignStatus; } if (SysClass.SysUserSalary.UserSalary_UserSalaryOpCode.Length > 0) { sWhereSQL += " And a.OpCode = '" + SysClass.SysUserSalary.UserSalary_UserSalaryOpCode + "'"; } //月份起始和月份结束同时不为空时,按区间查找数据 if (SysClass.SysUserSalary.UserSalary_SearchText.Length > 0 && SysClass.SysUserSalary.UserSalary_SearchText2.Length > 0) { sWhereSQL += " And a.SalaryYears >= '" + SysClass.SysUserSalary.UserSalary_SearchText + "'"; if (SysClass.SysUserSalary.UserSalary_ImportRecIndex > 0) { sWhereSQL += " And a.SalaryDate>='" + SysClass.SysUserSalary.UserSalary_ImportRecText + "'"; } sWhereSQL += " And a.SalaryYears <= '" + SysClass.SysUserSalary.UserSalary_SearchText2 + "'"; if (SysClass.SysUserSalary.UserSalary_ImportRecIndex2 > 0) { sWhereSQL += " And a.SalaryDate <= DateAdd(mi,3,'" + SysClass.SysUserSalary.UserSalary_ImportRecText2 + "')"; } } //仅月份起始不为空时,只按月份起始查找数据 else if (SysClass.SysUserSalary.UserSalary_SearchText.Length > 0) { sWhereSQL += " And a.SalaryYears = '" + SysClass.SysUserSalary.UserSalary_SearchText + "'"; if (SysClass.SysUserSalary.UserSalary_ImportRecIndex > 0) { sWhereSQL += " And a.SalaryRecGuid ='" + SysClass.SysUserSalary.UserSalary_ImportRecValue + "'"; } } //仅月份结束不为空时,只按月份结束查找数据 else if (SysClass.SysUserSalary.UserSalary_SearchText2.Length > 0) { sWhereSQL += " And a.SalaryYears = '" + SysClass.SysUserSalary.UserSalary_SearchText2 + "'"; if (SysClass.SysUserSalary.UserSalary_ImportRecIndex2 > 0) { sWhereSQL += " And a.SalaryRecGuid ='" + SysClass.SysUserSalary.UserSalary_ImportRecValue2 + "'"; } } //如果不是从属与最高部门的员工,此页面只能查询其所属子部门员工的数据! SqlDataReader sdrUser = SysClass.SysUser.GetUserInfoByReader(SysClass.SysGlobal.GetCurrentOpCode()); if (sdrUser.Read()) { SqlDataReader sdrOrg = SysClass.SysOrgan.GetSingleOrganByReader(Convert.ToInt32(sdrUser["OrganID"])); if (sdrOrg.Read()) { if (sdrOrg["POrganID"].ToString() != "0") { sWhereSQL += " And b.OrganID = " + Convert.ToInt32(sdrUser["OrganID"]); } } sdrOrg.Close(); } sdrUser.Close(); //Add by lk 20160118 start switch (SysClass.SysUserSalary.UserSalary_FlgValue) { //没有选中任何一项 case 0: sWhereSQL += " And d.Description = ''"; break; //仅【工资】被选中 case 1: sWhereSQL += " And d.Description like '%" + chkGongzi.Text + "%'"; break; //仅【奖金】被选中 case 2: sWhereSQL += " And d.Description like '%" + chkJiangjin.Text + "%'"; break; //【工资】和【奖金】被选中 case 3: sWhereSQL += " And (d.Description like '%" + chkGongzi.Text + "%'"; sWhereSQL += " or d.Description like '%" + chkJiangjin.Text + "%')"; break; //仅【报销】被选中 case 4: sWhereSQL += " And d.Description like '%" + chkBaoxiao.Text + "%'"; break; //【工资】和【报销】被选中 case 5: sWhereSQL += " And (d.Description like '%" + chkGongzi.Text + "%'"; sWhereSQL += " or d.Description like '%" + chkBaoxiao.Text + "%')"; break; //【奖金】和【报销】被选中 case 6: sWhereSQL += " And (d.Description like '%" + chkJiangjin.Text + "%'"; sWhereSQL += " or d.Description like '%" + chkBaoxiao.Text + "%')"; break; //【工资】【奖金】【报销】都被选中 case 7: break; } //Add by lk 20160118 end string sSQL = "select a.ID, a.OpCode, b.OpName, b.Sex, b.IdNumber, c.OrganName, a.SalaryYears, a.SalaryDate, a.TotalSalary,d.Description" + ", (Case IsNull(SignStatus,0) when 0 then a.TotalSalary else 0 end) As UnSignTotalSalary" + ", (Case IsNull(SignStatus,0) when 1 then a.TotalSalary else 0 end) As SignTotalSalary"; sSQL += " from UserSalary_Info a " + " left join SysUser_Info b on b.Status=0 And a.OpCode=b.OpCode" + " left join SysOrgan_Info c on c.Status=0 And b.OrganID=c.ID" //Add by lk 20160118 start + " left join UserUserImportRec_Info d on d.SalaryRecGuid=a.SalaryRecGuid" //Add by lk 20160118 end + " Where a.Status=0 " + sWhereSQL; sSQL += " Order By a.SalaryYears Desc,b.OpName"; DataSet ds = CyxPack.OperateSqlServer.DataCommon.GetDataByDataSet(sSQL); //创建DataTable对象 DataTable dt = new DataTable("output"); //构建表结构,往表中添加列 dt.Columns.Add("序号", typeof(int)); dt.Columns.Add("工号", typeof(string)); dt.Columns.Add("姓名", typeof(string)); dt.Columns.Add("单位部门", typeof(string)); dt.Columns.Add("工资年月", typeof(string)); dt.Columns.Add("发放日期", typeof(string)); dt.Columns.Add("发放金额", typeof(decimal)); dt.Columns.Add("未签收金额", typeof(decimal)); dt.Columns.Add("已签收金额", typeof(decimal)); dt.Columns.Add("备注", typeof(string)); //清空合计结果 mysum = 0; mysum1 = 0; mysum2 = 0; for (int iLoop = 0; iLoop < ds.Tables[0].Rows.Count; iLoop++) { //创建DataRow对象 DataRow dr = dt.NewRow(); //新增数据 dr[0] = iLoop + 1; dr[1] = ds.Tables[0].Rows[iLoop]["OpCode"].ToString(); dr[2] = ds.Tables[0].Rows[iLoop]["OpName"].ToString(); dr[3] = ds.Tables[0].Rows[iLoop]["OrganName"].ToString(); dr[4] = ds.Tables[0].Rows[iLoop]["SalaryYears"].ToString(); if (ds.Tables[0].Rows[iLoop]["SalaryDate"].ToString().Length > 0) { dr[5] = DateTime.Parse(ds.Tables[0].Rows[iLoop]["SalaryDate"].ToString()).ToString("yyyy-MM-dd"); } else { dr[5] = ""; } dr[6] = ds.Tables[0].Rows[iLoop]["TotalSalary"].ToString(); dr[7] = ds.Tables[0].Rows[iLoop]["UnSignTotalSalary"].ToString(); dr[8] = ds.Tables[0].Rows[iLoop]["SignTotalSalary"].ToString(); dr[9] = ds.Tables[0].Rows[iLoop]["Description"].ToString(); //把数据添加到表结构中 dt.Rows.Add(dr); //合计结果累加 mysum += double.Parse(ds.Tables[0].Rows[iLoop]["TotalSalary"].ToString()); mysum1 += double.Parse(ds.Tables[0].Rows[iLoop]["UnSignTotalSalary"].ToString()); mysum2 += double.Parse(ds.Tables[0].Rows[iLoop]["SignTotalSalary"].ToString()); } //添加合计部分数据 DataRow foot = dt.NewRow(); foot[5] = "总合计:"; foot[6] = mysum.ToString("0.00"); foot[7] = mysum1.ToString("0.00"); foot[8] = mysum2.ToString("0.00"); dt.Rows.Add(foot); System.Web.UI.WebControls.DataGrid dgExport = null; // 当前对话 System.Web.HttpContext curContext = System.Web.HttpContext.Current; // IO用于导出并返回excel文件 System.IO.StringWriter strWriter = null; System.Web.UI.HtmlTextWriter htmlWriter = null; // 设置编码和附件格式 curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); curContext.Response.Charset = "gb2312"; // 导出excel文件 strWriter = new System.IO.StringWriter(); htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter); // 为了解决dgData中可能进行了分页的情况,需要重新定义一个无分页的DataGrid dgExport = new System.Web.UI.WebControls.DataGrid(); dgExport.DataSource = dt.DefaultView; dgExport.AllowPaging = false; dgExport.DataBind(); // 返回客户端 dgExport.RenderControl(htmlWriter); curContext.Response.Clear(); curContext.Response.Buffer = true; curContext.Response.Write("上海动车段工资电子签收系统"); curContext.Response.AddHeader("Content-Disposition", "attachment;filename=" + strFilename); curContext.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=gb2312\"/>" + strWriter.ToString()); curContext.Response.Flush(); curContext.Response.End(); }
internal override void RenderItem(System.Web.UI.HtmlTextWriter output, FileViewItem item) { output.AddStyleAttribute(HtmlTextWriterStyle.Margin, "1px"); output.AddStyleAttribute(HtmlTextWriterStyle.Width, "120px"); output.AddStyleAttribute(HtmlTextWriterStyle.Display, "inline-block"); output.AddStyleAttribute(HtmlTextWriterStyle.VerticalAlign, "top"); output.RenderBeginTag(HtmlTextWriterTag.Div); fileView.RenderItemBeginTag(output, item); output.AddAttribute(HtmlTextWriterAttribute.Cellpadding, "0"); output.AddAttribute(HtmlTextWriterAttribute.Cellspacing, "0"); output.AddAttribute(HtmlTextWriterAttribute.Border, "0"); output.RenderBeginTag(HtmlTextWriterTag.Table); output.RenderBeginTag(HtmlTextWriterTag.Tr); output.AddStyleAttribute(HtmlTextWriterStyle.Width, "120px"); output.AddStyleAttribute(HtmlTextWriterStyle.Height, "96px"); output.AddStyleAttribute(HtmlTextWriterStyle.PaddingLeft, "13px"); output.AddStyleAttribute(HtmlTextWriterStyle.PaddingRight, "13px"); output.AddStyleAttribute(HtmlTextWriterStyle.PaddingTop, "2px"); output.RenderBeginTag(HtmlTextWriterTag.Td); output.AddAttribute(HtmlTextWriterAttribute.Cellpadding, "0"); output.AddAttribute(HtmlTextWriterAttribute.Cellspacing, "0"); output.AddAttribute(HtmlTextWriterAttribute.Border, "0"); output.RenderBeginTag(HtmlTextWriterTag.Table); output.RenderBeginTag(HtmlTextWriterTag.Tr); output.AddStyleAttribute(HtmlTextWriterStyle.BorderColor, "#ACA899"); output.AddStyleAttribute(HtmlTextWriterStyle.BorderStyle, "solid"); output.AddStyleAttribute(HtmlTextWriterStyle.BorderWidth, "1px"); output.AddStyleAttribute(HtmlTextWriterStyle.Width, "92px"); output.AddStyleAttribute(HtmlTextWriterStyle.Height, "92px"); output.AddStyleAttribute(HtmlTextWriterStyle.TextAlign, "center"); output.AddStyleAttribute(HtmlTextWriterStyle.VerticalAlign, "middle"); output.AddStyleAttribute("background-image", "url(\"" + item.ThumbnailImage + "\")"); output.AddStyleAttribute("background-position", "center center"); output.AddStyleAttribute("background-repeat", "no-repeat"); if (item.Hidden) { fileView.Controller.HiddenItemStyle.AddAttributesToRender(output); } output.RenderBeginTag(HtmlTextWriterTag.Td); output.RenderEndTag(); output.RenderEndTag(); output.RenderEndTag(); output.RenderEndTag(); output.RenderEndTag(); output.RenderBeginTag(HtmlTextWriterTag.Tr); output.RenderBeginTag(HtmlTextWriterTag.Td); output.AddStyleAttribute(HtmlTextWriterStyle.Cursor, "default"); output.AddStyleAttribute(HtmlTextWriterStyle.Width, "120px"); output.AddStyleAttribute(HtmlTextWriterStyle.PaddingBottom, "2px"); output.AddStyleAttribute(HtmlTextWriterStyle.Overflow, "hidden"); output.AddStyleAttribute(HtmlTextWriterStyle.TextAlign, "center"); output.AddAttribute(HtmlTextWriterAttribute.Id, item.ClientID + "_Name"); output.RenderBeginTag(HtmlTextWriterTag.Div); RenderItemName(output, item); output.RenderEndTag(); output.RenderEndTag(); output.RenderEndTag(); output.RenderEndTag(); fileView.RenderItemEndTag(output); output.RenderEndTag(); }
public void RenderControl(HtmlTextWriter writer) { SetTheme(); if (_version == ReCaptchaVersion.Version1) { var scriptCaptchaOptionsTag = new TagBuilder("script"); scriptCaptchaOptionsTag.Attributes.Add("type", MimeTypes.TextJavascript); scriptCaptchaOptionsTag.InnerHtml = string.Format("var RecaptchaOptions = {{ theme: '{0}', tabindex: 0 }}; ", Theme); writer.Write(scriptCaptchaOptionsTag.ToString(TagRenderMode.Normal)); var scriptLoadApiTag = new TagBuilder("script"); scriptLoadApiTag.Attributes.Add("src", string.Format(RECAPTCHA_API_URL_VERSION1, PublicKey)); writer.Write(scriptLoadApiTag.ToString(TagRenderMode.Normal)); } else if (_version == ReCaptchaVersion.Version2) { var scriptCallbackTag = new TagBuilder("script"); scriptCallbackTag.Attributes.Add("type", MimeTypes.TextJavascript); scriptCallbackTag.InnerHtml = string.Format("var onloadCallback = function() {{grecaptcha.render('{0}', {{'sitekey' : '{1}', 'theme' : '{2}' }});}};", Id, PublicKey, Theme); writer.Write(scriptCallbackTag.ToString(TagRenderMode.Normal)); var captchaTag = new TagBuilder("div"); captchaTag.Attributes.Add("id", Id); writer.Write(captchaTag.ToString(TagRenderMode.Normal)); var scriptLoadApiTag = new TagBuilder("script"); scriptLoadApiTag.Attributes.Add("src", RECAPTCHA_API_URL_VERSION2 + (string.IsNullOrEmpty(Language) ? "" : string.Format("&hl={0}", Language))); scriptLoadApiTag.Attributes.Add("async", null); scriptLoadApiTag.Attributes.Add("defer", null); writer.Write(scriptLoadApiTag.ToString(TagRenderMode.Normal)); } }