Ejemplo n.º 1
0
 public void BindGrid()
 {
     rptList.DataSource = WebBLL.GetOrderInfoListByName(namelike.Value, new Guid(activityList.SelectedValue.ToString()), true, time.Value.Replace("-", ""));
     rptList.DataBind();
 }
Ejemplo n.º 2
0
 public void BindGrid()
 {
     rptList.DataSource = WebBLL.GetOrderInfoListByName(namelike.Value, new Guid(activityList.SelectedValue.ToString()), false);
     rptList.DataBind();
 }
Ejemplo n.º 3
0
        public void Export_click(object sender, EventArgs e)
        {
            NPOIHelper.ListColumnsName = new SortedList(new NoSort());
            NPOIHelper.ListColumnsName.Add("ID", "导入物流凭证请勿修改");
            NPOIHelper.ListColumnsName.Add("CONSIGNEE", "姓名");
            NPOIHelper.ListColumnsName.Add("MOBILE", "手机号");
            NPOIHelper.ListColumnsName.Add("ALLADDRESS", "地址");
            NPOIHelper.ListColumnsName.Add("ORDERLIST", "订单内容");
            NPOIHelper.ListColumnsName.Add("PAYDATE", "付款时间");
            NPOIHelper.ListColumnsName.Add("AMOUNT", "付款金额");
            NPOIHelper.ListColumnsName.Add("REMARK", "送货备注");
            NPOIHelper.ListColumnsName.Add("LOGISTICS", "物流号");
            Response.Clear();
            Response.BufferOutput    = false;
            Response.ContentEncoding = System.Text.Encoding.UTF8;
            string filename = typeList.SelectedItem.Text + "-" + activityList.SelectedItem.Text + "-" + time.Value + "已付款订单列表";

            Response.AddHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
            Response.ContentType = "application/ms-excel";
            NPOIHelper.ExportExcel(Common.ToDataTable <Model.OrderInfo>(Common.GetAllAdress(WebBLL.GetOrderInfoListByName(namelike.Value, new Guid(activityList.SelectedValue.ToString()), true, time.Value.Replace("-", "")))), Response.OutputStream);
            Response.Close();
        }