private string GetReportList()
{
ProductSearchInfo productSearch = new ProductSearchInfo();
productSearch.Key = searchCourseName;
productSearch.NotInClassID = "3644|5235|5298";
productSearch.InCompanyID = CompanyBLL.SystemCompanyId.ToString() + "," + companyID.ToString();
List <ProductInfo> productList = ProductBLL.SearchProductList(productSearch);
decimal[,] averageInfo = new decimal[productList.Count, 6];
StringBuilder TempStr = new StringBuilder();
TempStr.Append("<table class=\"evaluation_sheet\">\n\r");
TempStr.Append("<tr>\n\r");
TempStr.Append("<th colspan=\"" + (productList.Count + 3) + "\">" + companyName);
if (startDate != DateTime.MinValue || endDate != DateTime.MinValue)
{
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
TempStr.Append(" [ " + startDate.ToString("d") + "—" + endDate.ToString("d") + " ]");
}
else if (startDate == DateTime.MinValue)
{
TempStr.Append(" [ 截止到：" + endDate.ToString("d") + " ]");
}
if (endDate != DateTime.MinValue)
{
endDate = ShopCommon.SearchEndDate(endDate);
}
}
//TempStr.Append(" <input id=\"Button2\" type=\"button\" value=\"导出报表\" Class=\"button\" OnClick=\"ExcelGetCatId();\" /></th>\n\r");
TempStr.Append("</th>\n\r");
TempStr.Append("</tr>\n\r");
TempStr.Append("<tr>\n\r");
TempStr.Append("<th style=\"min-width:60px\">序号</th>\n\r");
TempStr.Append("<th style=\"min-width:60px\">姓名</th>\n\r");
TempStr.Append("<th style=\"min-width:60px\">职位</th>\n\r");
for (int i = 0; i < productList.Count; i++)
{
TempStr.Append("<th style=\"min-width:100px;\">" + productList[i].Name + "</th>\n\r");
}
//TempStr.Append("<td>平均分</td>\n\r");
TempStr.Append("</tr>\n\r");
UserSearchInfo userSearch = new UserSearchInfo();
userSearch.InCompanyID = companyID.ToString();
userSearch.Status = (int)UserState.Normal;
userSearch.InGroupID = groupID;
userSearch.InWorkingPostID = postIdCondition;
userSearch.InStudyPostID = studyPostIdCondition;
List <UserInfo> userList = UserBLL.SearchUserList(userSearch);
int userNum = 0;//序号
if (userList.Count > 0)
{
//系统先调取公司月内的所有成绩，减少循环体中调用的对数据库操作的重复性
List <TestPaperInfo> testReportList = TestPaperBLL.ReadReportList(companyID.ToString(), ProductBLL.ReadProductIdStr(productList), startDate, endDate);
foreach (UserInfo user in userList)
{
userNum = userNum + 1;
TempStr.Append("<tr>\n\r");
TempStr.Append("<td width=\"35px\">" + userNum.ToString() + "</td>\n\r");
TempStr.Append("<td width=\"100px\">" + user.RealName + "</td>\n\r");
TempStr.Append("<td width=\"200px\">" + PostBLL.ReadPost(user.WorkingPostID).PostName + "</td>\n\r");
decimal userAverageScore = 0;
int courseHasTest = 0;
for (int i = 0; i < productList.Count; i++)
{
ProductInfo product = productList[i];
string courseState = "--";
//if (user.RegisterDate < CateIdEndDate[i])
//{
averageInfo[i, 5] = averageInfo[i, 5] + 1;
//}
//else
//{
// courseState = "不作计算";
//}
TestPaperInfo testPaperModel = TestPaperBLL.ReadReportInfo(testReportList, user.ID, product.ID);
if (testPaperModel != null)
{
TempStr.Append("<td>" + testPaperModel.Scorse.ToString() + "</td>\n\r");
userAverageScore = userAverageScore + testPaperModel.Scorse;
courseHasTest = courseHasTest + 1;
//科目总分计算
averageInfo[i, 0] = averageInfo[i, 0] + testPaperModel.Scorse;
//有成绩的人数计算
averageInfo[i, 1] = averageInfo[i, 1] + 1;
if (testPaperModel.IsPass == 1)
{
averageInfo[i, 2] = averageInfo[i, 2] + 1;
}
}
else
{
TempStr.Append("<td>" + courseState + "</td>\n\r");
}
}
//人均分
//if (courseHasTest > 0)
//{
// TempStr.Append("<td>" + Math.Round(userAverageScore / courseHasTest, 2) + "</td>\n\r");
//}
//else
//{
// TempStr.Append("<td>--</td>\n\r");
//}
TempStr.Append("</tr>\n\r");
}
}
TempStr.Append("<tr>\n\r");
TempStr.Append("<th colspan=\"3\"><B>应到人数</B></th>\n\r");
for (int i = 0; i < productList.Count; i++)
{
TempStr.Append("<th>" + averageInfo[i, 5].ToString() + "</th>\n\r");
}
TempStr.Append("</tr>\n\r");
TempStr.Append("<tr>\n\r");
TempStr.Append("<th colspan=\"3\"><B>实际参加考试人数</B></th>\n\r");
for (int i = 0; i < productList.Count; i++)
{
TempStr.Append("<th>" + (averageInfo[i, 1] != 0 ? averageInfo[i, 1].ToString() : "0") + "</th>\n\r");
}
TempStr.Append("</tr>\n\r");
TempStr.Append("<tr>\n\r");
TempStr.Append("<th colspan=\"3\"><B>到考率</B></th>\n\r");
for (int i = 0; i < productList.Count; i++)
{
TempStr.Append("<th>" + (averageInfo[i, 5] != 0 ? Math.Round(averageInfo[i, 1] / averageInfo[i, 5], 4).ToString("P") : "0") + "</th>\n\r");
}
TempStr.Append("</tr>\n\r");
TempStr.Append("<tr>\n\r");
TempStr.Append("<th colspan=\"3\"><B>到考平均分</B></th>\n\r");
for (int i = 0; i < productList.Count; i++)
{
TempStr.Append("<th>" + (averageInfo[i, 1] != 0 ? Math.Round(averageInfo[i, 0] / averageInfo[i, 1], 2) : 0) + "</th>\n\r");
}
TempStr.Append("</tr>\n\r");
TempStr.Append("<tr>\n\r");
TempStr.Append("<th colspan=\"3\"><B>考试通过人数</B></th>\n\r");
for (int i = 0; i < productList.Count; i++)
{
TempStr.Append("<th>" + averageInfo[i, 2] + "</th>\n\r");
}
TempStr.Append("</tr>\n\r");
TempStr.Append("<tr class=\"listTableFoot\">\n\r");
TempStr.Append("<th colspan=\"3\"><B>课程通过率</B></th>\n\r");
for (int i = 0; i < productList.Count; i++)
{
TempStr.Append("<th>" + (averageInfo[i, 5] != 0 ? Math.Round(averageInfo[i, 2] / averageInfo[i, 5], 4).ToString("P") : "0") + "</th>\n\r");
}
TempStr.Append("</tr>\n\r");
TempStr.Append("</table>\n\r");
return(TempStr.ToString());
}