public QueryResult QueryDeductList(DeductQueryFilter request)
{
int totalCount = 0;
QueryResult returnResult = new QueryResult()
{
Data = ObjectFactory <IDeductQueryDA> .Instance.LoadDeductInfo(request, out totalCount)
};
returnResult.TotalCount = totalCount;
return(returnResult);
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
//构造查询条件
//扣款名称
string name = this.txtName.Text.Trim();
if (name.Length > 200)
{
return;
}
deductQueryVM.Name = this.txtName.Text.Trim();
//构造查询条件
this.queryRequest = EntityConverter <DeductQueryVM, DeductQueryFilter> .Convert(deductQueryVM);
QueryResultGrid.Bind();
}
void dgDeductInfo_LoadingDataSource(object sender, LoadingDataEventArgs e)
{
DeductQueryFilter filter = new DeductQueryFilter()
{
DeductType = DeductType.Temp, Status = Status.Effective
};
serviceFacade.QueryDeducts(filter, (obj, args) =>
{
if (args.FaultsHandle())
{
ItemList = new List <DeductVM>();
return;
}
ItemList = DynamicConverter <DeductVM> .ConvertToVMList(args.Result.Rows);
this.dgDeductInfo.ItemsSource = ItemList;
});
}
/// <summary>
/// 扣款项维护列表
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable LoadDeductInfo(DeductQueryFilter queryFilter, out int totalCount)
{
if (queryFilter == null)
{
totalCount = -1;
return(null);
}
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryDeductList");
if (null != queryFilter.PageInfo.SortBy)
{
if (queryFilter.PageInfo.SortBy.IndexOf("[Status]") > -1)
{
queryFilter.PageInfo.SortBy = "D." + queryFilter.PageInfo.SortBy;
}
}
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = queryFilter.PageInfo.SortBy,
StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize,
MaximumRows = queryFilter.PageInfo.PageSize
};
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, pagingInfo, "Indate DESC"))
{
if (!string.IsNullOrEmpty(queryFilter.Name))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Name",
DbType.String, "@Name", QueryConditionOperatorType.Like, queryFilter.Name);
}
if (queryFilter.DeductType.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "DeductType",
DbType.Int32, "@DeductType", QueryConditionOperatorType.Equal, queryFilter.DeductType.Value);
}
if (queryFilter.AccountType.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "AccountType",
DbType.Int32, "@AccountType", QueryConditionOperatorType.Equal, queryFilter.AccountType.Value);
}
if (queryFilter.DeductMethod.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "DeductMethod",
DbType.Int32, "@DeductMethod", QueryConditionOperatorType.Equal, queryFilter.DeductMethod.Value);
}
if (queryFilter.Status.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "D.Status",
DbType.Int32, "@Status", QueryConditionOperatorType.Equal, queryFilter.Status.Value);
}
command.CommandText = sqlBuilder.BuildQuerySql();
command.SetParameterValue("@StartNumber", queryFilter.PageInfo.PageSize * queryFilter.PageInfo.PageIndex);
command.SetParameterValue("@EndNumber", queryFilter.PageInfo.PageSize * queryFilter.PageInfo.PageIndex + queryFilter.PageInfo.PageSize);
EnumColumnList columnEnums = new EnumColumnList();
columnEnums.Add("DeductType", typeof(DeductType));
columnEnums.Add("AccountType", typeof(AccountType));
columnEnums.Add("DeductMethod", typeof(DeductMethod));
columnEnums.Add("Status", typeof(Status));
DataTable dt = command.ExecuteDataTable(columnEnums);
totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(dt);
}
}
/// <summary>
/// 查询扣款项维护列表
/// </summary>
/// <param name="request"></param>
/// <param name="callback"></param>
public void QueryDeducts(DeductQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "/POService/Deduct/QueryDeductList";
restClient.QueryDynamicData(relativeUrl, request, callback);
}
