/// <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);
}
