public List <WS_BetInfoDgv> GetBetInfoList(int AccountId, int LotteryId, string Execpt, DateTime betTime)
{
using (e = new LotteryAPPEntities())
{
//游戏。奖期。玩法。赔率。方案。注单金额。开奖号码。状态。中奖金额。操作
var query = (from a in e.BetInfo
from b in e.Accounts
from c in e.Lotterys
from d in e.LotteryPlays
where a.LotteryExcept == Execpt && a.LotteryId == LotteryId &&
a.CreateTime >= betTime && a.AccountId == AccountId &&
a.AccountId == b.Id && a.LotteryId == c.Id && a.BetPlayTypeCode == d.LotteryPlayId && c.LotteryType == d.LotteryType
select new WS_BetInfoDgv
{
AccountName = b.AccountName,
BackMoney = a.BackMoney,
BackTime = a.BackTime,
BetMoney = a.BetMoney,
BetNum = a.BetNum,
BetTimes = a.BetTimes,
BetUnit = a.BetUnit,
ChoicePosition = a.ChoicePosition,
CreateTime = a.CreateTime,
GetBackPercent = a.GetBackPercent,
IsGetBackPercent = a.IsGetBackPercent,
Id = a.Id,
LotteryExcept = a.LotteryExcept,
LotteryId = a.LotteryId,
LotteryName = c.LotteryName,
PlayName = d.LotteryPlayName,
ResultType = a.ResultType,
WinMoney = a.WinMoney,
WinUnit = a.WinUnit,
}).ToList();
if (query.Count > 0)
{
query.ForEach(n => n.ResultTypeStr = EnumTool.GetBetResultType(n.ResultType));
var open = e.LotteryOpenInfo.FirstOrDefault(n => n.LotteryId == LotteryId && n.Expect == Execpt);
if (open != null)
{
query.ForEach(n => n.OpenCode = open.OpenCode);
}
}
return(query);
}
}
public WS_BetInfoDgv GetBetInfo(long id)
{
using (e = new LotteryAPPEntities())
{
var query = (from a in e.BetInfo
from b in e.Accounts
from c in e.Lotterys
from d in e.LotteryPlays
where a.AccountId == b.Id && a.LotteryId == c.Id && a.BetPlayTypeCode == d.LotteryPlayId &&
a.Id == id && c.LotteryType == d.LotteryType
select new WS_BetInfoDgv
{
AccountName = b.AccountName,
BackMoney = a.BackMoney,
BackTime = a.BackTime,
BetMoney = a.BetMoney,
BetNum = a.BetNum,
BetTimes = a.BetTimes,
BetUnit = a.BetUnit,
ChoicePosition = a.ChoicePosition,
CreateTime = a.CreateTime,
GetBackPercent = a.GetBackPercent,
IsGetBackPercent = a.IsGetBackPercent,
Id = a.Id,
LotteryExcept = a.LotteryExcept,
LotteryId = a.LotteryId,
LotteryName = c.LotteryName,
PlayName = d.LotteryPlayName,
ResultType = a.ResultType,
WinMoney = a.WinMoney,
WinUnit = a.WinUnit,
}).FirstOrDefault();
if (query != null)
{
query.ResultTypeStr = EnumTool.GetBetResultType(query.ResultType);
query.ChoicePosition = query.ChoicePosition.Replace("0", "万位").Replace("1", "千位").Replace("2", "百位").Replace("3", "十位").Replace("4", "个位");
var open = e.LotteryOpenInfo.FirstOrDefault(n => n.LotteryId == query.LotteryId && n.Expect == query.LotteryExcept);
if (open != null)
{
query.OpenCode = open.OpenCode;
}
}
return(query);
}
}
public List <WS_AccountBusiness> GetWS_AccountBusiness(int accountId, string betId, string busId, DateTime dtStart, DateTime dtEnd, int type)
{
using (e = new LotteryAPPEntities())
{
long id = 0;
long eId = 0;
dtStart = dtStart.Date;
dtEnd = dtEnd.Date.AddDays(1);
var query = e.AccountBusiness.Where(n => n.AccountId == accountId && n.CreateTime >= dtStart && n.CreateTime < dtEnd);
if (long.TryParse(betId, out eId))
{
query = query.Where(n => n.EventId == eId);
}
if (long.TryParse(busId, out id))
{
query = query.Where(n => n.Id == id);
}
if (type != 0)
{
query = query.Where(n => n.BusinessTypeId == type);
}
var list = (from a in query
from b in e.Accounts
where a.AccountId == b.Id
orderby a.Id descending
select new WS_AccountBusiness
{
AccountName = b.AccountName,
BusinessTypeId = a.BusinessTypeId,
CreateTime = a.CreateTime,
PayAfter = a.PayAfter,
PayBefore = a.PayBefore,
EventId = a.EventId,
PayIn = a.PayIn,
PayOut = a.PayOut,
Id = a.Id,
}).ToList();
list.ForEach(n => n.BusinessTypeStr = EnumTool.GetBusinessType(n.BusinessTypeId));
return(list);
}
}
//public object GetBetHistory(int AccountId,int count)
//{
// using (e = new LotteryAPPEntities())
// {
// var query = e.BetInfo.Where(n => n.AccountId == AccountId).OrderByDescending(n => n.Id).ToList().Select(n => new
// {
// n.BackMoney,
// n.BetMoney,
// BetNum = MyTool.GetBet_danshuang(n.BetNum, n.BetPlayTypeCode),
// BetPlayTypeCode = LotteryOpenTool.LpList().FirstOrDefault(w => w.BetPlayTypeCode == n.BetPlayTypeCode).LotteryPlayName,
// n.BetTimes,
// n.BetUnit,
// n.CreateTime,
// n.WinMoney,
// n.WinUnit,
// OpenNo = MyTool.AddZeroStr(n.LotteryOpenInfo.Expect, 3),
// OpenNum = n.ResultType > 1 ? "" : MyTool.AddZeroStr(n.LotteryOpenInfo.OpenCode),
// Enum_ResultType = MyTool.GetBetResultType(n.ResultType),
// });
// if(count>=0)
// {
// query = query.Take(count);
// }
// return query.ToList();
// }
//}
public object GetBetHistory(int AccountId, Lotterys lottery, DateTime DtLoad)
{
using (e = new LotteryAPPEntities())
{
var query = e.BetInfo.Where(n => n.AccountId == AccountId && n.LotteryOpenInfo.LotteryId == lottery.Id && n.CreateTime >= DtLoad).OrderByDescending(n => n.Id).ToList().Select(n => new
{
n.BackMoney,
n.BetMoney,
BetNum = lottery.LotteryType == "11x5" ? MyTool.GetBet_ZH_11X5(n.BetNum, n.BetPlayTypeCode) : n.BetNum,
BetPlayTypeCode = MyTool.GetLotteryPlayList(lottery.LotteryType)[n.BetPlayTypeCode - 1].LotteryPlayName,
n.BetTimes,
n.BetUnit,
n.CreateTime,
n.WinMoney,
n.WinUnit,
OpenNo = MyTool.AddZeroStr(n.LotteryOpenInfo.Expect, 3),
//OpenNum = n.ResultType==2 ? "" : n.LotteryOpenInfo.OpenCode,
OpenNum = n.LotteryOpenInfo.OpenCode,
Enum_ResultType = EnumTool.GetBetResultType(n.ResultType),
});
return(query.ToList());
}
}
public List <WS_BetInfoDgv> GetBetInfoList(int AccountId, int?LotteryId, DateTime StartTime, DateTime EndTime, int?ResultType, string BetInfoId, bool isIncludeChaseNumber)
{
EndTime = EndTime.Date.AddDays(1);
StartTime = StartTime.Date;
using (e = new LotteryAPPEntities())
{
//var betInfo=e.BetInfo.AsEnumerable();
//var lotterys = e.Lotterys.AsEnumerable();
//if(!string.IsNullOrEmpty(BetInfoId))
//{
// long No=0;
// if(long.TryParse(BetInfoId,out No))
// betInfo=betInfo.Where(n=>n.Id==No);
//}
//if(!isIncludeChaseNumber)
//{
// betInfo=betInfo.Where(n=>n.IsAddNum.HasValue&&n.IsAddNum==false);
//}
//if(ResultType.HasValue)
//{
// betInfo=betInfo.Where(n=>n.ResultType==ResultType.Value);
//}
var query = (from a in e.BetInfo
from b in e.Accounts
from c in e.Lotterys
from d in e.LotteryPlays
where
a.CreateTime >= StartTime && a.CreateTime <= EndTime && a.AccountId == AccountId &&
a.AccountId == b.Id && a.LotteryId == c.Id && a.BetPlayTypeCode == d.LotteryPlayId && c.LotteryType == d.LotteryType
select new { a, b, c, d });
if (LotteryId.HasValue)
{
query = query.Where(n => n.a.LotteryId == LotteryId);
}
if (!string.IsNullOrEmpty(BetInfoId))
{
long No = 0;
if (long.TryParse(BetInfoId, out No))
{
query = query.Where(n => n.a.Id == No);
}
}
if (!isIncludeChaseNumber)
{
query = query.Where(n => string.IsNullOrEmpty(n.a.AddNumNo));
}
if (ResultType.HasValue)
{
query = query.Where(n => n.a.ResultType == ResultType.Value);
}
var list = (from q in query
select new WS_BetInfoDgv
{
AccountName = q.b.AccountName,
BackMoney = q.a.BackMoney,
BackTime = q.a.BackTime,
BetMoney = q.a.BetMoney,
BetNum = q.a.BetNum,
BetTimes = q.a.BetTimes,
BetUnit = q.a.BetUnit,
ChoicePosition = q.a.ChoicePosition,
CreateTime = q.a.CreateTime,
GetBackPercent = q.a.GetBackPercent,
IsGetBackPercent = q.a.IsGetBackPercent,
Id = q.a.Id,
LotteryExcept = q.a.LotteryExcept,
LotteryId = q.a.LotteryId,
LotteryName = q.c.LotteryName,
PlayName = q.d.LotteryPlayName,
ResultType = q.a.ResultType,
WinMoney = q.a.WinMoney,
WinUnit = q.a.WinUnit,
IsChaseNumber = string.IsNullOrEmpty(q.a.AddNumNo) ? "否" : "是",
}).ToList();
if (list.Count > 0)
{
list.ForEach(n => n.ResultTypeStr = EnumTool.GetBetResultType(n.ResultType));
}
return(list);
}
}