base.Response.Clear();
                base.Response.ContentEncoding = Encoding.UTF8;
              
                base.Response.ContentType = "Application/ms-excel";
                
                
                base.Response.AppendHeader("Content-Disposition", "attachment;filename=\"Export_" + DateTime.Now.ToString("yyyymmddhhmm") + "_" + base.RandKey(4) + ".xls\"");
                if ((table != null) && (table.Rows.Count > 0))
                {
                    base.Response.Write("<table border=\"0\" style=\"text-align:left;font-size:10pt\" cellpadding=\"0\" cellspacing=\"0\">");
                    base.Response.Write("<tr height\"50\"><td style=\"text-align:center;font-size:16pt;\" colspan=\"11\"><b>訂單列表</b></td></tr>");
                    base.Response.Write("<tr><td colspan=\"11\"></td></tr>");
                    base.Response.Write("</table>");
                    
                    base.Response.Write("<table border=\"1px\" style=\"text-align:left;font-size:10pt\" cellpadding=\"0\" cellspacing=\"0\">");

                    base.Response.Write("<tr bgcolor=\"c0c0c0\">");
                    base.Response.Write("<td width=\"100\"><b>交易時間<b></td>");
                    base.Response.Write("<td width=\"200\"><b>訂單號</b></td>");
                    base.Response.Write("<td width=\"100\"><b>商戶號</b></td>");
                    base.Response.Write("<td width=\"100\"><b>商戶簡稱<b></td>");
                    base.Response.Write("<td width=\"100\"><b>終端號<b></td>");
                    base.Response.Write("<td width=\"100\"><b>交易類型<b></td>");
                    base.Response.Write("<td width=\"100\"><b>交易狀態(tài)<b></td>");
                    base.Response.Write("<td width=\"100\"><b>交易金額<b></td>");

                    base.Response.Write("<td width=\"100\"><b>結(jié)算金額<b></td>");
                    base.Response.Write("<td width=\"100\"><b>執(zhí)行費率(%)<b></td>");

                    base.Response.Write("<td width=\"100\"><b>手續(xù)費</b></td>");

                    base.Response.Write("<td width=\"100\"><b>收款行</b></td>");
                    base.Response.Write("<td width=\"100\"><b>支行名行</b></td>");
                    base.Response.Write("<td width=\"100\"><b>聯(lián)行號</b></td>");
                    base.Response.Write("<td width=\"100\"><b>收款帳戶</b></td>");
                    base.Response.Write("<td width=\"100\"><b>收款人</b></td>");

                    base.Response.Write("<td width=\"100\"><b>支付卡號<b></td>");
                    base.Response.Write("<td width=\"100\"><b>卡片類型<b></td>");
                    base.Response.Write("<td width=\"100\"><b>是否T0商戶<b></td>");
                    base.Response.Write("<td width=\"100\"><b>結(jié)算時間<b></td>");
                    base.Response.Write("</tr>");
                    for (int i = 0; i < table.Rows.Count; i++)
                    {
                        DataRow row = table.Rows[i];
                        //根據(jù)mainId 獲取到商戶的信息
                        DataSet posuserDS = BasePage.BindAgeData("SELECT  * FROM [posplat].[dbo].[PosUser] where mainid = '" + row["mainid"].ToString() + "'");
                        DataTableCollection posusertables = posuserDS.Tables;
                        
                        if (posuserDS.Tables.Count == 1)
                        {
                            DataTable theTable = posusertables[0];
                            DataRowCollection therows = theTable.Rows;
                            DataRow therow = therows[0];
                            
                            string combankname1 = therow["combankname1"].ToString(); //商戶銀行卡開戶行名稱
                            string zhihangming = therow["combanksort2"].ToString();//支行名
                            string lianhanghao = therow["combank2"].ToString();//聯(lián)行號
                            string combankcarnum1 = therow["combankcarnum1"].ToString();//銀行卡號
                            string combankcarname1 = therow["combankcarname1"].ToString();//shou kuan ren
                            string isT0 = therow["postdayid"].ToString().Equals("6") ? "是" : "否"; //是否T0代付

                            base.Response.Write("<tr>");
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", BasePage.TimeStr(row["addtime"].ToString())));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", row["systr"].ToString()));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", row["mainid"].ToString()));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", row["niname"].ToString()));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", row["serid"].ToString()));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", this.GetTradeType(row["tradesort"].ToString())));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\" >{TEXT}</td>".Replace("{TEXT}", BasePage.PosTradeState(row["tradestate"].ToString())));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", row["total"].ToString()));
                            
                            double jiesuanJinEr = Convert.ToDouble(row["total"]) - Convert.ToDouble(row["tax"]);
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", jiesuanJinEr.ToString()));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", row["rate"].ToString()));

                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", row["tax"].ToString()));

                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", combankname1));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", zhihangming));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", lianhanghao));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", combankcarnum1));
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", combankcarname1));

                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", BasePage.CardDis(row["carnum"].ToString())));//支付卡號
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", row["carorg"].ToString()));//支付卡號
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", isT0));//是否T0代付
                            base.Response.Write("<td style=\"vnd.ms-excel.numberformat:@\">{TEXT}</td>".Replace("{TEXT}", BasePage.TimeStr(row["jiesuantime"].ToString())));//結(jié)算時間

                            base.Response.Write("</tr>");

                        }
                        else
                        {
                            MessageBox.Show(this, "導出失敗,獲取商戶信息失斨笙印泉坐！");
                            return;
                        }
                        

                      
                    }
                    base.Response.Write("</table>");
                    base.Response.Write("<table border=\"0\" style=\"text-align:left;font-size:10pt\" cellpadding=\"0\" cellspacing=\"0\">");
                   
                    base.Response.Write("<tr><td colspan=\"11\"></td></tr>");
                    base.Response.Write("<tr>");
                    base.Response.Write("<td colspan=\"7\"> </td>");
                    base.Response.Write("<td><b>導出時間：<b></td>");
                    base.Response.Write("<td> {PrintTime}</td>".Replace("{PrintTime}", DateTime.Now.ToString()));
                    base.Response.Write("<td> </td>");
                    base.Response.Write("<td> </td>");
                    base.Response.Write("</tr>");
                    base.Response.Write("</table>");
                }
                base.Response.Flush();
                base.Response.Close();
                base.Response.End();
            }