Exemplo n.º 1
0
        public void ParamsCanBeModifiedAsNeeded()
        {
            // Arrange
            train F_train = new train("F Train");
            train N_train = new train("N Train");
            train R_train = new train("R Train");
            train V_train = new train("V Train");

            List <train> KingsHighwayTrains = new List <train> {
                F_train
            };
            List <train> ThirtyFourthStreetTrains = new List <train> {
                F_train, N_train, R_train
            };

            station KingsHighway       = new station("Kings Highway", KingsHighwayTrains);
            station ThirtyFourthStreet = new station("34th Street", ThirtyFourthStreetTrains);

            //Act
            ThirtyFourthStreet.SetName("ThirtyFourth Street");
            List <train> KingsHighwayTrainsAdapted = new List <train> {
                F_train, V_train
            };

            KingsHighway.SetAssociatedTrains(KingsHighwayTrainsAdapted);

            // Assert
            Assert.NotEqual(ThirtyFourthStreet.GetName(), "34th Street");
            Assert.Equal(ThirtyFourthStreet.GetName(), "ThirtyFourth Street");
            Assert.NotEqual(KingsHighway.GetAssociatedTrains().Count, 1);
            Assert.Equal(KingsHighway.GetAssociatedTrains().Count, 2);
            Assert.Equal(KingsHighway.GetAssociatedTrains()[0], F_train);
            Assert.Equal(KingsHighway.GetAssociatedTrains()[1], V_train);
        }
Exemplo n.º 2
0
 public ActionResult Create(FormCollection collection, station station)
 {
     try
     {
         var newStation = db.stations.Where(a => a.nameStation.Equals(station.nameStation)).FirstOrDefault();
         if (newStation == null)
         {
             db.stations.Add(station);
             db.SaveChanges();
             Session.Add("message", "Station added successfully");
             Session["error"]        = null;
             Session["notification"] = null;
             return(RedirectToAction("Index"));
         }
         else
         {
             Session.Add("error", "This station already exists!");
             Session["message"]      = null;
             Session["notification"] = null;
             return(RedirectToAction("Create"));
         }
     }
     catch (Exception ex)
     {
         Session["error"] = ex.Message;
         return(View());
     }
 }
 // GET: stations
 public ActionResult Index(station st)
 {
     int stationid = (int)Session["StationId"];
     Programme[] programes = db.Programmes.Where(c => c.stationId == stationid).ToArray();
     ViewBag.programmes = programes;
     return View("Index");
 }
Exemplo n.º 4
0
        static void FindStartOfTour(station[] stations)
        {
            if (stations == null || stations.Length < 2)
                return;

            int cur_gas = stations[0].gas - stations[0].dist;   //add first gas station to the tour
            int start = 0, end = 1;

            while (start != end || cur_gas < 0)
            {
                while (cur_gas < 0 && start != end) //if gas is < 0 and tour is still on, then remove this station from the tour
                {
                    cur_gas -= stations[start].gas - stations[start].dist;
                    start = (start + 1) % stations.Length;  //increment gas (circular array)

                    if (start == 0)
                        return; //if we came back to 1st station, then a tour cannot be formed
                }

                cur_gas += stations[end].gas - stations[end].dist;
                end = (end + 1) % stations.Length;
            }

            Console.WriteLine("Start = {0}\nEnd = {1}", start, end);
        }
Exemplo n.º 5
0
        public void IsDefinedProperly()
        {
            // Arrange
            train F_train = new train("F Train");
            train N_train = new train("N Train");
            train R_train = new train("R Train");

            List <train> KingsHighwayTrains = new List <train> {
                F_train
            };
            List <train> ThirtyFourthStreetTrains = new List <train> {
                F_train, N_train, R_train
            };

            station KingsHighway       = new station("Kings Highway", KingsHighwayTrains);
            station ThirtyFourthStreet = new station("34th Street", ThirtyFourthStreetTrains);

            // Assert
            Assert.Equal(KingsHighway.GetName(), "Kings Highway");
            Assert.Equal(ThirtyFourthStreet.GetName(), "34th Street");
            Assert.Equal(KingsHighway.GetAssociatedTrains()[0], F_train);
            Assert.Equal(KingsHighway.GetAssociatedTrains().Count, 1);
            Assert.Equal(ThirtyFourthStreet.GetAssociatedTrains()[0], F_train);
            Assert.Equal(ThirtyFourthStreet.GetAssociatedTrains()[1], N_train);
            Assert.Equal(ThirtyFourthStreet.GetAssociatedTrains()[2], R_train);
            Assert.Equal(ThirtyFourthStreet.GetAssociatedTrains().Count, 3);
        }
Exemplo n.º 6
0
 public ActionResult Edit(int id, FormCollection collection, station newStation)
 {
     try
     {
         station station = db.stations.Single(i => i.idStation == id);
         if (db.stations.Where(i => i.nameStation == newStation.nameStation && i.idStation != newStation.idStation &&
                               i.stateR == true).FirstOrDefault() == null)
         {
             UpdateModel(station);
             db.SaveChanges();
             Session.Add("message", "Station updated successfully");
             Session["error"]        = null;
             Session["notification"] = null;
             return(RedirectToAction("Index"));
         }
         else
         {
             Session.Add("error", "A station with the same name alreaddy exists!");
             Session["message"]      = null;
             Session["notification"] = null;
             return(RedirectToAction("Edit", id));
         }
     }
     catch
     {
         return(View());
     }
 }
