110,535
社区成员
发帖
与我相关
我的任务
分享
static void Main(string[] args)
{
//年龄分段
List<RoundAge> rList = new List<RoundAge>()
{
new RoundAge(){Begin=18,End=29},
new RoundAge(){Begin=30,End=49},
new RoundAge(){Begin=50,End=79},
};
//用户输入
var input = new RoundAge() { Begin = 18, End = 80 };
var q = rList.Where(x => input.Begin >= x.Begin || input.End <= x.End).ToList();
foreach (var item in q)
{
Console.WriteLine(string.Format("所属年龄段:{0}---{1}",item.Begin,item.End));
}
Console.ReadLine();
}
public class RoundAge
{
public int Begin { get; set; }
public int End { get; set; }
}
SELECT * FROM dbo.TestAge WHERE
(18 BETWEEN BeginAge AND EndAge)
OR (72 BETWEEN BeginAge AND EndAge)
OR (BeginAge BETWEEN 18 AND 72)
OR (EndAge BETWEEN 18 AND 72)