C#温度报警

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using System.Windows.Forms;
using System.Drawing;

//展示端口
namespace TemperatureSytem
{
   static class ShowPortIsOrNo
    {
       /// <summary>
       /// 显示可用端口，和提示
       /// </summary>
       /// <param name="combox">显示端口</param>
       /// <param name="lab">提示</param>
       public static void FromLoadPort(ComboBox combox,Label lab)
       {
           ArrayList alPort = PortCheckAndSeting.PortSeting();
           if (alPort.Count < 1)
           {
               lab.Text = "未检测到可用串口！！！";
               lab.ForeColor = Color.Red;
               return;
           }
           else
           {
               foreach (string sPort in alPort)
               {
                   combox.Items.Add(sPort);
                   combox.Text = sPort;
               }
           }
       }
    }
}

ShowPortIsOrNo.cs

//串口检测
using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using System.IO.Ports;
using System.Windows.Forms;

namespace TemperatureSytem
{
    static class PortCheckAndSeting
    {
        /// <summary>
        /// 加载的有串口
        /// </summary>
        /// <returns>返回一个串口动态数组</returns>
        public static ArrayList PortSeting()
        {
            ArrayList alPort = new ArrayList();
            foreach (string sPort in SerialPort.GetPortNames())
            {
                alPort.Add(sPort);
            }
            return alPort;
        }
        /// <summary>
        /// 新串口检测设置
        /// </summary>
        /// <param name="alOlePort"></param>
        /// <returns></returns>
        public static string NewPortSeting(ComboBox comBox)
        {
            //存在
            ArrayList alOldPort = new ArrayList();//保存旧串口号的
            foreach (string strOldPort in comBox.Items)//遍历旧的保存在动态数组里
            {
                alOldPort.Add(strOldPort);
            }
            foreach (string sPort in SerialPort.GetPortNames())
            {
                bool exists = ((IList)alOldPort).Contains(sPort);
                if (!exists)//在旧的串口里是否包含新检测的，不包含则返回这个新检测的
                    return sPort;
            }
            return "";
        }
    }
}

PortCheckAndSeting.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime.InteropServices;

namespace TemperatureSytem
{
    class Sound
    {
        [DllImport("winmm.dll")]
        public static extern long PlaySound(String fileName, long a, long b);

        [DllImport("winmm.dll")]
        public static extern long mciSendString(string lpstrCommand, string lpstrReturnString, long length, long hwndcallback);

        /// <summary>
        /// 播放音乐文件(重复)
        /// </summary>
        /// <param name="p_FileName">音乐文件名称</param>
        public static void PlayMusic_Repeat(string p_FileName)
        {
            try
            {
                mciSendString(@"close temp_music", " ", 0, 0);
                mciSendString(@"open " + p_FileName + " alias temp_music", " ", 0, 0);
                mciSendString(@"play temp_music repeat", " ", 0, 0);
            }
            catch
            { }
        }

        /// <summary>
        /// 播放音乐文件
        /// </summary>
        /// <param name="p_FileName">音乐文件名称</param>
        public static void PlayMusic(string p_FileName)
        {
            try
            {
                mciSendString(@"close temp_music", " ", 0, 0);
                mciSendString(@"open " + p_FileName + " alias temp_music", " ", 0, 0);
                mciSendString(@"play temp_music", " ", 0, 0);
            }
            catch
            { }
        }

        /// <summary>
        /// 停止当前音乐播放
        /// </summary>
        /// <param name="p_FileName">音乐文件名称</param>
        public static void StopMusic(string p_FileName)
        {
            try
            {
                mciSendString(@"close " + p_FileName, " ", 0, 0);
            }
            catch { }
        }

      
    }
}

Sound.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
using System.Collections;
using System.Data.SqlClient;
using System.Diagnostics;

namespace SqlOperate
{
    class SqlHelpers
    {
        public bool bl = true;
        public static string sql;
        public static string userName;
        public static string userPwd;
        public static string sqlDatabase;
        public static string strConn;

        public string Sql
        {
            get { return sql; }
            set { sql = value; }
        }
        public string UserName
        {
            get { return userName; }
            set { userName = value; }
        }
        public string UserPwd
        {
            get { return userPwd; }
            set { userPwd = value; }
        }
        public string SqlDataBase
        {
            get { return sqlDatabase; }
            set { sqlDatabase = value; }
        }


