public IList <PolicyArticle> FindALLByHits()
{
List <PolicyArticle> list = new List <PolicyArticle>();
sql = "select top 12 * from PolicyArticle order by hits desc";
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
PolicyArticle a = new PolicyArticle();
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 Save_Click(object sender, EventArgs e)
{
if (txtContent.Text.Trim().Length == 0)
{
Response.Write("<script>alert('内容不能为空！');</script>");
return;
}
object id = Request.QueryString["id"];//有待改善不安全
PolicyArticle da = new PolicyArticle();
PolicyArticleBLL policyarticlebll = new PolicyArticleBLL();
da.AddDate = Convert.ToDateTime(TxtDate.Text);
da.Writer = Server.HtmlEncode(TxtWriter.Text.Trim());
da.Title = Server.HtmlEncode(TxtTitle.Text.Trim());
da.Id = id;
da.Content = txtContent.Text;
if (policyarticlebll.Update(da))
{
Response.Write("<script>alert('修改成功');window.location.href='PolicyMgr.aspx';</script>");
}
else
{
Response.Write("<script>alert('更新失败');history.back();</script>");
}
}
public IList <PolicyArticle> Getlist(object num)//取PolicyArticle表中前num个记录,以列表的形式返回
{
List <PolicyArticle> list = new List <PolicyArticle>();
if (num != null && num.ToString() != "")
{
sql = "select top " + num + " * from PolicyArticle order by id desc";
}
else
{
sql = "select * from PolicyArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
PolicyArticle a = new PolicyArticle();
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 <PolicyArticle> FindALL(object cid, int num)//找到cid的类中前num的列表
{
List <PolicyArticle> list = new List <PolicyArticle>();
if (cid != null && cid.ToString() != "")
{
sql = "select top " + num + " * from PolicyArticle where cid=" + cid + " order by id desc";
}
else
{
sql = "select top " + num + " * from PolicyArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
PolicyArticle a = new PolicyArticle();
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 void DateBind(object id)//绑定要修改的信息
{
PolicyArticleBLL policyarticlebll = new PolicyArticleBLL();
PolicyArticle da = new PolicyArticle();
da = policyarticlebll.GetNewsArticle(id);
TxtTitle.Text = da.Title;
TxtWriter.Text = da.Writer;
TxtDate.Text = da.AddDate.ToString("d");
txtContent.Text = da.Content.ToString();
}
public bool Update(PolicyArticle a)
{
if (DbHelperSQL.Update(a))
{
return(true);
}
else
{
return(false);
}
}
public bool Add(PolicyArticle a)
{
if (DbHelperSQL.Insert(a))
{
return(true);
}
else
{
return(false);
}
}
public PolicyArticle Find(object id)//从PolicyArticle找到该id的数据，返回一个PolicyArticle类生成的对象
{
a = new PolicyArticle();
string sql = string.Format("select * from PolicyArticle 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 <PolicyArticle> search(string cid)//搜索该表中，所有与关键字匹配的记录，当cid为空时，搜索整个表
{
if (cid == "" || cid == null)
{
sql = "select * from PolicyArticle order by id desc";
ds = DbHelperSQL.GetDataSet(sql);
}
else
{
sql = "select * from ExampleArticle where title like '%" + cid + "%' order by id desc";
SqlParameter par = new SqlParameter("@titlesea", SqlDbType.NVarChar, 50);
par.Value = cid;
SqlParameter tablename = new SqlParameter("@tablename", SqlDbType.NVarChar, 50);
tablename.Value = "PolicyArticle";
SqlParameter[] cmdParms = { tablename, par };
ds = DbHelperSQL.RunProcedure("PolicySearch", cmdParms, "PolicyArticle");
}
List <PolicyArticle> list = new List <PolicyArticle>();
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
PolicyArticle a = new PolicyArticle();
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;
}
PolicyArticle da = new PolicyArticle();
PolicyArticleBLL policyarticlebll = new PolicyArticleBLL();
da.AddDate = Convert.ToDateTime(TxtDate.Text);
da.Writer = Server.HtmlEncode(TxtWriter.Text.Trim());
da.Title = Server.HtmlEncode(TxtTitle.Text.Trim());
da.Content = txtContent.Text;
if (policyarticlebll.Add(da))
{
Response.Write("<script>alert('添加成功');window.location.href='PolicyMgr.aspx';</script>");
}
else
{
Response.Write("<script>alert('添加失败');history.back();</script>");
}
}
public bool Update(PolicyArticle news)//更新数据
{
return(PolicyArticleDAO.Update(news));
}
public bool Add(PolicyArticle news)//加数据
{
return(PolicyArticleDAO.Add(news));
}
public async Task <Result> Handle(EditPolicyArticleCommand request, CancellationToken cancellationToken)
{
var id = string.IsNullOrWhiteSpace(request.Id) ? 0 : Convert.ToInt32(request.Id);
var show = request.Show == "1";
var sort = Convert.ToInt32(request.Sort);
var typeId = Convert.ToInt32(request.PolicyTypeId);
if (!await _policyTypeRepository.AnyAsync(x => x.Id == typeId))
{
return(Result.Failure($"typeId={typeId}类型不存在"));
}
if (id <= 0) //新增
{
var article = new PolicyArticle()
{
Content = request.Content,
Show = show,
Sort = sort,
ThemeTitle = request.ThemeTitle,
PolicyTypeId = typeId,
Source = request.Source,
Status = 0,
UserId = request.LoginUser.Id,
Describe = request.Content.FilterHtml().Cut(300)
};
if (request.LoginUser.Type == 1)
{
article.Status = 1;
}
await _policyArticleRepository.AddAsync(article);
}
else
{
//修改
var article = await _policyArticleRepository.Set().FirstOrDefaultAsync(x => x.Id == id);
if (article == null)
{
return(Result.Failure($"id={request.Id}错误文章不存在"));
}
if (!request.LoginUser.IsAdmin && article.Status == 1)
{
return(Result.Failure($"当前状态不能修改！"));
}
article.Content = request.Content;
article.Show = show;
article.Sort = sort;
article.ThemeTitle = request.ThemeTitle;
article.PolicyTypeId = typeId;
article.Source = request.Source;
article.Describe = request.Content.FilterHtml().Cut(300);
if (request.LoginUser.Type == 1)
{
article.Status = Convert.ToInt32(request.Status);
}
else
{
article.Status = 0;
}
await _policyArticleRepository.UpdateAsync(article);
}
return(Result.Success());
}
