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);
}
