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

進開發學習交流群：