private void btnSearch_Click(object sender, RoutedEventArgs e) { if (ValidationManager.Validate(this.QuerySection)) { filter = model.ConvertVM <NewsAdvReplyQueryVM, NewsAdvReplyQueryFilter>(); filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <NewsAdvReplyQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); } }
public virtual QueryResult QueryNewsAdvReply(NewsAdvReplyQueryFilter msg) { int totalCount; var dataTable = ObjectFactory <INewsQueryDA> .Instance.QueryNewsAdvReply(msg, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 查询公告及促销评论 /// </summary> /// <param name="callback"></param> public void QueryNewsAdvReply(NewsAdvReplyQueryFilter 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/NewsInfo/QueryNewsAdvReply"; restClient.QueryDynamicData(relativeUrl, filter, callback); }
/// <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 <NewsAdvReplyQueryVM, NewsAdvReplyQueryFilter>(); filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; facade.ExportExcelFile(filterVM, new ColumnSet[] { col }); }
public override void OnPageLoad(object sender, EventArgs e) { facade = new NewsAdvReplyQueryFacade(this); model = new NewsAdvReplyQueryVM(); model.ChannelID = "1"; QuerySection.DataContext = model; filter = new NewsAdvReplyQueryFilter(); model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; showStatus.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.MKT.NewsAdvReplyStatus>(EnumConverter.EnumAppendItemType.All); comIsUploadImage.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.MKT.NYNStatus>(EnumConverter.EnumAppendItemType.All); CodeNamePairHelper.GetList("MKT", "CommentsCategory", CodeNamePairAppendItemType.All, (obj, args) => { if (args.FaultsHandle()) { return; } comCommentCategory.ItemsSource = args.Result; }); facade.GetNewAdvReplyCreateUsers((obj, args) => { if (args.FaultsHandle()) { return; } BizEntity.Common.UserInfo select = new BizEntity.Common.UserInfo(); select.UserID = "0"; select.UserName = ECCentral.BizEntity.Enum.Resources.ResCommonEnum.Enum_All; List <BizEntity.Common.UserInfo> source = args.Result; source.Add(select); lastEditUsers.ItemsSource = source; }); showStatus.SelectedIndex = 0; lastEditUsers.SelectedIndex = 0; comCommentCategory.SelectedIndex = 0; comIsUploadImage.SelectedIndex = 0; base.OnPageLoad(sender, e); }
public void ExportExcelFile(NewsAdvReplyQueryFilter filter, ColumnSet[] columns) { string relativeUrl = "/MKTService/NewsInfo/QueryNewsAdvReply"; restClient.ExportFile(relativeUrl, filter, columns); }
/// <summary> /// 查询公告及促销评论 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryNewsAdvReply(NewsAdvReplyQueryFilter 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("News_QueryNewsAdvReplyList"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "N.SysNo DESC")) { //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID); sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "N.CreateDate", DbType.DateTime, "@CreateDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual, filter.InDateFrom, filter.InDateTo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.CustomerSysNo", DbType.Int32, "@CustomerSysNo", QueryConditionOperatorType.Equal, filter.CustomerSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.LastEditUserSysNo", DbType.Int32, "@LastEditUserSysNo", QueryConditionOperatorType.Like, filter.LastEditUserSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.ReferenceType", DbType.Int32, "@ReferenceType", QueryConditionOperatorType.Equal, filter.ReferenceType); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.ReferenceSysNo", DbType.Int32, "@ReferenceSysNo", QueryConditionOperatorType.Equal, filter.ReferenceSysNo); //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CI.LastEditUserID", DbType.String, "@LastEditUserID", QueryConditionOperatorType.Like, filter.LastEditUserID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SI.DisplayName", DbType.String, "@LastEditUserID", QueryConditionOperatorType.Like, filter.LastEditUserID); if (filter.IsUploadImage != null) { if (filter.IsUploadImage == ECCentral.BizEntity.MKT.NYNStatus.Yes) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "N.Image is not null"); } //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.Image", DbType.Int32, "@Image", QueryConditionOperatorType.IsNotNull, ""); else { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "N.Image is null"); } //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.[Image]", DbType.String, "@Image", filter.IsUploadImage == ECCentral.BizEntity.MKT.NYNStatus.Yes?QueryConditionOperatorType.IsNotNull:QueryConditionOperatorType.IsNull,); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.ReplyContent", DbType.String, "@ReplyContent", QueryConditionOperatorType.Like, filter.ReplyContent); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Like, filter.SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, filter.Status); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList enumList = new EnumColumnList(); enumList.Add("Status", typeof(ECCentral.BizEntity.MKT.NewsAdvReplyStatus)); //前台展示状态 enumList.Add("ReplyHasReplied", typeof(ECCentral.BizEntity.MKT.NYNStatus)); //是否存在回复 CodeNamePairColumnList pairList = new CodeNamePairColumnList(); pairList.Add("ReferenceType", "MKT", "CommentsCategory"); //ReferenceType评论类型 var dt = cmd.ExecuteDataTable(enumList, pairList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); //if (dt != null && dt.Rows.Count > 0) //{ // foreach (DataRow dr in dt.Rows) // { // if (!string.IsNullOrEmpty(dr["Image"].ToString())) // { // dr["Image"] = "http://c3.neweggimages.com.cn/CImages/Promotion/P80/" + dr["Image"].ToString().Replace(",", ",http://c3.neweggimages.com.cn/CImages/Promotion/P80/"); // dr["LinkImage"] = "http://c3.neweggimages.com.cn/CImages/Promotion/Original/" + dr["Image"].ToString().Replace(",", ",http://c3.neweggimages.com.cn/CImages/Promotion/Original/"); // } // } //} return(dt); } }