protected void ExcelBt_Click(object sender, EventArgs e)
{
ActivitySerachCondition searchCondition = this.Session["ActivitySerachCondition"] as ActivitySerachCondition;
ActivityBLL ybll = new ActivityBLL();
Page<ActivityInvo> page = new Page<ActivityInvo>();
page = ybll.GetActivityList(searchCondition, 0, true);
List<ActivityInvo> list = new List<ActivityInvo>();
if ((page != null) && (page.Data != null))
{
list = page.Data.ToList<ActivityInvo>();
}
if ((list != null) && (list.Count > 0))
{
ExcelEdit exelTools = new ExcelEdit();
exelTools.CreateExcel();
exelTools.WriteActivityList(list, 0, list.Count - 1);
Random random = new Random();
string fileName = base.Server.MapPath(".") + "/ActivityList_" + random.Next(1000).ToString() + ".xls";
exelTools.ExplortExcel(fileName);
this.ImportExcel(fileName, exelTools);
}
}
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);
}
}
protected void ExcelBt_Click(object sender, EventArgs e)
{
List<MemberActivityInfo> list = new List<MemberActivityInfo>();
list = this.Session["MemberActivityList"] as List<MemberActivityInfo>;
if ((list != null) && (list.Count > 0))
{
ExcelEdit exelTools = new ExcelEdit();
exelTools.CreateExcel();
exelTools.WriteAtivityMember(list, 0, list.Count - 1);
Random random = new Random();
string fileName = base.Server.MapPath(".") + "/ActivityMember_" + random.Next(1000).ToString() + ".xls";
exelTools.ExplortExcel(fileName);
this.ImportExcel(fileName, exelTools);
}
}
