public List <BannerDimension> GetBannerDimensions(BannerDimensionQueryFilter filter)
{
var cmd = DataCommandManager.GetDataCommand("Banner_GetBannerDimensions");
cmd.SetParameterValue <BannerDimensionQueryFilter>(filter);
return(cmd.ExecuteEntityList <BannerDimension>());
}
public virtual QueryResult QueryBannerDimension(BannerDimensionQueryFilter filter)
{
int totalCount = 0;
var dt = _bannerDimensionQueryDA.Query(filter, out totalCount);
QueryResult queryResult = new QueryResult();
queryResult.Data = dt;
queryResult.TotalCount = totalCount;
return(queryResult);
}
public void QueryDimensions(string companyCode, string channelID, int pageTypeID, EventHandler <RestClientEventArgs <List <BannerDimension> > > callback)
{
BannerDimensionQueryFilter filter = new BannerDimensionQueryFilter
{
CompanyCode = companyCode,
ChannelID = channelID,
PageTypeID = pageTypeID
};
string relativeUrl = "/MKTService/Banner/QueryDimensions";
restClient.Query <List <BannerDimension> >(relativeUrl, filter, callback);
}
public DataTable Query(BannerDimensionQueryFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = filter.PageInfo.SortBy;
pagingEntity.MaximumRows = filter.PageInfo.PageSize;
pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("BannerDimension_QueryBannerDimension");
var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "B.SysNo DESC");
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"B.PageType",
DbType.Int32,
"@PageType",
QueryConditionOperatorType.Equal,
filter.PageTypeID);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"B.PositionID",
DbType.Int32,
"@PositionID",
QueryConditionOperatorType.Equal,
filter.PositionID);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"B.PositionName",
DbType.AnsiStringFixedLength,
"@PositionName",
QueryConditionOperatorType.Like,
filter.PositionName);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"B.CompanyCode",
DbType.AnsiStringFixedLength,
"@CompanyCode",
QueryConditionOperatorType.Equal,
filter.CompanyCode);
cmd.CommandText = sqlBuilder.BuildQuerySql();
var dt = cmd.ExecuteDataTable();
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
public virtual List <BannerDimension> QueryBannerDimensions(BannerDimensionQueryFilter filter)
{
return(ObjectFactory <IBannerQueryDA> .Instance.GetBannerDimensions(filter));
}