C# NOPI导出EXCEL

【核心代码】

using System;
using System.Collections.Generic;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Web.sitemanager.hongbao
{
    public partial class User_Hongbao : Administrator.UI.ManagerBaseUIPage
    {
        //页面功能
        private string txtEditTitle = "会员管理";
        //导航路径
        public string txtManageTitle = "会员信息管理 > 会员信息";
        //传值
        public static string txtLocal = "";


        public static List<CMS.Model.UserHongbao> list = new List<CMS.Model.UserHongbao>();
        public static List<CMS.Security.User> listuser = new List<CMS.Security.User>();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {                
                RptBind();
            }
        }

        //数据绑定
        private void RptBind()
        {
            //初始值
            ToolsPannel.Visible = true;
            ListPanel.Visible = true;
            contentTab.Visible = false;
             
            string SQLStr = "";
            if (DropDownList1.SelectedValue != "")
                SQLStr  = " AND Type = "   DropDownList1.SelectedValue;

            list = CMS.BLL.UserHongbao.Search(0, SQLStr, "");

            listuser_inf(); 

            this.rptList.DataSource = list;
            this.rptList.DataBind();


            decimal summoney = 0;
            for (int i = 0; i < list.Count; i  )
            {
                summoney  = list[i].MoneyAmount;
            }
            lbltext.Text = Math.Round(summoney, 2).ToString();

            if (DropDownList1.SelectedValue == "")
            {
                Label2.Text = "";
            }
            else if (DropDownList1.SelectedValue == "1")
            {
                Label2.Text = "考试满分";                
            }
            else if (DropDownList1.SelectedValue == "2")
            {
                Label2.Text = "关注有礼";
            }

        }

        /// <summary>
        /// 获取答题用户列表
        /// </summary>
        private void listuser_inf()
        {
            string list_userid = "";

            if (list.Count > 0)
            {
                for (int i = 0; i < list.Count; i  )
                {
                    list_userid  = list[i].UserId   ",";
                }

                listuser = CMS.Security.User.get(" and UserId in ("   list_userid.TrimEnd(',')   ")");
            }
        }

        /// <summary>
        /// 根据用户ＩＤ获取用户姓名
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public string getusername(int userid)
        {
            string result = "";
            foreach (CMS.Security.User item in listuser)
            {
                if (item.UserId == userid)
                {
                    result = item.Name;
                    break;
                }
            }

            return result;
        } 



        /// <summary>
        /// 调出添加、编辑界面
        /// </summary>
        /// <param name="hidValue"></param>
        public void GetAddEditPanel(int hideValue)
        {
            //控制界面
            ObjectId.Value = hideValue.ToString();
            ToolsPannel.Visible = false;
            ListPanel.Visible = false;
            contentTab.Visible = true;
            if (hideValue == 0)
            {
                EditTitle.Text = txtEditTitle   "新增";
                //txtpassword.CssClass = "txtInput normal required"; 
            }
            else
            {
                EditTitle.Text = txtEditTitle   "编辑";
                //txtpassword.CssClass = "txtInput normal"; 
                CMS.Security.User user = CMS.Security.User.GetUserByUserID(hideValue);
                txtname.Text = user.Name;
                txtTel.Text = user.Telephone;

            }
        }

        //提交按钮
        public void btnSubmit_Click(object sender, EventArgs e)
        {
            int intObjectId = Convert.ToInt32(ObjectId.Value);
            if (intObjectId > 0)
            {
                CMS.Security.User editinfo = CMS.Security.User.GetUserByUserID(intObjectId);
                editinfo.Name = txtname.Text;
                editinfo.Telephone = txtTel.Text;

                editinfo.Update();
                JscriptMsg("修改成功啦！", "UserList.aspx", "Success");
            }
            else
            {
                CMS.Security.User addinfo = CMS.Security.User.GetUserByTelephone(txtTel.Text.Trim());
                if (addinfo != null)
                {
                    JscriptMsg("该手机号已经注册！", "", "Warning");
                }
                else
                {
                    addinfo.Name = txtname.Text.Trim();
                    addinfo.Telephone = txtTel.Text.Trim();
                    addinfo.Joined = DateTime.Now;

                    addinfo.Create();
                    JscriptMsg("创建成功啦！", "UserList.aspx", "Success");
                    JscriptMsg("确认密码不正确！", "", "Warning");
                }
            }
        }

        //分页
        protected void Repeater1_PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
        {
            rptList.CurrentPageIndex = e.NewPageIndex;
            RptBind();
        }

        //绑定操作按钮
        protected void Repeater1_ItemCommand(object sender, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "edit")
            {
                GetAddEditPanel(Convert.ToInt32(e.CommandArgument));
            }
        }

        //新增
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            GetAddEditPanel(0);
        }

        //保存排序
        protected void btnSave_Click(object sender, EventArgs e)
        {

        }

        //批量删除
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < rptList.Items.Count; i  )
            {
                int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
                CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
                if (cb.Checked)
                {
                    CMS.Security.User delinfo = CMS.Security.User.GetUserByUserID(id);
                    delinfo.Delete();
                }
            }
            JscriptMsg("批量删除成功啦！", "UserList.aspx", "Success");
        }

        public string GetOrderNumber(string v_mid)
        {
            string v_oid;
            DateTime dt = DateTime.Now;
            string v_ymd = dt.ToString("yyyyMMdd", DateTimeFormatInfo.InvariantInfo); // yyyyMMdd
            string timeStr = dt.ToString("HHmmss", DateTimeFormatInfo.InvariantInfo); // HHmmss
            v_oid = "SH"   v_ymd   v_mid   timeStr;
            return v_oid;
        }

        protected void GroupDropDownList2_SelectedIndexChanged(object sender, EventArgs e)
        {
            RptBind();
        }

        public void outExcel_Click(object sender, EventArgs e)
        {

            //string SQLStr = "";
            //if (DropDownList1.SelectedValue != "")
            //    SQLStr  = " AND Type = "   DropDownList1.SelectedValue;

            //list = CMS.BLL.UserHongbao.Search(0, SQLStr, "");

            //listuser_inf(); 

            string name = "/uploads/"   DateTime.Now.ToString("yyyy-MM-dd")   DateTime.Now.Millisecond   ".csv";
            FileStream fs = new FileStream(Server.MapPath(name), FileMode.Create, FileAccess.Write);
            StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("gb2312"));
            sw.WriteLine("姓名,红包类型,红包金额,创建时间");

            foreach (CMS.Model.UserHongbao item in list)
            {
                sw.WriteLine(getusername(item.UserId)   ","   (item.Type == 1 ? "满分试卷" : "关注有礼")   ","   Math.Round(Convert.ToDecimal(item.MoneyAmount), 2)   ","   item.CreateTime.ToString());
            }

            sw.Close();

            HttpContext.Current.Response.Redirect(name);
        }
    }
}