[C#] syntaxhighlighter_viewsource syntaxhighlighter_copycode
##0296QN=20191107113443000;ST=27;CN=2011
W=123456;MN=1122334455;Flag=4;CP=&&DataTime=20191107113443;a00000-Rtd=0.06,a00000-Flag=N;v1-Rtd=0.69,v1-Flag=N;k1-Rtd=0.33,k1-Flag=N;y2-Rtd=0.0,y2-Flag=D;v2-Rtd=0.0,v2-Flag=D;k2-Rtd=0.0,k2-Flag=D;10-Rtd=0.0,10-Flag=N,21-Rtd=0.0,21-Flag=N,22-Rtd=0.0,22-Flag=N&&8941
##0133QN=20191107113443000;ST=27;CN=2021W=123456;MN=1122334455;Flag=5;CP=&&DataTime=20191107113443;SB1-RS=0;SB2-RS=0;SB3-RS=0;SB4-RS=0;&&7BC0
[C#] syntaxhighlighter_viewsource syntaxhighlighter_copycode
public class CRC
{
#region CRC16
//public static byte[] CRC16(byte[] data)
//{
// int len = data.Length;
// if (len > 0)
// {
// ushort crc = 0xFFFF;
// for (int i = 0; i < len; i++)
// {
// crc = (ushort)(crc ^ (data));
// for (int j = 0; j < 8; j++)
// {
// crc = (crc & 1) != 0 ? (ushort)((crc >> 1) ^ 0xA001) : (ushort)(crc >> 1);
// }
// }
// byte hi = (byte)((crc & 0xFF00) >> 8); //高位置
// byte lo = (byte)(crc & 0x00FF); //低位置
// return new byte[] { hi, lo };
// }
// return new byte[] { 0, 0 };
//}
/// <summary>
/// 针对HJ-212-2017的CRC16校验算法
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static byte[] CRC16(byte[] data)
{
int len = data.Length, check;
if (len > 0)
{
ushort crc = 0xFFFF;
for (int i = 0; i < len; i++)
{
crc = (ushort)((crc >> 8) ^ (data));
for (int j = 0; j < 8; j++)
{
check = crc & 0x0001;
crc >>= 1;
if (check == 0x001)
{
crc ^= 0xA001;
}
//crc = (crc & 1) != 0 ? (ushort)((crc >> 1) ^ 0xA001) : (ushort)(crc >> 1);
}
}
byte hi = (byte)((crc & 0xFF00) >> 8); //高位置
byte lo = (byte)(crc & 0x00FF); //低位置
return new byte[] { hi, lo };
}
return new byte[] { 0, 0 };
}
#endregion
#region ToCRC16
public static string ToCRC16(string content)
{
return ToCRC16(content, Encoding.UTF8);
}
public static string ToCRC16(string content, bool isReverse)
{
return ToCRC16(content, Encoding.UTF8, isReverse);
}
public static string ToCRC16(string content, Encoding encoding)
{
return ByteToString(CRC16(encoding.GetBytes(content)), true);
}
public static string ToCRC16(string content, Encoding encoding, bool isReverse)
{
return ByteToString(CRC16(encoding.GetBytes(content)), isReverse);
}
public static string ToCRC16(byte[] data)
{
return ByteToString(CRC16(data), true);
}
public static string ToCRC16(byte[] data, bool isReverse)
{
return ByteToString(CRC16(data), isReverse);
}
#endregion
#region ToModbusCRC16
public static string ToModbusCRC16(string s)
{
return ToModbusCRC16(s, true);
}
public static string ToModbusCRC16(string s, bool isReverse)
{
return ByteToString(CRC16(StringToHexByte(s)), isReverse);
}
public static string ToModbusCRC16(byte[] data)
{
return ToModbusCRC16(data, true);
}
public static string ToModbusCRC16(byte[] data, bool isReverse)
{
return ByteToString(CRC16(data), isReverse);
}
#endregion
#region ByteToString
public static string ByteToString(byte[] arr, bool isReverse)
{
try
{
byte hi = arr[0], lo = arr[1];
return Convert.ToString(isReverse ? hi + lo * 0x100 : hi * 0x100 + lo, 16).ToUpper().PadLeft(4, '0');
}
catch (Exception ex) { throw (ex); }
}
public static string ByteToString(byte[] arr)
{
try
{
return ByteToString(arr, true);
}
catch (Exception ex) { throw (ex); }
}
#endregion
#region StringToHexString
public static string StringToHexString(string str)
{
StringBuilder s = new StringBuilder();
foreach (short c in str.ToCharArray())
{
s.Append(c.ToString("X4"));
}
return s.ToString();
}
#endregion
#region StringToHexByte
private static string ConvertChinese(string str)
{
StringBuilder s = new StringBuilder();
foreach (short c in str.ToCharArray())
{
if (c <= 0 || c >= 127)
{
s.Append(c.ToString("X4"));
}
else
{
s.Append((char)c);
}
}
return s.ToString();
}
private static string FilterChinese(string str)
{
StringBuilder s = new StringBuilder();
foreach (short c in str.ToCharArray())
{
if (c > 0 && c < 127)
{
s.Append((char)c);
}
}
return s.ToString();
}
/// <summary>
/// 字符串转16进制字符数组
/// </summary>
/// <param name="hex"></param>
/// <returns></returns>
public static byte[] StringToHexByte(string str)
{
return StringToHexByte(str, false);
}
/// <summary>
/// 字符串转16进制字符数组
/// </summary>
/// <param name="str"></param>
/// <param name="isFilterChinese">是否过滤掉中文字符</param>
/// <returns></returns>
public static byte[] StringToHexByte(string str, bool isFilterChinese)
{
string hex = isFilterChinese ? FilterChinese(str) : ConvertChinese(str);
//清除所有空格
hex = hex.Replace(" ", "");
//若字符个数为奇数，补一个0
hex += hex.Length % 2 != 0 ? "0" : "";
byte[] result = new byte[hex.Length / 2];
for (int i = 0, c = result.Length; i < c; i++)
{
result = Convert.ToByte(hex.Substring(i * 2, 2), 16);
}
return result;
}
#endregion
}
[SQL] syntaxhighlighter_viewsource syntaxhighlighter_copycode
BEGIN
declare @startDate datetime
declare @endDate datetime
SELECT @startDate = '2019-11-24 02:00:00' ,@endDate = '2019-11-25 02:00:00'
;WITH tb AS (
SELECT @startDate AS 'DateHour'
UNION ALL
SELECT DATEADD(HOUR,1,DateHour) FROM tb WHERE DateHour<@endDate
)
SELECT DateHour,round(AVG(b.Y1),2) as Y1,round(AVG(b.V1),2) as V1,round(AVG(b.K1),2) as K1
from tb a LEFT JOIN t_o_data b ON
CONVERT(VARCHAR(100),a.DateHour,112)=CONVERT(VARCHAR(100),b.DataTime,112)
AND DATEPART(HOUR, a.datehour)=DATEPART(hour, b.DataTime) AND b.Y1>0 AND b.MN='1122334455'
GROUP BY datehour
ORDER BY datehour ASC
END
