1、传入传出都是表
try { RfcDestination destination = RfcDestinationManager.GetDestination("DEV"); RfcFunctionMetadata BAPI_COMPANYCODE_GETDETAIL_MD = destination.Repository.GetFunctionMetadata("ZMM_PR_CHANGE"); //RFC函数名称 myfun = BAPI_COMPANYCODE_GETDETAIL_MD.CreateFunction(); //定义输入函数 IRfcTable tSAP = myfun.GetTable("IT_PR"); for (int i = 0; i < dt.Rows.Count; i++) { IRfcStructure struSAP = tSAP.Metadata.LineType.CreateStructure(); #region struSAP.SetValue("PREQ_NO", dt.Rows[i]["采购申请编号"].ToString()); struSAP.SetValue("PREQ_ITEM", dt.Rows[i]["采购申请的项目编号"].ToString()); struSAP.SetValue("DELETE_IND", dt.Rows[i]["采购凭证删除标识"].ToString()); #endregion tSAP.Append(struSAP); } myfun.SetValue("IT_PR", tSAP); //table 参数 myfun.Invoke(destination); IRfcTable dtSAPData = myfun.GetTable("IT_PR"); string errRow = "", errMessage = ""; for (int i = 0; i < dtSAPData.RowCount; i++) { IRfcStructure stru = dtSAPData[i]; #region sql = "update MM_purPurchaseApplyDetail set MTYPE = '" + stru.GetValue("MTYPE").ToString().Trim() + "',MESSAGE = '" + stru.GetValue("MESSAGE").ToString().Trim() + "' where BillNo = '" + txt_BillNo.Text.Trim() + "' and RowCode = '" + stru.GetValue("PREQ_ITEM").ToString().Trim() + "' "; if (!DB.AF.sqlExec(sql, sqlconnSAP, out errMsg)) { XtraMessageBox.Show("更新PR明细失败！"); } #endregion if (stru.GetValue("MTYPE").ToString().Trim() != "S") { errRow += stru.GetValue("PREQ_ITEM").ToString().Trim() + " "; errMessage += "第[" + stru.GetValue("PREQ_ITEM").ToString().Trim() + "]行:" + stru.GetValue("MESSAGE").ToString() + "\n"; } } if (errRow.Length > 0) { XtraMessageBox.Show("第[" + errRow + "]行Sap单据修改失败！失败原因为：" + "\n" + errMessage); } else XtraMessageBox.Show("SAP单据修改成功！"); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); }2、传入表、返回结构
RfcDestination destination = RfcDestinationManager.GetDestination("DEV"); RfcFunctionMetadata BAPI_COMPANYCODE_GETDETAIL_MD = destination.Repository.GetFunctionMetadata("ZMM_BAPI_GOODSMVT_CREATE_N"); //RFC函数名称 myfun = BAPI_COMPANYCODE_GETDETAIL_MD.CreateFunction(); //定义输入函数 IRfcTable tSAP = myfun.GetTable("IT_RES"); for (int i = 0; i < GV.RowCount; i++) { IRfcStructure struSAP = tSAP.Metadata.LineType.CreateStructure(); #region struSAP.SetValue("RSNUM", ""); //预留/相关需求的编号 struSAP.SetValue("RSPOS", ""); //预留 / 相关需求的项目编号 struSAP.SetValue("AUFNR", GV.GetRowCellValue(i, "订单号").ToString()); //订单号 #endregion tSAP.Append(struSAP); } myfun.SetValue("IT_RES", tSAP); //table 参数 try { myfun.Invoke(destination); } catch (Exception ex) { XtraMessageBox.Show("调用接口失败!"+ex.Message); } IRfcStructure getstu = myfun.GetStructure("O_RETURN"); DOCNO = getstu.GetValue("DOCNO").ToString(); MTYPE = getstu.GetValue("MSGTP").ToString(); MESSAGE = getstu.GetValue("MSTXT").ToString();3、传入表、返回字段
try { RfcDestination destination = RfcDestinationManager.GetDestination("DEV"); RfcFunctionMetadata BAPI_COMPANYCODE_GETDETAIL_MD = destination.Repository.GetFunctionMetadata("ZMM_PR_CREATE"); //RFC函数名称 myfun = BAPI_COMPANYCODE_GETDETAIL_MD.CreateFunction(); //定义输入函数 //IRfcFunction func = rfcRep.CreateFunction("ZMM_IS_PR_CREATE"); IRfcTable tSAP = myfun.GetTable("IT_PR"); for (int i = 0; i < dt.Rows.Count; i++) { IRfcStructure struSAP = tSAP.Metadata.LineType.CreateStructure(); #region struSAP.SetValue("PREQ_ITEM", dt.Rows[i]["采购申请的项目编号"].ToString()); struSAP.SetValue("PR_TYPE", dt.Rows[i]["订单类型"].ToString()); struSAP.SetValue("PR_TEXT", dt.Rows[i]["备注"].ToString()); struSAP.SetValue("PLANT", dt.Rows[i]["工厂"].ToString()); struSAP.SetValue("PUR_GROUP", dt.Rows[i]["采购组"].ToString()); #endregion tSAP.Append(struSAP); } myfun.SetValue("IT_PR", tSAP); //table 参数 myfun.Invoke(destination); EV_NUMBER = myfun.GetString("EV_NUMBER"); MTYPE = myfun.GetString("MTYPE"); MESSAGE = myfun.GetString("MESSAGE");4、传入字段、返回表
sesstab.Clear(); try { RfcDestination destination = RfcDestinationManager.GetDestination("DEV"); RfcFunctionMetadata BAPI_COMPANYCODE_GETDETAIL_MD = destination.Repository.GetFunctionMetadata("ZMM_GET_STOCK_QUANTITY_MUL"); //RFC函数名称 myfun = BAPI_COMPANYCODE_GETDETAIL_MD.CreateFunction(); // myfun.SetValue("IV_MATERIAL", "" + txt_MaterialID.Text.Trim() + ""); //物料编号 myfun.SetValue("IV_PLANT", "" + ddl_Company.EditValue.ToString().Trim() + ""); //工厂 myfun.SetValue("IV_STGE_LOC", "" + ddl_Warehouse.EditValue.ToString().Trim() + ""); //库存地点 myfun.SetValue("IV_BATCH", "" + txt_BatchNo.Text.Trim() + ""); //批号 myfun.Invoke(destination); MTYPE = myfun.GetString("MTYPE"); MESSAGE = myfun.GetString("MESSAGE"); IRfcTable tSAP = myfun.GetTable("ET_STOCK"); XtraMessageBox.Show(MTYPE+":"+ MESSAGE); for (int i = 0; i < tSAP.RowCount; i++) { IRfcStructure stru = tSAP[i]; DataRow dr = sesstab.NewRow(); dr["物料编号"] = stru.GetValue("MATERIAL").ToString(); dr["工厂"] = stru.GetValue("PLANT").ToString(); dr["库存地点"] = stru.GetValue("STGE_LOC").ToString(); dr["批号"] = stru.GetValue("BATCH").ToString(); dr["库存"] = stru.GetValue("LABST").ToString(); dr["物料描述"] = stru.GetValue("MAKTX").ToString(); dr["规格型号"] = stru.GetValue("GROES").ToString(); dr["基本计量单位"] = stru.GetValue("MEINS").ToString(); sesstab.Rows.Add(dr); } GC.DataSource = sesstab; } catch (Exception ex) { XtraMessageBox.Show(ex.Message); }
