Exemplo n.º 1
0
        public static int InsertData1000(ObsParams params1, float[] GHISum1000, float[] GTISum1000)
        {
            int ret = MysqlDAO.Insert2Db1000(params1, GHISum1000, GTISum1000);

            return(ret);

            /*    string sql = @" insert into obsdata(StationName,StationNO,ObsTime,GHI,GTI,PanleTemp,Temperature,Humitity,WindSpeed,WindDir,GHISum,GTISum)
             *                  values(@StationName,@StationNO,@ObsTime,@GHI,@GTI,@PanleTemp,@Temperature,@Humitity,@WindSpeed,@WindDir,@GHISum,@GTISum)
             *
             *                  ";
             *
             *  try
             *  {
             *      List<OleDbParameter> paramList = new List<OleDbParameter>();
             *      paramList.Add(new OleDbParameter("@StationName", params1.StationName));
             *      paramList.Add(new OleDbParameter("@StationNO", params1.StationNO));
             *      paramList.Add(new OleDbParameter("@ObsTime", params1.ObsTime));
             *      paramList.Add(new OleDbParameter("@GHI", params1.GHI));
             *      paramList.Add(new OleDbParameter("@GTI", params1.GTI));
             *      paramList.Add(new OleDbParameter("@PanleTemp", params1.PanleTemp));
             *      paramList.Add(new OleDbParameter("@Temperature", params1.Temperature));
             *      paramList.Add(new OleDbParameter("@Humitity", params1.Humitity));
             *      paramList.Add(new OleDbParameter("@WindSpeed", params1.WindSpeed));
             *      paramList.Add(new OleDbParameter("@WindDir", params1.WindDir));
             *      paramList.Add(new OleDbParameter("@GHISum", params1.GHISum));
             *      paramList.Add(new OleDbParameter("@GTISum", params1.GTISum));
             *
             *      return AccessHelper.ExecuteNonQuery(conn, sql, paramList.ToArray());
             *  }
             *  catch (System.Exception ex)
             *  {
             *      return 0;
             *  }*/
        }
Exemplo n.º 2
0
        public static ObsParams GetObsParams(byte[] data1)
        {
            ObsParams param = null;

            using (MemoryStream memoryStream = new MemoryStream(data1))
            {
                try
                {
                    BinaryReader br = new BinaryReader(memoryStream);
                    br.ReadBytes(2);
                    int Count = Convert.ToInt32(br.ReadByte());
                    if (Count < 20)
                    {
                        return(null);
                    }

                    param = new ObsParams();
                    //param.EquipNO = Convert.ToInt32(ChangeXL(br.ReadSingle())).ToString();
                    //param.StationNO = Convert.ToInt32(ChangeXL(br.ReadSingle()));
                    //param.Year = Convert.ToInt32(ChangeXL(br.ReadSingle()));
                    //param.Month = Convert.ToInt32(ChangeXL(br.ReadSingle()));
                    //param.Day = Convert.ToInt32(ChangeXL(br.ReadSingle()));
                    //param.Hour = Convert.ToInt32(ChangeXL(br.ReadSingle()));
                    //param.Minute = Convert.ToInt32(ChangeXL(br.ReadSingle()));
                    //param.Second= Convert.ToInt32(ChangeXL(br.ReadSingle()));

                    param.GHISum      = Convert.ToSingle(ChangeXLU16(br.ReadUInt16())) / 1000;
                    param.GTISum      = Convert.ToSingle(ChangeXLU16(br.ReadUInt16())) / 1000;
                    param.PanleTemp   = Convert.ToSingle(ChangeXL16(br.ReadInt16())) / 10;
                    param.Temperature = Convert.ToSingle(ChangeXL16(br.ReadInt16())) / 10;
                    param.Humitity    = Convert.ToSingle(ChangeXLU16(br.ReadUInt16())) / 10;
                    param.WindSpeed   = Convert.ToSingle(ChangeXLU16(br.ReadUInt16())) / 10;
                    param.WindSpeed   = Convert.ToSingle(ChangeXLU16(br.ReadUInt16())) / 10;
                    param.WindDir     = Convert.ToSingle(ChangeXLU16(br.ReadUInt16()));
                    param.GHI         = Convert.ToSingle(ChangeXLU16(br.ReadUInt16()));
                    param.GTI         = Convert.ToSingle(ChangeXLU16(br.ReadUInt16()));

                    //param.WindSpeed = ChangeXL(br.ReadSingle());
                    // param.WindDir = ChangeXL(br.ReadSingle());
                    //param.mVisibity = ChangeXL(br.ReadSingle());
                    //param.BatteryVolt = ChangeXL(br.ReadSingle());
                    return(param);
                }
                catch
                {
                    return(null);
                }
            }
        }
