/// <summary>
/// 更新
/// </summary>
/// <param name="constitutionresult"></param>
/// <returns>是否成功</returns>
public bool Update(ConstitutionResult constitutionresult)
{
StringBuilder sql = new StringBuilder("update ConstitutionResult set ");
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!constitutionresult.id.IsNullOrEmpty())
{
part2.Append("id = @id");
parm.Add("id", constitutionresult.id);
}
if (!constitutionresult.name.IsNullOrEmpty())
{
if (flag)
{
part1.Append("name = @name");
flag = false;
}
else
{
part1.Append(", name = @name");
}
parm.Add("name", constitutionresult.name);
}
if (!constitutionresult.content.IsNullOrEmpty())
{
if (flag)
{
part1.Append("content = @content");
flag = false;
}
else
{
part1.Append(", content = @content");
}
parm.Add("content", constitutionresult.content);
}
sql.Append(part1).Append(" where ").Append(part2);
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = conn.Execute(sql.ToString(), parm);
conn.Close();
return(r > 0);
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="constitutionresult"></param>
/// <returns>是否成功</returns>
public bool Insert(ConstitutionResult constitutionresult)
{
StringBuilder sql = new StringBuilder("insert into ConstitutionResult ");
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!constitutionresult.name.IsNullOrEmpty())
{
if (flag)
{
part1.Append("name");
part2.Append("@name");
flag = false;
}
else
{
part1.Append(",name");
part2.Append(",@name");
}
parm.Add("name", constitutionresult.name);
}
if (!constitutionresult.content.IsNullOrEmpty())
{
if (flag)
{
part1.Append("content");
part2.Append("@content");
flag = false;
}
else
{
part1.Append(",content");
part2.Append(",@content");
}
parm.Add("content", constitutionresult.content);
}
sql.Append("(").Append(part1).Append(") values(").Append(part2).Append(")");
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = conn.Execute(sql.ToString(), parm);
conn.Close();
return(r > 0);
}
}
/// <summary>
/// 简易版问题提交结果
/// </summary>
public ResultJsonModel <string> GetSubmitExpressQuestion(SubmitQusttionRequest request)
{
ResultJsonModel <string> result = new ResultJsonModel <string>();
var ArrayAnswer = request.Answer.Split(',');
var ListAnswer = ArrayAnswer.Distinct().ToList();
var questionnaire = CacheForModelQuestion.Instance.GetQuestionExpressList();
List <Questionnaire> List_Question = new List <Questionnaire>();
Dictionary <string, int> dic = new Dictionary <string, int>();
foreach (var item in ListAnswer)
{
if (!item.IsNullOrEmpty())
{
var model = questionnaire.Where(p => p.id.ToString() == item).FirstOrDefault();
if (model != null)
{
List_Question.Add(model);
var constitution = dic.Where(p => p.Key == model.Constitution).FirstOrDefault();
if (!dic.ContainsKey(model.Constitution))
{
dic.Add(model.Constitution, 1);
}
else
{
dic.Remove(model.Constitution);
dic.Add(model.Constitution, constitution.Value + 1);
}
}
}
}
var user = CacheForModelUser.Instance.GetUserInfo(request.UserId);
user.constitution = dic.OrderByDescending(p => p.Value).FirstOrDefault().Key;
DbOpertion.DBoperation.CustomerOper.Instance.Update(user);
CacheForModelUser.Instance.SetUserInfo(request.UserId);
ConstitutionResult constitutionResult = new ConstitutionResult();
constitutionResult.name = user.constitution;
constitutionResult = DbOpertion.DBoperation.ConstitutionResultOper.Instance.Select(constitutionResult).FirstOrDefault();
result.HttpCode = 200;
result.Message = user.constitution;
result.Model1 = constitutionResult.content;
return(result);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="constitutionresult"></param>
/// <param name="pageSize">页面大小</param>
/// <param name="pageNo">页面编号</param>
/// <returns>对象列表</returns>
public List <ConstitutionResult> SelectByPage(ConstitutionResult constitutionresult, int pageSize, int pageNo)
{
StringBuilder sql = new StringBuilder("Select Top ").Append(pageSize).Append(" ");
if (!constitutionresult.Field.IsNullOrEmpty())
{
sql.Append(constitutionresult.Field);
}
else
{
sql.Append("*");
}
sql.Append(" from ConstitutionResult ");
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
StringBuilder strBuliderPage = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!constitutionresult.id.IsNullOrEmpty())
{
if (flag)
{
part1.Append("id = @id");
flag = false;
}
else
{
part1.Append(" and id = @id");
}
parm.Add("id", constitutionresult.id);
}
if (!constitutionresult.name.IsNullOrEmpty())
{
if (flag)
{
part1.Append("name = @name");
flag = false;
}
else
{
part1.Append(" and name = @name");
}
parm.Add("name", constitutionresult.name);
}
if (!constitutionresult.content.IsNullOrEmpty())
{
if (flag)
{
part1.Append("content = @content");
flag = false;
}
else
{
part1.Append(" and content = @content");
}
parm.Add("content", constitutionresult.content);
}
if (!flag)
{
strBuliderPage.Append(" and");
}
strBuliderPage.Append(" id not in (").Append("Select Top ").Append(pageSize * (pageNo - 1)).Append(" id from ConstitutionResult ");
if (!constitutionresult.GroupBy.IsNullOrEmpty())
{
strBuliderPage.Append(" Group By ").Append(constitutionresult.GroupBy).Append(" ");
flag = false;
}
if (!constitutionresult.OrderBy.IsNullOrEmpty())
{
strBuliderPage.Append(" Order By ").Append(constitutionresult.OrderBy).Append(" ");
flag = false;
}
strBuliderPage.Append(" )");
if (!flag)
{
sql.Append(" where ");
}
sql.Append(part1).Append(strBuliderPage).Append(part1);
if (!constitutionresult.GroupBy.IsNullOrEmpty())
{
part2.Append(" Group By ").Append(constitutionresult.GroupBy).Append(" ");
}
if (!constitutionresult.OrderBy.IsNullOrEmpty())
{
part2.Append(" Order By ").Append(constitutionresult.OrderBy).Append(" ");
}
sql.Append(part2);
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = (List <ConstitutionResult>)conn.Query <ConstitutionResult>(sql.ToString(), parm);
conn.Close();
if (r == null)
{
r = new List <ConstitutionResult>();
}
return(r);
}
}
