Csharp:操作存儲過程輸出參數,和返回值
/// <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; }
哲学管理(学)人生, 文学艺术生活, 自动(计算机学)物理(学)工作, 生物(学)化学逆境, 历史(学)测绘(学)时间, 经济(学)数学金钱(理财), 心理(学)医学情绪, 诗词美容情感, 美学建筑(学)家园, 解构建构(分析)整合学习, 智商情商(IQ、EQ)运筹(学)生存.---Geovin Du(涂聚文)