public IEnumerable<DotPay.ViewModel.VirtualCurrencyDepositInListModel> GetVirtualCurrencyDepositBySearch(int? userID, DateTime? starttime, DateTime? endtime, CurrencyType currency, DepositState state, int page, int pageCount) { var paramters = new object[] { userID.HasValue ? userID.Value : 0, starttime.HasValue ? starttime.Value.ToUnixTimestamp() : 0, endtime.HasValue ? endtime.Value.ToUnixTimestamp() : 0, (int)state, (page - 1) * pageCount, pageCount }; var users = this.Context.Sql(depositVirtualCurrency_Sql.FormatWith(currency.ToString())) .Parameters(paramters) .QueryMany<VirtualCurrencyDepositInListModel>(); return users; }
public int CountVirtualCurrencyDepositBySearch(int? userID, DateTime? starttime, DateTime? endtime, CurrencyType currency, DepositState state) { var paramters = new object[] { (userID.HasValue ? userID.Value : 0), starttime.HasValue ? starttime.Value.ToUnixTimestamp() : 0, endtime.HasValue ? endtime.Value.ToUnixTimestamp() : 0, (int)state }; return this.Context.Sql(countdepositVirtualCurrency_Sql.FormatWith(currency.ToString())) .Parameters(paramters) .QuerySingle<int>(); }
public ActionResult GetVirtualCurrencyDepositBySearch(int? userID, DateTime? starttime, DateTime? endtime, CurrencyType currency, DepositState state, int page) { var users = IoC.Resolve<IDepositQuery>().GetVirtualCurrencyDepositBySearch(userID, starttime, endtime, currency, state, page, Constants.DEFAULT_PAGE_COUNT); return Json(users); }
/***********************************************************/ public int CountReceivePayMentTransactionBySearch(CurrencyType currency, DepositState state) { var paramters = new object[] { (int)state }; return this.Context.Sql(countReceivePayMentTransactionBySearch_Sql.FormatWith(currency.ToString())) .Parameters(paramters) .QuerySingle<int>(); }
public ActionResult CountVirtualCurrencyDepositBySearch(int? userID, DateTime? starttime, DateTime? endtime, CurrencyType currency, DepositState state) { var count = IoC.Resolve<IDepositQuery>().CountVirtualCurrencyDepositBySearch(userID, starttime, endtime, currency, state); return Json(count); }