protected void btnExportCustomerOrdersPDF_Click(object sender, ImageClickEventArgs e) { GridOrders.AllowPaging = false; GridOrders.DataBind(); Response.Clear(); Response.Buffer = true; Response.ClearContent(); Response.ClearHeaders(); Response.Charset = ""; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=InternalOrdersOfCustomer-" + SelectCustomerOrders.SelectedItem.ToString() + " - " + DateTime.Now.ToShortDateString() + ".pdf"); GridOrders.GridLines = GridLines.Horizontal; GridOrders.HeaderStyle.Font.Bold = true; GridOrders.HeaderStyle.ForeColor = System.Drawing.Color.DarkBlue; GridOrders.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); Response.End(); GridOrders.AllowPaging = true; GridOrders.DataBind(); }
//查询结果绑定 private void BindData() { Hashtable ht = new Hashtable(); if (string.IsNullOrWhiteSpace(datebegin.Text) || string.IsNullOrWhiteSpace(dateend.Text)) { MessageBoxShow("请输入开始时间及结束时间查询!", MessageBoxIcon.Information); return; } PageUtil pageUtil = new PageUtil(GridOrders.PageIndex, GridOrders.PageSize); ht["DateStart"] = datebegin.Text; ht["DateEnd"] = Convert.ToDateTime(dateend.Text).AddDays(1).ToString("yyyy-MM-dd"); if (DropDictLab.SelectedValue == "0") { ht["labid"] = Userinfo.joinLabidstr; } else { ht["labid"] = DropDictLab.SelectedValue; } ht["realname"] = tbxName.Text = TextUtility.ReplaceText(tbxName.Text); ht["ordernum"] = tbxOrderNum.Text; ht["status"] = dropStatus.SelectedIndex == 0 ? null : dropStatus.SelectedValue; ht["customerid"] = DropCustomer.SelectedValue == "-1" ? null : DropCustomer.SelectedValue; ht["iscancel"] = DropIScancel.SelectedIndex == 0 ? null : DropIScancel.SelectedValue; ht["pageStart"] = pageUtil.GetPageStartNum(); ht["pageEnd"] = pageUtil.GetPageEndNum(); GridOrders.RecordCount = mamagement.GetManagementOrdersCount(ht); GridOrders.DataSource = mamagement.GetManagementOrders(ht); GridOrders.DataBind(); }
private void BindData() { Hashtable ht = getPara(); GridOrders.RecordCount = mamagement.GetManagementOrdersCount(ht); GridOrders.DataSource = mamagement.GetManagementOrders(ht); GridOrders.DataBind(); }
/// <summary> /// 绑定Grid数据 /// </summary> /// <param name="ht">查询参数</param> /// <param name="isSearch">是否重新查询</param> private void BindData() { Hashtable ht = new Hashtable(); ht["ordernum"] = hidOrderNums.Text; GridOrders.DataSource = mamagement.GetManagementOrdersByDictmemberid(ht); GridOrders.DataBind(); }
//查询结果绑定 private void BindData() { //存储过滤条件 Hashtable ht = new Hashtable(); PageUtil pageUtil = new PageUtil(GridOrders.PageIndex, GridOrders.PageSize); ht["pageStart"] = pageUtil.GetPageStartNum(); ht["pageEnd"] = pageUtil.GetPageEndNum(); GridOrders.RecordCount = os.GetOverdueOrdersCount(); GridOrders.DataSource = os.GetOverdueOrders(ht); GridOrders.DataBind(); }
/// <summary>绑定Grid数据 /// /// </summary> /// <param name="ht">查询参数</param> /// <param name="isSearch">是否重新查询</param> private void BindData(Hashtable ht, bool isSearch) { GridOrders.DataSource = mamagement.GetManagementOrders(ht); GridOrders.DataBind(); if (isSearch) { int pagecount = mamagement.GetManagementOrdersCount(ht); ht["PageCount"] = GridOrders.RecordCount = pagecount; } else { GridOrders.RecordCount = Convert.ToInt32(ht["PageCount"]); } }
protected void Binder() { PageUtil pageUtil = new PageUtil(GridOrders.PageIndex, GridOrders.PageSize); Hashtable ht = new Hashtable(); ht.Add("Disposestate", DropState.SelectedValue); ht.Add("OrderNum", TextUtility.ReplaceText(txtOrderNum.Text)); ht.Add("BarCode", TextUtility.ReplaceText(txtBarCode.Text)); ht.Add("startDate", datebegin.Text.ToString() == "" ? null : datebegin.Text.ToString()); ht.Add("endDate", dateend.Text.ToString() == "" ? null : dateend.Text.ToString()); ht.Add("pageStart", pageUtil.GetPageStartNum()); ht.Add("pageEnd", pageUtil.GetPageEndNum()); //设置总项数 GridOrders.RecordCount = service.SelectOrderExceptionCount(ht); GridOrders.DataSource = service.SelectOrderExceptionLst(ht); GridOrders.DataBind(); }
protected void btnExportCustomerOrdersExcel_Click(object sender, ImageClickEventArgs e) { GridOrders.AllowPaging = false; GridOrders.DataBind(); Response.Clear(); Response.Buffer = true; Response.ClearContent(); Response.ClearHeaders(); Response.Charset = ""; string FileName = "InternalOrders - Customer - " + SelectCustomerOrders.SelectedItem.ToString() + " - " + DateTime.Now.ToShortDateString() + ".xls"; StringWriter strwritter = new StringWriter(); HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName); GridOrders.GridLines = GridLines.Both; GridOrders.HeaderStyle.Font.Bold = true; GridOrders.RenderControl(htmltextwrtter); Response.Write(strwritter.ToString()); Response.End(); GridOrders.AllowPaging = true; GridOrders.DataBind(); }