Advertisement
vim_fans

Untitled

Oct 17th, 2021
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.49 KB | None | 0 0
  1.  
  2.  
  3.                         Sql = @"SELECT JSDWBH as supplierCode,JSDW_MC as supplierName ,JSDW_ID as supplierID ,
  4. '建设单位' as supplierType FROM PMMDJSDWH WHERE JSDWH_BH= :supplierCode";
  5.          
  6.  
  7.                     cmd.CommandText = Sql;
  8.                     logger.Error("Sql= " + Sql);
  9.                     OracleParameter p1 = new OracleParameter(":supplierCode", OracleDbType.Varchar2);
  10.                     p1.Value = supplierCode;
  11.                     cmd.Parameters.Add(p1);
  12.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement