Beispiel #1
0
        public SapResult <List <FunctionModel> > GetFunctions(string functionName)
        {
            var result = new SapResult <List <FunctionModel> >();

            try
            {
                using (var conn = new SapConnection(_destinationName))
                {
                    // NOTE: https://www.sapdatasheet.org/abap/func/rfc_function_search.html
                    var rfcFunction = conn.Repository.CreateFunction("RFC_FUNCTION_SEARCH");
                    rfcFunction.SetValue("FUNCNAME", functionName);
                    rfcFunction.SetValue("LANGUAGE", "KO");
                    rfcFunction.Invoke(conn.Destination);

                    var functions = rfcFunction.GetTable("FUNCTIONS");
                    foreach (var function in functions)
                    {
                        result.Export.Add(new FunctionModel
                        {
                            Name        = function.GetString("FUNCNAME"),
                            Group       = function.GetString("GROUPNAME"),
                            Application = function.GetString("APPL"),
                            RemoteHost  = function.GetString("HOST"),
                            ShortText   = function.GetString("STEXT")
                        });
                    }
                }
            }
            catch (Exception ex)
            {
                result.AddError(ex);
            }

            return(result);
        }
Beispiel #2
0
        public SapResult <DataTable> GetTable(string tableName, int rowSkips = 0, int rowCount = 0)
        {
            var result = new SapResult <DataTable>();

            try
            {
                using (var conn = new SapConnection(_destinationName))
                {
                    // NOTE: https://www.sapdatasheet.org/abap/func/rfc_read_table.html
                    var rfcFunction = conn.Repository.CreateFunction("RFC_READ_TABLE");
                    rfcFunction.SetValue("QUERY_TABLE", tableName);
                    rfcFunction.SetValue("DELIMITER", DATA_SEPARATOR);
                    rfcFunction.SetValue("ROWSKIPS", rowSkips);
                    rfcFunction.SetValue("ROWCOUNT", rowCount);
                    rfcFunction.Invoke(conn.Destination);

                    var fields = rfcFunction.GetTable("FIELDS");
                    var datas  = rfcFunction.GetTable("DATA");
                    var table  = ToTable(tableName, fields, datas);

                    result.Export = table;
                }
            }
            catch (Exception ex)
            {
                result.AddError(ex);
            }

            return(result);
        }
Beispiel #3
0
        public SapResult <List <ParameterModel> > GetFunctionParameters(string functionName)
        {
            var result = new SapResult <List <ParameterModel> >();

            try
            {
                using (var conn = new SapConnection(_destinationName))
                {
                    var parameters = new List <ParameterModel>();
                    var meta       = conn.Repository.GetFunctionMetadata(functionName);
                    for (int i = 0; i < meta.ParameterCount; i++)
                    {
                        StructureModel structureModel = null;
                        if (meta[i].DataType == RfcDataType.STRUCTURE)
                        {
                            string structureName = meta[i].ValueMetadataAsStructureMetadata.Name;
                            structureModel = LoadStructureMetadata(conn.Repository, structureName);
                        }
                        else if (meta[i].DataType == RfcDataType.TABLE)
                        {
                            string structureName = meta[i].ValueMetadataAsTableMetadata.LineType.Name;
                            structureModel = LoadStructureMetadata(conn.Repository, structureName);
                        }

                        var parameter = new ParameterModel()
                        {
                            Name          = meta[i].Name,
                            DataType      = meta[i].DataType.ToString(),
                            Direction     = meta[i].Direction.ToString(),
                            DefaultValue  = meta[i].DefaultValue,
                            Optional      = meta[i].Optional,
                            Documentation = meta[i].Documentation,
                            Structure     = structureModel
                        };

                        parameters.Add(parameter);
                    }

                    // 정렬순서
                    var sortOrder = new List <string>()
                    {
                        "IMPORT", "EXPORT", "CHANGING", "TABLES"
                    };

                    result.Export = parameters.OrderBy(x => sortOrder.IndexOf(x.Direction)).ToList();
                }
            }
            catch (Exception ex)
            {
                result.AddError(ex);
            }

            return(result);
        }