C interface with SAP

1、 Incoming and outgoing are tables

 try
            {

                RfcDestination destination = RfcDestinationManager.GetDestination("DEV");
                RfcFunctionMetadata BAPI_COMPANYCODE_GETDETAIL_MD = destination.Repository.GetFunctionMetadata("ZMM_PR_CHANGE");  //RFC The name of the function 
                myfun = BAPI_COMPANYCODE_GETDETAIL_MD.CreateFunction();  // Define input function 

                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][" Purchase requisition No "].ToString());
                    struSAP.SetValue("PREQ_ITEM", dt.Rows[i][" Item number of the purchase requisition "].ToString());
                    struSAP.SetValue("DELETE_IND", dt.Rows[i][" Purchase voucher deletion id "].ToString());
                   
                    #endregion
                    tSAP.Append(struSAP);
                }
                myfun.SetValue("IT_PR", tSAP); //table  Parameters 
                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(" to update PR Details failed ！");
                    }
                    #endregion
                    if (stru.GetValue("MTYPE").ToString().Trim() != "S")
                    {
                        errRow += stru.GetValue("PREQ_ITEM").ToString().Trim() + " ";
                        errMessage += " The first [" + stru.GetValue("PREQ_ITEM").ToString().Trim() + "] That's ok :" + stru.GetValue("MESSAGE").ToString() + "\n";
                    }
                }
                if (errRow.Length > 0)
                {
                    XtraMessageBox.Show(" The first [" + errRow + "] That's ok Sap Failed to modify the document ！ The reason for the failure is ：" + "\n" + errMessage);
                }
                else
                    XtraMessageBox.Show("SAP The document has been modified successfully ！");
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(ex.Message);
            }

2、 Incoming table 、 Return to structure

  RfcDestination destination = RfcDestinationManager.GetDestination("DEV");
            RfcFunctionMetadata BAPI_COMPANYCODE_GETDETAIL_MD = destination.Repository.GetFunctionMetadata("ZMM_BAPI_GOODSMVT_CREATE_N");  //RFC The name of the function 
            myfun = BAPI_COMPANYCODE_GETDETAIL_MD.CreateFunction();  // Define input function 
            IRfcTable tSAP = myfun.GetTable("IT_RES");
            for (int i = 0; i < GV.RowCount; i++)
            {
                IRfcStructure struSAP = tSAP.Metadata.LineType.CreateStructure();
                #region
                struSAP.SetValue("RSNUM", "");  // reserve / Number of relevant requirements 
                struSAP.SetValue("RSPOS", "");  // reserve  /  Project number of relevant requirements 
                struSAP.SetValue("AUFNR", GV.GetRowCellValue(i, " The order number ").ToString());  // The order number 
                #endregion
                tSAP.Append(struSAP);
            }
            myfun.SetValue("IT_RES", tSAP); //table  Parameters 
            try
            {
                myfun.Invoke(destination);
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(" Failed to call interface !"+ex.Message);
            }
            IRfcStructure getstu = myfun.GetStructure("O_RETURN");
            DOCNO = getstu.GetValue("DOCNO").ToString();
            MTYPE = getstu.GetValue("MSGTP").ToString();
            MESSAGE = getstu.GetValue("MSTXT").ToString();

3、 Incoming table 、 Return field

   try
            {
                RfcDestination destination = RfcDestinationManager.GetDestination("DEV");
                RfcFunctionMetadata BAPI_COMPANYCODE_GETDETAIL_MD = destination.Repository.GetFunctionMetadata("ZMM_PR_CREATE");  //RFC The name of the function 
                myfun = BAPI_COMPANYCODE_GETDETAIL_MD.CreateFunction();  // Define input function 
                                                                         //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][" Item number of the purchase requisition "].ToString());
                    struSAP.SetValue("PR_TYPE", dt.Rows[i][" Order type "].ToString());
                    struSAP.SetValue("PR_TEXT", dt.Rows[i][" remarks "].ToString());
                    struSAP.SetValue("PLANT", dt.Rows[i][" factory "].ToString());
                    struSAP.SetValue("PUR_GROUP", dt.Rows[i][" Procurement section "].ToString());
                    #endregion
                    tSAP.Append(struSAP);
                }
                myfun.SetValue("IT_PR", tSAP); //table  Parameters 
                myfun.Invoke(destination);
                EV_NUMBER = myfun.GetString("EV_NUMBER");
                MTYPE = myfun.GetString("MTYPE");
                MESSAGE = myfun.GetString("MESSAGE");
            

4、 Incoming fields 、 Go back to the table

 sesstab.Clear();
            try
            {
                RfcDestination destination = RfcDestinationManager.GetDestination("DEV");
                RfcFunctionMetadata BAPI_COMPANYCODE_GETDETAIL_MD = destination.Repository.GetFunctionMetadata("ZMM_GET_STOCK_QUANTITY_MUL");  //RFC The name of the function 
                myfun = BAPI_COMPANYCODE_GETDETAIL_MD.CreateFunction();  //
                myfun.SetValue("IV_MATERIAL", "" + txt_MaterialID.Text.Trim() + "");   // Material number 
                myfun.SetValue("IV_PLANT", "" + ddl_Company.EditValue.ToString().Trim() + "");   // factory 
                myfun.SetValue("IV_STGE_LOC", "" + ddl_Warehouse.EditValue.ToString().Trim() + "");   // Place of stock 
                myfun.SetValue("IV_BATCH", "" + txt_BatchNo.Text.Trim() + "");   // Batch number 
                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[" Material number "] = stru.GetValue("MATERIAL").ToString();
                    dr[" factory "] = stru.GetValue("PLANT").ToString();
                    dr[" Place of stock "] = stru.GetValue("STGE_LOC").ToString();
                    dr[" Batch number "] = stru.GetValue("BATCH").ToString();
                    dr[" stock "] = stru.GetValue("LABST").ToString();
                    dr[" Material description "] = stru.GetValue("MAKTX").ToString();
                    dr[" Specifications and models "] = stru.GetValue("GROES").ToString();
                    dr[" The basic unit of measurement "] = stru.GetValue("MEINS").ToString();

                    sesstab.Rows.Add(dr);
                }
                GC.DataSource = sesstab;
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(ex.Message);
            }