private void GetDataForCombobox(HttpContext context)
{
try
{
var uid = HttpContext.Current.Request["uid"];
var questionbll = new BLL.Questionnaire();
var ds = questionbll.GetStudentQuestionnaire(uid);
// [{"SUBITEM_VALUE":"1","SUBITEM_NAME":"男"},{"SUBITEM_VALUE":"2","SUBITEM_NAME":"女"}]
if (ds != null && ds.Tables.Count > 0)
{
var str = new StringBuilder("[");
var i = 0;
foreach (DataRow row in ds.Tables[0].Rows)
{
i++;
str.Append("{\"CourseId\": \"" + row["CourseId"] + "\",");
str.Append("\"CourseName\": \""+i+". " + row["CourseName"] + "\"},");
}
str.Remove(str.Length - 1, 1);
str.Append("]");
context.Response.Write(str.ToString());
}
}
catch (Exception exception)
{
LogHelper.WriteLogofExceptioin(exception);
}
}
protected void SubmitBtn_Click(object sender, ImageClickEventArgs e)
{
try
{
var quesModel = new Models.Questionnaire();
Int32 total = 0;
quesModel.QuestionnaireId = Guid.NewGuid();
quesModel.AppraiserId = Profile.CurrentUser.UserId;
quesModel.AppraiserTime = DateTime.Now;
quesModel.CourseDevelop = Convert.ToInt32(radCourseDevelop.SelectedValue);
total += (int)quesModel.CourseDevelop;
quesModel.CourseId = this.courseId;
quesModel.CourseKey = Convert.ToInt32(radCourseKey.SelectedValue);
total += (int)quesModel.CourseKey;
quesModel.CoursePractical = Convert.ToInt32(radCoursePractical.SelectedValue);
total += (int)quesModel.CoursePractical;
quesModel.CourseRich = Convert.ToInt32(radContentRich.SelectedValue);
total += (int)quesModel.CourseRich;
quesModel.CourseSubject = Convert.ToInt32(radSubject.SelectedValue);
total += (int)quesModel.CourseSubject;
quesModel.OrgArrange = Convert.ToInt32(radOrgArrange.SelectedValue);
total += (int)quesModel.OrgArrange;
quesModel.OrgService = Convert.ToInt32(radOrgService.SelectedValue);
total += (int)quesModel.OrgService;
quesModel.OrgTime = Convert.ToInt32(radOrgTime.SelectedValue);
total += (int)quesModel.OrgTime;
quesModel.TeacherBearing = Convert.ToInt32(radTeacherBearing.SelectedValue);
total += (int)quesModel.TeacherBearing;
quesModel.TeacherCommunication = Convert.ToInt32(radTeacherCommunication.SelectedValue);
total += (int)quesModel.TeacherCommunication;
quesModel.TeacherLanguage = Convert.ToInt32(radTeacherLanguage.SelectedValue);
total += (int)quesModel.TeacherLanguage;
quesModel.TeacherPrepare = Convert.ToInt32(radTeacherPrepare.SelectedValue);
total += (int)quesModel.TeacherPrepare;
quesModel.TeacherStyle = Convert.ToInt32(radTeacherStyle.SelectedValue);
total += (int)quesModel.TeacherStyle;
quesModel.TotalEvaluation = Convert.ToInt32(radAll.SelectedValue);
// total += (int)quesModel.TotalEvaluation;
quesModel.Suggest = txtSuggest.InnerText.Trim();
quesModel.Total = total;
var queBll = new BLL.Questionnaire();
if (queBll.Add(quesModel))
{
queBll.SubmitQuestionnaireState(Profile.CurrentUser.UserId, courseId);
}
Response.Redirect("MyQuestionnaire.aspx");
}
catch (Exception ex)
{
Utility.LogHelper.WriteLogofExceptioin(ex);
}
}
private string GetData()
{
try
{
var uid = HttpContext.Current.Request["uid"];
var questionbll = new BLL.Questionnaire();
var ds = questionbll.GetStudentQuestionnaire(uid);
var str = JsonConvert.SerializeObject(new {total = ds.Tables[0].Rows.Count, rows = ds.Tables[0]});
return str;
}
catch (Exception exception)
{
LogHelper.WriteLogofExceptioin(exception);
return "";
}
}
private void EditData(string id, HttpContext context)
{
var stuids = context.Request["StuIds"];
var courseId = context.Request["CourseId"];
var msg = "";
if (!string.IsNullOrEmpty(stuids))
{
var stu = stuids.Split('|');
var questionBll = new BLL.Questionnaire();
var result = questionBll.EditQuestions(stu, courseId);
if (!result)
{
msg = "保存失败！";
}
}
// var str = JsonConvert.SerializeObject(new { success = result, errorMsg = msg});
context.Response.Write(msg);
}
private void GetSuggestion(string coid)
{
ISheet sheet2 = hssfworkbook.CreateSheet("学员建议");
ICellStyle cellstyleHead = hssfworkbook.CreateCellStyle();
cellstyleHead.VerticalAlignment = VerticalAlignment.Center;
//表头样式
cellstyleHead.BorderBottom = BorderStyle.Thin;
cellstyleHead.BorderLeft = BorderStyle.Thin;
cellstyleHead.BorderRight = BorderStyle.Thin;
cellstyleHead.BorderTop = BorderStyle.Thin;
cellstyleHead.Alignment= HorizontalAlignment.Center;
cellstyleHead.WrapText = true;
var font = hssfworkbook.CreateFont();
font.FontHeightInPoints = 15;
font.FontName = "宋体";
font.Boldweight = 700;
cellstyleHead.SetFont(font);
//表体样式
ICellStyle cellstyleContent = hssfworkbook.CreateCellStyle();
cellstyleContent.BorderBottom = BorderStyle.Thin;
cellstyleContent.BorderLeft = BorderStyle.Thin;
cellstyleContent.BorderRight = BorderStyle.Thin;
cellstyleContent.BorderTop = BorderStyle.Thin;
var font1 = hssfworkbook.CreateFont();
font1.FontHeightInPoints = 14;
font1.FontName = "宋体";
font1.Boldweight = 10;
cellstyleContent.SetFont(font1);
cellstyleContent.WrapText = true;
sheet2.SetColumnWidth(0, 13 * 256);
sheet2.SetColumnWidth(1, 78 * 256);
IRow title0 = sheet2.CreateRow(0);
title0.Height = 600;
for (int f = 0; f < 2; f++)
{
ICell cell = title0.CreateCell(f);
cell.SetCellValue("学员建议");
cell.CellStyle = cellstyleHead;
}
SetCellRangeAddress(sheet2, 0, 0, 0, 1);
var fieldsName = new List<string>() { "学员姓名", "建议" };
IRow title = sheet2.CreateRow(1);
for (int f = 0; f < fieldsName.Count; f++)
{
ICell cell = title.CreateCell(f);
cell.SetCellValue(fieldsName[f]);
cell.CellStyle = cellstyleHead;
}
var quesBll = new BLL.Questionnaire();
var ds = quesBll.GetSuggestion(coid);
var exportDs = ds.Tables[0];
int i = 2;
if (exportDs != null && exportDs.Rows.Count > 0)
{
foreach (DataRow r in exportDs.Rows)
{
IRow row = sheet2.CreateRow(i);
for (var j = 0; j < exportDs.Columns.Count; j++)
{
ICell cell = row.CreateCell(j);
cell.CellStyle = cellstyleContent;
cell.SetCellValue(Convert.ToString(r[j]));
}
i++;
}
}
}
private void GetTheLeft()
{
var queBll = new BLL.Questionnaire();
var ds = queBll.GetCourseQuestionnarieInfo(Profile.CurrentUser.UserId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
var sb = new StringBuilder();
var i = 0;
foreach (DataRow row in ds.Tables[0].Rows)
{
i++;
sb.Append("<span onclick='toOther(\"" + row["CourseId"] + "\")' style='cursor: pointer'>");
sb.Append(i + "、");
sb.Append(row["CourseName"]);
sb.Append(@"</span>");
sb.Append(@"<br/><br/>");
}
CourseNames.InnerHtml = sb.ToString();
}
}
private string GetReportData(string coursId, out string courseName)
{
var coid = new Guid(coursId);
var couBll = new BLL.Course();
var courseModel = couBll.GetModel(coid);
courseName = courseModel.CourseName;
var report = new BLL.Questionnaire();
var reportTitle = report.GetReportTile(coid);
var reportBody = report.GetReport(coid);
var totalShould = 0;
var totalPrac = 0;
var totalScor = "";
var satisfy = "";
var level = "良好";
var contenScor = "";
var techScor = "";
var orgScor = "";
if (reportTitle != null && reportTitle.Tables.Count > 0)
{
totalShould = Convert.ToInt32(reportTitle.Tables[0].Rows[0]["totalNum"]);
totalPrac = Convert.ToInt32(reportTitle.Tables[0].Rows[0]["totalDone"]);
totalScor = string.Format("{0:N2}" , Convert.ToDouble(reportTitle.Tables[0].Rows[0]["totalAvg"]));
satisfy = string.Format("{0:N2}", Convert.ToDouble(reportTitle.Tables[0].Rows[0]["Satisfy"])*100);
level = report.GetLevel(Convert.ToDouble(reportTitle.Tables[0].Rows[0]["Satisfy"]));
contenScor = string.Format("{0:N2}" , Convert.ToDouble(reportTitle.Tables[0].Rows[0]["CourseAvg"]));
techScor = string.Format("{0:N2}" , Convert.ToDouble(reportTitle.Tables[0].Rows[0]["TeacherAvg"]));
orgScor = string.Format("{0:N2}", Convert.ToDouble(reportTitle.Tables[0].Rows[0]["OrgAvg"]));
}
var result = new Dictionary<int, double[]>();
if (reportBody != null && reportBody.Tables.Count > 0)
{
foreach (DataRow row in reportBody.Tables[0].Rows)
{
result.Add((int)row["num"], new[] { Convert.ToDouble(row["top1"]), Convert.ToDouble(row["top2"]), Convert.ToDouble(row["top3"]), Convert.ToDouble(row["top4"]), Convert.ToDouble(row["top5"]) });
}
}
var allTop1 = string.Format("{0:N2}"+"%", result[1][0]*100);
var allTop2 = string.Format("{0:N2}" + "%", result[1][1] * 100);
var allTop3 = string.Format("{0:N2}" + "%", result[1][2] * 100);
var allTop4 = string.Format("{0:N2}" + "%", result[1][3] * 100);
var allTop5 = string.Format("{0:N2}" + "%", result[1][4] * 100);
var content1Top1 = result[2][0];
var content1Top2 = result[2][1];
var content1Top3 = result[2][2];
var content1Top4 = result[2][3];
var content1Top5 = result[2][4];
var content2Top1 = result[3][0];
var content2Top2 = result[3][1];
var content2Top3 = result[3][2];
var content2Top4 = result[3][3];
var content2Top5 = result[3][4];
var content3Top1 = result[4][0];
var content3Top2 = result[4][1];
var content3Top3 = result[4][2];
var content3Top4 = result[4][3];
var content3Top5 = result[4][4];
var content4Top1 = result[5][0];
var content4Top2 = result[5][1];
var content4Top3 = result[5][2];
var content4Top4 = result[5][3];
var content4Top5 = result[5][4];
var content5Top1 = result[6][0];
var content5Top2 = result[6][1];
var content5Top3 = result[6][2];
var content5Top4 = result[6][3];
var content5Top5 = result[6][4];
var teacher1Top1 = result[7][0];
var teacher1Top2 = result[7][1];
var teacher1Top3 = result[7][2];
var teacher1Top4 = result[7][3];
var teacher1Top5 = result[7][4];
var teacher2Top1 = result[8][0];
var teacher2Top2 = result[8][1];
var teacher2Top3 = result[8][2];
var teacher2Top4 = result[8][3];
var teacher2Top5 = result[8][4];
var teacher3Top1 = result[9][0];
var teacher3Top2 = result[9][1];
var teacher3Top3 = result[9][2];
var teacher3Top4 = result[9][3];
var teacher3Top5 = result[9][4];
var teacher4Top1 = result[10][0];
var teacher4Top2 = result[10][1];
var teacher4Top3 = result[10][2];
var teacher4Top4 = result[10][3];
var teacher4Top5 = result[10][4];
var teacher5Top1 = result[11][0];
var teacher5Top2 = result[11][1];
var teacher5Top3 = result[11][2];
var teacher5Top4 = result[11][3];
var teacher5Top5 = result[11][4];
var org1Top1 = result[12][0];
var org1Top2 = result[12][1];
var org1Top3 = result[12][2];
var org1Top4 = result[12][3];
var org1Top5 = result[12][4];
var org2Top1 = result[13][0];
var org2Top2 = result[13][1];
var org2Top3 = result[13][2];
var org2Top4 = result[13][3];
var org2Top5 = result[13][4];
var org3Top1 = result[14][0];
var org3Top2 = result[14][1];
var org3Top3 = result[14][2];
var org3Top4 = result[14][3];
var org3Top5 = result[14][4];
var dept = "海淀区教育党校";
var time = DateTime.Now.ToString("yyyy-MM-dd");
var str = new StringBuilder();
str.Append("<html xmlns=\"http://www.w3.org/1999/xhtml\">");
str.Append("<head>");
str.Append("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />");
str.Append("</head>");
str.Append("<body>");
str.Append("<p align=\"center\" style=\"font-size: 25px;font-weight: bold\"><strong>");
//str.Append(DateTime.Now.Year+ "年海淀区在职资格培训班培训效果测评表 ");
str.Append(DateTime.Now.Year + "年中青年干部教育管理培训班课程评估表 ");
str.Append("</strong><br /></p>");
str.Append("<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"614\" bordercolor=\"#000000\" bgcolor=\"#FFFFFF\" style=\"border-collapse:collapse;font-size: 14px;\" >");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"85\" align=\"center\" valign=\"middle\"><p><strong>课程名称 </strong></p></td>");
str.Append("<td width=\"217\" align=\"center\" valign=\"middle\"><p>" + courseModel.CourseName + " </p></td>");
str.Append("<td width=\"78\" colspan=\"1\" align=\"center\" valign=\"middle\"><p><strong>培训地点 </strong></p></td>");
str.Append("<td width=\"234\" colspan=\"3\" align=\"center\" valign=\"middle\"><p>" + courseModel.TeachPlace + " </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"85\" align=\"center\" valign=\"middle\"><p><strong>培训讲师</strong> </p></td>");
str.Append("<td width=\"217\" align=\"center\" valign=\"middle\"><p>" + courseModel.TeacherName + " </p></td>");
str.Append("<td width=\"78\" colspan=\"1\" align=\"center\" valign=\"middle\"><p><strong>培训时间 </strong></p></td>");
str.Append("<td width=\"234\" colspan=\"3\" align=\"center\" valign=\"middle\"><p>" + courseModel.TeachTime + "</p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"85\" align=\"center\" valign=\"middle\"><p><strong>应评人数 </strong></p></td>");
str.Append("<td width=\"217\" align=\"center\" valign=\"middle\"><p>" + totalShould + "</p></td>");
str.Append("<td width=\"78\" colspan=\"1\" align=\"center\" valign=\"middle\"><p><strong>实评人数 </strong></p></td>");
str.Append("<td width=\"234\" colspan=\"3\" align=\"center\" valign=\"middle\"><p>" + totalPrac + "</p></td>");
str.Append("</tr>");
str.Append("<tr>");
str.Append("<td width=\"614\" colspan=\"6\" valign=\"left\">");
str.Append("<p align=\"center\">");
str.Append("<strong>");
str.Append(" <br />");
str.Append("</strong><strong>本次培训总体平均分：" + totalScor + "分(满分52)<br />满意度：" + satisfy + "% <br />等级：" + level + "， </strong><br />");
str.Append("<strong>其中课程内容</strong><strong>" + contenScor + "</strong><strong>分<br />培训讲师</strong><strong>" + techScor + "</strong><strong>分<br />培训组织和管理</strong><strong>" + orgScor + "</strong><strong>分</strong>");
str.Append("</p>");
str.Append("</td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"302\" colspan=\"2\" valign=\"middle\" align=\"center\"><p align=\"center\"><strong>培训满意度评价项目</strong><strong> </strong></p></td>");
// str.Append("<td width=\"78\" valign=\"middle\" align=\"center\"><p>很满意 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\" align=\"center\"><p>很满意 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\" align=\"center\"><p>满意</p></td>");
str.Append("<td width=\"78\" valign=\"middle\" align=\"center\"><p>一般</p></td>");
str.Append("<td width=\"78\" valign=\"middle\" align=\"center\"><p>不满意</p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"302\" colspan=\"2\" valign=\"middle\" ><p align=\"center\"><strong>本次课程总体满意度 </strong></p></td>");
// str.Append("<td width=\"78\" valign=\"middle\"><p><strong>"+allTop1+"</strong></p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p><strong>" + allTop2 + "</strong></p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p><strong>" + allTop3 + "</strong></p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p><strong>" + allTop4 + "</strong></p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p><strong>" + allTop5 + "</strong></p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"85\" rowspan=\"5\" valign=\"middle\"><p align=\"center\"><strong>课程内容</strong><strong> </strong></p></td>");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程主题清晰明确 </p></td>");
// str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content1Top1 + "人</p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + content1Top2 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content1Top3 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content1Top4 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content1Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程内容丰富、能吸引人 </p></td>");
// str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content2Top1 + "人 </p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + content2Top2 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content2Top3 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content2Top4 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content2Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程内容切合实际，能指导实践 </p></td>");
// str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content3Top1 + "人 </p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + content3Top2 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content3Top3 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content3Top4 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content3Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程内容重点突出，易于理解 </p></td>");
// str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content4Top1 + "人 </p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + content4Top2 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content4Top3 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content4Top4 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content4Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程内容有助于个人发展 </p></td>");
// str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content5Top1 + "人 </p></td>");
str.Append("<td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + content5Top2 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content5Top3 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content5Top4 + "人 </p></td>");
str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + content5Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"85\" rowspan=\"5\" valign=\"middle\"><p align=\"center\"><a name=\"OLE_LINK2\" id=\"OLE_LINK2\"></a><a name=\"OLE_LINK1\" id=\"OLE_LINK1\"><strong>培训讲师</strong></a><strong> </strong></p></td>");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK6\" id=\"OLE_LINK6\"></a><a name=\"OLE_LINK5\" id=\"OLE_LINK5\">讲师准备比较充分</a> </p></td>");
// str.Append("<td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher1Top1 + "人 </p></td>");
str.Append(" <td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher1Top2 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher1Top3 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher1Top4 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher1Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK8\" id=\"OLE_LINK8\"></a><a name=\"OLE_LINK7\" id=\"OLE_LINK7\">语言表达清晰，态度端正</a> </p></td>");
// str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher2Top1 + "人 </p></td>");
str.Append(" <td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher2Top2 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher2Top3 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher2Top4 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher2Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK10\" id=\"OLE_LINK10\"></a><a name=\"OLE_LINK9\" id=\"OLE_LINK9\">仪表仪容端庄大方，有亲和力</a> </p></td>");
// str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher3Top1 + "人 </p></td>");
str.Append(" <td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher3Top2 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher3Top3 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher3Top4 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher3Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK12\" id=\"OLE_LINK12\"></a><a name=\"OLE_LINK11\" id=\"OLE_LINK11\">培训方式多样，生动有趣</a> </p></td>");
// str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher4Top1 + "人 </p></td>");
str.Append(" <td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher4Top2 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher4Top3 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher4Top4 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher4Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK14\" id=\"OLE_LINK14\"></a><a name=\"OLE_LINK13\" id=\"OLE_LINK13\">与学员沟通和互动有效</a> </p></td>");
// str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher5Top1 + "人 </p></td>");
str.Append(" <td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher5Top2 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher5Top3 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher5Top4 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + teacher5Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(" <td width=\"85\" rowspan=\"3\" valign=\"middle\"><p align=\"center\"><a name=\"OLE_LINK4\" id=\"OLE_LINK4\"></a><a name=\"OLE_LINK3\" id=\"OLE_LINK3\"><strong>培训组织和管理</strong></a><strong> </strong></p></td>");
str.Append(" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK16\" id=\"OLE_LINK16\"></a><a name=\"OLE_LINK15\" id=\"OLE_LINK15\">培训服务周到细致</a> </p></td>");
// str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + org1Top1 + "人 </p></td>");
str.Append(" <td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + org1Top2 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + org1Top3 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + org1Top4 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + org1Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK18\" id=\"OLE_LINK18\"></a><a name=\"OLE_LINK17\" id=\"OLE_LINK17\">培训时间安排和控制合理</a> </p></td>");
// str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + org2Top1 + "人 </p></td>");
str.Append(" <td width=\"78\" align=\"center\" valign=\"middle\"><p align=\"center\">" + org2Top2 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + org2Top3 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + org2Top4 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\"><p align=\"center\">" + org2Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK20\" id=\"OLE_LINK20\"></a><a name=\"OLE_LINK19\" id=\"OLE_LINK19\">培训场所、设备安排到位</a> </p></td>");
// str.Append(" <td width=\"78\" valign=\"middle\"><p>" + org3Top1 + "人 </p></td>");
str.Append(" <td width=\"78\" align=\"center\" valign=\"middle\"><p>" + org3Top2 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\" align=\"center\" ><p>" + org3Top3 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\" align=\"center\" ><p>" + org3Top4 + "人 </p></td>");
str.Append(" <td width=\"78\" valign=\"middle\" align=\"center\" ><p>" + org3Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(" <td width=\"85\" valign=\"middle\" align=\"center\"><p><a name=\"_Hlk401413534\" id=\"_Hlk401413534\"><strong>测评单位 </strong></a></p></td>");
str.Append(" <td width=\"217\" valign=\"middle\" align=\"center\"><p>" + dept + " </p></td>");
str.Append(" <td width=\"78\" colspan=\"1\" align=\"center\" valign=\"middle\"><p><strong>测评时间 </strong></p></td>");
str.Append(" <td width=\"234\" colspan=\"3\" align=\"center\" valign=\"middle\"><p>" + time + "</p></td>");
str.Append(" </tr>");
str.Append("</table>");
str.Append("</body>");
str.Append("</html>");
return str.ToString();
}
private void ExportTotalReport(HttpContext context)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("课程名称");
fieldsNames.Add("授课教师");
fieldsNames.Add("总平均分（满分52分）");
fieldsNames.Add("总体满意度");
fieldsNames.Add("评估等级");
fieldsNames.Add("课程内容满意度");
fieldsNames.Add("培训讲师满意度");
fieldsNames.Add("培训组织和管理满意度");
fieldsNames.Add("实评人数");
fieldsNames.Add("培训时间");
var quesBll = new BLL.Questionnaire();
var dt = quesBll.GetTotalReport();
dt.Columns.Remove("CourseId");
dt.AcceptChanges();
var filename = "课程评估总体情况统计表.xls";
exXls.ExportTotalReportToxls(context.Response, fieldsNames, dt, filename);
}
/// <summary>
/// 导出意见
/// </summary>
private void ExportSuggestionInfo(HttpContext context, string id)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("学员姓名");
fieldsNames.Add("建议");
var quesBll = new BLL.Questionnaire();
var ds = quesBll.GetSuggestion(id);
var courseBll = new BLL.Course();
var courseModel = courseBll.GetModel(new Guid(id));
var filename = courseModel.CourseName + "--学员建议.xls";
if (ds != null && ds.Tables.Count > 0)
{
exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename);
}
}
private void ExportStuInfo(HttpContext context, string id)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("学员姓名");
fieldsNames.Add("登录名");
fieldsNames.Add("密码");
fieldsNames.Add("所属学校");
var quesBll = new BLL.Questionnaire();
var dt = quesBll.GetStuInfoofCourse(id);
var courseBll = new BLL.Course();
var courseModel = courseBll.GetModel(new Guid(id));
var filename = courseModel.CourseName + "--学员信息.xls";
exXls.ExportToXls(context.Response, fieldsNames, dt, filename);
}
private void SetSatisfyBar(string sid)
{
//hcate.Value = "课程1, 课程2, 课程3, 课程4, 课程5";
//hdata.Value = "17, 31, 335, 203, 2";
hcate.Value = "";
hdata.Value = "";
try
{
var quesBll = new BLL.Questionnaire();
var dt = quesBll.GetSatisfybar(sid);
if (dt != null && dt.Rows.Count > 0)
{
var str1 = new StringBuilder();
var str2 = new StringBuilder();
foreach (DataRow row in dt.Rows)
{
str1.Append(row["CourseName"] + ",");
// str2.Append(row["Satisfy"].ToString().Substring(0,4) + ",");
if (Convert.ToDouble(row["Satisfy"])*100 > 100)
{
str2.Append("100"+ ",");
}
else
{
str2.Append(string.Format("{0:N2}", Convert.ToDouble(row["Satisfy"]) * 100) + ",");
}
}
str1.Remove(str1.Length - 1, 1);
str2.Remove(str2.Length - 1, 1);
hcate.Value = str1.ToString();
hdata.Value = str2.ToString();
}
}
catch (Exception ex)
{
LogHelper.WriteLogofExceptioin(ex);
}
}
private void SetOrgReports()
{
var str = new StringBuilder();
str.Append("<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" bordercolor=\"#000000\" bgcolor=\"#FFFFFF\" " +
" style=\"border-collapse:collapse;font-size: 14px;text-align:center\" >");
str.Append("<tr height=\"40\"> ");
str.Append("<td colspan='4'> <span style=\"font-size: 25px;font-weight: bold\">培训组织和管理满意度分布表</span><br/> </td>");
str.Append("</tr> ");
str.Append("<tr height=\"35\" bgcolor=\"#F0F9FF\" >");
str.Append("<td rowspan=\"2\" ><strong>课程名称</strong></td>");
// str.Append("<td rowspan=\"2\" ><strong>培训教师</strong></td>");
// str.Append("<td rowspan=\"2\" ><strong>培训时间</strong></td>");
str.Append("<td colspan=\"3\" ><strong>培训组织和管理各指标满意度</strong></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\" bgcolor=\"#F0F9FF\">");
str.Append("<td><strong>培训服务周到细致</strong></td>");
str.Append("<td><strong>培训时间安排和控制合理</strong></td>");
str.Append("<td><strong>培训场所、设备安排到位</strong></td>");
str.Append("</tr>");
var report = new BLL.Questionnaire();
var dt = report.GetOrgReport();
var i = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var orgArrangeP = Convert.ToDouble(row["OrgArrangeP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["OrgArrangeP"]) * 100);
var orgServiceP = Convert.ToDouble(row["OrgServiceP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["OrgServiceP"]) * 100);
var orgTimeP = Convert.ToDouble(row["OrgTimeP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["OrgTimeP"]) * 100);
i++;
var color = i % 2 == 1 ? "#FFFFFF" : "#F0F9FF";
str.Append("<tr height=\"35\" bgcolor=\"" + color + "\" > ");
str.Append("<td>" + row["CourseName"] + " </td>");
// str.Append("<td>" + row["TeacherName"] + " </td>");
// str.Append("<td>" + row["TeachTime"] + " </td>");
str.Append("<td>" + orgServiceP + " </td>");
str.Append("<td>" + orgTimeP + " </td>");
str.Append("<td>" + orgArrangeP + " </td>");
str.Append("</tr>");
}
}
//i++;
//var color1 = i % 2 == 1 ? "#FFFFFF" : "#F0F9FF";
//str.Append("<tr height=\"35\" bgcolor=\"" + color1 + "\" > ");
//str.Append("<td colspan='10'>");
//str.Append("总平均分=各项得分总和/实评人数；满意度=（很满意+满意）/实评人数； 课程（讲师或者组织）的满意度=每项满意度相加/项数 ");
//str.Append("</td>");
//str.Append("</tr>");
str.Append("<tr height=\"35\" bgcolor=\"#FFFFFF\" > ");
str.Append("<td colspan='10'>");
str.Append("<a href=\"javascript:void(0)\" class=\"easyui-linkbutton c6\" iconcls=\"icon-ok\" onclick=\"getOrgReports()\" style=\"width: 120px\">导出</a>");
str.Append("</td>");
str.Append("</tr>");
str.Append("</table>");
divReports.InnerHtml = str.ToString();
}
private void SetDetail(Guid coid)
{
var report = new BLL.Questionnaire();
var reportBody = report.GetReport(coid);
var result = new Dictionary<int, double[]>();
if (reportBody != null && reportBody.Tables.Count > 0)
{
foreach (DataRow row in reportBody.Tables[0].Rows)
{
result.Add((int)row["num"], new[] { Convert.ToDouble(row["top1"]), Convert.ToDouble(row["top2"]), Convert.ToDouble(row["top3"]), Convert.ToDouble(row["top4"]), Convert.ToDouble(row["top5"]) });
}
}
var allTop1 = string.Format("{0:N2}" + "%", result[1][0] * 100);
var allTop2 = string.Format("{0:N2}" + "%", result[1][1] * 100);
var allTop3 = string.Format("{0:N2}" + "%", result[1][2] * 100);
var allTop4 = string.Format("{0:N2}" + "%", result[1][3] * 100);
var allTop5 = string.Format("{0:N2}" + "%", result[1][4] * 100);
var content1Top1 = result[2][0];
var content1Top2 = result[2][1];
var content1Top3 = result[2][2];
var content1Top4 = result[2][3];
var content1Top5 = result[2][4];
var content2Top1 = result[3][0];
var content2Top2 = result[3][1];
var content2Top3 = result[3][2];
var content2Top4 = result[3][3];
var content2Top5 = result[3][4];
var content3Top1 = result[4][0];
var content3Top2 = result[4][1];
var content3Top3 = result[4][2];
var content3Top4 = result[4][3];
var content3Top5 = result[4][4];
var content4Top1 = result[5][0];
var content4Top2 = result[5][1];
var content4Top3 = result[5][2];
var content4Top4 = result[5][3];
var content4Top5 = result[5][4];
var content5Top1 = result[6][0];
var content5Top2 = result[6][1];
var content5Top3 = result[6][2];
var content5Top4 = result[6][3];
var content5Top5 = result[6][4];
var teacher1Top1 = result[7][0];
var teacher1Top2 = result[7][1];
var teacher1Top3 = result[7][2];
var teacher1Top4 = result[7][3];
var teacher1Top5 = result[7][4];
var teacher2Top1 = result[8][0];
var teacher2Top2 = result[8][1];
var teacher2Top3 = result[8][2];
var teacher2Top4 = result[8][3];
var teacher2Top5 = result[8][4];
var teacher3Top1 = result[9][0];
var teacher3Top2 = result[9][1];
var teacher3Top3 = result[9][2];
var teacher3Top4 = result[9][3];
var teacher3Top5 = result[9][4];
var teacher4Top1 = result[10][0];
var teacher4Top2 = result[10][1];
var teacher4Top3 = result[10][2];
var teacher4Top4 = result[10][3];
var teacher4Top5 = result[10][4];
var teacher5Top1 = result[11][0];
var teacher5Top2 = result[11][1];
var teacher5Top3 = result[11][2];
var teacher5Top4 = result[11][3];
var teacher5Top5 = result[11][4];
var org1Top1 = result[12][0];
var org1Top2 = result[12][1];
var org1Top3 = result[12][2];
var org1Top4 = result[12][3];
var org1Top5 = result[12][4];
var org2Top1 = result[13][0];
var org2Top2 = result[13][1];
var org2Top3 = result[13][2];
var org2Top4 = result[13][3];
var org2Top5 = result[13][4];
var org3Top1 = result[14][0];
var org3Top2 = result[14][1];
var org3Top3 = result[14][2];
var org3Top4 = result[14][3];
var org3Top5 = result[14][4];
var dept = "海淀区教育党校";
var time = DateTime.Now.ToString("yyyy-MM-dd");
var str = new StringBuilder();
str.Append(
"<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"98%\" bordercolor=\"#000000\" bgcolor=\"#FFFFFF\" style=\"border-collapse:collapse;font-size: 14px;\" >");
str.Append("<tr height=\"35\">");
str.Append(
"<td width=\"302\" colspan=\"2\" valign=\"middle\" align=\"center\"><p align=\"center\"><strong>培训满意度评价项目</strong><strong> </strong></p></td>");
// str.Append("<td valign=\"middle\" align=\"center\"><p>很满意 </p></td>");
str.Append("<td width=\"15%\" valign=\"middle\" align=\"center\"><p>很满意 </p></td>");
str.Append("<td width=\"15%\" valign=\"middle\" align=\"center\"><p>满意</p></td>");
str.Append("<td width=\"15%\" valign=\"middle\" align=\"center\"><p>一般</p></td>");
str.Append("<td width=\"15%\" valign=\"middle\" align=\"center\"><p>不满意</p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append(
"<td width=\"302\" colspan=\"2\" valign=\"middle\" ><p align=\"center\"><strong>本次课程总体满意度 </strong></p></td>");
// str.Append("<td valign=\"middle\"><p><strong>"+allTop1+"</strong></p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p><strong>" + allTop2 +
"</strong></p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p><strong>" + allTop3 +
"</strong></p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p><strong>" + allTop4 +
"</strong></p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p><strong>" + allTop5 +
"</strong></p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append(
"<td width=\"85\" rowspan=\"5\" valign=\"middle\"><p align=\"center\"><strong>课程内容</strong><strong> </strong></p></td>");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程主题清晰明确 </p></td>");
// str.Append("<td valign=\"middle\"><p align=\"center\">" + content1Top1 + "人</p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p align=\"center\">" + content1Top2 +
"人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content1Top3 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content1Top4 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content1Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程内容丰富、能吸引人 </p></td>");
// str.Append("<td valign=\"middle\"><p align=\"center\">" + content2Top1 + "人 </p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p align=\"center\">" + content2Top2 +
"人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content2Top3 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content2Top4 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content2Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程内容切合实际，能指导实践 </p></td>");
// str.Append("<td valign=\"middle\"><p align=\"center\">" + content3Top1 + "人 </p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p align=\"center\">" + content3Top2 +
"人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content3Top3 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content3Top4 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content3Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程内容重点突出，易于理解 </p></td>");
// str.Append("<td valign=\"middle\"><p align=\"center\">" + content4Top1 + "人 </p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p align=\"center\">" + content4Top2 +
"人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content4Top3 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content4Top4 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content4Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append("<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\">课程内容有助于个人发展 </p></td>");
// str.Append("<td valign=\"middle\"><p align=\"center\">" + content5Top1 + "人 </p></td>");
str.Append("<td align=\"center\" valign=\"middle\"><p align=\"center\">" + content5Top2 +
"人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content5Top3 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content5Top4 + "人 </p></td>");
str.Append("<td valign=\"middle\"><p align=\"center\">" + content5Top5 + "人 </p></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\">");
str.Append(
"<td width=\"85\" rowspan=\"5\" valign=\"middle\"><p align=\"center\"><a name=\"OLE_LINK2\" id=\"OLE_LINK2\"></a><a name=\"OLE_LINK1\" id=\"OLE_LINK1\"><strong>培训讲师</strong></a><strong> </strong></p></td>");
str.Append(
"<td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK6\" id=\"OLE_LINK6\"></a><a name=\"OLE_LINK5\" id=\"OLE_LINK5\">讲师准备比较充分</a> </p></td>");
// str.Append("<td valign=\"middle\"><p align=\"center\">" + teacher1Top1 + "人 </p></td>");
str.Append(" <td align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher1Top2 +
"人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher1Top3 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher1Top4 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher1Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(
" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK8\" id=\"OLE_LINK8\"></a><a name=\"OLE_LINK7\" id=\"OLE_LINK7\">语言表达清晰，态度端正</a> </p></td>");
// str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher2Top1 + "人 </p></td>");
str.Append(" <td align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher2Top2 +
"人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher2Top3 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher2Top4 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher2Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(
" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK10\" id=\"OLE_LINK10\"></a><a name=\"OLE_LINK9\" id=\"OLE_LINK9\">仪表仪容端庄大方，有亲和力</a> </p></td>");
// str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher3Top1 + "人 </p></td>");
str.Append(" <td align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher3Top2 +
"人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher3Top3 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher3Top4 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher3Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(
" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK12\" id=\"OLE_LINK12\"></a><a name=\"OLE_LINK11\" id=\"OLE_LINK11\">培训方式多样，生动有趣</a> </p></td>");
// str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher4Top1 + "人 </p></td>");
str.Append(" <td align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher4Top2 +
"人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher4Top3 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher4Top4 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher4Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(
" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK14\" id=\"OLE_LINK14\"></a><a name=\"OLE_LINK13\" id=\"OLE_LINK13\">与学员沟通和互动有效</a> </p></td>");
// str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher5Top1 + "人 </p></td>");
str.Append(" <td align=\"center\" valign=\"middle\"><p align=\"center\">" + teacher5Top2 +
"人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher5Top3 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher5Top4 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + teacher5Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(
" <td width=\"85\" rowspan=\"3\" valign=\"middle\"><p align=\"center\"><a name=\"OLE_LINK4\" id=\"OLE_LINK4\"></a><a name=\"OLE_LINK3\" id=\"OLE_LINK3\"><strong>培训组织和管理</strong></a><strong> </strong></p></td>");
str.Append(
" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK16\" id=\"OLE_LINK16\"></a><a name=\"OLE_LINK15\" id=\"OLE_LINK15\">培训服务周到细致</a> </p></td>");
// str.Append(" <td valign=\"middle\"><p align=\"center\">" + org1Top1 + "人 </p></td>");
str.Append(" <td align=\"center\" valign=\"middle\"><p align=\"center\">" + org1Top2 +
"人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + org1Top3 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + org1Top4 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + org1Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(
" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK18\" id=\"OLE_LINK18\"></a><a name=\"OLE_LINK17\" id=\"OLE_LINK17\">培训时间安排和控制合理</a> </p></td>");
// str.Append(" <td valign=\"middle\"><p align=\"center\">" + org2Top1 + "人 </p></td>");
str.Append(" <td align=\"center\" valign=\"middle\"><p align=\"center\">" + org2Top2 +
"人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + org2Top3 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + org2Top4 + "人 </p></td>");
str.Append(" <td valign=\"middle\"><p align=\"center\">" + org2Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(
" <td width=\"217\" valign=\"middle\"><p style=\"margin-left: 3px;\"><a name=\"OLE_LINK20\" id=\"OLE_LINK20\"></a><a name=\"OLE_LINK19\" id=\"OLE_LINK19\">培训场所、设备安排到位</a> </p></td>");
// str.Append(" <td valign=\"middle\"><p>" + org3Top1 + "人 </p></td>");
str.Append(" <td align=\"center\" valign=\"middle\"><p>" + org3Top2 + "人 </p></td>");
str.Append(" <td valign=\"middle\" align=\"center\" ><p>" + org3Top3 + "人 </p></td>");
str.Append(" <td valign=\"middle\" align=\"center\" ><p>" + org3Top4 + "人 </p></td>");
str.Append(" <td valign=\"middle\" align=\"center\" ><p>" + org3Top5 + "人 </p></td>");
str.Append(" </tr>");
str.Append(" <tr height=\"35\">");
str.Append(
" <td width=\"85\" valign=\"middle\" align=\"center\"><p><a name=\"_Hlk401413534\" id=\"_Hlk401413534\"><strong>测评单位 </strong></a></p></td>");
str.Append(" <td width=\"217\" valign=\"middle\" align=\"center\"><p>" + dept + " </p></td>");
str.Append(
" <td width=\"85\" colspan=\"2\" align=\"center\" valign=\"middle\"><p><strong>测评时间 </strong></p></td>");
str.Append(" <td width=\"227\" colspan=\"2\" align=\"center\" valign=\"middle\"><p>" + time + "</p></td>");
str.Append(" </tr>");
str.Append("</table>");
details.InnerHtml = str.ToString();
}
void GenerateEvReportData(Guid courseId)
{
ISheet sheet1 = hssfworkbook.CreateSheet("评估报告单");
ICellStyle cellstyleHead = hssfworkbook.CreateCellStyle();
cellstyleHead.VerticalAlignment = VerticalAlignment.Center;
//表头样式
cellstyleHead.BorderBottom = BorderStyle.Thin;
cellstyleHead.BorderLeft = BorderStyle.Thin;
cellstyleHead.BorderRight = BorderStyle.Thin;
cellstyleHead.BorderTop = BorderStyle.Thin;
cellstyleHead.WrapText = true;
cellstyleHead.Alignment= HorizontalAlignment.Center;
var font = hssfworkbook.CreateFont();
font.FontHeightInPoints = 15;
font.FontName = "宋体";
font.Boldweight = 700;
cellstyleHead.SetFont(font);
//表体样式
ICellStyle cellstyleContent = hssfworkbook.CreateCellStyle();
cellstyleContent.BorderBottom = BorderStyle.Thin;
cellstyleContent.BorderLeft = BorderStyle.Thin;
cellstyleContent.BorderRight = BorderStyle.Thin;
cellstyleContent.BorderTop = BorderStyle.Thin;
cellstyleContent.Alignment = HorizontalAlignment.Center;
var font1 = hssfworkbook.CreateFont();
font1.FontHeightInPoints = 14;
font1.FontName = "宋体";
font1.Boldweight = 10;
cellstyleContent.SetFont(font1);
cellstyleContent.WrapText = true;
ICellStyle cellstyleConTitle = hssfworkbook.CreateCellStyle();
cellstyleConTitle.BorderBottom = BorderStyle.Thin;
cellstyleConTitle.BorderLeft = BorderStyle.Thin;
cellstyleConTitle.BorderRight = BorderStyle.Thin;
cellstyleConTitle.BorderTop = BorderStyle.Thin;
cellstyleConTitle.Alignment = HorizontalAlignment.Center;
cellstyleConTitle.VerticalAlignment = VerticalAlignment.Center;
var font11 = hssfworkbook.CreateFont();
font11.FontHeightInPoints = 14;
font11.FontName = "宋体";
font11.Boldweight = 600;
cellstyleConTitle.SetFont(font11);
cellstyleConTitle.WrapText = true;
ICellStyle cellstyleConTitleLeft = hssfworkbook.CreateCellStyle();
cellstyleConTitleLeft.BorderBottom = BorderStyle.Thin;
cellstyleConTitleLeft.BorderLeft = BorderStyle.Thin;
cellstyleConTitleLeft.BorderRight = BorderStyle.Thin;
cellstyleConTitleLeft.BorderTop = BorderStyle.Thin;
cellstyleConTitleLeft.Alignment = HorizontalAlignment.Left;
cellstyleConTitleLeft.VerticalAlignment = VerticalAlignment.Center;
var fontTitleLeft = hssfworkbook.CreateFont();
fontTitleLeft.FontHeightInPoints = 14;
fontTitleLeft.FontName = "宋体";
fontTitleLeft.Boldweight = 10;
cellstyleConTitleLeft.SetFont(fontTitleLeft);
cellstyleConTitleLeft.WrapText = true;
IRow title = sheet1.CreateRow(0);
title.Height = 600;
for (int f = 0; f < 6; f++)
{
ICell cell = title.CreateCell(f);
sheet1.SetColumnWidth(f, 13 * 256);
cell.SetCellValue(DateTime.Now.Year+ "年中青年干部教育管理培训班课程评估表");
cell.CellStyle = cellstyleHead;
}
SetCellRangeAddress(sheet1, 0, 0, 0, 5);
sheet1.SetColumnWidth(0, 15 * 256);
sheet1.SetColumnWidth(1, 25 * 256);
sheet1.SetColumnWidth(2, 15 * 256);
sheet1.SetColumnWidth(3, 15 * 256);
sheet1.SetColumnWidth(4, 15 * 256);
sheet1.SetColumnWidth(5, 15 * 256);
var coubll= new BLL.Course();
var couModel = coubll.GetModel(courseId);
var question = new BLL.Questionnaire();
var exportDs = question.GetReportTile(courseId);
if (exportDs != null && exportDs.Tables.Count > 0&&exportDs.Tables[0].Rows.Count>0)
{
var datarow = exportDs.Tables[0].Rows[0];
IRow row1 = sheet1.CreateRow(1);
ICell cell1 = row1.CreateCell(0);
cell1.CellStyle = cellstyleConTitle;
cell1.SetCellValue("课程名称");
ICell cell2 = row1.CreateCell(1);
cell2.CellStyle = cellstyleContent;
cell2.SetCellValue( couModel.CourseName);
ICell cell3 = row1.CreateCell(2);
cell3.CellStyle = cellstyleConTitle;
cell3.SetCellValue("培训地点");
ICell cell4 = row1.CreateCell(3);
cell4.CellStyle = cellstyleContent;
cell4.SetCellValue(couModel.TeachPlace);
ICell cell5 = row1.CreateCell(4);
cell5.CellStyle = cellstyleContent;
cell5.SetCellValue(couModel.TeachPlace);
ICell cell6 = row1.CreateCell(5);
cell6.CellStyle = cellstyleContent;
cell6.SetCellValue(couModel.TeachPlace);
SetCellRangeAddress(sheet1, 1, 1, 3, 5);
IRow row2 = sheet1.CreateRow(2);
ICell cell21 = row2.CreateCell(0);
cell21.CellStyle = cellstyleConTitle;
cell21.SetCellValue("培训讲师");
ICell cell22 = row2.CreateCell(1);
cell22.CellStyle = cellstyleContent;
cell22.SetCellValue( couModel.TeacherName);
ICell cell23 = row2.CreateCell(2);
cell23.CellStyle = cellstyleConTitle;
cell23.SetCellValue("培训时间");
ICell cell24 = row2.CreateCell(3);
cell24.CellStyle = cellstyleContent;
cell24.SetCellValue(couModel.TeachTime);
ICell cell25 = row2.CreateCell(4);
cell25.CellStyle = cellstyleContent;
cell25.SetCellValue(couModel.TeachTime);
ICell cell26 = row2.CreateCell(5);
cell26.CellStyle = cellstyleContent;
cell26.SetCellValue(couModel.TeachTime);
SetCellRangeAddress(sheet1, 2, 2, 3, 5);
IRow row3 = sheet1.CreateRow(3);
ICell cell31 = row3.CreateCell(0);
cell31.CellStyle = cellstyleConTitle;
cell31.SetCellValue("应评人数");
ICell cell32 = row3.CreateCell(1);
cell32.CellStyle = cellstyleContent;
cell32.SetCellValue(datarow["totalNum"].ToString()+"人");
ICell cell33 = row3.CreateCell(2);
cell33.CellStyle = cellstyleConTitle;
cell33.SetCellValue("实评人数");
ICell cell34 = row3.CreateCell(3);
cell34.CellStyle = cellstyleContent;
cell34.SetCellValue(datarow["totalDone"].ToString() + "人");
ICell cell35 = row3.CreateCell(4);
cell35.CellStyle = cellstyleContent;
cell35.SetCellValue(datarow["totalDone"].ToString() + "人");
ICell cell36 = row3.CreateCell(5);
cell36.CellStyle = cellstyleContent;
cell36.SetCellValue(datarow["totalDone"].ToString() + "人");
SetCellRangeAddress(sheet1, 3, 3, 3, 5);
IRow row4 = sheet1.CreateRow(4);
ICell cell41 = row4.CreateCell(0);
cell41.CellStyle = cellstyleConTitle;
cell41.SetCellValue("总体平均分");
ICell cell42 = row4.CreateCell(1);
cell42.CellStyle = cellstyleContent;
cell42.SetCellValue(string.Format("{0:N2}", datarow["totalAvg"]) + " 分（满分52）");
ICell cell43 = row4.CreateCell(2);
cell43.CellStyle = cellstyleConTitle;
cell43.SetCellValue("满意度");
ICell cell44 = row4.CreateCell(3);
cell44.CellStyle = cellstyleContent;
cell44.SetCellValue(Convert.ToDouble(datarow["Satisfy"]) >= 1.0 ? "100%" : string.Format("{0:N2}" + "%", ((Convert.ToDecimal(datarow["Satisfy"])) * 100)));
ICell cell45 = row4.CreateCell(4);
cell45.CellStyle = cellstyleConTitle;
cell45.SetCellValue("等级");
ICell cell46 = row4.CreateCell(5);
cell46.CellStyle = cellstyleContent;
cell46.SetCellValue(question.GetLevel(Convert.ToDouble(datarow["Satisfy"])));
SetCellRangeAddress(sheet1, 4, 4, 3, 5);
var resultTotalReport = question.GetTotalReport();
if (resultTotalReport != null && resultTotalReport.Rows.Count > 0)
{
var cr = resultTotalReport.Select(string.Format(" CourseId='{0}'", courseId));
if (cr.Length > 0)
{
IRow row5 = sheet1.CreateRow(5);
ICell cell51 = row5.CreateCell(0);
cell51.CellStyle = cellstyleConTitle;
cell51.SetCellValue("课程内容");
ICell cell52 = row5.CreateCell(1);
cell52.CellStyle = cellstyleContent;
// cell52.SetCellValue(cr[0]["TotalCourse"].ToString());
cell52.SetCellValue(Convert.ToDouble(cr[0]["TotalCourse"]) >= 1.0 ? "100%" : string.Format("{0:N2}" + "%", ((Convert.ToDecimal(cr[0]["TotalCourse"])) * 100)));
ICell cell53 = row5.CreateCell(2);
cell53.CellStyle = cellstyleConTitle;
cell53.SetCellValue("培训讲师");
ICell cell54 = row5.CreateCell(3);
cell54.CellStyle = cellstyleContent;
// cell54.SetCellValue(cr[0]["TotalTeacher"].ToString());
cell54.SetCellValue(Convert.ToDouble(cr[0]["TotalTeacher"]) >= 1.0 ? "100%" : string.Format("{0:N2}" + "%", ((Convert.ToDecimal(cr[0]["TotalTeacher"])) * 100)));
ICell cell55 = row5.CreateCell(4);
cell55.CellStyle = cellstyleConTitle;
cell55.SetCellValue("培组织管理");
ICell cell56 = row5.CreateCell(5);
cell56.CellStyle = cellstyleContent;
// cell56.SetCellValue(cr[0]["TotalOrg"].ToString());
cell56.SetCellValue(Convert.ToDouble(cr[0]["TotalOrg"]) >= 1.0 ? "100%" : string.Format("{0:N2}" + "%", ((Convert.ToDecimal(cr[0]["TotalOrg"])) * 100)));
}
}
var reportBody = question.GetReport(courseId);
if (reportBody != null && reportBody.Tables.Count > 0)
{
var result = new Dictionary<int, double[]>();
if (reportBody != null && reportBody.Tables.Count > 0)
{
foreach (DataRow row in reportBody.Tables[0].Rows)
{
result.Add((int)row["num"], new[] { Convert.ToDouble(row["top1"]), Convert.ToDouble(row["top2"]), Convert.ToDouble(row["top3"]), Convert.ToDouble(row["top4"]), Convert.ToDouble(row["top5"]) });
}
}
var allTop1 = string.Format("{0:N2}" + "%", result[1][0] * 100);
var allTop2 = string.Format("{0:N2}" + "%", result[1][1] * 100);
var allTop3 = string.Format("{0:N2}" + "%", result[1][2] * 100);
var allTop4 = string.Format("{0:N2}" + "%", result[1][3] * 100);
var allTop5 = string.Format("{0:N2}" + "%", result[1][4] * 100);
IRow row6 = sheet1.CreateRow(6);
ICell cell61 = row6.CreateCell(0);
cell61.CellStyle = cellstyleConTitle;
cell61.SetCellValue("培训满意度评价项目");
ICell cell62 = row6.CreateCell(1);
cell62.CellStyle = cellstyleConTitle;
cell62.SetCellValue("培训满意度评价项目");
ICell cell63 = row6.CreateCell(2);
cell63.CellStyle = cellstyleContent;
cell63.SetCellValue("很满意");
ICell cell64 = row6.CreateCell(3);
cell64.CellStyle = cellstyleContent;
cell64.SetCellValue("满意");
ICell cell65 = row6.CreateCell(4);
cell65.CellStyle = cellstyleContent;
cell65.SetCellValue("一般");
ICell cell66 = row6.CreateCell(5);
cell66.CellStyle = cellstyleContent;
cell66.SetCellValue("不满意");
SetCellRangeAddress(sheet1, 6, 6, 0, 1);
IRow row7 = sheet1.CreateRow(7);
ICell cell71 = row7.CreateCell(0);
cell71.CellStyle = cellstyleConTitle;
cell71.SetCellValue("本次课程总体满意度");
ICell cell72 = row7.CreateCell(1);
cell72.CellStyle = cellstyleConTitle;
cell72.SetCellValue("本次课程总体满意度");
ICell cell73 = row7.CreateCell(2);
cell73.CellStyle = cellstyleContent;
cell73.SetCellValue(allTop2);
ICell cell74 = row7.CreateCell(3);
cell74.CellStyle = cellstyleContent;
cell74.SetCellValue(allTop3);
ICell cell75 = row7.CreateCell(4);
cell75.CellStyle = cellstyleContent;
cell75.SetCellValue(allTop4);
ICell cell76 = row7.CreateCell(5);
cell76.CellStyle = cellstyleContent;
cell76.SetCellValue(allTop5);
SetCellRangeAddress(sheet1, 7, 7, 0, 1);
var startRowNum = 8;
var startKey = 2;
SetDetailValue("课程内容",
new []{"课程主题清晰明确","课程内容丰富、能吸引人","课程内容切合实际，能指导实践","课程内容重点突出，易于理解","课程内容有助于个人发展"},
result, ref startRowNum, sheet1, cellstyleContent, cellstyleConTitle, ref startKey, cellstyleConTitleLeft);
SetDetailValue("培训讲师",
new[] { "讲师准备比较充分", "语言表达清晰，态度端正", "仪表仪容端庄大方，有亲和力", "培训方式多样，生动有趣", "与学员沟通和互动有效" },
result, ref startRowNum, sheet1, cellstyleContent, cellstyleConTitle, ref startKey, cellstyleConTitleLeft);
SetDetailValue("培训组织和管理",
new[] { "培训服务周到细致", "培训时间安排和控制合理", "培训场所、设备安排到位" },
result, ref startRowNum, sheet1, cellstyleContent, cellstyleConTitle, ref startKey, cellstyleConTitleLeft);
IRow endrow = sheet1.CreateRow(startRowNum);
ICell endcell1 = endrow.CreateCell(0);
endcell1.CellStyle = cellstyleConTitle;
endcell1.SetCellValue("测评单位");
ICell endcell12 = endrow.CreateCell(1);
endcell12.CellStyle = cellstyleContent;
endcell12.SetCellValue("海淀区教育党校");
ICell endcell13 = endrow.CreateCell(2);
endcell13.CellStyle = cellstyleConTitle;
endcell13.SetCellValue("测评时间");
ICell endcell14 = endrow.CreateCell(3);
endcell14.CellStyle = cellstyleContent;
endcell14.SetCellValue(DateTime.Now.ToString("yyyy-MM-dd"));
ICell endcell15 = endrow.CreateCell(4);
endcell15.CellStyle = cellstyleContent;
endcell15.SetCellValue(DateTime.Now.ToString("yyyy-MM-dd"));
ICell endcell16 = endrow.CreateCell(5);
endcell16.CellStyle = cellstyleContent;
endcell16.SetCellValue(DateTime.Now.ToString("yyyy-MM-dd"));
SetCellRangeAddress(sheet1, startRowNum, startRowNum, 3, 5);
}
}
GetSuggestion(courseId.ToString());
}
private void ExportCourseReport(HttpContext context)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("课程名称");
fieldsNames.Add("课程主题清晰明确");
fieldsNames.Add("课程内容丰富、能吸引人");
fieldsNames.Add("课程内容切合实际，能指导实践");
fieldsNames.Add("课程内容重点突出，易于理解");
fieldsNames.Add("课程内容有助于个人发展");
var quesBll = new BLL.Questionnaire();
var dt = quesBll.GetCourseReport();
dt.Columns.Remove("CourseId");
dt.Columns.Remove("CourseSubject");
dt.Columns.Remove("CourseDevelop");
dt.Columns.Remove("CourseKey");
dt.Columns.Remove("CoursePractical");
dt.Columns.Remove("CourseRich");
dt.Columns.Remove("TotalDone");
dt.Columns.Remove("TotalCourse");
dt.AcceptChanges();
var filename = "课程内容满意度分布表.xls";
exXls.ExportCourseReportToxls(context.Response, fieldsNames, dt, filename);
}
private void ExportOrgReport(HttpContext context)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("课程名称");
fieldsNames.Add("培训服务周到细致");
fieldsNames.Add("培训时间安排和控制合理");
fieldsNames.Add("培训场所、设备安排到位");
var quesBll = new BLL.Questionnaire();
var dt = quesBll.GetOrgReport();
dt.Columns.Remove("CourseId");
dt.Columns.Remove("OrgArrange");
dt.Columns.Remove("OrgService");
dt.Columns.Remove("OrgTime");
dt.Columns.Remove("TotalDone");
dt.Columns.Remove("TotalOrg");
dt.AcceptChanges();
var filename = "培训组织和管理满意度分布表.xls";
exXls.ExportOrgReportToxls(context.Response, fieldsNames, dt, filename);
}
private void SetTeacherReports()
{
var str = new StringBuilder();
str.Append("<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" bordercolor=\"#000000\" bgcolor=\"#FFFFFF\" " +
" style=\"border-collapse:collapse;font-size: 14px;text-align:center\" >");
str.Append("<tr height=\"40\"> ");
str.Append("<td colspan='6'> <span style=\"font-size: 25px;font-weight: bold\">培训讲师各指标满意度分布表</span><br/> </td>");
str.Append("</tr> ");
str.Append("<tr height=\"35\" bgcolor=\"#F0F9FF\" >");
str.Append("<td rowspan=\"2\" ><strong>课程名称</strong></td>");
// str.Append("<td rowspan=\"2\" ><strong>培训教师</strong></td>");
// str.Append("<td rowspan=\"2\" ><strong>培训时间</strong></td>");
str.Append("<td colspan=\"5\" ><strong>培训讲师各指标满意度</strong></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\" bgcolor=\"#F0F9FF\">");
str.Append("<td><strong>讲师准备比较充分</strong></td>");
str.Append("<td><strong>语言表达清晰，态度端正</strong></td>");
str.Append("<td><strong>仪表仪容端庄大方，有亲和力</strong></td>");
str.Append("<td><strong>培训方式多样，生动有趣</strong></td>");
str.Append("<td><strong>与学员沟通和互动有效</strong></td>");
str.Append("</tr>");
var report = new BLL.Questionnaire();
var dt = report.GetTeacherReport();
var i = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var teacherBearingP = Convert.ToDouble(row["TeacherBearingP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TeacherBearingP"]) * 100);
var teacherCommunicationP = Convert.ToDouble(row["TeacherCommunicationP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TeacherCommunicationP"]) * 100);
var teacherLanguageP = Convert.ToDouble(row["TeacherLanguageP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TeacherLanguageP"]) * 100);
var teacherPrepareP = Convert.ToDouble(row["TeacherPrepareP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TeacherPrepareP"]) * 100);
var teacherStyleP = Convert.ToDouble(row["TeacherStyleP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TeacherStyleP"]) * 100);
i++;
var color = i % 2 == 1 ? "#FFFFFF" : "#F0F9FF";
str.Append("<tr height=\"35\" bgcolor=\"" + color + "\" > ");
str.Append("<td>" + row["CourseName"] + " </td>");
// str.Append("<td>" + row["TeacherName"] + " </td>");
// str.Append("<td>" + row["TeachTime"] + " </td>");
str.Append("<td>" + teacherPrepareP + " </td>");
str.Append("<td>" + teacherLanguageP + " </td>");
str.Append("<td>" + teacherBearingP + " </td>");
str.Append("<td>" + teacherStyleP + " </td>");
str.Append("<td>" + teacherCommunicationP + " </td>");
str.Append("</tr>");
}
}
//i++;
//var color1 = i % 2 == 1 ? "#FFFFFF" : "#F0F9FF";
//str.Append("<tr height=\"35\" bgcolor=\"" + color1 + "\" > ");
//str.Append("<td colspan='10'>");
//str.Append("总平均分=各项得分总和/实评人数；满意度=（很满意+满意）/实评人数； 课程（讲师或者组织）的满意度=每项满意度相加/项数 ");
//str.Append("</td>");
//str.Append("</tr>");
str.Append("<tr height=\"35\" bgcolor=\"#FFFFFF\" > ");
str.Append("<td colspan='10'>");
str.Append("<a href=\"javascript:void(0)\" class=\"easyui-linkbutton c6\" iconcls=\"icon-ok\" onclick=\"getTeacherReports()\" style=\"width: 120px\">导出</a>");
str.Append("</td>");
str.Append("</tr>");
str.Append("</table>");
divReports.InnerHtml = str.ToString();
}
private void ExportStuNoFinish(HttpContext context, string id)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("学员姓名");
fieldsNames.Add("所在学校");
fieldsNames.Add("联系电话");
var quesBll = new BLL.Questionnaire();
var ds = quesBll.GetNofinishedStu(id);
var courseBll = new BLL.Course();
var courseModel = courseBll.GetModel(new Guid(id));
var filename = courseModel.CourseName + "--未完成学员.xls";
if (ds != null && ds.Tables.Count > 0)
{
exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename);
}
}
/// <summary>
/// 课程评估总体情况表
/// </summary>
private void SetTotalReports()
{
var str = new StringBuilder();
str.Append( "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" bordercolor=\"#000000\" bgcolor=\"#FFFFFF\" " +
" style=\"border-collapse:collapse;font-size: 14px;text-align:center\" >");
str.Append("<tr height=\"40\"> ");
str.Append("<td colspan='10'> <span style=\"font-size: 25px;font-weight: bold\">课程评估总体情况统计表</span><br/> </td>");
str.Append("</tr> ");
str.Append("<tr height=\"35\" bgcolor=\"#F0F9FF\" >");
str.Append("<td><strong>课程名称</strong></td>");
str.Append("<td><strong>授课教师</strong></td>");
str.Append("<td><strong>总平均分（满分52分）</strong></td>");
str.Append("<td><strong>总体满意度</strong></td>");
str.Append("<td><strong>评估等级</strong></td>");
str.Append("<td><strong>课程内容满意度</strong></td>");
str.Append("<td><strong>培训讲师满意度</strong></td>");
str.Append("<td><strong>培训组织和管理满意度</strong></td>");
str.Append("<td><strong>实评人数</strong></td>");
str.Append("<td><strong>培训时间</strong></td>");
str.Append("</tr>");
var report = new BLL.Questionnaire();
var dt = report.GetTotalReport();
var i = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var totalSatisfy = Convert.ToDouble(row["TotalSatisfy"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TotalSatisfy"]) * 100);
var totalCourse = Convert.ToDouble(row["TotalCourse"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TotalCourse"]) * 100);
var totalTeacher = Convert.ToDouble(row["TotalTeacher"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TotalTeacher"]) * 100);
var totalOrg = Convert.ToDouble(row["TotalOrg"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["TotalOrg"]) * 100);
i++;
var color = i % 2 == 1 ? "#FFFFFF" : "#F0F9FF";
str.Append("<tr height=\"35\" bgcolor=\""+color+"\" > ");
str.Append("<td>" + row["CourseName"] + " </td>");
str.Append("<td>" + row["TeacherName"] + " </td>");
str.Append("<td>" + string.Format("{0:N2}",row["TotalAvgScore"]) + " </td>");
str.Append("<td>" + totalSatisfy + " </td>");
str.Append("<td>" + row["ToLevel"] + " </td>");
str.Append("<td>" + totalCourse + " </td>");
str.Append("<td>" + totalTeacher + " </td>");
str.Append("<td>" + totalOrg + " </td>");
str.Append("<td>" + row["TotalDone"] + " </td>");
str.Append("<td>" + row["TeachTime"] + " </td>");
str.Append("</tr>");
}
}
i++;
var color1 = i % 2 == 1 ? "#FFFFFF" : "#F0F9FF";
str.Append("<tr height=\"35\" bgcolor=\""+color1+"\" > ");
str.Append("<td colspan='10'>");
str.Append("总平均分=各项得分总和/实评人数；满意度=（很满意+满意）/实评人数； 课程（讲师或者组织）的满意度=每项满意度相加/项数 ");
str.Append("</td>");
str.Append("</tr>");
str.Append("<tr height=\"35\" bgcolor=\"#FFFFFF\" > ");
str.Append("<td colspan='10'>");
str.Append("<a href=\"javascript:void(0)\" class=\"easyui-linkbutton c6\" iconcls=\"icon-ok\" onclick=\"getTotalReports()\" style=\"width: 120px\">导出</a>");
str.Append("</td>");
str.Append("</tr>");
str.Append("</table>");
divReports.InnerHtml = str.ToString();
}
private void ExportTeacherReport(HttpContext context)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("课程名称");
fieldsNames.Add("讲师准备比较充分");
fieldsNames.Add("语言表达清晰，态度端正");
fieldsNames.Add("仪表仪容端庄大方，有亲和力");
fieldsNames.Add("培训方式多样，生动有趣");
fieldsNames.Add("与学员沟通和互动有效");
var quesBll = new BLL.Questionnaire();
var dt = quesBll.GetTeacherReport();
dt.Columns.Remove("CourseId");
dt.Columns.Remove("TeacherName");
dt.Columns.Remove("TeachTime");
dt.Columns.Remove("TeacherBearing");
dt.Columns.Remove("TeacherCommunication");
dt.Columns.Remove("TeacherLanguage");
dt.Columns.Remove("TeacherPrepare");
dt.Columns.Remove("TeacherStyle");
dt.Columns.Remove("TotalDone");
dt.Columns.Remove("TotalTeacher");
dt.AcceptChanges();
var filename = "培训讲师各指标满意度分布表.xls";
exXls.ExportTeacherReportToxls(context.Response, fieldsNames, dt, filename);
}
private void SetCourseReports()
{
var str = new StringBuilder();
str.Append("<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" bordercolor=\"#000000\" bgcolor=\"#FFFFFF\" " +
" style=\"border-collapse:collapse;font-size: 14px;text-align:center\" >");
str.Append("<tr height=\"40\"> ");
str.Append("<td colspan='6'> <span style=\"font-size: 25px;font-weight: bold\">课程内容各指标满意度分布表</span><br/> </td>");
str.Append("</tr> ");
str.Append("<tr height=\"35\" bgcolor=\"#F0F9FF\" >");
str.Append("<td rowspan=\"2\" ><strong>课程名称</strong></td>");
// str.Append("<td rowspan=\"2\" ><strong>培训教师</strong></td>");
// str.Append("<td rowspan=\"2\" ><strong>培训时间</strong></td>");
str.Append("<td colspan=\"5\" ><strong>课程内容各指标满意度</strong></td>");
str.Append("</tr>");
str.Append("<tr height=\"35\" bgcolor=\"#F0F9FF\">");
str.Append("<td><strong>课程主题清晰明确</strong></td>");
str.Append("<td><strong>课程内容丰富、能吸引人</strong></td>");
str.Append("<td><strong>课程内容切合实际，能指导实践</strong></td>");
str.Append("<td><strong>课程内容重点突出，易于理解</strong></td>");
str.Append("<td><strong>课程内容有助于个人发展</strong></td>");
str.Append("</tr>");
var report = new BLL.Questionnaire();
var dt = report.GetCourseReport();
var i = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var courseSubjectP = Convert.ToDouble(row["CourseSubjectP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["CourseSubjectP"]) * 100);
var courseDevelopP = Convert.ToDouble(row["CourseDevelopP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["CourseDevelopP"]) * 100);
var courseKeyP = Convert.ToDouble(row["CourseKeyP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["CourseKeyP"]) * 100);
var coursePracticalP = Convert.ToDouble(row["CoursePracticalP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["CoursePracticalP"]) * 100);
var courseRichP = Convert.ToDouble(row["CourseRichP"]) >= 1.0
? "100%"
: string.Format("{0:N2}%", Convert.ToDouble(row["CourseRichP"]) * 100);
i++;
var color = i % 2 == 1 ? "#FFFFFF" : "#F0F9FF";
str.Append("<tr height=\"35\" bgcolor=\"" + color + "\" > ");
str.Append("<td>" + row["CourseName"] + " </td>");
// str.Append("<td>" + row["TeacherName"] + " </td>");
// str.Append("<td>" + row["TeachTime"] + " </td>");
str.Append("<td>" + courseSubjectP + " </td>");
str.Append("<td>" + courseRichP + " </td>");
str.Append("<td>" + coursePracticalP + " </td>");
str.Append("<td>" + courseKeyP + " </td>");
str.Append("<td>" + courseDevelopP + " </td>");
str.Append("</tr>");
}
}
//i++;
//var color1 = i % 2 == 1 ? "#FFFFFF" : "#F0F9FF";
//str.Append("<tr height=\"35\" bgcolor=\"" + color1 + "\" > ");
//str.Append("<td colspan='10'>");
//str.Append("总平均分=各项得分总和/实评人数；满意度=（很满意+满意）/实评人数； 课程（讲师或者组织）的满意度=每项满意度相加/项数 ");
//str.Append("</td>");
//str.Append("</tr>");
str.Append("<tr height=\"35\" bgcolor=\"#FFFFFF\" > ");
str.Append("<td colspan='10'>");
str.Append("<a href=\"javascript:void(0)\" class=\"easyui-linkbutton c6\" iconcls=\"icon-ok\" onclick=\"getCourseReports()\" style=\"width: 120px\">导出</a>");
str.Append("</td>");
str.Append("</tr>");
str.Append("</table>");
divReports.InnerHtml = str.ToString();
}
private void GetDataStudent(HttpContext context)
{
var ds = new DataSet();
var courseId = context.Request["coId"];
var page = Convert.ToInt32(context.Request["page"]);
var rows = Convert.ToInt32(context.Request["rows"]);
var startIndex = (page - 1) * rows + 1;
var endIndex = startIndex + rows - 1;
var stuBll = new BLL.Student();
var questionbll = new BLL.Questionnaire();
var num = stuBll.GetRecordCount("");
// ds = questionbll.GetCourseStudentState(courseId);
ds = questionbll.GetCourseStudentStateListByPage(courseId,"ck",startIndex,endIndex);
var str = JsonConvert.SerializeObject(new { total = num, rows = ds.Tables[0] });
context.Response.Write(str);
}
private void SetValue()
{
try
{
var courseId = Guid.Empty;
var coursebll = new BLL.Course();
if (!string.IsNullOrEmpty(Request.QueryString["cid"]))
{
courseId = new Guid(Request.QueryString["cid"]);
hCourseid.Value = courseId.ToString();
}
else //取个默认的
{
courseId = coursebll.GetTop1Guid();
hCourseid.Value = courseId.ToString();
}
var courseModel = coursebll.GetModel(courseId);
courseName.InnerText = courseModel.CourseName;
coursePlace.InnerText = courseModel.TeachPlace;
teacherName.InnerText = courseModel.TeacherName;
trainTime.InnerText = courseModel.TeachTime;
var question = new BLL.Questionnaire();
var dsResult = question.GetReportTile(courseId);
if (dsResult != null && dsResult.Tables.Count > 0)
{
var row = dsResult.Tables[0].Rows[0];
spTotalAvg.InnerText = string.Format("{0:N2}", row["totalAvg"]) + " 分（满分52）";
satisfaction.InnerText =Convert.ToDouble(row["Satisfy"])>=1.0? "100%": string.Format("{0:N2}" + "%", ((Convert.ToDecimal(row["Satisfy"])) * 100));
level.InnerText = question.GetLevel((Convert.ToDouble(row["Satisfy"])));
}
var dsrr = question.GetTotalReport();
if (dsrr != null && dsrr.Rows.Count > 0)
{
var result = dsrr.Select(string.Format(" CourseId='{0}'",courseId));
if (result.Length > 0)
{
divCourseContent.InnerText = Convert.ToDouble(result[0]["TotalCourse"]) >= 1.0 ? "100%" : string.Format("{0:N2}" + "%", ((Convert.ToDecimal(result[0]["TotalCourse"])) * 100));
divTeacher.InnerText = Convert.ToDouble(result[0]["TotalTeacher"]) >= 1.0 ? "100%" : string.Format("{0:N2}" + "%", ((Convert.ToDecimal(result[0]["TotalTeacher"])) * 100));
divOrg.InnerText = Convert.ToDouble(result[0]["TotalOrg"]) >= 1.0 ? "100%" : string.Format("{0:N2}" + "%", ((Convert.ToDecimal(result[0]["TotalOrg"])) * 100));
}
}
//var totalAvg = question.GetTotalAvg(courseId.ToString());
//spTotalAvg.InnerText = totalAvg.ToString();
//satisfaction.InnerText = string.Format("{0:N2}" + "%", (((float) totalAvg/52)*100));
//level.InnerText = question.GetLevel(((float)totalAvg / 52));
var statifyPercent = question.GetSatisfyPercent(courseId);
if (statifyPercent != null)
{
htp1.Value = string.Format("{0:N2}", ((statifyPercent[0])*100));
htp2.Value = string.Format("{0:N2}", ((statifyPercent[1]) * 100));
htp3.Value = string.Format("{0:N2}", ((statifyPercent[2]) * 100));
htp4.Value = string.Format("{0:N2}", ((statifyPercent[3]) * 100));
htp5.Value = string.Format("{0:N2}", ((statifyPercent[4]) * 100));
// nofinish.InnerText = statifyPercent[5].ToString();
totalPeople.InnerText = statifyPercent[6].ToString()+" 人";
totalDone.InnerText = statifyPercent[7].ToString() + " 人";
evProgress.InnerText = string.Format("{0:N2}%", ((statifyPercent[7] / statifyPercent[6]) * 100));
}
SetDetail(courseId);
#region old tendency
//var tendency = question.GetTendency(courseId);
//if (tendency != null)
//{
// htot1.Value = string.Format("{0:N2}", ((tendency[0]) ));
// htot2.Value = string.Format("{0:N2}", ((tendency[1])));
// htot3.Value = string.Format("{0:N2}", ((tendency[2])));
// htot4.Value = string.Format("{0:N2}", ((tendency[3])));
// htot5.Value = string.Format("{0:N2}", ((tendency[4])));
//}
#endregion
#region old the six
//var theTop6 = question.GetTheSix(courseId, true);
//if (theTop6 != null)
//{
// var result = new StringBuilder();
// var i = 0;
// foreach (var thetop in theTop6)
// {
// i++;
// result.Append(i + "、" + thetop + @"<br>");
// }
// top6.InnerHtml = result.ToString();
//}
//var theBottom6 = question.GetTheSix(courseId, false);
//if (theBottom6 != null)
//{
// var result = new StringBuilder();
// var i = 0;
// foreach (var thebop in theBottom6)
// {
// i++;
// result.Append(i + "、" + thebop + @"<br>");
// }
// bot6.InnerHtml = result.ToString();
//}
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLogofExceptioin(ex);
}
}
/// <summary>
/// 提取意见列表
/// </summary>
/// <param name="context"></param>
private void GetSuggestions(HttpContext context)
{
var ds = new DataSet();
var courBll = new BLL.Course();
ds = courBll.GetAllList();
var courseId = context.Request["coId"];
if (!string.IsNullOrEmpty(courseId))
{
var page = Convert.ToInt32(context.Request["page"]);
var rows = Convert.ToInt32(context.Request["rows"]);
var startIndex = (page - 1) * rows + 1;
var endIndex = startIndex + rows - 1;
var questionbll = new BLL.Questionnaire();
var num = questionbll.GetSuggestion(courseId) == null ? 0 : questionbll.GetSuggestion(courseId).Tables[0].Rows.Count;
ds = questionbll.GetSuggestionByPage(courseId, "", startIndex, endIndex);
var str = JsonConvert.SerializeObject(new { total = num, rows = ds.Tables[0] });
context.Response.Write(str);
}
}
private void AddData(HttpContext context)
{
var msg = "";
var courseId = context.Request["CourseId"];
var isAll = context.Request["IsAll"];
if (!string.IsNullOrEmpty(isAll)) //全选
{
if (isAll == "1")
{
var questionBll = new BLL.Questionnaire();
var result = questionBll.SaveQuestionsForAll(courseId);
if (!result)
{
msg = "保存失败！";
}
}
else //全不选
{
var questionBll = new BLL.Questionnaire();
var result = questionBll.DeletCourseStudentbyCourseId(courseId);
if (!result)
{
msg = "保存失败！";
}
}
}
else
{
var stuids = context.Request["StuIds"];
var unstuids = context.Request["UnStuIds"];
if (!string.IsNullOrEmpty(stuids))
{
if (!string.IsNullOrEmpty(unstuids))
{
var unid = unstuids.Split('|');
if (unid.Length > 0)
{
foreach (var uid in unid)
{
if (!string.IsNullOrEmpty(uid))
{
stuids = stuids.Replace(uid, "");
}
}
}
}
var stu = stuids.Split('|');
var stuList = new List<string>();
foreach (var sid in stu)
{
if (!string.IsNullOrEmpty(sid))
{
if (!stuList.Contains(sid))
{
stuList.Add(sid);
}
}
}
var questionBll = new BLL.Questionnaire();
var result = questionBll.SaveQuestions(stuList.ToArray(), courseId);
if (!result)
{
msg = "保存失败！";
}
}
else
{
var questionBll = new BLL.Questionnaire();
var result = questionBll.SaveQuestions(null, courseId);
if (!result)
{
msg = "保存失败！";
}
}
}
context.Response.Write(msg);
}
private void SetDisplay(string courseId)
{
quTime.Visible = false;
var queBll = new BLL.Questionnaire();
var ds = queBll.GetCourseQuestionnarieInfo(Profile.CurrentUser.UserId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows.Count > 1)
{
btnSubmit.ImageUrl = "~/images/regist2.jpg";
}
else
{
btnSubmit.ImageUrl = "~/images/regist1.jpg";
}
}
else
{
btnSubmit.ImageUrl = "~/images/regist1.jpg";
}
if (!string.IsNullOrEmpty(courseId)) //点击后传过来的
{
var course = new BLL.Course();
var couModel = course.GetModel(new Guid(courseId));
// coName.InnerText = couModel.CourseName;
hCouseId.Value = couModel.CourseId.ToString();
ipCourseName.InnerText = couModel.CourseName;
ipPlace.InnerText = couModel.TeachPlace;
ipTeacher.InnerText = couModel.TeacherName;
ipTime.InnerText = couModel.TeachTime;
// GetTheLeft();
quNo.Visible = false;
queHas.Visible = true;
// queHas1.Visible = true;
}
else
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
hCouseId.Value = ds.Tables[0].Rows[0]["CourseId"].ToString();
// coName.InnerText = ds.Tables[0].Rows[0]["CourseName"].ToString();
//var sb = new StringBuilder();
//var i = 0;
//foreach (DataRow row in ds.Tables[0].Rows)
//{
// i++;
// sb.Append("<span onclick='toOther(\"" + row["CourseId"] + "\")' style='cursor: pointer'>");
// sb.Append(i + "、");
// sb.Append(row["CourseName"]);
// sb.Append(@"</span>");
// sb.Append(@"<br/><br/>");
//}
// CourseNames.InnerHtml = sb.ToString();
ipCourseName.InnerText = ds.Tables[0].Rows[0]["CourseName"].ToString();
ipPlace.InnerText = ds.Tables[0].Rows[0]["TeachPlace"].ToString();
ipTeacher.InnerText = ds.Tables[0].Rows[0]["TeacherName"].ToString();
ipTime.InnerText = ds.Tables[0].Rows[0]["TeachTime"].ToString();
quNo.Visible = false;
queHas.Visible = true;
// queHas1.Visible = true;
}
else
{
quNo.Visible = true;
queHas.Visible = false;
// queHas1.Visible = false;
//Response.Redirect("");
}
}
}
private void DelData(string id, HttpContext context)
{
var queBll = new BLL.Questionnaire();
var result = false;
var msg = "";
try
{
result = queBll.DeletCourseStudentbyCourseId(id);
if (!result)
{
msg = "保存失败！";
}
}
catch (Exception ex)
{
LogHelper.WriteLogofExceptioin(ex);
result = false;
msg = ex.Message;
}
// var str = JsonConvert.SerializeObject(new { success = result, errorMsg = msg});
context.Response.Write(msg);
}
