/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AuxiliaryUnit(");
strSql.Append("AuxiliaryUnitID,AuxOutPutPointID,InputStateType,FireSensingID,FireSensingMode,FireSensingEnable,TamperSensingID,TamperSensingMode,TamperSensingEnable,LowVoltageID,LowVoltageMode,LowVoltageEnable,PowerOutageID,PowerOutageMode,PowerOutageEnable)");
strSql.Append(" values (");
strSql.Append("@AuxiliaryUnitID,@AuxOutPutPointID,@InputStateType,@FireSensingID,@FireSensingMode,@FireSensingEnable,@TamperSensingID,@TamperSensingMode,@TamperSensingEnable,@LowVoltageID,@LowVoltageMode,@LowVoltageEnable,@PowerOutageID,@PowerOutageMode,@PowerOutageEnable)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@AuxiliaryUnitID", DbType.Int32, 4),
new SQLiteParameter("@AuxOutPutPointID", DbType.Int32, 4),
new SQLiteParameter("@InputStateType", DbType.Int32, 4),
new SQLiteParameter("@FireSensingID", DbType.Int32, 4),
new SQLiteParameter("@FireSensingMode", DbType.Int32, 4),
new SQLiteParameter("@FireSensingEnable", DbType.Boolean, 1),
new SQLiteParameter("@TamperSensingID", DbType.Int32, 4),
new SQLiteParameter("@TamperSensingMode", DbType.Int32, 4),
new SQLiteParameter("@TamperSensingEnable", DbType.Boolean, 1),
new SQLiteParameter("@LowVoltageID", DbType.Int32, 4),
new SQLiteParameter("@LowVoltageMode", DbType.Int32, 4),
new SQLiteParameter("@LowVoltageEnable", DbType.Boolean, 1),
new SQLiteParameter("@PowerOutageID", DbType.Int32, 4),
new SQLiteParameter("@PowerOutageMode", DbType.Int32, 4),
new SQLiteParameter("@PowerOutageEnable", DbType.Boolean, 1)
};
parameters[0].Value = model.AuxiliaryUnitID;
parameters[1].Value = model.AuxOutPutPointID;
parameters[2].Value = model.InputStateType;
parameters[3].Value = model.FireSensingID;
parameters[4].Value = model.FireSensingMode;
parameters[5].Value = model.FireSensingEnable;
parameters[6].Value = model.TamperSensingID;
parameters[7].Value = model.TamperSensingMode;
parameters[8].Value = model.TamperSensingEnable;
parameters[9].Value = model.LowVoltageID;
parameters[10].Value = model.LowVoltageMode;
parameters[11].Value = model.LowVoltageEnable;
parameters[12].Value = model.PowerOutageID;
parameters[13].Value = model.PowerOutageMode;
parameters[14].Value = model.PowerOutageEnable;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit GetModel(int AuxiliaryUnitID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AuxiliaryUnitID,AuxOutPutPointID,InputStateType,FireSensingID,FireSensingMode,FireSensingEnable,TamperSensingID,TamperSensingMode,TamperSensingEnable,LowVoltageID,LowVoltageMode,LowVoltageEnable,PowerOutageID,PowerOutageMode,PowerOutageEnable from AuxiliaryUnit ");
strSql.Append(" where AuxiliaryUnitID=@AuxiliaryUnitID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@AuxiliaryUnitID", DbType.Int32, 4)
};
parameters[0].Value = AuxiliaryUnitID;
KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit model = new KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit DataRowToModel(DataRow row)
{
KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit model = new KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit();
if (row != null)
{
if (row["AuxiliaryUnitID"] != null && row["AuxiliaryUnitID"].ToString() != "")
{
model.AuxiliaryUnitID = int.Parse(row["AuxiliaryUnitID"].ToString());
}
if (row["AuxOutPutPointID"] != null && row["AuxOutPutPointID"].ToString() != "")
{
model.AuxOutPutPointID = int.Parse(row["AuxOutPutPointID"].ToString());
}
if (row["InputStateType"] != null && row["InputStateType"].ToString() != "")
{
model.InputStateType = int.Parse(row["InputStateType"].ToString());
}
if (row["FireSensingID"] != null && row["FireSensingID"].ToString() != "")
{
model.FireSensingID = int.Parse(row["FireSensingID"].ToString());
}
if (row["FireSensingMode"] != null && row["FireSensingMode"].ToString() != "")
{
model.FireSensingMode = int.Parse(row["FireSensingMode"].ToString());
}
if (row["FireSensingEnable"] != null && row["FireSensingEnable"].ToString() != "")
{
if ((row["FireSensingEnable"].ToString() == "1") || (row["FireSensingEnable"].ToString().ToLower() == "true"))
{
model.FireSensingEnable = true;
}
else
{
model.FireSensingEnable = false;
}
}
if (row["TamperSensingID"] != null && row["TamperSensingID"].ToString() != "")
{
model.TamperSensingID = int.Parse(row["TamperSensingID"].ToString());
}
if (row["TamperSensingMode"] != null && row["TamperSensingMode"].ToString() != "")
{
model.TamperSensingMode = int.Parse(row["TamperSensingMode"].ToString());
}
if (row["TamperSensingEnable"] != null && row["TamperSensingEnable"].ToString() != "")
{
if ((row["TamperSensingEnable"].ToString() == "1") || (row["TamperSensingEnable"].ToString().ToLower() == "true"))
{
model.TamperSensingEnable = true;
}
else
{
model.TamperSensingEnable = false;
}
}
if (row["LowVoltageID"] != null && row["LowVoltageID"].ToString() != "")
{
model.LowVoltageID = int.Parse(row["LowVoltageID"].ToString());
}
if (row["LowVoltageMode"] != null && row["LowVoltageMode"].ToString() != "")
{
model.LowVoltageMode = int.Parse(row["LowVoltageMode"].ToString());
}
if (row["LowVoltageEnable"] != null && row["LowVoltageEnable"].ToString() != "")
{
if ((row["LowVoltageEnable"].ToString() == "1") || (row["LowVoltageEnable"].ToString().ToLower() == "true"))
{
model.LowVoltageEnable = true;
}
else
{
model.LowVoltageEnable = false;
}
}
if (row["PowerOutageID"] != null && row["PowerOutageID"].ToString() != "")
{
model.PowerOutageID = int.Parse(row["PowerOutageID"].ToString());
}
if (row["PowerOutageMode"] != null && row["PowerOutageMode"].ToString() != "")
{
model.PowerOutageMode = int.Parse(row["PowerOutageMode"].ToString());
}
if (row["PowerOutageEnable"] != null && row["PowerOutageEnable"].ToString() != "")
{
if ((row["PowerOutageEnable"].ToString() == "1") || (row["PowerOutageEnable"].ToString().ToLower() == "true"))
{
model.PowerOutageEnable = true;
}
else
{
model.PowerOutageEnable = false;
}
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AuxiliaryUnit set ");
strSql.Append("AuxOutPutPointID=@AuxOutPutPointID,");
strSql.Append("InputStateType=@InputStateType,");
strSql.Append("FireSensingID=@FireSensingID,");
strSql.Append("FireSensingMode=@FireSensingMode,");
strSql.Append("FireSensingEnable=@FireSensingEnable,");
strSql.Append("TamperSensingID=@TamperSensingID,");
strSql.Append("TamperSensingMode=@TamperSensingMode,");
strSql.Append("TamperSensingEnable=@TamperSensingEnable,");
strSql.Append("LowVoltageID=@LowVoltageID,");
strSql.Append("LowVoltageMode=@LowVoltageMode,");
strSql.Append("LowVoltageEnable=@LowVoltageEnable,");
strSql.Append("PowerOutageID=@PowerOutageID,");
strSql.Append("PowerOutageMode=@PowerOutageMode,");
strSql.Append("PowerOutageEnable=@PowerOutageEnable");
strSql.Append(" where AuxiliaryUnitID=@AuxiliaryUnitID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@AuxOutPutPointID", DbType.Int32, 4),
new SQLiteParameter("@InputStateType", DbType.Int32, 4),
new SQLiteParameter("@FireSensingID", DbType.Int32, 4),
new SQLiteParameter("@FireSensingMode", DbType.Int32, 4),
new SQLiteParameter("@FireSensingEnable", DbType.Boolean, 1),
new SQLiteParameter("@TamperSensingID", DbType.Int32, 4),
new SQLiteParameter("@TamperSensingMode", DbType.Int32, 4),
new SQLiteParameter("@TamperSensingEnable", DbType.Boolean, 1),
new SQLiteParameter("@LowVoltageID", DbType.Int32, 4),
new SQLiteParameter("@LowVoltageMode", DbType.Int32, 4),
new SQLiteParameter("@LowVoltageEnable", DbType.Boolean, 1),
new SQLiteParameter("@PowerOutageID", DbType.Int32, 4),
new SQLiteParameter("@PowerOutageMode", DbType.Int32, 4),
new SQLiteParameter("@PowerOutageEnable", DbType.Boolean, 1),
new SQLiteParameter("@AuxiliaryUnitID", DbType.Int32, 4)
};
parameters[0].Value = model.AuxOutPutPointID;
parameters[1].Value = model.InputStateType;
parameters[2].Value = model.FireSensingID;
parameters[3].Value = model.FireSensingMode;
parameters[4].Value = model.FireSensingEnable;
parameters[5].Value = model.TamperSensingID;
parameters[6].Value = model.TamperSensingMode;
parameters[7].Value = model.TamperSensingEnable;
parameters[8].Value = model.LowVoltageID;
parameters[9].Value = model.LowVoltageMode;
parameters[10].Value = model.LowVoltageEnable;
parameters[11].Value = model.PowerOutageID;
parameters[12].Value = model.PowerOutageMode;
parameters[13].Value = model.PowerOutageEnable;
parameters[14].Value = model.AuxiliaryUnitID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit GetModel(int AuxiliaryUnitID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select AuxiliaryUnitID,AuxOutPutPointID,InputStateType,FireSensingID,FireSensingMode,FireSensingEnable,TamperSensingID,TamperSensingMode,TamperSensingEnable,LowVoltageID,LowVoltageMode,LowVoltageEnable,PowerOutageID,PowerOutageMode,PowerOutageEnable from AuxiliaryUnit ");
strSql.Append(" where AuxiliaryUnitID=@AuxiliaryUnitID ");
SQLiteParameter[] parameters = {
new SQLiteParameter("@AuxiliaryUnitID", DbType.Int32,4) };
parameters[0].Value = AuxiliaryUnitID;
KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit model=new KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit();
DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit DataRowToModel(DataRow row)
{
KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit model=new KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit();
if (row != null)
{
if(row["AuxiliaryUnitID"]!=null && row["AuxiliaryUnitID"].ToString()!="")
{
model.AuxiliaryUnitID=int.Parse(row["AuxiliaryUnitID"].ToString());
}
if(row["AuxOutPutPointID"]!=null && row["AuxOutPutPointID"].ToString()!="")
{
model.AuxOutPutPointID=int.Parse(row["AuxOutPutPointID"].ToString());
}
if(row["InputStateType"]!=null && row["InputStateType"].ToString()!="")
{
model.InputStateType=int.Parse(row["InputStateType"].ToString());
}
if(row["FireSensingID"]!=null && row["FireSensingID"].ToString()!="")
{
model.FireSensingID=int.Parse(row["FireSensingID"].ToString());
}
if(row["FireSensingMode"]!=null && row["FireSensingMode"].ToString()!="")
{
model.FireSensingMode=int.Parse(row["FireSensingMode"].ToString());
}
if(row["FireSensingEnable"]!=null && row["FireSensingEnable"].ToString()!="")
{
if((row["FireSensingEnable"].ToString()=="1")||(row["FireSensingEnable"].ToString().ToLower()=="true"))
{
model.FireSensingEnable=true;
}
else
{
model.FireSensingEnable=false;
}
}
if(row["TamperSensingID"]!=null && row["TamperSensingID"].ToString()!="")
{
model.TamperSensingID=int.Parse(row["TamperSensingID"].ToString());
}
if(row["TamperSensingMode"]!=null && row["TamperSensingMode"].ToString()!="")
{
model.TamperSensingMode=int.Parse(row["TamperSensingMode"].ToString());
}
if(row["TamperSensingEnable"]!=null && row["TamperSensingEnable"].ToString()!="")
{
if((row["TamperSensingEnable"].ToString()=="1")||(row["TamperSensingEnable"].ToString().ToLower()=="true"))
{
model.TamperSensingEnable=true;
}
else
{
model.TamperSensingEnable=false;
}
}
if(row["LowVoltageID"]!=null && row["LowVoltageID"].ToString()!="")
{
model.LowVoltageID=int.Parse(row["LowVoltageID"].ToString());
}
if(row["LowVoltageMode"]!=null && row["LowVoltageMode"].ToString()!="")
{
model.LowVoltageMode=int.Parse(row["LowVoltageMode"].ToString());
}
if(row["LowVoltageEnable"]!=null && row["LowVoltageEnable"].ToString()!="")
{
if((row["LowVoltageEnable"].ToString()=="1")||(row["LowVoltageEnable"].ToString().ToLower()=="true"))
{
model.LowVoltageEnable=true;
}
else
{
model.LowVoltageEnable=false;
}
}
if(row["PowerOutageID"]!=null && row["PowerOutageID"].ToString()!="")
{
model.PowerOutageID=int.Parse(row["PowerOutageID"].ToString());
}
if(row["PowerOutageMode"]!=null && row["PowerOutageMode"].ToString()!="")
{
model.PowerOutageMode=int.Parse(row["PowerOutageMode"].ToString());
}
if(row["PowerOutageEnable"]!=null && row["PowerOutageEnable"].ToString()!="")
{
if((row["PowerOutageEnable"].ToString()=="1")||(row["PowerOutageEnable"].ToString().ToLower()=="true"))
{
model.PowerOutageEnable=true;
}
else
{
model.PowerOutageEnable=false;
}
}
}
return model;
}
