public IEnumerable<DotPay.ViewModel.VirtualCoinWithdrawListModel> GetVirtualCoinWithdrawBySearch(int? userID, CurrencyType currencyType, VirtualCoinTxState state, int page, int pageCount) { var paramters = new object[] { userID.HasValue ? userID.Value : 0, (int)state, (page - 1) * pageCount, pageCount }; var users = this.Context.Sql(getVirtualCoinWithdraw_Sql.FormatWith(currencyType.ToString())) .Parameters(paramters) .QueryMany<VirtualCoinWithdrawListModel>(); return users; }
public ActionResult GetWithdrawCountBySearch(int? userID,CurrencyType currencyType, VirtualCoinTxState state) { var count = IoC.Resolve<IWithdrawQuery>().CountVirtualCoinWithdrawBySearch(userID,currencyType, state); return Json(count); }
public int CountVirtualCoinWithdrawBySearch(int?userID, CurrencyType currencyType, VirtualCoinTxState state) { var paramters = new object[] { userID.HasValue ? userID.Value : 0, (int)state }; return this.Context.Sql(getVirtualCoinWithdrawCount_Sql.FormatWith(currencyType.ToString())) .Parameters(paramters) .QuerySingle<int>(); }
public ActionResult GetWithdrawBySearch(int? userID,CurrencyType currencyType, VirtualCoinTxState state, int page) { var currencies = IoC.Resolve<IWithdrawQuery>().GetVirtualCoinWithdrawBySearch(userID,currencyType, state, page, Constants.DEFAULT_PAGE_COUNT); return Json(currencies); }