        public string StrrConn
        {
            get { return strConn; }
            set { strConn = value; }
        }
        OleDbConnection con;
        OleDbDataAdapter adp;
        //连接
        public string StrConnString()
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\data.mdb";
            return strConn;
        }
        public void Conn()
        {
            // string sqlconn = "server=" + sql + ";database="+sqlDatabase+";u;
            con = new OleDbConnection(StrConnString());
            try
            {
                con.Open();
                bl = true;
            }
            catch (Exception)
            {

                bl = false;
            }
        }
        #region 返回DataTable
        /// <summary>
        /// 返回DataTable
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public DataTable datatable(string sqlxx)
        {
            DataSet dataset = new DataSet();
            try
            {
                adp = new OleDbDataAdapter(sqlxx, StrConnString());
                adp.Fill(dataset, "table1");

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            return dataset.Tables["table1"];
        }
        #endregion

        #region 返回DATASET
        /// <summary>
        /// 返回DataTable
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public DataSet dataSet(string sqlxx)
        {
            DataSet dataset = new DataSet();
            try
            {
                adp = new OleDbDataAdapter(sqlxx, StrConnString());
                adp.Fill(dataset, "table1");

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            return dataset;
        }

        public DataSet dataSet(ArrayList sqlxx)
        {
            DataSet dataset = new DataSet();
            int i = 0;
            try
            {
                foreach (string item in sqlxx)
                {
                    adp = new OleDbDataAdapter(item, StrConnString());
                    adp.Fill(dataset,i.ToString());
                    i++;
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            return dataset;
        }
        #endregion

        #region 返回一个动态数组
        /// <summary>
        /// 返回一个动态数组
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="ziduan"></param>
        /// <param name="combox"></param>
        public ArrayList pinyin(string sql, string ziduan)
        {

            OleDbConnection con = new OleDbConnection(StrConnString());
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            ArrayList al = new ArrayList();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr2 = dt.Rows[i];
                string username = Convert.ToString(dr2[ziduan]);
                bool rep = false;
                foreach (string str in al)
                {
                    if (username == str)
                    {
                        rep = true;
                        break;
                    }
                }
                if (!rep)
                {
                    al.Add(username);
                }
            }
            return al;

        }
        #endregion

        #region 普通ExecuteNonQuery
        /// <summary>
        /// 普通ExecuteNonQuery
        /// </summary>
        /// <param name="sql"></param>
        public void ExecuteNonQuery(string sqlxx)
        {
            try
            {
                OleDbConnection con = new OleDbConnection(StrConnString());
                con.Open();
                OleDbCommand cmd = new OleDbCommand(sqlxx, con);
                cmd.ExecuteNonQuery();
                con.Close();
            }
            catch {throw new Exception(); }
           

        }
        #endregion

        #region 普通ExecuteNonQuery
        /// <summary>
        /// 数组ExecuteNonQuery
        /// </summary>
        /// <param name="sql"></param>
        public void ExecuteNonQuery(ArrayList sqlxx)
        {
            try
            {
                OleDbConnection con = new OleDbConnection(StrConnString());
                con.Open();
                foreach (string item in sqlxx)
                {
                    OleDbCommand cmd = new OleDbCommand(item, con);
                    cmd.ExecuteNonQuery();
                }

                con.Close();
            }
            catch { throw new Exception(); }


        }
        #endregion

        #region ComboBox下拉选择
        /// <summary>
        /// ComboBox下拉选择
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="ziduan"></param>
        /// <param name="combox"></param>
        public void Combox(string sql, string ziduan, ComboBox combox, int j)
        {
            combox.Items.Clear();
            OleDbConnection con = new OleDbConnection(StrConnString());
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            ArrayList al = new ArrayList();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr2 = dt.Rows[i];
                string username = Convert.ToString(dr2[ziduan]);
                bool rep = false;
                foreach (string str in al)
                {
                    if (username == str)
                    {
                        rep = true;
                        break;
                    }
                }
                if (!rep)
                {
                    al.Add(username);
                    combox.Items.Add(username);
                }
            }
            if (al.Count < 1)
            {
                combox.Text = "";
            }
            else
            {
                if (j == 0)
                {
                    combox.AutoCompleteCustomSource.AddRange((string[])al.ToArray(typeof(string))); //ArryList转为string[]
                    combox.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest;
                    combox.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.CustomSource;
                }
                else
                {
                    combox.Text = al[0].ToString();
                    combox.AutoCompleteCustomSource.AddRange((string[])al.ToArray(typeof(string))); //ArryList转为string[]
                    combox.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest;
                    combox.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.CustomSource;
                }

            }
        }
        #endregion

        #region 返回一个动态数组
        /// <summary>
        /// 返回一个动态数组含两个字段
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="ziduan"></param>
        /// <param name="combox"></param>
        public ArrayList TwoZiduan(string sql, string ziduan, string ziduan2)
        {

            OleDbConnection con = new OleDbConnection(StrConnString());
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            ArrayList al = new ArrayList();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr2 = dt.Rows[i];
                string username = Convert.ToString(dr2[ziduan]);
                string phonenumber = Convert.ToString(dr2[ziduan2]);
                string xx = username + "--" + phonenumber;
                bool rep = false;
                foreach (string str in al)
                {
                    if (xx == str)
                    {
                        rep = true;
                        break;
                    }
                }
                if (!rep)
                {
                    al.Add(xx);
                }
            }
            return al;

        }
        #endregion

        #region  提取一个字段int
        /// <summary>
        /// 提取一个字段int
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="ziduan"></param>
        /// <returns>int</returns>
        public int ReturnValue(string sql, string ziduan)
        {
            int IdValude = 0;
            OleDbConnection con = new OleDbConnection(StrConnString());
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                DataRow dr2 = dt.Rows[0];
                IdValude = Convert.ToInt32(dr2[ziduan]);
                return IdValude;
            }
            else
            {
                IdValude = -1;
                return IdValude;
            }
        }

