public decimal SumTiXian(DateTime?begin, DateTime?end) { decimal sum = 0; string strWhere = ""; if (begin != null && end != null) { strWhere = " createtime >=@begin and createtime <=@end "; } else if (begin == null && end != null) { strWhere = " createtime <=@end "; } else if (begin != null && end == null) { strWhere = " createtime >=@begin "; } else { strWhere = " 1=1 "; } string sql = "select ISNULL(SUM(LogCount),0) from TiXianLog where " + strWhere; using (var db = BaseDal.ReadOnlySanNongDunConn()) { sum = db.DbConnecttion.ExecuteScalar <decimal>(sql, Engineer.ccc, new { begin = begin, end = end }); } return(sum); }
/// <summary> /// 激活卡互转 /// </summary> /// <param name="reUserName"></param> /// <param name="accInfo"></param> /// <param name="reAccInfo"></param> /// <returns></returns> //public bool GiveActivationCard(UserInfo userInfo, UserInfo reUserInfo, AccountInfo accInfo, AccountInfo reAccInfo) //{ // bool isTransaction = false; // using (DbBase dbBase = BaseDal.WriteSanNongDunDbBase()) // { // IDbTransaction dbTransaction = dbBase.DbConnecttion.BeginTransaction(); // isTransaction = UpdateActivationCount(accInfo, dbBase, dbTransaction); // if (!isTransaction) // { // dbTransaction.Rollback(); // return false; // } // isTransaction = UpdateActivationCount(reAccInfo, dbBase, dbTransaction); // if (!isTransaction) // { // dbTransaction.Rollback(); // return false; // } // ActivationTable at = new ActivationTable(); // at.CreateTime = DateTime.Now; // at.UserId = userInfo.UserId; // at.ReUserId = reUserInfo.UserId; // at.Remark = "赠送激活卡"; // at.ReUserName = reUserInfo.UserName; // at.ActivationType = 2; // isTransaction = AddActivTable(at, dbBase, dbTransaction); // if (!isTransaction) // { // dbTransaction.Rollback(); // return false; // } // dbTransaction.Commit(); // } // return isTransaction; //} /// <summary> /// 修改激活卡数量 /// </summary> /// <param name="accInfo"></param> /// <param name="db"></param> /// <param name="dbTransaction"></param> /// <returns></returns> //public bool UpdateActivationCount(AccountInfo accInfo, DbBase db, IDbTransaction dbTransaction) //{ // bool isTrue = false; // try // { // //update AccountInfo set TotalAssets=1,ActivationCount=1 where AccountId= // string sql = "update AccountInfo set ActivationCount=@activationCount where AccountId=@accountId"; // isTrue = db.DbConnecttion.Execute(sql, Engineer.ccc, new { activationCount = accInfo.ActivationCount, accountId = accInfo.AccountId }, dbTransaction) > 0; // } // catch (Exception ex) // { // LogHelper.WriteLog(typeof(UserAccountDal), "UpdateActivationCount", Engineer.ggg, accInfo, ex); // } // return isTrue; //} /// <summary> /// 获取 团队上级 账户信息 /// </summary> /// <param name="p"></param> /// <returns></returns> public UserAccInfoModel GetTeamParentAccInfo(string teamParentId) { UserAccInfoModel userAcc = new UserAccInfoModel(); List <UserAccInfoModel> list = new List <UserAccInfoModel>(); string sql = @"select u.RightId,u.LeftId,u.TeamParentId,u.[level],acc.* from AccountInfo acc inner join UserInfo u on u.UserId = acc.UserId where u.IsActivation=1 and u.UserStatus=1 and (u.LeftId=@teamParentId or u.RightId=@teamParentId)"; try { using (var db = BaseDal.ReadOnlySanNongDunConn()) { list = db.DbConnecttion.Query <UserAccInfoModel>(sql, Engineer.ccc, new { teamParentId = teamParentId }).ToList <UserAccInfoModel>(); if (list.Count > 0) { userAcc = list[0]; } } } catch (Exception ex) { LogHelper.WriteLog(typeof(UserAccountDal), "GetTeamParentUser", Engineer.ggg, teamParentId, ex); } return(userAcc); }
/// <summary> /// /// </summary> /// <param name="userName"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="adminLogType"></param> /// <param name="logType"></param> /// <returns></returns> public Page <UserLogInfoModel> GetPageUserLog(string userName, int pageIndex, int pageSize, int adminLogType, int logType) { string userNameSql = ""; string adminLogTypeSql = ""; if (!string.IsNullOrEmpty(userName)) { userNameSql = " and UserName like @userName"; } if (logType == 1) { adminLogTypeSql = " and AdminLogType = @adminLogType"; } Page <UserLogInfoModel> page = new Page <UserLogInfoModel>(); try { using (var db = BaseDal.ReadOnlySanNongDunConn()) { string sql = string.Format(@" select num,UserId,UserName,RealName,Number,AdminLogType,CreateTime,LogType,Ep,Zfc from (select ROW_NUMBER() over (order by l.CreateTime desc)as num,u.UserId,UserName,RealName,Number,AdminLogType,l.CreateTime,LogType,Ep,Zfc from UserInfo u inner join LogInfo l on u.UserId=l.UserId where UserStatus=1 and IsActivation=1 and LogType = @logType {0} {1} ) as t where t.num between @pageSize * (@pageIndex - 1) + 1 and @pageSize * @pageIndex ", userNameSql, adminLogTypeSql, pageIndex); page.Data = db.DbConnecttion.Query <UserLogInfoModel>(sql, Engineer.ccc, new { userName = "******" + userName + "%", pageIndex = pageIndex, pageSize = pageSize, adminLogType = adminLogType, logType = logType }).ToList(); string sqlCount = string.Format(@"select COUNT(1) from LogInfo l inner join UserInfo u on u.UserId=l.UserId where UserStatus=1 and IsActivation=1 and LogType = @logType {0} {1}", userNameSql, adminLogTypeSql); int totalCount = (int)db.DbConnecttion.ExecuteScalar(sqlCount, new { userName = "******" + userName + "%", adminLogType = adminLogType, logType = logType }); page.TotalCount = totalCount; } } catch (Exception ex) { LogHelper.WriteLog(typeof(LogDal), "GetPageUserLog", Engineer.ccc, new { userName = userName, pageIndex = pageIndex, pageSize = pageSize, adminLogType = adminLogType, logType = logType }, ex); } return(page); }
/// <summary> /// 根据用户id查账户实体 /// sj /// </summary> /// <param name="userId">用户id</param> /// <returns></returns> public RechargeLockCoin GetRechargeLockCoinByLogName(string logName) { RechargeLockCoin data = new RechargeLockCoin(); try { using (var db = BaseDal.ReadOnlySanNongDunConn()) { data = db.Query <RechargeLockCoin>(SqlQuery <RechargeLockCoin> .Builder(db).AndWhere(x => x.LoginName, OperationMethod.Equal, logName)).FirstOrDefault(); } } catch (Exception ex) { LogHelper.WriteError(typeof(RechargeLockCoinDal), ex); data = null; } return(data); }
/// <summary> /// 根据用户id查账户实体 /// sj /// </summary> /// <param name="userId">用户id</param> /// <returns></returns> public LevelInfo GetLevelInfoById(int levelStatus) { LevelInfo data = new LevelInfo(); try { using (var db = BaseDal.ReadOnlySanNongDunConn()) { data = db.Query <LevelInfo>(SqlQuery <LevelInfo> .Builder(db).AndWhere(x => x.LevelStatus, OperationMethod.Equal, levelStatus)).FirstOrDefault(); } } catch (Exception ex) { LogHelper.WriteError(typeof(LevelInfoDal), ex); data = null; } return(data); }
/// <summary> /// 根据Id查询 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public OrderInfo GetOrderByOrderId(int orderId) { OrderInfo data = null; try { using (var db = BaseDal.ReadOnlySanNongDunConn()) { data = db.Query <OrderInfo>(SqlQuery <OrderInfo> .Builder(db).AndWhere(x => x.OrderId, OperationMethod.Equal, orderId)).FirstOrDefault(); } } catch (Exception ex) { LogHelper.WriteLog(typeof(OrderInfoDal), "GetOrderByOrderId", Engineer.ccc, new { orderId = orderId }, ex); data = null; } return(data); }
/// <summary> /// 根据用户id查账户实体 /// sj /// </summary> /// <param name="userId">用户id</param> /// <returns></returns> public Finance GetFinanceByLogName(string logName) { Finance data = new Finance(); try { using (var db = BaseDal.ReadOnlySanNongDunConn()) { data = db.Query <Finance>(SqlQuery <Finance> .Builder(db).AndWhere(x => x.LoginName, OperationMethod.Equal, logName)).FirstOrDefault(); } } catch (Exception ex) { LogHelper.WriteError(typeof(FinanceDal), ex); data = null; } return(data); }
/// <summary> /// 根据用户id查账户实体 /// sj /// </summary> /// <param name="userId">用户id</param> /// <returns></returns> public ComputingPower GetComputingPowerByLogName(string logName) { ComputingPower data = new ComputingPower(); try { using (var db = BaseDal.ReadOnlySanNongDunConn()) { data = db.Query <ComputingPower>(SqlQuery <ComputingPower> .Builder(db).AndWhere(x => x.LoginName, OperationMethod.Equal, logName)).FirstOrDefault(); } } catch (Exception ex) { LogHelper.WriteError(typeof(ComputingPowerDal), ex); data = null; } return(data); }
/// <summary> /// 修改账户 /// sj /// </summary> /// <param name="customerAccount">修改账户实体</param> /// <returns></returns> public bool UpdateRechargeLockCoin(RechargeLockCoin RechargeLockCoin) { bool result = false; try { if (RechargeLockCoin != null) { using (var db = BaseDal.WriteSanNongDunDbBase()) { result = db.Update(RechargeLockCoin); } } } catch (Exception ex) { LogHelper.WriteLog(typeof(RechargeLockCoinDal), "UpdateRechargeLockCoin", Engineer.ccc, RechargeLockCoin, ex); } return(result); }
/// <summary> /// 修改账户 /// sj /// </summary> /// <param name="customerAccount">修改账户实体</param> /// <returns></returns> public bool UpdateGlobalConfig(GlobalConfig gc) { bool result = false; try { if (gc != null) { using (var db = BaseDal.WriteSanNongDunDbBase()) { result = db.Update(gc); } } } catch (Exception ex) { LogHelper.WriteLog(typeof(GlobalConfigDal), "UpdateGlobalConfig", Engineer.ccc, gc, ex); } return(result); }
/// <summary> /// 修改账户 /// sj /// </summary> /// <param name="customerAccount">修改账户实体</param> /// <returns></returns> public bool UpdateLevelInfo(LevelInfo levelInfo) { bool result = false; try { if (levelInfo != null) { using (var db = BaseDal.WriteSanNongDunDbBase()) { result = db.Update(levelInfo); } } } catch (Exception ex) { LogHelper.WriteLog(typeof(LevelInfoDal), "UpdateLevelInfo", Engineer.ccc, levelInfo, ex); } return(result); }
/// <summary> /// 修改账户 /// sj /// </summary> /// <param name="customerAccount">修改账户实体</param> /// <returns></returns> public bool UpdateFinance(Finance Finance) { bool result = false; try { if (Finance != null) { using (var db = BaseDal.WriteSanNongDunDbBase()) { result = db.Update(Finance); } } } catch (Exception ex) { LogHelper.WriteLog(typeof(FinanceDal), "UpdateFinance", Engineer.ccc, Finance, ex); } return(result); }
/// <summary> /// 修改账户 /// sj /// </summary> /// <param name="customerAccount">修改账户实体</param> /// <returns></returns> public bool UpdateComputingPower(ComputingPower computingPower) { bool result = false; try { if (computingPower != null) { using (var db = BaseDal.WriteSanNongDunDbBase()) { result = db.Update(computingPower); } } } catch (Exception ex) { LogHelper.WriteLog(typeof(ComputingPowerDal), "UpdateComputingPower", Engineer.ccc, computingPower, ex); } return(result); }
public bool Insert(ScoreLog scoreLog) { bool isTrue = false; try { using (var db = BaseDal.WriteSanNongDunDbBase()) { isTrue = db.Insert <ScoreLog>(scoreLog); if (!isTrue) { LogHelper.WriteInfo(typeof(ScoreLogDal), "Insert--添加记录失败", Engineer.ccc, scoreLog); } } } catch (Exception ex) { LogHelper.WriteLog(typeof(ScoreLogDal), "Insert", Engineer.ccc, scoreLog, ex); } return(isTrue); }
/// <summary> /// 修改账户总资产 /// </summary> /// <returns></returns> //public bool UpdateTotalAssets(AccountInfo accInfo, DbBase db, IDbTransaction dbTransaction) //{ // bool isTrue = false; // try // { // //update AccountInfo set TotalAssets=1,ActivationCount=1 where AccountId= // string sql = "update AccountInfo set TotalAssets=@totalAssets where AccountId=@accountId"; // isTrue = db.DbConnecttion.Execute(sql, Engineer.ccc, new { totalAssets = accInfo.TotalAssets, accountId = accInfo.AccountId }, dbTransaction) > 0; // } // catch (Exception ex) // { // LogHelper.WriteLog(typeof(UserAccountDal), "UpdateTotalAssets", Engineer.ggg, null, ex); // } // return isTrue; //} /// <summary> /// 激活卡记录 /// </summary> /// <param name="userId"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public Page <ActicationCardExchangeModel> ActivationCardExchange(int userId, int activationType, int pageIndex, int pageSize) { int totalCount = 0; Page <ActicationCardExchangeModel> page = new Page <ActicationCardExchangeModel>(); List <ActicationCardExchangeModel> list = new List <ActicationCardExchangeModel>(); string sql = @" select num,UserId,ReUserName,ReUserId,CreateTime,Remark,ActivationType from(select ROW_NUMBER() over(order by at.CreateTime desc)as num, at.UserId,at.ReUserName,ReUserId,at.CreateTime,at.Remark,at.ActivationType from ActivationTable as at inner join UserInfo as u on at.UserId=u.UserId where u.UserId=@userId and at.ActivationType=@activationType )as t where t.num between @pageSize * (@pageIndex - 1) + 1 and @pageIndex * @pageSize "; string totalSql = @"select ROW_NUMBER() over(order by at.CreateTime desc)as num,at.UserId,at.ReUserName,ReUserId,at.CreateTime from ActivationTable as at inner join UserInfo as u on at.UserId=u.UserId where u.UserStatus=1 and IsActivation=1 and u.UserId=@userId"; using (var db = BaseDal.ReadOnlySanNongDunConn()) { list = db.DbConnecttion.Query <ActicationCardExchangeModel>(sql, Engineer.ccc, new { userId = userId, activationType = activationType, pageIndex = pageIndex, pageSize = pageSize }).ToList <ActicationCardExchangeModel>(); totalCount = db.DbConnecttion.Query <ActicationCardExchangeModel>(totalSql, Engineer.ccc, new { userId = userId }).ToList <ActicationCardExchangeModel>().Count; if (list != null && totalCount > 0) { page.Data = list; page.PageIndex = pageIndex; page.PageSize = pageSize; page.TotalCount = totalCount; page.PageYe = (int)Math.Ceiling(Convert.ToDouble(totalCount) / Convert.ToDouble(pageSize)); } } return(page); }