public DataTable SocietyCommissionQuery(CommissionTypeQueryFilter filter, out int totalCount)
{
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("SocietyCommissionQuery");
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = filter.PagingInfo.SortBy,
StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize,
MaximumRows = filter.PagingInfo.PageSize
};
using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(
command.CommandText, command, pagingInfo, "SysNo DESC"))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"SysNo", DbType.Int32,
"@SysNo", QueryConditionOperatorType.Equal,
filter.SysNo);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"OrganizationID", DbType.String,
"@OrganizationID", QueryConditionOperatorType.Like,
filter.OrganizationID);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"OrganizationName", DbType.String,
"@OrganizationName", QueryConditionOperatorType.Like,
filter.OrganizationName);
command.CommandText = builder.BuildQuerySql();
EnumColumnList enumList = new EnumColumnList();
enumList.Add("IsOnlineShow", typeof(HYNStatus));
DataTable dt = command.ExecuteDataTable(enumList);
totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(dt);
}
}
public virtual ECCentral.Service.Utility.WCF.QueryResult QueryCommissionType(CommissionTypeQueryFilter request, out int totalCount)
{
var dataTable = ObjectFactory <ICommissionTypeQueryDA> .Instance.QueryCommissionType(request, out totalCount);
return(new ECCentral.Service.Utility.WCF.QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public QueryResult SocietyCommissionQuery(CommissionTypeQueryFilter request)
{
int totalCount;
var dataTable = ObjectFactory <ICommissionTypeQueryDA> .Instance.SocietyCommissionQuery(request, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public ECCentral.Service.Utility.WCF.QueryResult SocietyCommissionQuery(CommissionTypeQueryFilter request, out int totalCount)
{
totalCount = 0;
return(ObjectFactory <CommissionTypeProcessor> .Instance.SocietyCommissionQuery(request, out totalCount));
}
