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)));
}
}
/// <summary>
/// 单个插入，返回影响行数
/// </summary>
/// <param name="topicgroups"></param>
/// <returns></returns>
public static int Insert(Topicgroups model)
{
using (var db = Databases.Instance)
{
return(db.Execute(@"insert into `qp.topicgroup`(id,TopicName,CharactersSize,SetsettingId,OptionText,Stide,FromName,FromID) values(@id,@TopicName,@CharactersSize,@SetsettingId ,@OptionText,@Stide,@FromName,@FromID);", model));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="topicgroups"></param>
/// <returns></returns>
public static bool Update(Topicgroups model)
{
using (var db = Databases.Instance)
{
int updateSet = db.Execute(@"update `qp.topicgroup` set TopicName=@TopicName,CharactersSize=@CharactersSize,SetsettingId=@SetsettingId,OptionText=@OptionText,Stide=@Stide,FromName=@FromName,FromID=@FromID where id=@id", new { model });
if (updateSet > 0)
{
return(true);
}
return(false);
}
}
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)));
}
}
