Пример #1
0
        public void UpdateAntenna(Antenna antenna)
        {
            try
            {
                SqlConnection cn = new SqlConnection(cnStr);

                cn.Open();
                SqlCommand sqlCommand = new SqlCommand("updateAntenna", cn);
                sqlCommand.CommandType = CommandType.StoredProcedure;

                ArrayList param = new ArrayList();
                param.Add(new SqlParameter("@Name", antenna.Name));
                param.Add(new SqlParameter("@Type", antenna.Type));
                param.Add(new SqlParameter("@MaxGain", antenna.MaxGain));
                param.Add(new SqlParameter("@Polarization", antenna.Polarization));
                param.Add(new SqlParameter("@ReceiverThreshold", antenna.RecieveThrehold));
                param.Add(new SqlParameter("@TransmisionLoss", antenna.TransmissionLoss));
                param.Add(new SqlParameter("@VSWR", antenna.VSWR));
                param.Add(new SqlParameter("@Temperature", antenna.Temperature));
                param.Add(new SqlParameter("@Radius", antenna.Radius));
                param.Add(new SqlParameter("@BlockageRadius", antenna.BlockageRadius));
                param.Add(new SqlParameter("@ApetureDistribution", antenna.ApertureDistribution));
                param.Add(new SqlParameter("@EdgeTeper", antenna.EdgeTeper));
                param.Add(new SqlParameter("@Length", antenna.Length));
                param.Add(new SqlParameter("@Pitch", antenna.Pitch));



                sqlCommand.Parameters.AddRange((SqlParameter[])param.ToArray(typeof(SqlParameter)));


                sqlCommand.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                LogFileManager.ObjLog.error(ex.Message);
                throw ex;
            }
        }
Пример #2
0
        public Antenna GetAntenna(string name)
        {
            SqlConnection cn      = new SqlConnection(cnStr);
            Antenna       antenna = null;

            try
            {
                cn.Open();
                SqlCommand sqlCommand = new SqlCommand("getAntenna", cn);
                sqlCommand.CommandType = CommandType.StoredProcedure;
                //add params
                SqlParameter param = new SqlParameter();
                param.ParameterName = "@Name";
                param.Value         = name;
                param.SqlDbType     = SqlDbType.NVarChar;
                param.Direction     = ParameterDirection.Input;
                sqlCommand.Parameters.Add(param);

                SqlDataReader myDataReader = sqlCommand.ExecuteReader();
                if (myDataReader.Read())
                {
                    string type              = myDataReader.GetString(1);
                    double maxGain           = myDataReader.GetDouble(2);
                    double receiverThreshold = myDataReader.GetDouble(4);
                    double transmissionLoss  = myDataReader.GetDouble(5);
                    double vswr              = myDataReader.GetDouble(6);
                    double temperature       = myDataReader.GetDouble(7);
                    string polarization      = null;
                    if (!myDataReader.IsDBNull(3))
                    {
                        polarization = myDataReader.GetString(3);
                    }
                    double?radius = null;
                    if (!myDataReader.IsDBNull(8))
                    {
                        radius = myDataReader.GetDouble(8);
                    }
                    double?blockageRadius = null;
                    if (!myDataReader.IsDBNull(9))
                    {
                        blockageRadius = myDataReader.GetDouble(9);
                    }
                    string apertureDistribution = null;
                    if (!myDataReader.IsDBNull(10))
                    {
                        apertureDistribution = myDataReader.GetString(10);
                    }
                    double?edgeTeper = null;
                    if (!myDataReader.IsDBNull(11))
                    {
                        edgeTeper = myDataReader.GetDouble(11);
                    }
                    double?length = null;
                    if (!myDataReader.IsDBNull(12))
                    {
                        length = myDataReader.GetDouble(12);
                    }
                    double?pitch = null;
                    if (!myDataReader.IsDBNull(13))
                    {
                        pitch = myDataReader.GetDouble(13);
                    }

                    antenna = new Antenna(name, type, maxGain, receiverThreshold, transmissionLoss, vswr, temperature,
                                          polarization, radius, blockageRadius, apertureDistribution, edgeTeper, length, pitch);
                }

                return(antenna);
            }
            catch (SqlException ex)
            {
                LogFileManager.ObjLog.error(ex.Message);
                return(null);

                throw ex;
            }
            finally
            {
                cn.Close();
            }
        }