日期:2014-05-17 浏览次数:21340 次
DbCommand dbcmd = db.GetStoredProcCommand("getinstockbillanddetails"); //添加参数 db.AddInParameter(dbcmd, "instockid", DbType.Int32, int.Parse(stockId)); db.AddInParameter(dbcmd, "primaryname", DbType.String, "asdas"); db.AddInParameter(dbcmd, "attachname", DbType.String, "asdas"); OracleParameter oraPara1 = new OracleParameter("cur1", OracleDbType.RefCursor, ParameterDirection.Output); OracleParameter oraPara2 = new OracleParameter("cur2", OracleDbType.RefCursor, ParameterDirection.Output); //添加参数到cmd dbcmd.Parameters.Add(oraPara1); dbcmd.Parameters.Add(oraPara2); DataSet ds = db.ExecuteDataSet(dbcmd);