//导出操作
public void WriteExcel(string path)
{
//文件流
using (FileStream fsWrite = new FileStream(path, FileMode.Create, FileAccess.Write))
{
//创建工作表
XSSFWorkbook work = new XSSFWorkbook();
//创建页
ISheet sheet = work.CreateSheet();
//读取会员信息
List <MemberInfo> list = memDal.GetAllMemberInfoByDelFlag(0);
//创建行
for (int i = 0; i < list.Count; i++)
{
//创建行
IRow row = sheet.CreateRow(i);
//只要名字和电话
row.CreateCell(0, CellType.String).SetCellValue(list[i].MemName);
row.CreateCell(1, CellType.String).SetCellValue(list[i].MemMobilePhone);
}
work.Write(fsWrite);//写入文件
}
}
/// <summary>
/// 根据删除标志查询结果
/// </summary>
/// <param name="delFlag">0: 未删除;1: 删除</param>
/// <returns></returns>
public List <MemberInfo> GetAllMemberInfoByDelFlag(int delFlag)
{
return(dal.GetAllMemberInfoByDelFlag(delFlag));
}
/// <summary>
/// 根据删除标识查询所有的会员信息
/// </summary>
/// <param name="memmberId">删除标识0---没删除,1---删除</param>
/// <returns>会员信息集合(对象)</returns>
public List <MemberInfo> GetAllMemberInfoByDelFlag(int memmberId)
{
return(dal.GetAllMemberInfoByDelFlag(memmberId));
}