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; } }