/// <summary> /// 增加一条数据,返回主键 /// </summary> public int Add(MODEL.DrawerStateModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into drawerstate("); strSql.Append("f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16)"); strSql.Append(" values ("); strSql.Append("@f1,@f2,@f3,@f4,@f5,@f6,@f7,@f8,@f9,@f10,@f11,@f12,@f13,@f14,@f15,@f16);"); strSql.Append(" select last_insert_id() as insertId"); MySqlParameter[] parameters = { new MySqlParameter("@f1", MySqlDbType.Bit), new MySqlParameter("@f2", MySqlDbType.Bit), new MySqlParameter("@f3", MySqlDbType.Bit), new MySqlParameter("@f4", MySqlDbType.Bit), new MySqlParameter("@f5", MySqlDbType.Bit), new MySqlParameter("@f6", MySqlDbType.Bit), new MySqlParameter("@f7", MySqlDbType.Bit), new MySqlParameter("@f8", MySqlDbType.Bit), new MySqlParameter("@f9", MySqlDbType.Bit), new MySqlParameter("@f10", MySqlDbType.Bit), new MySqlParameter("@f11", MySqlDbType.Bit), new MySqlParameter("@f12", MySqlDbType.Bit), new MySqlParameter("@f13", MySqlDbType.Bit), new MySqlParameter("@f14", MySqlDbType.Bit), new MySqlParameter("@f15", MySqlDbType.Bit), new MySqlParameter("@f16", MySqlDbType.Bit) }; parameters[0].Value = model.f1; parameters[1].Value = model.f2; parameters[2].Value = model.f3; parameters[3].Value = model.f4; parameters[4].Value = model.f5; parameters[5].Value = model.f6; parameters[6].Value = model.f7; parameters[7].Value = model.f8; parameters[8].Value = model.f9; parameters[9].Value = model.f10; parameters[10].Value = model.f11; parameters[11].Value = model.f12; parameters[12].Value = model.f13; parameters[13].Value = model.f14; parameters[14].Value = model.f15; parameters[15].Value = model.f16; return(Convert.ToInt32(Common.MySQLHelper.ExecuteScalar(strSql.ToString(), parameters))); }
public override BaseDevHouse Decode(byte[] data) { if ((DateTime.Now - InsertTime).TotalMinutes >= 10) { InsertTime = DateTime.Now; isInsert = true; } #region ------解码并赋值--------- //环境温度 T_ROOM 0 T_ROOM = BinaryHelper.GetNumByByteRange(data, GetRange(0)) / 100M; //环境湿度 H_ROOM 1 H_ROOM = BinaryHelper.GetNumByByteRange(data, GetRange(1)) / 100M; //烟雾报警 ALARM_FIRE 2 0 ALARM_FIRE = BinaryHelper.GetbitValue(data, GetRange(2), 0); //水浸报警 ALARM_SUMP 2 1 ALARM_SUMP = BinaryHelper.GetbitValue(data, GetRange(2), 1); //变压器A相温度 N1_T_A 3 N1_T_A = BinaryHelper.GetNumByByteRange(data, GetRange(3)) / 100M; //变压器B相温度 N1_T_B 4 N1_T_B = BinaryHelper.GetNumByByteRange(data, GetRange(4)) / 100M; //变压器C相温度 N1_T_C 5 N1_T_C = BinaryHelper.GetNumByByteRange(data, GetRange(5)) / 100M; //进线柜AB线电压 N1_UAB 6 N1_UAB = BinaryHelper.GetNumByByteRange(data, GetRange(6)) / 100M; //进线柜BC线电压 N1_UBC 7 N1_UBC = BinaryHelper.GetNumByByteRange(data, GetRange(7)) / 100M; //进线柜CA线电压 N1_UCA 8 N1_UCA = BinaryHelper.GetNumByByteRange(data, GetRange(8)) / 100M; //进线柜A相电流 N1_IA 9 N1_IA = BinaryHelper.GetNumByByteRange(data, GetRange(9)) / 100M; //进线柜B相电流 N1_IB 10 N1_IB = BinaryHelper.GetNumByByteRange(data, GetRange(10)) / 100M; //进线柜C相电流 N1_IC 11 N1_IC = BinaryHelper.GetNumByByteRange(data, GetRange(11)) / 100M; //进线柜功率因素 N1_PF 12 N1_PF = BinaryHelper.GetNumByByteRange(data, GetRange(12)) / 100M; //进线柜有功电能 N1_KWH 13 N1_KWH = BinaryHelper.GetNumByByteRange(data, GetRange(13)); //进线柜无功电能 N1_KVARH 14 N1_KVARH = BinaryHelper.GetNumByByteRange(data, GetRange(14)); //进线柜断路器状态 N1_JXG 15 0 N1_JXG = BinaryHelper.GetbitValue(data, GetRange(15), 0); //电容柜断路器状态 N1_DRG 1 N1_DRG = BinaryHelper.GetbitValue(data, GetRange(15), 1); //联络柜断路器状态 N1_LLG 2 N1_LLG = BinaryHelper.GetbitValue(data, GetRange(15), 2); //1#抽屉柜断路器状态 N1_G1_F1…F16 16 0…16 N1_G1 = GetDrawerState(data, 16); //2#抽屉柜断路器状态 N1_G2_F1…F16 17 0…16 N1_G2 = GetDrawerState(data, 17); //3#抽屉柜断路器状态 N1_G3_F1…F16 18 0…16 N1_G3 = GetDrawerState(data, 18); //4#抽屉柜断路器状态 N1_G4_F1…F1 19 0…16 N1_G4 = GetDrawerState(data, 19); //5#抽屉柜断路器状态 N1_G5_F1…F16 20 0…16 N1_G5 = GetDrawerState(data, 20); //6#抽屉柜断路器状态 N1_G6_F1…F16 21 0…16 N1_G6 = GetDrawerState(data, 21); //7#抽屉柜断路器状态 N1_G7_F1…F16 22 0…16 N1_G7 = GetDrawerState(data, 22); //8#抽屉柜断路器状态 N1_G8_F1…F16 23 0…16 N1_G8 = GetDrawerState(data, 23); //9#抽屉柜断路器状态 N1_G9_F1…F16 24 0…16 N1_G9 = GetDrawerState(data, 24); //10#抽屉柜断路器状态 N1_G10_F1…F16 25 0…16 N1_G10 = GetDrawerState(data, 25); //变压器A相温度 N2_T_A 26 N2_T_A = BinaryHelper.GetNumByByteRange(data, GetRange(26)) / 100M; //变压器B相温度 N2_T_B 27 N2_T_B = BinaryHelper.GetNumByByteRange(data, GetRange(27)) / 100M; //变压器C相温度 N2_T_C 28 N2_T_C = BinaryHelper.GetNumByByteRange(data, GetRange(28)) / 100M; //进线柜AB线电压 N2_UAB 29 N2_UAB = BinaryHelper.GetNumByByteRange(data, GetRange(29)) / 100M; //进线柜BC线电压 N2_UBC 30 N2_UBC = BinaryHelper.GetNumByByteRange(data, GetRange(30)) / 100M; //进线柜CA线电压 N2_UCA 31 N2_UCA = BinaryHelper.GetNumByByteRange(data, GetRange(31)) / 100M; //进线柜A相电流 N2_IA 32 N2_IA = BinaryHelper.GetNumByByteRange(data, GetRange(32)) / 100M; //进线柜B相电流 N2_IB 33 N2_IB = BinaryHelper.GetNumByByteRange(data, GetRange(33)) / 100M; //进线柜C相电流 N2_IC 34 N2_IC = BinaryHelper.GetNumByByteRange(data, GetRange(34)) / 100M; //进线柜功率因素 N2_PF 35 N2_PF = BinaryHelper.GetNumByByteRange(data, GetRange(35)) / 100M; //进线柜有功电能 N2_KWH 36 N2_KWH = BinaryHelper.GetNumByByteRange(data, GetRange(36)); //进线柜无功电能 N2_KVARH 37 N2_KVARH = BinaryHelper.GetNumByByteRange(data, GetRange(37)); //进线柜断路器状态 N2_JXG 38 N2_JXG = BinaryHelper.GetbitValue(data, GetRange(38), 0); //电容柜断路器状态 N2_DRG 1 N2_DRG = BinaryHelper.GetbitValue(data, GetRange(38), 1); //联络柜断路器状态 N2_LLG 2 N2_LLG = BinaryHelper.GetbitValue(data, GetRange(38), 2); //1#抽屉柜断路器状态 N2_G1_F1…F16 39 0…16 N2_G1 = GetDrawerState(data, 39); //2#抽屉柜断路器状态 N2_G2_F1…F16 40 0…16 N2_G2 = GetDrawerState(data, 40); //3#抽屉柜断路器状态 N2_G3_F1…F16 41 0…16 N2_G3 = GetDrawerState(data, 41); //4#抽屉柜断路器状态 N2_G4_F1…F16 42 0…16 N2_G4 = GetDrawerState(data, 42); //5#抽屉柜断路器状态 N2_G5_F1…F16 43 0…16 N2_G5 = GetDrawerState(data, 43); //6#抽屉柜断路器状态 N2_G6_F1…F16 44 0…16 N2_G6 = GetDrawerState(data, 44); //7#抽屉柜断路器状态 N2_G7_F1…F16 45 0…16 N2_G7 = GetDrawerState(data, 45); //8#抽屉柜断路器状态 N2_G8_F1…F16 46 0…16 N2_G8 = GetDrawerState(data, 46); //9#抽屉柜断路器状态 N2_G9_F1…F16 47 0…16 N2_G9 = GetDrawerState(data, 47); //10#抽屉柜断路器状态 N2_G10_F1…F16 48 0…16 N2_G10 = GetDrawerState(data, 48); #endregion Add(); isInsert = false; return(this); }
/// <summary> /// 序列化字符串输出 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Serializer(MODEL.DrawerStateModel model) { return(drawerstate_dal.Serializer(model)); }
/// <summary> /// 增加一条数据,返回主键 /// </summary> public int Add(MODEL.DrawerStateModel model) { return(drawerstate_dal.Add(model)); }
/// <summary> /// 序列化字符串输出 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Serializer(MODEL.DrawerStateModel model) { return(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15}", model.f1, model.f2, model.f3, model.f4, model.f5, model.f6, model.f7, model.f8, model.f9, model.f10, model.f11, model.f12, model.f13, model.f14, model.f15, model.f16)); }