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

    技术2022-05-20  49

    /// <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;          }

          }

     


    最新回复(0)