C#接收存储过程返回值: public static int User_Add(User us) C#接收存储过程输出参数: public static decimal Cart_UserAmount(int UID)
SqlHelper接收存储过程返回值: public int AddInfo(InfoModel obj) { try { string strSql = "spInfoSelftReferAdd"; SqlParameter[] para ={ SqlHelper.MakeInParam("@Refer_Id",obj.strRefer_Id), SqlHelper.MakeInParam("@Emit_Date",obj.dtEmit_Date), SqlHelper.MakeInParam("@StockCode",obj.strStockCode), SqlHelper.MakeInParam("@Grade",obj.intGrade), SqlHelper.MakeInParam("@Title",obj.strTitle), SqlHelper.MakeInParam("@Summary",obj.strSummary), SqlHelper.MakeInParam("@Category",obj.strCategory), SqlHelper.MakeInParam("@SZCLGrade",obj.strSZCLGrade), SqlHelper.MakeInParam("@Add_Human",obj.strAdd_Human), SqlHelper.MakeInParam("@Subheading",obj.strSubTitle), SqlHelper.MakeInParam("@Review",obj.strReView), SqlHelper.MakeInParam("@CategoryCode",obj.strCategoryCode), SqlHelper.MakeInParam("@IsReview",obj.IsDP), SqlHelper.MakeInParam("@ReReferId",obj.strReReferId), SqlHelper.MakeInParam("@CategoryID",obj.CategoryID), SqlHelper.MakeParam("@ReturnValue",SqlDbType.Int,4,ParameterDirection.ReturnValue,0,false) }; SqlHelper.ExecuteNonQuery(this.ConnInfo, CommandType.StoredProcedure, strSql, para); int ReturnValue = Convert.ToInt32(para[15].Value); //ReturnVallue return ReturnValue; } catch (Exception ex) { ExceptionLogFactory.CreateObject(enuExceptionType.File, ex); return 0; } finally { if (this.ConnInfo.State.ToString() == "Open") { this.ConnInfo.Close(); } } }
SqlHelper接收存储过程输出值: public void GetWebPageData_New(PageModel obj) { try { string spName = "spPaginationnew"; SqlParameter[] parameters = { SqlHelper.MakeInParam("@TableName",SqlDbType.VarChar,1000,obj.TableName), SqlHelper.MakeInParam("@PKey",SqlDbType.VarChar,50,obj.IDKey), SqlHelper.MakeInParam("@PKType",SqlDbType.VarChar,50,obj.IDKeyType), SqlHelper.MakeInParam("@Fields",SqlDbType.VarChar,5000,obj.Fields), SqlHelper.MakeInParam("@OrderField",SqlDbType.VarChar,5000,obj.SortField), SqlHelper.MakeInParam("@SqlWhere",SqlDbType.VarChar,5000,obj.Where), SqlHelper.MakeInParam("@PageSize",SqlDbType.Int,4,obj.PageSize), SqlHelper.MakeInParam("@PageIndex",SqlDbType.Int,4,obj.CurrentPage), SqlHelper.MakeInParam("@IsReturn",SqlDbType.Bit,1,obj.IsReturnOutPut), SqlHelper.MakeOutParam("@TotalPage",SqlDbType.Int,4), SqlHelper.MakeOutParam("@TotalRecord",SqlDbType.Int,4) }; DataSet ds = SqlHelper.ExecuteDataset(this.ConnStr, CommandType.StoredProcedure, spName, parameters); string aa = parameters[9].Value.ToString(); string bb = parameters[10].Value.ToString(); } catch (Exception ex) { throw ex; } } |
|