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