Csharp:操作存儲過程輸出參數，和返回值

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

/// <summary>        ///塗聚文 存儲過程輸出參數，和返回值        /// 20131030        /// Geovin Du        /// </summary>        /// <param name="rept"></param>        /// <param name="apage"></param>        /// <param name="vipno"></param>        /// <param name="date"></param>        /// <param name="alltotal"></param>        /// <returns></returns>        public DataTable SelectbirthdayVipdlyTotalPage(Repeater rept, AspNetPager apage, string vipno, DateTime date, out string alltotal)        {            DataTable dt = new DataTable();            int pagecout = SelectVipInfoErroCount(vipno,date);            try            {                SqlParameter[] par = new SqlParameter[]{                new SqlParameter("@vipno", SqlDbType.NVarChar,30),//输入参数                new SqlParameter("@now", SqlDbType.DateTime),//输入参数                 new SqlParameter("@alltotal", SqlDbType.Decimal,50),//输出参数                  };                par[0].Value = vipno;                par[1].Value = date;                par[2].Direction = ParameterDirection.Output; //ParameterDirection.ReturnValue; //                using (DataTable reader = DBHelper.GetDataBindRepeaterAspNetPagerList(rept, apage, pagecout, 20, "View_birthdayVipdlyList", "proc_Select_birthdayVipdlyTotal", CommandType.StoredProcedure, par))                {                    dt = reader;                    alltotal = par[2].Value.ToString();                }            }            catch (SqlException ex)            {                  throw ex;            }              return dt;          }