/// <summary>
/// 功能:获取分页Sql语句
/// </summary>
/// <param name="strSql">读取数据sql</param>
/// <param name="pageInfoParam">分页对象</param>
/// <returns>分页Sql</returns>
public static string GetPageSql(string strSql, PageInfoParam pageInfoParam)
{
string strOrderBy = "";
if (null == pageInfoParam.SortInfo || pageInfoParam.SortInfo.Count == 0)
{
strOrderBy = pageInfoParam.SortField + " " + (pageInfoParam.SortDirection ? "asc " : "desc ");
}
else
{
int intCount = 0;
StringBuilder sbTemp = new StringBuilder();
pageInfoParam.SortInfo.Any(si =>
{
if (intCount > 0)
{
sbTemp.Append(",");
}
sbTemp.Append(si.Key);
sbTemp.Append(" ");
sbTemp.Append(si.Value ? "asc " : "desc ");
intCount++;
return(false);
});
strOrderBy = sbTemp.ToString();
}
return(s_dbDataSource.GetPageSql(strSql, pageInfoParam.PageIndex, pageInfoParam.PageSize, strOrderBy));
}
/// <summary>
/// 功能:获取分页数据
/// </summary>
/// <typeparam name="T1">数据类型1</typeparam>
/// <param name="cmdText">查询命令(原始语句)</param>
/// <param name="parames">命令参数</param>
/// <param name="cmdType">命令类型</param>
/// <param name="dbTrans">事物对象</param>
/// <returns>列表数据</returns>
public static Tuple <List <T1>, long> GetOrmPageData <T1>(string cmdText, PageInfoParam pageInfo, CommandType cmdType = CommandType.Text, object parames = null, IDbTransaction dbTrans = null)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append(GetPageSql(cmdText, pageInfo).ToString());
sbSql.Append(";");
sbSql.Append(GetCountSql(cmdText).ToString());
return(s_dbDataSource.GetOrmPageData <T1>(sbSql.ToString(), cmdType, parames, dbTrans));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static Task <FeedBackResponse <IList <TAutoTransfer> > > GetTautoTransferInfoByMerchantCodeAsync(string merchantCode, PageInfoParam pageInfo, int?status, string endPontName = "")
{
return(CallMethodAsync(x => x.GetTautoTransferInfoByMerchantCodeAsync(merchantCode, pageInfo, status), endPontName));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public Task <FeedBackResponse <IList <TAutoTransfer> > > GetTautoTransferInfoByMerchantCodeAsync(string merchantCode, PageInfoParam pageInfo, int?status)
{
return(this.Channel.GetTautoTransferInfoByMerchantCodeAsync(merchantCode, pageInfo, status));
}
/// <summary>
/// 功能:获取分页Sql语句
/// </summary>
/// <param name="strSql">读取数据sql</param>
/// <param name="pageInfoParam">分页对象</param>
/// <returns>分页Sql</returns>
public static string GetPageSql <T>(string strSql, PageInfoParam <T> pageInfoParam)
{
return(s_dbDataSource.GetPageSql(strSql, pageInfoParam.PageIndex, pageInfoParam.PageSize, pageInfoParam.SortField + " " + (pageInfoParam.SortDirection ? "asc " : "desc")));
}
/// <summary>
/// 功能描述:获得代付订单列表
/// </summary>
/// <param name="merchantCode">商户号</param>
/// <param name="pageInfo">分页信息</param>
/// <param name="status">订单状态</param>
/// <returns></returns>
public FeedBackResponse <IList <TAutoTransfer> > GetTautoTransferInfoByMerchantCode(string merchantCode, PageInfoParam pageInfo, int?status = null)
{
return(OrderServiceHelper.GetTautoTransferInfoByMerchantCode(merchantCode, pageInfo, status));
}
/// <summary>
/// 功能描述:获取代付订单列表
/// </summary>
/// <param name="merchantCode">商户号</param>
/// <param name="pageInfo">分页信息</param>
/// <param name="status">订单状态</param>
/// <returns></returns>
public static FeedBackResponse <IList <TAutoTransfer> > GetTautoTransferInfoByMerchantCode(string merchantCode, PageInfoParam pageInfo, int?status = null)
{
var fbrReturn = new FeedBackResponse <IList <TAutoTransfer> >();
var strSqlBase = new StringBuilder(200);
var strSqlCout = new StringBuilder(200);
//参数字典
var parames = new Dictionary <string, object>();
strSqlBase.Append("SELECT FId,FMerchantCode,FMerchantOrderNumber,FMerchantAddTime,FAmount,FStatus,FHolders,FBankName,FCardNo,FOrderNumber,FAddTime from tautotransfer where FMerchantCode=@FMerchantCode");
strSqlCout.Append("select count(1) from tautotransfer where FMerchantCode=@FMerchantCode");
parames.Add("FMerchantCode", merchantCode);
if (null != status)
{
strSqlBase.Append(" and FStatus=@FStatus");
strSqlCout.Append(" and FStatus=@FStatus");
parames.Add("FStatus", status.Value);
}
var sql = new StringBuilder(DBDataSourceHelper.GetPageSql(strSqlBase.ToString(), pageInfo));
sql.Append(";");
sql.Append(strSqlCout);
var data = DBDataSourceHelper.GetOrmPageData <TAutoTransfer>(sql.ToString(), parames: parames);
fbrReturn.ResultData = data.Item1;
fbrReturn.TotalCount = data.Item2;
return(fbrReturn);
}