public void ProcessRequest(HttpContext context) { //context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); if (context != null && context.Request != null && context.Response != null && context.Request.HttpMethod == "POST") { HttpRequest request = context.Request; // Get HTTP POST form variables, ensuring they are not null. string filename = request.Form["filename"]; string type = request.Form["type"]; int width = 0; string svg = request.Form["svg"]; if (filename != null && type != null && Int32.TryParse(request.Form["width"], out width) && svg != null) { // Create a new chart export object using form variables. // type = "image/jpeg"; Exporter export = new Exporter(filename, type, width, svg); // Write the exported chart to the HTTP Response object. // export.WriteToHttpResponse(context.Response); // Short-circuit this ASP.NET request and end. Short-circuiting // prevents other modules from adding/interfering with the output. //HttpContext.Current.ApplicationInstance.CompleteRequest(); //context.Response.End(); var imgHeight = 0; var imgWidth = 0; var imgbytes = export.GetReportImg(out imgHeight, out imgWidth); var xls=new ExportXls(); xls.ExportImg2Xls(context.Response, imgbytes, "课程满意度分布",imgHeight,imgWidth); } } }
private void ExportStuInfo(HttpContext context) { var exXls = new ExportXls(); var fieldsNames = new List<string>(); fieldsNames.Add("姓名"); fieldsNames.Add("性别"); fieldsNames.Add("身份证号"); fieldsNames.Add("所在单位"); fieldsNames.Add("职务"); fieldsNames.Add("联系电话"); fieldsNames.Add("出生日期"); fieldsNames.Add("民族"); fieldsNames.Add("全日制学历"); fieldsNames.Add("全日制学校"); fieldsNames.Add("在职学历"); fieldsNames.Add("在职学校"); fieldsNames.Add("政治面貌"); fieldsNames.Add("职称"); fieldsNames.Add("现任级别"); fieldsNames.Add("任现任级别时间"); fieldsNames.Add("现任职务"); fieldsNames.Add("任职时间"); fieldsNames.Add("手机号"); fieldsNames.Add("学时"); fieldsNames.Add("描述"); fieldsNames.Add("继教号"); var ds = QueryDataResultForExp(context); var filename =DateTime.Now.ToString("yyyy-MM-dd")+ "-学员信息.xls"; if (ds != null && ds.Tables.Count > 0) { exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename); } }
private void ExportCourseInfo(HttpContext context) { var exXls = new ExportXls(); var fieldsNames = new List<string>(); fieldsNames.Add("课程名称"); fieldsNames.Add("授课教师"); fieldsNames.Add("授课地点"); fieldsNames.Add("授课时间"); var ds = QueryDataResultForExp(context); var filename = DateTime.Now.ToString("yyyy-MM-dd") + "-课程信息.xls"; if (ds != null && ds.Tables.Count > 0) { exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename); } }
private void ExportTeacherInfo(HttpContext context) { var exXls = new ExportXls(); var fieldsNames = new List<string>(); fieldsNames.Add("姓名"); fieldsNames.Add("性别"); fieldsNames.Add("身份证号"); fieldsNames.Add("所在单位"); fieldsNames.Add("职称"); fieldsNames.Add("职务"); fieldsNames.Add("研究方向"); fieldsNames.Add("手机号"); fieldsNames.Add("描述"); var ds = QueryDataResultForExp(context); var filename = DateTime.Now.ToString("yyyy-MM-dd") + "-教师信息.xls"; if (ds != null && ds.Tables.Count > 0) { exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename); } }
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); }
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); }
/// <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 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); } }
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 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 ExportEvReportToxls(HttpContext context, string coursId) { var coid = new Guid(coursId); var couBll = new BLL.Course(); var courseModel = couBll.GetModel(coid); var courseName = courseModel.CourseName; var exXls = new ExportXls(); var filename = courseName + "-评估报告单.xls"; exXls.ExportEvReportToxls(context.Response, filename, coid); }
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); }
/// <summary> /// 上传 /// </summary> /// <param name="context"></param> /// <param name="dtype"></param> /// <returns></returns> private string Upload(HttpContext context, string dtype) { var filename = ""; var basePath = HttpContext.Current.Server.MapPath("UploadTemplate/"); switch (dtype) { case "stu": filename = Guid.NewGuid() + "stu.xls"; break; case "tch": filename = Guid.NewGuid() + "tch.xls"; break; case "cor": filename = Guid.NewGuid() + "cor.xls"; break; default: break; } try { if (!string.IsNullOrEmpty(filename) && context.Request.Files["Filedata"] != null) { HttpPostedFile myFile = context.Request.Files["Filedata"]; int nFileLen = myFile.ContentLength; byte[] myData = new byte[nFileLen]; myFile.InputStream.Read(myData, 0, nFileLen); System.IO.FileStream newFile = new System.IO.FileStream(basePath + filename, System.IO.FileMode.Create); newFile.Write(myData, 0, myData.Length); newFile.Close(); var exp = new ExportXls(); var dt = exp.ExcelToDataTable("", true, basePath + filename); var msg = ""; var result = false; if (dtype == "stu") { result = StudentImport(dt, out msg, filename); } else if (dtype == "tch") { result = TeacherImport(dt, out msg, filename); } else if (dtype == "cor") { result = CourseImport(dt, out msg, filename); } if (result) { return "1"; } else { return msg; } } else { return "0"; } } catch (Exception ex) { LogHelper.WriteFileLog(ex.Message + ex); return "2"; } }