예제 #1
0
파일: Form1.cs 프로젝트: XenaMac/MTC
        private void LoadTrucks()
        {
            DateTime dtStart = new DateTime();
            DateTime dtEnd   = new DateTime();

            try
            {
                dtStart = Convert.ToDateTime(dtpStart.Text + " " + txtStartHour.Text);
                dtEnd   = Convert.ToDateTime(dtpEnd.Text + " " + txtEndHour.Text);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            SQLCode mySQL = new SQLCode();

            cboTrucks.Items.Clear();
            try
            {
                List <string> trucks = mySQL.GetTrucks(dtStart, dtEnd);
                foreach (string s in trucks)
                {
                    cboTrucks.Items.Add(s);
                }
                cboTrucks.Text = "Select";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "Error");
            }
        }
예제 #2
0
파일: Form1.cs 프로젝트: XenaMac/MTC
 private void LoadPlaybackByBeat()
 {
     try
     {
         gvData.DataSource = null;
         gvData.Rows.Clear();
         bool LogonOnly = false;
         if (chkLogon.Checked == true)
         {
             LogonOnly = true;
         }
         DateTime dtStart = Convert.ToDateTime(dtpStart.Text + " 00:00:00");
         DateTime dtEnd   = Convert.ToDateTime(dtpEnd.Text + " 23:59:59");
         SQLCode  mySQL   = new SQLCode();
         mySQL.LoadTrackingDataByBeat(cboBeats.Text, dtStart, dtEnd, LogonOnly);
         gvData.DataSource = GlobalData.allTrack;
         GPSTrack firstTrack = GlobalData.allTrack[0];
         gMapControl1.Position = new PointLatLng(firstTrack.Lat, firstTrack.Lon);
         gMapControl1.Overlays.Clear();
         GMapOverlay           overlay = new GMapOverlay(gMapControl1, "base");
         GMapMarkerGoogleGreen home    = new GMapMarkerGoogleGreen(new PointLatLng(firstTrack.Lat, firstTrack.Lon));
         overlay.Markers.Add(home);
         gMapControl1.Overlays.Add(overlay);
         iEventCount = GlobalData.allTrack.Count - 1;
         foreach (DataGridViewRow row in gvData.Rows)
         {
             row.DefaultCellStyle.BackColor = Color.White;
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
 }