public DataTable QuerySettlement(GroupBuyingSettlementQueryFilter 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("QueryGroupBuyingSettlement"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "m.SysNo DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.SysNo", DbType.String, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo); 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.SettleDate", DbType.DateTime, "@SettleDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.SettleDateDateFrom); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.SettleDate", DbType.DateTime, "@SettleDateTo", QueryConditionOperatorType.LessThanOrEqual, filter.SettleDateDateTo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, filter.Status); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "FPM.Status", DbType.Int32, "@PayItemStatus", QueryConditionOperatorType.Equal, filter.PayItemStatus); sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "m.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); var dt = cmd.ExecuteDataTable(new EnumColumnList { { "Status", typeof(SettlementBillStatus) }, { "PayItemStatus", typeof(PayItemStatus) } }); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public virtual QueryResult QuerySettlement(GroupBuyingSettlementQueryFilter filter) { int totalCount; var dt = ObjectFactory <IGroupBuyingQueryDA> .Instance.QuerySettlement(filter, out totalCount); return(new QueryResult() { Data = dt, TotalCount = totalCount }); }