1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleApp20
{
internal class Program
{
private static void Main(string[] args)
{
var memberdata = new List<Member>()
{
new Member(){ MemberID = 1, MemberAccount = "小明"},
new Member(){ MemberID = 2, MemberAccount = "小王"},
new Member(){ MemberID = 3, MemberAccount = "小華"},
};
var scoredata = new List<Score>()
{
new Score(){ MemberID = 1, score = 100},
new Score(){ MemberID = 2, score = 50},
new Score(){ MemberID = 3, score = 40},
};
var membergamelogdata = new List<MemberGameLog>()
{
new MemberGameLog() { MemberID = 1 , LogID = 4001 , LogName = "打棒球" },
new MemberGameLog() { MemberID = 2 , LogID = 4002 , LogName = "打羽球" },
new MemberGameLog() { MemberID = 3 , LogID = 4003 , LogName = "打籃球" }
};
var joindata = memberdata
.Join(membergamelogdata,
member => member.MemberID,
gamelogdata => gamelogdata.MemberID,
(member, gamelogdata) =>
new
{
MemberID = member.MemberID,
MemberAccount = member.MemberAccount,
LogID = gamelogdata.LogID,
LogName = gamelogdata.LogName
})
.Join(scoredata,
memberjoin1 => memberjoin1.MemberID,
score => score.MemberID, (memberjoin1, thescore) =>
{
// Declare variable within LINQ select
var getscorestring = getScoreString(thescore.score);
return new
{
MemberID = memberjoin1.MemberID,
MemberAccount = memberjoin1.MemberAccount,
score = getscorestring,
LogID = memberjoin1.LogID,
LogName = memberjoin1.LogName
};
});
foreach (var item in joindata)
{
Console.WriteLine($"{item.MemberID}, {item.MemberAccount}, {item.score}, {item.LogID}, {item.LogName}");
}
}
private static string getScoreString(int score)
{
if (score > 80)
{
return "甲";
}
else if (score > 60)
{
return "乙";
}
else
{
return "丙";
}
}
private class Score
{
public int MemberID { get; set; }
public int score { get; set; }
}
private class Member
{
public int MemberID { get; set; }
public string MemberAccount { get; set; }
}
private class MemberGameLog
{
public int MemberID { get; set; }
public int LogID { get; set; }
public string LogName { get; set; }
}
}
}
|
