public Account SJ(Account account, Site site)
{
if (account.grade == AccountGrade.Member || account.grade == AccountGrade.Manager)
{
//通过积分升级
if (account.presentExp >= site.ThreePoint)
{
account.grade = AccountGrade.GoldMedalManager;
}
else if (account.presentExp >= site.TwoPoint)
{
account.grade = AccountGrade.Manager;
}
//通过人数升级
if (account.grade == AccountGrade.Member || account.grade == AccountGrade.Manager)
{
string sql = @"select COUNT(t.tatol) as tatol from (
select userId, COUNT(1) as tatol from fz_Orders where userId in (select userId from fz_Accounts where salerId=@accountId) and amount>@amount and isFirs=1 and orderState in (2,3,4,8) group by userId) t
";
var total = _databaseInstance.ExecuteScalar(sql, new { accountId = account.accountId, amount = site.minAmount });
if (total != null)
{
if (int.Parse(total.ToString()) >= site.ThreePeople)
{
account.grade = AccountGrade.GoldMedalManager;
}
else if (int.Parse(total.ToString()) >= site.TwoPeople)
{
account.grade = AccountGrade.Manager;
}
}
}
}
return(account);
}
public decimal GetSummary(int ownerId)
{
var sql = @"select sum(amount) from CashDealLogs where ownerId = @ownerId";
var value = _databaseInstance.ExecuteScalar(sql, new { ownerId = ownerId });
return(System.Convert.ToDecimal(System.Convert.IsDBNull(value) ? 0m : value));
}
public int RecommendCount(string UserName)
{
string sql = "select count(*) from fz_RecommendLogs where salerName=@salerName";
var item = _databaseInstance.ExecuteScalar(sql, new { salerName = UserName }).ToString();
int count = 0;
int.TryParse(item, out count);
return(count);
}
public decimal GetUserIdPoint(int userId)
{
string sql = string.Format("select sum(point) as point from fz_Withdraws where userId=@userId and state in ({0},{1})", WithdrawStates.notaudit, WithdrawStates.success);
var point = _databaseInstance.ExecuteScalar(sql, new { userId = userId }).ToString();
if (!string.IsNullOrWhiteSpace(point))
{
return(decimal.Parse(point));
}
return(0);
}
public int GetSalerCount(int accountId)
{
int total = 0;
string sql = "select COUNT(1) as total from fz_Accounts where salerId=@salerId and grade in (0,2,3)";
var count = _databaseInstance.ExecuteScalar(sql, new { salerId = accountId }).ToString();
if (!string.IsNullOrWhiteSpace(count))
{
int.TryParse(count, out total);
}
return(total);
}
public string GetOrderSerialnumber()
{
string sql = @"select isnull(max(substring(Orderid,11,5))+1,1) from Orders
where substring(Orderid,2,8)is null or substring(Orderid,2,8)=Convert(varchar(10),Getdate(),112)";
int num = (int)_databaseInstance.ExecuteScalar(sql, null);
string snoTemp = num.ToString();
for (int i = 0; i < 5 - num.ToString().Length; i++)
{
snoTemp = "0" + snoTemp;
}
return(snoTemp);
}
public int OrderDetailCount(string OrderNo)
{
string sql = "select count(*) from fz_OrderDetails where orderNo=@orderNo";
object value = _databaseInstance.ExecuteScalar(sql, new { orderNo = OrderNo }).ToString();
int count = 0;
if (value == null)
{
return(count);
}
int.TryParse(value.ToString(), out count);
return(count);
}
public object QueryIdentity()
{
string sql = "select @@identity";
return(_databaseInstance.ExecuteScalar(sql, null));
}
public object ExecuteScalar(CommandType commandType, string commandText)
{
return(Invoke(() => DatabaseInstance.ExecuteScalar(commandType, commandText)));
}
public object ExecuteScalar(string storedProcedureName, params object[] parameterValues)
{
return(Invoke(() => DatabaseInstance.ExecuteScalar(storedProcedureName, parameterValues)));
}
public object ExecuteScalar(DbCommand command)
{
return(Invoke(() => DatabaseInstance.ExecuteScalar(command)));
}
public decimal SumNoLiquidate(int shopId)
{
var sql = "select sum(amount) from DealLogs where state <> 3 and dealtype in (1,4,8) and LiquidateDealLogId = 0 and shopId = @shopId";
return((decimal)(_databaseInstance.ExecuteScalar(sql, new { shopId = shopId }) ?? 0m));
}
