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;
}
public void SetArticle(ArticleRes art)
{
this._art = art;
}
public ArticleResItem(ArticleRes art)
{
this._art = art;
}
