//组织
static void GenerateOrganizeInfo(int num)
{
OrganizeInfoDal dal = new OrganizeInfoDal();
DbSession dbSession = new DbSession();
for (int i = 0; i < num; i++)
{
OrganizeInfo organize = new OrganizeInfo();
organize.OrganizeInfoLoginId = Guid.NewGuid().ToString().Substring(0, 10);
organize.OrganizeInfoShowName = (Faker.Name.First() + Faker.Name.First()).Substring(3);
organize.OrganizeInfoPwd = MD5Helper.Get_MD5(Faker.Name.First()).Substring(3);
organize.OrganizeInfoPeople = (Faker.Name.Last() + Faker.Name.First()).Substring(3);
organize.OrganizeInfoEmail = Faker.Internet.FreeEmail().Substring(0, 10);
organize.OrganizeInfoManageId = 2;
organize.OrganizeInfoLastTime = Convert.ToDateTime(Faker.Business.CreditCardExpiryDate());
organize.CreateTime = organize.OrganizeInfoLastTime.AddMonths(-10);
organize.ModfiedOn = organize.OrganizeInfoLastTime.AddMonths(-4);
organize.OrganizeInfoIcon = "/Content/Upload/images/1.jpg";
organize.ActivityCount = 0;
organize.Status = (short)((new Random().Next(9)) % 3);
dal.Add(organize);
}
dbSession.SaveChanges();
}
public void DataExportToExecl()
{
OrganizeInfoDal dal = new OrganizeInfoDal();
DbSession dbSession = new DbSession();
//创建Excel文件的对象
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //添加一个sheet
var _data = dal.GetEntities(u => true).ToList();
//给sheet1添加第一行的头部标题
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("排名");
row1.CreateCell(1).SetCellValue("CardID");
row1.CreateCell(2).SetCellValue("姓名");
row1.CreateCell(3).SetCellValue("手机");
row1.CreateCell(4).SetCellValue("职位");
row1.CreateCell(5).SetCellValue("所在公司");
row1.CreateCell(6).SetCellValue("创建时间");
//将数据逐步写入sheet1各个行
for (int i = 0; i < _data.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(i + 1);
rowtemp.CreateCell(1).SetCellValue(_data[i].OrganizeInfoShowName);
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, System.IO.SeekOrigin.Begin);
var buf = ms.ToArray();
using (FileStream fs = new FileStream("test.xls", FileMode.Create, FileAccess.Write))
{
fs.Write(buf, 0, buf.Length);
fs.Flush();
}
}