Exemplo n.º 3
0
        public static int Insert2Db1000(ObsParams params1, float[] GHISum1000, float[] GTISum1000)
        {
            //"datasource=localhost;username=root;password=NCEPU_fluence.;database=topflag
            string          connectionString = "Server=localhost;User Id=root;Password=123456789;Persist Security Info=True;Database=topflag;";
            MySqlConnection cn = new MySqlConnection(connectionString);
            //int EXIST = Exist(params1.StationName, params1.ObsTime);
            //if (EXIST==1)
            //{
            //return 0;
            // }
            int res = 0;

            try
            {//(   StationID) Values ( @StationID);
                string       sql = @" 
                                insert into obsdata1000(StationName,StationNO,ObsTime,GHI,GTI,GHISum,GTISum,GHISum1000,GTISum1000) 
                                values(@StationName,@StationNO,@ObsTime,@GHI,@GTI,@GHISum,@GTISum,@GHISum1000,@GTISum1000)";
                MySqlCommand cmd = new MySqlCommand(sql, cn);

                cmd.Parameters.Add(new MySqlParameter("@StationName", MySqlDbType.VarChar)
                {
                    Value = params1.StationName
                });
                cmd.Parameters.Add(new MySqlParameter("@StationNO", MySqlDbType.Int32)
                {
                    Value = params1.StationNO
                });
                cmd.Parameters.Add(new MySqlParameter("@ObsTime", MySqlDbType.DateTime)
                {
                    Value = params1.ObsTime
                });

                cmd.Parameters.Add(new MySqlParameter("@GHI", MySqlDbType.Float)
                {
                    Value = params1.GHI
                });
                cmd.Parameters.Add(new MySqlParameter("@GTI", MySqlDbType.Float)
                {
                    Value = params1.GTI
                });
                cmd.Parameters.Add(new MySqlParameter("@GHISum", MySqlDbType.Float)
                {
                    Value = params1.GHISum
                });
                cmd.Parameters.Add(new MySqlParameter("@GTISum", MySqlDbType.Float)
                {
                    Value = params1.GTISum
                });
                cmd.Parameters.Add(new MySqlParameter("@GHISum1000", MySqlDbType.Float)
                {
                    Value = GHISum1000[params1.StationNO - 1]
                });
                cmd.Parameters.Add(new MySqlParameter("@GTISum1000", MySqlDbType.Float)
                {
                    Value = GTISum1000[params1.StationNO - 1]
                });

                cn.Open();
                res = cmd.ExecuteNonQuery();
            }
            catch (System.Exception ex)
            {
                res = -1;
            }
            finally
            {
                cn.Close();
                cn.Dispose();
            }
            return(res);
        }
