string arrStr =string.empty;
DataTable dt = bll.GameKind(传方法参数);
List<int> lstID = (from d in dt.AsEnumerable()select d.Field<int>("要找的字段名int类型")).ToList<int>();
foreach (var item in lstID)
{
arrStr += item + ",";
}
arrStr = arrStr.TrimEnd(',');
或者
var adminList = dt.AsEnumerable().Where(d => d.Field<int>("条件字段名") == 1).Select(d => d.Field<int>("ParentID")).ToList();
List<Model> list = 调用个方法返回集合
var idList = list.Select(x => x.UserID.ToString()).ToList();
String UIDS = String.Join(",", idList.ToArray());
Dictionary<int, string> dic = Config.GetUsers(UIDS);
String GameNumArray = String.Join(",", list.Select(t => "'" + t.GameNum + "'").Distinct().ToArray());
if (!String.IsNullOrEmpty(GameNumArray))
{
Dictionary<String, TypeModel> numDic = 一个方法(GameNumArray);
list.ForEach(x =>
{
x.USERNAME = dic.ContainsKey(x.UserID) ? dic[x.UserID].Split(',')[2] : x.UserID.ToString();
x.GAMEID = dic.ContainsKey(x.UserID) ? WebUtility.ConvertToInt32(dic[x.UserID].Split(',')[0], 0) : x.UserID;
x.GameTpye = numDic.ContainsKey(x.GameNum) ? numDic[x.GameNum].GameTpye : -1;
});
}
return list;
List<RecordZjhRoomGameModel> dataList = new List<Model.RecordZjhRoomGameModel>();
List<RecordZjhRoomGame> gameList = dal.获取数据方法();
if (gameList.Count > 0)
{
#region 定义赋值变量
int? UserID_1;
int? UserScore_1,;
int? UserChair_1;
DateTime Date;
int ScoreKind;
String HandCard = String.Empty;
#endregion
#region 批量查询玩家xinxi
var lstID = gameList.Select(x => x.UserID.ToString()).Distinct().ToList();
var Userids = String.Join(",", lstID.ToArray());
#endregion
#region group by PlayNum
var sums = from game in gameList
group game by new { game.PlayNum } into g
select new { Data = g.Key };
#endregion
var UserCount = gameList.Select(x => x.UserID).Distinct().Count();
if (UserCount == 3)
{
#region 数据处理
var findList = new List<RecordZjhRoomGame>();
foreach (var item in sums)
{
findList = gameList.Where(x => x.PlayNum == item.Data.PlayNum).ToList();
ScoreKind = findList.Select(x => x.ScoreKind).Max();
Date = WebUtility.ConvertToDateTime(findList.Select(x => x.WriteDate).Max(), DateTime.Now);
UserID_1 = findList.Select(x => x.UserID).ElementAt(0);
UserChair_1 = findList.Select(x => x.ChairID).ElementAt(0);
UserScore_1 = findList.Select(x => x.WinScore).ElementAt(0);
UserScore_2 = findList.Select(x => x.WinScore).ElementAt(1);
dataList.Add(new Model.RecordZjhRoomGameModel()
{
PlayNum = item.Data.PlayNum,
UserID_1 = UserID_1,
UserName_1 = UserDic.ContainsKey(UserID_1.ToString()) ? UserDic[UserID_1.ToString()] : UserID_1.ToString(),
UserScore_1 = UserScore_1,
IsMissed = ScoreKind == 2 ? 1 : 0,
Time1 = Date.ToString("yyyy-MM-dd"),
Time2 = Date.ToString("HH:mm:ss")
});
}
#endregion
}
}
public List<LogModel> logList = new List<LogModel>();
logList = bll.Get方法获取集合(参数);
if (RequestHelper.IsPost())
{
int pageIndex = Request["page"] == null ? 1 : WebUtility.ConvertToInt32(Request["page"], 1);
logList = logList.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var dataList = from query in logList
select new
{
addtime = query.addtime.ToString("yyyy-MM-dd HH:mm:ss"),
memo = query.memo,
ip = query.ip
};
JavaScriptSerializer resultjson = new JavaScriptSerializer();
Context.Response.Write(resultjson.Serialize(dataList));
Context.Response.End();
}
public List<Model> 方法名称(int UserID)
{
var aList = DBData.方法名返回list<model>());
var bList = DBData.方法名返回list<model>());
var list = aList.Union(bList).OrderByDescending(c => c.addtime).ToList();//按照时间排序连个集合合并
return list;
}
public List<Model> 方法名称( )
{
List<Model> list = 方法();
List<Model> list2 = 方法();
list.ForEach(x =>
{
var findList = list2.Find(r => r.LogDate == x.LogDate);
x.CostNum = findList != null ? findList.CostNum : x.CostNum;
x.UsersNum = findList != null ? findList.UsersNum : x.UsersNum;
});
return list;
}