C#调用数据库中的Procedure的方法

C#调用数据库中的Procedure的方法

public ExecutionResult CreateWIPSN(MOBaseInfo moBaseInfo)
        {
            ExecutionResult execRes;
            string sqlText;

            //private InfoLightDBTools dbTools;       //#ORACLE#
            //this.dbTools = new InfoLightDBTools(clientInfo, dbName);

            // private InfoLightDBTXTools dbTXTools;  //#ORACLE# 要结合事务处理使用：BeginTransaction(),Commit(),Rollback(),EndTransaction()
            // this.dbTXTools = new InfoLightDBTXTools(clientInfo, dbName);

            // private InfoLightMSTools mdbtool;    //#SQL SERVER#


            // private DBParameter dbParam;
            //this.dbParam = new DBParameter();

            sqlText = "SFIS1.CREATE_WIP_SN";
            this.dbParam.Clear();
            this.dbParam.Add("imo_number", OracleType.VarChar, moBaseInfo.MONo);
            this.dbParam.Add("imodel_name", OracleType.VarChar, moBaseInfo.ModelName);
            this.dbParam.Add("iline_name", OracleType.VarChar, moBaseInfo.DefaultLine);
            this.dbParam.Add("ispecial_route", OracleType.VarChar, moBaseInfo.RouteCode);
            this.dbParam.Add("icustomer_no", OracleType.VarChar, moBaseInfo.CustCode);
            this.dbParam.Add("iversion_code", OracleType.VarChar, moBaseInfo.VersionCode);
            this.dbParam.Add("ikey_part_no", OracleType.VarChar, moBaseInfo.KeyPartNo);
            this.dbParam.Add("ibom_no", OracleType.VarChar, moBaseInfo.BOMNo);
            this.dbParam.Add("iweight", OracleType.VarChar, moBaseInfo.Weight);
            this.dbParam.Add("iqty", OracleType.Number, moBaseInfo.TargetQty);
            this.dbParam.Add("res", OracleType.VarChar);
            execRes = this.dbTools.ExecuteSP(sqlText, this.dbParam.GetParameters());

            return execRes;
        }      

本文来自博客园，作者：農碼一生，转载请注明原文链接：https://www.cnblogs.com/wml-it/p/12573106.html

技术的发展日新月异，随着时间推移，无法保证本博客所有内容的正确性。如有误导，请大家见谅，欢迎评论区指正！ 个人开源代码链接: GitHub:

https://github.com/ITMingliang

Gitee:

https://gitee.com/mingliang_it

GitLab:

https://gitlab.com/ITMingliang

进开发学习交流群：