public ArticleResItem GetArticleItem(int id)
{
ArticleResItem res = null;
DataBaseAccess db = this._dao.New();
db.ExecuteReader(
"SELECT Id ,ResId,Title ,Content,Url ,Pic ,Sort,Enabled,Description FROM wx_art_item WHERE Id=" + id.ToString(),
rd =>
{
if (rd.Read())
{
int resId = rd.GetInt32(1);
res = new ArticleResItem(new ArticleRes {
Id = resId
});
res.Id = rd.GetInt32(0);
res.Title = rd.GetString(2);
res.Content = rd.GetString(3);
res.Url = rd.GetString(4);
res.Pic = rd.GetString(5);
res.Sort = rd.GetInt32(6);
res.Enabled = rd.GetBoolean(7);
res.Description = rd.GetString(8);
}
});
return(res);
}
public string EditArticleItem(HttpContext context)
{
string resId = context.Request["res_id"];
int id = int.Parse(context.Request["id"]);
TemplatePage page = this._app.GetPage(this._plugin, "mg/article_item.html");
ArticleResItem res = IocObject.WeixinRes.GetArticleItem(id);
page.AddVariable("content", res.Content);
page.AddVariable("description", res.Description);
res.Content = null;
res.Description = null;
page.AddVariable("entity", res != null ? JsonConvert.SerializeObject(res) : "{}");
page.AddVariable("resId", resId);
return(page.ToString());
}
public string SaveArticleItem_post(HttpContext context)
{
bool isCreate = false;
try
{
ArticleResItem tres = context.Request.Form.ConvertToEntity <ArticleResItem>();
isCreate = tres.Id <= 0;
ArticleRes res = IocObject.WeixinRes.GetResById(int.Parse(context.Request.Form["ResId"])) as ArticleRes;
tres.SetArticle(res);
int id = tres.Save();
}
catch (Exception exc)
{
return("{result:false,message:'" + exc.Message + "'}");
}
return("{result:true,message:'" + (isCreate ? "添加成功" : "保存成功") + "'}");
}
public int SaveArticleItem(int id, ArticleResItem item)
{
DataBaseAccess db = this._dao.New();
var data = new object[, ]
{
{ "@ResId", id },
{ "@Description", item.Description },
{ "@Content", item.Content },
{ "@Enabled", item.Enabled },
{ "@Pic", item.Pic },
{ "@Id", item.Id },
{ "@Sort", item.Sort },
{ "@Title", item.Title },
{ "@Url", item.Url },
};
if (item.Id > 0)
{
db.ExecuteNonQuery(new SqlQuery(@"UPDATE wx_art_item SET Title = @Title ,
[Content]=@Content, Description=@Description,[Url] = @Url ,[Pic] = @Pic ,[Sort] = @Sort ,[Enabled] = @Enabled
WHERE [ResId] = @ResId AND id=@Id",
data));
}
else
{
int row =
db.ExecuteNonQuery(new SqlQuery(@"INSERT INTO wx_art_item ([ResId],[Title],Description,[Content],[Url],[Pic],[Sort],[Enabled])
VALUES (@ResId,@Title,@Description,@Content,@Url,@Pic,@Sort,@Enabled)", data));
if (row == 1)
{
return(Convert.ToInt32(db.ExecuteScalar("SELECT MAX(id) FROM wx_art_item")));
}
}
return(item.Id);
}
