public ActionResult PostBusinessWithdraw(int pageindex = 1)
{
ViewBag.openCityList = iAreaProvider.GetOpenCityOfSingleCity(0);
var criteria = new BusinessWithdrawSearchCriteria();
TryUpdateModel(criteria);
var pagedList = iBusinessFinanceProvider.GetBusinessWithdrawList(criteria);
return(PartialView("_BusinessWithdrawList", pagedList));
}
/// <summary>
/// 获取要导出的商户提现申请单
/// danny-20150512
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public IList <BusinessWithdrawFormModel> GetBusinessWithdrawForExport(BusinessWithdrawSearchCriteria criteria)
{
string sql = @"
select b.[Name] BusinessName,
b.PhoneNo BusinessPhoneNo,
bwf.OpenBank ,
bwf.TrueName ,
bwf.AccountNo ,
bwf.Amount
from BusinessWithdrawForm bwf with(nolock)
join business b with(nolock) on bwf.BusinessId=b.Id
where 1=1";
if (!string.IsNullOrWhiteSpace(criteria.BusinessName))
{
sql += " AND b.[Name]=@BusinessName";
}
if (!string.IsNullOrWhiteSpace(criteria.BusinessPhoneNo))
{
sql += " AND b.PhoneNo=@BusinessPhoneNo";
}
if (!string.IsNullOrWhiteSpace(criteria.BusinessCity))
{
sql += " AND b.City=@BusinessCity";
}
if (criteria.WithdrawStatus != 0)
{
sql += " AND bwf.Status=@WithdrawStatus";
}
if (!string.IsNullOrWhiteSpace(criteria.WithwardNo))
{
sql += " AND bwf.WithwardNo=@WithwardNo";
}
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateStart))
{
sql += " AND CONVERT(CHAR(10),bwf.WithdrawTime,120)>=CONVERT(CHAR(10),@WithdrawDateStart,120)";
}
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateEnd))
{
sql += " AND CONVERT(CHAR(10),bwf.WithdrawTime,120)<=CONVERT(CHAR(10),@WithdrawDateEnd,120)";
}
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@BusinessName", criteria.BusinessName);
parm.AddWithValue("@BusinessPhoneNo", criteria.BusinessPhoneNo);
parm.AddWithValue("@WithwardNo", criteria.WithwardNo);
parm.AddWithValue("@WithdrawDateStart", criteria.WithdrawDateStart);
parm.AddWithValue("@WithdrawDateEnd", criteria.WithdrawDateEnd);
parm.AddWithValue("@WithdrawStatus", criteria.WithdrawStatus);
parm.AddWithValue("@BusinessCity", criteria.BusinessCity);
DataTable dt = DbHelper.ExecuteDataTable(SuperMan_Read, sql, parm);
return(MapRows <BusinessWithdrawFormModel>(dt));
}
/// <summary>
/// 根据参数获取商家提现申请单列表
/// danny-20150509
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public PageInfo <T> GetBusinessWithdrawList <T>(BusinessWithdrawSearchCriteria criteria)
{
string columnList = @" bwf.Id,
bwf.WithwardNo,
b.[Name] BusinessName,
b.PhoneNo BusinessPhoneNo,
bwf.BalancePrice,
bwf.AllowWithdrawPrice,
bwf.Amount,
bwf.Balance,
bwf.Status,
bwf.WithdrawTime,
bwf.Auditor,
bwf.AuditTime,
bwf.Payer,
bwf.PayTime,
bwf.AuditFailedReason,
bwf.PayFailedReason ";
var sbSqlWhere = new StringBuilder(" 1=1 ");
if (!string.IsNullOrWhiteSpace(criteria.BusinessName))
{
sbSqlWhere.AppendFormat(" AND b.[Name]='{0}' ", criteria.BusinessName.Trim());
}
if (!string.IsNullOrWhiteSpace(criteria.BusinessPhoneNo))
{
sbSqlWhere.AppendFormat(" AND b.PhoneNo='{0}' ", criteria.BusinessPhoneNo.Trim());
}
if (!string.IsNullOrWhiteSpace(criteria.BusinessCity))
{
sbSqlWhere.AppendFormat(" AND b.City='{0}' ", criteria.BusinessCity.Trim());
}
if (criteria.WithdrawStatus != 0)
{
sbSqlWhere.AppendFormat(" AND bwf.Status={0} ", criteria.WithdrawStatus);
}
if (!string.IsNullOrWhiteSpace(criteria.WithwardNo))
{
sbSqlWhere.AppendFormat(" AND bwf.WithwardNo='{0}' ", criteria.WithwardNo.Trim());
}
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateStart))
{
sbSqlWhere.AppendFormat(" AND CONVERT(CHAR(10),bwf.WithdrawTime,120)>=CONVERT(CHAR(10),'{0}',120) ", criteria.WithdrawDateStart.Trim());
}
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateEnd))
{
sbSqlWhere.AppendFormat(" AND CONVERT(CHAR(10),bwf.WithdrawTime,120)<=CONVERT(CHAR(10),'{0}',120) ", criteria.WithdrawDateEnd.Trim());
}
string tableList = @" BusinessWithdrawForm bwf with(nolock)
join business b with(nolock) on bwf.BusinessId=b.Id";
string orderByColumn = " bwf.Id DESC ";
return(new PageHelper().GetPages <T>(SuperMan_Read, criteria.PageIndex, sbSqlWhere.ToString(), orderByColumn, columnList, tableList, criteria.PageSize, true));
}
/// <summary>
/// 加载默认商户提款单列表
/// danny-20150511
/// </summary>
/// <returns></returns>
public ActionResult BusinessWithdraw()
{
ViewBag.openCityList = iAreaProvider.GetOpenCityOfSingleCity(0);
var criteria = new BusinessWithdrawSearchCriteria()
{
WithdrawStatus = 0
};
var pagedList = iBusinessFinanceProvider.GetBusinessWithdrawList(criteria);
return(View(pagedList));
}
/// <summary>
/// 导出商户提款申请单列表
/// danny-20150512
/// </summary>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public ActionResult ExportBusinessWithdrawForm(int pageindex = 1)
{
var criteria = new BusinessWithdrawSearchCriteria();
TryUpdateModel(criteria);
var dtBusinessWithdraw = iBusinessFinanceProvider.GetBusinessWithdrawForExport(criteria);
if (dtBusinessWithdraw != null && dtBusinessWithdraw.Count > 0)
{
string filname = "商户提款申请单{0}.xls";
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateStart))
{
filname = string.Format(filname, criteria.WithdrawDateStart + "~" + criteria.WithdrawDateEnd);
}
byte[] data = Encoding.UTF8.GetBytes(iBusinessFinanceProvider.CreateBusinessWithdrawFormExcel(dtBusinessWithdraw.ToList()));
return(File(data, "application/ms-excel", filname));
}
ViewBag.openCityList = iAreaProvider.GetOpenCityOfSingleCity(0);
var pagedList = iBusinessFinanceProvider.GetBusinessWithdrawList(criteria);
return(View("BusinessWithdraw", pagedList));
}
/// <summary>
/// 根据参数获取商家提现申请单列表
/// danny-20150509
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public PageInfo <BusinessWithdrawFormModel> GetBusinessWithdrawList(BusinessWithdrawSearchCriteria criteria)
{
return(businessFinanceDao.GetBusinessWithdrawList <BusinessWithdrawFormModel>(criteria));
}
/// <summary>
/// 获取要导出的商户提现申请单
/// danny-20150512
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public IList <BusinessWithdrawFormModel> GetBusinessWithdrawForExport(BusinessWithdrawSearchCriteria criteria)
{
return(businessFinanceDao.GetBusinessWithdrawForExport(criteria));
}
