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/"> {NUMBER}</td>".Replace("{NUMBER}", dr["NUMBER"].ToString()));
//收货人
Response.Write("<td width=/"150/"> {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/"> {ReceiveTel}</td>".Replace("{ReceiveTel}", dr["ReceiveTel"].ToString()));
//手机
Response.Write("<td width=/"150/"> {ReceiveMobile}</td>".Replace("{ReceiveMobile}", dr["ReceiveMobile"].ToString()));
//Email
Response.Write("<td width=/"150/"> {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> " + payment + "</td>");
//配送方式
Response.Write("<td> " + dr["Delivery"].ToString() + "</td>");
//收货地址
Response.Write("<td > {ReceiveAddress}</td>".Replace("{ReceiveAddress}", dr["ReceiveAddress"].ToString()));
//邮编
Response.Write("<td> {ReceivePostCode}</td>".Replace("{ReceivePostCode}", dr["ReceivePostCode"].ToString()));
//标志性建筑
Response.Write("<td> {Building}</td>".Replace("{Building}", dr["Building"].ToString()));
//发票抬头
Response.Write("<td> {InvoiceHead}</td>".Replace("{InvoiceHead}", dr["InvoiceHead"].ToString()));
//发票税额
Response.Write("<td> {InvoicePrice}</td>".Replace("{InvoicePrice}", dr["InvoicePrice"].ToString()));
//运费(配送费用)
Response.Write("<td> {Fee}</td>".Replace("{Fee}", dr["Fee"].ToString()));
//手续费
Response.Write("<td> {PaymentPrice}</td>".Replace("{PaymentPrice}", dr["PaymentPrice"].ToString()));
//订单总金额
Response.Write("<td> {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> {PrintTime}</td>".Replace("{PrintTime}", DateTime.Now.ToString()));
//操作者
Response.Write("<td><b>操作者:<b></td>");
Response.Write("<td> {Operator}</td>".Replace("{Operator}", base.Uid));
Response.Write("</tr>");
Response.Write("</table>");
}
Response.Flush();
Response.Close();
Response.End();
}
catch
{
//导出错误时操作
utils.JsAlert("导出失败!");
}
}