public List<MemberBaseInfo> GetMemberList() { 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>(); } return list; }
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); } }