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); }