public virtual QueryResult QueryBusinessCooperation(BusinessCooperationQueryFilter filter) { int totalCount; var dt = ObjectFactory <IGroupBuyingQueryDA> .Instance.QueryBusinessCooperation(filter, out totalCount); return(new QueryResult() { Data = dt, TotalCount = totalCount }); }
public DataTable QueryBusinessCooperation(BusinessCooperationQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = filter.PagingInfo.SortBy; pagingEntity.MaximumRows = filter.PagingInfo.PageSize; pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryBusinessCooperation"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "m.SysNo DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.Type", DbType.Int32, "@Type", QueryConditionOperatorType.Equal, filter.GroupBuyingType); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.VendorName", DbType.String, "@VendorName", QueryConditionOperatorType.Like, filter.VendorName); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.ContactTel", DbType.String, "@ContactTel", QueryConditionOperatorType.Like, filter.Telephone); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.AreaSysNo", DbType.String, "@AreaSysNo", QueryConditionOperatorType.Equal, filter.AreaSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.CreateDate", DbType.DateTime, "@CreateDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.CreateDateFrom); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.CreateDate", DbType.DateTime, "@CreateDateTo", QueryConditionOperatorType.LessThanOrEqual, filter.CreateDateTo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, filter.Status); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.EditDate", DbType.DateTime, "@HandleDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.HandleDateFrom); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.EditDate", DbType.DateTime, "@HandleDateTo", QueryConditionOperatorType.LessThanOrEqual, filter.HandleDateTo); sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "m.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); var cnList = new CodeNamePairColumnList(); cnList.Add("Type", "MKT", "GroupBuyingTypeList"); var dt = cmd.ExecuteDataTable(new EnumColumnList { { "Status", typeof(BusinessCooperationStatus) } }, cnList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }