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();
}