Esempio n. 1
0
        private void UpdateDisplay()
        {
            if (comboBox1.SelectedIndex < 0)
            {
                dataRowEditor1.SetDataRow(m_sites.NewsitecatalogRow());
                dataGridViewSiteProperties.DataSource = null;

                return;
            }

            var row = m_sites[comboBox1.SelectedIndex];

            this.dataRowEditor1.SetDataRow(row);

            var siteid = row["siteid"].ToString();

            m_props.Columns["siteid"].DefaultValue     = siteid;
            m_props.Columns["id"].AutoIncrement        = true;
            m_props.Columns["id"].AutoIncrementSeed    = m_props.NextID();
            m_props.DefaultView.RowFilter              = "siteid = '" + siteid + "'";
            this.dataGridViewSiteProperties.DataSource = m_props;

            dataGridViewSiteProperties.Columns["siteid"].Visible = false;
            dataGridViewSiteProperties.Columns["id"].Visible     = false;
        }
Esempio n. 2
0
        private static void UpdateGPSiteInfo(TimeSeriesDatabaseDataSet.sitecatalogDataTable sc)
        {
            Console.WriteLine("reading gp excel");
            var fn  = @"U:\water.usbr.gov\data\GPsitesTESSELAPP_kt.xlsx";
            var xls = new NpoiExcel(fn);
            var tbl = xls.ReadDataTable(0);

            //var tbl = ExcelDB.Read(fn, 0);

            for (int i = 0; i < tbl.Rows.Count; i++)
            {
                var desc  = tbl.Rows[i]["Description"].ToString();
                var lat   = tbl.Rows[i]["Latitude"].ToString().Trim();
                var lon   = tbl.Rows[i]["Longitude"].ToString().Trim();
                var state = tbl.Rows[i]["State"].ToString().Trim();
                if (lon[0] != '-')
                {
                    lon = "-" + lon;
                }
                //var office = tbl.Rows[i]["office"].ToString();
                var siteid   = tbl.Rows[i]["Site Name"].ToString().ToLower().Trim();
                var siteType = tbl.Rows[i]["type"].ToString().ToLower().Trim();


                var siteRow = sc.FindBysiteid(siteid);

                if (siteRow == null)
                {
                    Console.WriteLine("new site : " + siteid);
                    siteRow        = sc.NewsitecatalogRow();
                    siteRow.siteid = siteid;
                    sc.AddsitecatalogRow(siteRow);
                }
                else
                {
                    Console.WriteLine("existing site : " + siteRow.siteid);
                }

                siteRow.description = desc;
                siteRow.state       = state;
                siteRow.latitude    = lat;
                siteRow.longitude   = lon;
                //siteRow.responsibility = office;
                siteRow.type          = siteType;
                siteRow.agency_region = "GP";
            }
        }
Esempio n. 3
0
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (comboBox1.SelectedIndex < 0)
            {
                dataRowEditor1.SetDataRow(m_sites.NewsitecatalogRow());
                return;
            }

            var row = m_sites[comboBox1.SelectedIndex];

            this.dataRowEditor1.SetDataRow(row);

            var siteid = row["siteid"].ToString();

            m_props.Columns["siteid"].DefaultValue     = siteid;
            m_props.Columns["id"].AutoIncrement        = true;
            m_props.Columns["id"].AutoIncrementSeed    = m_props.NextID();
            m_props.DefaultView.RowFilter              = "siteid = '" + siteid + "'";
            this.dataGridViewSiteProperties.DataSource = m_props;
        }