/// <summary>
/// 得到一个对象实体
/// </summary>
public MZZ.Model.tb_lntegral_users DataRowToModel(DataRow row)
{
MZZ.Model.tb_lntegral_users model=new MZZ.Model.tb_lntegral_users();
if (row != null)
{
if(row["id"]!=null && row["id"].ToString()!="")
{
model.id=int.Parse(row["id"].ToString());
}
if(row["openid"]!=null)
{
model.openid=row["openid"].ToString();
}
if(row["prizeid"]!=null && row["prizeid"].ToString()!="")
{
model.prizeid=int.Parse(row["prizeid"].ToString());
}
if(row["address"]!=null)
{
model.address=row["address"].ToString();
}
if(row["name"]!=null)
{
model.name=row["name"].ToString();
}
if(row["cellphone"]!=null)
{
model.cellphone=row["cellphone"].ToString();
}
if(row["createdate"]!=null && row["createdate"].ToString()!="")
{
model.createdate=DateTime.Parse(row["createdate"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MZZ.Model.tb_lntegral_users GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select id,openid,prizeid,address,name,cellphone,createdate from tb_lntegral_users ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters = {
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
MZZ.Model.tb_lntegral_users model=new MZZ.Model.tb_lntegral_users();
DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
