private void Button_Search_Click(object sender, RoutedEventArgs e) { if (ValidationManager.Validate(this.QuerySection)) { filter = model.ConvertVM <ProductConsultQueryVM, ProductConsultQueryFilter>(); filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <ProductConsultQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); } }
public virtual QueryResult QueryProductConsult(ProductConsultQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <ICommentQueryDA> .Instance.QueryProductConsult(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 查询咨询管理 /// </summary> /// <param name="callback"></param> public void QueryProductConsult(ProductConsultQueryFilter 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/CommentInfo/QueryProductConsult"; 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(ResComment.Information_ExportFailed); return; } ColumnSet col = new ColumnSet(this.QueryResultGrid); filter = model.ConvertVM <ProductConsultQueryVM, ProductConsultQueryFilter>(); filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; facade.ExportExcelFile(filterVM, new ColumnSet[] { col }); }
public ActionResult AjaxQuery() { ProductConsultQueryFilter queryCriteria = BuildQueryFilterEntity <ProductConsultQueryFilter>(); queryCriteria.SortFields = "ProductSysNo"; int?currentSellerSysNo = null; int currentSellerSysNoValue = UserAuthHelper.GetCurrentUser().SellerSysNo; if (currentSellerSysNoValue > 0) { currentSellerSysNo = currentSellerSysNoValue; } queryCriteria.SellerSysNo = currentSellerSysNo; QueryResult <ProductConsultQueryBasicInfo> result = ProductConsultService.QueryProductConsultBasicInfoList(queryCriteria); return(AjaxGridJson(result)); }
public void ExportExcelFile(ProductConsultQueryFilter filter, ColumnSet[] columns) { string relativeUrl = "/MKTService/CommentInfo/QueryProductConsult"; restClient.ExportFile(relativeUrl, filter, columns); }
/// <summary> /// Query查询 /// </summary> /// <param name="queryCriteria"></param> /// <returns></returns> public static QueryResult <ProductConsultQueryBasicInfo> QueryProductConsultBasicInfoList(ProductConsultQueryFilter queryCriteria) { int totalCount = 0; QueryResult <ProductConsultQueryBasicInfo> result = new QueryResult <ProductConsultQueryBasicInfo>(); List <ProductConsultQueryBasicInfo> list = ProductConsultDA.QueryProductConsultBasicInfoList(queryCriteria, out totalCount); result.ResultList = list; result.PageInfo = new PageInfo { PageIndex = queryCriteria.PageIndex, PageSize = queryCriteria.PageSize, TotalCount = totalCount, }; return(result); }
/// <summary> /// 产品咨询查询 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public static List <ProductConsultQueryBasicInfo> QueryProductConsultBasicInfoList(ProductConsultQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = filter.SortFields; pagingEntity.MaximumRows = filter.PageSize; pagingEntity.StartRowIndex = filter.PageIndex * filter.PageSize; CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("ProductConsult_GetProductConsultDetailList"); using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingEntity, string.IsNullOrEmpty(pagingEntity.SortField) ? pagingEntity.SortField : "A.SysNo DESC")) { if (filter.SellerSysNo.HasValue) { dataCommand.AddInputParameter("@SellerSysNo", DbType.String, filter.SellerSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.MerchantSysNo", DbType.String, "@SellerSysNo", QueryConditionOperatorType.Equal, filter.SellerSysNo); } //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID); //中蛋故有 if (filter.VendorType == 1) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "VD.VendorType=0"); } else { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "VD.SysNo", DbType.Int32, "@VendorType", QueryConditionOperatorType.Equal, filter.VendorType); } if (filter.ProductGroupNo != 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "PC.ProductGroupSysno", DbType.Int32, "@GroupID", QueryConditionOperatorType.Equal, filter.ProductGroupNo); } if (filter.IsByGroup) { if (filter.ProductSysNo > 0) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "B.SysNo in(SELECT ProductSysNo FROM [OverseaContentManagement].[dbo].[V_CM_AllProductInfo] WHERE [ProductGroupSysno] IN (SELECT [ProductGroupSysno] FROM [OverseaContentManagement].[dbo].[V_CM_AllProductInfo] WHERE ProductID='" + filter.ProductID + "' AND ProductSysNo=" + filter.ProductSysNo + "))"); } } else { if (!string.IsNullOrEmpty(filter.ProductID)) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.ProductSysNo IN (SELECT SysNo FROM ipp3.dbo.Product WITH (NOLOCK) WHERE ProductID = '" + filter.ProductID + "')"); } } sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "A.InDate", DbType.DateTime, "@InDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual, filter.InDateFrom, filter.InDateTo); sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "A.EditDate", DbType.DateTime, "@EditDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual, filter.EditDateFrom, filter.EditDateTo); //商品类别 if (filter.Category1SysNo != null && filter.Category2SysNo != null && filter.Category3SysNo != null) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.ProductSysNo IN (SELECT SysNo FROM ipp3.dbo.Product WITH (NOLOCK) WHERE C3SysNo = " + filter.Category3SysNo + " AND CompanyCode=" + filter.CompanyCode + ")"); } else if (filter.Category1SysNo != null && filter.Category2SysNo != null) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.ProductSysNo IN (SELECT p.SysNo FROM ipp3.dbo.Product p WITH (NOLOCK),ipp3.dbo.Category3 c WITH (NOLOCK) WHERE p.C3SysNo = c.SysNo AND c.C2SysNo =" + filter.Category2SysNo + " AND P.CompanyCode=" + filter.CompanyCode + " AND C.CompanyCode=" + filter.CompanyCode + ")"); } else if (filter.Category1SysNo != null) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.ProductSysNo IN (SELECT p.SysNo FROM ipp3.dbo.Product p WITH (NOLOCK),ipp3.dbo.Category3 c3 WITH (NOLOCK),ipp3.dbo.Category2 c2 WITH (NOLOCK) WHERE p.C3SysNo = c3.SysNo AND c3.C2SysNo = c2.SysNo AND c2.C1SysNo = " + filter.Category1SysNo + " AND P.companycode=" + filter.CompanyCode + " AND c2.companycode=" + filter.CompanyCode + " AND c3.companycode=" + filter.CompanyCode + ")"); } if (filter.PMUserSysNo != null) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.ProductSysNo IN (SELECT SysNo FROM ipp3.dbo.Product WITH (NOLOCK) WHERE PMUserSysNo = " + filter.PMUserSysNo + ")"); } if (filter.ProductStatus != null) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.ProductSysNo IN (SELECT SysNo FROM ipp3.dbo.Product WITH (NOLOCK) WHERE Status = " + filter.ProductStatus + ")"); } if (!string.IsNullOrEmpty(filter.Status)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, filter.Status.Substring(0, 1)); if (filter.Status.Length > 1) { if (filter.Status.Substring(2, 1) == "1") { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.EditUser='******'"); } else if (filter.Status.Substring(2, 1) == "2") { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.EditUser<>'System'"); } } } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Type", DbType.String, "@Type", QueryConditionOperatorType.Equal, filter.Type); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Content", DbType.String, "@Content", QueryConditionOperatorType.Like, filter.Content); if (filter.CustomerSysNo != null) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.CustomerSysNo=" + filter.CustomerSysNo + ""); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.EditUser", DbType.String, "@EditUser", QueryConditionOperatorType.Like, filter.EditUser); if (filter.CustomerCategory != null) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "A.CustomerSysNo IN ( SELECT SysNo FROM ipp3.dbo.Customer WITH (NOLOCK) WHERE CompanyCustomer = " + filter.CustomerCategory + ")"); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); //CodeNamePairColumnList pairList = new CodeNamePairColumnList(); //pairList.Add("Status", "MKT", "ReplyStatus");//咨询状态 ////pairList.Add("ReferenceType", "MKT", "CommentsCategory"); //var dt = cmd.ExecuteDataTable(pairList); //totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); List <ProductConsultQueryBasicInfo> list = dataCommand.ExecuteEntityList <ProductConsultQueryBasicInfo>(); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(list); } }
public override void OnPageLoad(object sender, EventArgs e) { facade = new ProductConsultQueryFacade(this); filter = new ProductConsultQueryFilter(); filterReply = new ProductConsultReplyQueryFilter(); model = new ProductConsultQueryVM(); modelReply = new ProductConsultReplyQueryVM(); modelReply.ChannelID = "1"; model.ChannelID = "1"; model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; modelReply.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; #region 咨询 //商品状态 comProductStatus.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.IM.ProductStatus>(EnumConverter.EnumAppendItemType.All); //咨询状态,就是相对应的回复状态 CodeNamePairHelper.GetList("MKT", "ReplyStatus", CodeNamePairAppendItemType.All, (obj, args) => { if (args.FaultsHandle()) { return; } comConsultStatus.ItemsSource = args.Result; comConsultStatusReply.ItemsSource = args.Result;//.Remove(;需要删除已经回复,需要确认 }); //标记类型,也就是咨询的类型 CodeNamePairHelper.GetList("MKT", "ConsultCategory", CodeNamePairAppendItemType.All, (obj, args) => { if (args.FaultsHandle()) { return; } comConsultCategory.ItemsSource = args.Result; }); //顾客类型 CodeNamePairHelper.GetList("MKT", "CustomerCategory", CodeNamePairAppendItemType.All, (obj, args) => { if (args.FaultsHandle()) { return; } comCustomerCategory.ItemsSource = args.Result; comCustomerCategoryReply.ItemsSource = args.Result; }); #endregion #region 回复 comIsTopReply.ItemsSource = EnumConverter.GetKeyValuePairs <YNStatus>(EnumConverter.EnumAppendItemType.All); comProductStatusReply.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.IM.ProductStatus>(EnumConverter.EnumAppendItemType.All); comIsType.ItemsSource = EnumConverter.GetKeyValuePairs <ReplyVendor>(EnumConverter.EnumAppendItemType.All); #endregion ProductConsultLayout.DataContext = model; btnStackPanel.DataContext = model; ProductConsultReplyLayout.DataContext = modelReply; btnReplyStackPanel.DataContext = modelReply; base.OnPageLoad(sender, e); }