/// <summary> ///查询SEO信息 /// </summary> /// <param name="callback"></param> public void SEOQuery(SEOQueryFilter 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/SEOInfo/QuerySEO"; restClient.QueryDynamicData(relativeUrl, filter, callback); }
public override void OnPageLoad(object sender, EventArgs e) { filter = new SEOQueryFilter(); _queryVM = new SEOMetadataQueryVM(); _queryVM.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; _queryVM.ChannelID = "1"; QuerySection.DataContext = _queryVM; btnStackPanel.DataContext = _queryVM; facade = new SEOFacade(this); cbNewsCategory.ItemsSource = EnumConverter.GetKeyValuePairs <ADStatus>(EnumConverter.EnumAppendItemType.All); base.OnPageLoad(sender, e); }
private void OnMaintainDialogResult(object sender, ResultEventArgs args) { if (args.DialogResult == DialogResultType.OK) { filter = _queryVM.ConvertVM <SEOMetadataQueryVM, SEOQueryFilter>(); filter.PageType = ucPageType.PageType; filter.PageID = ucPageType.PageID; filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <SEOQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); } }
/// <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 = _queryVM.ConvertVM <SEOMetadataQueryVM, SEOQueryFilter>(); filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; facade.ExportExcelFile(filterVM, new ColumnSet[] { col }); }
private void Button_Search_Click(object sender, RoutedEventArgs e) { if (lstChannel.SelectedValue == null) { Window.Alert(ResNewsInfo.Information_SelectTheChannel, MessageType.Error); } else { if (ValidationManager.Validate(this.QuerySection)) { filter = _queryVM.ConvertVM <SEOMetadataQueryVM, SEOQueryFilter>(); filter.PageType = ucPageType.PageType; filter.PageID = ucPageType.PageID; filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <SEOQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); } } }
public DataTable QuerySEO(SEOQueryFilter 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("SEO_GetSEODataList"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "B.SysNo DESC")) { //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID); if (filter.PageID == 1 || filter.PageID == 2 || filter.PageID == 3) { sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "C3.C1Sysno", DbType.Int32, "@PageID", QueryConditionOperatorType.Equal, filter.PageID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "C3.C2Sysno", DbType.Int32, "@PageID", QueryConditionOperatorType.Equal, filter.PageID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "C3.C3Sysno", DbType.Int32, "@PageID", QueryConditionOperatorType.Equal, filter.PageID); sqlBuilder.ConditionConstructor.EndGroupCondition(); } else { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "cm.PageID", DbType.Int32, "@PageID", QueryConditionOperatorType.Equal, filter.PageID); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cm.PageType", DbType.Int32, "@PageType", QueryConditionOperatorType.Equal, filter.PageType); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cm.PageTitle", DbType.String, "@PageTitle", QueryConditionOperatorType.Like, filter.PageTitle); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cm.PageDescription", DbType.String, "@PageDescription", QueryConditionOperatorType.Like, filter.PageDescription); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cm.PageKeywords", DbType.String, "@PageKeywords", QueryConditionOperatorType.Like, filter.PageKeywords); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cm.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cm.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, filter.Status); cmd.CommandText = sqlBuilder.BuildQuerySql(); var dt = cmd.ExecuteDataTable <ECCentral.BizEntity.MKT.ADStatus>("Status"); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public virtual QueryResult QuerySEO(SEOQueryFilter filter) { int totalCount; DataTable dataTable = ObjectFactory <ISEOQueryDA> .Instance.QuerySEO(filter, out totalCount); List <CodeNamePair> pair = ObjectFactory <PageTypeAppService> .Instance.GetPageType(filter.CompanyCode, filter.ChannelID.ToString(), ModuleType.SEO); //foreach (DataRow dr in dataTable.Rows) //{ // foreach (CodeNamePair p in pair) // { // if (dr["PageType"].ToString() == p.Code) // { // PageResult pr = ObjectFactory<PageTypeAppService>.Instance.GetPage(filter.CompanyCode, filter.ChannelID.ToString(), ModuleType.SEO, p.Code); // if(pr.PageList!=null && pr.PageList.Count>0) // dr["PageIDName"] = pr.PageList[0].PageName; // dr["PageTypeName"] = p.Name; // //还需要转换页面名称 // } // } //} foreach (DataRow dr in dataTable.Rows) { SEOItem item = new SEOItem(); item.PageType = int.Parse(dr["PageType"].ToString()); item.PageID = int.Parse(dr["PageID"].ToString()); item.CompanyCode = dr["CompanyCode"].ToString(); foreach (CodeNamePair p in pair) { if (dr["PageType"].ToString() == p.Code) { dr["PageTypeName"] = p.Name; } } switch (int.Parse(dr["PageType"].ToString())) { case 1: dr["PageIDName"] = seoItemAppService.GetCNameFromCategory1(item); break; case 2: dr["PageIDName"] = seoItemAppService.GetCNameFromCategory2(item); break; case 3: dr["PageIDName"] = seoItemAppService.GetCNameFromCategory3(item); break; case 4: dr["PageIDName"] = seoItemAppService.GetBrandName(item); break; case 5: dr["PageIDName"] = seoItemAppService.GetSaleAdvertisement(item); break; case 9: dr["PageIDName"] = seoItemAppService.GetBrandNameSpe(item); break; case 29: dr["PageIDName"] = seoItemAppService.GetVendorName(item); break; } } return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
public void ExportExcelFile(SEOQueryFilter filter, ColumnSet[] columns) { string relativeUrl = "/MKTService/SEOInfo/QuerySEO"; restClient.ExportFile(relativeUrl, filter, columns); }