• 大小: 708KB
    文件类型: .rar
    金币: 1
    下载: 0 次
    发布日期: 2021-05-21
  • 语言: C#
  • 标签:

资源简介

VS2015开发的远程数据采集后台,C#源码,协议解析

资源截图

代码片段和文件信息

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Text;

namespace RMS
{
    class CommonDAL
    {
        /// 
        /// 将收到的数据存入数据库
        /// 

        /// 
        /// 
        public bool InsertNewData(DataPacket model)
        {
            StringBuilder strSql = new StringBuilder();//.ToString(“yyyyMMddhhmmss“)  
            strSql.Append(“insert into DataPacket ([ReceiveTime][DTUID][CPVersionID][CAddress][DeviceID][ControlName][RTN][ParaValueLength][CheckCode][Data1][Data2][Data3][Data4][Data5][Data6][Data7][Data8][Data9][Data10][Data11][Data12][Data13][Data14][Data15][Data16][Data17][Data18][Data19][Data20][Data21][Data22][Data23][Data24][Data25]) values (@ReceiveTime@DTUID@CPVersionID@CAddress@DeviceID@ControlName@RTN@ParaValueLength@CheckCode@Data1@Data2@Data3@Data4@Data5@Data6@Data7@Data8@Data9@Data10@Data11@Data12@Data13@Data14@Data15@Data16@Data17@Data18@Data19@Data20@Data21@Data22@Data23@Data24@Data25)“);

            SqlParameter[] parameters = {
                        new SqlParameter(“@CPVersionID“ SqlDbType.VarChar20) 
                        new SqlParameter(“@CAddress“ SqlDbType.VarChar20)   
                        new SqlParameter(“@DeviceID“ SqlDbType.VarChar20)
                        new SqlParameter(“@ControlName“ SqlDbType.VarChar20)
                        new SqlParameter(“@ParaValueLength“ SqlDbType.VarChar20)
                        new SqlParameter(“@CheckCode“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data1“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data2“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data3“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data4“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data5“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data6“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data7“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data8“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data9“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data10“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data11“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data12“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data13“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data14“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data15“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data16“ SqlDbType.VarChar20)
                        new SqlParameter(“@Data17“ SqlDbType.VarChar20)
                        new SqlParameter

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

    ..A..H.     87040  2017-07-07 08:58  DataCollection\.vs\RMSDataCollection\v14\.suo

     文件        390  2016-04-19 17:59  DataCollection\RMSDataCollection\App.config

     文件     122880  2015-04-02 11:54  DataCollection\RMSDataCollection\bin\Debug\gprsdll.dll

     文件        379  2015-06-08 16:56  DataCollection\RMSDataCollection\bin\Debug\RMS.vshost.exe.config

     文件     283648  2017-02-25 10:52  DataCollection\RMSDataCollection\bin\Debug\RMSDataCollection.exe

     文件        390  2016-04-19 17:59  DataCollection\RMSDataCollection\bin\Debug\RMSDataCollection.exe.config

     文件     271872  2017-02-25 10:52  DataCollection\RMSDataCollection\bin\Debug\RMSDataCollection.pdb

     文件      21688  2017-07-07 08:56  DataCollection\RMSDataCollection\bin\Debug\RMSDataCollection.vshost.exe

     文件        390  2016-04-19 17:59  DataCollection\RMSDataCollection\bin\Debug\RMSDataCollection.vshost.exe.config

     文件        490  2012-06-06 02:06  DataCollection\RMSDataCollection\bin\Debug\RMSDataCollection.vshost.exe.manifest

     文件      26732  2016-09-13 17:44  DataCollection\RMSDataCollection\CommonDAL.cs

     文件        520  2015-05-11 09:38  DataCollection\RMSDataCollection\CommonString.cs

     文件       8316  2016-04-08 17:07  DataCollection\RMSDataCollection\DataPacket.cs

     文件     125192  2015-05-11 09:33  DataCollection\RMSDataCollection\DbHelperSQL.cs

     文件       9021  2015-05-11 09:33  DataCollection\RMSDataCollection\DTUdll.cs

     文件        147  2015-08-17 12:01  DataCollection\RMSDataCollection\DTUListDataset.cs

     文件      42473  2015-08-17 12:01  DataCollection\RMSDataCollection\DTUListDataset.Designer.cs

     文件        361  2015-08-17 12:01  DataCollection\RMSDataCollection\DTUListDataset.xsc

     文件       4152  2015-08-17 12:01  DataCollection\RMSDataCollection\DTUListDataset.xsd

     文件        851  2015-08-17 12:01  DataCollection\RMSDataCollection\DTUListDataset.xss

     文件       3647  2017-07-07 08:57  DataCollection\RMSDataCollection\frmAbout.cs

     文件       9319  2017-07-07 08:57  DataCollection\RMSDataCollection\frmAbout.Designer.cs

     文件       5817  2017-07-07 08:57  DataCollection\RMSDataCollection\frmAbout.resx

     文件      48946  2017-07-07 08:57  DataCollection\RMSDataCollection\frmMain.cs

     文件      43671  2017-07-07 08:57  DataCollection\RMSDataCollection\frmMain.Designer.cs

     文件      33984  2017-07-07 08:57  DataCollection\RMSDataCollection\frmMain.resx

     文件      41982  2016-09-29 15:32  DataCollection\RMSDataCollection\Frm_SetDTU.cs

     文件     110718  2016-04-19 15:19  DataCollection\RMSDataCollection\Frm_SetDTU.Designer.cs

     文件       6190  2016-04-19 15:19  DataCollection\RMSDataCollection\Frm_SetDTU.resx

     文件     122880  2015-04-02 11:54  DataCollection\RMSDataCollection\gprsdll.dll

............此处省略55个文件信息

评论

共有 条评论

相关资源