public static QueryResult <ProductNotifyInfo> QueryProductNotify(ProduceNotifiyQueryFilter filter) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("Customer_QueryProductNotify"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, filter.ConvertToPaging(), "pnr.[SysNo] DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pnr.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pnr.CustomerSysNo", DbType.Int32, "@CustomerSysNo", QueryConditionOperatorType.Equal, filter.CustomerSysNo); command.CommandText = sqlBuilder.BuildQuerySql(); var newsList = command.ExecuteEntityList <ProductNotifyInfo>(); var totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); QueryResult <ProductNotifyInfo> result = new QueryResult <ProductNotifyInfo>(); result.ResultList = newsList; result.PageInfo = filter.ConvertToPageInfo(totalCount); return(result); } }
public static QueryResult <ProductNotifyInfo> QueryProductNotify(ProduceNotifiyQueryFilter filter) { return(ProductNotifyDA.QueryProductNotify(filter)); }