        #endregion

        #region 提取一个字段string
        //提取一个字段string
        public string TextBox(string sql, string ziduan)
        {

            try
            {
                OleDbConnection con = new OleDbConnection(StrConnString());
                OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
                DataTable dt = new DataTable();
                adp.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    DataRow dr2 = dt.Rows[0];
                    return Convert.ToString(dr2[1]);
                }
                else
                {
                    return "";
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return "";
            }
        }
        #endregion

        #region dataGridView美化
        /// <summary>
        /// dataGridView美化
        /// </summary>
        /// <param name="dataGridView"></param>
        public void dataGridView(DataGridView dataGridView)
        {
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
            dataGridView.AllowUserToAddRows = false;
            dataGridView.AllowUserToDeleteRows = false;
            dataGridViewCellStyle1.BackColor = System.Drawing.Color.LightCyan;
            dataGridView.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;
            dataGridView.BackgroundColor = System.Drawing.Color.White;
            dataGridView.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
            dataGridView.ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.Single;
            dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;//211, 223, 240
            dataGridViewCellStyle2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(223)))), ((int)(((byte)(240)))));
            dataGridViewCellStyle2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            dataGridViewCellStyle2.ForeColor = System.Drawing.Color.Navy;
            dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight;
            dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
            dataGridView.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2;
            dataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            dataGridView.EnableHeadersVisualStyles = false;
            dataGridView.GridColor = System.Drawing.SystemColors.GradientInactiveCaption;
            dataGridView.ReadOnly = false ;
            dataGridView.RowHeadersVisible = false;
            dataGridView.RowTemplate.Height = 23;
            dataGridView.RowTemplate.ReadOnly = false ;
            dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
        } 
        #endregion


        private void pilian(string tableName,string[] aa,string[] bb)
        {

            Stopwatch sw = new Stopwatch();
            OleDbConnection con = new OleDbConnection(StrConnString());
            OleDbCommand sqlComm = new OleDbCommand();
            sqlComm.CommandText = string.Format("insert into sz_tb (UserName,Pwd)values(@p0,@p1,@p2)");//参数化SQL
            sqlComm.Parameters.Add("@p0", SqlDbType.Int);
            sqlComm.Parameters.Add("@p1", SqlDbType.NVarChar);
            sqlComm.Parameters.Add("@p2", SqlDbType.VarChar);
            sqlComm.CommandType = CommandType.Text;
            sqlComm.Connection = con;
            con.Open();
            try
            {
                //循环插入100万条数据，每次插入10万条，插入10次。
                for (int multiply = 0; multiply < 10; multiply++)
                {
                    for (int count = multiply * 100000; count < (multiply + 1) * 100000; count++)
                    {

                        sqlComm.Parameters["@p0"].Value = count;
                        sqlComm.Parameters["@p1"].Value = string.Format("User-{0}", count * multiply);
                        sqlComm.Parameters["@p2"].Value = string.Format("Pwd-{0}", count * multiply);
                        sw.Start();
                        sqlComm.ExecuteNonQuery();
                        sw.Stop();
                    }
                    //每插入10万条数据后，显示此次插入所用时间
                   // Console.WriteLine(string.Format("Elapsed Time is {0} Milliseconds", sw.ElapsedMilliseconds));
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }

            Console.ReadLine();
        }
    }
}

SqlHelpers.cs

using System;
using System.Collections.Generic;
using 
                       
                    
                     
                      



鲜花




握手




雷人




路过




鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

TaskVision（C#版）在Win2003上完美安装（说明：访问的库是本地的） ...发布时间：2022-07-10

Win10系列：C#应用控件进阶7发布时间：2022-07-10

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

2023-10-27

florent37/ViewAnimator: A fluent Android

2022-08-15

florent37/Shrine-MaterialDesign2: implem

2022-08-17

CVE-2020-36276

2022-09-23

SimpleSoftwareIO/simple-sms: Send and re

2022-08-13

阅读排行榜

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19121|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9971|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8317|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8686|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8626|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9643|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8611|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7991|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8639|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7527|2022-11-06

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服（服务时间 9:00～18:00）

在线QQ客服

地址：深圳市南山区西丽大学城创智工业园

电邮：jeky_zhao#qq.com

移动电话：139-2527-9053

客服电话

电子邮件

C#温度报警

请发表评论

全部评论

上一篇：

下一篇：

delphiFastReport安装方法delphiFastReport

CVE-2022-34637

kojino/Harvard-Robust-Machine-Learning:

cescoffier/puppet-nexus: A Puppet Module

文的笔顺,诠释文的笔画,解读文的部首