/// <summary> /// 获取题目 /// </summary> /// <returns></returns> public LoanSubject GetChoiceSubject(int?SubjectID) { string sqlSubject = string.Empty; LoanSubject subjectModel = null; if (SubjectID == null) { sqlSubject = $"select top 1 * from LoanSubject order by Sort"; subjectModel = DbHelper.QuerySingle <LoanSubject>(sqlSubject); } else { sqlSubject = $"select * from LoanSubject where SubjectID ={SubjectID}"; subjectModel = DbHelper.QuerySingle <LoanSubject>(sqlSubject); } string sqlAnswer = $"select * from LoanAnswer where SubjectID={subjectModel.SubjectID}"; List <LoanAnswer> answerList = DbHelper.Query <LoanAnswer>(sqlAnswer); subjectModel.LoanAnswerList.AddRange(answerList); string sqlNextSubject = $"select top 1 SubjectID from LoanSubject where Sort > (select Sort from LoanSubject where SubjectID={subjectModel.SubjectID}) order by Sort"; int NextSubjectID = DbHelper.QuerySingle <int>(sqlNextSubject); subjectModel.NextSubjectID = NextSubjectID; string sqlSubjectCount = "select count(*) from LoanSubject"; int SubjectCount = DbHelper.QuerySingle <int>(sqlSubjectCount); subjectModel.SubjectCount = SubjectCount; return(subjectModel); }
public ActionResult Calculator(int?id) { LoanSubject subject = _loanSubjectService.GetChoiceSubject(id); if (Session["relations"] == null) { Session["relations"] = new List <SubjectAnswerRelation>(); } return(View(subject)); }
public JsonResult <LoanSubject> GetChoiceSubject(int?SubjectID = null) { LoanSubject loanSubject = _loanSubjectService.GetChoiceSubject(SubjectID); return(new JsonResult <LoanSubject> { status = true, Message = "获取成功", Data = loanSubject }); }
/// <summary> /// 获取题目详情 /// </summary> /// <param name="SubjectID"></param> /// <returns></returns> public LoanSubject GetSubjectDetail(int SubjectID) { string sqlSubject = $"select * from LoanSubject where SubjectID ={SubjectID}"; LoanSubject subjectModel = DbHelper.QuerySingle <LoanSubject>(sqlSubject); string sqlAnswer = $"select * from LoanAnswer where SubjectID={SubjectID}"; List <LoanAnswer> answerList = DbHelper.Query <LoanAnswer>(sqlAnswer); subjectModel.LoanAnswerList.AddRange(answerList); return(subjectModel); }
/// <summary> /// 更新题目 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateSubject(LoanSubject model) { if (BatchDelete(model.SubjectID.ToString()) && AddSubject(model)) { return(true); } else { return(false); } }
public void AddRelation(LoanSubject subject) { SubjectAnswerRelation relation = new SubjectAnswerRelation(); relation.SubjectID = subject.SubjectID; relation.AnswerID = int.Parse(Request["optionRadio"]); List <SubjectAnswerRelation> relations = (List <SubjectAnswerRelation>)Session["relations"]; SubjectAnswerRelation rl = relations.FirstOrDefault(m => m.SubjectID == subject.SubjectID); if (rl == null) { relations.Add(relation); } Session["relations"] = relations; }
/// <summary> /// 添加题目 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddSubject(LoanSubject model) { string sqlstr = $"insert into LoanSubject(Subject,Sort) values('{model.Subject}',{model.Sort})"; int result = DbHelper.ExecuteSqlCommandScalar(sqlstr, new SqlParameter[] { }); int result1 = 0; if (result > 0) { string sql = string.Empty; foreach (var item in model.LoanAnswerList) { sql += $"insert into LoanAnswer(Answer,LoanAmount,SubjectID) values('{item.Answer}',{item.LoanAmount},{result});"; } result1 = DbHelper.ExecuteSqlCommand(sql, null); return(result1 > 0); } return(false); }
/// <summary> /// 提交编辑题目 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult EditSubject(SubjectViewModel model) { if (!ModelState.IsValid) { return(View("~/Views/Loan/LoanSetting/EditSubject.cshtml")); } LoanSubject loanSubject = new LoanSubject(); loanSubject.SubjectID = model.SubjectID; loanSubject.Subject = model.Subject; loanSubject.Sort = model.Sort; if (model.Answer != null && model.Answer.Count() > 0) { for (int i = 0; i < model.Answer.Count(); i++) { if (model.Answer[i] != "" && model.LoanAmount[i] != 0) { loanSubject.LoanAnswerList.Add(new LoanAnswer { Answer = model.Answer[i], LoanAmount = model.LoanAmount[i] }); } } } if (_loanSubjectService.UpdateSubject(loanSubject) == true) { TempData["Message"] = "保存成功"; return(RedirectToAction("GetSubjectList")); } else { TempData["Message"] = "保存失败"; return(RedirectToAction("GetSubjectList")); } }
public ActionResult Calculator(LoanSubject subject) { AddRelation(subject); //计算身价 string answerIDStr = string.Empty; foreach (var item in Relations) { answerIDStr += item.AnswerID + ","; } answerIDStr = answerIDStr.Trim(new char[] { ',' }); //身价计算 bool flag = _loanSubjectService.ValueCalculation(CommonHelper.CurrentUser.MemberID, answerIDStr); if (flag) { //清空保存的答题 Session["relations"] = null; return(Redirect("/LoanCalculator/CalculatorResult")); } return(Redirect("/LoanCalculator/Calculator/" + subject.SubjectID)); }
public ActionResult CalculatorNext(LoanSubject subject) { AddRelation(subject); return(Redirect("/LoanCalculator/Calculator/" + subject.NextSubjectID)); }
public ActionResult EditSubject(int SubjectID) { LoanSubject subjectModel = _loanSubjectService.GetSubjectDetail(SubjectID); return(View("~/Views/Loan/LoanSetting/EditSubject.cshtml", subjectModel)); }