public IList <AllianceArticle> FindALLByHits()
{
List <AllianceArticle> list = new List <AllianceArticle>();
sql = "select top 12 * from AllianceArticle order by hits desc";
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
AllianceArticle a = new AllianceArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
protected void Add_Click(object sender, EventArgs e)
{
if (txtContent.Text.Trim().Length == 0)
{
Response.Write("<script>alert('内容不能为空！');</script>");
return;
}
AllianceArticle da = new AllianceArticle();
AllianceArticleBLL alliancearticlebll = new AllianceArticleBLL();
string title = Server.HtmlEncode(TxtTitle.Text.Trim());
string writer = Server.HtmlEncode(TxtWriter.Text.Trim());
da.AddDate = Convert.ToDateTime(TxtDate.Text);
da.Writer = writer;
da.Title = title;
da.Content = txtContent.Text;
if (alliancearticlebll.Add(da))
{
Response.Write("<script>alert('添加成功');window.location.href='AllianceMgr.aspx';</script>");
}
else
{
Response.Write("<script>alert('添加失败');history.back();</script>");
}
}
public IList <AllianceArticle> FindALL(object cid, int num)//找到cid的类中前num的列表
{
List <AllianceArticle> list = new List <AllianceArticle>();
if (cid != null && cid.ToString() != "")
{
sql = "select top " + num + " * from AllianceArticle where cid=" + cid + " order by id desc";
}
else
{
sql = "select top " + num + " * from AllianceArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
AllianceArticle a = new AllianceArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
public IList <AllianceArticle> Getlist(object num)//取AllianceArticle表中前num个记录,以列表的形式返回
{
List <AllianceArticle> list = new List <AllianceArticle>();
if (num != null && num.ToString() != "")
{
sql = "select top " + num + " * from AllianceArticle order by id desc";
}
else
{
sql = "select * from AllianceArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
AllianceArticle a = new AllianceArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
public bool Update(AllianceArticle a)
{
if (DbHelperSQL.Update(a))
{
return(true);
}
else
{
return(false);
}
}
public bool Add(AllianceArticle a)
{
if (DbHelperSQL.Insert(a))
{
return(true);
}
else
{
return(false);
}
}
public void DateBind(object id)//绑定要修改的信息
{
AllianceArticleBLL alliancearticlebll = new AllianceArticleBLL();
AllianceArticle da = new AllianceArticle();
da = alliancearticlebll.GetNewsArticle(id);
TxtTitle.Text = da.Title;
TxtWriter.Text = da.Writer;
TxtDate.Text = da.AddDate.ToString("d");
txtContent.Text = da.Content.ToString();
}
public AllianceArticle Find(object id)//从AllianceArticle找到该id的数据，返回一个AllianceArticle类生成的对象
{
a = new AllianceArticle();
string sql = string.Format("select * from AllianceArticle where id='{0}'", id);
dr = DbHelperSQL.GetDateRow(sql);
try
{
a.AddDate = Convert.ToDateTime(dr["AddDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
return(a);
}
catch
{
return(null);
}
}
public IList <AllianceArticle> search(string cid)//搜索该表中，所有与关键字匹配的记录，当cid为空时，搜索整个表
{
if (cid == "" || cid == null)
{
sql = "select * from AllianceArticle order by id desc";
ds = DbHelperSQL.GetDataSet(sql);
}
else
{
SqlParameter par = new SqlParameter("@titlesea", SqlDbType.NVarChar, 50);
par.Value = cid;
SqlParameter tablename = new SqlParameter("@tablename", SqlDbType.NVarChar, 50);
tablename.Value = "AllianceArticle";
SqlParameter[] cmdParms = { tablename, par };
ds = DbHelperSQL.RunProcedure("AllianceSearch", cmdParms, "AllianceArticle");
}
List <AllianceArticle> list = new List <AllianceArticle>();
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
AllianceArticle a = new AllianceArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
public bool Update(AllianceArticle news)//更新数据
{
return(AllianceArticleDao.Update(news));
}
public bool Add(AllianceArticle news)//添加数据
{
return(AllianceArticleDao.Add(news));
}