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