/// <summary>
/// 请求服务，并将查询结果绑定到DataGrid
/// </summary>
void DataGrid_LoadingDataSource(object sender, LoadingDataEventArgs e)
{
filter = viewModel.ConvertVM <CustomerGiftQueryVM, CustomerGiftQueryFilter>();
filter.PagingInfo = new PagingInfo
{
PageIndex = e.PageIndex,
PageSize = e.PageSize,
SortBy = e.SortField
};
_facade.Query(filter, (s, args) =>
{
if (args.FaultsHandle())
{
return;
}
this.DataGrid.TotalCount = args.Result.TotalCount;
_rows = DynamicConverter <CustomerGiftListVM> .ConvertToVMList(args.Result.Rows);
this.DataGrid.ItemsSource = _rows;
if (_checkBoxAll != null)
{
//重新查询后，将全选CheckBox置为false
_checkBoxAll.IsChecked = false;
}
});
}
public virtual QueryResult QueryGift(CustomerGiftQueryFilter msg)
{
int totalCount;
var dataTable = ObjectFactory <IGiftQueryDA> .Instance.Query(msg, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public virtual DataTable Query(CustomerGiftQueryFilter queryEntity, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = queryEntity.PagingInfo.SortBy;
pagingEntity.MaximumRows = queryEntity.PagingInfo.PageSize;
pagingEntity.StartRowIndex = queryEntity.PagingInfo.PageIndex * queryEntity.PagingInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("Gift_Query");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "gift.SysNo DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"customer.CustomerID", DbType.String, "@CustomerID",
QueryConditionOperatorType.Equal, queryEntity.CustomerID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"gift.Quantity", DbType.Int32, "@Quantity",
QueryConditionOperatorType.Equal, queryEntity.ProductQty);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"gift.Status", DbType.Int32, "@Status",
QueryConditionOperatorType.Equal, queryEntity.Status);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"gift.CreateDate", DbType.DateTime, "@CreateDateFrom",
QueryConditionOperatorType.MoreThanOrEqual,
queryEntity.CreateDateFrom);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"gift.CreateDate", DbType.DateTime, "@CreateDateTo",
QueryConditionOperatorType.LessThan,
queryEntity.CreateDateTo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"product.ProductID", DbType.String, "@ProductID",
QueryConditionOperatorType.Equal, queryEntity.ProductID);
cmd.CommandText = sqlBuilder.BuildQuerySql();
DataTable dt = cmd.ExecuteDataTable();
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public void Query(CustomerGiftQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "/CustomerService/Gift/Query";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
