public ActionResult UpdateNews(tbl_TuhuNews tn) { var userName = HttpContext.User.Identity.Name; int result = DALTuhuNews.UpdateTuhuNews(new SqlConnection(strConn), tn); if (result > 0) { try { var oprLog = new Tuhu.Provisioning.DataAccess.Entity.OprLog { ObjectID = tn.Id, ObjectType = "TuhuNews", Author = userName, Operation = "修改途虎新闻" }; new Tuhu.Provisioning.Business.OprLogManagement.OprLogManager().AddOprLog(oprLog); } catch (Exception) { } } return(Json(result)); }
public static object InsertTuhuNews(SqlConnection conn, tbl_TuhuNews tn) { string sql = @" INSERT INTO Activity..tbl_TuhuNews ( Title , NewsFrom , IssueTime , NewsType , Content, NewsGuid ) VALUES ( @N_Title , @N_From , @N_IssueTime , @N_Type , @N_Content, @N_Guid ); SELECT TOP 1 Id FROM Activity.[dbo].[tbl_TuhuNews] WITH(NOLOCK)ORDER BY Id DESC "; var sqlParams = new SqlParameter[] { new SqlParameter("@N_Title", tn.Title), new SqlParameter("@N_From", tn.NewsFrom), new SqlParameter("@N_IssueTime", tn.IssueTime), new SqlParameter("@N_Type", tn.NewsType), new SqlParameter("@N_Content", tn.Content), new SqlParameter("@N_Guid", tn.NewsGuid) }; return(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlParams)); }
public ActionResult Add(tbl_TuhuNews tn) { var userName = HttpContext.User.Identity.Name; string strGUID = System.Guid.NewGuid().ToString(); tn.NewsGuid = new Guid(strGUID); int result = (int)DALTuhuNews.InsertTuhuNews(new SqlConnection(strConn), tn); tbl_TuhuNews Tuhunews = DALTuhuNews.SelectNewsbyID(new SqlConnection(strConn)); if (result > 0) { var oprLog = new Tuhu.Provisioning.DataAccess.Entity.OprLog { ObjectID = result, ObjectType = "TuhuNews", Author = userName, Operation = "添加途虎新闻" }; new Tuhu.Provisioning.Business.OprLogManagement.OprLogManager().AddOprLog(oprLog); } return(Json(result)); }
public static int UpdateTuhuNews(SqlConnection conn, tbl_TuhuNews tn) { string sql = @"UPDATE Activity.[dbo].[tbl_TuhuNews] SET [Title] = @N_Title , [NewsFrom] = @N_From , [IssueTime] = @N_IssueTime , [NewsType] = @N_Type , [Content] = @N_Content WHERE [Id] = @N_Id; "; var sqlParams = new SqlParameter[] { new SqlParameter("@N_Title", tn.Title), new SqlParameter("@N_From", tn.NewsFrom), new SqlParameter("@N_IssueTime", tn.IssueTime), new SqlParameter("@N_Type", tn.NewsType), new SqlParameter("@N_Content", tn.Content), new SqlParameter("@N_Id", tn.Id) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParams)); }