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