Exemplo n.º 4
0
        public static ObsParams GetObsParams_old(string data1)
        {
            ObsParams param = new ObsParams();

            try
            {
                string StationNO = data1.Substring(1, 4);
                uint   num       = uint.Parse(StationNO, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals = BitConverter.GetBytes(num);
                param.StationNO = BitConverter.ToInt16(floatVals, 0);

                string hexString  = data1.Substring(87, 4);
                uint   num2       = uint.Parse(hexString, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals2 = BitConverter.GetBytes(num2);
                param.GHISum = Convert.ToSingle(BitConverter.ToInt16(floatVals2, 0)) / 10;

                string GTISum     = data1.Substring(79, 4);
                uint   num3       = uint.Parse(GTISum, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals3 = BitConverter.GetBytes(num3);
                param.GTISum = Convert.ToSingle(BitConverter.ToInt16(floatVals3, 0)) / 10;

                string PanleTemp  = data1.Substring(107, 4);
                uint   num4       = uint.Parse(PanleTemp, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals4 = BitConverter.GetBytes(num4);
                param.PanleTemp = Convert.ToSingle(BitConverter.ToInt16(floatVals4, 0));

                string Temperature = data1.Substring(117, 4);
                uint   num5        = uint.Parse(Temperature, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals5  = BitConverter.GetBytes(num5);
                param.Temperature = Convert.ToSingle(BitConverter.ToInt16(floatVals5, 0)) / 10;

                string Humitity   = data1.Substring(117, 4);
                uint   num6       = uint.Parse(Humitity, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals6 = BitConverter.GetBytes(num6);
                param.Humitity = Convert.ToSingle(BitConverter.ToInt16(floatVals6, 0)) / 10;

                string WindSpeed  = data1.Substring(117, 4);
                uint   num7       = uint.Parse(WindSpeed, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals7 = BitConverter.GetBytes(num7);
                param.WindSpeed = Convert.ToSingle(BitConverter.ToInt16(floatVals7, 0)) / 10;

                string WindDir    = data1.Substring(117, 4);
                uint   num8       = uint.Parse(WindDir, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals8 = BitConverter.GetBytes(num8);
                param.WindDir = Convert.ToSingle(BitConverter.ToInt16(floatVals8, 0)) / 10;

                string GHI        = data1.Substring(117, 4);
                uint   num9       = uint.Parse(GHI, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals9 = BitConverter.GetBytes(num9);
                param.GHI = Convert.ToSingle(BitConverter.ToInt16(floatVals9, 0)) / 10;

                string GTI         = data1.Substring(117, 4);
                uint   num10       = uint.Parse(GHI, System.Globalization.NumberStyles.AllowHexSpecifier);
                byte[] floatVals10 = BitConverter.GetBytes(num9);
                param.GHI = Convert.ToSingle(BitConverter.ToInt16(floatVals10, 0)) / 10;
            }
            catch (System.Exception ex)
            {
                param = null;
            }
            return(param);
        }
Exemplo n.º 5
0
        // void bw_DoWork(object sender, DoWorkEventArgs e)
        void bw_DoWork(System.IO.Ports.SerialPort sport)
        {   // 需要在此写入接收程序,判断信息
            //  System.IO.Ports.SerialPort sport = e.Argument as System.IO.Ports.SerialPort;
            string sp = sport.PortName;
            string stationName = GetEquipNo(sp);
            string StationNo = GetStationNo(sp);
            bool equiptype = IfOld(sp);
            if (equiptype == false)
            {
                byte[] RcvBytes = new byte[sport.BytesToRead];



                Thread.Sleep(3000);
                int lIntLen = sport.Read(RcvBytes, 0, RcvBytes.Length);
                if (params1 != null)
                {
                    params1 = null;

                }
                //从串口获取数据
                params1 = new ObsParams();    // 定义到数据库文件,应该是一样的
                if (lIntLen < 25)
                {
                    byte[] RcyByte_all = RcvBytes;
                    sp = sport.PortName;
                    stationName = GetEquipNo(sp);
                    StationNo = GetStationNo(sp);
                    byte[] RcvBytes_new = new byte[sport.BytesToRead];
                    lIntLen = sport.Read(RcvBytes_new, 0, RcvBytes_new.Length);

                    byte[] result = new byte[RcyByte_all.Length + RcvBytes_new.Length];
                    RcyByte_all.CopyTo(result, 0);
                    RcvBytes_new.CopyTo(result, RcyByte_all.Length);

                    RcvBytes = result;
                    
                    //lIntLen = sport.Read(RcvBytes, 0, RcvBytes.Length);
                    if (RcvBytes.Length < 25)
                    {
                        return;
                    }
    
                }
               params1 = Common.GetObsParams(RcvBytes);
            }
            else
            {
                char[] RcvBytes_old = new char[sport.BytesToRead];
                Thread.Sleep(3000);
                int lIntLen = sport.Read(RcvBytes_old, 0, RcvBytes_old.Length);
                if (params1 != null)
                {
                    params1 = null;

                }
                //从串口获取数据
                params1 = new ObsParams();    // 定义到数据库文件,应该是一样的
                if (lIntLen < 117)
                {
                    char[] RcyByte_all = RcvBytes_old;
                    sp = sport.PortName;
                    stationName = GetEquipNo(sp);
                    StationNo = GetStationNo(sp);
                    char[] RcvBytes_new =new char[sport.BytesToRead];
                    lIntLen = sport.Read(RcvBytes_new, 0, RcvBytes_new.Length);

                    char[] result = new char[RcyByte_all.Length + RcvBytes_new.Length];
                    RcyByte_all.CopyTo(result, 0);
                    RcvBytes_new.CopyTo(result, RcyByte_all.Length);
                    RcvBytes_old = result;

                }
                    
                    string RcvBytes_string = new string(RcvBytes_old);
                   
                    params1 = Common.GetObsParams_old(RcvBytes_string);
                    //lIntLen = sport.Read(RcvBytes, 0, RcvBytes.Length);
                    if (RcvBytes_old.Length < 117)
                    {
                        return;
                    }



            }




            if (params1 == null)
            {
                return;
            }

            params1.StationName = stationName;
            int.TryParse(StationNo, out params1.StationNO);
  
           // int ret = DAO.Exist(params1.StationName, params1.ObsTime);// 判断是否有重复的数据
            //if (ret<1)
            //{
                
            DAO.InsertData(params1);



            try
            {

                    ObsParams parameter_lg =new ObsParams();
                    ObsParams parameter_yp = new ObsParams();
                    ObsParams parameter_gly = new ObsParams();
                    ObsParams parameter_zhtb = new ObsParams();
                    ObsParams parameter_wwz = new ObsParams();
                    ObsParams parameter_swzy = new ObsParams();
                    ObsParams parameter_jsd = new ObsParams();
                    ObsParams parameter_hj = new ObsParams();
                    ObsParams parameter_tc = new ObsParams();
                if (params1.StationNO != null)
                {
                    // Member.obsParamsList.Add(params1);
                    switch (Convert.ToInt32(params1.StationNO))
                    {
                        case 1:
                            Member.parameter_lg = params1;
                            break;
                        case 2:
                            Member.parameter_yp = params1;
                            break;
                        case 3:
                            Member.parameter_jsd = params1;
                            break;
                        case 4:
                            Member.parameter_zhtb = params1;
                            break;
                        case 5:
                            Member.parameter_tc = params1;
                            break;
                        case 6:
                            Member.parameter_swzy = params1;
                            break;
                        case 7:
                            Member.parameter_hj = params1;
                            break;
                        case 8:
                            Member.parameter_gly = params1;
                            break;
                        case 9:
                            Member.parameter_wwz = params1;

                            break;
                        default:
                            //Member.parameter_wwz = params1;
                            break;

                    }
                }
            }
            
            catch (System.Exception ex)
            {

            }
        

            /*case 1

                 Member.parameter_lg = params1;
            endswitc
            if (Convert.ToInt32(params1.StationNO) == 1)
            {
                Member.parameter_lg = params1;
            }

            if (Convert.ToInt32(params1.StationNO) == 2)
            {
                Member.parameter_yp = params1;
            }
            if (Convert.ToInt32(params1.StationNO) == 3)
            {
                Member.parameter_jsd = params1;
            }
            if (Convert.ToInt32(params1.StationNO) == 4)
            {
                Member.parameter_zhtb = params1;
            }
            if (Convert.ToInt32(params1.StationNO) == 5)
            {
                Member.parameter_tc = params1;
            }
            if (Convert.ToInt32(params1.StationNO) == 6)
            {
                Member.parameter_swzy = params1;
            }
            if (Convert.ToInt32(params1.StationNO) == 7)
            {
                Member.parameter_hj = params1;
            }
            if (Convert.ToInt32(params1.StationNO) == 8)
            {
                Member.parameter_gly = params1;
            }
            if (Convert.ToInt32(params1.StationNO) == 9)
            {
                Member.parameter_wwz = params1;
            }*/
            

            //frmobsdatall.FenpeiData(params1);

              //  判断是否大于1000,数据是否增加  biyonghrng  xinjia
  
               //if (params1.Hour==0 && params1.Minute==0)
               //{
               //    GHISum1000 = new float[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0};
               //    GTISum1000 = new float[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
               //} 
               //else
               //{
               //    if (params1.GHI >= 1000 || params1.GTI >= 1000)
               //    {

               //        GHISum1000[params1.StationNO-1] = GHISum1000[params1.StationNO-1] + params1.GHI / 1000000*20;
               //        GTISum1000[params1.StationNO-1] = GTISum1000[params1.StationNO-1] + params1.GTI / 1000000*20;

               //        DAO.InsertData1000(params1,GHISum1000,GTISum1000);
               //    }
               //}
                  


               //////

                //MysqlConnection.InsertToDb(params1);
                //InsertFirstDataDao.readHistoryData();
                //Ms_SQLDAO.InsertToDb(params1);
                
            //}


            if (stationName == selectStationNo)
            {
                MethodInvoker mi = new MethodInvoker(SetControlsProp);
                BeginInvoke(mi);
            }

        }