/// <summary>
/// 根据query获取兑现申请信息
/// </summary>
/// <returns></returns>
public DataTable GetCommissionToCashByQuery(CommissionToCashQueryFilter query, out int TotalCount)
{
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetCommissionToCashByQuery");
var pagingInfo = new PagingInfoEntity
{
SortField = query.PageInfo.SortBy,
StartRowIndex = query.PageInfo.PageIndex * query.PageInfo.PageSize,
MaximumRows = query.PageInfo.PageSize
};
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingInfo, "cashRecord.SysNo desc"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "userInfo.CustomerID",
DbType.String, "@CustomerID", QueryConditionOperatorType.LeftLike, query.CustomerID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cashRecord.InDate",
DbType.DateTime, "@RequestDateFrom", QueryConditionOperatorType.MoreThanOrEqual, query.ApplicationDateFrom);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cashRecord.InDate",
DbType.DateTime, "@RequestDateTo", QueryConditionOperatorType.LessThanOrEqual, query.ApplicationDateTo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cashRecord.Status",
DbType.AnsiStringFixedLength, "@Status", QueryConditionOperatorType.Equal, query.Status);
cmd.CommandText = sqlBuilder.BuildQuerySql();
}
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(8, typeof(ToCashStatus));
TotalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
public QueryResult GetCommissionToCashByQuery(CommissionToCashQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <ICommissionToCashDA> .Instance.GetCommissionToCashByQuery(query, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 获取申请信息
/// </summary>
/// <param name="model"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void GetCommissionToCashByQuery(CommissionToCashQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string GetCommissionToCashByQueryUrl = "ExternalSYSService/CommissionToCash/GetCommissionToCashByQuery";
CommissionToCashQueryFilter query = ConvertQuery(model);
query.PageInfo = new QueryFilter.Common.PagingInfo()
{
PageIndex = PageIndex,
PageSize = PageSize,
SortBy = SortField
};
restClient.QueryDynamicData(GetCommissionToCashByQueryUrl, query, callback);
}