Exemplo n.º 7
0
        public JsonResult GetDocsByStation(int idStation) //Obtiene la lista de documentos por estacion para mostrarlos
        {
            db.Configuration.ProxyCreationEnabled = false;
            StationExt result = new StationExt();

            result.glacier         = new glacier();
            result.measurementType = new measurementType();
            station         aux  = db.stations.Include("glacier").Single(x => x.idStation == idStation);
            glacier         gaxu = db.glaciers.Single(i => i.idGlacier == aux.idGlacier);
            measurementType maxu = db.measurementTypes.Single(i => i.idMeasurementType == aux.idMeasurementType);
            var             docs = db.enteredDatas.Where(x => x.idStation == idStation && x.stateR == true).Select(p => new EnteredDataSimplify
            {
                idDoc     = p.idEnteredData,
                idStation = p.idStation,
                name      = p.nameEnteredData,
                startDate = p.startDate.ToString(),
                endDate   = p.endDate.ToString()
            }).ToList();

            result.docs                   = docs;
            result.nameStation            = aux.nameStation;
            result.latitudeStation        = aux.latitudeStation;
            result.longitudeStation       = aux.longitudeStation;
            result.altitudeStation        = aux.altitudeStation;
            result.glacier.nameGlacier    = gaxu.nameGlacier;
            result.measurementType.nameMT = maxu.nameMT;
            result.location               = aux.location;

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Exemplo n.º 8
0
        /// <summary>
        /// update
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public int update(ref station obj)
        {
            using (NpgsqlDBConnection db = new NpgsqlDBConnection())
            {
                try
                {
                    if (db.open_connection())
                    {
                        string sql_command = "UPDATE stations set  " +
                                             " socket_port = :socket_port, station_name =:station_name, " +
                                             " station_id =:station_id," +
                                             " ftpserver =:ftpserver, ftpusername=:ftpusername," +
                                             " ftppassword =:ftppassword, ftpfolder=:ftpfolder," +
                                             " ftpflag =:ftpflag," +
                                             " modified = :modified " +
                                             //" goip = :goip " +
                                             " where id = :id";

                        using (NpgsqlCommand cmd = db._conn.CreateCommand())
                        {
                            cmd.CommandText = sql_command;

                            cmd.Parameters.Add(":socket_port", NpgsqlTypes.NpgsqlDbType.Integer).Value  = obj.socket_port;
                            cmd.Parameters.Add(":station_name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.station_name;
                            cmd.Parameters.Add(":station_id", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.station_id;
                            cmd.Parameters.Add(":modified", NpgsqlTypes.NpgsqlDbType.Timestamp).Value   = obj.modified;

                            cmd.Parameters.Add(":ftpserver", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.ftpserver;
                            cmd.Parameters.Add(":ftpusername", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.ftpusername;
                            cmd.Parameters.Add(":ftppassword", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.ftppassword;
                            cmd.Parameters.Add(":ftpfolder", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.ftpfolder;
                            cmd.Parameters.Add(":ftpflag", NpgsqlTypes.NpgsqlDbType.Integer).Value     = obj.ftpflag;

                            //cmd.Parameters.Add(":goip", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.goip;

                            cmd.Parameters.Add(":id", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.id;

                            cmd.ExecuteNonQuery();

                            db.close_connection();
                            return(obj.id);
                        }
                    }
                    else
                    {
                        db.close_connection();
                        return(-1);
                    }
                }
                catch
                {
                    if (db != null)
                    {
                        db.close_connection();
                    }
                    return(-1);
                }
            }
        }
Exemplo n.º 9
0
        public bool insertMeteorologicalData(int idDocument, string reader, station selectedStation)
        {
            try
            {
                string[] aux = null;
                aux = reader.Split(';').Where(x => !String.IsNullOrEmpty(x)).ToArray();
                meteorologicalData data = new meteorologicalData();
                var aux1 = aux[0].Split(' ');                                       //SEPARO LA FECHA DE LA HORA
                var aux2 = aux1[0].Split('/');                                      //SEPARO MES/DIA/AÑO EN LA FECHA PARA LUEGO CONVERTIR A DIA/MES/AÑO
                var auxF = aux2[1] + "/" + aux2[0] + "/" + aux2[2] + " " + aux1[1]; //CONVIERTO A DIA/MES/AÑO

                if (selectedStation.idLocation == 1)                                //Datos Meteorológicos dentro del glaciar
                {
                    //data.dateData = Convert.ToDateTime(aux[0]);
                    data.dateData              = Convert.ToDateTime(auxF);
                    data.inShortWaveRadiation  = (Math.Round((float.Parse(aux[1])), 3));
                    data.outShortWaveRadiation = (Math.Round((float.Parse(aux[2])), 3));
                    data.albedo                   = (Math.Round((float.Parse(aux[3])), 3));
                    data.relativeHumidity         = (Math.Round((float.Parse(aux[4])), 3));
                    data.ventilatedAirTemperature = (Math.Round((float.Parse(aux[5])), 3));
                    data.windSpeed                = (Math.Round((float.Parse(aux[6])), 3));
                    data.windDirection            = (Math.Round((float.Parse(aux[7])), 3));
                }
                else //Datos Meteorológicos fuera del glaciar
                {
                    //data.dateData = Convert.ToDateTime(aux[0]);
                    data.dateData              = Convert.ToDateTime(auxF);
                    data.inShortWaveRadiation  = (Math.Round((float.Parse(aux[1])), 3));
                    data.outShortWaveRadiation = (Math.Round((float.Parse(aux[2])), 3));
                    data.albedo = (Math.Round((float.Parse(aux[3])), 3));
                    data.inLongWaveRadiation         = (Math.Round((float.Parse(aux[4])), 3));
                    data.outLongWaveRadiation        = (Math.Round((float.Parse(aux[5])), 3));
                    data.relativeHumidity            = (Math.Round((float.Parse(aux[6])), 3));
                    data.ventilatedAirTemperature    = (Math.Round((float.Parse(aux[7])), 3));
                    data.nonVentilatedAirTemperature = (Math.Round((float.Parse(aux[8])), 3));
                    data.windSpeed           = (Math.Round((float.Parse(aux[9])), 3));
                    data.windDirection       = (Math.Round((float.Parse(aux[10])), 3));
                    data.precipitationAmount = (Math.Round((float.Parse(aux[11])), 3));
                    data.precipitationRate   = (Math.Round((float.Parse(aux[12])), 3));
                    data.distanceSensor_Snow = (Math.Round((float.Parse(aux[13])), 3));
                    data.snowDepth           = (Math.Round((float.Parse(aux[14])), 3));
                    data.groundFlux          = (Math.Round((float.Parse(aux[15])), 3));
                    data.groundTemp_3cm      = (Math.Round((float.Parse(aux[16])), 3));
                    data.groundTemp_10cm     = (Math.Round((float.Parse(aux[17])), 3));
                    data.groundTemp_30cm     = (Math.Round((float.Parse(aux[18])), 3));
                }
                data.idEnteredData = idDocument;
                db.meteorologicalDatas.Add(data);
                db.SaveChanges();
                return(true);
            }
            catch
            {
                return(false);
            }
        }
Exemplo n.º 10
0
        // GET: stations/Delete/5
        public ActionResult Delete(int id)
        {
            station station = db.stations.Single(i => i.idStation == id);

            station.stateR = false;
            db.SaveChanges();
            Session.Add("message", "Station desactivated successfully");
            Session["error"]        = null;
            Session["notification"] = null;
            return(RedirectToAction("Index"));
        }
Exemplo n.º 11
0
 public void loadUpgrades()
 {
     station = GameObject.FindGameObjectWithTag("Base").GetComponent <station>();
     if (station.upgradesUsed.Contains(0))
     {
         GameObject.Find("pause").GetComponent <menu>().setHangerActive();
     }
     if (station.upgradesUsed.Contains(1))
     {
         GameObject.Find("pause").GetComponent <menu>().setStationActive();
     }
 }
Exemplo n.º 12
0
    private void loadBase(SceneLoader scene)
    {
        station = scene.loadBase().GetComponent <station>();

        BinaryFormatter bf     = new BinaryFormatter();
        FileStream      input  = File.Open(Application.persistentDataPath + "/" + sceneName + "/Sectors/base.dat", FileMode.OpenOrCreate);
        Base            sector = (Base)bf.Deserialize(input);

        station.molH         = sector.molH;
        station.upgradesUsed = sector.upgrades;
        station.upgrades     = sector.upgradeVals;
        expandMol();
    }
        // GET: stations/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            station station = db.stations.Find(id);

            if (station == null)
            {
                return(HttpNotFound());
            }
            return(View(station));
        }
Exemplo n.º 14
0
 // Use this for initialization
 void Start()
 {
     ship    = GameObject.FindGameObjectWithTag("Player").GetComponent <Controller>();
     Stat    = GameObject.FindGameObjectWithTag("Base").GetComponent <station>();
     hanger  = Stat.hanger;
     station = Stat.science;
     texTemp = new Texture2D(64, 32);
     //I need to delete this before I actually use this menu will nt show anything as of right now
     upgrades = new string[loadData.data.stationUpgrades.Length];
     for (int i = 0; i < loadData.data.stationUpgrades.Length; i++)
     {
         upgrades[i] = loadData.data.stationUpgrades[i].upgradeName;
     }
     loadData.data.loadUpgrades();
 }
Exemplo n.º 15
0
    // Use this for initialization
    void Start()
    {
        sceneLoader   = GameObject.Find("SceneLoader").GetComponent <SceneLoader>();
        stationScript = GameObject.Find("station(Clone)").GetComponent <station>();
        ship          = GameObject.FindGameObjectWithTag("Player").GetComponent <Controller>();

        system   = transform.GetChild(0).GetComponent <Text>();
        distance = transform.GetChild(1).GetComponent <Text>();
        station  = transform.GetChild(2).GetComponent <Text>();
        hydrogen = transform.GetChild(4).GetComponent <Text>();

        system.text   = "System:\nBDMSC - " + sceneLoader.seed;
        distance.text = "Distance from Sol: " + sceneLoader.seed;
        station.text  = "Hydrogen of\nStation: " + stationScript.molH;
        hydrogen.text = "(" + ship.hydrogen + ")";
    }
Exemplo n.º 16
0
        static void Main(string[] args)
        {
            int[,] mat = {
                         {6, 4},
                         {0, 6},
                         {7, 3}
                         };
            station[] stations = new station[mat.GetLength(0)];

            for (int i = 0; i < mat.GetLength(0); i++)
            {
                stations[i] = new station(mat[i, 0], mat[i, 1]);
            }

            FindStartOfTour(stations);
            Console.ReadLine();
        }
Exemplo n.º 17
0
        /// <summary>
        /// get info by id
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public station get_info_by_id(int id)
        {
            using (NpgsqlDBConnection db = new NpgsqlDBConnection())
            {
                try
                {
                    station obj = null;
                    if (db.open_connection())
                    {
                        string sql_command = "SELECT * FROM stations WHERE id = " + id;
                        sql_command += " LIMIT 1";
                        using (NpgsqlCommand cmd = db._conn.CreateCommand())
                        {
                            cmd.CommandText = sql_command;

                            NpgsqlDataReader reader = cmd.ExecuteReader();

                            while (reader.Read())
                            {
                                obj = new station();
                                obj = (station)_get_info(reader);
                                break;
                            }
                            reader.Close();
                            db.close_connection();
                            return(obj);
                        }
                    }
                    else
                    {
                        db.close_connection();
                        return(null);
                    }
                }
                catch
                {
                    if (db != null)
                    {
                        db.close_connection();
                    }
                    return(null);
                }
                finally
                { db.close_connection(); }
            }
        }
Exemplo n.º 18
0
    //switch current station to the new station
    public void SwitchStation(station newStation)
    {
        print(newStation.ToString());
        currentStation = newStation;

        switch (newStation)
        {
        case station.crafting: Crafting();
            break;

        case station.packaging: Packaging();
            break;

        case station.sorting: Sorting();
            break;
        }
    }
Exemplo n.º 19
0
        public void bindData()
        {
            station            mStation   = mCurrentMonitorLb.Tag as station;
            List <sat>         mSatGPS    = MainForm.SatList.Where(p => p.sId == mStation.sId && p.sPrn < 30).ToList();
            List <sat>         mSatGLO    = MainForm.SatList.Where(p => p.sId == mStation.sId && p.sPrn > 30 && p.sPrn < 60).ToList();
            List <sat>         mSatBD     = MainForm.SatList.Where(p => p.sId == mStation.sId && p.sPrn > 60).ToList();
            List <SeriesPoint> mPointsGPS = new List <SeriesPoint>();
            List <SeriesPoint> mPointsGLO = new List <SeriesPoint>();
            List <SeriesPoint> mPointsBD  = new List <SeriesPoint>();

            foreach (var sat in mSatGPS)
            {
                SeriesPoint point = new DevExpress.XtraCharts.SeriesPoint(sat.sAzm, sat.sElev);
                point.Tag = sat.sPrn;
                mPointsGPS.Add(point);
            }
            foreach (var sat in mSatGLO)
            {
                SeriesPoint point = new DevExpress.XtraCharts.SeriesPoint(sat.sAzm, sat.sElev);
                point.Tag = sat.sPrn;
                mPointsGLO.Add(point);
            }
            foreach (var sat in mSatBD)
            {
                SeriesPoint point = new DevExpress.XtraCharts.SeriesPoint(sat.sAzm, sat.sElev);
                point.Tag = sat.sPrn;
                mPointsBD.Add(point);
            }
            mXkt.SetPoints(mPointsGPS, mPointsGLO, mPointsBD);

            List <sat>         mSatXZB     = MainForm.SatList.Where(p => p.sId == mStation.sId).ToList();
            List <SeriesPoint> mPointsXZB1 = new List <SeriesPoint>();
            List <SeriesPoint> mPointsXZB2 = new List <SeriesPoint>();

            foreach (var sat in mSatXZB)
            {
                SeriesPoint point1 = new DevExpress.XtraCharts.SeriesPoint(sat.sPrn, sat.sL1);
                SeriesPoint point2 = new DevExpress.XtraCharts.SeriesPoint(sat.sPrn, sat.sL2);
                point1.Tag = sat.sPrn;
                point2.Tag = sat.sPrn;
                mPointsXZB1.Add(point1);
                mPointsXZB2.Add(point2);
            }
            mXzb.SetPoints(mPointsXZB1, mPointsXZB2);
        }
Exemplo n.º 20
0
        // GET: stations/Details/5
        public ActionResult Details(int?id)
        {
            Session["error"]        = null;
            Session["notification"] = null;
            Session["message"]      = null;

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            station station = db.stations.Single(i => i.idStation == id);

            if (station == null)
            {
                return(HttpNotFound());
            }
            return(View(station));
        }
Exemplo n.º 21
0
        /// <summary>
        /// Get all
        /// </summary>
        /// <returns></returns>
        public IEnumerable <station> get_all()
        {
            List <station> listUser = new List <station>();

            using (NpgsqlDBConnection db = new NpgsqlDBConnection())
            {
                try
                {
                    if (db.open_connection())
                    {
                        string sql_command = "SELECT * FROM stations";
                        using (NpgsqlCommand cmd = db._conn.CreateCommand())
                        {
                            cmd.CommandText = sql_command;
                            NpgsqlDataReader reader = cmd.ExecuteReader();
                            while (reader.Read())
                            {
                                station obj = new station();
                                obj = (station)_get_info(reader);
                                listUser.Add(obj);
                            }
                            reader.Close();
                            db.close_connection();
                            return(listUser);
                        }
                    }
                    else
                    {
                        db.close_connection();
                        return(null);
                    }
                }
                catch
                {
                    if (db != null)
                    {
                        db.close_connection();
                    }
                    return(null);
                }
                finally
                { db.close_connection(); }
            }
        }
Exemplo n.º 22
0
 private void OnTriggerEnter(UnityEngine.Collider other)
 {
     thing = other.gameObject;
     if (other.tag.Equals("Planet"))
     {
         plan     = other.GetComponent <planet>();
         draining = true;
     }
     else if (other.name.Equals("Star"))
     {
         plan     = other.GetComponent <star>();
         draining = true;
     }
     else if (other.gameObject.tag.Equals("Base"))
     {
         draining     = false;
         station      = other.GetComponent <station>();
         transferring = true;
     }
 }
Exemplo n.º 23
0
        private void bindData()
        {
            Thread mLoadThread = new Thread(new ThreadStart(delegate
            {
                this.Invoke((EventHandler) delegate
                {
                    MainForm.ShowLoading();
                    resetDiagramScroll(DateTime.Now, DateTime.Now.AddDays(-1));
                });

                string mMonitor  = mCurrentMonitorLb.Text;
                station mStation = mCurrentMonitorLb.Tag as station;

                int mTopN  = 24;
                int mStyle = 2;

                switch (mCurrentTimeLb.Text)
                {
                case "月":
                    mTopN  = mCurrentTypeLb.Text == "历史曲线" ? 36 : 12;
                    mStyle = 4;
                    break;

                case "小时":
                    mTopN  = mCurrentTypeLb.Text == "历史曲线" ? 720 : 24;
                    mStyle = 2;
                    break;

                default:
                    mTopN  = mCurrentTypeLb.Text == "历史曲线" ? 365 : 31;
                    mStyle = 3;
                    break;
                }


                IList <DEVICE_STATUS_CLEAN> mStatusList = DEVICE_STATUS_CLEANDao.QueryTopForList(mStation.sCoorName, mTopN, new DEVICE_STATUS_CLEAN()
                {
                    Style = mStyle
                });
                List <SeriesPoint> mSeriesPointList0 = new List <SeriesPoint>();
                List <SeriesPoint> mSeriesPointList1 = new List <SeriesPoint>();
                double mTotalWy = 0, mLjWy = 0, mTotalCj = 0, mLjCj = 0;
                foreach (var status in mStatusList)
                {
                    status.Dx = mCurrentTypeLb.Text == "速度趋势" ? status.XSpeed * 1000 : status.X * 1000;
                    status.Dh = mCurrentTypeLb.Text == "速度趋势" ? status.Hspeed * 1000 : status.Height * 1000;
                    if (Math.Abs(status.Dx) > 4 || Math.Abs(status.Dx) < 0.1)
                    {
                        status.Dx = 0;
                    }
                    if (Math.Abs(status.Dh) > 4 || Math.Abs(status.Dh) < 0.1)
                    {
                        status.Dh = 0;
                    }
                    mTotalWy = mTotalWy + Math.Abs(status.Dx);
                    mTotalCj = mTotalCj + Math.Abs(status.Dh);
                    mLjWy    = mLjWy + status.Dx;
                    mLjCj    = mLjCj + status.Dh;
                    mSeriesPointList0.Add(new SeriesPoint(status.aDatetime.Value, status.Dx));
                    mSeriesPointList1.Add(new SeriesPoint(status.aDatetime.Value, status.Dh));
                }

                //当选择的时间改变时,更新Grid列表
                if (mCurrentQueryStyle != mStyle)
                {
                    mCurrentQueryStyle = mStyle;
                    mJcdList.Clear();
                    if (mCurrentTypeLb.Text == "历史曲线")
                    {
                        switch (mStyle)
                        {
                        case 2:
                            mTopN = 24;
                            break;

                        case 3:
                            mTopN = 12;
                            break;

                        case 4:
                            mTopN = 31;
                            break;

                        default:
                            break;
                        }
                    }
                    foreach (var station in MainForm.StationList)
                    {
                        mStatusList = DEVICE_STATUS_CLEANDao.QueryTopForList(station.sCoorName, mTopN, new DEVICE_STATUS_CLEAN()
                        {
                            Style = mStyle
                        });
                        mTotalWy = 0;
                        mLjWy    = 0;
                        mTotalCj = 0;
                        mLjCj    = 0;
                        foreach (var status in mStatusList)
                        {
                            status.Dx = status.X * 1000;
                            status.Dh = status.Height * 1000;
                            if (Math.Abs(status.Dx) > 4 || Math.Abs(status.Dx) < 0.1)
                            {
                                status.Dx = 0;
                            }
                            if (Math.Abs(status.Dh) > 4 || Math.Abs(status.Dh) < 0.1)
                            {
                                status.Dh = 0;
                            }
                            mTotalWy = mTotalWy + Math.Abs(status.Dx);
                            mTotalCj = mTotalCj + Math.Abs(status.Dh);
                            mLjWy    = mLjWy + status.Dx;
                            mLjCj    = mLjCj + status.Dh;
                        }
                        if (mStatusList.Count > 0)
                        {
                            var first = mStatusList.First();
                            var last  = mStatusList.Last();
                            Jcd jcd   = new Jcd();
                            jcd.BH    = station.sName;
                            jcd.BW    = "坝顶\n108\n高程";
                            jcd.Scgc  = station.Sh + first.Dh;
                            jcd.Bcgc1 = station.Sh + last.Dh;
                            jcd.Ljcx  = mLjCj;
                            jcd.Scds  = first.Dx;
                            jcd.Bcgc2 = last.Dx;
                            jcd.Ljwy  = mLjWy;
                            mJcdList.Add(jcd);
                        }
                    }
                }

                this.Invoke((EventHandler) delegate
                {
                    MainForm.HideLoading();
                    this.mainChart.Series[0].Points.Clear();
                    this.mainChart.Series[1].Points.Clear();
                    if (mStatusList.Count > 0)
                    {
                        this.mainChart.Series[0].Points.AddRange(mSeriesPointList0.ToArray());
                        this.mainChart.Series[1].Points.AddRange(mSeriesPointList1.ToArray());
                        this.lblSswy.Text = "位移:" + mStatusList[0].Dx.ToString("F2").PadLeft(2, ' ') + "mm";
                        this.lblSscj.Text = "沉降:" + mStatusList[0].Dh.ToString("F2").PadLeft(2, ' ') + "mm";
                        this.lblTjwy.Text = string.Format("平均位移:{0}mm    累计位移:{1}mm", (mTotalWy / mStatusList.Count).ToString("F2").PadLeft(3, ' '), mLjWy.ToString("F2").PadLeft(3, ' '));
                        this.lblTjcj.Text = string.Format("平均沉降:{0}mm    累计沉降:{1}mm", (mTotalCj / mStatusList.Count).ToString("F2").PadLeft(3, ' '), mLjCj.ToString("F2").PadLeft(3, ' '));
                        resetDiagramScroll(mStatusList[0].aDatetime.Value, mStatusList[mStatusList.Count - 1].aDatetime.Value);
                    }
                    gcMain.DataSource = mJcdList;
                    gvMain.RefreshData();
                });
            }));

            mLoadThread.Start();
        }
Exemplo n.º 24
0
        private void refreshDataForControl()
        {
            // get all comport name from computer.
            string[] availableComportList;
            availableComportList = SerialPort.GetPortNames();
            module_repository    modules          = new module_repository();
            IEnumerable <module> moduleConfigList = modules.get_all();

            MODULE_CONFIG_LIST = moduleConfigList.Select(x => x.item_name).ToArray();

            if (availableComportList.Length <= 0)
            {
                MessageBox.Show(lang.getText("available_port_null"));
                //this.Close();
                //return;
            }
            // check station info setting
            station existedStationsSetting = new station_repository().get_info();

            if (existedStationsSetting == null)
            {
                existedStationsSetting = new station();
                if (new station_repository().add(ref existedStationsSetting) > 0)
                {
                    // insert ok to database
                }
                else
                {
                    MessageBox.Show(lang.getText("system_error"));
                    return;
                }
            }
            else
            {
                // set data to control from existed station setting
                txtStationName.Text = existedStationsSetting.station_name;
                txtStationID.Text   = existedStationsSetting.station_id;
                txtSocketPort.Text  = existedStationsSetting.socket_port.ToString();
                if (isOpen(existedStationsSetting.socket_port))
                {
                    this.btnSOCKET.Image = global::DataLogger.Properties.Resources.ON_switch_96x25;
                    btnShow.Enabled      = true;
                }
                else
                {
                    this.btnSOCKET.Image = global::DataLogger.Properties.Resources.OFF_switch_96x25;
                    btnShow.Enabled      = false;
                }
                var sortComportList = availableComportList.OrderBy(port => Convert.ToInt32(port.Replace("COM", string.Empty)));
                int selectedIndex   = 0;
                cbModule.Items.Clear();

                var1Module.Items.Clear();
                var2Module.Items.Clear();
                var3Module.Items.Clear();
                var4Module.Items.Clear();
                var5Module.Items.Clear();
                var6Module.Items.Clear();
                foreach (string itemAvailableComportName in sortComportList)
                {
                    cbModule.Items.Add(itemAvailableComportName);


                    if (existedStationsSetting.module_comport == itemAvailableComportName)
                    {
                        cbModule.SelectedIndex = selectedIndex;
                    }

                    selectedIndex = selectedIndex + 1;
                }
            }

            foreach (string itemModuleID in MODULE_ID_LIST)
            {
                var1Module.Items.Add(itemModuleID);
                var2Module.Items.Add(itemModuleID);
                var3Module.Items.Add(itemModuleID);
                var4Module.Items.Add(itemModuleID);
                var5Module.Items.Add(itemModuleID);
                var6Module.Items.Add(itemModuleID);
                var7Module.Items.Add(itemModuleID);
                var8Module.Items.Add(itemModuleID);
                var9Module.Items.Add(itemModuleID);
                var10Module.Items.Add(itemModuleID);
                var11Module.Items.Add(itemModuleID);
                var12Module.Items.Add(itemModuleID);
                var13Module.Items.Add(itemModuleID);
                var14Module.Items.Add(itemModuleID);
                var15Module.Items.Add(itemModuleID);
                var16Module.Items.Add(itemModuleID);
                var17Module.Items.Add(itemModuleID);
                var18Module.Items.Add(itemModuleID);
            }

            IEnumerable <module> moduleConfigurationList = checkAndInsertModuleConfiguration();

            foreach (module itemModuleSetting in moduleConfigurationList)
            {
                displayModuleSetting(itemModuleSetting);
            }
        }
Exemplo n.º 25
0
 public static object Insert(station t)
 {
     return(BaseDA.Insert <station>("Insertstation", t));
 }
Exemplo n.º 26
0
        public ActionResult Register(Register regdata)
        {

            var x = db.stations.Where(m => m.name.Equals(regdata.RadioStation.Name) || m.frequency.Equals(regdata.RadioStation.Frequency)).ToArray();

            if (x.Any())
            {
                ModelState.AddModelError("", "Station alredy exists");
                return View(regdata);
            }
            else {
                byte[] uploadedFile = new byte[regdata.RadioStation.Logo.InputStream.Length];
                regdata.RadioStation.Logo.InputStream.Read(uploadedFile, 0, uploadedFile.Length);


                Image img = Image.FromStream(regdata.RadioStation.Logo.InputStream);
                MemoryStream ms = new MemoryStream();

                if (img.RawFormat.Equals(System.Drawing.Imaging.ImageFormat.Jpeg))
                {
                    img.Save(ms, ImageFormat.Jpeg);
                }
                else if (img.RawFormat.Equals(System.Drawing.Imaging.ImageFormat.Gif))
                {
                    img.Save(ms, ImageFormat.Gif);
                }
                else if (img.RawFormat.Equals(System.Drawing.Imaging.ImageFormat.Bmp))
                {
                    img.Save(ms, ImageFormat.Bmp);
                }
                else if (img.RawFormat.Equals(System.Drawing.Imaging.ImageFormat.Png))
                {
                    img.Save(ms, ImageFormat.Png);
                }

                try
                {
                    station temp = new station();
                    temp.approved = false;
                    temp.frequency = regdata.RadioStation.Frequency;
                    temp.name = regdata.RadioStation.Name;
                    temp.logo = ms.ToArray();

                    db.stations.Add(temp);
                    db.SaveChanges();
                    WebSecurity.CreateUserAndAccount(regdata.UserName, regdata.Password);
                    Roles.AddUserToRole(regdata.UserName, "StationAdmin");
                    

                    int StationId = db.stations.Where(m => m.name.Equals(temp.name)).First().id;
                    int userId = db.UserProfiles.Where(m => m.UserName.Equals(regdata.UserName)).First().UserId;

                    db.StationUsers.Add(new StationUser { StationId=StationId,UserId=userId});
                    db.SaveChanges();

                    return RedirectToAction("Index", "Home");

                }
                catch (System.Web.Security.MembershipCreateUserException ex)
                {
                    ModelState.AddModelError("", "Username alredy exists");
                    return View(regdata);
                }
            }
        }
Exemplo n.º 27
0
        static void Main(string[] args)
        {
            Dictionary <string, Dictionary <string, string> > terminiMasterList = new Dictionary <string, Dictionary <string, string> >();
            Dictionary <string, string> BlueLine_termini = new Dictionary <string, string>()
            {
                { "North", "Bowdoin" },
                { "South", "Wonderland" }
            };
            Dictionary <string, string> GreenLineB_termini = new Dictionary <string, string>()
            {
                { "West", "Boston College" },
                { "East", "Park Street" }
            };
            Dictionary <string, string> GreenLineC_termini = new Dictionary <string, string>()
            {
                { "West", "Cleveland Circle" },
                { "East", "North Station" }
            };
            Dictionary <string, string> GreenLineD_termini = new Dictionary <string, string>()
            {
                { "West", "Riverside" },
                { "East", "Government Center" }
            };
            Dictionary <string, string> GreenLineE_termini = new Dictionary <string, string>()
            {
                { "West", "Heath Street" },
                { "East", "Lechmere" }
            };
            Dictionary <string, string> OrangeLine_termini = new Dictionary <string, string>()
            {
                { "North", "Oak Grove" },
                { "South", "Forest Hills" }
            };
            Dictionary <string, string> RedLine1_termini = new Dictionary <string, string>()
            {
                { "West", "Alewife" },
                { "East", "Ashmont" }
            };
            Dictionary <string, string> RedLine2_termini = new Dictionary <string, string>()
            {
                { "West", "Alewife" },
                { "North", "Braintree" }
            };
            Dictionary <string, string> SilverLineSL1_termini = new Dictionary <string, string>()
            {
                { "West", "Alewife" },
                { "North", "Braintree" }
            };
            Dictionary <string, string> SilverLineSL2_termini = new Dictionary <string, string>()
            {
                { "West", "Alewife" },
                { "North", "Braintree" }
            };
            Dictionary <string, string> SilverLineSL3_termini = new Dictionary <string, string>()
            {
                { "West", "Alewife" },
                { "North", "Braintree" }
            };
            Dictionary <string, string> SilverLineSL4_termini = new Dictionary <string, string>()
            {
                { "West", "Alewife" },
                { "North", "Braintree" }
            };
            Dictionary <string, string> SilverLineSL5_termini = new Dictionary <string, string>()
            {
                { "West", "Alewife" },
                { "North", "Braintree" }
            };

            terminiMasterList.Add("BlueLine", BlueLine_termini);
            terminiMasterList.Add("GreenLineB", GreenLineB_termini);
            terminiMasterList.Add("GreenLineC", GreenLineC_termini);
            terminiMasterList.Add("GreenLineD", GreenLineD_termini);
            terminiMasterList.Add("GreenLineE", GreenLineE_termini);
            terminiMasterList.Add("OrangeLine", OrangeLine_termini);
            terminiMasterList.Add("RedLine1", RedLine1_termini);
            terminiMasterList.Add("RedLine2", RedLine2_termini);

            train BlueLine      = new train("Blue Line", BlueLine_termini);
            train GreenLineB    = new train("Green Line B", GreenLineB_termini);
            train GreenLineC    = new train("Green Line C", GreenLineC_termini);
            train GreenLineD    = new train("Green Line D", GreenLineD_termini);
            train GreenLineE    = new train("Green Line E", GreenLineE_termini);
            train OrangeLine    = new train("Orange Line", OrangeLine_termini);
            train RedLine1      = new train("Red Line", RedLine1_termini);
            train RedLine2      = new train("Red Line", RedLine2_termini);
            train SilverLineSl1 = new train("SilverLine SL1", SilverLineSL1_termini);
            train SilverLineSl2 = new train("SilverLine SL2", SilverLineSL2_termini);
            train SilverLineSl3 = new train("SilverLine SL3", SilverLineSL3_termini);
            train SilverLineSl4 = new train("SilverLine SL4", SilverLineSL4_termini);
            train SilverLineSl5 = new train("SilverLine SL5", SilverLineSL5_termini);

            List <train> ForestHillsTrains = new List <train> {
                OrangeLine
            };
            List <train> GreenStreetTrains = new List <train> {
                OrangeLine
            };
            List <train> StonyBrookTrains = new List <train> {
                OrangeLine
            };
            List <train> JacksonSquareTrains = new List <train> {
                OrangeLine
            };
            List <train> RoxburyCrossingTrains = new List <train> {
                OrangeLine
            };
            List <train> RugglesTrains = new List <train> {
                OrangeLine
            };
            List <train> MassachusettsAvenueTrains = new List <train> {
                OrangeLine
            };
            List <train> BackBayTrains = new List <train> {
                OrangeLine
            };
            List <train> TuftsMedicalCenterTrains = new List <train> {
                OrangeLine, SilverLineSl4, SilverLineSl5
            };
            List <train> ChinatownTrains = new List <train> {
                OrangeLine, SilverLineSl4, SilverLineSl5
            };
            List <train> DowntownCrossingTrains = new List <train> {
                OrangeLine, RedLine1, RedLine2
            };
            List <train> StateStreetTrains = new List <train> {
                OrangeLine, BlueLine
            };
            List <train> HaymarketTrains = new List <train> {
                OrangeLine, GreenLineC, GreenLineE
            };
            List <train> NorthStationTrains = new List <train> {
                OrangeLine, GreenLineC, GreenLineE
            };
            List <train> CommunityCollegeTrains = new List <train> {
                OrangeLine
            };
            List <train> SullivanSquareTrains = new List <train> {
                OrangeLine
            };
            List <train> AssemblyTrains = new List <train> {
                OrangeLine
            };
            List <train> WellingtonTrains = new List <train> {
                OrangeLine
            };
            List <train> MaldenCenterTrains = new List <train> {
                OrangeLine
            };
            List <train> OakGroveTrains = new List <train> {
                OrangeLine
            };
            List <train> BowdoinTrains = new List <train> {
                BlueLine
            };
            List <train> GovernmentCenterTrains = new List <train> {
                BlueLine, GreenLineC, GreenLineD, GreenLineE
            };
            List <train> AquariumTrains = new List <train> {
                BlueLine
            };
            List <train> MaverickTrains = new List <train> {
                BlueLine
            };
            List <train> AirportTrains = new List <train> {
                BlueLine
            };
            List <train> WoodIslandTrains = new List <train> {
                BlueLine
            };
            List <train> OrientHeightsTrains = new List <train> {
                BlueLine
            };
            List <train> SuffolkDownsTrains = new List <train> {
                BlueLine
            };
            List <train> BeachmontTrains = new List <train> {
                BlueLine
            };
            List <train> RevereBeachTrains = new List <train> {
                BlueLine
            };
            List <train> WonderlandTrains = new List <train> {
                BlueLine
            };

            station ForestHills         = new station("Forest Hills", ForestHillsTrains);
            station GreenStreet         = new station("Green Street", GreenStreetTrains);
            station StonyBrook          = new station("Stony Brook", StonyBrookTrains);
            station JacksonSquare       = new station("Jackson Square", JacksonSquareTrains);
            station RoxburyCrossing     = new station("RoxburyCrossing", RoxburyCrossingTrains);
            station Ruggles             = new station("Ruggles", RugglesTrains);
            station MassachusettsAvenue = new station("Massachusetts Avenue", MassachusettsAvenueTrains);
            station BackBay             = new station("Back Bay", BackBayTrains);
            station TuftsMedicalCenter  = new station("Tufts Medical Center", TuftsMedicalCenterTrains);
            station Chinatown           = new station("Chinatown", ChinatownTrains);
            station DowntownCrossing    = new station("Downtown Crossing", DowntownCrossingTrains);
            station StateStreet         = new station("State Street", StateStreetTrains);
            station Haymarket           = new station("Haymarket", HaymarketTrains);
            station NorthStation        = new station("North Station", NorthStationTrains);
            station CommunityCollege    = new station("Community College", CommunityCollegeTrains);
            station SullivanSquare      = new station("Sullivan Square", SullivanSquareTrains);
            station Assembly            = new station("Assembly", AssemblyTrains);
            station Wellington          = new station("Wellington", WellingtonTrains);
            station MaldenCenter        = new station("Malden Center", MaldenCenterTrains);
            station OakGrove            = new station("Oak Grove", OakGroveTrains);
            station Bowdoin             = new station("Bowdoin", BowdoinTrains);
            station GovernmentCenter    = new station("Government Center", GovernmentCenterTrains);
            station Aquarium            = new station("Aquarium", AquariumTrains);
            station Maverick            = new station("Maverick", MaverickTrains);
            station Airport             = new station("Airport", AirportTrains);
            station WoodIsland          = new station("Wood Island", WoodIslandTrains);
            station OrientHeights       = new station("Orient Heights", OrientHeightsTrains);
            station SuffolkDowns        = new station("Suffolk Downs", SuffolkDownsTrains);
            station Beachmont           = new station("Beachmont", BeachmontTrains);
            station RevereBeach         = new station("Revere Beach", RevereBeachTrains);
            station Wonderland          = new station("Wonderland", WonderlandTrains);


            List <station> OrangeLine_stations = new List <station>()
            {
                ForestHills, GreenStreet, StonyBrook, JacksonSquare, RoxburyCrossing, Ruggles,
                MassachusettsAvenue, BackBay, TuftsMedicalCenter, Chinatown, DowntownCrossing,
                StateStreet, Haymarket, NorthStation, CommunityCollege, SullivanSquare, Assembly,
                Wellington, MaldenCenter, OakGrove
            };

            List <station> BlueLine_stations = new List <station>()
            {
                Bowdoin, GovernmentCenter, StateStreet, Aquarium, Maverick, Airport, WoodIsland, OrientHeights,
                SuffolkDowns, Beachmont, RevereBeach, Wonderland
            };


            Dictionary <train, List <station> > StationList = new Dictionary <train, List <station> >()
            {
                { OrangeLine, OrangeLine_stations },
                { BlueLine, BlueLine_stations }
            };
        }
Exemplo n.º 28
0
        public ServiceManager(
            NodeContainer container, CacheStorage storage, Logger logger, TimerManager timerManager,
            BoundServiceManager boundServiceManager,
            machoNet machoNet,
            objectCaching objectCaching,
            alert alert,
            authentication authentication,
            character character,
            userSvc userSvc,
            charmgr charmgr,
            config config,
            dogmaIM dogmaIM,
            invbroker invbroker,
            warRegistry warRegistry,
            station station,
            map map,
            account account,
            skillMgr skillMgr,
            contractMgr contractMgr,
            corpStationMgr corpStationMgr,
            bookmark bookmark,
            LSC LSC,
            onlineStatus onlineStatus,
            billMgr billMgr,
            facWarMgr facWarMgr,
            corporationSvc corporationSvc,
            clientStatsMgr clientStatsMgr,
            voiceMgr voiceMgr,
            standing2 standing2,
            tutorialSvc tutorialSvc,
            agentMgr agentMgr,
            corpRegistry corpRegistry,
            marketProxy marketProxy,
            stationSvc stationSvc,
            certificateMgr certificateMgr,
            jumpCloneSvc jumpCloneSvc,
            LPSvc LPSvc,
            lookupSvc lookupSvc,
            insuranceSvc insuranceSvc,
            slash slash,
            ship ship,
            corpmgr corpmgr,
            repairSvc repairSvc,
            reprocessingSvc reprocessingSvc,
            ramProxy ramProxy,
            factory factory)
        {
            this.Container           = container;
            this.CacheStorage        = storage;
            this.BoundServiceManager = boundServiceManager;
            this.TimerManager        = timerManager;
            this.Logger = logger;
            this.Log    = this.Logger.CreateLogChannel("ServiceManager");

            // store all the services
            this.machoNet        = machoNet;
            this.objectCaching   = objectCaching;
            this.alert           = alert;
            this.authentication  = authentication;
            this.character       = character;
            this.userSvc         = userSvc;
            this.charmgr         = charmgr;
            this.config          = config;
            this.dogmaIM         = dogmaIM;
            this.invbroker       = invbroker;
            this.warRegistry     = warRegistry;
            this.station         = station;
            this.map             = map;
            this.account         = account;
            this.skillMgr        = skillMgr;
            this.contractMgr     = contractMgr;
            this.corpStationMgr  = corpStationMgr;
            this.bookmark        = bookmark;
            this.LSC             = LSC;
            this.onlineStatus    = onlineStatus;
            this.billMgr         = billMgr;
            this.facWarMgr       = facWarMgr;
            this.corporationSvc  = corporationSvc;
            this.clientStatsMgr  = clientStatsMgr;
            this.voiceMgr        = voiceMgr;
            this.standing2       = standing2;
            this.tutorialSvc     = tutorialSvc;
            this.agentMgr        = agentMgr;
            this.corpRegistry    = corpRegistry;
            this.marketProxy     = marketProxy;
            this.stationSvc      = stationSvc;
            this.certificateMgr  = certificateMgr;
            this.jumpCloneSvc    = jumpCloneSvc;
            this.LPSvc           = LPSvc;
            this.lookupSvc       = lookupSvc;
            this.insuranceSvc    = insuranceSvc;
            this.slash           = slash;
            this.ship            = ship;
            this.corpmgr         = corpmgr;
            this.repairSvc       = repairSvc;
            this.reprocessingSvc = reprocessingSvc;
            this.ramProxy        = ramProxy;
            this.factory         = factory;
        }
Exemplo n.º 29
0
        private station _get_info(NpgsqlDataReader dataReader)
        {
            station obj = new station();

            try
            {
                if (!DBNull.Value.Equals(dataReader["id"]))
                {
                    obj.id = Convert.ToInt32(dataReader["id"].ToString().Trim());
                }
                else
                {
                    obj.id = 0;
                }

                if (!DBNull.Value.Equals(dataReader["socket_port"]))
                {
                    obj.socket_port = Convert.ToInt32(dataReader["socket_port"].ToString().Trim());
                }
                else
                {
                    obj.socket_port = 0;
                }

                if (!DBNull.Value.Equals(dataReader["station_name"]))
                {
                    obj.station_name = dataReader["station_name"].ToString().Trim();
                }
                else
                {
                    obj.station_name = "";
                }
                if (!DBNull.Value.Equals(dataReader["station_id"]))
                {
                    obj.station_id = dataReader["station_id"].ToString().Trim();
                }
                else
                {
                    obj.station_id = "";
                }

                if (!DBNull.Value.Equals(dataReader["sampler_comport"]))
                {
                    obj.sampler_comport = dataReader["sampler_comport"].ToString().Trim();
                }
                else
                {
                    obj.sampler_comport = "";
                }
                if (!DBNull.Value.Equals(dataReader["module_comport"]))
                {
                    obj.module_comport = dataReader["module_comport"].ToString().Trim();
                }
                else
                {
                    obj.module_comport = "";
                }
                if (!DBNull.Value.Equals(dataReader["mps_comport"]))
                {
                    obj.mps_comport = dataReader["mps_comport"].ToString().Trim();
                }
                else
                {
                    obj.mps_comport = "";
                }
                if (!DBNull.Value.Equals(dataReader["tn_comport"]))
                {
                    obj.tn_comport = dataReader["tn_comport"].ToString().Trim();
                }
                else
                {
                    obj.tn_comport = "";
                }
                if (!DBNull.Value.Equals(dataReader["tp_comport"]))
                {
                    obj.tp_comport = dataReader["tp_comport"].ToString().Trim();
                }
                else
                {
                    obj.tp_comport = "";
                }
                if (!DBNull.Value.Equals(dataReader["toc_comport"]))
                {
                    obj.toc_comport = dataReader["toc_comport"].ToString().Trim();
                }
                else
                {
                    obj.toc_comport = "";
                }
                ////////////////////////////////////////////////////////////////////////////////////////////////////
                try
                {
                    if (!DBNull.Value.Equals(dataReader["modified"]))
                    {
                        obj.modified = Convert.ToDateTime(dataReader["modified"].ToString().Trim());
                    }
                    else
                    {
                        obj.modified = DateTime.Now;
                    }
                }
                catch (Exception ex) { }
                if (!DBNull.Value.Equals(dataReader["mps_protocol"]))
                {
                    obj.mps_protocol = Convert.ToInt32(dataReader["mps_protocol"].ToString().Trim());
                }
                else
                {
                    obj.mps_protocol = 0;
                }
                if (!DBNull.Value.Equals(dataReader["tn_protocol"]))
                {
                    obj.tn_protocol = Convert.ToInt32(dataReader["tn_protocol"].ToString().Trim());
                }
                else
                {
                    obj.tn_protocol = 0;
                }
                if (!DBNull.Value.Equals(dataReader["tp_protocol"]))
                {
                    obj.tp_protocol = Convert.ToInt32(dataReader["tp_protocol"].ToString().Trim());
                }
                else
                {
                    obj.tp_protocol = 0;
                }
                if (!DBNull.Value.Equals(dataReader["toc_protocol"]))
                {
                    obj.toc_protocol = Convert.ToInt32(dataReader["toc_protocol"].ToString().Trim());
                }
                else
                {
                    obj.toc_protocol = 0;
                }


                if (!DBNull.Value.Equals(dataReader["do1_caption"]))
                {
                    obj.do1_caption = dataReader["do1_caption"].ToString().Trim();
                }
                else
                {
                    obj.do1_caption = "";
                }
                if (!DBNull.Value.Equals(dataReader["do2_caption"]))
                {
                    obj.do2_caption = dataReader["do2_caption"].ToString().Trim();
                }
                else
                {
                    obj.do2_caption = "";
                }
                if (!DBNull.Value.Equals(dataReader["do3_caption"]))
                {
                    obj.do3_caption = dataReader["do3_caption"].ToString().Trim();
                }
                else
                {
                    obj.do3_caption = "";
                }
                if (!DBNull.Value.Equals(dataReader["do4_caption"]))
                {
                    obj.do4_caption = dataReader["do4_caption"].ToString().Trim();
                }
                else
                {
                    obj.do4_caption = "";
                }
                if (!DBNull.Value.Equals(dataReader["do5_caption"]))
                {
                    obj.do5_caption = dataReader["do5_caption"].ToString().Trim();
                }
                else
                {
                    obj.do5_caption = "";
                }
                if (!DBNull.Value.Equals(dataReader["do6_caption"]))
                {
                    obj.do6_caption = dataReader["do6_caption"].ToString().Trim();
                }
                else
                {
                    obj.do6_caption = "";
                }
                if (!DBNull.Value.Equals(dataReader["do7_caption"]))
                {
                    obj.do7_caption = dataReader["do7_caption"].ToString().Trim();
                }
                else
                {
                    obj.do7_caption = "";
                }
                if (!DBNull.Value.Equals(dataReader["do8_caption"]))
                {
                    obj.do8_caption = dataReader["do8_caption"].ToString().Trim();
                }
                else
                {
                    obj.do8_caption = "";
                }


                if (!DBNull.Value.Equals(dataReader["do1_caption_vi"]))
                {
                    obj.do1_caption_vi = dataReader["do1_caption_vi"].ToString().Trim();
                }
                else
                {
                    obj.do1_caption_vi = "";
                }
                if (!DBNull.Value.Equals(dataReader["do2_caption_vi"]))
                {
                    obj.do2_caption_vi = dataReader["do2_caption_vi"].ToString().Trim();
                }
                else
                {
                    obj.do2_caption_vi = "";
                }
                if (!DBNull.Value.Equals(dataReader["do3_caption_vi"]))
                {
                    obj.do3_caption_vi = dataReader["do3_caption_vi"].ToString().Trim();
                }
                else
                {
                    obj.do3_caption_vi = "";
                }
                if (!DBNull.Value.Equals(dataReader["do4_caption_vi"]))
                {
                    obj.do4_caption_vi = dataReader["do4_caption_vi"].ToString().Trim();
                }
                else
                {
                    obj.do4_caption_vi = "";
                }
                if (!DBNull.Value.Equals(dataReader["do5_caption_vi"]))
                {
                    obj.do5_caption_vi = dataReader["do5_caption_vi"].ToString().Trim();
                }
                else
                {
                    obj.do5_caption_vi = "";
                }
                if (!DBNull.Value.Equals(dataReader["do6_caption_vi"]))
                {
                    obj.do6_caption_vi = dataReader["do6_caption_vi"].ToString().Trim();
                }
                else
                {
                    obj.do6_caption_vi = "";
                }
                if (!DBNull.Value.Equals(dataReader["do7_caption_vi"]))
                {
                    obj.do7_caption_vi = dataReader["do7_caption_vi"].ToString().Trim();
                }
                else
                {
                    obj.do7_caption_vi = "";
                }
                if (!DBNull.Value.Equals(dataReader["do8_caption_vi"]))
                {
                    obj.do8_caption_vi = dataReader["do8_caption_vi"].ToString().Trim();
                }
                else
                {
                    obj.do8_caption_vi = "";
                }
                //////////////////////////////////////////////////////////////////////////////////////////////////
                if (!DBNull.Value.Equals(dataReader["ftpserver"]))
                {
                    obj.ftpserver = dataReader["ftpserver"].ToString().Trim();
                }
                else
                {
                    obj.ftpserver = "";
                }

                if (!DBNull.Value.Equals(dataReader["ftpusername"]))
                {
                    obj.ftpusername = dataReader["ftpusername"].ToString().Trim();
                }
                else
                {
                    obj.ftpusername = "";
                }

                if (!DBNull.Value.Equals(dataReader["ftppassword"]))
                {
                    obj.ftppassword = dataReader["ftppassword"].ToString().Trim();
                }
                else
                {
                    obj.ftppassword = "";
                }

                if (!DBNull.Value.Equals(dataReader["ftpfolder"]))
                {
                    obj.ftpfolder = dataReader["ftpfolder"].ToString().Trim();
                }
                else
                {
                    obj.ftpfolder = "";
                }

                if (!DBNull.Value.Equals(dataReader["ftpflag"]))
                {
                    obj.ftpflag = Convert.ToInt32(dataReader["ftpflag"].ToString().Trim());
                }
                else
                {
                    obj.ftpflag = -1;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(obj);
        }
Exemplo n.º 30
0
        /// <summary>
        /// add new
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public int add(ref station obj)
        {
            using (NpgsqlDBConnection db = new NpgsqlDBConnection())
            {
                try
                {
                    int ID = -1;

                    if (db.open_connection())
                    {
                        string sql_command = "INSERT INTO stations (station_name, " +
                                             " station_id,socket_port," +
                                             " sampler_comport, tn_comport, tp_comport, toc_comport, " +
                                             " mps_comport, module_comport, mps_protocol, tn_protocol, " +
                                             " tp_protocol, toc_protocol, " +
                                             " do1_caption, do2_caption, " +
                                             " do3_caption, do4_caption, " +
                                             " do5_caption, do6_caption, " +
                                             " do7_caption, do8_caption, " +
                                             " do1_caption_vi, do2_caption_vi, " +
                                             " do3_caption_vi, do4_caption_vi, " +
                                             " do5_caption_vi, do6_caption_vi, " +
                                             " do7_caption_vi, do8_caption_vi, " +
                                             " ftpserver, ftpusername, " +
                                             " ftppassword, ftpfolder, " +
                                             " ftpflag, " +
                                             " modified)" +
                                             " VALUES (:station_name, " +
                                             " :station_id, :socket_port," +
                                             " :sampler_comport, :tn_comport, :tp_comport, :toc_comport, " +
                                             " :mps_comport, :module_comport, :mps_protocol, :tn_protocol, " +
                                             " :tp_protocol, :toc_protocol, " +
                                             " :do1_caption, :do2_caption, " +
                                             " :do3_caption, :do4_caption, " +
                                             " :do5_caption, :do6_caption, " +
                                             " :do7_caption, :do8_caption, " +
                                             " :do1_caption_vi, :do2_caption_vi, " +
                                             " :do3_caption_vi, :do4_caption_vi, " +
                                             " :do5_caption_vi, :do6_caption_vi, " +
                                             " :do7_caption_vi, :do8_caption_vi, " +
                                             " :ftpserver, :ftpusername, " +
                                             " :ftppassword, :ftpfolder, " +
                                             " :ftpflag, " +
                                             " :modified)";
                        sql_command += " RETURNING id;";

                        using (NpgsqlCommand cmd = db._conn.CreateCommand())
                        {
                            cmd.CommandText = sql_command;

                            cmd.Parameters.Add(":socket_port", NpgsqlTypes.NpgsqlDbType.Integer).Value  = obj.socket_port;
                            cmd.Parameters.Add(":station_name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.station_name;
                            cmd.Parameters.Add(":station_id", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.station_id;
                            cmd.Parameters.Add(":modified", NpgsqlTypes.NpgsqlDbType.Timestamp).Value   = obj.modified;

                            cmd.Parameters.Add(":sampler_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.sampler_comport;
                            cmd.Parameters.Add(":tn_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value      = obj.tn_comport;
                            cmd.Parameters.Add(":tp_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value      = obj.tp_comport;
                            cmd.Parameters.Add(":toc_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value     = obj.toc_comport;
                            cmd.Parameters.Add(":mps_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value     = obj.mps_comport;
                            cmd.Parameters.Add(":module_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value  = obj.module_comport;

                            cmd.Parameters.Add(":mps_protocol", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.mps_protocol;
                            cmd.Parameters.Add(":tn_protocol", NpgsqlTypes.NpgsqlDbType.Integer).Value  = obj.tn_protocol;
                            cmd.Parameters.Add(":tp_protocol", NpgsqlTypes.NpgsqlDbType.Integer).Value  = obj.tp_protocol;
                            cmd.Parameters.Add(":toc_protocol", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.toc_protocol;

                            cmd.Parameters.Add(":do1_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do1_caption;
                            cmd.Parameters.Add(":do2_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do2_caption;
                            cmd.Parameters.Add(":do3_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do3_caption;
                            cmd.Parameters.Add(":do4_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do4_caption;
                            cmd.Parameters.Add(":do5_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do5_caption;
                            cmd.Parameters.Add(":do6_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do6_caption;
                            cmd.Parameters.Add(":do7_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do7_caption;
                            cmd.Parameters.Add(":do8_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do8_caption;

                            cmd.Parameters.Add(":do1_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do1_caption_vi;
                            cmd.Parameters.Add(":do2_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do2_caption_vi;
                            cmd.Parameters.Add(":do3_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do3_caption_vi;
                            cmd.Parameters.Add(":do4_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do4_caption_vi;
                            cmd.Parameters.Add(":do5_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do5_caption_vi;
                            cmd.Parameters.Add(":do6_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do6_caption_vi;
                            cmd.Parameters.Add(":do7_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do7_caption_vi;
                            cmd.Parameters.Add(":do8_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do8_caption_vi;

                            cmd.Parameters.Add(":ftpserver", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.ftpserver;
                            cmd.Parameters.Add(":ftpusername", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.ftpusername;
                            cmd.Parameters.Add(":ftppassword", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.ftppassword;
                            cmd.Parameters.Add(":ftpfolder", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.ftpfolder;
                            cmd.Parameters.Add(":ftpflag", NpgsqlTypes.NpgsqlDbType.Integer).Value     = obj.ftpflag;

                            ID     = Convert.ToInt32(cmd.ExecuteScalar());
                            obj.id = ID;

                            db.close_connection();
                            return(ID);
                        }
                    }
                    else
                    {
                        db.close_connection();
                        return(-1);
                    }
                }
                catch
                {
                    if (db != null)
                    {
                        db.close_connection();
                    }
                    return(-1);
                }
                finally
                { db.close_connection(); }
            }
        }
Exemplo n.º 31
0
        /// <summary>
        /// update
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public int update(ref station obj)
        {
            using (NpgsqlDBConnection db = new NpgsqlDBConnection())
            {
                try
                {
                    if (db.open_connection())
                    {
                        string sql_command = "UPDATE stations set  " +
                                             " socket_port = :socket_port, station_name =:station_name, " +
                                             " station_id =:station_id, sampler_comport=:sampler_comport," +
                                             " tn_comport =:tn_comport, tp_comport=:tp_comport," +
                                             " toc_comport =:toc_comport, mps_comport=:mps_comport," +
                                             " module_comport =:module_comport, mps_protocol=:mps_protocol," +
                                             " tn_protocol =:tn_protocol, tp_protocol=:tp_protocol," +
                                             " toc_protocol =:toc_protocol," +
                                             " do1_caption =:do1_caption, do2_caption=:do2_caption," +
                                             " do3_caption =:do3_caption, do4_caption=:do4_caption," +
                                             " do5_caption =:do5_caption, do6_caption=:do6_caption," +
                                             " do7_caption =:do7_caption, do8_caption=:do8_caption," +
                                             " do1_caption_vi =:do1_caption_vi, do2_caption_vi=:do2_caption_vi," +
                                             " do3_caption_vi =:do3_caption_vi, do4_caption_vi=:do4_caption_vi," +
                                             " do5_caption_vi =:do5_caption_vi, do6_caption_vi=:do6_caption_vi," +
                                             " do7_caption_vi =:do7_caption_vi, do8_caption_vi=:do8_caption_vi," +

                                             " ftpserver =:ftpserver, ftpusername=:ftpusername," +
                                             " ftppassword =:ftppassword, ftpfolder=:ftpfolder," +
                                             " ftpflag =:ftpflag," +

                                             " modified = :modified " +
                                             " where id = :id";

                        using (NpgsqlCommand cmd = db._conn.CreateCommand())
                        {
                            cmd.CommandText = sql_command;

                            cmd.Parameters.Add(":socket_port", NpgsqlTypes.NpgsqlDbType.Integer).Value  = obj.socket_port;
                            cmd.Parameters.Add(":station_name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.station_name;
                            cmd.Parameters.Add(":station_id", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.station_id;
                            cmd.Parameters.Add(":modified", NpgsqlTypes.NpgsqlDbType.Timestamp).Value   = obj.modified;

                            cmd.Parameters.Add(":sampler_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.sampler_comport;
                            cmd.Parameters.Add(":tn_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value      = obj.tn_comport;
                            cmd.Parameters.Add(":tp_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value      = obj.tp_comport;
                            cmd.Parameters.Add(":toc_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value     = obj.toc_comport;
                            cmd.Parameters.Add(":mps_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value     = obj.mps_comport;
                            cmd.Parameters.Add(":module_comport", NpgsqlTypes.NpgsqlDbType.Varchar).Value  = obj.module_comport;

                            cmd.Parameters.Add(":mps_protocol", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.mps_protocol;
                            cmd.Parameters.Add(":tn_protocol", NpgsqlTypes.NpgsqlDbType.Integer).Value  = obj.tn_protocol;
                            cmd.Parameters.Add(":tp_protocol", NpgsqlTypes.NpgsqlDbType.Integer).Value  = obj.tp_protocol;
                            cmd.Parameters.Add(":toc_protocol", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.toc_protocol;

                            cmd.Parameters.Add(":do1_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do1_caption;
                            cmd.Parameters.Add(":do2_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do2_caption;
                            cmd.Parameters.Add(":do3_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do3_caption;
                            cmd.Parameters.Add(":do4_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do4_caption;
                            cmd.Parameters.Add(":do5_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do5_caption;
                            cmd.Parameters.Add(":do6_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do6_caption;
                            cmd.Parameters.Add(":do7_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do7_caption;
                            cmd.Parameters.Add(":do8_caption", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do8_caption;

                            cmd.Parameters.Add(":do1_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do1_caption_vi;
                            cmd.Parameters.Add(":do2_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do2_caption_vi;
                            cmd.Parameters.Add(":do3_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do3_caption_vi;
                            cmd.Parameters.Add(":do4_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do4_caption_vi;
                            cmd.Parameters.Add(":do5_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do5_caption_vi;
                            cmd.Parameters.Add(":do6_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do6_caption_vi;
                            cmd.Parameters.Add(":do7_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do7_caption_vi;
                            cmd.Parameters.Add(":do8_caption_vi", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.do8_caption_vi;

                            cmd.Parameters.Add(":ftpserver", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.ftpserver;
                            cmd.Parameters.Add(":ftpusername", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.ftpusername;
                            cmd.Parameters.Add(":ftppassword", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.ftppassword;
                            cmd.Parameters.Add(":ftpfolder", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.ftpfolder;
                            cmd.Parameters.Add(":ftpflag", NpgsqlTypes.NpgsqlDbType.Integer).Value     = obj.ftpflag;

                            cmd.Parameters.Add(":id", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.id;

                            cmd.ExecuteNonQuery();

                            db.close_connection();
                            return(obj.id);
                        }
                    }
                    else
                    {
                        db.close_connection();
                        return(-1);
                    }
                }
                catch
                {
                    if (db != null)
                    {
                        db.close_connection();
                    }
                    return(-1);
                }
            }
        }
Exemplo n.º 32
0
 public Base(station stat)
 {
     this.upgradeVals = stat.upgrades;
     this.upgrades    = stat.upgradesUsed;
     this.molH        = stat.molH;
 }
Exemplo n.º 33
0
        private station _get_info(NpgsqlDataReader dataReader)
        {
            station obj = new station();

            try
            {
                if (!DBNull.Value.Equals(dataReader["id"]))
                {
                    obj.id = Convert.ToInt32(dataReader["id"].ToString().Trim());
                }
                else
                {
                    obj.id = 0;
                }

                if (!DBNull.Value.Equals(dataReader["socket_port"]))
                {
                    obj.socket_port = Convert.ToInt32(dataReader["socket_port"].ToString().Trim());
                }
                else
                {
                    obj.socket_port = 0;
                }

                if (!DBNull.Value.Equals(dataReader["station_name"]))
                {
                    obj.station_name = dataReader["station_name"].ToString().Trim();
                }
                else
                {
                    obj.station_name = "";
                }
                if (!DBNull.Value.Equals(dataReader["station_id"]))
                {
                    obj.station_id = dataReader["station_id"].ToString().Trim();
                }
                else
                {
                    obj.station_id = "";
                }

                ////////////////////////////////////////////////////////////////////////////////////////////////////
                try
                {
                    if (!DBNull.Value.Equals(dataReader["modified"]))
                    {
                        obj.modified = Convert.ToDateTime(dataReader["modified"].ToString().Trim());
                    }
                    else
                    {
                        obj.modified = DateTime.Now;
                    }
                }
                catch (Exception ex) { }

                if (!DBNull.Value.Equals(dataReader["ftpserver"]))
                {
                    obj.ftpserver = dataReader["ftpserver"].ToString().Trim();
                }
                else
                {
                    obj.ftpserver = "";
                }

                if (!DBNull.Value.Equals(dataReader["ftpusername"]))
                {
                    obj.ftpusername = dataReader["ftpusername"].ToString().Trim();
                }
                else
                {
                    obj.ftpusername = "";
                }

                if (!DBNull.Value.Equals(dataReader["ftppassword"]))
                {
                    obj.ftppassword = dataReader["ftppassword"].ToString().Trim();
                }
                else
                {
                    obj.ftppassword = "";
                }

                if (!DBNull.Value.Equals(dataReader["ftpfolder"]))
                {
                    obj.ftpfolder = dataReader["ftpfolder"].ToString().Trim();
                }
                else
                {
                    obj.ftpfolder = "";
                }

                if (!DBNull.Value.Equals(dataReader["ftpflag"]))
                {
                    obj.ftpflag = Convert.ToInt32(dataReader["ftpflag"].ToString().Trim());
                }
                else
                {
                    obj.ftpflag = -1;
                }

                if (!DBNull.Value.Equals(dataReader["goip"]))
                {
                    obj.goip = dataReader["goip"].ToString().Trim();
                }
                else
                {
                    obj.goip = "";
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(obj);
        }
Exemplo n.º 34
0
        /// <summary>
        /// add new
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public int add(ref station obj)
        {
            using (NpgsqlDBConnection db = new NpgsqlDBConnection())
            {
                try
                {
                    int ID = -1;

                    if (db.open_connection())
                    {
                        string sql_command = "INSERT INTO stations (station_name, " +
                                             " station_id,socket_port," +
                                             " ftpserver, ftpusername, " +
                                             " ftppassword, ftpfolder, " +
                                             " ftpflag, " +
                                             " modified)" +
                                             " VALUES (:station_name, " +
                                             " :station_id, :socket_port," +
                                             " :ftpserver, :ftpusername, " +
                                             " :ftppassword, :ftpfolder, " +
                                             " :ftpflag, " +
                                             " :modified)";
                        sql_command += " RETURNING id;";

                        using (NpgsqlCommand cmd = db._conn.CreateCommand())
                        {
                            cmd.CommandText = sql_command;

                            cmd.Parameters.Add(":socket_port", NpgsqlTypes.NpgsqlDbType.Integer).Value  = obj.socket_port;
                            cmd.Parameters.Add(":station_name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.station_name;
                            cmd.Parameters.Add(":station_id", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.station_id;
                            cmd.Parameters.Add(":modified", NpgsqlTypes.NpgsqlDbType.Timestamp).Value   = obj.modified;

                            cmd.Parameters.Add(":ftpserver", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.ftpserver;
                            cmd.Parameters.Add(":ftpusername", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.ftpusername;
                            cmd.Parameters.Add(":ftppassword", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.ftppassword;
                            cmd.Parameters.Add(":ftpfolder", NpgsqlTypes.NpgsqlDbType.Varchar).Value   = obj.ftpfolder;
                            cmd.Parameters.Add(":ftpflag", NpgsqlTypes.NpgsqlDbType.Integer).Value     = obj.ftpflag;

                            ID     = Convert.ToInt32(cmd.ExecuteScalar());
                            obj.id = ID;

                            db.close_connection();
                            return(ID);
                        }
                    }
                    else
                    {
                        db.close_connection();
                        return(-1);
                    }
                }
                catch
                {
                    if (db != null)
                    {
                        db.close_connection();
                    }
                    return(-1);
                }
                finally
                { db.close_connection(); }
            }
        }