//插入需求 public Boolean insertUserCompleteRequirement(UserCompleteRequirement completerequirement) { String sql = "INSERT INTO tb_complete_requirement(user_id,requirement_id,complete_time) VALUES(@user_id,@requirement_id,@complete_time)"; SqlCommand cmd = DbUtil.getCommand(sql); cmd.Parameters.Add(new SqlParameter("@user_id", completerequirement.User)); cmd.Parameters.Add(new SqlParameter("@requirement_id", completerequirement.Requirement)); cmd.Parameters.Add(new SqlParameter("@complete_time", completerequirement.CompleteTime)); int i = cmd.ExecuteNonQuery(); DbUtil.close(); if (i > 0) { return(true); } else { return(false); } }
//查询某个用户(ID)的所有完成的需求 public List <UserCompleteRequirement> queryUserCompleteRequirementByUserId(int userId) { List <UserCompleteRequirement> list = new List <UserCompleteRequirement>(); String sql = "SELECT * FROM tb_complete_requirement WHERE user_id = @user_id"; SqlCommand cmd = DbUtil.getCommand(sql); cmd.Parameters.Add("@user_id", userId); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.HasRows) { while (sdr.Read()) { UserCompleteRequirement completerequirement = new UserCompleteRequirement(); completerequirement.User.Id = sdr.GetInt32(0); completerequirement.Requirement.Id = sdr.GetInt32(1); completerequirement.CompleteTime = sdr.GetDateTime(2); list.Add(completerequirement); } } return(list); }