public virtual QueryResult QueryAdvertiser(AdvertiserQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <IAdvertiserQueryDA> .Instance.QueryAdvertiser(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 查询广告商 /// </summary> /// <param name="filter"></param> /// <param name="callback"></param> public void QueryAdvertiser(AdvertiserQueryFilter 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/QueryAdvertiser"; restClient.QueryDynamicData(relativeUrl, filter, callback); }
private void btnNewItem_Click(object sender, RoutedEventArgs e) { UCAddAdvertisers usercontrol = new UCAddAdvertisers(); usercontrol.Dialog = Window.ShowDialog(ResNewsInfo.Title_CreateAdvertiser, usercontrol, (obj, args) => { filter = model.ConvertVM <AdvertisersQueryVM, AdvertiserQueryFilter>(); filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <AdvertiserQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); }); }
private void Button_Search_Click(object sender, RoutedEventArgs e) { if (model.HasValidationErrors) { return; } filter = model.ConvertVM <AdvertisersQueryVM, AdvertiserQueryFilter>(); filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <AdvertiserQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); }
/// <summary> /// 广告商查询 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryAdvertiser(AdvertiserQueryFilter 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.CreateCustomDataCommandFromConfig("Advertisers_GetAdvertisers"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "SysNo DESC")) { //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "AdvertiserName", DbType.String, "@AdvertiserName", QueryConditionOperatorType.Like, filter.AdvertiserName); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "MonitorCode", DbType.String, "@MonitorCode", QueryConditionOperatorType.Like, filter.MonitorCode); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, filter.Status); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CookiePeriod", DbType.Int32, "@CookiePeriod", QueryConditionOperatorType.Equal, filter.CookiePeriod); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); var dt = cmd.ExecuteDataTable <ECCentral.BizEntity.MKT.ADStatus>("Status"); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); foreach (DataRow dr in dt.Rows) { DateTime dtime = System.Convert.ToDateTime(dr["InDate"].ToString()); string selectDT = dtime.ToString("yyyy-MM-dd"); //dr["EffectLink"] = "http://www.oysd.cn/mkt/queryadveffect.asox?unionid=" + dr["AdvertiserUserName"] + "&pwd=" + dr["AdvertiserPassword"] + "&starttime=" + selectDT + "&endtime=" + selectDT; dr["EffectLink"] = string.Format(AppSettingManager.GetSetting("MKT", "AdvertiserEffectLink") + "?unionid={0}&pwd={1}&starttime={2}&endtime={3}", dr["AdvertiserUserName"].ToString(), dr["AdvertiserPassword"].ToString(), selectDT, selectDT); } return(dt);//.Tables[0]; } }
public override void OnPageLoad(object sender, EventArgs e) { model = new AdvertisersQueryVM(); model.ChannelID = "1"; QuerySection.DataContext = model; btnStackPanel.DataContext = model; filter = new AdvertiserQueryFilter(); filter.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; facade = new AdvertiserFacade(this); cbShowComment.SelectedIndex = 0; Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn status = QueryResultGrid.Columns[4] as Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn; status.Binding.ConverterParameter = typeof(ADStatus); base.OnPageLoad(sender, e); }
/// <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 <AdvertisersQueryVM, AdvertiserQueryFilter>(); 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.ExportExcelFile(filterVM, new ColumnSet[] { col }); }
public void ExportExcelFile(AdvertiserQueryFilter filter, ColumnSet[] columns) { string relativeUrl = "/MKTService/AdvInfo/QueryAdvertiser"; restClient.ExportFile(relativeUrl, filter, columns); }