csharp:存儲過程輸出參數，和返回值

最新推荐文章于 2017-06-05 09:30:25 发布

geovi

最新推荐文章于 2017-06-05 09:30:25 发布

阅读量964

点赞数

分类专栏： .NET 文章标签： c#

本文链接：https://blog.csdn.net/geovi/article/details/13630469

版权

.NET 专栏收录该内容

88 篇文章 0 订阅

订阅专栏

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

        }