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); }