/// <summary> /// 通过姓名获取教师的详细信息 /// </summary> /// <param name="name"></param> /// <returns></returns> public personalinformation GetTeacherByName(string name) { Model.personalinformation teacherInfo = new personalinformation(); try { var teacherlist = PersonalinformationService.LoadEntities(u => u.vcName == name).ToList(); if (teacherlist != null) { List <int?> teacherList = new List <int?>(); foreach (var item in teacherlist) { teacherList.Add(item.iUserID); } var teacherLogin = RegisterloginService.LoadEntities(u => teacherList.Contains(u.iUserID) && u.iIdentity == 8).FirstOrDefault(); if (teacherLogin != null) { teacherInfo = PersonalinformationService.LoadEntities(u => u.iUserID == teacherLogin.iUserID).FirstOrDefault(); } } } catch (Exception) { teacherInfo = null; } return(teacherInfo); }
/// <summary> /// 获取团队指导老师的信息 /// </summary> /// <param name="id">团队ID</param> /// <returns></returns> public personalinformation GetTeamTeacher(int id) { personalinformation person = new personalinformation(); var teamAppliCantInfo = TeamAppliCantService.LoadEntities(u => u.iTeamID == id).FirstOrDefault(); if (teamAppliCantInfo != null) { person = PersonalinformationService.LoadEntities(u => u.iUserID == teamAppliCantInfo.iUserID).FirstOrDefault(); } return(person); }
/// <summary> /// 获取团队当前队长信息 /// </summary> /// <param name="id">团队ID</param> /// <returns></returns> public personalinformation GetTeamCaptain(int id) { personalinformation person = new personalinformation(); //通过团队ID找到TeamApplicantID的记录 var teamAppliCantInfo = TeamAppliCantService.LoadEntities(u => u.iTeamID == id).FirstOrDefault(); if (teamAppliCantInfo != null) { //通过队员表找到队员表中的队长记录 var playerInfo = PlayersService.LoadEntities(u => u.iTeamApplicantID == teamAppliCantInfo.ID && u.bPlayerType == true).FirstOrDefault(); if (playerInfo != null) { //根据队长记录中的ID找到队长个人信息 var PersonInfo = PersonalinformationService.LoadEntities(u => u.iUserID == playerInfo.iUserID).FirstOrDefault(); person = PersonInfo; } } return(person); }
public ActionResult RegisterPage() { if (Request.HttpMethod.ToUpper() == "POST") { string userAccount = Request["account"]; //学号注册 string userPwd = Request["password"]; //密码 string reUserPwd = Request["rePassword"]; char[] userAccounts = userAccount.ToCharArray(); string userPhone = Request["phone"]; //string userAccount = "185800000"; //string userPwd = "0123456789"; //string reUserPwd = "0123456789"; //string userPhone = "18337281814"; ////string userPhone = "010-88888888";//固定电话 //char[] userAccounts = userAccount.ToCharArray(); //int userWeChatId = Convert.ToInt32(Request["weChatId"]);//微信ID账号,目前不做 try { var uAccount = userService.CheckAccount(userAccount).FirstOrDefault(); if (uAccount == null)//账号未注册 { if (userAccounts[1] == '6' || userAccounts[1] == '7' || userAccounts[1] == '8' || userAccounts[1] == '9') { if (userAccounts[0] == '1' && userAccounts.Length == 9 && CheckValidateCharacter(userAccount)) { if (userPwd == reUserPwd) { char[] userPwds = userPwd.ToCharArray(); if (userPwds.Length >= 10 && userPwds.Length <= 16 && CheckValidateCharacter(userPwd)) { if (CheckValidatePhone(userPhone)) { if (userAccount != null && userPwd != null && userPhone != null) { user userRegister = new user(); //用户注册和登陆表,存储用户注册时的基本信息 registerlogin registerAndLogin = new registerlogin(); //注册登录表,在后台自动填写用的其他信息 personalinformation perlinformation = new personalinformation(); //个人信息表,用户填充IUSERID userRegister.vcUserAccount = userAccount; userPwd = MD5Secret.GetMD5Str(userPwd); //给密码加密 userRegister.vcPassWord = userPwd; //userRegister.iWeChatID= userWeChatId;暂时不用 userRegister.IsDel = false;//数据库如果没有写false,添加 try { userService.AddEntity(userRegister);//将用户注册的基本信息添加到user表里 try { var userStatus = userService.CheckUserRegisterStatus(userAccount, userPwd); foreach (var status in userStatus) { userInfoStatus = status.vcUserAccount; } //用户基本信息完毕 //用户注册时后台自动填充用户的其他信息的表 registerAndLogin.GUID = Guid.NewGuid(); registerAndLogin.iUserID = userRegister.ID; registerAndLogin.dApplyTime = DateTime.Now.ToLocalTime(); registerAndLogin.vcApplyLocation = "text"; //申请地点 registerAndLogin.iIdentity = 0; //身份标识 registerAndLogin.IsDel = false; //填充注册登录表完毕 //填充个人信息表 perlinformation.iUserID = userRegister.ID; try { personalinformationService.AddEntity(perlinformation); } catch (Exception) { status = "fail"; result = "网络异常,注册失败"; } //个人信息表完毕 //后台自动填充用户其他的信息完毕 try { if (userInfoStatus == userAccount && registerloginService.AddEntity(registerAndLogin) != null) { status = "ok"; result = "注册成功"; } else { status = "fail"; result = "注册失败"; } } catch (Exception) { status = "fail"; result = "网络异常,注册失败"; } } catch (Exception) { status = "fail"; result = "网络异常,注册失败"; } } catch (Exception) { status = "fail"; result = "网络异常,注册失败";; } } else { status = "fail"; result = "注册失败"; } } else { status = "fail"; result = "请输入正确的电话号码"; } } else { status = "fail"; result = "密码格式不正确,请检查密码长度和密码格式是否符合规范"; } } else { status = "fail"; result = "两次输入的密码不一致"; } } else { status = "fail"; result = "账号格式输入不正确,请以学号注册"; } } else { status = "fail"; result = "账号格式输入不正确,请以学号注册(暂时支持16、17、18、19级学生)"; } } else { status = "fail"; result = "您的账号已注册,无法重复注册"; } } catch (Exception) { status = "fail"; result = "网络连接不稳定"; } } string jsonData = "{" + "\"" + "status" + "\"" + ":" + "\"" + status + "\"" + "," + "\"" + "msg" + "\"" + ":" + "\"" + result + "\"" + "}"; return(Content(jsonData)); }