/// <summary>
///
/// </summary>
/// <param name="orderNO"></param>
/// <param name="pay_status">0：未支付 1：成功 2:失败</param>
/// <param name="paydatetime"></param>
/// <returns></returns>
public bool DonePayRecord(string orderNO, int pay_status, string paydatetime, int payType)
{
using (e = new LotteryAPPEntities())
{
using (var tran = new TransactionScope())
{
var f = e.Pay_Record.FirstOrDefault(n => n.orderNO == orderNO && n.pay_status == 0);//1
if (f == null)
{
return(false);
}
if (f.pay_status != 0)
{
return(false);
}
var flag = false;
f.paydatetime = paydatetime;
f.pay_status = pay_status;
f.payType = payType;
var ar = e.AccountRecharge.FirstOrDefault(n => n.OrderNo == orderNO);//2
if (ar == null)
{
return(false);
}
ar.Type = payType.ToString();
ar.Status = pay_status;
if (pay_status == 1)
{
var account = e.Accounts.FirstOrDefault(n => n.Id == f.userId);//3
if (account == null)
{
return(false);
}
var ab = new AccountBusiness
{
AccountId = account.Id,
BusinessTypeId = (int)Enum_AccountBusinessType.Recharge,
CreateTime = EntitiesTool.GetDateTimeNow(e),
EventId = ar.Id,
PayBefore = account.AccountBalance,
PayIn = f.orderAmount / 100,
PayAfter = account.AccountBalance + f.orderAmount / 100,
};
account.AccountBalance = ab.PayAfter;
e.AccountBusiness.Add(ab);//4.投注业务单
var add = e.SaveChanges();
flag = add == 4;
}
else
{
flag = e.SaveChanges() == 2;
}
if (flag)
{
tran.Complete();
}
return(flag);
}
}
}
public Accounts GetAccount(int AccountId)
{
using (e = new LotteryAPPEntities())
{
return(e.Accounts.FirstOrDefault(n => n.Id == AccountId));
}
}
public bool EditAccountRegInfoSet(AccountRegInfoSet info)
{
using (e = new LotteryAPPEntities())
{
var s = e.AccountRegInfoSet.FirstOrDefault(n => n.Id == info.Id);
if (s == null)
{
return(false);
}
var acc = e.Accounts.FirstOrDefault(n => n.Id == s.AccountId);
if (acc == null)
{
return(false);
}
if (info.AgentPercent11X5 > acc.AgentPercent11X5)
{
return(false);
}
if (info.AgentPercentDPC > acc.AgentPercentDPC)
{
return(false);
}
if (info.AgentPercentSSC > acc.AgentPercentSSC)
{
return(false);
}
s.AgentPercent11X5 = info.AgentPercent11X5;
s.AgentPercentDPC = info.AgentPercentDPC;
s.AgentPercentSSC = info.AgentPercentSSC;
return(e.SaveChanges() == 1);
}
}
public bool IsExistsLoginName(string loginName)
{
using (e = new LotteryAPPEntities())
{
return(e.Accounts.FirstOrDefault(n => n.AccountName == loginName) != null);
}
}
public BankCard GetBankCard(int AccountId, string cardNo)
{
using (e = new LotteryAPPEntities())
{
return(e.BankCard.FirstOrDefault(n => n.AccountId == AccountId && n.CardNo == cardNo));
}
}
public List <BankCard> GetBankCard(int AccountId)
{
using (e = new LotteryAPPEntities())
{
return(e.BankCard.Where(n => n.AccountId == AccountId).ToList());
}
}
public void Add(List <LotteryOpenInfo> Info)
{
using (e = new LotteryAPPEntities())
{
using (tran = new TransactionScope())
{
try
{
var lId = Info[0].LotteryId;
var query = e.LotteryOpenInfo.Where(n => n.LotteryId == lId).Select(n => n.Expect).ToList();
var query1 = Info.Where(n => !query.Contains(n.Expect)).ToList();//如果期号不存在
if (query1.Count > 0)
{
e.LotteryOpenInfo.AddRange(query1);
}
var query2 = e.LotteryOpenInfo.Where(n => n.LotteryId == lId && n.OpenCode == "").ToList();//更新期号存在且号码为空的开奖信息
foreach (var item in query2)
{
var f = Info.FirstOrDefault(n => n.Expect == item.Expect);
if (f != null && !string.IsNullOrEmpty(f.OpenCode))
{
item.OpenCode = f.OpenCode;
item.OpenTime = f.OpenTime;
}
}
e.SaveChanges();
tran.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
}
}
/// <summary>
/// 账户充值
/// </summary>
/// <param name="AccountId"></param>
/// <param name="Type"></param>
/// <param name="Money"></param>
public void Recharge(int AccountId, string Type, decimal Money, string OrderNo)
{
using (e = new LotteryAPPEntities())
{
var dt = EntitiesTool.GetDateTimeNow(e);
var account = e.Accounts.FirstOrDefault(n => n.Id == AccountId);
var no = e.AccountRecharge.Count(n => n.AccountId == AccountId) + 1;
using (var tran = new TransactionScope())
{
var o = new AccountRecharge
{
AccountId = AccountId,
CreateTime = dt,
Money = Money,
OrderNo = OrderNo,
Type = Type,
Remarks = "",
};
e.AccountRecharge.Add(o);
var ab = new AccountBusiness
{
AccountId = AccountId,
BusinessTypeId = (int)Enum_AccountBusinessType.Recharge,
CreateTime = dt,
PayBefore = account.AccountBalance,
PayIn = Money,
PayAfter = account.AccountBalance + Money,
};
e.AccountBusiness.Add(ab);//充值业务单
account.AccountBalance = ab.PayAfter;
e.SaveChanges();
tran.Complete();
}
}
}
public AccountWithdraw GetAccountWithdraw(string OrderNo)
{
using (e = new LotteryAPPEntities())
{
return(e.AccountWithdraw.FirstOrDefault(n => n.OrderNo == OrderNo));
}
}
/// <summary>
/// 获取特定已开奖期数
/// </summary>
/// <returns></returns>
public List <LotteryOpenInfo> LastOpen_Count(int count, int LotteryId)
{
using (e = new LotteryAPPEntities())
{
var query = e.LotteryOpenInfo.Where(n => n.LotteryId == LotteryId && n.OpenCode != "").OrderByDescending(n => n.OpenTime).Take(count).ToList();
return(query);
}
}
public List <Accounts> LoginOnTest(string Name)
{
using (e = new LotteryAPPEntities())
{
var account = e.Accounts.Where(n => n.AccountName.Contains(Name)).ToList();
return(account);
}
}
/// <summary>
/// 返回所有注册信息
/// </summary>
/// <param name="AccountId"></param>
/// <returns></returns>
public List <AccountRegInfoSet> GetAccountRegInfoSetList(int AccountId)
{
using (e = new LotteryAPPEntities())
{
var query = e.AccountRegInfoSet.Where(n => n.AccountId == AccountId).ToList();
return(query);
}
}
public LotteryOffcialSchedule NextOpenNo(int LotteryId)
{
using (e = new LotteryAPPEntities())
{
var dt = EntitiesTool.GetDateTimeNow(e);
return(e.LotteryOffcialSchedule.Where(n => LotteryId == n.LotteryId && n.ScheduleOpenTime > dt).OrderBy(n => n.ScheduleOpenTime).FirstOrDefault());
}
}
public bool IsExistsOpenCardNo(int AccountId, string CardNo)
{
using (e = new LotteryAPPEntities())
{
var c = e.BankCard.FirstOrDefault(n => n.AccountId == AccountId && n.CardNo == CardNo);
return(c != null);
}
}
/// <summary>
/// 锁定银行卡
/// </summary>
/// <param name="AccountId"></param>
public void LockBankCard(int AccountId)
{
using (e = new LotteryAPPEntities())
{
var a = e.Accounts.FirstOrDefault(n => n.Id == AccountId);
a.BankCardLockStatus = true;
e.SaveChanges();
}
}
/// <summary>
/// 获取准备开奖期号
/// </summary>
/// <returns></returns>
public LotteryOpenInfo NextOpenNo(int LotteryId)
{
using (e = new LotteryAPPEntities())
{
var dt = EntitiesTool.GetDateTimeNow(e);
var query = e.LotteryOpenInfo.Where(n => n.LotteryId == LotteryId && n.OpenTime > dt).FirstOrDefault();
return(query);
}
}
/// <summary>
/// 单日提现次数
/// </summary>
/// <param name="AccountId"></param>
/// <returns></returns>
public int TodayWithdrawCount(int AccountId)
{
using (e = new LotteryAPPEntities())
{
var dt = EntitiesTool.GetDateTimeNow(e).Date;
var dt1 = dt.AddDays(1);
return(e.AccountWithdraw.Count(n => n.AccountId == AccountId && n.CreateTime >= dt && n.CreateTime < dt1));
}
}
/// <summary>
/// 注册下级
/// </summary>
public void RegChildAccount(Accounts Account)
{
using (e = new LotteryAPPEntities())
{
Account.CreateTime = EntitiesTool.GetDateTimeNow(e);
e.Accounts.Add(Account);
e.SaveChanges();
}
}
/// <summary>
/// 绑定银行卡
/// </summary>
/// <param name="BankCard"></param>
public void BindBankCard(BankCard BankCard)
{
using (e = new LotteryAPPEntities())
{
BankCard.CreatTime = EntitiesTool.GetDateTimeNow(e);
BankCard.No = e.BankCard.Count(n => n.AccountId == BankCard.AccountId) + 1;
e.BankCard.Add(BankCard);
e.SaveChanges();
}
}
public List <AccountWithdraw> GetAccountWithdrawByDate(int AccountId, DateTime dtStart, DateTime dtEnd)
{
using (e = new LotteryAPPEntities())
{
dtStart = dtStart.Date;
dtEnd = dtEnd.Date.AddDays(1);
var query = e.AccountWithdraw.Where(n => n.AccountId == AccountId && n.CreateTime >= dtStart && n.CreateTime < dtEnd).ToList();
return(query);
}
}
/// <summary>
/// 获取指定数量的预开奖信息
/// </summary>
/// <param name="LotteryId"></param>
/// <param name="Count"></param>
/// <returns></returns>
public List <LotteryOffcialSchedule> GetLotteryOffcialScheduleList(int LotteryId, int Count)
{
using (e = new LotteryAPPEntities())
{
var dt = EntitiesTool.GetDateTimeNow(e);
var query = e.LotteryOffcialSchedule.Where(n => n.LotteryId == LotteryId && n.ScheduleOpenTime > dt).Take(Count).ToList();
//query.ForEach(n => n.ScheduleOpenCode = "");
return(query);
}
}
public static List <Cities> GetCitiesList()
{
if (CitiesList.Count == 0)
{
using (e = new LotteryAPPEntities())
{
CitiesList = e.Cities.ToList();
}
}
return(CitiesList);
}
public static List <Provinces> GetProvincesList()
{
if (ProvincesList.Count == 0)
{
using (e = new LotteryAPPEntities())
{
ProvincesList = e.Provinces.ToList();
}
}
return(ProvincesList);
}
/// <summary>
/// 新增注册链接Id
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool AddAccountRegInfoSet(AccountRegInfoSet info)
{
using (e = new LotteryAPPEntities())
{
info.No = e.AccountRegInfoSet.Count(n => n.AccountId == info.AccountId) + 1;
if (info.No > 3)
{
return(false);
}
e.AccountRegInfoSet.Add(info);
return(e.SaveChanges() == 1);
}
}
public List <LotteryOffcialSchedule> NextOpenNo(List <int> LotteryId)
{
using (e = new LotteryAPPEntities())
{
var dt = EntitiesTool.GetDateTimeNow(e);
var query = new List <LotteryOffcialSchedule>();
foreach (var item in LotteryId)
{
query.Add(e.LotteryOffcialSchedule.Where(n => item == n.LotteryId && n.ScheduleOpenTime > dt).OrderBy(n => n.ScheduleOpenTime).FirstOrDefault());
}
return(query);
}
}
/// <summary>
/// 获取上一期号码
/// </summary>
/// <returns></returns>
public LotteryOpenInfo LastOpenNo(int LotteryId)
{
using (e = new LotteryAPPEntities())
{
var dt = EntitiesTool.GetDateTimeNow(e);
var query = e.LotteryOpenInfo.Where(n => n.LotteryId == LotteryId && n.OpenTime <= dt).OrderByDescending(n => n.OpenTime).FirstOrDefault(); //获取已开奖的最后一期
if (query == null) //如果没有已开奖期号
{
query = e.LotteryOpenInfo.Where(n => n.LotteryId == LotteryId && n.OpenTime > dt).FirstOrDefault(); //获取第一期
}
return(query);
}
}
/// <summary>
/// 链接注册下级用户
/// </summary>
/// <returns></returns>
public bool RegAccountBySet(int AccountRegInfoSetId, string Name, string Pwd, string MoneyPwd, string NickName, string Email)
{
using (e = new LotteryAPPEntities())
{
if (e.Accounts.FirstOrDefault(n => n.AccountName == Name) != null)
{
return(false);
}
var s = e.AccountRegInfoSet.FirstOrDefault(n => n.Id == AccountRegInfoSetId);
var account = new Accounts
{
AccountMoneyPwd = MoneyPwd,
AccountName = Name,
AccountPwd = Pwd,
AccountNickname = NickName,
Email = Email,
//AgentPercent11X5 = s.AgentPercent11X5,
//AgentPercentDPC = s.AgentPercentDPC,
//AgentPercentSSC = s.AgentPercentSSC,
//AccountParentId = s.AccountId,
CreateTime = EntitiesTool.GetDateTimeNow(e),
AccountStatus = (int)Enum_AccountStatus.Normal,
};
if (s != null)
{
var acc = e.Accounts.FirstOrDefault(n => n.Id == s.AccountId);
if (acc != null)
{
if (s.AgentPercent11X5 > acc.AgentPercent11X5)
{
return(false);
}
if (s.AgentPercentDPC > acc.AgentPercentDPC)
{
return(false);
}
if (s.AgentPercentSSC > acc.AgentPercentSSC)
{
return(false);
}
account.AgentPercent11X5 = s.AgentPercent11X5;
account.AgentPercentDPC = s.AgentPercentDPC;
account.AgentPercentSSC = s.AgentPercentSSC;
account.AccountParentId = s.AccountId;
}
}
e.Accounts.Add(account);
return(e.SaveChanges() == 1);
}
}
public bool EditMoneyPwd(int AccountId, string Opwd, string Npwd)
{
using (e = new LotteryAPPEntities())
{
var a = e.Accounts.FirstOrDefault(n => n.Id == AccountId && n.AccountMoneyPwd == Opwd);
if (a == null)
{
return(false);
}
a.AccountMoneyPwd = Npwd;
e.SaveChanges();
return(true);
}
}
public bool EditNickName(int AccountId, string NickName)
{
using (e = new LotteryAPPEntities())
{
var a = e.Accounts.FirstOrDefault(n => n.Id == AccountId);
if (a == null)
{
return(false);
}
a.AccountNickname = NickName;
e.SaveChanges();
return(true);
}
}
/// <summary>
/// 检查同一用户名
/// </summary>
/// <param name="AccountId"></param>
/// <param name="Name"></param>
/// <returns></returns>
public bool IsExistsOpenCardName(int AccountId, string Name)
{
using (e = new LotteryAPPEntities())
{
var c = e.BankCard.FirstOrDefault(n => n.AccountId == AccountId);
if (c == null)
{
return(true);
}
else
{
return(c.OpenCardName == Name);
}
}
}
