CREATE OR REPLACE package body REPORT.Clinic_Rate
as
PROCEDURE Clinic_Master
(
Start_Date date,
End_Date date,
I number,
T_Rate OUT T_CURSOR
)
IS
BEGIN
OPEN T_Rate FOR
select COUNTS,count(*) as counts_number from
(
SELECT PATIENT_ID,COUNT(PATIENT_ID) AS COUNTs FROM CLINIC_MASTER WHERE visit_date>=Start_Date and Visit_date<=End_Date GROUP BY PATIENT_ID
) a
group by COUNTS
order by COUNTS;
END Clinic_Master;
end Clinic_Rate;
/
c#调用
private
void Data_Load1()
{
OracleConnection newConn = MyConn.Conn_Oracle();
newConn.Open();
OracleCommand dmCmd = new OracleCommand("SXXX_SELDM_XML.dept_dict", newConn); //
调用包中存储过程GetDM
dmCmd.CommandType = CommandType.StoredProcedure;
OracleParameter param_p_id = new OracleParameter("code", OracleType.Number);
param_p_id.Direction = ParameterDirection.Input;
param_p_id.Value = 148;
OracleParameter param = new OracleParameter("C_DM_DEPT", OracleType.Cursor);
param.Direction = ParameterDirection.Output;
DataSet MyDataSet = new DataSet();
dmCmd.Parameters.Add(param_p_id);
dmCmd.Parameters.Add(param);
OracleDataAdapter MyDataAdapter = new OracleDataAdapter();
MyDataAdapter.SelectCommand = dmCmd;
MyDataAdapter.Fill(MyDataSet, "Clinic_Data");
GridView2.DataSource = MyDataSet.Tables["Clinic_Data"];
GridView2.DataBind();
}