private void InfoViewCar_Load(object sender, EventArgs e) { //设置自己的未知 this.Location = new Point(480 * 2, 0); //查询所有站 BaseOperate op = new BaseOperate(); String sql = @"SELECT StationID,Name FROM [db_rfidtest].[rfidtest].[dbo.Station]"; stations = op.getds(sql, "[db_rfidtest].[rfidtest].[dbo.Station]"); loadData(); }
private void InfoViewSumMain_Load(object sender, EventArgs e) { try { this.Location = Screen.AllScreens[MainWindow.locations[4]].WorkingArea.Location; this.Size = Screen.AllScreens[MainWindow.locations[4]].WorkingArea.Size; } catch { } try { int station = 46; int car; double size = 50.7; int people = 1243000; double sum = 0; double argSize; double argPeople; ChartData chartdata = new ChartData(); BaseOperate op = new BaseOperate(); chartdata.updateData(2, DateTime.Now, 0); foreach (double item in chartdata.lastyear) { sum += item; } sum = 344602.75; argSize = sum / size; argPeople = sum / people; String sql = @"SELECT COUNT(*) FROM [db_rfidtest].[rfidtest].[dbo.Driver]"; DataSet ds = op.getds(sql, "[db_rfidtest].[rfidtest].[dbo.Driver]"); if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0) return; car = int.Parse(ds.Tables[0].Rows[0][0].ToString()); sql = @"SELECT COUNT(*) FROM [db_rfidtest].[rfidtest].[dbo.Station]"; ds = op.getds(sql, "[db_rfidtest].[rfidtest].[dbo.Station]"); if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0) return; station = int.Parse(ds.Tables[0].Rows[0][0].ToString())-2; lblStation.Text = "" + station + "个"; lblCar.Text = "" + car + "辆"; lblSize.Text = "" + size + "平方公里"; lblPeople.Text = "" + people + "人"; lblSum.Text = "" + sum + "吨垃圾"; lblArgSize.Text = "" + argSize.ToString("f2") + "吨垃圾"; lblArgPeople.Text = "" + argPeople.ToString("f2") + "吨垃圾"; } catch { } }
private void InfoViewStateMain_Load(object sender, EventArgs e) { try { this.Location = Screen.AllScreens[MainWindow.locations[3]].WorkingArea.Location; this.Size = Screen.AllScreens[MainWindow.locations[3]].WorkingArea.Size; } catch { } try { string sql = "Select name from [dbo.Station] where stationid > 29"; InfoView.Classes.BaseOperate op = new InfoView.Classes.BaseOperate(); stations = op.getds(sql, "[dbo.Station]").Tables[0]; } catch { } tmrState_Tick(null, null); // }
private void InfoViewCarMain_Load(object sender, EventArgs e) { this.lblStartTime2.Text = "无"; this.lblEndTime2.Text = "无"; //查询所有站 BaseOperate op = new BaseOperate(); String sql = @"SELECT StationID,Name FROM [db_rfidtest].[rfidtest].[dbo.Station]"; stations = op.getds(sql, "[db_rfidtest].[rfidtest].[dbo.Station]"); curStation = 0; loadData(); loadStationCar(); try { this.Location = Screen.AllScreens[MainWindow.locations[0]].WorkingArea.Location; Size s = new Size(); s.Width = Screen.AllScreens[MainWindow.locations[0]].WorkingArea.Size.Width; s.Height = Screen.AllScreens[MainWindow.locations[0]].WorkingArea.Size.Height / 2; this.Size = s; } catch { } }
private void loadStationCar() { try { if (stations == null || stations.Tables.Count <= 0) return; String sql = @"SELECT * FROM [db_rfidtest].[rfidtest].[dbo.goods] WHERE StartStationID = " + stations.Tables[0].Rows[curStation]["StationID"].ToString() + " AND ((StartTime > '" + DateTime.Now.ToString("yy-MM-dd") + "' AND StartTime<'" + DateTime.Now.AddDays(1).ToString("yy-MM-dd 00:00") + "') OR (EndTime > '" + DateTime.Now.ToString("yy-MM-dd") + "' AND EndTime<'" + DateTime.Now.AddDays(1).ToString("yy-MM-dd 00:00") + "'))"; BaseOperate op = new BaseOperate(); cars = op.getds(sql, "[db_rfidtest].[rfidtest].[dbo.goods]"); panel2.Invalidate(); groupBox1.Text = stations.Tables[0].Rows[curStation]["Name"].ToString(); curStation++; if (curStation >= stations.Tables[0].Rows.Count) curStation = 0; } catch { } }
private void loadData() { //第一次查询,查询出最近的一条已到车辆 String sqlStart = @"SELECT TOP 1 * FROM [db_rfidtest].[rfidtest].[dbo.goods] WHERE [db_rfidtest].[rfidtest].[dbo.goods].[ENDTIME] is not null ORDER BY ENDTIME DESC"; BaseOperate operate = new BaseOperate(); DataSet ds2 = null; try { ds2 = operate.getds(sqlStart, "[db_rfidtest].[rfidtest].[dbo.goods]"); } catch (Exception e) { MessageBox.Show(e.Message); return; } //第二次查询,查询出最后一次未到车辆 sqlStart = @"SELECT TOP 1 * FROM [db_rfidtest].[rfidtest].[dbo.goods] WHERE [db_rfidtest].[rfidtest].[dbo.goods].[ENDTIME] is null ORDER BY STARTTIME DESC"; DataSet ds1 = null; try { ds1 = operate.getds(sqlStart, "[db_rfidtest].[rfidtest].[dbo.goods]"); } catch (Exception e) { //MessageBox.Show(e.Message); return; } if (ds1.Tables.Count <= 0 || ds1.Tables[0].Rows.Count<=0) return; if (ds2.Tables.Count <= 0 || ds2.Tables[0].Rows.Count <= 0) return; //判断上次查询到的数据是否和本次一样 if (id1 != int.Parse(ds1.Tables[0].Rows[0]["ID"].ToString())) { try { //如果不一样则更改当前数据 id1 = int.Parse(ds1.Tables[0].Rows[0]["ID"].ToString()); lblCarNo1.Text = ds1.Tables[0].Rows[0]["TruckNo"].ToString(); lblStartTime1.Text = DateTime.Parse(ds1.Tables[0].Rows[0]["StartTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); lblSStation1.Text = getNameById(ds1.Tables[0].Rows[0]["StartStationID"].ToString()); lblEStation1.Text = getNameById(ds1.Tables[0].Rows[0]["EndStationID"].ToString()) ; //20121017 //lblEStation1.Text = "大屯"; Thread t = new Thread(new ParameterizedThreadStart(changeData)); t.Start("1"); } catch { } } if (id2 != int.Parse(ds2.Tables[0].Rows[0]["ID"].ToString())) { try { //如果不一样则更改当前数据 id2 = int.Parse(ds2.Tables[0].Rows[0]["ID"].ToString()); lblCarNo2.Text = ds2.Tables[0].Rows[0]["TruckNo"].ToString(); lblStartTime2.Text = DateTime.Parse(ds2.Tables[0].Rows[0]["StartTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); lblEndTime2.Text = DateTime.Parse(ds2.Tables[0].Rows[0]["EndTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); lblSStation2.Text = getNameById(ds2.Tables[0].Rows[0]["StartStationID"].ToString()); lblEStation2.Text = getNameById(ds2.Tables[0].Rows[0]["EndStationID"].ToString()); lblWeight.Text = ds2.Tables[0].Rows[0]["Weight"].ToString(); Thread t = new Thread(new ParameterizedThreadStart(changeData)); t.Start("2"); } catch { } } }
private void loadData() { //第一次查询,查询出最近的一条已到车辆 String sqlStart = @"SELECT TOP 1 * FROM [db_rfidtest].[rfidtest].[dbo.goods] WHERE [db_rfidtest].[rfidtest].[dbo.goods].[ENDTIME] is not null ORDER BY ENDTIME DESC"; BaseOperate operate = new BaseOperate(); DataSet ds2 = null; try { ds2 = operate.getds(sqlStart, "[db_rfidtest].[rfidtest].[dbo.goods]"); } catch (Exception e) { MessageBox.Show(e.Message); return; } //第二次查询,查询出最后一次未到车辆 sqlStart = @"SELECT TOP 1 * FROM [db_rfidtest].[rfidtest].[dbo.goods] WHERE [db_rfidtest].[rfidtest].[dbo.goods].[ENDTIME] is null ORDER BY STARTTIME DESC"; DataSet ds1 = null; try { ds1 = operate.getds(sqlStart, "[db_rfidtest].[rfidtest].[dbo.goods]"); } catch (Exception e) { //MessageBox.Show(e.Message); return; } if (ds1.Tables.Count <= 0 || ds1.Tables[0].Rows.Count <= 0) return; if (ds2.Tables.Count <= 0 || ds2.Tables[0].Rows.Count <= 0) return; //判断上次查询到的数据是否和本次一样 if (id2 != int.Parse(ds1.Tables[0].Rows[0]["ID"].ToString())) { try { //如果不一样则更改当前数据 id1 = int.Parse(ds1.Tables[0].Rows[0]["ID"].ToString().Trim()); TruckNo1.Text = ds1.Tables[0].Rows[0]["TruckNo"].ToString().Trim(); StartTime1.Text = DateTime.Parse(ds1.Tables[0].Rows[0]["StartTime"].ToString()).ToString("HH:mm"); StartStation1.Text = getNameById(ds1.Tables[0].Rows[0]["StartStationID"].ToString()); EndStation1.Text = getNameById(ds1.Tables[0].Rows[0]["EndStationID"].ToString()); if (EndStation1.Text.Trim() == "大屯") EndStation1.Text = "马家楼"; else EndStation1.Text = "大屯"; } catch { } } if (id1 != int.Parse(ds2.Tables[0].Rows[0]["ID"].ToString())) { try { //如果不一样则更改当前数据 id2 = int.Parse(ds2.Tables[0].Rows[0]["ID"].ToString()); TruckNo2.Text = ds2.Tables[0].Rows[0]["TruckNo"].ToString().Trim(); StartTime2.Text = DateTime.Parse(ds2.Tables[0].Rows[0]["StartTime"].ToString()).ToString("HH:mm"); EndTime2.Text = DateTime.Parse(ds2.Tables[0].Rows[0]["EndTime"].ToString()).ToString("HH:mm"); StartStation2.Text = getNameById(ds2.Tables[0].Rows[0]["StartStationID"].ToString()); EndStation2.Text = getNameById(ds2.Tables[0].Rows[0]["EndStationID"].ToString()); Weight2.Text = ds2.Tables[0].Rows[0]["Weight"].ToString(); } catch { } } }