public IWxRes GetResById(int id) { IWxRes res = null; DataBaseAccess db = this._dao.New(); db.ExecuteReader("SELECT Id ,ResKey,TypeId,TypeName,CreateTime,UpdateTime FROM wx_res WHERE Id=" + id.ToString(), rd => { if (rd.Read()) { int typeId = rd.GetInt32(2); if (typeId == 1) { res = new TextRes { CreateTime = rd.GetDateTime(4), UpdateTime = rd.GetDateTime(5), TypeId = typeId, TypeName = rd.GetString(3), ResKey = rd.GetString(1), Id = rd.GetInt32(0) }; } else { res = new ArticleRes { CreateTime = rd.GetDateTime(4), UpdateTime = rd.GetDateTime(5), TypeId = typeId, ResKey = rd.GetString(1), TypeName = rd.GetString(3), Id = rd.GetInt32(0) }; } } }); if (res != null) { TextRes tRes; ArticleRes atRes; if ((tRes = (res as TextRes)) != null) { db.ExecuteReader("SELECT Content FROM wx_text Where resid=" + tRes.Id.ToString(), rd => { if (rd.Read()) { tRes.Content = rd.GetString(0); } }); } else { atRes = res as ArticleRes; db.ExecuteReader("SELECT * FROM wx_art_item WHERE resid=" + atRes.Id.ToString() + " ORDER BY sort,id", rd => { if (rd.HasRows) { atRes.Items = rd.ToEntityList<ArticleResItem>(); } }); if (atRes.Items != null) { foreach (var articleResItem in atRes.Items) { articleResItem.SetArticle(atRes); } } else { atRes.Items = new List<ArticleResItem>(); } } } return res; }
private int SaveArticleRes(ArticleRes artRes) { DataBaseAccess db = this._dao.New(); var data = new object[,] { {"@Id", artRes.Id}, {"@ResKey", artRes.ResKey}, {"@CreateTime", artRes.CreateTime}, {"@UpdateTime", artRes.UpdateTime}, {"@TypeId", artRes.TypeId}, {"@TypeName", artRes.TypeName} }; if (artRes.Id > 0) { db.ExecuteNonQuery(new SqlQuery("UPDATE wx_res SET reskey=@resKey,updatetime=@updatetime WHERE id=@Id", data)); } else { int row = db.ExecuteNonQuery(new SqlQuery(@"INSERT INTO wx_res (ResKey,TypeId,TypeName,CreateTime,UpdateTime) VALUES (@ResKey,@TypeId,@TypeName,@CreateTime,@UpdateTime)", data)); if (row == 1) { int id = Convert.ToInt32(db.ExecuteScalar("SELECT MAX(id) FROM wx_res")); return id; } } return artRes.Id; }
public void SetArticle(ArticleRes art) { this._art = art; }
public ArticleResItem(ArticleRes art) { this._art = art; }