// 重置数据 private void ResetData() { members = Tool.GetField(data); foreach (FieldInfo item in members) { Log.Debug("字段:{0},值:{1}", item.Name, item.GetValue(data)); ShowMember show_mem = null; foreach (ShowMember mem in MemberList) { if (mem.id == item.Name) { show_mem = mem; break; } } if (show_mem == null) { return; } InputItem input_clone = InputItem.Clone <InputItem>(); input_clone.gameObject.name = item.Name; input_clone.RefreshData(show_mem.name, item.GetValue(data).ToString(), show_mem.read_only); InputList.Add(input_clone); } }
public async Task <ActionResult <IEnumerable <ShowMember> > > GetMemberList([FromRoute] int groupId) { Console.WriteLine("show all member in this group " + groupId); await using (SqlConnection sqlConnection = new SqlConnection(Global.connect_string)) { sqlConnection.Open(); string strCreate = @"SELECT Group_User.UserId, UserName,UniformNumber,IsManager,LastGameDate,UserPhoto FROM [Group_User] ,[UserInfo] WHERE Group_User.GroupId = @groupId AND UserInfo.UserId = Group_User.UserId AND Group_User.UserId IN (SELECT UserId FROM Group_User WHERE GroupId= @groupId AND Accepted IN (1,2)) ORDER BY isManager DESC, JoinGroupDate DESC"; await using (SqlCommand cmd = new SqlCommand(strCreate, sqlConnection)) { cmd.Parameters.AddWithValue("@groupId", groupId); await using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { ShowMember newObj = new ShowMember(); newObj.UserId = reader.GetInt32(0); newObj.UserName = reader.GetString(1); newObj.UniformNumber = reader.IsDBNull(2) ? 0 : reader.GetInt32(2); switch (reader.GetInt32(3)) { case 0: newObj.Role = "is member"; break; case 1: newObj.Role = "is manager"; break; } newObj.LastGameDate = reader.IsDBNull(4) ? "haven't play yet" : reader.GetDateTime(4).ToString("yyyy-MM-dd"); string photoRoute = null; if (!reader.IsDBNull(5)) { photoRoute = Global.user_photo_url + reader.GetString(5); } newObj.UserPhoto = photoRoute; memberList.Add(newObj); } return(CreatedAtAction("GetMemberList", new { errorcode = -1, msg = "success get memberList", MemberList = memberList })); } else { return(CreatedAtAction("GetMemberList", new { errorcode = 400, msg = "no member in this group" })); } } } } }