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;
        } 

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

标签：dbtools   int   weight   key   this   comm   lin   back   var   

查看更多关于C#调用数据库中的Procedure的方法的详细内容...