protected void Page_Load(object sender, EventArgs e)
{
LoadNewsCat(LoadOldNews());
if (IsPostBack)
{
MODEL.News model = new MODEL.News();
model.Id = Convert.ToInt32(Context.Request.QueryString["id"]);
model.Catid = Convert.ToInt32(Request.Form["selNewsCate"]);
model.Ntitle = Request.Form["title"];
model.Ncontent = Request.Form["myeditor"];
BLL.News bllNews = new BLL.News();
if (bllNews.ModifyNews(model) > 0)
{
Context.Response.Write("<script>alert('修改成功啦！')</script>");
}
}
}
/// <summary>
///
/// </summary>
/// <param name="cid"></param>
/// <returns></returns>
public List<MODEL.News> GetNewsBycid(int cid)
{
string sql = "select * from news inner join newsCat on news.catid=newsCat.id where news.isdelete=0 and news.catid=@cid order by ncreatedate desc";
MySqlParameter sp = new MySqlParameter("@cid", cid);
List<MODEL.News> list = new List<MODEL.News>();
DataTable dt = MySqlHelper.ExcuteDataTable(sql, sp);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
MODEL.News model = new MODEL.News();
LoadEntityData(model, dr);
list.Add(model);
}
}
return list;
}
public List<MODEL.News> GetAllNews()
{
using (MagazineDBEntities cntxt = new MagazineDBEntities())
{
var newsList = new List<MODEL.News>();
var newsListDAL = cntxt.News.ToList();
foreach (var n in newsListDAL)
{
var news = new MODEL.News();
news.NewsID = n.NewsID;
newsList.Add(news);
}
return newsList;
}
}
protected void Page_Load(object sender, EventArgs e)
{
LoadNewsCat();
if (IsPostBack)
{
MODEL.News model = new MODEL.News();
model.Ntitle = Request.Form["title"];
model.Ncontent = Request.Form["editor01"];
model.Catid = Convert.ToInt32(Request.Form["selNewsCate"]);
BLL.News bllNews = new BLL.News();
if (bllNews.AddNews(model))
{
Response.Write("<script>alert('添加成功！')</script>");
}
else
{
Response.Write("失败！请重试！");
}
}
}
