public int update(Model.News mn)
{
StringBuilder sql = new StringBuilder();
sql.Append(" update news set ");
sql.Append(" _title=@name, _from=@source, _author=@author,_top=@hot,_click=@count,_content=@info,_cateid=@nid,_ispic=@pic ");
sql.Append(" where _id=@id ");
SqlParameter [] par =
{
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@source", SqlDbType.VarChar, 50),
new SqlParameter("@author", SqlDbType.VarChar, 50),
new SqlParameter("@hot", SqlDbType.Int, 4),
new SqlParameter("@count", SqlDbType.Int, 4),
new SqlParameter("@info", SqlDbType.VarChar, 0),
new SqlParameter("@nid", SqlDbType.Int, 4),
new SqlParameter("@pic", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
par[0].Value = mn.Title;
par[1].Value = mn.From;
par[2].Value = mn.Author;
par[3].Value = mn.Top;
par[4].Value = mn.Click;
par[5].Value = mn.Content;
par[6].Value = mn.Cateid;
par[7].Value = mn.Ispic;
par[8].Value = mn.ID;
int result = DbHelperSQL.ExecuteSql(sql.ToString(), par);
return(result);
}
public int add(Model.News mn)
{
StringBuilder sql = new StringBuilder();
sql.Append(" insert into news ");
sql.Append(" (_title,_from,_author,_top,_click,_content,_cateid,_ispic) ");
sql.Append(" values( @title,@from,@author,@top,@click,@content,@cateid,@ispic ) ");
SqlParameter[] par = { new SqlParameter("@title", SqlDbType.VarChar, 50),
new SqlParameter("@from", SqlDbType.VarChar, 50),
new SqlParameter("@author", SqlDbType.VarChar, 50),
new SqlParameter("@top", SqlDbType.VarChar, 50),
new SqlParameter("@click", SqlDbType.VarChar, 50),
new SqlParameter("@content", SqlDbType.VarChar, 0),
new SqlParameter("@cateid", SqlDbType.VarChar, 50),
new SqlParameter("@ispic", SqlDbType.VarChar, 50) };
par[0].Value = mn.Title;
par[1].Value = mn.From;
par[2].Value = mn.Author;
par[3].Value = mn.Top;
par[4].Value = mn.Click;
par[5].Value = mn.Content;
par[6].Value = mn.Cateid;
par[7].Value = mn.Ispic;
int result = DbHelperSQL.ExecuteSql(sql.ToString(), par);
return(result);
}
public SqlDataReader datareader(Model.News mn)
{
string str = " select * from news where _id=" + mn.ID + " ";
SqlDataReader dr = DbHelperSQL.ExecuteReader(str);
return(dr);
}
//更新新闻点击率
public void UpdateNewsHit(Model.News news)
{
IDataParameter[] parameter =
{
new SqlParameter("@ID", SqlDbType.Int, 32)
};
parameter[0].Value = news.ID;
pr.ExcutePro("UpdateNewsHit", parameter);
//string SQL = "update news set newshit=newshit+1 where id='"+news.ID+"'";
//db.SQLExecute(SQL);
}
public int _delete(Model.News mn)
{
StringBuilder sql = new StringBuilder();
sql.Append(" delete from news where _id=@nid ");
SqlParameter[] par = { new SqlParameter("@nid", SqlDbType.Int, 4) };
par[0].Value = mn.ID;
int result = DbHelperSQL.ExecuteSql(sql.ToString(), par);
return(result);
}
//更新点击
public bool UpdateClick(Model.News news)
{
string SQL = "update news set click=click+1 where id ='" + news.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
return(true);
}
else
{
return(false);
}
}
//添加新闻
public bool AddNews(Model.News news)
{
string SQL = "insert into news values('" + news.category + "','" + news.title + "','" + news.author + "','" + news.contents + "','" + news.createTime + "','" + news.click + "')";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('添加成功');location.href='choose.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('添加失败,请重试');</script>");
return(false);
}
}
//删除新闻
public bool DelNews(Model.News news)
{
string SQL = "DELETE from news where id='" + news.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
// HttpContext.Current.Response.Write("<script>alert('删除成功');location.href='choose.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('删除失败,请重试');</script>");
return(false);
}
}
//更新新闻
public bool UpdateNews(Model.News news)
{
string SQL = "update news set category='" + news.category + "',title='" + news.title + "',author='" + news.author + "',contents='" + news.contents + "',createTime='" + news.createTime + "' where id='" + news.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('更新成功');location.href='choose.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('更新失败,请重试');</script>");
return(false);
}
}
//搜索新闻---按category
public bool SearchCategory(Model.News news)
{
string SQL;
SQL = "select * from news where category like '%" + news.category + "%'";
news.sql = SQL;
DataSet ds = DBHelper.GetDataSet(SQL);
if (ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
//发布新闻
public bool InsertNews(Model.News news)
{
bool flag = false;
IDataParameter[] parameter =
{
new SqlParameter("@newstitle", SqlDbType.VarChar, 50),
new SqlParameter("@newscontent", SqlDbType.VarChar, 50),
new SqlParameter("@newsauthor", SqlDbType.VarChar, 50),
new SqlParameter("@newshit", SqlDbType.Int, 32)
};
parameter[0].Value = news.Title;
parameter[1].Value = news.Content;
parameter[2].Value = news.Author;
parameter[3].Value = news.Hit;
flag = pr.ExecuteProcedure("InsertNews", parameter);
return(flag);
}
//查询新闻
public bool QueryNews(Model.News news)
{
string SQL = "select * from news where id='" + news.id + "'";
DataSet ds = DBHelper.GetDataSet(SQL);
if (ds.Tables[0].Rows.Count > 0)
{
news.category = ds.Tables[0].Rows[0][1].ToString();
news.title = ds.Tables[0].Rows[0][2].ToString();
news.author = ds.Tables[0].Rows[0][3].ToString();
news.contents = ds.Tables[0].Rows[0][4].ToString();
news.createTime = ds.Tables[0].Rows[0][5].ToString();
news.click = ds.Tables[0].Rows[0][6].ToString();
return(true);
}
else
{
return(false);
}
}
//新闻数据的更新
public bool UpdateNews(Model.News news)
{
bool flag = false;
IDataParameter[] parameter =
{
new SqlParameter("@newstitle", SqlDbType.VarChar, 50),
new SqlParameter("@newscontent", SqlDbType.VarChar, 50),
new SqlParameter("@newsauthor", SqlDbType.VarChar, 50)
};
parameter[0].Value = news.Title;
parameter[1].Value = news.Content;
parameter[2].Value = news.Author;
flag = pr.ExecuteProcedure("UpdateNews", parameter);
//string SQL = "";
//SQL = "update news set newscontent='" + news.Content + "',newsauthor='" + news.Author + "' where newstitle='" + news.Title + "'";
//int count = db.SQLExecuteReturn(SQL);
//if (count > 0)
// flag = true;
return(flag);
}
//新闻数据定点查询
public DataTable SearchIDNews(Model.News news)
{
string SQL = "select * from news where newstitle='" + news.Title + "'";
return(db.SQLGetDataTable(SQL));
}
//新闻数据的显示（数据表）
public DataTable SearchNews(Model.News news)
{
string SQL = "select * from news";
return(db.SQLGetDataTable(SQL));
}
//显示具体新闻内容
public DataTable ShowNewsDetail(Model.News news)
{
string SQL = "select * from news where ID='" + news.ID + "'";
return(db.SQLGetDataTable(SQL));
}
