/// <summary> /// 更新一条数据 /// </summary> public bool UpdateByUserId(DataAngine.Model.hitrecord_detail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update hitrecord_detail set "); strSql.Append("hit_record_id=:hit_record_id,"); strSql.Append("rank=:rank,"); strSql.Append("score=:score"); strSql.Append(" where user_id=:user_id"); OracleParameter[] parameters = { new OracleParameter(":hit_record_id", OracleType.Int32), new OracleParameter(":user_id", OracleType.Int32), new OracleParameter(":rank", OracleType.Int32), new OracleParameter(":score", OracleType.Float), new OracleParameter(":id", OracleType.Int32) }; parameters[0].Value = model.hit_record_id; parameters[1].Value = model.user_id; parameters[2].Value = model.rank; parameters[3].Value = model.score; parameters[4].Value = model.id; int rows = DbHelperOracle.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据HitrecordId 获得 hitrecord_detail /// </summary> /// <param name="HitrecordId"></param> /// <returns></returns> public List <DataAngine.Model.hitrecord_detail> GetModelByHitUserId(int hitUserId) { List <DataAngine.Model.hitrecord_detail> modelList = new List <Model.hitrecord_detail>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,hit_record_id,user_id,rank,score from hitrecord_detail "); strSql.Append(" where user_id=@user_id"); OracleParameter[] parameters = { new OracleParameter("@user_id", OracleType.Int32) }; parameters[0].Value = hitUserId; DataAngine.Model.hitrecord_detail model = new DataAngine.Model.hitrecord_detail(); DataSet ds = DbHelperOracle.ExecuteDataSet(CommandType.Text, strSql.ToString(), parameters); foreach (var row in ds.Tables[0].Rows) { modelList.Add(DataRowToModel((DataRow)row)); } return(modelList); }