public void ImportExcel(string fileName, ExcelEdit exelTools)
{
exelTools.deleteTempExcel();
FileInfo info = new FileInfo(fileName);
base.Response.Charset = "GB2312";
base.Response.ContentEncoding =System.Text.Encoding.UTF8;
base.Response.AddHeader("Content-Disposition", "attachment; filename=" + base.Server.UrlEncode(info.Name));
base.Response.AddHeader("Content-Length", info.Length.ToString());
base.Response.ContentType = "application/ms-excel";
base.Response.WriteFile(info.FullName);
base.Response.Flush();
info.Delete();
base.Response.End();
}
public void ImportExcel(string fileName, ExcelEdit exelTools)
{
exelTools.deleteTempExcel();
System.IO.FileInfo file = new System.IO.FileInfo(fileName);
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
// 添加头信息，为"文件下载/另存为"对话框指定默认文件名
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(file.Name));
// 添加头信息，指定文件大小，让浏览器能够显示下载进度
Response.AddHeader("Content-Length", file.Length.ToString());
// 指定返回的是一个不能被客户端读取的流，必须被下载
Response.ContentType = "application/ms-excel";
// 把文件流发送到客户端
Response.WriteFile(file.FullName);
// 停止页面的执行
Response.Flush();
file.Delete();
Response.End();
}
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)
{
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)
{
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);
}
}