/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.AntiPassBack DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.AntiPassBack model = new KryptonAccessController.AccessDataBase.Model.AntiPassBack();
if (row != null)
{
if (row["AntiPassBackID"] != null && row["AntiPassBackID"].ToString() != "")
{
model.AntiPassBackID = int.Parse(row["AntiPassBackID"].ToString());
}
if (row["AntiPassBackMode"] != null && row["AntiPassBackMode"].ToString() != "")
{
model.AntiPassBackMode = int.Parse(row["AntiPassBackMode"].ToString());
}
if (row["AntiPassEnable"] != null && row["AntiPassEnable"].ToString() != "")
{
if ((row["AntiPassEnable"].ToString() == "1") || (row["AntiPassEnable"].ToString().ToLower() == "true"))
{
model.AntiPassEnable = true;
}
else
{
model.AntiPassEnable = false;
}
}
if (row["ControlerInfoInLANID1"] != null && row["ControlerInfoInLANID1"].ToString() != "")
{
model.ControlerInfoInLANID1 = int.Parse(row["ControlerInfoInLANID1"].ToString());
}
if (row["DoorUnitID1"] != null && row["DoorUnitID1"].ToString() != "")
{
model.DoorUnitID1 = int.Parse(row["DoorUnitID1"].ToString());
}
if (row["ControlerInfoInLANID2"] != null && row["ControlerInfoInLANID2"].ToString() != "")
{
model.ControlerInfoInLANID2 = int.Parse(row["ControlerInfoInLANID2"].ToString());
}
if (row["DoorUnitID2"] != null && row["DoorUnitID2"].ToString() != "")
{
model.DoorUnitID2 = int.Parse(row["DoorUnitID2"].ToString());
}
if (row["ControlerInfoInLANID3"] != null && row["ControlerInfoInLANID3"].ToString() != "")
{
model.ControlerInfoInLANID3 = int.Parse(row["ControlerInfoInLANID3"].ToString());
}
if (row["DoorUnitID3"] != null && row["DoorUnitID3"].ToString() != "")
{
model.DoorUnitID3 = int.Parse(row["DoorUnitID3"].ToString());
}
if (row["ControlerInfoInLANID4"] != null && row["ControlerInfoInLANID4"].ToString() != "")
{
model.ControlerInfoInLANID4 = int.Parse(row["ControlerInfoInLANID4"].ToString());
}
if (row["DoorUnitID4"] != null && row["DoorUnitID4"].ToString() != "")
{
model.DoorUnitID4 = int.Parse(row["DoorUnitID4"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KryptonAccessController.AccessDataBase.Model.AntiPassBack model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AntiPassBack set ");
strSql.Append("AntiPassBackMode=@AntiPassBackMode,");
strSql.Append("AntiPassEnable=@AntiPassEnable,");
strSql.Append("ControlerInfoInLANID1=@ControlerInfoInLANID1,");
strSql.Append("DoorUnitID1=@DoorUnitID1,");
strSql.Append("ControlerInfoInLANID2=@ControlerInfoInLANID2,");
strSql.Append("DoorUnitID2=@DoorUnitID2,");
strSql.Append("ControlerInfoInLANID3=@ControlerInfoInLANID3,");
strSql.Append("DoorUnitID3=@DoorUnitID3,");
strSql.Append("ControlerInfoInLANID4=@ControlerInfoInLANID4,");
strSql.Append("DoorUnitID4=@DoorUnitID4");
strSql.Append(" where AntiPassBackID=@AntiPassBackID ");
SqlParameter[] parameters =
{
new SqlParameter("@AntiPassBackMode", SqlDbType.Int, 4),
new SqlParameter("@AntiPassEnable", SqlDbType.Bit, 1),
new SqlParameter("@ControlerInfoInLANID1", SqlDbType.Int, 4),
new SqlParameter("@DoorUnitID1", SqlDbType.Int, 4),
new SqlParameter("@ControlerInfoInLANID2", SqlDbType.Int, 4),
new SqlParameter("@DoorUnitID2", SqlDbType.Int, 4),
new SqlParameter("@ControlerInfoInLANID3", SqlDbType.Int, 4),
new SqlParameter("@DoorUnitID3", SqlDbType.Int, 4),
new SqlParameter("@ControlerInfoInLANID4", SqlDbType.Int, 4),
new SqlParameter("@DoorUnitID4", SqlDbType.Int, 4),
new SqlParameter("@AntiPassBackID", SqlDbType.Int, 4)
};
parameters[0].Value = model.AntiPassBackMode;
parameters[1].Value = model.AntiPassEnable;
parameters[2].Value = model.ControlerInfoInLANID1;
parameters[3].Value = model.DoorUnitID1;
parameters[4].Value = model.ControlerInfoInLANID2;
parameters[5].Value = model.DoorUnitID2;
parameters[6].Value = model.ControlerInfoInLANID3;
parameters[7].Value = model.DoorUnitID3;
parameters[8].Value = model.ControlerInfoInLANID4;
parameters[9].Value = model.DoorUnitID4;
parameters[10].Value = model.AntiPassBackID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.AntiPassBack model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AntiPassBack(");
strSql.Append("AntiPassBackID,AntiPassBackMode,AntiPassEnable,ControlerInfoInLANID1,DoorUnitID1,ControlerInfoInLANID2,DoorUnitID2,ControlerInfoInLANID3,DoorUnitID3,ControlerInfoInLANID4,DoorUnitID4)");
strSql.Append(" values (");
strSql.Append("@AntiPassBackID,@AntiPassBackMode,@AntiPassEnable,@ControlerInfoInLANID1,@DoorUnitID1,@ControlerInfoInLANID2,@DoorUnitID2,@ControlerInfoInLANID3,@DoorUnitID3,@ControlerInfoInLANID4,@DoorUnitID4)");
SqlParameter[] parameters =
{
new SqlParameter("@AntiPassBackID", SqlDbType.Int, 4),
new SqlParameter("@AntiPassBackMode", SqlDbType.Int, 4),
new SqlParameter("@AntiPassEnable", SqlDbType.Bit, 1),
new SqlParameter("@ControlerInfoInLANID1", SqlDbType.Int, 4),
new SqlParameter("@DoorUnitID1", SqlDbType.Int, 4),
new SqlParameter("@ControlerInfoInLANID2", SqlDbType.Int, 4),
new SqlParameter("@DoorUnitID2", SqlDbType.Int, 4),
new SqlParameter("@ControlerInfoInLANID3", SqlDbType.Int, 4),
new SqlParameter("@DoorUnitID3", SqlDbType.Int, 4),
new SqlParameter("@ControlerInfoInLANID4", SqlDbType.Int, 4),
new SqlParameter("@DoorUnitID4", SqlDbType.Int, 4)
};
parameters[0].Value = model.AntiPassBackID;
parameters[1].Value = model.AntiPassBackMode;
parameters[2].Value = model.AntiPassEnable;
parameters[3].Value = model.ControlerInfoInLANID1;
parameters[4].Value = model.DoorUnitID1;
parameters[5].Value = model.ControlerInfoInLANID2;
parameters[6].Value = model.DoorUnitID2;
parameters[7].Value = model.ControlerInfoInLANID3;
parameters[8].Value = model.DoorUnitID3;
parameters[9].Value = model.ControlerInfoInLANID4;
parameters[10].Value = model.DoorUnitID4;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.AntiPassBack GetModel(int AntiPassBackID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 AntiPassBackID,AntiPassBackMode,AntiPassEnable,ControlerInfoInLANID1,DoorUnitID1,ControlerInfoInLANID2,DoorUnitID2,ControlerInfoInLANID3,DoorUnitID3,ControlerInfoInLANID4,DoorUnitID4 from AntiPassBack ");
strSql.Append(" where AntiPassBackID=@AntiPassBackID ");
SqlParameter[] parameters =
{
new SqlParameter("@AntiPassBackID", SqlDbType.Int, 4)
};
parameters[0].Value = AntiPassBackID;
KryptonAccessController.AccessDataBase.Model.AntiPassBack model = new KryptonAccessController.AccessDataBase.Model.AntiPassBack();
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 KryptonAccessController.AccessDataBase.Model.AntiPassBack DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.AntiPassBack model=new KryptonAccessController.AccessDataBase.Model.AntiPassBack();
if (row != null)
{
if(row["AntiPassBackID"]!=null && row["AntiPassBackID"].ToString()!="")
{
model.AntiPassBackID=int.Parse(row["AntiPassBackID"].ToString());
}
if(row["AntiPassBackMode"]!=null && row["AntiPassBackMode"].ToString()!="")
{
model.AntiPassBackMode=int.Parse(row["AntiPassBackMode"].ToString());
}
if(row["AntiPassEnable"]!=null && row["AntiPassEnable"].ToString()!="")
{
if((row["AntiPassEnable"].ToString()=="1")||(row["AntiPassEnable"].ToString().ToLower()=="true"))
{
model.AntiPassEnable=true;
}
else
{
model.AntiPassEnable=false;
}
}
if(row["ControlerInfoInLANID1"]!=null && row["ControlerInfoInLANID1"].ToString()!="")
{
model.ControlerInfoInLANID1=int.Parse(row["ControlerInfoInLANID1"].ToString());
}
if(row["DoorUnitID1"]!=null && row["DoorUnitID1"].ToString()!="")
{
model.DoorUnitID1=int.Parse(row["DoorUnitID1"].ToString());
}
if(row["ControlerInfoInLANID2"]!=null && row["ControlerInfoInLANID2"].ToString()!="")
{
model.ControlerInfoInLANID2=int.Parse(row["ControlerInfoInLANID2"].ToString());
}
if(row["DoorUnitID2"]!=null && row["DoorUnitID2"].ToString()!="")
{
model.DoorUnitID2=int.Parse(row["DoorUnitID2"].ToString());
}
if(row["ControlerInfoInLANID3"]!=null && row["ControlerInfoInLANID3"].ToString()!="")
{
model.ControlerInfoInLANID3=int.Parse(row["ControlerInfoInLANID3"].ToString());
}
if(row["DoorUnitID3"]!=null && row["DoorUnitID3"].ToString()!="")
{
model.DoorUnitID3=int.Parse(row["DoorUnitID3"].ToString());
}
if(row["ControlerInfoInLANID4"]!=null && row["ControlerInfoInLANID4"].ToString()!="")
{
model.ControlerInfoInLANID4=int.Parse(row["ControlerInfoInLANID4"].ToString());
}
if(row["DoorUnitID4"]!=null && row["DoorUnitID4"].ToString()!="")
{
model.DoorUnitID4=int.Parse(row["DoorUnitID4"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.AntiPassBack GetModel(int AntiPassBackID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 AntiPassBackID,AntiPassBackMode,AntiPassEnable,ControlerInfoInLANID1,DoorUnitID1,ControlerInfoInLANID2,DoorUnitID2,ControlerInfoInLANID3,DoorUnitID3,ControlerInfoInLANID4,DoorUnitID4 from AntiPassBack ");
strSql.Append(" where AntiPassBackID=@AntiPassBackID ");
SqlParameter[] parameters = {
new SqlParameter("@AntiPassBackID", SqlDbType.Int,4) };
parameters[0].Value = AntiPassBackID;
KryptonAccessController.AccessDataBase.Model.AntiPassBack model=new KryptonAccessController.AccessDataBase.Model.AntiPassBack();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
