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