/// <summary> /// 为场馆添加一个学生 /// </summary> /// <param name="student">学生信息</param> /// <returns></returns> public static bool Create(Sys.Models.Student student) { //todo 并发暂时不考虑 /* * 检查场馆code是否存在 * 检查学生信息是否存在 * 检查学生场馆绑定关系是否存在 * 插入绑定关系 * 插入学生信息和绑定关系 * */ try { bool isExistVenueCode = VenueService.IsExistVenueCode(student.VenueID.Value); if (!isExistVenueCode) { throw new Comm.YYException.YYException("场馆编码不存在"); } bool isExistStudent = IsExist(student); if (isExistStudent)//学生已经存在 { bool isExistStudentVenue = IsExistInVenue(student); if (isExistStudentVenue) { throw new Comm.YYException.YYException(student.FullName + "学生已经绑定"); } var student_info = FindStudentByUserName(student.UserName); var student_venue_result = Comm.Helper.DapperHelper.Instance.Insert(new Sys.Models.Student_Venue() { AddTime = DateTime.Now, StudentID = student_info.StudentID, VenueID = student.VenueID, }); return(student_venue_result > 0); } else//学生不存在 { return(ImportStudent(student)); } } catch (Comm.YYException.YYException) { throw; } catch (Exception ex) { logs.Error("学生添加失败", ex); return(false); } }
/// <summary> /// 为场馆添加一个 /// </summary> /// <param name="coach">教练信息</param> /// <returns></returns> public static bool Create(Sys.Models.Coach coach) { //todo 并发暂时不考虑 try { bool isExistVenueCode = VenueService.IsExistVenueCode(coach.VenueID.Value); if (!isExistVenueCode) { throw new Comm.YYException.YYException("场馆编码不存在"); } bool isExistCoach = IsExist(coach); if (!isExistCoach) { return(ImportCoach(coach)); } else { bool isExistStudentVenue = IsExistInVenue(coach); if (isExistStudentVenue) { throw new Comm.YYException.YYException(coach.FullName + "教练已经绑定"); } var coach_info = FindCoachByUserName(coach.UserName); var coach_venue_result = Comm.Helper.DapperHelper.Instance.Insert(new Sys.Models.Coach_Venue() { AddTime = DateTime.Now, CoachID = coach_info.CoachID, VenueID = coach.VenueID, }); return(coach_venue_result > 0); } } catch (Comm.YYException.YYException) { throw; } catch (Exception ex) { logs.Error("教练添加失败", ex); return(false); } }