读取存储过程的值

 #region 玂计沮よ猭
  private void SavaData()
  {   
   try
   {     
    SqlConnection sqlConn = new SqlConnection( OA.Components.Common.DbConnectionString);
    SqlCommand sqlComm = sqlConn.CreateCommand();
    sqlComm.CommandType = CommandType.StoredProcedure;
    sqlComm.CommandText = "pr_Divan_InsertDivan";
    sqlConn.Open();

    sqlComm.Parameters.Add("@Divan_No",SqlDbType.VarChar,10);
    sqlComm.Parameters.Add("@Divan_Name",SqlDbType.VarChar,50);
    sqlComm.Parameters.Add("@Company_No",SqlDbType.VarChar,10);
    sqlComm.Parameters.Add("@Ower_Dept_No",SqlDbType.VarChar,10);
    sqlComm.Parameters.Add("@Divan_Size",SqlDbType.VarChar,20);
    sqlComm.Parameters.Add("@Lodge_Amount",SqlDbType.SmallInt);
    sqlComm.Parameters.Add("@Has_Videobit",SqlDbType.Bit);
    sqlComm.Parameters.Add("@has_audio",SqlDbType.Bit);
    sqlComm.Parameters.Add("@State",SqlDbType.Char,1);
    sqlComm.Parameters.Add("@Tel_1",SqlDbType.VarChar,20);
    sqlComm.Parameters.Add("@Tel_2",SqlDbType.VarChar,20);
    sqlComm.Parameters.Add("@Tel_3",SqlDbType.VarChar,20);
    sqlComm.Parameters.Add("@Address",SqlDbType.VarChar,100);
    sqlComm.Parameters.Add("@User_No",SqlDbType.VarChar,20);
    sqlComm.Parameters.Add("@Divan_description",SqlDbType.VarChar,200);    
   
    sqlComm.Parameters["@Divan_No"].Value = this.txtNo.Value.ToString().Trim();
    sqlComm.Parameters["@Divan_Name"].Value = this.txtName.Value.ToString().Trim();
    sqlComm.Parameters["@Company_No"].Value = this.txtCompany_No.Value.ToString().Trim();
    sqlComm.Parameters["@Ower_Dept_No"].Value = this.txtDept.Value.ToString().Trim();
    sqlComm.Parameters["@Divan_Size"].Value = this.txtSize.Value.ToString().Trim();
    sqlComm.Parameters["@Lodge_Amount"].Value = this.txtCount.Value.ToString().Trim();

    sqlComm.Parameters["@Has_Videobit"].Value = this.VideoState;
    sqlComm.Parameters["@has_audio"].Value =this.AudioState;
    sqlComm.Parameters["@State"].Value = this.State;
    sqlComm.Parameters["@Tel_1"].Value =this.txt_Tel_1.Value.ToString().Trim();
    sqlComm.Parameters["@Tel_2"].Value = this.txt_Tel_2.Value.ToString().Trim();
    sqlComm.Parameters["@Tel_3"].Value = this.txt_Tel_3.Value.ToString().Trim();
    sqlComm.Parameters["@Address"].Value = this.txt_Address.Value.ToString().Trim();
    sqlComm.Parameters["@User_No"].Value = this.txtUser_No.Value.ToString().Trim();
    sqlComm.Parameters["@Divan_description"].Value = this.txtDescription.Value.ToString().Trim();
    
    SqlDataReader sdr = sqlComm.ExecuteReader(CommandBehavior.CloseConnection);
    if(sdr.Read())
    {
     Err = sdr.GetInt32(0);
     if(Err ==-1)
     {
      OA.Components.Common.Alert("赣穦某絪腹竒,叫癸!");
      return;
     }
     if(Err ==-2)
     {
      OA.Components.Common.Alert("穦某嘿竒,叫癸!");
      return;
     }
    }    
   }
   catch(Exception ee)
   {     
    OA.Components.Common.Alert(ee.Message); 
   }
      
  }
  #endregion

 

/********************************************
 *介紹：辦公自動化OA系統 ()
 *作者：YM
 *書寫時間：2007/05/09
 *傳入：會議列表@DivanID
 *說明：涉及表名[divan,divan_apply_list,divan_use_history]
*********************************************/
CREATE PROCEDURE pr_Divan_InsertDivan
( 
 @Divan_No varchar(10),
 @Divan_Name varchar(50),
 @Company_No varchar(10),
 @Ower_Dept_No varchar(10),
 @Divan_Size varchar(20),
 @Lodge_Amount smallint,
 @Has_Videobit bit,
 @has_audio bit,
 @State char(1),
 @Tel_1 varchar(20),
 @Tel_2 varchar(20),
 @Tel_3 varchar(20),
 @Address varchar(100),
 @User_No varchar(20),
 @Divan_description varchar(200)
 
)
as
 Declare @ID int
 Declare @Err int
 Declare @D_No int
 Declare @D_Name int
 select @D_No=Count(*) from divan where divan_no =@Divan_No
if(@D_No<>0)
 begin
  set @Err =-1
  select @Err
  return
 end
select @D_Name =Count(*) from divan where divan_name =@Divan_Name
if(@D_Name<>0)
 begin
  set @Err=-2
  select @Err
  return
 end
 --Select @ID = Max(divan_id) From Divan_no
 Select @ID = Max(divan_id) From divan
 Set @ID = IsNull(@ID, 0) + 1
 --insert into divan_apply_list(divan_id) values(@ID)
 insert into divan(divan_id,divan_no,divan_name,company_no,owner_dept_no,divan_size,lodge_amount,has_video,has_audio,state, tel_1,tel_2,tel_3,address,user_no,divan_description)
  values(@ID,@Divan_No,@Divan_Name,@Company_No,@Ower_Dept_No,@Divan_Size,@Lodge_Amount,@Has_Videobit,@has_audio,@State,@Tel_1,@Tel_2,@Tel_3,@Address,@User_No,@Divan_description)
--取系統錯誤號
select @Err = @@Error

--輸出組id和錯誤號
select @Err