/// <summary>
/// 查询某个时间段提现记录
/// </summary>
/// <param name="requeest">参数</param>
public List <FnCashout> GetPeriodTimes(FnCashoutQueryRequest requeest)
{
//测试SQL:SELECT * FROM bssms WHERE CustomerSysNo='15008228718' AND CreatedDate>='2017-11-22 00:00:00' AND CreatedDate<='2017-11-22 23:59:59'
var strSql = string.Format("SELECT * FROM agent_fncashout WHERE CustomerSysNo={0} AND CreatedDate>='{1}' AND CreatedDate<='{2}'", requeest.CustomerSysNo.Value, requeest.StartTime, requeest.EndTime);
var result = DBContext.Sql(strSql)
//.Parameter("CustomerSysNo", requeest.CustomerSysNo.HasValue)
//.Parameter("StartTime", requeest.StartTime)
//.Parameter("EndTime", requeest.EndTime)
.QueryMany <FnCashout>();
return(result);
}
/// <summary>
/// 提现申请查询
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>分部视图</returns>
public JsonResult CashoutLogQuery(FnCashoutQueryRequest request)
{
var list = FnCashoutApp.Instance.GetPagerList(new FnCashoutQueryRequest()
{
CustomerSysNo = CustomerContext.Context.SysNo
});
var data = new
{
Status = true,
Data = list.TData.ToList(),
Count = list.PageSize
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取提现申请分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>提现申请分页列表</returns>
public PagedList <FnCashout> GetPagerList(FnCashoutQueryRequest request)
{
var dataCount = DBContext.Select <int>("count(0)").From("agent_fncashout");
var dataList = DBContext.Select <FnCashout>("*").From("agent_fncashout");
Action <string, string, object> setWhere = (@where, name, value) =>
{
dataCount.AndWhere(where).Parameter(name, value);
dataList.AndWhere(where).Parameter(name, value);
};
if (request.CustomerSysNo.HasValue)
{
setWhere("CustomerSysNo = @CustomerSysNo", "CustomerSysNo", request.CustomerSysNo.Value);
}
return(new PagedList <FnCashout>
{
TData = dataList.Paging(request.CurrentPageIndex.GetHashCode(), request.PageSize.GetHashCode()).OrderBy("SysNo desc").QueryMany(),
CurrentPageIndex = request.CurrentPageIndex.GetHashCode(),
TotalCount = dataCount.QuerySingle()
});
}
/// <summary>
/// 获取提现申请分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>提现申请分页列表</returns>
public PagedList <FnCashout> GetPagerList(FnCashoutQueryRequest request)
{
return(Using <IFnCashout>().GetPagerList(request));
}
/// <summary>
/// 查询某个时间段发送短信数量
/// </summary>
/// <param name="requeest">参数</param>
public List <FnCashout> GetPeriodTimes(FnCashoutQueryRequest requeest)
{
return(Using <IFnCashout>().GetPeriodTimes(requeest));
}
