/// <summary> /// 查询商品支付方式 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryProductPayType(ProductPayTypeQueryFilter filter, out int totalCount) { var pagingEntity = new PagingInfoEntity { SortField = filter.PageInfo.SortBy, MaximumRows = filter.PageInfo.PageSize, StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize }; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ProductPayType_GetProductPayTypeList"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "pdp.SysNo DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pdp.ProductSysNo", DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, filter.ProductSysNo); var minDateTime = DateTime.MinValue; if (filter.BeginDateFrom.HasValue && filter.BeginDateFrom.Value.Date != minDateTime) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pdp.BeginDate", DbType.DateTime, "@BeginDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.BeginDateFrom); } if (filter.BeginDateTo.HasValue && filter.BeginDateTo.Value.Date != minDateTime) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pdp.BeginDate", DbType.DateTime, "@BeginDateTo", QueryConditionOperatorType.LessThanOrEqual, filter.BeginDateTo); } if (filter.EndDateFrom.HasValue && filter.EndDateFrom.Value.Date != minDateTime) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pdp.EndDate", DbType.DateTime, "@EndDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.EndDateFrom); } if (filter.EndDateTo.HasValue && filter.EndDateTo.Value.Date != minDateTime) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pdp.EndDate", DbType.DateTime, "@EndDateTo", QueryConditionOperatorType.LessThanOrEqual, filter.EndDateTo); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pdp.PayTypeSysNo", DbType.String, "@PayTypeSysNo", QueryConditionOperatorType.Equal, filter.PayTypeSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pdp.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, filter.Status); cmd.CommandText = sqlBuilder.BuildQuerySql(); var ds = cmd.ExecuteDataSet(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(ds.Tables[0]); } }
public override void OnPageLoad(object sender, System.EventArgs e) { base.OnPageLoad(sender, e); _facade = new ProductPayTypeFacade(this); _filter = new ProductPayTypeQueryFilter(); _model = new ProductPayTypeQueryVM(); DataContext = _model; cbPayTypeStatus.ItemsSource = EnumConverter.GetKeyValuePairs <PayTypeStatus>(EnumConverter.EnumAppendItemType.All); }
public virtual QueryResult QueryProductPayType(ProductPayTypeQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <IProductPayTypeQueryDA> .Instance.QueryProductPayType(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
private void btnProductPayTypeSearch_Click(object sender, RoutedEventArgs e) { if (ValidationManager.Validate(QuerySection)) { if (dpBeginDateFrom.SelectedDateTime.HasValue && dpBeginDateTo.SelectedDateTime.HasValue && dpBeginDateFrom.SelectedDateTime.Value.CompareTo(dpBeginDateTo.SelectedDateTime.Value) > 0) { CPApplication.Current.CurrentPage.Context.Window.MessageBox.Show(ResProductPayTypeQuery.Error_BeginDateMoreEndDate, MessageBoxType.Warning); return; } if (dpEndDateFrom.SelectedDateTime.HasValue && dpEndDateTo.SelectedDateTime.HasValue && dpEndDateFrom.SelectedDateTime.Value.CompareTo(dpEndDateTo.SelectedDateTime.Value) > 0) { CPApplication.Current.CurrentPage.Context.Window.MessageBox.Show(ResProductPayTypeQuery.Error_BeginDateMoreEndDate, MessageBoxType.Warning); return; } _filter = _model.ConvertVM <ProductPayTypeQueryVM, ProductPayTypeQueryFilter>(); dgPayTypeQueryResult.QueryCriteria = _filter; dgPayTypeQueryResult.Bind(); } }
/// <summary> /// 查询商品支付方式 /// </summary> /// <param name="filter">查询条件</param> /// <param name="callback">回调函数</param> public void QueryProductPayType(ProductPayTypeQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback) { _restClient.QueryDynamicData(QueryProductPayTypeRelativeUrl, filter, callback); }