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));
}
