/// <summary>
/// 得到一个对象实体
/// </summary>
public Pan.Model.News DataRowToModel(DataRow row)
{
Pan.Model.News model = new Pan.Model.News();
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();
}
try
{
if (row["summary"] != null)
{
model.summary = row["summary"].ToString();
}
}
catch { }
if (row["isTop"] != null)
{
model.isTop = row["isTop"].ToString();
}
if (row["isReco"] != null)
{
model.isReco = row["isReco"].ToString();
}
if (row["type"] != null)
{
model.type = row["type"].ToString();
}
try
{
if (row["content"] != null)
{
model.content = row["content"].ToString();
}
if (row["author"] != null)
{
model.author = row["author"].ToString();
}
if (row["source"] != null)
{
model.source = row["source"].ToString();
}
if (row["views"] != null)
{
model.views = row["views"].ToString();
}
if (row["keywords"] != null)
{
model.keywords = row["keywords"].ToString();
}
if (row["description"] != null)
{
model.description = row["description"].ToString();
}
}
catch { }
if (row["time"] != null)
{
model.time = row["time"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Pan.Model.News GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,title,summary,isTop,isReco,type,content,author,source,views,keywords,description,time from News ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
Pan.Model.News model = new Pan.Model.News();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
