/// <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));
}
