/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo GetModel(int DoorUnitID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DoorUnitID,OutPutLockID,OutPutTimeLength,OpenDoorOverTimeLen,ZoneCountLimitEnable,ZoneCountLimitMax,ZoneCountLimitMed,ZoneCountLimitMin,ReaderID1,ReaderEnable1,ReaderID2,ReaderEnable2,InputStateType,ExitButtonID,ExitButtonMode,ExtiButtonEnable,DoorContactID,DoorContactMode,DoorContactEnable,DoorPositionID,DoorPositionMode,DoorPositionEnable,BreakGlassID,BreakGlassMode,BreakGlassEnable from DoorUnitInfo ");
strSql.Append(" where DoorUnitID=@DoorUnitID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@DoorUnitID", DbType.Int32, 4)
};
parameters[0].Value = DoorUnitID;
KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo model = new KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo();
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.DoorUnitInfo GetModel(int DoorUnitID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select DoorUnitID,OutPutLockID,OutPutTimeLength,OpenDoorOverTimeLen,ZoneCountLimitEnable,ZoneCountLimitMax,ZoneCountLimitMed,ZoneCountLimitMin,ReaderID1,ReaderEnable1,ReaderID2,ReaderEnable2,InputStateType,ExitButtonID,ExitButtonMode,ExtiButtonEnable,DoorContactID,DoorContactMode,DoorContactEnable,DoorPositionID,DoorPositionMode,DoorPositionEnable,BreakGlassID,BreakGlassMode,BreakGlassEnable from DoorUnitInfo ");
strSql.Append(" where DoorUnitID=@DoorUnitID ");
SQLiteParameter[] parameters = {
new SQLiteParameter("@DoorUnitID", DbType.Int32,4) };
parameters[0].Value = DoorUnitID;
KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo model=new KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo();
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.DoorUnitInfo DataRowToModel(DataRow row)
{
KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo model=new KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo();
if (row != null)
{
if(row["DoorUnitID"]!=null && row["DoorUnitID"].ToString()!="")
{
model.DoorUnitID=int.Parse(row["DoorUnitID"].ToString());
}
if(row["OutPutLockID"]!=null && row["OutPutLockID"].ToString()!="")
{
model.OutPutLockID=int.Parse(row["OutPutLockID"].ToString());
}
if(row["OutPutTimeLength"]!=null && row["OutPutTimeLength"].ToString()!="")
{
model.OutPutTimeLength=int.Parse(row["OutPutTimeLength"].ToString());
}
if(row["OpenDoorOverTimeLen"]!=null && row["OpenDoorOverTimeLen"].ToString()!="")
{
model.OpenDoorOverTimeLen=int.Parse(row["OpenDoorOverTimeLen"].ToString());
}
if(row["ZoneCountLimitEnable"]!=null && row["ZoneCountLimitEnable"].ToString()!="")
{
if((row["ZoneCountLimitEnable"].ToString()=="1")||(row["ZoneCountLimitEnable"].ToString().ToLower()=="true"))
{
model.ZoneCountLimitEnable=true;
}
else
{
model.ZoneCountLimitEnable=false;
}
}
if(row["ZoneCountLimitMax"]!=null && row["ZoneCountLimitMax"].ToString()!="")
{
model.ZoneCountLimitMax=int.Parse(row["ZoneCountLimitMax"].ToString());
}
if(row["ZoneCountLimitMed"]!=null && row["ZoneCountLimitMed"].ToString()!="")
{
model.ZoneCountLimitMed=int.Parse(row["ZoneCountLimitMed"].ToString());
}
if(row["ZoneCountLimitMin"]!=null && row["ZoneCountLimitMin"].ToString()!="")
{
model.ZoneCountLimitMin=int.Parse(row["ZoneCountLimitMin"].ToString());
}
if(row["ReaderID1"]!=null && row["ReaderID1"].ToString()!="")
{
model.ReaderID1=int.Parse(row["ReaderID1"].ToString());
}
if(row["ReaderEnable1"]!=null && row["ReaderEnable1"].ToString()!="")
{
if((row["ReaderEnable1"].ToString()=="1")||(row["ReaderEnable1"].ToString().ToLower()=="true"))
{
model.ReaderEnable1=true;
}
else
{
model.ReaderEnable1=false;
}
}
if(row["ReaderID2"]!=null && row["ReaderID2"].ToString()!="")
{
model.ReaderID2=int.Parse(row["ReaderID2"].ToString());
}
if(row["ReaderEnable2"]!=null && row["ReaderEnable2"].ToString()!="")
{
if((row["ReaderEnable2"].ToString()=="1")||(row["ReaderEnable2"].ToString().ToLower()=="true"))
{
model.ReaderEnable2=true;
}
else
{
model.ReaderEnable2=false;
}
}
if(row["InputStateType"]!=null && row["InputStateType"].ToString()!="")
{
model.InputStateType=int.Parse(row["InputStateType"].ToString());
}
if(row["ExitButtonID"]!=null && row["ExitButtonID"].ToString()!="")
{
model.ExitButtonID=int.Parse(row["ExitButtonID"].ToString());
}
if(row["ExitButtonMode"]!=null && row["ExitButtonMode"].ToString()!="")
{
model.ExitButtonMode=int.Parse(row["ExitButtonMode"].ToString());
}
if(row["ExtiButtonEnable"]!=null && row["ExtiButtonEnable"].ToString()!="")
{
if((row["ExtiButtonEnable"].ToString()=="1")||(row["ExtiButtonEnable"].ToString().ToLower()=="true"))
{
model.ExtiButtonEnable=true;
}
else
{
model.ExtiButtonEnable=false;
}
}
if(row["DoorContactID"]!=null && row["DoorContactID"].ToString()!="")
{
model.DoorContactID=int.Parse(row["DoorContactID"].ToString());
}
if(row["DoorContactMode"]!=null && row["DoorContactMode"].ToString()!="")
{
model.DoorContactMode=int.Parse(row["DoorContactMode"].ToString());
}
if(row["DoorContactEnable"]!=null && row["DoorContactEnable"].ToString()!="")
{
if((row["DoorContactEnable"].ToString()=="1")||(row["DoorContactEnable"].ToString().ToLower()=="true"))
{
model.DoorContactEnable=true;
}
else
{
model.DoorContactEnable=false;
}
}
if(row["DoorPositionID"]!=null && row["DoorPositionID"].ToString()!="")
{
model.DoorPositionID=int.Parse(row["DoorPositionID"].ToString());
}
if(row["DoorPositionMode"]!=null && row["DoorPositionMode"].ToString()!="")
{
model.DoorPositionMode=int.Parse(row["DoorPositionMode"].ToString());
}
if(row["DoorPositionEnable"]!=null && row["DoorPositionEnable"].ToString()!="")
{
if((row["DoorPositionEnable"].ToString()=="1")||(row["DoorPositionEnable"].ToString().ToLower()=="true"))
{
model.DoorPositionEnable=true;
}
else
{
model.DoorPositionEnable=false;
}
}
if(row["BreakGlassID"]!=null && row["BreakGlassID"].ToString()!="")
{
model.BreakGlassID=int.Parse(row["BreakGlassID"].ToString());
}
if(row["BreakGlassMode"]!=null && row["BreakGlassMode"].ToString()!="")
{
model.BreakGlassMode=int.Parse(row["BreakGlassMode"].ToString());
}
if(row["BreakGlassEnable"]!=null && row["BreakGlassEnable"].ToString()!="")
{
if((row["BreakGlassEnable"].ToString()=="1")||(row["BreakGlassEnable"].ToString().ToLower()=="true"))
{
model.BreakGlassEnable=true;
}
else
{
model.BreakGlassEnable=false;
}
}
}
return model;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DoorUnitInfo(");
strSql.Append("DoorUnitID,OutPutLockID,OutPutTimeLength,OpenDoorOverTimeLen,ZoneCountLimitEnable,ZoneCountLimitMax,ZoneCountLimitMed,ZoneCountLimitMin,ReaderID1,ReaderEnable1,ReaderID2,ReaderEnable2,InputStateType,ExitButtonID,ExitButtonMode,ExtiButtonEnable,DoorContactID,DoorContactMode,DoorContactEnable,DoorPositionID,DoorPositionMode,DoorPositionEnable,BreakGlassID,BreakGlassMode,BreakGlassEnable)");
strSql.Append(" values (");
strSql.Append("@DoorUnitID,@OutPutLockID,@OutPutTimeLength,@OpenDoorOverTimeLen,@ZoneCountLimitEnable,@ZoneCountLimitMax,@ZoneCountLimitMed,@ZoneCountLimitMin,@ReaderID1,@ReaderEnable1,@ReaderID2,@ReaderEnable2,@InputStateType,@ExitButtonID,@ExitButtonMode,@ExtiButtonEnable,@DoorContactID,@DoorContactMode,@DoorContactEnable,@DoorPositionID,@DoorPositionMode,@DoorPositionEnable,@BreakGlassID,@BreakGlassMode,@BreakGlassEnable)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@DoorUnitID", DbType.Int32, 4),
new SQLiteParameter("@OutPutLockID", DbType.Int32, 4),
new SQLiteParameter("@OutPutTimeLength", DbType.Int32, 4),
new SQLiteParameter("@OpenDoorOverTimeLen", DbType.Int32, 4),
new SQLiteParameter("@ZoneCountLimitEnable", DbType.Boolean, 1),
new SQLiteParameter("@ZoneCountLimitMax", DbType.Int32, 4),
new SQLiteParameter("@ZoneCountLimitMed", DbType.Int32, 4),
new SQLiteParameter("@ZoneCountLimitMin", DbType.Int32, 4),
new SQLiteParameter("@ReaderID1", DbType.Int32, 4),
new SQLiteParameter("@ReaderEnable1", DbType.Boolean, 1),
new SQLiteParameter("@ReaderID2", DbType.Int32, 4),
new SQLiteParameter("@ReaderEnable2", DbType.Boolean, 1),
new SQLiteParameter("@InputStateType", DbType.Int32, 4),
new SQLiteParameter("@ExitButtonID", DbType.Int32, 4),
new SQLiteParameter("@ExitButtonMode", DbType.Int32, 4),
new SQLiteParameter("@ExtiButtonEnable", DbType.Boolean, 1),
new SQLiteParameter("@DoorContactID", DbType.Int32, 4),
new SQLiteParameter("@DoorContactMode", DbType.Int32, 4),
new SQLiteParameter("@DoorContactEnable", DbType.Boolean, 1),
new SQLiteParameter("@DoorPositionID", DbType.Int32, 4),
new SQLiteParameter("@DoorPositionMode", DbType.Int32, 4),
new SQLiteParameter("@DoorPositionEnable", DbType.Boolean, 1),
new SQLiteParameter("@BreakGlassID", DbType.Int32, 4),
new SQLiteParameter("@BreakGlassMode", DbType.Int32, 4),
new SQLiteParameter("@BreakGlassEnable", DbType.Boolean, 1)
};
parameters[0].Value = model.DoorUnitID;
parameters[1].Value = model.OutPutLockID;
parameters[2].Value = model.OutPutTimeLength;
parameters[3].Value = model.OpenDoorOverTimeLen;
parameters[4].Value = model.ZoneCountLimitEnable;
parameters[5].Value = model.ZoneCountLimitMax;
parameters[6].Value = model.ZoneCountLimitMed;
parameters[7].Value = model.ZoneCountLimitMin;
parameters[8].Value = model.ReaderID1;
parameters[9].Value = model.ReaderEnable1;
parameters[10].Value = model.ReaderID2;
parameters[11].Value = model.ReaderEnable2;
parameters[12].Value = model.InputStateType;
parameters[13].Value = model.ExitButtonID;
parameters[14].Value = model.ExitButtonMode;
parameters[15].Value = model.ExtiButtonEnable;
parameters[16].Value = model.DoorContactID;
parameters[17].Value = model.DoorContactMode;
parameters[18].Value = model.DoorContactEnable;
parameters[19].Value = model.DoorPositionID;
parameters[20].Value = model.DoorPositionMode;
parameters[21].Value = model.DoorPositionEnable;
parameters[22].Value = model.BreakGlassID;
parameters[23].Value = model.BreakGlassMode;
parameters[24].Value = model.BreakGlassEnable;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo DataRowToModel(DataRow row)
{
KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo model = new KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo();
if (row != null)
{
if (row["DoorUnitID"] != null && row["DoorUnitID"].ToString() != "")
{
model.DoorUnitID = int.Parse(row["DoorUnitID"].ToString());
}
if (row["OutPutLockID"] != null && row["OutPutLockID"].ToString() != "")
{
model.OutPutLockID = int.Parse(row["OutPutLockID"].ToString());
}
if (row["OutPutTimeLength"] != null && row["OutPutTimeLength"].ToString() != "")
{
model.OutPutTimeLength = int.Parse(row["OutPutTimeLength"].ToString());
}
if (row["OpenDoorOverTimeLen"] != null && row["OpenDoorOverTimeLen"].ToString() != "")
{
model.OpenDoorOverTimeLen = int.Parse(row["OpenDoorOverTimeLen"].ToString());
}
if (row["ZoneCountLimitEnable"] != null && row["ZoneCountLimitEnable"].ToString() != "")
{
if ((row["ZoneCountLimitEnable"].ToString() == "1") || (row["ZoneCountLimitEnable"].ToString().ToLower() == "true"))
{
model.ZoneCountLimitEnable = true;
}
else
{
model.ZoneCountLimitEnable = false;
}
}
if (row["ZoneCountLimitMax"] != null && row["ZoneCountLimitMax"].ToString() != "")
{
model.ZoneCountLimitMax = int.Parse(row["ZoneCountLimitMax"].ToString());
}
if (row["ZoneCountLimitMed"] != null && row["ZoneCountLimitMed"].ToString() != "")
{
model.ZoneCountLimitMed = int.Parse(row["ZoneCountLimitMed"].ToString());
}
if (row["ZoneCountLimitMin"] != null && row["ZoneCountLimitMin"].ToString() != "")
{
model.ZoneCountLimitMin = int.Parse(row["ZoneCountLimitMin"].ToString());
}
if (row["ReaderID1"] != null && row["ReaderID1"].ToString() != "")
{
model.ReaderID1 = int.Parse(row["ReaderID1"].ToString());
}
if (row["ReaderEnable1"] != null && row["ReaderEnable1"].ToString() != "")
{
if ((row["ReaderEnable1"].ToString() == "1") || (row["ReaderEnable1"].ToString().ToLower() == "true"))
{
model.ReaderEnable1 = true;
}
else
{
model.ReaderEnable1 = false;
}
}
if (row["ReaderID2"] != null && row["ReaderID2"].ToString() != "")
{
model.ReaderID2 = int.Parse(row["ReaderID2"].ToString());
}
if (row["ReaderEnable2"] != null && row["ReaderEnable2"].ToString() != "")
{
if ((row["ReaderEnable2"].ToString() == "1") || (row["ReaderEnable2"].ToString().ToLower() == "true"))
{
model.ReaderEnable2 = true;
}
else
{
model.ReaderEnable2 = false;
}
}
if (row["InputStateType"] != null && row["InputStateType"].ToString() != "")
{
model.InputStateType = int.Parse(row["InputStateType"].ToString());
}
if (row["ExitButtonID"] != null && row["ExitButtonID"].ToString() != "")
{
model.ExitButtonID = int.Parse(row["ExitButtonID"].ToString());
}
if (row["ExitButtonMode"] != null && row["ExitButtonMode"].ToString() != "")
{
model.ExitButtonMode = int.Parse(row["ExitButtonMode"].ToString());
}
if (row["ExtiButtonEnable"] != null && row["ExtiButtonEnable"].ToString() != "")
{
if ((row["ExtiButtonEnable"].ToString() == "1") || (row["ExtiButtonEnable"].ToString().ToLower() == "true"))
{
model.ExtiButtonEnable = true;
}
else
{
model.ExtiButtonEnable = false;
}
}
if (row["DoorContactID"] != null && row["DoorContactID"].ToString() != "")
{
model.DoorContactID = int.Parse(row["DoorContactID"].ToString());
}
if (row["DoorContactMode"] != null && row["DoorContactMode"].ToString() != "")
{
model.DoorContactMode = int.Parse(row["DoorContactMode"].ToString());
}
if (row["DoorContactEnable"] != null && row["DoorContactEnable"].ToString() != "")
{
if ((row["DoorContactEnable"].ToString() == "1") || (row["DoorContactEnable"].ToString().ToLower() == "true"))
{
model.DoorContactEnable = true;
}
else
{
model.DoorContactEnable = false;
}
}
if (row["DoorPositionID"] != null && row["DoorPositionID"].ToString() != "")
{
model.DoorPositionID = int.Parse(row["DoorPositionID"].ToString());
}
if (row["DoorPositionMode"] != null && row["DoorPositionMode"].ToString() != "")
{
model.DoorPositionMode = int.Parse(row["DoorPositionMode"].ToString());
}
if (row["DoorPositionEnable"] != null && row["DoorPositionEnable"].ToString() != "")
{
if ((row["DoorPositionEnable"].ToString() == "1") || (row["DoorPositionEnable"].ToString().ToLower() == "true"))
{
model.DoorPositionEnable = true;
}
else
{
model.DoorPositionEnable = false;
}
}
if (row["BreakGlassID"] != null && row["BreakGlassID"].ToString() != "")
{
model.BreakGlassID = int.Parse(row["BreakGlassID"].ToString());
}
if (row["BreakGlassMode"] != null && row["BreakGlassMode"].ToString() != "")
{
model.BreakGlassMode = int.Parse(row["BreakGlassMode"].ToString());
}
if (row["BreakGlassEnable"] != null && row["BreakGlassEnable"].ToString() != "")
{
if ((row["BreakGlassEnable"].ToString() == "1") || (row["BreakGlassEnable"].ToString().ToLower() == "true"))
{
model.BreakGlassEnable = true;
}
else
{
model.BreakGlassEnable = false;
}
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KryptonAccessController.SQLite.Model.ControllerRelation.DoorUnitInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DoorUnitInfo set ");
strSql.Append("OutPutLockID=@OutPutLockID,");
strSql.Append("OutPutTimeLength=@OutPutTimeLength,");
strSql.Append("OpenDoorOverTimeLen=@OpenDoorOverTimeLen,");
strSql.Append("ZoneCountLimitEnable=@ZoneCountLimitEnable,");
strSql.Append("ZoneCountLimitMax=@ZoneCountLimitMax,");
strSql.Append("ZoneCountLimitMed=@ZoneCountLimitMed,");
strSql.Append("ZoneCountLimitMin=@ZoneCountLimitMin,");
strSql.Append("ReaderID1=@ReaderID1,");
strSql.Append("ReaderEnable1=@ReaderEnable1,");
strSql.Append("ReaderID2=@ReaderID2,");
strSql.Append("ReaderEnable2=@ReaderEnable2,");
strSql.Append("InputStateType=@InputStateType,");
strSql.Append("ExitButtonID=@ExitButtonID,");
strSql.Append("ExitButtonMode=@ExitButtonMode,");
strSql.Append("ExtiButtonEnable=@ExtiButtonEnable,");
strSql.Append("DoorContactID=@DoorContactID,");
strSql.Append("DoorContactMode=@DoorContactMode,");
strSql.Append("DoorContactEnable=@DoorContactEnable,");
strSql.Append("DoorPositionID=@DoorPositionID,");
strSql.Append("DoorPositionMode=@DoorPositionMode,");
strSql.Append("DoorPositionEnable=@DoorPositionEnable,");
strSql.Append("BreakGlassID=@BreakGlassID,");
strSql.Append("BreakGlassMode=@BreakGlassMode,");
strSql.Append("BreakGlassEnable=@BreakGlassEnable");
strSql.Append(" where DoorUnitID=@DoorUnitID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@OutPutLockID", DbType.Int32, 4),
new SQLiteParameter("@OutPutTimeLength", DbType.Int32, 4),
new SQLiteParameter("@OpenDoorOverTimeLen", DbType.Int32, 4),
new SQLiteParameter("@ZoneCountLimitEnable", DbType.Boolean, 1),
new SQLiteParameter("@ZoneCountLimitMax", DbType.Int32, 4),
new SQLiteParameter("@ZoneCountLimitMed", DbType.Int32, 4),
new SQLiteParameter("@ZoneCountLimitMin", DbType.Int32, 4),
new SQLiteParameter("@ReaderID1", DbType.Int32, 4),
new SQLiteParameter("@ReaderEnable1", DbType.Boolean, 1),
new SQLiteParameter("@ReaderID2", DbType.Int32, 4),
new SQLiteParameter("@ReaderEnable2", DbType.Boolean, 1),
new SQLiteParameter("@InputStateType", DbType.Int32, 4),
new SQLiteParameter("@ExitButtonID", DbType.Int32, 4),
new SQLiteParameter("@ExitButtonMode", DbType.Int32, 4),
new SQLiteParameter("@ExtiButtonEnable", DbType.Boolean, 1),
new SQLiteParameter("@DoorContactID", DbType.Int32, 4),
new SQLiteParameter("@DoorContactMode", DbType.Int32, 4),
new SQLiteParameter("@DoorContactEnable", DbType.Boolean, 1),
new SQLiteParameter("@DoorPositionID", DbType.Int32, 4),
new SQLiteParameter("@DoorPositionMode", DbType.Int32, 4),
new SQLiteParameter("@DoorPositionEnable", DbType.Boolean, 1),
new SQLiteParameter("@BreakGlassID", DbType.Int32, 4),
new SQLiteParameter("@BreakGlassMode", DbType.Int32, 4),
new SQLiteParameter("@BreakGlassEnable", DbType.Boolean, 1),
new SQLiteParameter("@DoorUnitID", DbType.Int32, 4)
};
parameters[0].Value = model.OutPutLockID;
parameters[1].Value = model.OutPutTimeLength;
parameters[2].Value = model.OpenDoorOverTimeLen;
parameters[3].Value = model.ZoneCountLimitEnable;
parameters[4].Value = model.ZoneCountLimitMax;
parameters[5].Value = model.ZoneCountLimitMed;
parameters[6].Value = model.ZoneCountLimitMin;
parameters[7].Value = model.ReaderID1;
parameters[8].Value = model.ReaderEnable1;
parameters[9].Value = model.ReaderID2;
parameters[10].Value = model.ReaderEnable2;
parameters[11].Value = model.InputStateType;
parameters[12].Value = model.ExitButtonID;
parameters[13].Value = model.ExitButtonMode;
parameters[14].Value = model.ExtiButtonEnable;
parameters[15].Value = model.DoorContactID;
parameters[16].Value = model.DoorContactMode;
parameters[17].Value = model.DoorContactEnable;
parameters[18].Value = model.DoorPositionID;
parameters[19].Value = model.DoorPositionMode;
parameters[20].Value = model.DoorPositionEnable;
parameters[21].Value = model.BreakGlassID;
parameters[22].Value = model.BreakGlassMode;
parameters[23].Value = model.BreakGlassEnable;
parameters[24].Value = model.DoorUnitID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
