public DataTable GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,title,FROM_UNIXTIME(created) created,creator,FROM_UNIXTIME(changed) changed,changer,click,sort_id,content,up,support,status,summary,carousel_url,thumbnail_url,description from article ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
PersonalWorkAPI.Model.article model = new PersonalWorkAPI.Model.article();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
//public PersonalWorkAPI.Model.article GetModel(int id)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select id,title,created,creator,changed,changer,click,sort_id,content,up,support,status from article ");
// strSql.Append(" where id=@id");
// MySqlParameter[] parameters = {
// new MySqlParameter("@id", MySqlDbType.Int32)
// };
// parameters[0].Value = id;
// PersonalWorkAPI.Model.article model = new PersonalWorkAPI.Model.article();
// DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
// if (ds.Tables[0].Rows.Count > 0)
// {
// return DataRowToModel(ds.Tables[0].Rows[0]);
// }
// else
// {
// return null;
// }
//}
/// <summary>
/// 得到一个对象实体
/// </summary>
public PersonalWorkAPI.Model.article DataRowToModel(DataRow row)
{
PersonalWorkAPI.Model.article model = new PersonalWorkAPI.Model.article();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["title"] != null)
{
model.title = row["title"].ToString();
}
if (row["created"] != null && row["created"].ToString() != "")
{
model.created = row["created"].ToString();
}
if (row["creator"] != null)
{
model.creator = row["creator"].ToString();
}
if (row["changed"] != null && row["changed"].ToString() != "")
{
model.changed = row["changed"].ToString();
}
if (row["changer"] != null)
{
model.changer = row["changer"].ToString();
}
if (row["click"] != null && row["click"].ToString() != "")
{
model.click = int.Parse(row["click"].ToString());
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(row["sort_id"].ToString());
}
if (row["content"] != null)
{
model.content = row["content"].ToString();
}
if (row["up"] != null && row["up"].ToString() != "")
{
model.up = int.Parse(row["up"].ToString());
}
if (row["support"] != null && row["support"].ToString() != "")
{
model.support = int.Parse(row["support"].ToString());
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
if (row["sort_name"] != null)
{
model.sort_name = row["sort_name"].ToString();
}
if (row["summary"] != null && row["summary"].ToString() != "")
{
model.summary = row["summary"].ToString();
}
if (row["carousel_url"] != null && row["carousel_url"].ToString() != "")
{
model.carousel_url = row["carousel_url"].ToString();
}
if (row["thumbnail_url"] != null && row["thumbnail_url"].ToString() != "")
{
model.thumbnail_url = row["thumbnail_url"].ToString();
}
if (row["description"] != null && row["description"].ToString() != "")
{
model.description = row["description"].ToString();
}
}
return(model);
}
