public static int addSignupUserItem(ref SignupUserItem item) { item.Name = item.Name.Replace(" ", "").Trim(); item.CardID = item.CardID.Replace(" ", "").Trim(); item.Mobile = item.Mobile.Replace(" ", "").Trim(); if (item.Name.Length == 0 || item.CardID.Length == 0 || item.Mobile.Length == 0) { throw new Exception("请填写您的姓名、身份证号码和手机号码!"); } else if (item.CardID.Length > 0 && !Regex.Match(item.CardID, @"^\d{17}(\d|X)$", RegexOptions.IgnoreCase).Success) { throw new Exception("身份证号码格式不正确,请检查是否有误!"); } else if (item.Mobile.Length > 0 && !Regex.Match(item.Mobile, @"^\d{11}$").Success) { throw new Exception("手机号码格式不正确,请检查是否有误!"); } List <AnswerItem> answers = item.Answers; List <QuestionItem> ques; DbSelect.getQuestionList(out ques, null); if (!ques.TrueForAll((QuestionItem q) => answers.Exists((AnswerItem ans) => ans.Question.ID == q.ID))) { throw new Exception("请确认是否已回答所有问题!"); } List <SignupUserItem> list; Dictionary <String, String[]> conditions = new Dictionary <String, String[]>(); conditions.Add("Name", new String[] { new Operator(OperatorTypeEnum.Equal), item.Name }); conditions.Add("CardID", new String[] { new Operator(OperatorTypeEnum.Equal), item.CardID }); conditions.Add("Mobile", new String[] { new Operator(OperatorTypeEnum.Equal), item.Mobile }); int ret = DbSelect.getSignupList(out list, conditions); if (ret != OK) { return(FAILED); } if (list.Count == 0) // 无匹配用户 { throw new Exception("考生信息不符,无法查询!"); } else { item = list[0]; item.Answers = answers; if (list[0].SignupSequence.Length != 0) // 已签到 { return(CANCELLED); } } return(DbEdit.updateSignupUserItem(ref item)); }
public static int deleteAllSignupUserItems() { return(DbEdit.deleteAllSignupUserItems()); }
public static int recoverAllSignupUserItems() { return(DbEdit.recoverAllSignupUserItems()); }
public static int deleteSignupUserItem(int ID) { return(DbEdit.deleteSignupUserItem(ID)); }
public static int recoverSignupUserItem(int ID) { return(DbEdit.recoverSignupUserItem(ID)); }