sql.Append("select isnull(dbo.GetSaleOrderOrderSerial_BySaleOrderItemID(SaleOrderItemID),0) as SaleOrderSerial, * from VendorOrderInfo where " + GetQuery()" );
DataTable dt = VcSale.DBUtility.DbHelperSQL.Query(sql.ToString()).Tables[0];
StringBuilder sb = new StringBuilder();
if (dt != null)
{
sb.Append("<tr><td>销售订单</td><td>收购单号</td><td>供应商帐号</td><td>游戏名</td><td>服务器名</td><td>实际交易量</td><td>单价</td><td>状态</td></tr>");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td> " + dt.Rows[i]["SaleOrderSerial"].ToString() + "</td>");
sb.Append("<td> " + dt.Rows[i]["OrderSerial"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["MailAccount"].ToString() + "</td>");
sb.Append("<td>" + VcSale.Cache.Utility.GetGame((int)dt.Rows[i]["GameID"]).Name + "</td>");
sb.Append("<td> " + VcSale.Cache.Utility.GetGameServer((int)dt.Rows[i]["ServerID"]).Name + "</td>");
sb.Append("<td>" + dt.Rows[i]["Amount"].ToString() + "</td>");
double price = double.Parse(dt.Rows[i]["RealPrice"].ToString());
sb.Append("<td>" + string.Format("{0:¥0.0000}", price) + "</td>");
sb.Append("<td>" + ((OrderType)(byte)dt.Rows[i]["Status"]).ToString() + "</td>");
sb.Append("</tr>");
}
}
Response.ContentType = "application/vnd.ms-excel";
Response.Write("<table>" + sb.ToString() + "</table>");
Response.End();
//数据用EXCEL导出时用 可以避免特殊字符显示引起的乱码