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