/// <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);
}
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="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>
/// 修改账户总资产
/// </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);
}
