代买写入供应商。供应商财务信息,供应商银行账号
金蝶云社区-云社区用户3J7f5885
云社区用户3J7f5885
0人赞赏了该文章 694次浏览 未经作者许可,禁止转载编辑于2019年07月12日 20:54:13

//编码
String numString=fieldsSupplier.getString("LIFNR");
//名称
String nameString=fieldsSupplier.getString("NAME1");
//公司代码
String companyString=fieldsSupplier.getString("BUKRS");

//查询该公司是否存在
SupplierCollection supplierCollection=SupplierFactory.getLocalInstance(ctx).getSupplierCollection(" where number='"+numString+"'");
if(supplierCollection==null||supplierCollection.size()<=0)
{
SupplierInfo supplierInfo=new SupplierInfo();
//供应商名称
supplierInfo.setName(nameString);
//供应商编码
supplierInfo.setNumber(numString);
//核准
supplierInfo.setUsedStatus(UsedStatusEnum.APPROVED);
//生效状态
supplierInfo.setEffectedStatus(EffectedStatusEnum.EFFECTED);
//是否内部供应商
supplierInfo.setIsInternalCompany(false);
//查询控制单元
CtrlUnitInfo cu=CtrlUnitFactory.getLocalInstance(ctx).getCtrlUnitCollection().get(0);
//控制单元
supplierInfo.setCU(cu);
//客户分组列表
SupplierGroupDetailCollection supplierGroupDetails = supplierInfo.getSupplierGroupDetails();
//分组实体
SupplierGroupDetailInfo supplierGroupDetailInfo = new SupplierGroupDetailInfo();
//分组标准
CSSPGroupStandardInfo groupStandardInfo = CSSPGroupStandardFactory.getLocalInstance(ctx).getCSSPGroupStandardInfo(new ObjectUuidPK("00000000-0000-0000-0000-000000000001BC122A7F"));//客户分组标准ID
//分组实体中添加分组标准
supplierGroupDetailInfo.setSupplierGroupStandard(groupStandardInfo);
//查询客户分组 编码等于公司代码,标准为固定值(供应商:00000000-0000-0000-0000-000000000001BC122A7F)
CSSPGroupCollection groupCollection = CSSPGroupFactory.getLocalInstance(ctx).getCSSPGroupCollection(String.format(" where number='%s' and groupStandard.id ='"+groupStandardInfo.getId()+"'",companyString));

//添加客户分组
supplierGroupDetailInfo.setSupplierGroup(groupCollection.get(0));
//实体中添加分类全名
supplierGroupDetailInfo.setSupplierGroupFullName("供应商");
//把分组实体添加到集合中
supplierGroupDetails.add(supplierGroupDetailInfo);
//分组标准
supplierInfo.setBrowseGroup(groupCollection.get(0));
//保存
IObjectPK save=null;
try{
save= SupplierFactory.getLocalInstance(ctx).save(supplierInfo);
}catch(BaseException be)
{
System.out.print(be);

}
//保存成功,添加财务信息
if(save!=null)
{
SupplierCompanyInfoInfo supplierCompanyInfo=new SupplierCompanyInfoInfo();
supplierCompanyInfo.setSupplier(supplierInfo);
supplierCompanyInfo.setName(nameString);
supplierCompanyInfo.setNumber(numString);

//获取财务组织
CompanyOrgUnitInfo companyOrgUnitInfo=CompanyOrgUnitFactory.getLocalInstance(ctx).getCompanyOrgUnitCollection().get(0);
//财务组织
supplierCompanyInfo.setCompanyOrgUnit(companyOrgUnitInfo);
//保存
IObjectPK saveCompany= SupplierCompanyInfoFactory.getLocalInstance(ctx).save(supplierCompanyInfo);
//保存成功,添加银行
if(saveCompany!=null)
{
//银行
JCoFunction functionBank = null;
//查询银行信息
try {
functionBank = destination.getRepository().getFunction("Z_SDL_EAS_LFBK");
JCoParameterList input = functionBank.getImportParameterList();
//查询条件 编码
input.setValue("LIFNR", numString);
functionBank.execute(destination);
} catch (JCoException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String bankResult=functionBank.getExportParameterList().getString("RESPONSESTATUS");
//调用失败
if("9".equals(bankResult))
{
continue;
}
//获取返回表数据 供应商
JCoTable fieldsSupplieBankr = functionBank.getTableParameterList().getTable("IT_LFBK");
for(int t=0;t {
fieldsSupplieBankr.setRow(t);
//银行代码
String bankCode=fieldsSupplieBankr.getString("BANKL");
//开户姓名
String userName=fieldsSupplieBankr.getString("KOINH");
//银行账号
String bankNumber=fieldsSupplieBankr.getString("ZBANKN");

SupplierCompanyBankInfo supplierBankInfo=new SupplierCompanyBankInfo();
supplierBankInfo.setBank(bankCode);
supplierBankInfo.setBankAccount(bankNumber);
supplierBankInfo.setSupplierCompanyInfo(supplierCompanyInfo);
SupplierCompanyBankFactory.getLocalInstance(ctx).save(supplierBankInfo);


}
}
}