/// <summary> /// thêm dữ liệu vào bảng examhallstudent : /// </summary> /// <param name="listStudentCode"></param> /// <param name="examTimeCode"></param> /// <param name="courseCode"></param> /// <param name="parentCode"></param> /// <returns></returns> public JsonResult Insert(List<string> listStudentCode, string examTimeCode, string courseCode) { int ret = 0; if (listStudentCode != null) { EXAMHALLSTUDENT_BUS bus = new EXAMHALLSTUDENT_BUS(); foreach (var studentCode in listStudentCode) { MARK_BUS markBus = new MARK_BUS(); MARK_OBJ markObj = markBus.GetByKey( new fieldpara("STUDENTCODE", studentCode, 0), new fieldpara("COURSECODE", courseCode, 0), new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0) ); if (markObj == null) ret = -1; else { // kiểm tra đã tồn tại bản ghi có markcode và coursecode truyền vào chưa EXAMHALLSTUDENT_OBJ obj = bus.GetByKey( new fieldpara("MARKCODE", markObj.CODE, 0), new fieldpara("COURSECODE", courseCode, 0), new fieldpara("EXAMTIMECODE", examTimeCode, 0), new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0) ); if (obj != null) { ret = -2; return Json(new { ret }, JsonRequestBehavior.AllowGet); } EXAMHALLSTUDENT_OBJ objTemp = new EXAMHALLSTUDENT_OBJ(); objTemp.CODE = bus.genNextCode(objTemp); objTemp.MARKCODE = markObj.CODE; objTemp.COURSECODE = courseCode; objTemp.EXAMTIMECODE = examTimeCode; objTemp.LOCK = 0; objTemp.EDITTIME = DateTime.Now; objTemp.EDITUSER = _ses.loginCode; objTemp.UNIVERSITYCODE = _ses.gUNIVERSITYCODE; ret = bus.insert(objTemp); } markBus.CloseConnection(); } bus.CloseConnection(); } return Json(new { ret }, JsonRequestBehavior.AllowGet); }