using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public byte [] rec1;
public object rec;
public int a;
public Form1()
{
InitializeComponent();
}
private void button1_Click_1(object sender, EventArgs e)
{
string aa = "Data Source=(local);Initial Catalog=ab;Integrated Security=True";
SqlConnection con = new SqlConnection();
con.ConnectionString = aa;
string cmdText = "SELECT * FROM 温湿度 where 时间='" + textBox2.Text + "'";
//MessageBox.Show(cmdText);
SqlDataAdapter da = new SqlDataAdapter(cmdText, con);
DataSet ds = new DataSet();
try
{
con.Open();
da.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
textBox1.Text = textBox2.Text;
textBox3.Text = row["温度"].ToString();
textBox4.Text = row["湿度"].ToString();
}
}
catch (Exception)
{
MessageBox.Show("对不起！查询失败！", "提示");
}
finally
{
con.Close();
}
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
private void 显示ToolStripMenuItem_Click(object sender, EventArgs e)
{
string aa = "Data Source=(local);Initial Catalog=ab;Integrated Security=True";
SqlConnection con = new SqlConnection();
con.ConnectionString = aa;
string cmdText = "SELECT * FROM 温湿度";
SqlDataAdapter da = new SqlDataAdapter(cmdText, con);
DataSet ds = new DataSet();
try
{
con.Open();
da.Fill(ds);
}
catch (Exception)
{
MessageBox.Show("对不起！查询失败！", "提示");
}
finally
{
con.Close();
}
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
private void 保存ToolStripMenuItem_Click(object sender, EventArgs e)
{
string aa = "Data Source=(local);Initial Catalog=ab;Integrated Security=True";
SqlConnection con = new SqlConnection();
con.ConnectionString = aa;
string cmdText = "insert into 温湿度(时间,温度,湿度) values ('"+textBox1.Text +"','"+textBox3.Text+"','"+textBox4.Text +"')";
SqlCommand cmd = new SqlCommand(cmdText ,con);
try
{
con.Open();
cmd.ExecuteNonQuery();
qingkong();
}
catch (Exception)
{
MessageBox.Show("对不起！保存数据失败！", "提示");
}
finally
{
con.Close();
}
shuaxin();
}
void qingkong()
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}
void shuaxin()
{
string aa = "Data Source=(local);Initial Catalog=ab;Integrated Security=True";
SqlConnection con = new SqlConnection();
con.ConnectionString = aa;
string cmdText = "SELECT * FROM 温湿度";
SqlDataAdapter da = new SqlDataAdapter(cmdText, con);
DataSet ds = new DataSet();
try
{
con.Open();
da.Fill(ds);
}
catch (Exception)
{
MessageBox.Show("对不起！查询失败！", "提示");
}
finally
{
con.Close();
}
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
private void axMSComm1_OnComm(object sender, EventArgs e)
{
//byte[] rec1;
//if (axMSComm1.CommEvent== ComEvReceive)
//axMSComm1.CommEvent == 1;
//if (axMSComm1.CommEvent.Equals(1))
//rec= Convert.ToByte(axMSComm1.Input);
//c =axMSComm1.Input;
//b = (byte)rec;
timer1.Enabled = true;
rec= axMSComm1.Input;
rec1= (byte[] )rec;
rec1[0] = (byte)(rec1[0] - 100);
rec1[1] = (byte)(rec1[1] - 200);
textBox5.Text = Convert.ToString(rec1[0])+"℃";
textBox6.Text = Convert.ToString(rec1[1])+"%";
listBox1.Items.Add(textBox5.Text);
textBox7.Text =Convert.ToString (DateTime.Now);
//textBox7.Text = Convert.ToString(a);
// a++;
}
private void button2_Click(object sender, EventArgs e)
{
axMSComm1.InBufferCount = 0;
axMSComm1.PortOpen = true;
//axMSComm1.Output = 0x12;
if (axMSComm1.PortOpen==true)
MessageBox.Show("串口已打开！", "提示");
//timer1.Enabled = true;
}
private void timer1_Tick(object sender, EventArgs e)
{
axMSComm1.PortOpen = false;
//textBox7.Text=DateTime.Now.ToString();
//textBox5.Text = "12";
//textBox6.Text = "162";
string aa = "Data Source=(local);Initial Catalog=ab;Integrated Security=True";
SqlConnection con = new SqlConnection();
con.ConnectionString = aa;
string cmdText = "insert into 温湿度(时间,温度,湿度) values ('" + textBox7.Text + "','" + textBox5.Text + "','" + textBox6.Text + "')";
SqlCommand cmd = new SqlCommand(cmdText, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
qingkong();
}
catch (Exception)
{
timer1.Enabled = false;
MessageBox.Show("对不起！保存数据失败！", "提示");
}
finally
{
con.Close();
}
shuaxin();
timer1.Enabled = false;
axMSComm1.PortOpen = true;
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void groupBox3_Enter(object sender, EventArgs e)
{
}
private void button3_Click(object sender, EventArgs e)
{
axMSComm1.PortOpen = false;
timer1.Enabled = false;
}
}
}
