Ejemplo n.º 1
0
 protected void ExcelBt_Click(object sender, EventArgs e)
 {
     MemberSeachCondition searchCondition = (Session["MemberSerachCondition"] as MemberSeachCondition);
     MemberManageBLL memberBLL = new MemberManageBLL();
     Page<MemberBaseInfo> memberPageInfo = new Page<MemberBaseInfo>();
     memberPageInfo = memberBLL.GetMemberList(true, searchCondition);
     List<MemberBaseInfo> list = new List<MemberBaseInfo>();
     if (memberPageInfo != null && memberPageInfo.Data != null)
     {
         list = memberPageInfo.Data.ToList<MemberBaseInfo>();
     }
     if (list != null && list.Count > 0)
     {
         ExcelEdit edit = new ExcelEdit();
         edit.CreateExcel();
         edit.WriteHisData(list, 0, list.Count - 1);
         Random rand = new Random();
         string fileName = Server.MapPath(".") + "/MemberList_" + rand.Next(1000).ToString() + ".xls";
         edit.ExplortExcel(fileName);
         ImportExcel(fileName, edit);
     }
 }