/// <summary> /// 获取当前奖期 /// </summary> /// <param name="gameCode"></param> /// <param name="gameType"></param> /// <returns></returns> public Issuse_QueryInfo QueryCurrentIssuse(string gameCode, string gameType = "") { var bol = string.IsNullOrEmpty(gameType); //var query = from i in DB.CreateQuery<C_Game_Issuse>() // where i.GameCode == gameCode // && (string.IsNullOrEmpty(gameType) || i.GameType == gameType) // && i.Status == (int)IssuseStatus.OnSale // && i.LocalStopTime > DateTime.Now // orderby i.LocalStopTime ascending // select i; var query = DB.CreateQuery <C_Game_Issuse>(); if (bol) { query = query.Where(p => p.GameCode == gameCode && p.Status == (int)IssuseStatus.OnSale && p.LocalStopTime > DateTime.Now ).OrderBy(p => p.LocalStopTime); } else { query = query.Where(p => p.GameCode == gameCode && p.Status == (int)IssuseStatus.OnSale && p.LocalStopTime > DateTime.Now && p.GameType == gameType ).OrderBy(p => p.LocalStopTime); } var info = query.FirstOrDefault(); Issuse_QueryInfo returninfo = null; if (info != null) { returninfo = new Issuse_QueryInfo() { CreateTime = info.CreateTime, GameCode_IssuseNumber = info.GameCode_IssuseNumber, GatewayStopTime = info.GatewayStopTime, IssuseNumber = info.IssuseNumber, LocalStopTime = info.LocalStopTime, OfficialStopTime = info.OfficialStopTime, StartTime = info.StartTime, Status = (IssuseStatus)info.Status, WinNumber = info.WinNumber, Game = new GameInfo() { GameCode = info.GameCode } }; } return(returninfo); }
public Issuse_QueryInfo QueryCurrentIssuseInfoWithOffical(string gameCode) { var entity = new LotteryGameManager().QueryCurrentIssuseWithOffical(gameCode); if (entity == null) { return(null); } var info = new Issuse_QueryInfo { Status = IssuseStatus.OnSale }; ObjectConvert.ConverEntityToInfo <GameIssuse, Issuse_QueryInfo>(entity, ref info); var gameInfo = new GameInfo(); gameInfo.GameCode = entity.GameCode; //ObjectConvert.ConverEntityToInfo<LotteryGame, GameInfo>(entity.Game, ref gameInfo); info.Game = gameInfo; return(info); }
public Issuse_QueryInfo QueryCurrentNewIssuseInfo(string gameCode, string gameType) { var entity = new DataQuery().QueryCurrentNewIssuseInfo(gameCode, gameType); if (entity == null) { return(null); } var info = new Issuse_QueryInfo { Status = IssuseStatus.OnSale }; ObjectConvert.ConverEntityToInfo <GameIssuse, Issuse_QueryInfo>(entity, ref info); var gameInfo = new GameInfo(); gameInfo.GameCode = entity.GameCode; //ObjectConvert.ConverEntityToInfo<LotteryGame, GameInfo>(entity.Game, ref gameInfo); info.Game = gameInfo; return(info); }