/// <summary>
/// 得到一个对象实体
/// </summary>
public MZZ.Model.tb_imgs DataRowToModel(DataRow row)
{
MZZ.Model.tb_imgs model=new MZZ.Model.tb_imgs();
if (row != null)
{
if(row["imgs_id"]!=null && row["imgs_id"].ToString()!="")
{
model.imgs_id=int.Parse(row["imgs_id"].ToString());
}
if(row["imgs_path"]!=null)
{
model.imgs_path=row["imgs_path"].ToString();
}
if(row["imgs_etag"]!=null)
{
model.imgs_etag=row["imgs_etag"].ToString();
}
if(row["imgs_path_md5"]!=null)
{
model.imgs_path_md5=row["imgs_path_md5"].ToString();
}
if(row["imgs_mime"]!=null)
{
model.imgs_mime=row["imgs_mime"].ToString();
}
if(row["imgs_height"]!=null && row["imgs_height"].ToString()!="")
{
model.imgs_height=int.Parse(row["imgs_height"].ToString());
}
if(row["imgs_width"]!=null && row["imgs_width"].ToString()!="")
{
model.imgs_width=int.Parse(row["imgs_width"].ToString());
}
if(row["imgs_size"]!=null && row["imgs_size"].ToString()!="")
{
model.imgs_size=int.Parse(row["imgs_size"].ToString());
}
if(row["imgs_quote"]!=null && row["imgs_quote"].ToString()!="")
{
model.imgs_quote=int.Parse(row["imgs_quote"].ToString());
}
if(row["imgs_score"]!=null && row["imgs_score"].ToString()!="")
{
model.imgs_score=int.Parse(row["imgs_score"].ToString());
}
if(row["imgs_score_tip"]!=null && row["imgs_score_tip"].ToString()!="")
{
model.imgs_score_tip=int.Parse(row["imgs_score_tip"].ToString());
}
if(row["imgs_score_task"]!=null)
{
model.imgs_score_task=row["imgs_score_task"].ToString();
}
if(row["imgs_time"]!=null && row["imgs_time"].ToString()!="")
{
model.imgs_time=int.Parse(row["imgs_time"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MZZ.Model.tb_imgs GetModel(int imgs_id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select imgs_id,imgs_path,imgs_etag,imgs_path_md5,imgs_mime,imgs_height,imgs_width,imgs_size,imgs_quote,imgs_score,imgs_score_tip,imgs_score_task,imgs_time from tb_imgs ");
strSql.Append(" where imgs_id=@imgs_id");
MySqlParameter[] parameters = {
new MySqlParameter("@imgs_id", MySqlDbType.Int32)
};
parameters[0].Value = imgs_id;
MZZ.Model.tb_imgs model=new MZZ.Model.tb_imgs();
DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
