1，查询教师证书 public ActionResult SelectTeaCertificateByNumber(string TeacherNumber) //查询教师证书 { try { var listResult = (from tbachievement in myModel.PW_Achievement jointbCertificateIinmyModel.CertificateITableon tbachievement.AchievementID equals tbCertificateI.AchievementID join tbUser in myModel.PW_User on tbachievement.UserID equals tbUser.UserID jointbTeacher in myModel.PW_Teacher on tbUser.UserID equals tbTeacher.UserID where tbTeacher.TeacherNumber == TeacherNumber select new CertificateInfor { CertificateNumber = tbCertificateI.CertificateNumber, IssuanceUnit = tbCertificateI.IssuanceUnit, StrIssuanceTime = tbCertificateI.IssuanceTime.ToString(), StartTime = tbachievement.StTime.ToString(), Achievement = tbachievement.Achievement.ToString(), StudentName = tbTeacher.TeacherName, StudentID = tbTeacher.TeacherID, StudentNumber = tbTeacher.TeacherNumber.Trim() } ).ToList(); return Json(listResult, JsonRequestBehavior.AllowGet); } catch (Exception) { return Json("", JsonRequestBehavior.AllowGet); } } /// /// 1.3查询教师编号 /// /summary /// param name=“UserID”/param /// returns/returns public ActionResult SelectTeacherNumber(int UserID)//查询教师编号 { var listNumber = myModel.PW_Teacher.Where(m => m.UserID == UserID).Select(m => m.TeacherNumber).ToList(); return Json(listNumber, JsonRequestBehavior.AllowGet); } div class=“container-fluid” div class=“row” div class=“col-lg-8 col-md-8 col-sm-8 left” divclass="left-titles"id="titlesInfor"contenteditable=“true” style=“overflow:auto;” !–题目信息– /div div class=“row btngroup” div class=“col-md-2 col-sm-2” style=“text-align:center;” label class=“control-label” style="margin-top:6px;"所属科目/label /div div class=“col-md-3 col-sm-3” style=“padding:0;” selectclass="form-control"id=“Subject” style=“margin-left:-20px;”/select /div div class=“col-md-2 col-sm-2” style=“text-align:center;” label class=“control-label” style="margin-top:6px;"适用单位/label /div div class=“col-md-3 col-sm-3” style=“padding:0;” select class=“form-control” id=“Unit” style=“margin-left:-20px;”/select /div div class=“col-md-2 col-sm-2” button class=“btn btn-primary” type=“button” οnclick="downloadTemplet()"下载模板/button /div /div div class=“row btngroup” div class=“col-md-2 col-sm-2 col-md-offset-4 col-sm-offset-4” input id=“ImportTitles” class=“btn btn-primary” type=“button” value=“导入试题” / /div div class=“col-md-2 col-sm-2” button class=“btn btn-primary” type=“button” οnclick="saveImport()"上传试题/button /div /div /div div class=“col-sm-4 right” div class="h5"录入注意事项/div p 1、题目的录入规范要与上传模板相符合/p p 2、上 传时要把题型、难度、知识点与数据库中题型、难度、知识点对应，否则是录入不进的/p p 3、上传的文件中不可以出现全角的字母或字，不可以出现除黑色外的其他颜色的字/p p 4、上传的文件中不可以有编号列表/p P 5、上传的word文件中如果出现↓这个箭头一定要改为←┘(回车)/p p 6、上传的文件中题型下的要按照标准的，就是只能在每行结束时必须按回车/p p 7、例如：在答案：A之后一定要按回车，不然正确的题目也是录不进的/p p 8、在传输的过程中，会有一些数字重复,缺少换行需要手动修改；如果不按照规则修改将会导致试题的不完整，就要在修改试题中修改/p p 9、上传的word文件中的格式要和范列导入的格式一样，之后的修改就按导入到界面的格式来修改/p p 10、上传到界面的内容必须要检查一遍或者多遍！！！/p p 11、支持手动录入试题，不过一定要按照导入界面的格式来添加/p /div /div /div
