public static SqlDataReader ReaderSelect(MeasureE1Data d)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from MeasureE1 ");
return(WFNetLib.ADO.SQLServerOP.ReaderExecuteSQL(sql.ToString()));
}
public static DataTable DataTableSelect(MeasureE1Data d)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from MeasureE1 where ID=");
sql.Append("");
sql.Append(d.ID.ToString());
sql.Append("");
return(WFNetLib.ADO.SQLServerOP.DataTableSQL(sql.ToString()));
}
public static int Delete(MeasureE1Data d)
{
StringBuilder sql = new StringBuilder();
sql.Append("delete from MeasureE1 ");
sql.Append(" where ID=");
sql.Append("");
sql.Append(d.ID.ToString());
sql.Append("");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static void AnalyzeE1Data(ref MeasureE1Data e1, byte[] data, uint len)
{
for (uint i = 0; i < len;)
{
switch (data[i])
{
case 0xb8:
e1.B8 = StringsFunction.byteToHexStr(data, (int)(i + 1), 8, "");
i = i + 1 + 8;
break;
case 0xb9:
e1.B9 = StringsFunction.byteToHexStr(data, (int)(i + 1), 8, "");
i = i + 1 + 8;
break;
case 0xba:
e1.BA = StringsFunction.byteToHexStr(data, (int)(i + 1), 8, "");
i = i + 1 + 8;
break;
case 0xbb:
e1.BB = StringsFunction.byteToHexStr(data, (int)(i + 1), 8, "");
i = i + 1 + 8;
break;
case 0xbc:
e1.BC = StringsFunction.byteToHexStr(data, (int)(i + 1), 7, "");
i = i + 1 + 7;
break;
case 0xbd:
e1.BD = StringsFunction.byteToHexStr(data, (int)(i + 1), 7, "");
i = i + 1 + 7;
break;
case 0xbe:
e1.BE = StringsFunction.byteToHexStr(data, (int)(i + 1), 7, "");
i = i + 1 + 7;
break;
case 0xbf:
e1.BF = StringsFunction.byteToHexStr(data, (int)(i + 1), 7, "");
i = i + 1 + 7;
break;
case 0xc0:
e1.C0 = StringsFunction.byteToHexStr(data, (int)(i + 1), 4, "");
i = i + 1 + 4;
break;
case 0xc1:
e1.C1 = StringsFunction.byteToHexStr(data, (int)(i + 1), 4, "");
i = i + 1 + 4;
break;
case 0xc2:
e1.C2 = StringsFunction.byteToHexStr(data, (int)(i + 1), 4, "");
i = i + 1 + 4;
break;
case 0xc3:
e1.C3 = StringsFunction.byteToHexStr(data, (int)(i + 1), 4, "");
i = i + 1 + 4;
break;
case 0xc4:
e1.C4 = StringsFunction.byteToHexStr(data, (int)(i + 1), 1, "");
i = i + 1 + 1;
break;
case 0xc5:
e1.C5 = StringsFunction.byteToHexStr(data, (int)(i + 1), 1, "");
i = i + 1 + 1;
break;
case 0xc6:
e1.C6 = StringsFunction.byteToHexStr(data, (int)(i + 1), 1, "");
i = i + 1 + 1;
break;
case 0xc7:
e1.C7 = StringsFunction.byteToHexStr(data, (int)(i + 1), 1, "");
i = i + 1 + 1;
break;
case 0xc8:
e1.C8 = StringsFunction.byteToHexStr(data, (int)(i + 1), 8, "");
i = i + 1 + 8;
break;
case 0xc9:
e1.C9 = StringsFunction.byteToHexStr(data, (int)(i + 1), 8, "");
i = i + 1 + 8;
break;
case 0xca:
e1.CA = StringsFunction.byteToHexStr(data, (int)(i + 1), 9, "");
i = i + 1 + 9;
break;
case 0xcb:
e1.CB = StringsFunction.byteToHexStr(data, (int)(i + 1), 9, "");
i = i + 1 + 9;
break;
case 0xcc:
e1.CC = StringsFunction.byteToHexStr(data, (int)(i + 1), 2, "");
i = i + 1 + 2;
break;
case 0xcd:
e1.CD = StringsFunction.byteToHexStr(data, (int)(i + 1), 2, "");
i = i + 1 + 2;
break;
default:
return;
}
}
}
public static int Update(MeasureE1Data d)
{
StringBuilder sql = new StringBuilder();
sql.Append("update MeasureE1 set ");
sql.Append("Source=");
sql.Append("");
sql.Append(d.Source.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("Ident=");
sql.Append("'");
sql.Append(d.Ident.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Time=");
sql.Append("'");
sql.Append(d.Time.ToString("yyyy-MM-dd HH:mm:ss"));
sql.Append("'");
sql.Append(", ");
sql.Append("Reserve=");
sql.Append("'");
sql.Append(d.Reserve.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("bRead=");
sql.Append("");
if (d.bRead)
{
sql.Append("1");
}
else
{
sql.Append("0");
}
sql.Append("");
sql.Append(", ");
sql.Append("B8=");
sql.Append("'");
sql.Append(d.B8.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("B9=");
sql.Append("'");
sql.Append(d.B9.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("BA=");
sql.Append("'");
sql.Append(d.BA.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("BB=");
sql.Append("'");
sql.Append(d.BB.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("BC=");
sql.Append("'");
sql.Append(d.BC.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("BD=");
sql.Append("'");
sql.Append(d.BD.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("BE=");
sql.Append("'");
sql.Append(d.BE.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("BF=");
sql.Append("'");
sql.Append(d.BF.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C0=");
sql.Append("'");
sql.Append(d.C0.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C1=");
sql.Append("'");
sql.Append(d.C1.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C2=");
sql.Append("'");
sql.Append(d.C2.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C3=");
sql.Append("'");
sql.Append(d.C3.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C4=");
sql.Append("'");
sql.Append(d.C4.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C5=");
sql.Append("'");
sql.Append(d.C5.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C6=");
sql.Append("'");
sql.Append(d.C6.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C7=");
sql.Append("'");
sql.Append(d.C7.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C8=");
sql.Append("'");
sql.Append(d.C8.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("C9=");
sql.Append("'");
sql.Append(d.C9.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("CA=");
sql.Append("'");
sql.Append(d.CA.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("CB=");
sql.Append("'");
sql.Append(d.CB.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("CC=");
sql.Append("'");
sql.Append(d.CC.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("CD=");
sql.Append("'");
sql.Append(d.CD.ToString());
sql.Append("'");
sql.Append(" where ID=");
sql.Append("");
sql.Append(d.ID.ToString()); sql.Append("");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static int Insert(MeasureE1Data d)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into MeasureE1 (");
sql.Append("Source, ");
sql.Append("Ident, ");
sql.Append("Time, ");
sql.Append("Reserve, ");
sql.Append("bRead, ");
sql.Append("B8, ");
sql.Append("B9, ");
sql.Append("BA, ");
sql.Append("BB, ");
sql.Append("BC, ");
sql.Append("BD, ");
sql.Append("BE, ");
sql.Append("BF, ");
sql.Append("C0, ");
sql.Append("C1, ");
sql.Append("C2, ");
sql.Append("C3, ");
sql.Append("C4, ");
sql.Append("C5, ");
sql.Append("C6, ");
sql.Append("C7, ");
sql.Append("C8, ");
sql.Append("C9, ");
sql.Append("CA, ");
sql.Append("CB, ");
sql.Append("CC, ");
sql.Append("CD");
sql.Append(") values (");
sql.Append("");
sql.Append(d.Source.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Ident.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Time.ToString("yyyy-MM-dd HH:mm:ss"));
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Reserve.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("");
if (d.bRead)
{
sql.Append("1");
}
else
{
sql.Append("0");
}
sql.Append("");
sql.Append(", ");
sql.Append("'");
sql.Append(d.B8.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.B9.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.BA.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.BB.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.BC.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.BD.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.BE.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.BF.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C0.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C1.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C2.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C3.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C4.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C5.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C6.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C7.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C8.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.C9.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.CA.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.CB.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.CC.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.CD.ToString());
sql.Append("'");
sql.Append(")");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static MeasureE1Data Construct(DataRow dr)
{
MeasureE1Data data = new MeasureE1Data();
try { data.ID = Convert.ToInt64(dr["ID"]); }
catch { }
try { data.Source = Convert.ToInt32(dr["Source"]); }
catch { }
try { data.Ident = Convert.ToString(dr["Ident"]); }
catch { }
try { data.Time = Convert.ToDateTime(dr["Time"]); }
catch { }
try { data.Reserve = Convert.ToString(dr["Reserve"]); }
catch { }
try { data.bRead = Convert.ToBoolean(dr["bRead"]); }
catch { }
try { data.B8 = Convert.ToString(dr["B8"]); }
catch { }
try { data.B9 = Convert.ToString(dr["B9"]); }
catch { }
try { data.BA = Convert.ToString(dr["BA"]); }
catch { }
try { data.BB = Convert.ToString(dr["BB"]); }
catch { }
try { data.BC = Convert.ToString(dr["BC"]); }
catch { }
try { data.BD = Convert.ToString(dr["BD"]); }
catch { }
try { data.BE = Convert.ToString(dr["BE"]); }
catch { }
try { data.BF = Convert.ToString(dr["BF"]); }
catch { }
try { data.C0 = Convert.ToString(dr["C0"]); }
catch { }
try { data.C1 = Convert.ToString(dr["C1"]); }
catch { }
try { data.C2 = Convert.ToString(dr["C2"]); }
catch { }
try { data.C3 = Convert.ToString(dr["C3"]); }
catch { }
try { data.C4 = Convert.ToString(dr["C4"]); }
catch { }
try { data.C5 = Convert.ToString(dr["C5"]); }
catch { }
try { data.C6 = Convert.ToString(dr["C6"]); }
catch { }
try { data.C7 = Convert.ToString(dr["C7"]); }
catch { }
try { data.C8 = Convert.ToString(dr["C8"]); }
catch { }
try { data.C9 = Convert.ToString(dr["C9"]); }
catch { }
try { data.CA = Convert.ToString(dr["CA"]); }
catch { }
try { data.CB = Convert.ToString(dr["CB"]); }
catch { }
try { data.CC = Convert.ToString(dr["CC"]); }
catch { }
try { data.CD = Convert.ToString(dr["CD"]); }
catch { }
return(data);
}
public static MeasureE1Data Construct(DataGridView dgv, int rowIndex)
{
MeasureE1Data data = new MeasureE1Data();
if (dgv.Rows.Count < rowIndex + 1)
{
return(null);
}
DataGridViewCellCollection dr = dgv.Rows[rowIndex].Cells;
if (dr == null)
{
return(null);
}
try { data.ID = Convert.ToInt64(dr["ID"]); }
catch { }
try { data.Source = Convert.ToInt32(dr["Source"]); }
catch { }
try { data.Ident = Convert.ToString(dr["Ident"]); }
catch { }
try { data.Time = Convert.ToDateTime(dr["Time"]); }
catch { }
try { data.Reserve = Convert.ToString(dr["Reserve"]); }
catch { }
try { data.bRead = Convert.ToBoolean(dr["bRead"]); }
catch { }
try { data.B8 = Convert.ToString(dr["B8"]); }
catch { }
try { data.B9 = Convert.ToString(dr["B9"]); }
catch { }
try { data.BA = Convert.ToString(dr["BA"]); }
catch { }
try { data.BB = Convert.ToString(dr["BB"]); }
catch { }
try { data.BC = Convert.ToString(dr["BC"]); }
catch { }
try { data.BD = Convert.ToString(dr["BD"]); }
catch { }
try { data.BE = Convert.ToString(dr["BE"]); }
catch { }
try { data.BF = Convert.ToString(dr["BF"]); }
catch { }
try { data.C0 = Convert.ToString(dr["C0"]); }
catch { }
try { data.C1 = Convert.ToString(dr["C1"]); }
catch { }
try { data.C2 = Convert.ToString(dr["C2"]); }
catch { }
try { data.C3 = Convert.ToString(dr["C3"]); }
catch { }
try { data.C4 = Convert.ToString(dr["C4"]); }
catch { }
try { data.C5 = Convert.ToString(dr["C5"]); }
catch { }
try { data.C6 = Convert.ToString(dr["C6"]); }
catch { }
try { data.C7 = Convert.ToString(dr["C7"]); }
catch { }
try { data.C8 = Convert.ToString(dr["C8"]); }
catch { }
try { data.C9 = Convert.ToString(dr["C9"]); }
catch { }
try { data.CA = Convert.ToString(dr["CA"]); }
catch { }
try { data.CB = Convert.ToString(dr["CB"]); }
catch { }
try { data.CC = Convert.ToString(dr["CC"]); }
catch { }
try { data.CD = Convert.ToString(dr["CD"]); }
catch { }
return(data);
}
void CH368IntProc()
{
byte[] readHeaderList = new byte[7];
byte[] readDataList = new byte[0x100];
byte read = 0;
/************************************************************************/
/* 读ram */
/************************************************************************/
//拉低片选
if (CH368.CH367mWriteIoByte(CH368Index, mBaseAddr + 0xf8, 0xb0) == 0)
{
MessageBox.Show("1");
return;
}
//读7个字节,判断是否为有效帧
// CH368.CH367mAccessBlock(CH368Index, CH368.mFuncReadMemByte, mMemAddr, readList, 64);
// this.Invoke((EventHandler)(delegate { textBox1.Text = StringsFunction.byteToHexStr(readList, 0, (int)64, " "); }));
//Debug.WriteLine(StringsFunction.byteToHexStr(readList, 0, (int)9, " "));
if (CH368.CH367mAccessBlock(CH368Index, CH368.mFuncReadMemByte, mMemAddr, readHeaderList, 7) == 0)
{
MessageBox.Show("2");
return;
}
if (bLog)
{
this.Invoke((EventHandler)(delegate
{
try
{
textBox1.AppendText(DateTime.Now.ToString() + ":");
textBox1.AppendText(StringsFunction.byteToHexStr(readHeaderList, 0, 7, " "));
}
catch
{
}
}));
//Debug.WriteLine(StringsFunction.byteToHexStr(readList, 0, 7, " "));
}
if (readHeaderList[0] == 0xfa && readHeaderList[1] == 0xf3 && readHeaderList[2] == 0x30)
{
//Debug.WriteLine(StringsFunction.byteToHexStr(readList, 0, 7, " "));
uint readDataLen = readHeaderList[6];// BytesOP.MakeShort(readHeaderList[5], readHeaderList[6]);
if (CH368.CH367mAccessBlock(CH368Index, CH368.mFuncReadMemByte, mMemAddr + 7, readDataList, readDataLen) == 0)
{
MessageBox.Show("3");
return;
}
if (bLog)
{
string str = StringsFunction.byteToHexStr(readDataList, 0, (int)readDataLen, " ");
try
{
this.Invoke((EventHandler)(delegate
{
textBox1.AppendText(str);
}));
}
catch
{
}
}
if (readHeaderList[3] == 0xe0 || readHeaderList[3] == 0xe2)
{
MeasureE0Data e0 = new MeasureE0Data();
e0.Source = readHeaderList[3];
Fuction.AnalyzeE0Data(ref e0, readDataList, readDataLen);
e0.Time = DateTime.Now;
MeasureE0DataDBOption.Insert(e0);
}
else if (readHeaderList[3] == 0xe1 || readHeaderList[3] == 0xe3)
{
MeasureE1Data e1 = new MeasureE1Data();
e1.Source = readHeaderList[3];
Fuction.AnalyzeE1Data(ref e1, readDataList, readDataLen);
e1.Time = DateTime.Now;
MeasureE1DataDBOption.Insert(e1);
}
//Debug.WriteLine(StringsFunction.byteToHexStr(readList, 0, (int)len, " "));
}
if (bLog)
{
this.Invoke((EventHandler)(delegate
{
try
{
// bLog = false;
// timerLog.Enabled = true;
textBox1.AppendText("\r\n");
}
catch
{
}
}));
}
//拉高片选
if (CH368.CH367mWriteIoByte(CH368Index, mBaseAddr + 0xf8, 0xb1) == 0)
{
MessageBox.Show("4");
return;
}
/************************************************************************/
/* 完成读取，告知单片机 */
/************************************************************************/
//拉低SCS，表示在处理完成
if (CH368.CH367mWriteIoByte(CH368Index, mBaseAddr + 0xe8, 0x03) == 0)
{
MessageBox.Show("5");
return;
}
//等待单片机退出通信流程
while (true)
{
if (CH368.CH367mReadIoByte(CH368Index, mBaseAddr + 0xf8, ref read) == 0)
{
MessageBox.Show("10");
return;
}
if (BytesOP.GetBit(read, 3))
{
break;
}
}
//SCS 高电平
if (CH368.CH367mWriteIoByte(CH368Index, mBaseAddr + 0xe8, 0x07) == 0)
{
MessageBox.Show("12");
return;
}
}
