public bool UpdateNoticeInfo(Noticeinfo noticeinfo)
{
DbParameter[] parms = {
DbHelper.MakeInParam("@nid", DbType.Int32, 4, noticeinfo.Nid),
DbHelper.MakeInParam("@uid", DbType.Int32, 4, noticeinfo.Uid),
DbHelper.MakeInParam("@type", DbType.Int32, 4, noticeinfo.Type),
DbHelper.MakeInParam("@new", DbType.Int32, 4, noticeinfo.New),
DbHelper.MakeInParam("@posterid", DbType.Int32, 4, noticeinfo.Posterid),
DbHelper.MakeInParam("@poster", DbType.AnsiString, 20, noticeinfo.Poster),
DbHelper.MakeInParam("@note", DbType.String, 0, noticeinfo.Note),
DbHelper.MakeInParam("@postdatetime", DbType.DateTime, 8, noticeinfo.Postdatetime)
};
return DbHelper.ExecuteNonQuery(CommandType.Text, "UPDATE [" + BaseConfigs.GetTablePrefix + "notices] SET [uid] = @uid, [type] = @type, [new] = @new, [posterid] = @posterid, [poster] = @poster, [note] = @note, [postdatetime] = @postdatetime WHERE [nid] = @nid", parms) > 0;
}
public IActionResult Form(Noticeinfo noticeinfo)
{
return(Json(_noticeinfoService.Save(noticeinfo)));
}
public int CreateNoticeInfo(Noticeinfo noticeinfo)
{
DbParameter[] parms = {
DbHelper.MakeInParam("@uid", DbType.Int32, 4, noticeinfo.Uid),
DbHelper.MakeInParam("@type", DbType.Int32, 4, noticeinfo.Type),
DbHelper.MakeInParam("@new", DbType.Int32, 4, noticeinfo.New),
DbHelper.MakeInParam("@posterid", DbType.Int32, 4, noticeinfo.Posterid),
DbHelper.MakeInParam("@poster", DbType.AnsiString, 20, noticeinfo.Poster),
DbHelper.MakeInParam("@note", DbType.String, 0, noticeinfo.Note),
DbHelper.MakeInParam("@postdatetime", DbType.DateTime, 8, noticeinfo.Postdatetime)
};
return Utils.StrToInt(DbHelper.ExecuteScalar(CommandType.Text, "INSERT INTO [" + BaseConfigs.GetTablePrefix + "notices] ([uid], [type], [new], [posterid], [poster], [note], [postdatetime]) VALUES (@uid, @type, @new, @posterid, @poster, @note, @postdatetime);SELECT SCOPE_IDENTITY() AS 'nid'", parms), -1);
}
