public int DeleteNewsTab(int Newsid)
{
string sql = "delete NewsTab where Newsid=@Newsid ";
int result = DBHelpe.ExecuteSql(sql, new SqlParameter("Newsid", Newsid));
return(result);
}
public int UpdateNewsTabaudit(int newsid)
{
string sql = "Update NewsTab set Audit=5 where Newsid=@Newsid ";//ɾ³ýÓà ¸Ä±äÉóºË״̬
SqlParameter[] ps = new SqlParameter[] {
new SqlParameter("@Newsid", newsid)
};
int result = DBHelpe.ExecuteSql(sql, ps);
return(result);
}
public int UpdateNewsTabUrl(string url, int newsid)
{
string sql = "Update NewsTab set urlhtml=@urlhtml where Newsid=@Newsid ";
SqlParameter[] ps = new SqlParameter[] {
new SqlParameter("@urlhtml", url)
, new SqlParameter("@Newsid", newsid)
};
int result = DBHelpe.ExecuteSql(sql, ps);
return(result);
}
public int UpdateNewsTab(Tz888.Model.NewsTab newstab, int newsid)
{
string sql = "Update NewsTab set NTitle=@ntitle ,TypeID=@typeid,recommendID=@recommendID,urlhtml=@urlhtml where Newsid=@Newsid ";
SqlParameter[] ps = new SqlParameter[] {
new SqlParameter("@ntitle", newstab.NTitle)
, new SqlParameter("@typeid", newstab.TypeID)
, new SqlParameter("@recommendID", newstab.RecommendID)
, new SqlParameter("@urlhtml", newstab.Urlhtml)
, new SqlParameter("@Newsid", newsid)
};
int result = DBHelpe.ExecuteSql(sql, ps);
return(result);
}
public int UpdateNewsViewTab(Tz888.Model.NewsViewTab newsviewtab, int newsid)
{
string sql = "Update NewsViewTab set Title=@title ,Keywords=@keywords,Description=@descript,NewView=@newview,form=@form,Author=@author,Zhaiyao=@zhaiyao where Newsid=@Newsid ";
SqlParameter[] ps = new SqlParameter[] {
new SqlParameter("@title", newsviewtab.Title)
, new SqlParameter("@keywords", newsviewtab.Keywords)
, new SqlParameter("@descript", newsviewtab.Description)
, new SqlParameter("@newview", newsviewtab.NewView)
, new SqlParameter("@form", newsviewtab.Formid)
, new SqlParameter("@author", newsviewtab.Author)
, new SqlParameter("@zhaiyao", newsviewtab.Zhaiyao)
, new SqlParameter("@Newsid", newsid)
};
int result = DBHelpe.ExecuteSql(sql, ps);
return(result);
}
