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