/// <summary>
/// 导出商户余额流水记录
/// danny-20150512
/// </summary>
/// <returns></returns>
public ActionResult ExportBusinessBalanceRecord()
{
var criteria = new BusinessBalanceRecordSerchCriteria();
TryUpdateModel(criteria);
var dtBusinessBalanceRecord = iBusinessFinanceProvider.GetBusinessBalanceRecordListForExport(criteria);
if (dtBusinessBalanceRecord != null && dtBusinessBalanceRecord.Count > 0)
{
string filname = "商户提款流水记录{0}.xls";
if (!string.IsNullOrWhiteSpace(criteria.OperateTimeStart))
{
filname = string.Format(filname, criteria.OperateTimeStart + "~" + criteria.OperateTimeEnd);
}
byte[] data = Encoding.UTF8.GetBytes(iBusinessFinanceProvider.CreateBusinessBalanceRecordExcel(dtBusinessBalanceRecord.ToList()));
return(File(data, "application/ms-excel", filname));
}
var businessWithdrawFormModel = iBusinessProvider.GetBusinessDetailById(criteria.BusinessId.ToString());
var criteriaNew = new BusinessBalanceRecordSerchCriteria()
{
BusinessId = Convert.ToInt32(criteria.BusinessId)
};
ViewBag.businessBalanceRecord = iBusinessFinanceProvider.GetBusinessBalanceRecordList(criteriaNew);
return(View("BusinessDetail", businessWithdrawFormModel));
}
public ActionResult PostBusinessBalanceRecord(int pageindex = 1)
{
var criteria = new BusinessBalanceRecordSerchCriteria();
TryUpdateModel(criteria);
ViewBag.businessBalanceRecord = iBusinessFinanceProvider.GetBusinessBalanceRecordListOfPaging(criteria);
return(PartialView("_BusinessBalanceRecordList"));
}
/// <summary>
/// 根据商户Id获取收支记录
/// danny-20150604
/// </summary>
/// <param name="businessId"></param>
/// <returns></returns>
public ActionResult PostGetBusinessBalanceRecordListOfPaging(string businessId)
{
var criteria = new BusinessBalanceRecordSerchCriteria()
{
BusinessId = Convert.ToInt32(businessId)
};
var pagedList = iBusinessFinanceProvider.GetBusinessBalanceRecordListOfPaging(criteria);
return(View(pagedList));
}
/// <summary>
/// 查看商户详细信息
/// danny-20150512
/// </summary>
/// <param name="businessId">商户Id</param>
/// <returns></returns>
public ActionResult BusinessDetail(string businessId)
{
var criteria = new BusinessBalanceRecordSerchCriteria()
{
BusinessId = Convert.ToInt32(businessId)
};
ViewBag.businessBalanceRecord = iBusinessFinanceProvider.GetBusinessBalanceRecordListOfPaging(criteria);
var queryCriteria = new BussinessBalanceQuery();
queryCriteria.BusinessId = businessId;
ViewBag.TotalAmount = statisticsProvider.QueryBusinessTotalAmount(queryCriteria);
var businessWithdrawFormModel = iBusinessProvider.GetBusinessDetailById(businessId);
return(View(businessWithdrawFormModel));
}
/// <summary>
/// 获取商户提款收支记录列表
/// danny-20150512
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public IList <BusinessBalanceRecord> GetBusinessBalanceRecordList(BusinessBalanceRecordSerchCriteria criteria)
{
string sql = @"
SELECT bbr.[Id]
,bbr.[BusinessId]
,bbr.[Amount]
,bbr.[Status]
,bbr.[Balance]
,bbr.[RecordType]
,bbr.[Operator]
,bbr.[OperateTime]
,bbr.[WithwardId]
,bbr.[RelationNo]
,bbr.[Remark]
FROM [BusinessBalanceRecord] bbr WITH(NOLOCK)
WHERE BusinessId=@BusinessId ";
if (criteria.RecordType != 0)
{
sql += @" AND bbr.[RecordType]=@RecordType";
}
if (!string.IsNullOrWhiteSpace(criteria.RelationNo))
{
sql += @" AND bbr.[RelationNo]=@RelationNo";
}
if (!string.IsNullOrWhiteSpace(criteria.OperateTimeStart))
{
sql += @" AND CONVERT(CHAR(10),bbr.OperateTime,120)>=CONVERT(CHAR(10),@OperateTimeStart,120)";
}
if (!string.IsNullOrWhiteSpace(criteria.OperateTimeEnd))
{
sql += @" AND CONVERT(CHAR(10),bbr.OperateTime,120)<=CONVERT(CHAR(10),@OperateTimeEnd,120)";
}
sql += " ORDER BY bbr.Id DESC";
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@BusinessId", criteria.BusinessId);
parm.AddWithValue("@RecordType", criteria.RecordType);
parm.AddWithValue("@RelationNo", criteria.RelationNo);
parm.AddWithValue("@OperateTimeStart", criteria.OperateTimeStart);
parm.AddWithValue("@OperateTimeEnd", criteria.OperateTimeEnd);
DataTable dt = DbHelper.ExecuteDataTable(SuperMan_Read, sql, parm);
return(MapRows <BusinessBalanceRecord>(dt));
}
/// <summary>
/// 获取商户提款收支记录列表分页版
/// danny-20150604
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public PageInfo <T> GetBusinessBalanceRecordListOfPaging <T>(BusinessBalanceRecordSerchCriteria criteria)
{
string columnList = @" bbr.[Id]
,bbr.[BusinessId]
,bbr.[Amount]
,bbr.[Status]
,bbr.[Balance]
,bbr.[RecordType]
,bbr.[Operator]
,bbr.[OperateTime]
,bbr.[WithwardId]
,bbr.[RelationNo]
,bbr.[Remark]";
var sbSqlWhere = new StringBuilder(" 1=1 ");
if (criteria.BusinessId != 0)
{
sbSqlWhere.AppendFormat("AND bbr.[BusinessId]={0}", criteria.BusinessId);
}
if (criteria.RecordType != 0)
{
sbSqlWhere.AppendFormat("AND bbr.[RecordType]={0}", criteria.RecordType);
}
if (!string.IsNullOrWhiteSpace(criteria.RelationNo))
{
sbSqlWhere.AppendFormat("AND bbr.[RelationNo]='{0}'", criteria.RelationNo);
}
if (!string.IsNullOrWhiteSpace(criteria.OperateTimeStart))
{
sbSqlWhere.AppendFormat("AND CONVERT(CHAR(10),bbr.OperateTime,120)>=CONVERT(CHAR(10),'{0}',120)", criteria.OperateTimeStart.Trim());
}
if (!string.IsNullOrWhiteSpace(criteria.OperateTimeEnd))
{
sbSqlWhere.AppendFormat(" AND CONVERT(CHAR(10),bbr.OperateTime,120)<=CONVERT(CHAR(10),'{0}',120)", criteria.OperateTimeEnd.Trim());
}
string tableList = @" [BusinessBalanceRecord] bbr WITH(NOLOCK)";
string orderByColumn = " bbr.Id DESC";
return(new PageHelper().GetPages <T>(SuperMan_Read, criteria.PageIndex, sbSqlWhere.ToString(), orderByColumn, columnList, tableList, criteria.PageSize, true));
}
/// <summary>
/// 查看商户余额流水记录
/// danny-20150512
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public ActionResult BusinessBalanceRecord(BusinessBalanceRecordSerchCriteria criteria)
{
ViewBag.businessBalanceRecord = iBusinessFinanceProvider.GetBusinessBalanceRecordList(criteria);
return(PartialView("_BusinessBalanceRecordList"));
}
/// <summary>
/// 获取商户提款收支记录列表分页版
/// danny-20150604
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public PageInfo <BusinessBalanceRecord> GetBusinessBalanceRecordListOfPaging(BusinessBalanceRecordSerchCriteria criteria)
{
return(businessFinanceDao.GetBusinessBalanceRecordListOfPaging <BusinessBalanceRecord>(criteria));
}
/// <summary>
/// 获取要导出的商户提款收支记录列表
/// danny-20150512
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public IList <BusinessBalanceRecordModel> GetBusinessBalanceRecordListForExport(BusinessBalanceRecordSerchCriteria criteria)
{
return(businessFinanceDao.GetBusinessBalanceRecordListForExport(criteria));
}
