private void Single(byte[] content) { try { Pro_CrewregistDevice_Beat_Mod info = new Pro_CrewregistDevice_Beat_Mod(); info.Pi_DevId = StationId.ToString(); //设备编号 info.Pi_DevTime = ConverUtil.Time(content, 0); //设备时间 info.Pi_StateTFT = content[6].ToString(); //tft屏状态 info.Pi_State433 = content[7].ToString(); //433状态 info.Pi_StateReader = content[8].ToString(); //读卡器状态 info.Pi_StateCard = content[9].ToString(); //身份证读卡器状态 info.Pi_StatePrint = content[10].ToString(); //打印机状态 info.Pi_StateSd = content[11].ToString(); //SD卡状态 UInt16 ResultNum; string Reason; Pro_CrewregistDevice_Beat_Dal.Exec(info, out ResultNum, out Reason); if (ResultNum != 0) { MyLibrary.Log.Debug(Name + "出错;" + Reason + " 原始代码:" + OriginalCode); } } catch (Exception ex) { MyLibrary.Log.Error(Name + "错误:" + ex.Message + " 原始代码:" + OriginalCode); } }
public static void Exec(Pro_CrewregistDevice_Beat_Mod info, out UInt16 resultNum, out string reason) { Database db = DataConnect.GetConnect; DbCommand cmd = db.GetStoredProcCommand("PRO_CREWREGISTDEVICE_BEAT"); db.AddInParameter(cmd, ":pi_devid", DbType.String, info.Pi_DevId); db.AddInParameter(cmd, ":pi_devtime", DbType.Date, info.Pi_DevTime); db.AddInParameter(cmd, ":pi_STATETFT", DbType.String, info.Pi_StateTFT); db.AddInParameter(cmd, ":pi_STATE433", DbType.String, info.Pi_State433); db.AddInParameter(cmd, ":pi_STATEREADER", DbType.String, info.Pi_StateReader); db.AddInParameter(cmd, ":pi_STATECARD", DbType.String, info.Pi_StateCard); db.AddInParameter(cmd, ":pi_STATEPRINT", DbType.String, info.Pi_StatePrint); db.AddInParameter(cmd, ":pi_STATESD", DbType.String, info.Pi_StateSd); db.AddOutParameter(cmd, ":po_ret", DbType.String, 256); db.AddOutParameter(cmd, ":po_content", DbType.String, 256); db.ExecuteNonQuery(cmd); resultNum = Convert.ToUInt16(db.GetParameterValue(cmd, ":po_ret")); reason = db.GetParameterValue(cmd, ":po_content").ToString(); }