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