学步园

private void ExportTXT()
  {
       HttpContext.Current.Response.Clear(); 
       HttpContext.Current.Response.Buffer= true; 
       HttpContext.Current.Response.Charset="GB2312";   
       HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename=FileName.txt");
       HttpContext.Current.Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
       HttpContext.Current.Response.ContentType = "application/ms-text";//设置输出文件类型为TXT文件。 
             
       System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
       System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); 
       System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

       string client_no = drp_Custom.SelectedValue.Trim();//客户
       string cMonth = drp_CMonth.SelectedItem.Text.Trim();//合同月
       string mclass_id = drp_BigClass.SelectedValue.Trim();//大类
       string borg_id = drp_CareerPart.SelectedValue.Trim();//事业部
       string region_id = drp_BigSection.SelectedValue.Trim();//大区
       string sTime = txt_SData.Text.Trim();// varchar(10),
       string eTime = txt_EData.Text.Trim();// varchar(10)

       SqlParameter[] parArray = new SqlParameter[8];
       if(rdTopUser.Checked == true)
           parArray[0] = new SqlParameter("@MainSapNo",client_no);
       else
           parArray[0] = new SqlParameter("@SapMainNo",client_no);
       parArray[1] = new SqlParameter("@cMonth",cMonth);
       parArray[2] = new SqlParameter("@mclass_id",mclass_id);
       parArray[3] = new SqlParameter("@borg_id",borg_id);
       parArray[4] = new SqlParameter("@region_id",region_id);
       parArray[5] = new SqlParameter("@sTime",sTime);
       parArray[6] = new SqlParameter("@eTime",eTime);

       try
       {
            SqlDataReader drtemp;
            StringBuilder sb = new StringBuilder();
            drtemp= SqlHelper.ExecuteReader(SqlHelper.ToEposConnString,CommandType.StoredProcedure,"Csd_SapFuturesContractExport_Top",parArray);
            //表头
            sb.Append("1\t");
            sb.Append("2\t");
            sb.Append("3\t");
            sb.Append("4\t");
            sb.Append("5\t");
            sb.Append("6\t");
            sb.Append("7\t");
            sb.Append("8\t");
            sb.Append("9\t");
            sb.Append("10\t");
            sb.Append("11\t");
            sb.Append("12号\t");
            sb.Append("13");
            sb.Append("\r\n");
     
        while(drtemp.Read())
        {
             //表内容
             sb.Append(drtemp["SAP_NO"].ToString() + "\t");
             sb.Append(drtemp["SapReceive_No"].ToString() + "\t");
             sb.Append(drtemp["Sale_dept"].ToString() + "\t");
             sb.Append(drtemp["BORG_ID"].ToString() + "\t");
             sb.Append(drtemp["MCLASS_ID"].ToString() + "\t");
             sb.Append(drtemp["sTime"].ToString() + "\t");
             sb.Append(drtemp["eTime"].ToString() + "\t");
             sb.Append(drtemp["Receive_Date"].ToString() + "\t");
             sb.Append(drtemp["style_no"].ToString() + "\t");
             sb.Append(drtemp["sizeno"].ToString() + "\t");
             sb.Append(drtemp["Quan"].ToString()+ "\t");
             sb.Append(drtemp["PO_No"].ToString() + "\t");
             sb.Append(drtemp["impmark"].ToString());
             sb.Append("\r\n");
        }
        HttpContext.Current.Response.Write(sb.ToString());
        HttpContext.Current.Response.End();
   }
   catch(Exception ex)
   {
        Response.Write("<script>alert('" + ex.Message.ToString() + "')</script>");
   }
  }