/// <summary> /// 查询分类属性 /// </summary> /// <param name="model"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="SortField"></param> /// <param name="callback"></param> public void QueryCategoryExtendWarranty(CategoryExtendWarrantyQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { CategoryExtendWarrantyQueryFilter filter = model.ConvertVM <CategoryExtendWarrantyQueryVM, CategoryExtendWarrantyQueryFilter>(); if (string.IsNullOrEmpty(model.Cost)) { filter.Cost = -1; } filter.PagingInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; restClient.QueryDynamicData(GetRelativeUrl, filter, (obj, args) => { if (args.FaultsHandle()) { return; } if (!(args.Result == null || args.Result.Rows == null)) { foreach (var item in args.Result.Rows) { item.IsChecked = false; } } callback(obj, args); } ); }
public QueryResult QueryCategoryExtendWarranty(CategoryExtendWarrantyQueryFilter request) { if (request == null) { throw new BizException(ResouceManager.GetMessageString("IM.CategoryExtendWarranty", "CategoryExtendWarrantyCondtionIsNull")); } int totalCount; var data = ObjectFactory <ICategoryExtendWarrantyQueryDA> .Instance.QueryCategoryExtendWarranty(request, out totalCount); var source = new QueryResult { Data = data, TotalCount = totalCount }; return(source); }
public DataTable QueryCategoryExtendWarranty(CategoryExtendWarrantyQueryFilter queryCriteria, out int totalCount) { var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCategoryExtendWarranty"); var pagingInfo = new PagingInfoEntity { SortField = queryCriteria.PagingInfo.SortBy, StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize, MaximumRows = queryCriteria.PagingInfo.PageSize }; using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "A.SysNo DESC")) { if (queryCriteria.C1SysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C2.C1SysNo", DbType.Int32, "@C1SysNo", QueryConditionOperatorType.Equal, queryCriteria.C1SysNo); } if (queryCriteria.C2SysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C2.SysNo", DbType.Int32, "@C2SysNo", QueryConditionOperatorType.Equal, queryCriteria.C2SysNo); } if (queryCriteria.C3SysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C.SysNo", DbType.Int32, "@C3SysNo", QueryConditionOperatorType.Equal, queryCriteria.C3SysNo); } if (!string.IsNullOrEmpty(queryCriteria.BrandName)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.ManufacturerName + B.BriefName", DbType.String, "@BrandName", QueryConditionOperatorType.Like, queryCriteria.BrandName); } if (!string.IsNullOrEmpty(queryCriteria.ProductCode)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.ProductCode", DbType.String, "@ProductCode", QueryConditionOperatorType.Equal, queryCriteria.ProductCode); } if (queryCriteria.Years > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Years", DbType.Int32, "@Years", QueryConditionOperatorType.Equal, queryCriteria.Years); } if (queryCriteria.MinUnitPrice > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.MinUnitPrice", DbType.Decimal, "@MinUnitPrice", QueryConditionOperatorType.LessThanOrEqual, queryCriteria.MinUnitPrice); } if (queryCriteria.MaxUnitPrice > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.MaxUnitPrice", DbType.Decimal, "@MaxUnitPrice", QueryConditionOperatorType.MoreThanOrEqual, queryCriteria.MaxUnitPrice); } if (queryCriteria.UnitPrice > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.UnitPrice", DbType.Decimal, "@UnitPrice", QueryConditionOperatorType.Equal, queryCriteria.UnitPrice); } if (queryCriteria.Cost >= 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Cost", DbType.Decimal, "@Cost", QueryConditionOperatorType.Equal, queryCriteria.Cost); } if (!queryCriteria.Status.ToString().Equals("0")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, queryCriteria.Status); } if (!queryCriteria.IsECSelected.ToString().Equals("0")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.IsECSelected", DbType.String, "@IsECSelected", QueryConditionOperatorType.Equal, queryCriteria.IsECSelected); } dataCommand.CommandText = sqlBuilder.BuildQuerySql(); var enumList = new EnumColumnList { { "Status", typeof(CategoryExtendWarrantyStatus) } , { "Years", typeof(CategoryExtendWarrantyYears) } , { "IsECSelected", typeof(BooleanEnum) } }; DataTable dt = dataCommand.ExecuteDataTable(enumList); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(dt); } }
//行模板详细状态改变触发事件 private void DataGrid_RowDetailsVisibilityChanged(object sender, DataGridRowDetailsEventArgs e) { //如果是展开状态将加载数据 if (e.Row.DetailsVisibility == Visibility.Visible) { var data = DataGrid.Columns[0].GetCellContent(e.Row).DataContext as DynamicXml; #region Gift if ((int)data["GiftItemCount"] > 0) { //加载礼品 var giftDataGird = e.DetailsElement.FindName("DataGridGift") as DataGrid; //如果加载过将不再读取 if (giftDataGird.ItemsSource == null) { m_facade.GetValidVenderGifts(data["SysNo"], (o, args) => { if (!args.FaultsHandle()) { var list = args.Result.Rows; foreach (var item in list) { item["IsCheck"] = false; item["MasterSysNo"] = data["SysNo"]; } giftDataGird.ItemsSource = list; } }); } } #endregion #region ExtendWarranty if ((int)data["ExtendWarrantyCount"] > 0) { //加载延保产品 var extendWarrantyDataGird = e.DetailsElement.FindName("DataGridExtendWarranty") as DataGrid; //如果加载过将不再读取 if (extendWarrantyDataGird.ItemsSource == null) { var query = new CategoryExtendWarrantyQueryFilter(); query.PagingInfo = new PagingInfo { PageIndex = 0, PageSize = 10, SortBy = "A.SysNo" }; query.C3SysNo = (int)data["C3SysNo"]; query.MaxUnitPrice = (decimal)data["Price"]; query.MinUnitPrice = (decimal)data["Price"]; m_facade.GetExtendWarranty(query, (o, args) => { if (!args.FaultsHandle()) { List <ExtendedWarrantyVM> vmlist = new List <ExtendedWarrantyVM>(); //将数据转为VMList foreach (var item in args.Result.Rows) { ExtendedWarrantyVM vm = DynamicConverter <ExtendedWarrantyVM> .ConvertToVM(item); vm.ServiceYears = (decimal)item["Years"]; vm.ServiceUnitPrice = item["UnitPrice"]; vm.ServiceCost = item["Cost"]; vmlist.Add(vm); } extendWarrantyDataGird.ItemsSource = vmlist; } }); } } #endregion } }
/// <summary> /// 延保查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="callback">回调函数</param> public void GetExtendWarranty(CategoryExtendWarrantyQueryFilter query, EventHandler <RestClientEventArgs <dynamic> > callback) { restClient.QueryDynamicData("/IMService/CategoryExtendWarranty/QueryCategoryExtendWarranty", query, callback); }