压力传感器标定 - 带记录log功能

【实例简介】压力传感器标定 - 带记录log功能 ，欢迎下载

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using opc_Library;



namespace 压力传感器标定
{
    public partial class Form1 : Form
    {
        public int i, j, k;
       write_log write_log = new write_log();

        public Form1()
        {
            InitializeComponent();
            
        }
        private SqlConnection GetConnection()//定义数据库链接
        {
            string constr = "Server=A3012L678;user=sa;pwd=1983217;database=csharpzxw";
            SqlConnection mycon = new SqlConnection(constr);
            return mycon;
        }
        private void dgvBind()//定义绑定数据
        {
            SqlConnection mycon = GetConnection();
            try
            {
                mycon.Open();
                SqlDataAdapter sda = new SqlDataAdapter("select * from mytable001", mycon);
                DataTable table = new DataTable();
                sda.Fill(table);
                
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                mycon.Close();
            }
        }
        private void Form1_Load(object sender, EventArgs e)//载入数据
        {
            dgvBind();
            label4.Text = DateTime.Now.ToString();
        }

        

        private void button1_Click(object sender, EventArgs e)
        {
            label4.Text = DateTime.Now.ToString();
            positiveTb.Focus();
            positiveTb.SelectAll();
            negativTB.Focus();
            negativTB.SelectAll();
            
            write_log.write_log_txt("输入成功");
            float average;
            float positive = float.Parse(positiveTb.Text);
            float negative = float.Parse(negativTB.Text);
            average = (positive   negative) / 2;
            
            averageTB.Text = Math.Round(average, 4).ToString();

            SqlConnection mycon = GetConnection();//要操作数据库必须先连接
            try
            {
                mycon.Open();

                

                //string updateSql = "update mytable001 set gender='中' where id=3";//将id=3的gender属性更改
                //string mystr1 = dataGridView1.Columns[e.ColumnIndex].HeaderText   "="   "'"   dataGridView1.CurrentCell.Value.ToString()   "'";
                //string mystr2 = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();

                string mystr1 = "'"   positiveTb.Text   "'";
                string mystr2 = i.ToString();
                string updateSql = "update mytable003 set positive="   mystr1   "where id="   mystr2;

                string mystr3 = "'"   negativTB.Text   "'";
                string mystr4= j.ToString();
                string updateSql2 = "update mytable003 set negative="   mystr3   "where id="   mystr4;

                string mystr5 = "'"   averageTB.Text   "'";
                string mystr6 = k.ToString();
                string updateSql3 = "update mytable003 set average="   mystr5   "where id="   mystr6;

                string mystr7 = "'"   label4.Text   "'";
                string updateSql4 = "update mytable003 set time="   mystr7   "where id="   mystr6;


                SqlCommand mycom = new SqlCommand(updateSql, mycon);//更新数据库
                mycom.ExecuteNonQuery();

                SqlCommand mycom2 = new SqlCommand(updateSql2, mycon);//更新数据库
                mycom2.ExecuteNonQuery();

                SqlCommand mycom3 = new SqlCommand(updateSql3, mycon);//更新数据库
                mycom3.ExecuteNonQuery();

                SqlCommand mycom4 = new SqlCommand(updateSql4, mycon);//更新数据库
                mycom4.ExecuteNonQuery();
                dgvBind();
                i  ;
                j  ;
                k  ;
               

                write_log.write_log_txt(string.Concat(new string[]
                            {
                               positiveTb.Text,
                                " ",
                               negativTB.Text,
                               "=",
                                averageTB.Text
                            }));
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                mycon.Close();

            }

        }

       

        private void Form1_Load_1(object sender, EventArgs e)
        {
           
            int i, j, k=0;
          

        }

       
        
    }
    }