private void DataGrid_Result_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { OrderCheckItemQueryFilter queryFilter = new OrderCheckItemQueryFilter(); queryFilter.PagingInfo = new PagingInfo { PageSize = int.MaxValue, PageIndex = 0, SortBy = "" }; queryFilter.ReferenceType = "PC"; queryFilter.CompanyCode = CPApplication.Current.CompanyCode; OrderCheckItemFacade facade = new OrderCheckItemFacade(this); facade.QueryOrderCheckItem(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } List <OrderCheckItemVM> list = DynamicConverter <OrderCheckItemVM> .ConvertToVMList(args.Result.Rows); dataGridOrderCheckList.ItemsSource = list; dataGridOrderCheckList.TotalCount = list.Count(); }); }
private void DataGrid_Result_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { OrderCheckItemQueryFilter queryFilter = new OrderCheckItemQueryFilter(); queryFilter.PagingInfo = new PagingInfo { PageSize = e.PageSize, PageIndex = e.PageIndex, SortBy = e.SortField }; if (rbtnProductSysNo1.IsChecked.Value) { viewModel.ReferenceType = "PID"; } else if (rbtnProductType1.IsChecked.Value) { viewModel.ReferenceType = "PC3"; } queryFilter.ReferenceType = viewModel.ReferenceType; queryFilter.Status = viewModel.Status; queryFilter.ReferenceContent = viewModel.ProductID; queryFilter.Description = (viewModel.Category3No.HasValue ? viewModel.Category3No.ToString() : string.Empty); OrderCheckItemFacade facade = new OrderCheckItemFacade(this); facade.QueryOrderCheckItem(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } List <OrderCheckItemVM> list = DynamicConverter <OrderCheckItemVM> .ConvertToVMList(args.Result.Rows); this.DataGrid_ResultList.ItemsSource = list; DataGrid_ResultList.TotalCount = args.Result.TotalCount; }); }
public QueryResult QueryOrderCheckItemList(OrderCheckItemQueryFilter request) { int totalCount; return(new QueryResult() { Data = ObjectFactory <IOrderCheckItemQueryDA> .Instance.Query(request, out totalCount), TotalCount = totalCount }); }
private void LoadListBoxData() { CommonDataFacade commonDataFacade = new CommonDataFacade(this); OrderCheckItemQueryFilter queryFilter = new OrderCheckItemQueryFilter(); queryFilter.PagingInfo = new PagingInfo { PageSize = int.MaxValue, PageIndex = 0, SortBy = "" }; queryFilter.ReferenceType = "ST"; queryFilter.CompanyCode = CPApplication.Current.CompanyCode; OrderCheckItemFacade facade = new OrderCheckItemFacade(this); facade.QueryOrderCheckItem(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } rightList = DynamicConverter <OrderCheckItemVM> .ConvertToVMList(args.Result.Rows); rightList = FindAll(rightList, x => x.SysNo.HasValue); ListBox_SelectedShippingTypeList.ItemsSource = rightList; commonDataFacade.GetShippingTypeList(true, (obj2, args2) => { leftList = args2.Result; leftList = FindAll(leftList, x => x.SysNo.HasValue); if (rightList != null && leftList != null) { foreach (OrderCheckItemVM p in rightList) { leftList.Remove(leftList.Where(x => x.SysNo.ToString() == p.ReferenceContent).FirstOrDefault()); } } ListBox_ShippingTypeList.ItemsSource = leftList; }); }); }
private void DataGrid_Result_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { OrderCheckItemQueryFilter queryFilter = new OrderCheckItemQueryFilter(); queryFilter.PagingInfo = new PagingInfo { PageSize = e.PageSize, PageIndex = e.PageIndex, SortBy = e.SortField }; queryFilter.ReferenceContent = (Combox_ServiceObject.SelectedIndex == 0 ? string.Empty : model.ReferenceContent); queryFilter.ReferenceType = (Combox_DTServiceType.SelectedIndex == 0 ? string.Empty : model.ReferenceType); queryFilter.ReferenceTypeIn = "'DT11','DT12'"; OrderCheckItemFacade facade = new OrderCheckItemFacade(this); facade.QueryOrderCheckItem(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } List <OrderCheckItemVM> list = DynamicConverter <OrderCheckItemVM> .ConvertToVMList(args.Result.Rows); List <CodeNamePair> OrderCheckItemType = new List <CodeNamePair>(); CodeNamePairHelper.GetList("Customer", "DistributionServiceType", (obj2, args2) => { OrderCheckItemType = args2.Result; foreach (CodeNamePair pair in OrderCheckItemType) { foreach (OrderCheckItemVM itemVM in list) { if (itemVM.ReferenceType.ToString() == pair.Code) { itemVM.ReferenceTypeName = pair.Name; } } } }); DataGrid_DTServiceList.ItemsSource = list; DataGrid_DTServiceList.TotalCount = args.Result.TotalCount; }); }
private void DataGrid_Result_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { OrderCheckItemQueryFilter queryFilter = new OrderCheckItemQueryFilter(); queryFilter.PagingInfo = new PagingInfo { PageSize = e.PageSize, PageIndex = e.PageIndex, SortBy = e.SortField }; queryFilter.ReferenceTypeIn = "'CA','CP','CN'"; facade = new OrderCheckItemFacade(this); facade.QueryOrderCheckItem(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } List <OrderCheckItemVM> list = DynamicConverter <OrderCheckItemVM> .ConvertToVMList(args.Result.Rows); List <CodeNamePair> OrderCheckItemType = new List <CodeNamePair>(); CodeNamePairHelper.GetList("Customer", "KeyWordType", (obj2, args2) => { OrderCheckItemType = args2.Result; //在顾客端拿到的类型为: List<CodeNamePair> foreach (CodeNamePair pair in OrderCheckItemType) { foreach (OrderCheckItemVM itemVM in list) { if (itemVM.ReferenceType.ToString() == pair.Code) { itemVM.ReferenceTypeName = pair.Name; } } } }); dataGrid1.ItemsSource = list; dataGrid1.TotalCount = args.Result.TotalCount; }); }
private void LoadListBoxData() { OrderCheckItemQueryFilter queryFilter = new OrderCheckItemQueryFilter(); queryFilter.PagingInfo = new PagingInfo { PageSize = int.MaxValue, PageIndex = 0, SortBy = "" }; queryFilter.ReferenceType = "FP"; queryFilter.CompanyCode = CPApplication.Current.CompanyCode; OrderCheckItemFacade facade = new OrderCheckItemFacade(this); facade.QueryOrderCheckItem(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } rightList = DynamicConverter <OrderCheckItemVM> .ConvertToVMList(args.Result.Rows); ListBox_SelectedPayTypeList.ItemsSource = rightList; CodeNamePairHelper.GetList("Customer", "FPType", (obj2, args2) => { leftList = args2.Result; if (rightList != null && leftList != null) { foreach (OrderCheckItemVM p in rightList) { leftList.Remove(leftList.Where(x => x.Code == p.ReferenceContent).FirstOrDefault()); } } ListBox_PayTypeList.ItemsSource = leftList; }); }); }
private void DataGrid_Result_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { OrderCheckItemQueryFilter queryFilter = new OrderCheckItemQueryFilter(); queryFilter.PagingInfo = new PagingInfo { PageSize = e.PageSize, PageIndex = e.PageIndex, SortBy = e.SortField }; amountType.ForEach(item => { queryFilter.ReferenceTypeIn += string.Format("'{0}',", item.Code); }); queryFilter.ReferenceTypeIn = queryFilter.ReferenceTypeIn.TrimEnd(','); OrderCheckItemFacade facade = new OrderCheckItemFacade(this); facade.QueryOrderCheckItem(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } List <OrderCheckItemVM> list = DynamicConverter <OrderCheckItemVM> .ConvertToVMList(args.Result.Rows); foreach (CodeNamePair pair in amountType) { foreach (OrderCheckItemVM itemVM in list) { if (itemVM.ReferenceType.ToString() == pair.Code) { itemVM.ReferenceTypeName = pair.Name; } } } dataGridAmount.ItemsSource = list; dataGridAmount.TotalCount = args.Result.TotalCount; }); }
private void DataGrid_Result_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { OrderCheckItemQueryFilter queryFilter = new OrderCheckItemQueryFilter(); queryFilter.PagingInfo = new PagingInfo { PageSize = e.PageSize, PageIndex = e.PageIndex, SortBy = e.SortField }; queryFilter.ReferenceType = "SA"; OrderCheckItemFacade facade = new OrderCheckItemFacade(this); facade.QueryOrderCheckItem(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } List <OrderCheckItemVM> list = DynamicConverter <OrderCheckItemVM> .ConvertToVMList(args.Result.Rows); dataGridAutoCheckTimeList.ItemsSource = list; dataGridAutoCheckTimeList.TotalCount = args.Result.TotalCount; }); }
public void QueryOrderCheckItem(OrderCheckItemQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "/CustomerService/OrderCheckItem/Query"; restClient.QueryDynamicData(relativeUrl, request, callback); }
public virtual DataTable Query(OrderCheckItemQueryFilter queryCriteria, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = queryCriteria.PagingInfo.SortBy; pagingEntity.MaximumRows = queryCriteria.PagingInfo.PageSize; pagingEntity.StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetOrderCheckItem"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "a.SysNo DESC")) { if (string.Compare(queryCriteria.ReferenceType, "PC3") == 0) { if (queryCriteria.C1SysNo.HasValue) { string subQuerySQLC1 = @"SELECT [Category3Sysno] FROM OverseaContentManagement.dbo.V_CM_CategoryInfo with(nolock) WHERE [Category1Sysno] = " + queryCriteria.C1SysNo; sqlBuilder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, "a.Description", QueryConditionOperatorType.In, subQuerySQLC1 ); } else if (queryCriteria.C2SysNo.HasValue) { string subQuerySQLC1 = @"SELECT [Category3Sysno] FROM OverseaContentManagement.dbo.V_CM_CategoryInfo with(nolock) WHERE [Category2Sysno] = " + queryCriteria.C2SysNo; sqlBuilder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, "a.Description", QueryConditionOperatorType.In, subQuerySQLC1 ); } } if (!string.IsNullOrEmpty(queryCriteria.ReferenceTypeIn) && string.Compare(queryCriteria.ReferenceTypeIn, "'DT11','DT12'") == 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.sysno", DbType.Int32, "@sysno", QueryConditionOperatorType.Equal, queryCriteria.SysNo); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ReferenceType", DbType.String, "@ReferenceType", QueryConditionOperatorType.Equal, queryCriteria.ReferenceType); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ReferenceContent", DbType.String, "@ReferenceContent", QueryConditionOperatorType.Equal, queryCriteria.ReferenceContent); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, queryCriteria.Status); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Description", DbType.String, "@Description", QueryConditionOperatorType.Equal, queryCriteria.Description); sqlBuilder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, "a.ReferenceType", QueryConditionOperatorType.In, queryCriteria.ReferenceTypeIn); sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, queryCriteria.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); DataTable dt = cmd.ExecuteDataTable(4, typeof(OrderCheckStatus)); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }