/// <summary>
/// 单个插入，返回影响行数
/// </summary>
/// <param name="topicgroups"></param>
/// <returns></returns>
public static int Insert(Formsettings model)
{
using (var db = Databases.Instance)
{
return(db.Execute(@"insert into `qp.formsettings`(FormID,FormNote,FormTitle,FormCopyright,FormCreateDate,FormStatus,FormCreater) values(@FormID,@FormNote,@FormTitle,@FormCopyright,@FormCreateDate,@FormStatus,@FormCreater);", model));
}
}
public IActionResult AddSurvey(string title, string brief, string copy)
{
try
{
// 表单ID
string formId = Guid.NewGuid().ToString();
Formsettings InsertModel = new Formsettings()
{
FormID = formId,
FormNote = brief,
FormTitle = title,
FormCopyright = copy,
FormCreateDate = DateTime.Parse(DateTime.Now.ToShortDateString()),
FormStatus = 1,
FormCreater = Seesion.UserName
};
//给全局的表单ID赋值
var InsertState = HelpFormsettings.Insert(InsertModel);
Seesion.FromIds = formId;
if (InsertState > 0)
{
return(Json(ResultMsg.FormatResult(200, Seesion.FromIds, Seesion.UserName)));
}
return(Json(ResultMsg.FormatResult(0, "数据添加失败", "失败")));
}
catch (Exception el)
{
return(Json(ResultMsg.FormatResult(el)));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="topicgroups"></param>
/// <returns></returns>
public static bool Update(Formsettings model)
{
using (var db = Databases.Instance)
{
int updateSet = db.Execute(@"update `qp.formsettings` set Answer=@Answer,FromID=@FromID where FormID=@FormID", new { model });
if (updateSet > 0)
{
return(true);
}
return(false);
}
}
