public override void OnPageLoad(object sender, EventArgs e) { facade = new ProductKeywordsQueryFacade(this); filter = new ProductKeywordsQueryFilter(); model = new ProductKeywordsQueryVM(); model.ChannelID = "1"; model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; comProductStatus.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.IM.ProductStatus>(EnumConverter.EnumAppendItemType.All); this.DataContext = model; facade.GetProductKeywordsEditUserList(Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode, (s, args) => { if (args.FaultsHandle()) { return; } List <UserInfo> userList = args.Result; userList.Insert(0, new UserInfo { SysNo = null, UserName = ResCommonEnum.Enum_All }); comEditUser.ItemsSource = userList; }); base.OnPageLoad(sender, e); }
public virtual QueryResult QueryProductPageKeywords(ProductKeywordsQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <IKeywordQueryDA> .Instance.QueryProductPageKeywords(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 查询产品页面关键字 /// </summary> /// <param name="filter"></param> /// <param name="callback"></param> public void QueryProductPageKeywords(ProductKeywordsQueryFilter 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/KeywordsInfo/QueryProductPageKeywords"; restClient.QueryDynamicData(relativeUrl, filter, callback); }
private void Button_Search_Click(object sender, RoutedEventArgs e) { if (ValidationManager.Validate(this.QuerySection)) { filter = model.ConvertVM <ProductKeywordsQueryVM, ProductKeywordsQueryFilter>(); filter.PropertySysNo = SelectCategoryProperty.CategoryPropertySysNo; filter.PropertyValueSysNo = SelectCategoryProperty.PropertyValueSysNo; filter.InputValue = SelectCategoryProperty.InputValue; filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <ProductKeywordsQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); } }
/// <summary> /// 查询产品页面关键字 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryProductPageKeywords(ProductKeywordsQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); if (filter.PageInfo == null) { pagingEntity = null; } else { pagingEntity.SortField = filter.PageInfo.SortBy; pagingEntity.MaximumRows = filter.PageInfo.PageSize; pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize; } var cmd = DataCommandManager.GetDataCommand("ProductKeywords_QueryProductKeywordsList"); cmd.SetParameterValue("@EditDateTo", filter.EditDateTo); cmd.SetParameterValue("@EditDateFrom", filter.EditDateFrom); cmd.SetParameterValue("@ProductMode", filter.ProductMode); cmd.SetParameterValue("@C1SysNo", filter.Category1SysNo); cmd.SetParameterValue("@C2SysNo", filter.Category2SysNo); cmd.SetParameterValue("@C3SysNo", filter.Category3SysNo); cmd.SetParameterValue("@VendorName", filter.VendorName); cmd.SetParameterValue("@SelectedManufacturerSysNo", filter.SelectedManufacturerSysNo); cmd.SetParameterValue("@Keywords", filter.Keywords); cmd.SetParameterValue("@EditUser", filter.EditUser); cmd.SetParameterValue("@UserSysNo", filter.PMUserSysNo); cmd.SetParameterValue("@ProductID", filter.ProductID); cmd.SetParameterValue("@Status", filter.Status); cmd.SetParameterValue("@PropertyValueSysNo", filter.PropertyValueSysNo); cmd.SetParameterValue("@PropertySysNo", filter.PropertySysNo); cmd.SetParameterValue("@ManualInput", filter.InputValue); cmd.SetParameterValue("@StartNumber", pagingEntity.StartRowIndex); cmd.SetParameterValue("@EndNumber", pagingEntity.StartRowIndex + pagingEntity.MaximumRows); cmd.SetParameterValue("@SortField", pagingEntity.SortField); DataTable dt = new DataTable(); dt = cmd.ExecuteDataTable(); totalCount = (int)cmd.GetParameterValue("@TotalCount"); return(dt); }
/// <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(ResKeywords.Information_ExportFailed); return; } ColumnSet col = new ColumnSet(this.QueryResultGrid); filter = model.ConvertVM <ProductKeywordsQueryVM, ProductKeywordsQueryFilter>(); filter.PropertySysNo = SelectCategoryProperty.CategoryPropertySysNo; filter.PropertyValueSysNo = SelectCategoryProperty.PropertyValueSysNo; filter.InputValue = SelectCategoryProperty.InputValue; filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; facade.ExportExcelFile(filterVM, new ColumnSet[] { col }); }
private void QueryResultGrid_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { if (QueryResultGrid.QueryCriteria == null) { filter = model.ConvertVM <ProductKeywordsQueryVM, ProductKeywordsQueryFilter>(); filter.PropertySysNo = SelectCategoryProperty.CategoryPropertySysNo; filter.PropertyValueSysNo = SelectCategoryProperty.PropertyValueSysNo; filter.InputValue = SelectCategoryProperty.InputValue; filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <ProductKeywordsQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; } if ((QueryResultGrid.QueryCriteria as ProductKeywordsQueryFilter).EditUser == ResCommonEnum.Enum_All) { (QueryResultGrid.QueryCriteria as ProductKeywordsQueryFilter).EditUser = null; } facade.QueryProductPageKeywords(QueryResultGrid.QueryCriteria as ProductKeywordsQueryFilter, e.PageSize, e.PageIndex, e.SortField, (s, args) => { if (args.FaultsHandle()) { return; } gridVM = DynamicConverter <ProductKeywordsQueryVM> .ConvertToVMList <List <ProductKeywordsQueryVM> >(args.Result.Rows); QueryResultGrid.ItemsSource = gridVM; QueryResultGrid.TotalCount = args.Result.TotalCount; if (gridVM != null) { btnBatchAdd.Visibility = Visibility.Visible; btnBatchDelete.Visibility = Visibility.Visible; } else { btnBatchDelete.Visibility = Visibility.Collapsed; btnBatchAdd.Visibility = Visibility.Collapsed; } }); }
public void ExportExcelFile(ProductKeywordsQueryFilter filter, ColumnSet[] columns) { string relativeUrl = "/MKTService/KeywordsInfo/QueryProductPageKeywords"; restClient.ExportFile(relativeUrl, filter, columns); }