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