/// <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; } }