public static QueryResult <ProductPriceNotifyInfo> QueryProductPriceNotify(ProducePriceNotifiyQueryFilter filter) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("Customer_QueryProductPriceNotify"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, filter.ConvertToPaging(), "w.[SysNo] DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "w.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "w.CustomerSysNo", DbType.Int32, "@CustomerSysNo", QueryConditionOperatorType.Equal, filter.CustomerSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "w.LanguageCode", DbType.String, "@LanguageCode", QueryConditionOperatorType.Equal, ConstValue.LanguageCode); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "w.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, ConstValue.CompanyCode); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "w.StoreCompanyCode", DbType.String, "@StoreCompanyCode", QueryConditionOperatorType.Equal, ConstValue.StoreCompanyCode); command.CommandText = sqlBuilder.BuildQuerySql(); var newsList = command.ExecuteEntityList <ProductPriceNotifyInfo>(); var totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); QueryResult <ProductPriceNotifyInfo> result = new QueryResult <ProductPriceNotifyInfo>(); result.ResultList = newsList; result.PageInfo = filter.ConvertToPageInfo(totalCount); return(result); } }
public static QueryResult <ProductPriceNotifyInfo> QueryProductPriceNotify(ProducePriceNotifiyQueryFilter filter) { return(ProductPriceNotifyDA.QueryProductPriceNotify(filter)); }