public void ExportExcelForVendors(VendorQueryFilter request, ColumnSet[] columns) { request.CompanyCode = CPApplication.Current.CompanyCode; string relativeUrl = "/POService/Vendor/QueryVendorList"; restClient.ExportFile(relativeUrl, request, columns); }
/// <summary> /// 获取Vendor下已经锁定的PM列表 /// </summary> /// <param name="request"></param> /// <param name="callback"></param> public void QueryVendorPMHoldInfoByVendorSysNo(VendorQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback) { request.CompanyCode = CPApplication.Current.CompanyCode; string relativeUrl = "/POService/Vendor/QueryVendorPMHoldInfoByVendorSysNo"; restClient.QueryDynamicData(relativeUrl, request, callback); }
public DataTable QueryVendorPMHoldInfoByVendorSysNo(VendorQueryFilter queryFilter) { DataCommand command = DataCommandManager.GetDataCommand("GetVendorPMHoldInfoByVendorSysNo"); command.SetParameterValue("@VendorSysNo", queryFilter.VendorSysNo.Value); command.SetParameterValue("@CompanyCode", queryFilter.CompanyCode); return(command.ExecuteDataTable()); }
public DataTable QueryCanLockPMListByVendorSysNo(VendorQueryFilter queryFilter) { DataCommand dataCommand = DataCommandManager.GetDataCommand("GetCanLockPMListByVendorSysNo"); dataCommand.SetParameterValue("@VendorSysno", queryFilter.VendorSysNo.Value); dataCommand.SetParameterValue("@CompanyCode", queryFilter.CompanyCode); return(dataCommand.ExecuteDataTable()); }
public QueryResult QueryVendorPMHoldInfoByVendorSysNo(VendorQueryFilter queryFilter) { QueryResult result = new QueryResult(); result.Data = ObjectFactory <IVendorQueryDA> .Instance.QueryVendorPMHoldInfoByVendorSysNo(queryFilter); result.TotalCount = result.Data.Rows.Count; return(result); }
public QueryResult QueryVendorList(VendorQueryFilter request) { int totalCount = 0; QueryResult returnResult = new QueryResult() { Data = ObjectFactory <IVendorQueryDA> .Instance.QueryVendorList(request, out totalCount) }; returnResult.TotalCount = totalCount; return(returnResult); }
private void btnSearch_Click(object sender, RoutedEventArgs e) { if (!ValidationHelper.Validation(this.txtVendorSysNo, validateList)) { return; } this.QueryResultGrid.SelectedIndex = -1; this.queryFilter = EntityConverter <VendorQueryVM, VendorQueryFilter> .Convert(queryVM); QueryResultGrid.Bind(); }
private void QueryResultGrid_ExportAllClick(object sender, EventArgs e) { //新增商家: if (!AuthMgr.HasFunctionPoint(AuthKeyConst.PO_Vendor_ExportExcel)) { Window.Alert("对不起,你没有权限进行此操作!"); return; } //导出全部: if (null != queryRequest) { VendorQueryFilter exportQueryRequest = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <ECCentral.QueryFilter.PO.VendorQueryFilter>(queryRequest); exportQueryRequest.PageInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = ConstValue.MaxRowCountLimit }; foreach (DataGridColumn col in QueryResultGrid.Columns) { if (col.Visibility == Visibility.Collapsed) { if (col is Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn) { (col as Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn).NeedExport = false; } else if (col is Newegg.Oversea.Silverlight.Controls.Data.DataGridTemplateColumn) { (col as Newegg.Oversea.Silverlight.Controls.Data.DataGridTemplateColumn).NeedExport = false; } } } ColumnSet columnSet = new ColumnSet(QueryResultGrid); //ColumnSet columnSet = new ColumnSet() //.Add("SysNo", ResVendorQuery.GridHeader_VendorSysNo, 20) //.Add("VendorName", ResVendorQuery.GridHeader_VendorName, 40) //.Add("IsConsign", ResVendorQuery.GridHeader_Consign, 20) //.Add("RANK", ResVendorQuery.GridHeader_VendorLevel, 20) //.Add("Status", ResVendorQuery.GridHeader_Status, 20) //.Add("PayTermsName", ResVendorQuery.GridHeader_PayPeriodType, 40) //.Add("Bank", ResVendorQuery.GridHeader_Bank, 20) //.Add("Account", ResVendorQuery.GridHeader_Account, 20) //.Add("VendorContractInfo", ResVendorQuery.GridHeader_ContractInfo, 20) //.Add("CreateVendorUserName", ResVendorQuery.GridHeader_CreateUser, 20) //.Add("CreateVendorTime", ResVendorQuery.GridHeader_CreateTime, 20) //.Add("AuditStatus", ResVendorQuery.GridHeader_AuditStatus, 20); vendorFacade.ExportExcelForVendors(exportQueryRequest, new ColumnSet[] { columnSet }); } }
void UCVendorQuery_Loaded(object sender, RoutedEventArgs e) { this.Loaded -= UCVendorQuery_Loaded; validateList = new List <ValidationEntity>(); validateList.Add(new ValidationEntity(ValidationEnum.IsInteger, this.txtVendorSysNo.Text, "供应商编号必须为整数")); Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn colStatus = this.QueryResultGrid.Columns[2] as Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn; colStatus.Binding.ConverterParameter = typeof(ValidStatus); BindComboBoxData(); serviceFacade = new VendorFacade(CPApplication.Current.CurrentPage); queryVM = new VendorQueryVM(); queryFilter = new VendorQueryFilter(); this.DataContext = queryVM; }
public VendorInfo EditVendor(VendorInfo info) { VendorInfo oldVendor = LoadVendorBySysNo(info.SysNo.Value.ToString()); if (string.IsNullOrEmpty(oldVendor.VendorFinanceInfo.AccountNumber) || (oldVendor.VendorFinanceInfo.AccountNumber.Trim() != info.VendorFinanceInfo.AccountNumber.Trim())) { VendorQueryFilter filter = new VendorQueryFilter() { PageInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = 10, SortBy = "v.SysNo" }, Account = info.VendorFinanceInfo.AccountNumber, IsConsign = info.VendorBasicInfo.ConsignFlag }; QueryResult result = QueryVendorList(filter); if (result.TotalCount > 0) { throw new BizException("该供应商银行账号和对应账期属性已存在!"); } } info.VendorBasicInfo.VendorRank = info.VendorBasicInfo.RequestVendorRank.Value; if (string.IsNullOrEmpty(oldVendor.VendorBasicInfo.BuyWeekDayVendor)) { oldVendor.VendorBasicInfo.BuyWeekDayVendor = ""; } if (oldVendor.VendorBasicInfo.BuyWeekDayVendor != info.VendorBasicInfo.RequestBuyWeekDayVendor) { info.VendorBasicInfo.BuyWeekDayVendor = info.VendorBasicInfo.RequestBuyWeekDayVendor; } info.VendorBasicInfo.BuyWeekDayVendor = string.IsNullOrEmpty(info.VendorBasicInfo.BuyWeekDayVendor) ? "" : info.VendorBasicInfo.BuyWeekDayVendor; //更新: return(ObjectFactory <VendorAppService> .Instance.EditVendorInfo(info)); }
private void BindPMList() { VendorQueryFilter filter = new VendorQueryFilter() { VendorSysNo = this.VendorSysNo }; //1. 获取Vendor下可以锁定的PM列表 serviceFacade.QueryCanLockPMListVendorSysNo(filter, (obj, args) => { if (args.FaultsHandle()) { return; } CanHoldPMList = DynamicConverter <VendorHoldPMInfoVM> .ConvertToVMList(args.Result.Rows); this.gridPMList.Bind(); //2.获取Vendor下已经锁定的 PM并勾选: serviceFacade.QueryVendorPMHoldInfoByVendorSysNo(filter, (obj2, args2) => { if (args2.FaultsHandle()) { return; } HoldedPMList = DynamicConverter <VendorHoldPMInfoVM> .ConvertToVMList(args2.Result.Rows); HoldedPMList = HoldedPMList.Where(x => x.IsChecked == true).ToList(); HoldedPMList.ForEach(x => { VendorHoldPMInfoVM vm = CanHoldPMList.SingleOrDefault(g => g.PMSysNo == x.PMSysNo.Value); if (null != vm) { vm.IsChecked = true; } }); }); }); }
void UCSellerPicker_Loaded(object sender, RoutedEventArgs e) { this.Loaded -= UCSellerPicker_Loaded; serviceFacade = new VendorFacade(CurrentPage); VendorInfo = new VendorInfo(); var exp = this.GetBindingExpression(UCSellerPicker.SelectedSellerSysNoProperty); if (exp != null && exp.ParentBinding != null) { string path = exp.ParentBinding.Path.Path; Binding binding = new Binding(); binding.Path = new PropertyPath(path); binding.Mode = BindingMode.TwoWay; binding.NotifyOnValidationError = true; cmbSeller.SetBinding(Newegg.Oversea.Silverlight.Controls.Combox.SelectedValueProperty, binding); } VendorQueryFilter filter = new VendorQueryFilter() { PageInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = int.MaxValue, SortBy = "V.SysNo asc" }, VendorType = 1, Status = VendorStatus.Available }; serviceFacade.QueryVendors(filter, (obj, args) => { if (args.FaultsHandle()) { return; } List <VendorInfo> vendorInfo = new List <VendorInfo>(); if (null != args.Result.Rows) { foreach (var item in args.Result.Rows) { VendorInfo info = new VendorInfo() { SysNo = Convert.ToInt32(item["SysNo"].ToString()), }; info.VendorBasicInfo = new VendorBasicInfo() { VendorNameLocal = item["VendorName"].ToString() }; vendorInfo.Add(info); } } vendorInfo.Insert(0, new VendorInfo() { SysNo = 1, VendorBasicInfo = new VendorBasicInfo() { VendorNameLocal = "泰隆优选" } }); vendorInfo.Insert(0, new VendorInfo() { VendorBasicInfo = new VendorBasicInfo() { VendorNameLocal = ResCommonEnum.Enum_All } }); this.cmbSeller.ItemsSource = vendorInfo; }); }
/// <summary> /// 查询供应商列表 /// </summary> /// <param name="request"></param> /// <param name="callback"></param> public void QueryVendors(VendorQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "/POService/Vendor/QueryVendorList"; restClient.QueryDynamicData(relativeUrl, request, callback); }