コード例 #1
0
        public string SeatUser_Update(SeatUser_Class obj)
        {
            SqlConnection con = new SqlConnection(new login().GetConnectionString());
            SqlCommand    cmd = new SqlCommand("SeatUser_Update", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@SeatUserId", obj.SeatUserId);
            cmd.Parameters.AddWithValue("@UserId", obj.UserId);
            cmd.Parameters.AddWithValue("@SeatId", obj.SeatId);
            cmd.Parameters.AddWithValue("@Active", obj.Active);
            cmd.Parameters.AddWithValue("@ActiveStartDate", Convert.ToDateTime(obj.ActiveStartDate));
            cmd.Parameters.AddWithValue("@ActiveEndDate", Convert.ToDateTime(obj.ActiveEndDate));
            cmd.Parameters.AddWithValue("@SequenceNo", obj.SequenceNo);
            cmd.Parameters.AddWithValue("@IPAddress", obj.IPAddress);
            cmd.Parameters.AddWithValue("@LoginUserId", obj.LoginUserId);
            cmd.Parameters.Add("@Return", SqlDbType.NVarChar, 50).Value = "";
            cmd.Parameters["@Return"].Direction = ParameterDirection.Output;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            string Return = Convert.ToString(cmd.Parameters["@Return"].Value);

            return(Return);
        }
コード例 #2
0
        public string SeatUser_Update(SeatUser_Class obj)
        {
            string Return = objModels.SeatUser_Update(obj);

            return(Return);
        }