/// <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);
}
