public ActionResult HeBeiStudentTestTableExport() { DirFileHelper.ClearDirectory("/Areas/ZhangCeModule/UploadFile"); DStudent_TestScoreBll tcBll = new DStudent_TestScoreBll(); List <HeBeiStudents> heBeiSList = tcBll.GetHeBeiStudentInfoExport(CookieHelper.GetCookie("NK")); StringBuilder HeBeiHtmlTable = new StringBuilder(); HeBeiHtmlTable.Append("<table>"); HeBeiHtmlTable.Append("<tr><th >序号</th><th>新生来源地(以省内11个设区市为单位)</th><th>性别</th><th>人数</th><th>优秀率</th><th>良好率</th><th>及格率</th><th>总达标率</th></tr>"); string mes = ""; foreach (HeBeiStudents heBeiS in heBeiSList) { mes = mes + string.Format("<tr><th>{0}</th><th>{1}</th><th>{2}</th><th>{3}</th><th>{4}</th><th>{5}</th><th>{6}</th><th>{7}</th></tr>", heBeiS.ID, heBeiS.StudentAddress, heBeiS.StudentSex, heBeiS.StudentCount, heBeiS.Outstanding, heBeiS.Goodrate, heBeiS.PassRate, heBeiS.TotalRate); } HeBeiHtmlTable.Append(mes); HeBeiHtmlTable.Append("</table>"); // 进行Excel转换操作,并返回转换的文件下载链接 string urlPath = DeriveExcel.ExportHtmlTableToExcel(HeBeiHtmlTable.ToString(), "河北新生表"); var path = Server.MapPath("~/" + urlPath); var name = Path.GetFileName(path); return(File(path, "application/vnd.ms-excel", name)); }
/// <summary> /// 删除学生 /// </summary> /// <param name="id">主键</param> /// <param name="NK">所属年份</param> /// <returns>数值>0成功,=0失败</returns> public int DelDStudentInfos(int id, string NK) { DStudent_TestScoreBll tsBll = new DStudent_TestScoreBll(); tsBll.DeleteStudentTestScoreByStudentCode(GetDStudentInfosModelById(id, NK).StudentCode, NK); StringBuilder strSql = new StringBuilder(); List <DbParameter> parameter = new List <DbParameter>(); strSql.Append("DELETE DStudent_Infos" + NK + " WHERE ID=@ID"); parameter.Add(DbFactory.CreateDbParameter("@ID", id)); return(Repository().ExecuteBySql(strSql, parameter.ToArray())); }
public ActionResult StudentScoreManExcelExport() { DirFileHelper.ClearDirectory("/Areas/ZhangCeModule/UploadFile"); DStudent_TestScoreBll tcBll = new DStudent_TestScoreBll(); // 1.获取数据集合 List <StudentScoreExcel> list = tcBll.GetDStudentTestScoreListExport(CookieHelper.GetCookie("NK"), "1"); // 2.设置单元格抬头 // key:实体对象属性名称,可通过反射获取值 // value:Excel列的名称 Dictionary <string, string> cellheader = new Dictionary <string, string> { { "GradeCode", "年级编号" }, { "ClassCode", "班级编号" }, { "ClassName", "班级名称" }, { "StudentCode", "学籍号" }, { "NationCode", "民族代码" }, { "StudentName", "姓名" }, { "StudentSex", "性别(男:1,女:2)" }, { "StudentBornDate", "出生日期" }, { "StudentSource", "学生来源" }, { "StudentIDNumber", "身份证号" }, { "StudentNative", "家庭住址" }, { "Heigh", "身高" }, { "Weight", "体重" }, { "Pulmonary", "肺活量" }, { "FiftyRun", "50米跑" }, { "StandJump", "立定跳远" }, { "SitAndReach", "坐位体前屈" }, { "EightHundred", "800米跑" }, { "ThousandRun", "1000米跑" }, { "MinSupination", "一分钟仰卧起坐" }, { "PullUp", "引体向上" }, }; // 3.进行Excel转换操作,并返回转换的文件下载链接 string urlPath = DeriveExcel.ListToExcel2003(cellheader, list, "学生上报成绩表(男)"); var path = Server.MapPath("~/" + urlPath); var name = Path.GetFileName(path); return(File(path, "application/vnd.ms-excel", name)); }
public ActionResult GridOtherStudentInfoJson(string keyvalue, JqGridParam jqgridparam) { try { Stopwatch watch = CommonHelper.TimerStart(); DStudent_TestScoreBll tcBll = new DStudent_TestScoreBll(); // 1.获取数据集合 DataTable ListData = tcBll.StudentOtherAll(CookieHelper.GetCookie("NK"), ref jqgridparam); var JsonData = new { total = jqgridparam.total, page = jqgridparam.page, records = jqgridparam.records, costtime = CommonHelper.TimerEnd(watch), rows = ListData, }; return(Content(JsonData.ToJson())); } catch (Exception ex) { Base_SysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误:" + ex.Message); return(null); } }
/// <summary> /// 学生信息自定义导出 /// </summary> /// <param name="ExportField"></param> /// <param name="ResultType"></param> /// <returns></returns> public ActionResult StudentOtherExcelExport(string ExportField, string ResultType) { DirFileHelper.ClearDirectory("/Areas/ZhangCeModule/UploadFile"); DStudent_TestScoreBll tcBll = new DStudent_TestScoreBll(); ExportField = ExportField.Substring(0, ExportField.Length - 1); string[] pName = ExportField.Split(','); // 1.获取数据集合 List <StudentScoreExcel> list = tcBll.StudentOtherExport(ResultType, CookieHelper.GetCookie("NK")); // 2.设置单元格抬头 // key:实体对象属性名称,可通过反射获取值 // value:Excel列的名称 Dictionary <string, string> cellheader = new Dictionary <string, string> { }; for (int i = 0; i < pName.Length; i++) { if (pName[i] == "studentcode") { cellheader.Add("StudentCode", "学生学号"); } if (pName[i] == "studentname") { cellheader.Add("StudentName", "学生姓名"); } if (pName[i] == "studentsex") { cellheader.Add("StudentSex", "学生性别"); } if (pName[i] == "studentborndate") { cellheader.Add("StudentBornDate", "出生日期"); } if (pName[i] == "studenthomeaddress") { cellheader.Add("StudentHomeAddress", "学生住址"); } if (pName[i] == "gradecode") { cellheader.Add("GradeCode", "年级编号"); } if (pName[i] == "schoolname") { cellheader.Add("SchoolName", "学院名称"); } if (pName[i] == "schoolcode") { cellheader.Add("SchoolCode", "学院编号"); } if (pName[i] == "classname") { cellheader.Add("ClassName", "班级名称"); } if (pName[i] == "classcode") { cellheader.Add("ClassCode", "班级编号"); } if (pName[i] == "nationcode") { cellheader.Add("NationCode", "民族编号"); } if (pName[i] == "nationname") { cellheader.Add("NationName", "民族名称"); } if (pName[i] == "studentnative") { cellheader.Add("StudentNative", "学生籍贯"); } if (pName[i] == "studentmovetype") { cellheader.Add("StudentMoveType", "异动类型"); } if (pName[i] == "studentidnumber") { cellheader.Add("StudentIDNumber", "学生身份证号"); } if (pName[i] == "studentphone") { cellheader.Add("StudentPhone", "学生电话"); } if (pName[i] == "studentisregister") { cellheader.Add("StudentIsRegister", "是否注册"); } if (pName[i] == "heigh") { cellheader.Add("Heigh", "身高"); } if (pName[i] == "weight") { cellheader.Add("Weight", "体重"); } if (pName[i] == "bmi") { cellheader.Add("BMI", "体重指数"); } if (pName[i] == "bmiscore") { cellheader.Add("BMIScore", "体重指数得分"); } if (pName[i] == "bmilevel") { cellheader.Add("BMILevel", "体重指数级别"); } if (pName[i] == "pulmonary") { cellheader.Add("Pulmonary", "肺活量"); } if (pName[i] == "pulmonaryscore") { cellheader.Add("PulmonaryScore", "肺活量得分"); } if (pName[i] == "pulmonarylevel") { cellheader.Add("PulmonaryLevel", "肺活量级别"); } if (pName[i] == "fiftyrun") { cellheader.Add("FiftyRun", "50米跑"); } if (pName[i] == "fiftyrunscore") { cellheader.Add("FiftyRunScore", "50米跑得分"); } if (pName[i] == "fiftyrunlevel") { cellheader.Add("FiftyRunLevel", "50米跑级别"); } if (pName[i] == "standjump") { cellheader.Add("StandJump", "立定跳远"); } if (pName[i] == "standjumpscore") { cellheader.Add("StandJumpScore", "立定跳远得分"); } if (pName[i] == "standjumplevel") { cellheader.Add("StandJumpLevel", "立定跳远级别"); } if (pName[i] == "sitandreach") { cellheader.Add("SitAndReach", "座位体前屈"); } if (pName[i] == "sitandreachscore") { cellheader.Add("SitAndReachScore", "座位体前屈得分"); } if (pName[i] == "sitandreachlevel") { cellheader.Add("SitAndReachLevel", "座位体前屈级别"); } if (pName[i] == "eighthundred") { cellheader.Add("EightHundred", "800米"); } if (pName[i] == "eighthundredscore") { cellheader.Add("EightHundredScore", "800米得分"); } if (pName[i] == "eighthundredlevel") { cellheader.Add("EightHundredLevel", "800米级别"); } if (pName[i] == "eighthundredaddscore") { cellheader.Add("EightHundredAddScore", "800米加分"); } if (pName[i] == "thousandrun") { cellheader.Add("ThousandRun", "1000米"); } if (pName[i] == "thousandrunscore") { cellheader.Add("ThousandRunScore", "1000米得分"); } if (pName[i] == "thousandrunlevel") { cellheader.Add("ThousandRunLevel", "1000米级别"); } if (pName[i] == "thousandrunaddscore") { cellheader.Add("ThousandRunAddScore", "1000米加分"); } if (pName[i] == "minsupination") { cellheader.Add("MinSupination", "1分钟仰卧起坐"); } if (pName[i] == "minsupinationscore") { cellheader.Add("MinSupinationScore", "1分钟仰卧起坐得分"); } if (pName[i] == "minsupinationlevel") { cellheader.Add("MinSupinationLevel", "1分钟仰卧起坐级别"); } if (pName[i] == "minsupinationaddscore") { cellheader.Add("MinSupinationAddScore", "1分钟仰卧起坐加分"); } if (pName[i] == "pullup") { cellheader.Add("PullUp", "引体向上"); } if (pName[i] == "pullupscore") { cellheader.Add("PullUpScore", "引体向上得分"); } if (pName[i] == "pulluplevel") { cellheader.Add("PullUpLevel", "引体向上级别"); } if (pName[i] == "pullupaddscore") { cellheader.Add("PullUpAddScore", "引体向上加分"); } if (pName[i] == "testresult") { cellheader.Add("TestResult", "测试结果:补测、通过、免测,作弊"); } if (pName[i] == "studenttruescore") { cellheader.Add("StudentTrueScore", "学生最后真是成绩"); } if (pName[i] == "testtype") { cellheader.Add("TestType", "测试类型:正常测试、补测测试"); } if (pName[i] == "createtime") { cellheader.Add("CreateTime", "创建时间"); } if (pName[i] == "updatetime") { cellheader.Add("UpdateTime", "更新时间"); } if (pName[i] == "remark") { cellheader.Add("Remark", "备注"); } } string fuStr = "学生信息自定义导出.xls"; // 3.进行Excel转换操作,并返回转换的文件下载链接 string urlPath = DeriveExcel.ListToExcel2003(cellheader, list, "导出老师体测信息表"); FilePathResult file = new FilePathResult("~/" + urlPath, "application/vnd.ms-excel"); file.FileDownloadName = fuStr; return(file); }