protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckAdminPower("ReadVoteItem", PowerCheckType.Single);
foreach (VoteInfo voteInfo in VoteBLL.ReadNamedList())
{
VoteID.Items.Add(new ListItem(voteInfo.Title, "|" + voteInfo.ID + "|"));
}
VoteID.Items.Insert(0, new ListItem("所有类别", string.Empty));
Title.Text = RequestHelper.GetQueryString <string>("Title");
VoteID.Text = RequestHelper.GetQueryString <string>("VoteID");
IsShow.Text = RequestHelper.GetQueryString <string>("IsShow");
VoteItemSearchInfo itemSearch = new VoteItemSearchInfo();
itemSearch.ItemName = RequestHelper.GetQueryString <string>("Title");
itemSearch.VoteID = !string.IsNullOrEmpty(RequestHelper.GetQueryString <string>("VoteID")) ? "|" + RequestHelper.GetQueryString <string>("VoteID") + "|" : string.Empty;
itemSearch.Exp2 = RequestHelper.GetQueryString <string>("IsShow");
BindControl(VoteItemBLL.ReadVoteItemList(CurrentPage, PageSize, itemSearch, ref Count, string.Empty), RecordList, MyPager);
}
}
/// <summary>
/// 投票记录导出Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnTOExcel_Click(object sender, EventArgs e)
{
int count = 0;
List <VoteItemInfo> voteItemList = VoteItemBLL.ReadVoteItemList(1, 500, ref count, "VoteCount");
HSSFWorkbook book = new HSSFWorkbook();
ISheet sheet = book.CreateSheet("投票结果统计");
//列宽
sheet.SetColumnWidth(0, 20 * 256);
sheet.SetColumnWidth(1, 20 * 256);
sheet.SetColumnWidth(2, 20 * 256);
sheet.SetColumnWidth(3, 20 * 256);
// 第一行
IRow row = sheet.CreateRow(0);
row.Height = 400;//行高
row.CreateCell(0).SetCellValue("姓名");
row.CreateCell(1).SetCellValue("得票数");
row.CreateCell(2).SetCellValue("类型");
row.CreateCell(3).SetCellValue("奖项名称");
row.CreateCell(4).SetCellValue("个人宣言");
ICellStyle style1 = book.CreateCellStyle();
//背景色
style1.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.Grey25Percent.Index;
style1.FillPattern = FillPattern.SolidForeground;
//水平对齐
style1.Alignment = HorizontalAlignment.Center;
//垂直对齐
style1.VerticalAlignment = VerticalAlignment.Center;
//字体加粗
IFont f = book.CreateFont();
f.Boldweight = (short)FontBoldWeight.Bold;
style1.SetFont(f);
for (int x = 0; x <= 4; x++)
{
row.Cells[x].CellStyle = style1;
}
//循环插入数据行
ICellStyle style2 = book.CreateCellStyle();
style2.Alignment = HorizontalAlignment.Center;
style2.VerticalAlignment = VerticalAlignment.Center;
int rowNo = 1;
foreach (VoteItemInfo tmpItem in voteItemList)
{
IRow TmpRow = sheet.CreateRow(rowNo);
TmpRow.Height = 300;//行高
//名称
TmpRow.CreateCell(0).SetCellType(CellType.String);
TmpRow.CreateCell(0).SetCellValue(tmpItem.ItemName);
TmpRow.Cells[0].CellStyle = style2;
//票数
TmpRow.CreateCell(1).SetCellType(CellType.Numeric);
TmpRow.CreateCell(1).SetCellValue(tmpItem.VoteCount);
TmpRow.Cells[1].CellStyle = style2;
//类型
TmpRow.CreateCell(2).SetCellValue(VoteBLL.ReadVote(VoteBLL.GetTopClassID(tmpItem.VoteID)).Title);
TmpRow.Cells[2].CellStyle = style2;
//奖项名称
TmpRow.CreateCell(3).SetCellValue(tmpItem.Solution);
TmpRow.Cells[3].CellStyle = style2;
//个人宣言
TmpRow.CreateCell(4).SetCellValue(tmpItem.Department);
TmpRow.Cells[4].CellStyle = style2;
rowNo++;
}
//锁定
sheet.CreateFreezePane(0, 1, 1, 1);
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
}