/// <summary> /// 获取要导出的骑士提现申请单 /// danny-20150513 /// </summary> /// <param name="criteria"></param> /// <returns></returns> public IList <ClienterWithdrawFormModel> GetClienterWithdrawForExport(ClienterWithdrawSearchCriteria criteria) { string sql = @" select c.[TrueName] ClienterName, c.PhoneNo ClienterPhoneNo, cwf.OpenBank , cwf.TrueName , cwf.AccountNo , cwf.Amount, cwf.WithdrawTime WithdrawDateStart from ClienterWithdrawForm cwf with(nolock) join clienter c with(nolock) on cwf.ClienterId=c.Id where 1=1"; if (!string.IsNullOrWhiteSpace(criteria.ClienterName)) { sql += " AND c.[TrueName]=@ClienterName"; } if (!string.IsNullOrWhiteSpace(criteria.ClienterPhoneNo)) { sql += " AND c.PhoneNo=@ClienterPhoneNo"; } if (criteria.WithdrawStatus != 0) { sql += " AND cwf.Status=@WithdrawStatus"; } if (!string.IsNullOrWhiteSpace(criteria.WithwardNo)) { sql += " AND cwf.WithwardNo=@WithwardNo"; } if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateStart)) { sql += " AND CONVERT(CHAR(10),cwf.WithdrawTime,120)>=CONVERT(CHAR(10),@WithdrawDateStart,120)"; } if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateEnd)) { sql += " AND CONVERT(CHAR(10),cwf.WithdrawTime,120)<=CONVERT(CHAR(10),@WithdrawDateEnd,120)"; } IDbParameters parm = DbHelper.CreateDbParameters(); parm.AddWithValue("@ClienterName", criteria.ClienterName); parm.AddWithValue("@ClienterPhoneNo", criteria.ClienterPhoneNo); parm.AddWithValue("@WithwardNo", criteria.WithwardNo); parm.AddWithValue("@WithdrawDateStart", criteria.WithdrawDateStart); parm.AddWithValue("@WithdrawDateEnd", criteria.WithdrawDateEnd); parm.AddWithValue("@WithdrawStatus", criteria.WithdrawStatus); DataTable dt = DbHelper.ExecuteDataTable(SuperMan_Read, sql, parm); return(MapRows <ClienterWithdrawFormModel>(dt)); }
/// <summary> /// 根据参数获取骑士提现申请单列表 /// danny-20150513 /// </summary> /// <param name="criteria"></param> /// <returns></returns> public PageInfo <T> GetClienterWithdrawList <T>(ClienterWithdrawSearchCriteria criteria) { string columnList = @" cwf.Id, cwf.WithwardNo, c.[TrueName] ClienterName, c.PhoneNo ClienterPhoneNo, cwf.BalancePrice, cwf.AllowWithdrawPrice, cwf.Amount, cwf.Balance, cwf.Status, cwf.WithdrawTime, cwf.Auditor, cwf.AuditTime, cwf.Payer, cwf.PayTime, cwf.AuditFailedReason, cwf.PayFailedReason "; var sbSqlWhere = new StringBuilder(" 1=1 "); if (!string.IsNullOrWhiteSpace(criteria.ClienterName)) { sbSqlWhere.AppendFormat(" AND c.[TrueName]='{0}' ", criteria.ClienterName.Trim()); } if (!string.IsNullOrWhiteSpace(criteria.ClienterPhoneNo)) { sbSqlWhere.AppendFormat(" AND c.PhoneNo='{0}' ", criteria.ClienterPhoneNo.Trim()); } if (criteria.WithdrawStatus != 0) { sbSqlWhere.AppendFormat(" AND cwf.Status={0} ", criteria.WithdrawStatus); } if (!string.IsNullOrWhiteSpace(criteria.WithwardNo)) { sbSqlWhere.AppendFormat(" AND cwf.WithwardNo='{0}' ", criteria.WithwardNo.Trim()); } if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateStart)) { sbSqlWhere.AppendFormat(" AND CONVERT(CHAR(10),cwf.WithdrawTime,120)>=CONVERT(CHAR(10),'{0}',120) ", criteria.WithdrawDateStart.Trim()); } if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateEnd)) { sbSqlWhere.AppendFormat(" AND CONVERT(CHAR(10),cwf.WithdrawTime,120)<=CONVERT(CHAR(10),'{0}',120) ", criteria.WithdrawDateEnd.Trim()); } string tableList = @" ClienterWithdrawForm cwf with(nolock) join clienter c with(nolock) on cwf.ClienterId=c.Id"; string orderByColumn = " cwf.Id DESC "; return(new PageHelper().GetPages <T>(SuperMan_Read, criteria.PageIndex, sbSqlWhere.ToString(), orderByColumn, columnList, tableList, criteria.PageSize, true)); }
/// <summary> /// 获取要导出的骑士提现申请单 /// danny-20150513 /// </summary> /// <param name="criteria"></param> /// <returns></returns> public IList <ClienterWithdrawFormModel> GetClienterWithdrawForExport(ClienterWithdrawSearchCriteria criteria) { return(clienterFinanceDao.GetClienterWithdrawForExport(criteria)); }
/// <summary> /// 根据参数获取骑士提现申请单列表 /// danny-20150513 /// </summary> /// <param name="criteria"></param> /// <returns></returns> public PageInfo <ClienterWithdrawFormModel> GetClienterWithdrawList(ClienterWithdrawSearchCriteria criteria) { return(clienterFinanceDao.GetClienterWithdrawList <ClienterWithdrawFormModel>(criteria)); }