/// <summary> /// 添加Excel的数据 /// </summary> /// <param name="xmlDate"></param> private string AddExcelData(DataTable xmlDate, string testLimit, int testSetID, string testTeacher, string testAddress, string testBeginDate, string testBeginWeek, string testBeginTime, string testGroup, string groupCount, string testType, string NK) { //还原分组和分配老师 dTestAllotBll.DelDStudentTestAllotByTestSetID(Convert.ToInt32(testSetID), CookieHelper.GetCookie("NK")); string errorMsg = ""; int errorcount = 0; //错误的个数 int sumcount = xmlDate.Rows.Count; //导入数据的总个数 int rowindex = 1; //行标 string comname = string.Empty; int i = 1; foreach (DataRow excelRow in xmlDate.Rows) { DStudent_Test testModel = null; bool flg = true;//可添加入库的标识 rowindex++; try { comname = excelRow[0].ToString().Trim(); DStudent_Infos model = dInfoBll.GetDStudentInfosModel(excelRow[0].ToString().Trim(), NK); if (model.SchoolCode == "" || model == null || model.StudentCode == null) { if (flg) { errorcount++; } errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + ",添加失败;失败原因:库中不存在该学生,添加测试失败! <br/>"; flg = false; } else if (model.StudentSex != excelRow[1].ToString().Trim()) { if (flg) { errorcount++; } errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + ",添加失败;失败原因:学生性别和该条测试信息性别不相同,添加测试失败!<br/>"; flg = false; } else { if (model.GradeCode != "40") { if (model.GradeCode == testLimit) { } else { testModel = new DStudent_Test { StudentCode = model.StudentCode, GradeCode = model.GradeCode, SchoolCode = model.SchoolCode, SchoolName = model.SchoolName, ClassCode = model.ClassCode, ClassName = model.ClassName, TestSetID = testSetID, StudentName = model.StudentName, StudentSex = model.StudentSex, TestTeacher = testTeacher, TestAddress = testAddress, BeginPraDate = testBeginDate, BeginWeek = testBeginWeek, BeginPraTime = testBeginTime, ApplyFor = "1", TestGroup = testGroup, TestGroupCode = groupCount == "" ? "" : (Convert.ToInt32(groupCount) + 1).ToString(), TestType = testType, CreateTime = System.DateTime.Now.ToString(), UpdateTime = System.DateTime.Now.ToString(), Remark = "" }; } } else { testModel = new DStudent_Test { StudentCode = model.StudentCode, GradeCode = model.GradeCode, SchoolCode = model.SchoolCode, SchoolName = model.SchoolName, ClassCode = model.ClassCode, ClassName = model.ClassName, TestSetID = testSetID, StudentName = model.StudentName, StudentSex = model.StudentSex, TestTeacher = testTeacher, TestAddress = testAddress, BeginPraDate = testBeginDate, BeginWeek = testBeginWeek, BeginPraTime = testBeginTime, ApplyFor = "1", TestGroup = testGroup, TestGroupCode = groupCount == "" ? "" : (Convert.ToInt32(groupCount) + 1).ToString(), TestType = testType, CreateTime = System.DateTime.Now.ToString(), UpdateTime = System.DateTime.Now.ToString(), Remark = "" }; } } } catch (Exception ex) { if (flg) { errorcount++; } errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + ",添加失败;失败原因:" + ex.Message + "<br/>"; flg = false; } if (flg) { int result = 1; try { //导入信息返回的结果 result = dTestBll.AddDStudentTestAdmin(testModel, CookieHelper.GetCookie("NK")); if (result == 2) { if (flg) { errorcount++; } errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + "(数据库已经存在),添加失败" + "<br/>"; } else if (result <= 0) { if (flg) { errorcount++; } errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + "添加失败(原因:数据库可能存在)" + "<br/>"; } } catch (Exception ex) { errorcount++; errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + "添加失败;失败原因:" + ex.Message + "<br/>"; } } i++; } string importMsg = "共导入【" + sumcount + "】条记录<br/>" + "导入成功【" + (sumcount - errorcount) + "】条记录<br/>" + "导入失败【" + (errorcount) + "】条记录<br/>"; return(importMsg + "<br><div style='color:blue' id='errorMsg'>" + errorMsg + "</div>"); }
//添加学生测试 public ActionResult AddTestStudent(string studentCode, int testSetID, string studentSex, string testBeginDate, string testBeginWeek, string testBeginTime, string testAddress, string testGroup, string groupCount, string testTeacher, string testType, string testLimit) { try { DStudent_Infos model = dInfoBll.GetDStudentInfosModel(studentCode, CookieHelper.GetCookie("NK")); if (model.SchoolCode == "" || model == null || model.StudentCode == null) { return(Content(new JsonMessage { Success = false, Code = "0", Message = "库中不存在该学生,添加测试失败!" }.ToString())); } else if (model.StudentSex != studentSex) { return(Content(new JsonMessage { Success = false, Code = "0", Message = "学生性别和该条测试信息性别不相同,添加测试失败!" }.ToString())); } else { if (testLimit != "40") { //如果学生不符合测试限制,则无法测试 if (model.GradeCode != testLimit) { return(Content(new JsonMessage { Success = false, Code = "0", Message = "该学生不符合测试限制!" }.ToString())); } else { DStudent_Test testModel = new DStudent_Test { StudentCode = model.StudentCode, GradeCode = model.GradeCode, SchoolCode = model.SchoolCode, SchoolName = model.SchoolName, ClassCode = model.ClassCode, ClassName = model.ClassName, TestSetID = testSetID, StudentName = model.StudentName, StudentSex = model.StudentSex, TestTeacher = testTeacher, TestAddress = testAddress, BeginPraDate = testBeginDate, BeginWeek = testBeginWeek, BeginPraTime = testBeginTime, ApplyFor = "1", TestGroup = testGroup, TestGroupCode = groupCount == "" ? "" : (Convert.ToInt32(groupCount) + 1).ToString(), TestType = testType, CreateTime = System.DateTime.Now.ToString(), UpdateTime = System.DateTime.Now.ToString(), Remark = "" }; int n = dTestBll.AddDStudentTestAdmin(testModel, CookieHelper.GetCookie("NK")); if (n == 1) { return(Content(new JsonMessage { Success = true, Code = "1", Message = "添加成功!" }.ToString())); } else { return(Content(new JsonMessage { Success = true, Code = "0", Message = "该学生已经约考,不能重复添加!" }.ToString())); } } } else { DStudent_Test testModel = new DStudent_Test { StudentCode = model.StudentCode, GradeCode = model.GradeCode, SchoolCode = model.SchoolCode, SchoolName = model.SchoolName, ClassCode = model.ClassCode, ClassName = model.ClassName, TestSetID = testSetID, StudentName = model.StudentName, StudentSex = model.StudentSex, TestTeacher = testTeacher, TestAddress = testAddress, BeginPraDate = testBeginDate, BeginWeek = testBeginWeek, BeginPraTime = testBeginTime, ApplyFor = "1", TestGroup = testGroup, TestGroupCode = groupCount == "" ? "" : (Convert.ToInt32(groupCount) + 1).ToString(), TestType = testType, CreateTime = System.DateTime.Now.ToString(), UpdateTime = System.DateTime.Now.ToString(), Remark = "" }; int n = dTestBll.AddDStudentTestAdmin(testModel, CookieHelper.GetCookie("NK")); if (n == 1) { return(Content(new JsonMessage { Success = true, Code = "1", Message = "添加成功!" }.ToString())); } else { return(Content(new JsonMessage { Success = true, Code = "0", Message = "该学生已经约考,不能重复添加!" }.ToString())); } } } } catch (Exception ex) { Base_SysLogBll.Instance.WriteLog("", OperationType.Add, "-1", "异常错误:" + ex.Message); return(null); } }