带输出参数存储过程

方法函数<br>： #region 添加新站点存储过程版本<br> /// <summary><br> /// 新增站点<br> /// </summary><br> /// <param name="userwebhost">站点表实体</param><br> /// <returns></returns><br> public bool AddNew(UserWebHost userwebhost, out int ReturnValue, out string ReturnString)<br> {<br> Database DBUserWebHost;<br> DbCommand ComUserWebHost = null;<br> ReturnValue = -1;<br> ReturnString = string.Empty;<br><br> DBUserWebHost = DatabaseFactory.CreateDatabase("WapAD_Base");<br> using (IDbConnection IDBConn = DBUserWebHost.CreateConnection())<br> {<br> IDBConn.Open();<br> IDbTransaction IDBTrans = IDBConn.BeginTransaction();<br> try<br> {<br><br> ComUserWebHost = DBUserWebHost.GetStoredProcCommand("proc_AddUserWebHost");<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@UserId", DbType.Int32, userwebhost.UserId);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@ChannelType", DbType.Int32, userwebhost.ChannelType);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@ChannelId", DbType.Int32, userwebhost.ChannelId);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@WebName", DbType.String, userwebhost.WebName);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@WebUrl", DbType.String, userwebhost.WebUrl);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@Description", DbType.AnsiString, userwebhost.Description);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@ServerIP", DbType.Int64, userwebhost.ServerIP);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@SynchUrl", DbType.String, userwebhost.SynchUrl);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@State", DbType.Int32, userwebhost.State);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@Keap", DbType.Int32, userwebhost.Keap);<br> DBUserWebHost.AddInParameter(ComUserWebHost, "@CheckUserID", DbType.Int32, userwebhost.CheckUserID);<br> DBUserWebHost.AddOutParameter(ComUserWebHost, "@ReturnValue", DbType.Int32, 4);<br> DBUserWebHost.AddOutParameter(ComUserWebHost, "@ReturnString", DbType.String, 500);<br> DBUserWebHost.ExecuteNonQuery(ComUserWebHost);<br><br> ReturnValue = (int)DBUserWebHost.GetParameterValue(ComUserWebHost, "@ReturnValue");<br> ReturnString = (string)DBUserWebHost.GetParameterValue(ComUserWebHost, "@ReturnString");<br> IDBTrans.Commit();<br> }<br> catch (Exception ex)<br> {<br> IDBTrans.Rollback();<br> Log.SystemLog(ex.Message);<br> return false;<br> }<br> finally<br> {<br> if (IDBConn.State != ConnectionState.Closed)<br> {<br> IDBConn.Close();<br> }<br> }<br> }<br> return true;<br> }<br> #endregion<br><br>调用代码：<br><span style="color: rgb(255, 0, 0);"> int ReturnValue = 0;//输出参数</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> string ReturnString = string.Empty;//输出参数</span><br><br> try<br> {<br><br> UserWebHost MyWebHost = new UserWebHost();<br> DAABUserWebHost _UserWebHost = new DAABUserWebHost();<br> MyWebHost.UserId = Convert.ToInt32(Session["EUserID"].ToString());<br> MyWebHost.ChannelId = Convert.ToInt32(Request.Form["ddlChannel"].ToString());<br> MyWebHost.ChannelType = Convert.ToInt32(ddlChannelTypeID.SelectedValue);<br> MyWebHost.WebName = txtWebName.Text;<br> MyWebHost.WebUrl = txtWebUrl.Text;<br> MyWebHost.Description = "";<br> MyWebHost.ServerIP = IpAddress(txtServerIp.Text);<br> MyWebHost.SynchUrl = txtSynUrl.Text;<br> MyWebHost.BackCount = 0;<br> MyWebHost.CheckUserID = 0;<br> MyWebHost.State = 0;<br> MyWebHost.Keap = 0;<br> MyWebHost.CheckDate = DateTime.Now;<br> MyWebHost.CreateDate = DateTime.Now;<br><br><br><br><br><br><span style="color: rgb(255, 0, 0);"> _UserWebHost.AddNew(MyWebHost, out ReturnValue, out ReturnString);</span><br> ClientScript.RegisterStartupScript(typeof(string), "eror", "<script language='javascript'>alert('添加成功')</script>");<br><br> }<br> catch<br> {<br><br><br> ClientScript.RegisterStartupScript(typeof(string), "eror", "<script language='javascript'>alert('" + ReturnString + "')</script>");<br> }<br><br>