从带输出参数的存储过程中获取输出参数的值 OUTPUT

来源：互联网发布：花桥远洋数据地址编辑：程序博客网时间：2024/05/16 13:50

/// <summary>
      /// 获取查询结果
      /// </summary>
      public static void GetAllPersons(string qybhStr, out int aqycount, out int jsrycount, out int tzrycount)
      {

          try
          {

              SqlParameter qybh = new SqlParameter();
              qybh.ParameterName = "@qybh";
              qybh.Direction = ParameterDirection.Input;
              qybh.SqlDbType = SqlDbType.VarChar;
              qybh.Size = 20;
              qybh.Value = qybhStr;

              SqlParameter aqy = new SqlParameter();
              aqy.ParameterName = "@aqycount";
              aqy.Direction = ParameterDirection.Output;
              aqy.SqlDbType = SqlDbType.Int;

              SqlParameter jsry = new SqlParameter();
              jsry.ParameterName = "@jsrycount";
              jsry.Direction = ParameterDirection.Output;
              jsry.SqlDbType = SqlDbType.Int;

              SqlParameter tzry = new SqlParameter();
              tzry.ParameterName = "@tzrycount";
              tzry.Direction = ParameterDirection.Output;
              tzry.SqlDbType = SqlDbType.Int;
              SqlParameter[] pars = new SqlParameter[] { qybh, aqy, jsry, tzry };
              using (SqlDataReader da = CommonCorpSrv.GetDataReader("dt_cx_GetQyRy", pars))
              {
                  aqycount = (int)aqy.Value;
                  jsrycount = (int)jsry.Value;
                  tzrycount = (int)tzry.Value;
              }

          }

          catch (Exception ex)
          {
              throw ex;
          }

}