public IActionResult ContentPage(string Stides, string interest, string TopicName, string CharactersSize, string OptionSet) { //return Json(new { string1= Stides, string2= interest, string3= TopicName, string4= CharactersSize, string5= OptionSet, string6= Isempty }); try { //name关键字生成规则【题号+选项ID+10-99随机数】 string fromName = Stides + interest + Seesion.sj.Next(10, 100).ToString(); CharactersSize = CharactersSize == null ? "0" : CharactersSize; Stides = Stides == null ? "0" : Stides; Topicgroups InsertModel = new Topicgroups() { id = Guid.NewGuid().ToString(), TopicName = TopicName, CharactersSize = CharactersSize, SetsettingId = interest, OptionText = OptionSet, Stide = int.Parse(Stides), FromName = fromName, // Isnull = Isempty == null ? "空" : Isempty, FromID = Seesion.FromIds }; int request = HelpTopicgroup.Insert(InsertModel); if (request > 0) { return(Json(data: ResultMsg.FormatResult())); } return(Json(data: ResultMsg.FormatResult(0, "插入数据库失败", "错误"))); } catch (Exception ex) { return(Json(data: ResultMsg.FormatResult(ex))); } }
public IActionResult Edit() { try { var topicID = Request.Form["id"]; var stIdes = Request.Form["Stide"]; var stsettingId = Request.Form["SetsettingId"]; var topicName = Request.Form["TopicName"]; var charactersSize = Request.Form["CharactersSize"]; var optionText = Request.Form["OptionText"]; ///题号修改规则 /// 先判断该题号是否修改,如果没有动直接修改全部 /// 如果题号不一致 , 去查询是否存在改动题号, 题号存在,内容和题号全部替换 不存在直接修改题号 if (stIdes == Seesion._stide) { string fromName = Seesion._stide + stsettingId + Seesion.sj.Next(10, 100).ToString(); Topicgroups updateModel = new Topicgroups() { TopicName = topicName, CharactersSize = charactersSize, SetsettingId = stsettingId, OptionText = optionText, Stide = int.Parse(Seesion._stide), id = topicID, FromName = fromName, FromID = Seesion.FromIds }; if (HelpTopicgroup.Update(updateModel)) { return(RedirectToAction("Index")); } return(Json(ResultMsg.FormatResult(0, "修改失败", "修改失败"))); } else { //把用户修改的题号 拿去数据库中对比,如果存在就两两相互替换,不修改其他内容,不存在就直接修改,并且修改所用 var existStide = Databases.Instance.Query <Topicgroups>("select id,TopicName,CharactersSize,SetsettingId ,OptionText ,Stide from `qp.topicgroup` where Stide =@Stide", new { Stide = stIdes }); if (existStide.Count() > 0) { try { Topicgroups updateModel; foreach (var item in existStide) { string fromNamed = Seesion._stide + item.SetsettingId + Seesion.sj.Next(10, 100).ToString(); // 更改成被修改的题号,同时内容也全部替换 updateModel = new Topicgroups() { id = Guid.NewGuid().ToString(), TopicName = item.TopicName, CharactersSize = item.CharactersSize, SetsettingId = item.SetsettingId, OptionText = item.OptionText, Stide = int.Parse(Seesion._stide), FromName = fromNamed, FromID = Seesion.FromIds }; HelpTopicgroup.Insert(updateModel); HelpTopicgroup.Delete(item.id); } HelpTopicgroup.Delete(topicID); //就相当于新增加一组数据,把新的题号带上 !!!! string fromName = stIdes + stsettingId + Seesion.sj.Next(10, 100).ToString(); updateModel = new Topicgroups() { TopicName = topicName, CharactersSize = charactersSize, SetsettingId = stsettingId, OptionText = optionText, id = topicID, Stide = int.Parse(stIdes), FromName = fromName, FromID = Seesion.FromIds }; HelpTopicgroup.Insert(updateModel); return(View("Index")); } catch (Exception el) { return(Json(ResultMsg.FormatResult(el))); } } else { //不存在这个题号的时候直接修改题号不需要搭理内容 try { Databases.Instance.Execute("update `qp.topicgroup` set Stide =@Stide where id=@id", new { id = topicID, Stide = stIdes }); return(RedirectToAction("Index")); } catch (Exception el) { return(Json(ResultMsg.FormatResult(el))); } } } } catch (Exception el) { return(Json(ResultMsg.FormatResult(el))); } }