日期:2014-05-17 浏览次数:21500 次
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);