/// <summary> /// 广告效果BBS查询 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryAdvEffectBBS(AdvEffectBBSQueryFilter 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("AdvEffectMonitor_GetAdvBBSList"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "B.UserID DESC")) { //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID); if (filter.InDateFrom.HasValue && filter.InDateTo.HasValue && filter.InDateFrom.Equals(filter.InDateTo)) { filter.InDateTo = filter.InDateTo.Value.AddDays(1); } //sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "A.ClickDate", DbType.DateTime, "@ClickDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual, filter.InDateFrom, filter.InDateTo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.ClickDate", DbType.DateTime, "@ClickDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.InDateFrom); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.ClickDate", DbType.DateTime, "@ClickDateTo", QueryConditionOperatorType.LessThan, filter.InDateTo); cmd.CommandText = sqlBuilder.BuildQuerySql(); var ds = cmd.ExecuteDataSet(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(ds.Tables[0]); } }
public virtual QueryResult QueryAdvEffectBBS(AdvEffectBBSQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <IAdvertiserQueryDA> .Instance.QueryAdvEffectBBS(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
private void Button_Search_Click(object sender, RoutedEventArgs e) { if (ValidationManager.Validate(this.QuerySection)) { filter = model.ConvertVM <AdvEffectBBSVM, AdvEffectBBSQueryFilter>(); filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <AdvEffectBBSQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); } }
public override void OnPageLoad(object sender, EventArgs e) { model = new AdvEffectBBSVM(); model.ChannelID = "1"; QuerySection.DataContext = model; facade = new AdvEffectMonitorFacade(this); filter = new AdvEffectBBSQueryFilter(); model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; base.OnPageLoad(sender, e); }
/// <summary> /// 查询广告效果所涉及的价钱总计 /// </summary> /// <param name="filter"></param> /// <param name="callback"></param> //public void QueryAdvEffectToltalPrice(AdvEffectQueryFilter filter, EventHandler<RestClientEventArgs<dynamic>> callback) //{ // string relativeUrl = "/MKTService/AdvInfo/QueryAdvEffectToltalPrice"; // restClient.QueryDynamicData(relativeUrl, filter, callback); //} /// <summary> /// 查询广告效果BBS推广 /// </summary> /// <param name="filter"></param> /// <param name="callback"></param> public void QueryAdvEffectBBS(AdvEffectBBSQueryFilter filter, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; string relativeUrl = "/MKTService/AdvInfo/QueryAdvEffectBBS"; restClient.QueryDynamicData(relativeUrl, filter, callback); }
private void btnBBSClickReport_Click(object sender, RoutedEventArgs e) { if (filterVM == null || this.QueryResultGrid.TotalCount < 1) { Window.Alert(ResNewsInfo.Information_ExportFailed); return; } ColumnSet col = new ColumnSet(this.QueryResultGrid); filter = model.ConvertVM <AdvEffectBBSVM, AdvEffectBBSQueryFilter>(); filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; facade.ExportEffectBBSExcelFile(filter, new ColumnSet[] { col }); }
/// <summary> /// 数据全部导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void QueryResultGrid_ExportAllClick(object sender, EventArgs e) { if (filterVM == null || this.QueryResultGrid.TotalCount < 1) { Window.Alert(ResNewsInfo.Information_ExportFailed); return; } ColumnSet col = new ColumnSet(this.QueryResultGrid); filter = model.ConvertVM <AdvEffectBBSVM, AdvEffectBBSQueryFilter>(); filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; //col.Insert(0, "ProductId", ResRMAReports.Excel_ProductID, 20) .SetWidth("ProductName", 30); facade.ExportEffectBBSExcelFile(filterVM, new ColumnSet[] { col }); }
public void ExportEffectBBSExcelFile(AdvEffectBBSQueryFilter filter, ColumnSet[] columns) { string relativeUrl = "/MKTService/AdvInfo/QueryAdvEffectBBS"; restClient.ExportFile(relativeUrl, filter, columns); }