public bool createexcel(int id)
{
ScanInfoBLL scanbll = new ScanInfoBLL();
SqlDataReader sr = scanbll.GetItemsById(id);
string title = "";
string firstitem = "";
string seconditem = "";
string thirditem = "";
string forthitem = "";
string fifthitem = "";
while (sr.Read())
{
title = sr[1].ToString();
firstitem = sr[2].ToString();
seconditem = sr[9].ToString();
thirditem = sr[16].ToString();
forthitem = sr[23].ToString();
fifthitem = sr[30].ToString();
break;
}
sr.Close();
DataTable dt = bll.GetTable();
DateTime date = DateTime.Now;
string Title = title + date.ToShortDateString() + "打印";
string path = Server.MapPath("./file//排行榜.xlsx");
return(bll.createlist(dt, Title, firstitem, seconditem, thirditem, forthitem, fifthitem, path));
}
public string GetItemsById(int id)
{
string str = "";
SqlDataReader sr = scaninfobll.GetItemsById(id);
str += "<th style=\"width:160px;text-align:center\">评分人</th><th style=\"width:160px;text-align:center\">被评分人</th>";
while (sr.Read())
{
str += "<th style=\"width:160px;text-align:center\">" + sr["First_Item"].ToString() + "</th>";
str += "<th style=\"width:160px;text-align:center\">" + sr["Second_Item"].ToString() + "</th>";
str += "<th style=\"width:160px;text-align:center\">" + sr["Third_Item"].ToString() + "</th>";
str += "<th style=\"width:160px;text-align:center\">" + sr["Forth_Item"].ToString() + "</th>";
str += "<th style=\"width:160px;text-align:center\">" + sr["Fifth_Item"].ToString() + "</th>";
}
sr.Close();
str += "<th style=\"width:20px;text-align:center;\">总分</th>";
str += "<th style=\"width:160px;text-align:center\">评分时间</th>";
return(str);
}