// 重置数据
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" }));
}
}
}
}
}
