public async Task <List <SalesOrder> > GetJE_SalesOrderList()
{
QueryParam queryParam = new QueryParam();
//条件 未同步 未删除
queryParam.filter = "(IsJESync eq 'N') and (DocType eq 'S01') and (BusinessType in ('CS','SP','AR-CMS')) and (IsDelete eq 'N')";
queryParam.limit = DataConvertEx.TryConvertParse(ConfigurationManager.AppSettings["MergeCount"], 300);
return(await _salesOrderApp.GetSalesOrderAsync(queryParam));
}
public async Task <List <SalesOrder> > GetIN_SalesOrderList()
{
QueryParam queryParam = new QueryParam();
//条件 未同步 未删除 退货
queryParam.filter = "(IsINSync eq 'N') and (((DocType eq 'S03') and (BusinessType in ('OS','TS','AS-CMS'))) or ((DocType eq 'S01') and (BusinessType eq 'OS'))) and (IsDelete eq 'N')";
queryParam.limit = DataConvertEx.TryConvertParse(ConfigurationManager.AppSettings["MergeCount"], 300);//从配置文件中获取合并条数，没有默认为300
return(await _salesOrderApp.GetSalesOrderAsync(queryParam));
}
public Result CreateOrUpdateMaterial(Material material)
{
Result result = new Result();
SAPbobsCOM.Items myItem = SAP.SAPCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oItems);
///检查物料是否创建
bool IsExist = myItem.GetByKey(material.ItemCode);
myItem.ItemCode = material.ItemCode;
myItem.ItemName = material.ItemName;
myItem.SalesVATGroup = material.VatGourpSa;
myItem.PurchaseVATGroup = material.VatGourpPu;
myItem.UserFields.Fields.Item("U_InitialCost").Value = Convert.ToDouble(material.InitialCost);
myItem.UserFields.Fields.Item("U_RealCost").Value = Convert.ToDouble(material.InitialCost);
myItem.UserFields.Fields.Item("U_SalesPrice").Value = Convert.ToDouble(material.SalesPrice);
myItem.InventoryItem = DataConvertEx.GetSAPValue(material.InvntItem);
myItem.UserFields.Fields.Item("U_Consignment").Value = material.Consignment;
myItem.UserFields.Fields.Item("U_Vendor").Value = material.Vendor;
//myItem.PrchseItem = 'Y';
//myItem.SellItem = 'Y';
myItem.ItemsGroupCode = BOneCommon.GetItemGroupCodeByOMSGroupNum(material.OMSGroupNum);
int ResultCode = 0;
if (IsExist)
{
ResultCode = myItem.Update();
}
else
{
ResultCode = myItem.Add();
}
if (ResultCode != 0)
{
result.ResultCode = -1;
result.ObjCode = material.ItemCode;
result.Message = SAP.SAPCompany.GetLastErrorDescription();
}
else
{
result.ResultCode = 0;
result.ObjCode = material.ItemCode;
result.Message = "Saved or Updated successfully.";
}
return(result);
}
public Result CreateOrUpdateCustomer(BusinessPartner businessPartner)
{
Result result = new Result();
SAPbobsCOM.BusinessPartners myBusinessPartner = SAP.SAPCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners);
bool isExist = myBusinessPartner.GetByKey(businessPartner.CardCode);
myBusinessPartner.CardCode = businessPartner.CardCode;
myBusinessPartner.CardName = businessPartner.CardName;
myBusinessPartner.UserFields.Fields.Item("U_PlatformCode").Value = businessPartner.PlatformCode;
myBusinessPartner.CardType = DataConvertEx.GetCardTypeByPlatformCode(businessPartner.PlatformCode.Substring(0, 1));
myBusinessPartner.GroupCode = BOneCommon.GetCustomerGroupCodeByPlateformCode(businessPartner.PlatformCode);
int rtCode = 0;
if (isExist)
{
rtCode = myBusinessPartner.Update();
}
else
{
rtCode = myBusinessPartner.Add();
}
if (rtCode != 0)
{
result.ResultCode = -1;
result.ObjCode = businessPartner.CardCode;
result.Message = SAP.SAPCompany.GetLastErrorDescription();
}
else
{
result.ResultCode = 0;
result.ObjCode = businessPartner.CardCode;
result.Message = "Updated or saved customer successfully.";
}
return(result);
}
