带输出参数存储过程

方法函数
: #region 添加新站点存储过程版本
        /// <summary>
        /// 新增站点
        /// </summary>
        /// <param name="userwebhost">站点表实体</param>
        /// <returns></returns>
        public bool AddNew(UserWebHost userwebhost, out int ReturnValue, out string ReturnString)
        {
            Database DBUserWebHost;
            DbCommand ComUserWebHost = null;
            ReturnValue = -1;
            ReturnString = string.Empty;

            DBUserWebHost = DatabaseFactory.CreateDatabase("WapAD_Base");
            using (IDbConnection IDBConn = DBUserWebHost.CreateConnection())
            {
                IDBConn.Open();
                IDbTransaction IDBTrans = IDBConn.BeginTransaction();
                try
                {

                    ComUserWebHost = DBUserWebHost.GetStoredProcCommand("proc_AddUserWebHost");
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@UserId", DbType.Int32, userwebhost.UserId);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@ChannelType", DbType.Int32, userwebhost.ChannelType);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@ChannelId", DbType.Int32, userwebhost.ChannelId);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@WebName", DbType.String, userwebhost.WebName);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@WebUrl", DbType.String, userwebhost.WebUrl);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@Description", DbType.AnsiString, userwebhost.Description);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@ServerIP", DbType.Int64, userwebhost.ServerIP);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@SynchUrl", DbType.String, userwebhost.SynchUrl);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@State", DbType.Int32, userwebhost.State);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@Keap", DbType.Int32, userwebhost.Keap);
                    DBUserWebHost.AddInParameter(ComUserWebHost, "@CheckUserID", DbType.Int32, userwebhost.CheckUserID);
                    DBUserWebHost.AddOutParameter(ComUserWebHost, "@ReturnValue", DbType.Int32, 4);
                    DBUserWebHost.AddOutParameter(ComUserWebHost, "@ReturnString", DbType.String, 500);
                    DBUserWebHost.ExecuteNonQuery(ComUserWebHost);

                    ReturnValue = (int)DBUserWebHost.GetParameterValue(ComUserWebHost, "@ReturnValue");
                    ReturnString = (string)DBUserWebHost.GetParameterValue(ComUserWebHost, "@ReturnString");
                    IDBTrans.Commit();
                }
                catch (Exception ex)
                {
                    IDBTrans.Rollback();
                    Log.SystemLog(ex.Message);
                    return false;
                }
                finally
                {
                    if (IDBConn.State != ConnectionState.Closed)
                    {
                        IDBConn.Close();
                    }
                }
            }
            return true;
        }
        #endregion

调用代码:
          int ReturnValue = 0;//输出参数
        string ReturnString = string.Empty;//输出参数
     
        try
        {

            UserWebHost MyWebHost = new UserWebHost();
            DAABUserWebHost _UserWebHost = new DAABUserWebHost();
            MyWebHost.UserId = Convert.ToInt32(Session["EUserID"].ToString());
            MyWebHost.ChannelId = Convert.ToInt32(Request.Form["ddlChannel"].ToString());
            MyWebHost.ChannelType = Convert.ToInt32(ddlChannelTypeID.SelectedValue);
            MyWebHost.WebName = txtWebName.Text;
            MyWebHost.WebUrl = txtWebUrl.Text;
            MyWebHost.Description = "";
            MyWebHost.ServerIP = IpAddress(txtServerIp.Text);
            MyWebHost.SynchUrl = txtSynUrl.Text;
            MyWebHost.BackCount = 0;
            MyWebHost.CheckUserID = 0;
            MyWebHost.State = 0;
            MyWebHost.Keap = 0;
            MyWebHost.CheckDate = DateTime.Now;
            MyWebHost.CreateDate = DateTime.Now;



         

             _UserWebHost.AddNew(MyWebHost, out ReturnValue, out ReturnString);
            ClientScript.RegisterStartupScript(typeof(string), "eror", "<script language='javascript'>alert('添加成功')</script>");

        }
        catch
        {


            ClientScript.RegisterStartupScript(typeof(string), "eror", "<script language='javascript'>alert('" + ReturnString + "')</script>");
        }

 
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值