public void Single_30(byte[] content) { Pro_QiangZhiGuanKong_Mod info = new Pro_QiangZhiGuanKong_Mod(); info.pi_CmdType = "1"; info.pi_ListId = Guid.NewGuid().ToString("N"); info.pi_DeviceTime = ConverUtil.Time(content, 0); //设备时间 info.pi_StationLng = GetPosition(content, 6); //经度。 info.pi_StationLat = GetPosition(content, 10); //维度。 info.pi_param1 = content[14].ToString(); //防拆开关状态。 info.pi_param2 = content[15].ToString(); //电量。 info.pi_param3 = content[28].ToString(); //标志位。 info.pi_param4 = content[29].ToString(); //是否移动。 info.pi_param5 = ConverUtil.ByteToStr_Q(content, 18, 10); //手机串号。 info.pi_param6 = content[16].ToString("D2") + content[17].ToString("D2"); //省市。 info.pi_StationNo = StationId.ToString(); //基站编号。 info.pi_ServiceTime = PlatformTime; //平台时间。 info.pi_InTime = DateTime.Now; //入库时间。 string Result = QiangZhiGuanKongDal.Handle(info); if (Result != "0") { MyLibrary.Log.Debug(Name + "出错:" + Result + " 原始代码:" + OriginalCode); } }
public static void Insert(Pro_QiangZhiGuanKong_Mod info, out ushort resultNo, out string reason) { Database db = DataConnect.GetConnect; DbCommand cmd = db.GetStoredProcCommand("Pro_QiangZhiGuanKong"); db.AddInParameter(cmd, ":pi_CmdType", DbType.String, info.pi_CmdType); db.AddInParameter(cmd, ":pi_ListId", DbType.String, info.pi_ListId); db.AddInParameter(cmd, ":pi_DeviceTime", DbType.Date, info.pi_DeviceTime); db.AddInParameter(cmd, ":pi_DeviceCode", DbType.String, info.pi_DeviceCode); db.AddInParameter(cmd, ":pi_StationAddress", DbType.String, info.pi_StationAddress); db.AddInParameter(cmd, ":pi_StationLng", DbType.String, info.pi_StationLng); db.AddInParameter(cmd, ":pi_StationLat", DbType.String, info.pi_StationLat); db.AddInParameter(cmd, ":pi_param1", DbType.String, info.pi_param1); db.AddInParameter(cmd, ":pi_param2", DbType.String, info.pi_param2); db.AddInParameter(cmd, ":pi_param3", DbType.String, info.pi_param3); db.AddInParameter(cmd, ":pi_param4", DbType.String, info.pi_param4); db.AddInParameter(cmd, ":pi_param5", DbType.String, info.pi_param5); db.AddInParameter(cmd, ":pi_param6", DbType.String, info.pi_param6); db.AddInParameter(cmd, ":pi_param7", DbType.String, info.pi_param7); db.AddInParameter(cmd, ":pi_param8", DbType.String, info.pi_param8); db.AddInParameter(cmd, ":pi_param9", DbType.String, info.pi_param9); db.AddInParameter(cmd, ":pi_param10", DbType.String, info.pi_param10); db.AddInParameter(cmd, ":pi_StationNo", DbType.String, info.pi_StationNo); db.AddInParameter(cmd, ":pi_ServiceTime", DbType.Date, info.pi_ServiceTime); db.AddInParameter(cmd, ":pi_InTime", DbType.Date, info.pi_InTime); db.AddOutParameter(cmd, ":po_resultnum", DbType.String, 256); db.AddOutParameter(cmd, ":po_reason", DbType.String, 256); db.ExecuteNonQuery(cmd); resultNo = Convert.ToUInt16(db.GetParameterValue(cmd, ":po_resultnum")); reason = db.GetParameterValue(cmd, ":po_reason").ToString(); }
public static string Handle(Pro_QiangZhiGuanKong_Mod info) { ushort resultnum; string reason; Pro_QiangZhiGuanKong_Dal.Insert(info, out resultnum, out reason); if (resultnum == 0) { return("0"); } else { return(reason); } }
public bool Execute() { try { if (_content.Length != 19) { MyLibrary.Log.Debug(Name + "长度无效:原始代码:" + OriginalCode); return(true); } DateTime time = ConverUtil.Time(_content, 0); //设备时间。 string DeviceType = ConverUtil.ByteToStr_2(_content, 7); //设备类型。 string DeviceCode = ConverUtil.ByteToStr_4(_content, 9); //设备编码。 string cmdid = _content[13].ToString(); //命令字。 string Sheng = _content[14].ToString(); //省。 string Shi = _content[15].ToString(); //市。 // GetStationInfo(StationId.ToString()); Pro_QiangZhiGuanKong_Mod info = new Pro_QiangZhiGuanKong_Mod(); info.pi_CmdType = "2"; info.pi_ListId = Guid.NewGuid().ToString("N"); info.pi_DeviceCode = DeviceCode; info.pi_StationNo = StationId.ToString(); info.pi_DeviceTime = time; info.pi_ServiceTime = PlatformTime; info.pi_InTime = DateTime.Now; string Result = QiangZhiGuanKongDal.Handle(info); if (Result != "0") { MyLibrary.Log.Debug(Name + "出错:" + Result + " 原始代码:" + OriginalCode); } } catch (Exception ex) { MyLibrary.Log.Error(Name + "出错:" + ex.Message + " 原始代码:" + OriginalCode); } return(true); }