private void showDoorUnitControl(ref MyComponents.DoorUnit doorUnit, KryptonAccessController.AccessDataBase.Model.DoorUnitInfo modelDoorUnit)
{
doorUnit.KryptonComboBoxInputStateType.SelectedIndex = modelDoorUnit.InputStateType == 2 ? 0 : 1;
doorUnit.KryptonTextBoxOutPoint.Text = modelDoorUnit.OutPutLockID.ToString();
doorUnit.KryptonTextBoxExitButton.Text = modelDoorUnit.ExitButtonID.ToString();
doorUnit.KryptonTextBoxDoorContact.Text = modelDoorUnit.DoorContactID.ToString();
doorUnit.KryptonTextBoxDoorPosition.Text = modelDoorUnit.DoorPositionID.ToString();
doorUnit.KryptonTextBoxBreakGlass.Text = modelDoorUnit.BreakGlassID.ToString();
doorUnit.KryptonTextBoxReader1.Text = modelDoorUnit.ReadID1.ToString();
doorUnit.KryptonTextBoxReader2.Text = modelDoorUnit.ReadID2.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.DoorUnitInfo GetModel(int DoorUnitID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 DoorUnitID,OutPutLockID,OutPutTimeLen,OpenDoorOverTimeLen,ZoneCountLimitEnable,ZoneCountLimitMax,ZoneCountLimitMed,ZoneCountLimitMin,ReadID1,ReadIDEnable1,ReadID2,ReadIDEnable2,InputStateType,ExitButtonID,ExitButtonMode,ExtiButtonEnable,DoorContactID,DoorContactMode,DoorContactEnable,DoorPositionID,DoorPositionMode,DoorPositionEnable,BreakGlassID,BreakGlassMode,BreakGlassEnable,ElectronicMapID,PositionX,PositionY,StateImageOpen,StateImageClose,StateImageAlarmOpen,StateImageAlarmClose from DoorUnitInfo ");
strSql.Append(" where DoorUnitID=@DoorUnitID ");
SqlParameter[] parameters =
{
new SqlParameter("@DoorUnitID", SqlDbType.Int, 4)
};
parameters[0].Value = DoorUnitID;
KryptonAccessController.AccessDataBase.Model.DoorUnitInfo model = new KryptonAccessController.AccessDataBase.Model.DoorUnitInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.DoorUnitInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DoorUnitInfo(");
strSql.Append("DoorUnitID,OutPutLockID,OutPutTimeLen,OpenDoorOverTimeLen,ZoneCountLimitEnable,ZoneCountLimitMax,ZoneCountLimitMed,ZoneCountLimitMin,ReadID1,ReadIDEnable1,ReadID2,ReadIDEnable2,InputStateType,ExitButtonID,ExitButtonMode,ExtiButtonEnable,DoorContactID,DoorContactMode,DoorContactEnable,DoorPositionID,DoorPositionMode,DoorPositionEnable,BreakGlassID,BreakGlassMode,BreakGlassEnable,ElectronicMapID,PositionX,PositionY,StateImageOpen,StateImageClose,StateImageAlarmOpen,StateImageAlarmClose)");
strSql.Append(" values (");
strSql.Append("@DoorUnitID,@OutPutLockID,@OutPutTimeLen,@OpenDoorOverTimeLen,@ZoneCountLimitEnable,@ZoneCountLimitMax,@ZoneCountLimitMed,@ZoneCountLimitMin,@ReadID1,@ReadIDEnable1,@ReadID2,@ReadIDEnable2,@InputStateType,@ExitButtonID,@ExitButtonMode,@ExtiButtonEnable,@DoorContactID,@DoorContactMode,@DoorContactEnable,@DoorPositionID,@DoorPositionMode,@DoorPositionEnable,@BreakGlassID,@BreakGlassMode,@BreakGlassEnable,@ElectronicMapID,@PositionX,@PositionY,@StateImageOpen,@StateImageClose,@StateImageAlarmOpen,@StateImageAlarmClose)");
SqlParameter[] parameters =
{
new SqlParameter("@DoorUnitID", SqlDbType.Int, 4),
new SqlParameter("@OutPutLockID", SqlDbType.Int, 4),
new SqlParameter("@OutPutTimeLen", SqlDbType.Int, 4),
new SqlParameter("@OpenDoorOverTimeLen", SqlDbType.Int, 4),
new SqlParameter("@ZoneCountLimitEnable", SqlDbType.Bit, 1),
new SqlParameter("@ZoneCountLimitMax", SqlDbType.Int, 4),
new SqlParameter("@ZoneCountLimitMed", SqlDbType.Int, 4),
new SqlParameter("@ZoneCountLimitMin", SqlDbType.Int, 4),
new SqlParameter("@ReadID1", SqlDbType.Int, 4),
new SqlParameter("@ReadIDEnable1", SqlDbType.Bit, 1),
new SqlParameter("@ReadID2", SqlDbType.Int, 4),
new SqlParameter("@ReadIDEnable2", SqlDbType.Bit, 1),
new SqlParameter("@InputStateType", SqlDbType.Int, 4),
new SqlParameter("@ExitButtonID", SqlDbType.Int, 4),
new SqlParameter("@ExitButtonMode", SqlDbType.Int, 4),
new SqlParameter("@ExtiButtonEnable", SqlDbType.Bit, 1),
new SqlParameter("@DoorContactID", SqlDbType.Int, 4),
new SqlParameter("@DoorContactMode", SqlDbType.Int, 4),
new SqlParameter("@DoorContactEnable", SqlDbType.Bit, 1),
new SqlParameter("@DoorPositionID", SqlDbType.Int, 4),
new SqlParameter("@DoorPositionMode", SqlDbType.Int, 4),
new SqlParameter("@DoorPositionEnable", SqlDbType.Bit, 1),
new SqlParameter("@BreakGlassID", SqlDbType.Int, 4),
new SqlParameter("@BreakGlassMode", SqlDbType.Int, 4),
new SqlParameter("@BreakGlassEnable", SqlDbType.Bit, 1),
new SqlParameter("@ElectronicMapID", SqlDbType.Int, 4),
new SqlParameter("@PositionX", SqlDbType.Int, 4),
new SqlParameter("@PositionY", SqlDbType.Int, 4),
new SqlParameter("@StateImageOpen", SqlDbType.Image),
new SqlParameter("@StateImageClose", SqlDbType.Image),
new SqlParameter("@StateImageAlarmOpen", SqlDbType.Image),
new SqlParameter("@StateImageAlarmClose", SqlDbType.Image)
};
parameters[0].Value = model.DoorUnitID;
parameters[1].Value = model.OutPutLockID;
parameters[2].Value = model.OutPutTimeLen;
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.ReadID1;
parameters[9].Value = model.ReadIDEnable1;
parameters[10].Value = model.ReadID2;
parameters[11].Value = model.ReadIDEnable2;
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;
parameters[25].Value = model.ElectronicMapID;
parameters[26].Value = model.PositionX;
parameters[27].Value = model.PositionY;
parameters[28].Value = model.StateImageOpen;
parameters[29].Value = model.StateImageClose;
parameters[30].Value = model.StateImageAlarmOpen;
parameters[31].Value = model.StateImageAlarmClose;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.DoorUnitInfo DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.DoorUnitInfo model = new KryptonAccessController.AccessDataBase.Model.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["OutPutTimeLen"] != null && row["OutPutTimeLen"].ToString() != "")
{
model.OutPutTimeLen = int.Parse(row["OutPutTimeLen"].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["ReadID1"] != null && row["ReadID1"].ToString() != "")
{
model.ReadID1 = int.Parse(row["ReadID1"].ToString());
}
if (row["ReadIDEnable1"] != null && row["ReadIDEnable1"].ToString() != "")
{
if ((row["ReadIDEnable1"].ToString() == "1") || (row["ReadIDEnable1"].ToString().ToLower() == "true"))
{
model.ReadIDEnable1 = true;
}
else
{
model.ReadIDEnable1 = false;
}
}
if (row["ReadID2"] != null && row["ReadID2"].ToString() != "")
{
model.ReadID2 = int.Parse(row["ReadID2"].ToString());
}
if (row["ReadIDEnable2"] != null && row["ReadIDEnable2"].ToString() != "")
{
if ((row["ReadIDEnable2"].ToString() == "1") || (row["ReadIDEnable2"].ToString().ToLower() == "true"))
{
model.ReadIDEnable2 = true;
}
else
{
model.ReadIDEnable2 = 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;
}
}
if (row["ElectronicMapID"] != null && row["ElectronicMapID"].ToString() != "")
{
model.ElectronicMapID = int.Parse(row["ElectronicMapID"].ToString());
}
if (row["PositionX"] != null && row["PositionX"].ToString() != "")
{
model.PositionX = int.Parse(row["PositionX"].ToString());
}
if (row["PositionY"] != null && row["PositionY"].ToString() != "")
{
model.PositionY = int.Parse(row["PositionY"].ToString());
}
if (row["StateImageOpen"] != null && row["StateImageOpen"].ToString() != "")
{
model.StateImageOpen = (byte[])row["StateImageOpen"];
}
if (row["StateImageClose"] != null && row["StateImageClose"].ToString() != "")
{
model.StateImageClose = (byte[])row["StateImageClose"];
}
if (row["StateImageAlarmOpen"] != null && row["StateImageAlarmOpen"].ToString() != "")
{
model.StateImageAlarmOpen = (byte[])row["StateImageAlarmOpen"];
}
if (row["StateImageAlarmClose"] != null && row["StateImageAlarmClose"].ToString() != "")
{
model.StateImageAlarmClose = (byte[])row["StateImageAlarmClose"];
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KryptonAccessController.AccessDataBase.Model.DoorUnitInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DoorUnitInfo set ");
strSql.Append("OutPutLockID=@OutPutLockID,");
strSql.Append("OutPutTimeLen=@OutPutTimeLen,");
strSql.Append("OpenDoorOverTimeLen=@OpenDoorOverTimeLen,");
strSql.Append("ZoneCountLimitEnable=@ZoneCountLimitEnable,");
strSql.Append("ZoneCountLimitMax=@ZoneCountLimitMax,");
strSql.Append("ZoneCountLimitMed=@ZoneCountLimitMed,");
strSql.Append("ZoneCountLimitMin=@ZoneCountLimitMin,");
strSql.Append("ReadID1=@ReadID1,");
strSql.Append("ReadIDEnable1=@ReadIDEnable1,");
strSql.Append("ReadID2=@ReadID2,");
strSql.Append("ReadIDEnable2=@ReadIDEnable2,");
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("ElectronicMapID=@ElectronicMapID,");
strSql.Append("PositionX=@PositionX,");
strSql.Append("PositionY=@PositionY,");
strSql.Append("StateImageOpen=@StateImageOpen,");
strSql.Append("StateImageClose=@StateImageClose,");
strSql.Append("StateImageAlarmOpen=@StateImageAlarmOpen,");
strSql.Append("StateImageAlarmClose=@StateImageAlarmClose");
strSql.Append(" where DoorUnitID=@DoorUnitID ");
SqlParameter[] parameters =
{
new SqlParameter("@OutPutLockID", SqlDbType.Int, 4),
new SqlParameter("@OutPutTimeLen", SqlDbType.Int, 4),
new SqlParameter("@OpenDoorOverTimeLen", SqlDbType.Int, 4),
new SqlParameter("@ZoneCountLimitEnable", SqlDbType.Bit, 1),
new SqlParameter("@ZoneCountLimitMax", SqlDbType.Int, 4),
new SqlParameter("@ZoneCountLimitMed", SqlDbType.Int, 4),
new SqlParameter("@ZoneCountLimitMin", SqlDbType.Int, 4),
new SqlParameter("@ReadID1", SqlDbType.Int, 4),
new SqlParameter("@ReadIDEnable1", SqlDbType.Bit, 1),
new SqlParameter("@ReadID2", SqlDbType.Int, 4),
new SqlParameter("@ReadIDEnable2", SqlDbType.Bit, 1),
new SqlParameter("@InputStateType", SqlDbType.Int, 4),
new SqlParameter("@ExitButtonID", SqlDbType.Int, 4),
new SqlParameter("@ExitButtonMode", SqlDbType.Int, 4),
new SqlParameter("@ExtiButtonEnable", SqlDbType.Bit, 1),
new SqlParameter("@DoorContactID", SqlDbType.Int, 4),
new SqlParameter("@DoorContactMode", SqlDbType.Int, 4),
new SqlParameter("@DoorContactEnable", SqlDbType.Bit, 1),
new SqlParameter("@DoorPositionID", SqlDbType.Int, 4),
new SqlParameter("@DoorPositionMode", SqlDbType.Int, 4),
new SqlParameter("@DoorPositionEnable", SqlDbType.Bit, 1),
new SqlParameter("@BreakGlassID", SqlDbType.Int, 4),
new SqlParameter("@BreakGlassMode", SqlDbType.Int, 4),
new SqlParameter("@BreakGlassEnable", SqlDbType.Bit, 1),
new SqlParameter("@ElectronicMapID", SqlDbType.Int, 4),
new SqlParameter("@PositionX", SqlDbType.Int, 4),
new SqlParameter("@PositionY", SqlDbType.Int, 4),
new SqlParameter("@StateImageOpen", SqlDbType.Image),
new SqlParameter("@StateImageClose", SqlDbType.Image),
new SqlParameter("@StateImageAlarmOpen", SqlDbType.Image),
new SqlParameter("@StateImageAlarmClose", SqlDbType.Image),
new SqlParameter("@DoorUnitID", SqlDbType.Int, 4)
};
parameters[0].Value = model.OutPutLockID;
parameters[1].Value = model.OutPutTimeLen;
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.ReadID1;
parameters[8].Value = model.ReadIDEnable1;
parameters[9].Value = model.ReadID2;
parameters[10].Value = model.ReadIDEnable2;
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.ElectronicMapID;
parameters[25].Value = model.PositionX;
parameters[26].Value = model.PositionY;
parameters[27].Value = model.StateImageOpen;
parameters[28].Value = model.StateImageClose;
parameters[29].Value = model.StateImageAlarmOpen;
parameters[30].Value = model.StateImageAlarmClose;
parameters[31].Value = model.DoorUnitID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}