Excel导出

 protected void btnExcel_Click(object sender, EventArgs e)
    {
        try
        {
            int intPageCount = 0;       //记录总条数
            //是否结算
            scLast.isSettleUp = Convert.ToInt32(this.drpStatusID.SelectedItem.Value);
            //订单时间(上限)
            scLast.DateStart = txtDateState.Text.Trim();
            //订单时间(下限)
            scLast.DateEnd = txtDateStop.Text.Trim();
          
            //店铺名称
            scLast.shopName = this.txtShop.Text.Trim();
            //订单编号
            scLast.Number = this.txtNumber.Text.Trim();

            DataTable dt = new Commission().GetList(scLast.Number, scLast.isSettleUp, scLast.shopName, scLast.DateStart, scLast.DateEnd, scLast.PageIndex, out intPageCount);

            Response.Clear();
            Response.ContentEncoding = System.Text.Encoding.UTF8;
            Response.ContentType = "Application/ms-excel";
            Response.AppendHeader("Content-Disposition",
            "attachment;filename=/"Export_Order_" + DateTime.Now.ToString("yyyymmddhhmm") + ".xls/"");
            if (dt != null && dt.Rows.Count > 0)
            {
                //页标题
                Response.Write("<table border=/"0/" style=/"text-align:left;font-size:10pt/" cellpadding=/"0/" cellspacing=/"0/">");
                Response.Write("<tr height/"50/"><td style=/"text-align:center;font-size:16pt;/" colspan=/"20/"><b>佣金列表</b></td></tr>");
                Response.Write("<tr><td colspan=/"20/"></td></tr>");
                Response.Write("</table>");

                //表头
                Response.Write("<table border=/"1px/" style=/"text-align:left;font-size:10pt/" cellpadding=/"0/" cellspacing=/"0/">");
                Response.Write("<tr bgcolor=/"c0c0c0/">");
                Response.Write("<td width=/"100/"><b>订单编号</b></td>");
                Response.Write("<td width=/"100/"><b>收货人</b></td>");
                Response.Write("<td width=/"100/"><b>性别<b></td>");
                Response.Write("<td width=/"100/"><b>联系电话<b></td>");
                Response.Write("<td width=/"100/"><b>手机<b></td>");
                Response.Write("<td width=/"100/"><b>Email<b></td>");
                Response.Write("<td width=/"100/"><b>订单状态</b></td>");
                Response.Write("<td width=/"100/"><b>支付方式<b></td>");
                Response.Write("<td width=/"100/"><b>配送方式<b></td>");
                Response.Write("<td><b>收货地址<b></td>");
                Response.Write("<td width=/"100/"><b>邮编<b></td>");
                Response.Write("<td width=/"100/"><b>标志性建筑<b></td>");
                Response.Write("<td width=/"100/"><b>发票抬头<b></td>");
                Response.Write("<td width=/"100/"><b>发票税额<b></td>");
                Response.Write("<td width=/"100/"><b>运费<b></td>");
                Response.Write("<td width=/"100/"><b>手续费<b></td>");
                Response.Write("<td width=/"100/"><b>订单总金额<b></td>");
                Response.Write("</tr>");

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DataRow dr = dt.Rows[i];
                    //第一行
                    Response.Write("<tr>");
                    //订单编号
                    Response.Write("<td width=/"150/">&nbsp;{NUMBER}</td>".Replace("{NUMBER}", dr["NUMBER"].ToString()));
                    //收货人
                    Response.Write("<td width=/"150/">&nbsp;{ReceiveName}</td>".Replace("{ReceiveName}", dr["ReceiveName"].ToString()));
                    //性别
                    if (dr["ReceiveSex"].ToString() == "1")
                    {
                        Response.Write("<td width=/"150/">{ReceiveSex}</td>".Replace("{ReceiveSex}", "男"));
                    }
                    else if (dr["ReceiveSex"].ToString() == "2")
                    {
                        Response.Write("<td width=/"150/">{ReceiveSex}</td>".Replace("{ReceiveSex}", "女"));
                    }
                    else
                    {
                        Response.Write("<td width=/"150/">{ReceiveSex}</td>".Replace("{ReceiveSex}", "保密"));
                    }
                    //联系电话
                    Response.Write("<td width=/"150/">&nbsp;{ReceiveTel}</td>".Replace("{ReceiveTel}", dr["ReceiveTel"].ToString()));
                    //手机
                    Response.Write("<td width=/"150/">&nbsp;{ReceiveMobile}</td>".Replace("{ReceiveMobile}", dr["ReceiveMobile"].ToString()));
                    //Email
                    Response.Write("<td width=/"150/">&nbsp;{SendEmail}</td>".Replace("{SendEmail}", dr["SendEmail"].ToString()));
                    //订单状态
                    if (dr["StatusID"].ToString() == "-1")
                    {
                        Response.Write("<td>用户取消</td>");
                    }
                    else if (dr["StatusID"].ToString() == "-2")
                    {
                        Response.Write("<td>管理员取消</td>");
                    }
                    else if (dr["StatusID"].ToString() == "1")
                    {
                        Response.Write("<td>买家已付款</td>");
                    }
                    else if (dr["StatusID"].ToString() == "2")
                    {
                        Response.Write("<td>已付款,等待卖家确认</td>");
                    }
                    else if (dr["StatusID"].ToString() == "3")
                    {
                        Response.Write("<td>已发货,等待买家确认</td>");
                    }
                    else if (dr["StatusID"].ToString() == "4")
                    {
                        Response.Write("<td>交易完成</td>");
                    }
                    else
                    {
                        Response.Write("<td>等待买家付款</td>");
                    }
                    string payment = dr["Payment"].ToString();
                    if (payment == "Alipay_Instant_Year")
                        payment = "支付宝";
                    else
                        payment = "快钱支付";
                    //支付方式
                    Response.Write("<td>&nbsp;" + payment + "</td>");
                    //配送方式
                    Response.Write("<td>&nbsp;" + dr["Delivery"].ToString() + "</td>");
                    //收货地址
                    Response.Write("<td >&nbsp;{ReceiveAddress}</td>".Replace("{ReceiveAddress}", dr["ReceiveAddress"].ToString()));
                    //邮编
                    Response.Write("<td>&nbsp;{ReceivePostCode}</td>".Replace("{ReceivePostCode}", dr["ReceivePostCode"].ToString()));
                    //标志性建筑
                    Response.Write("<td>&nbsp;{Building}</td>".Replace("{Building}", dr["Building"].ToString()));
                    //发票抬头
                    Response.Write("<td>&nbsp;{InvoiceHead}</td>".Replace("{InvoiceHead}", dr["InvoiceHead"].ToString()));
                    //发票税额
                    Response.Write("<td>&nbsp;{InvoicePrice}</td>".Replace("{InvoicePrice}", dr["InvoicePrice"].ToString()));
                    //运费(配送费用)
                    Response.Write("<td>&nbsp;{Fee}</td>".Replace("{Fee}", dr["Fee"].ToString()));
                    //手续费
                    Response.Write("<td>&nbsp;{PaymentPrice}</td>".Replace("{PaymentPrice}", dr["PaymentPrice"].ToString()));
                    //订单总金额
                    Response.Write("<td>&nbsp;{Price}</td>".Replace("{Price}", dr["Price"].ToString()));
                    Response.Write("</tr>");
                }
                Response.Write("</table>");
                //页脚
                Response.Write("<table border=/"0/" style=/"text-align:left;font-size:10pt/" cellpadding=/"0/" cellspacing=/"0/">");
                Response.Write("<tr><td colspan=/"15/"></td></tr>");
                //补空
                Response.Write("<tr>");
                Response.Write("<td colspan=/"11/"> </td>");

                //打印时间
                Response.Write("<td><b>导出时间：<b></td>");
                Response.Write("<td>&nbsp;{PrintTime}</td>".Replace("{PrintTime}", DateTime.Now.ToString()));

                //操作者
                Response.Write("<td><b>操作者：<b></td>");
                Response.Write("<td>&nbsp;{Operator}</td>".Replace("{Operator}", base.Uid));
                Response.Write("</tr>");
                Response.Write("</table>");
            }
            Response.Flush();
            Response.Close();
            Response.End();

 

        }
        catch
        {
            //导出错误时操作
            utils.JsAlert("导出失败！");
        }
    }