- public void SaveBrowseInfo(decimal goodsId)
- {
- string sql= "insert into comm.comm_browse_record (id,userid,goodsid) values(:id,:userid,:goodsid)";
- OracleParameter[] parameters ={
- new OracleParameter(":id", OracleDbType.Int32) ,
- new OracleParameter(":userid", OracleDbType.Int32) ,
- new OracleParameter(":goodsid", OracleDbType.Int32)
- };
- parameters[0].Value = base.GetSequencesTo<decimal>("s_comm_browse_record");
- parameters[1].Value = 1;
- parameters[2].Value = goodsId;
- for (int i = 0; i < parameters.Length; i++)
- {
- Parameters.Add(parameters[i]);
- }
- CommandText = sql;
- ExecuteNonQuery(true);
- }
- public IDataReader GetAdsById(decimal shopId, string className)
- {
- var sqlStr = new StringBuilder();
- sqlStr.Append("SELECT T.ID,T.TITLE,T.PIC,T.HREF FROM COMM.COMM_ADMANAGEMENT T ");
- sqlStr.Append("JOIN COMM.COMM_PUBLIC P ON T.CLASSID=P.ID ");
- sqlStr.Append("WHERE T.ISDELETE=0 ");
- sqlStr.Append("AND P.CLASSNAME=:CLASSNAME ");
- sqlStr.Append("AND T.SHOPID=:SHOPID ");
- Parameters.Add(":CLASSNAME", OracleDbType.NVarchar2).Value = className;
- Parameters.Add(":SHOPID", OracleDbType.Int32).Value = shopId;
- CommandText = sqlStr.ToString();
- return ExecuteReader(CommandBehavior.CloseConnection, true);
- }
转载于:https://blog.51cto.com/doubleqian/677197