1. public void SaveBrowseInfo(decimal goodsId) 
  2.         { 
  3.  
  4.              string sql= "insert into comm.comm_browse_record (id,userid,goodsid) values(:id,:userid,:goodsid)"; 
  5.              OracleParameter[] parameters ={ 
  6.                             new OracleParameter(":id", OracleDbType.Int32) , 
  7.                             new OracleParameter(":userid", OracleDbType.Int32) ,  
  8.                             new OracleParameter(":goodsid", OracleDbType.Int32)  
  9.                                          }; 
  10.              parameters[0].Value = base.GetSequencesTo<decimal>("s_comm_browse_record"); 
  11.              parameters[1].Value = 1; 
  12.              parameters[2].Value = goodsId; 
  13.              for (int i = 0; i < parameters.Length; i++) 
  14.              { 
  15.                  Parameters.Add(parameters[i]); 
  16.              } 
  17.              CommandText = sql; 
  18.              ExecuteNonQuery(true);  
  19.          } 

 

  1. public IDataReader GetAdsById(decimal shopId, string className) 
  2.         { 
  3.             var sqlStr = new StringBuilder();             
  4.             sqlStr.Append("SELECT T.ID,T.TITLE,T.PIC,T.HREF FROM COMM.COMM_ADMANAGEMENT  T ");             
  5.             sqlStr.Append("JOIN COMM.COMM_PUBLIC P ON T.CLASSID=P.ID "); 
  6.             sqlStr.Append("WHERE T.ISDELETE=0 "); 
  7.             sqlStr.Append("AND P.CLASSNAME=:CLASSNAME ");  
  8.             sqlStr.Append("AND T.SHOPID=:SHOPID ");  
  9.  
  10.             Parameters.Add(":CLASSNAME", OracleDbType.NVarchar2).Value = className; 
  11.             Parameters.Add(":SHOPID", OracleDbType.Int32).Value = shopId;                
  12.  
  13.             CommandText = sqlStr.ToString(); 
  14.             return ExecuteReader(CommandBehavior.CloseConnection, true); 
  15.         }