/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.EventInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EventInfo(");
strSql.Append("EventID,ControllerID,PointType,PointID,CardID,EventCodeID,EventDateTime)");
strSql.Append(" values (");
strSql.Append("@EventID,@ControllerID,@PointType,@PointID,@CardID,@EventCodeID,@EventDateTime)");
SqlParameter[] parameters = {
new SqlParameter("@EventID", SqlDbType.Int,4),
new SqlParameter("@ControllerID", SqlDbType.Int,4),
new SqlParameter("@PointType", SqlDbType.Int,4),
new SqlParameter("@PointID", SqlDbType.Int,4),
new SqlParameter("@CardID", SqlDbType.NVarChar,10),
new SqlParameter("@EventCodeID", SqlDbType.Int,4),
new SqlParameter("@EventDateTime", SqlDbType.NVarChar,10)};
parameters[0].Value = model.EventID;
parameters[1].Value = model.ControllerID;
parameters[2].Value = model.PointType;
parameters[3].Value = model.PointID;
parameters[4].Value = model.CardID;
parameters[5].Value = model.EventCodeID;
parameters[6].Value = model.EventDateTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.InteractRelation.StandardOperateProcedure model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into StandardOperateProcedure(");
strSql.Append("SOPID,SOPName,SOPWaitTimeLength,DesControllerInfoInLANID,Action,OutPutLength)");
strSql.Append(" values (");
strSql.Append("@SOPID,@SOPName,@SOPWaitTimeLength,@DesControllerInfoInLANID,@Action,@OutPutLength)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@SOPID", DbType.Int32,4),
new SQLiteParameter("@SOPName", DbType.String),
new SQLiteParameter("@SOPWaitTimeLength", DbType.Int32,4),
new SQLiteParameter("@DesControllerInfoInLANID", DbType.Int32,4),
new SQLiteParameter("@Action", DbType.String),
new SQLiteParameter("@OutPutLength", DbType.Int32,4)};
parameters[0].Value = model.SOPID;
parameters[1].Value = model.SOPName;
parameters[2].Value = model.SOPWaitTimeLength;
parameters[3].Value = model.DesControllerInfoInLANID;
parameters[4].Value = model.Action;
parameters[5].Value = model.OutPutLength;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.ElectronicMap model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ElectronicMap(");
strSql.Append("ElectronicMapID,ElectronicMapName,ElectronicMapDes,Map)");
strSql.Append(" values (");
strSql.Append("@ElectronicMapID,@ElectronicMapName,@ElectronicMapDes,@Map)");
SqlParameter[] parameters = {
new SqlParameter("@ElectronicMapID", SqlDbType.Int,4),
new SqlParameter("@ElectronicMapName", SqlDbType.NVarChar,50),
new SqlParameter("@ElectronicMapDes", SqlDbType.NVarChar,100),
new SqlParameter("@Map", SqlDbType.Image)};
parameters[0].Value = model.ElectronicMapID;
parameters[1].Value = model.ElectronicMapName;
parameters[2].Value = model.ElectronicMapDes;
parameters[3].Value = model.Map;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.InteractRelation.HolidayICP model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into HolidayICP(");
strSql.Append("HolidayID,HolidayName,HolidayStartDate,HolidayEndDate,HolidayType,TimeICPID)");
strSql.Append(" values (");
strSql.Append("@HolidayID,@HolidayName,@HolidayStartDate,@HolidayEndDate,@HolidayType,@TimeICPID)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@HolidayID", DbType.Int32,4),
new SQLiteParameter("@HolidayName", DbType.String),
new SQLiteParameter("@HolidayStartDate", DbType.String),
new SQLiteParameter("@HolidayEndDate", DbType.String),
new SQLiteParameter("@HolidayType", DbType.Int32,4),
new SQLiteParameter("@TimeICPID", DbType.Int32,4)};
parameters[0].Value = model.HolidayID;
parameters[1].Value = model.HolidayName;
parameters[2].Value = model.HolidayStartDate;
parameters[3].Value = model.HolidayEndDate;
parameters[4].Value = model.HolidayType;
parameters[5].Value = model.TimeICPID;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.LCDRelation.MediaVideo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into MediaVideo(");
strSql.Append("MediaVideoID,MediaVideoName,MediaVideoFilePath,MediaVideoGroupID,MediaVideoType,PlayPriority)");
strSql.Append(" values (");
strSql.Append("@MediaVideoID,@MediaVideoName,@MediaVideoFilePath,@MediaVideoGroupID,@MediaVideoType,@PlayPriority)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@MediaVideoID", DbType.Int32,4),
new SQLiteParameter("@MediaVideoName", DbType.String),
new SQLiteParameter("@MediaVideoFilePath", DbType.String),
new SQLiteParameter("@MediaVideoGroupID", DbType.Int32,4),
new SQLiteParameter("@MediaVideoType", DbType.Int32,4),
new SQLiteParameter("@PlayPriority", DbType.Int32,4)};
parameters[0].Value = model.MediaVideoID;
parameters[1].Value = model.MediaVideoName;
parameters[2].Value = model.MediaVideoFilePath;
parameters[3].Value = model.MediaVideoGroupID;
parameters[4].Value = model.MediaVideoType;
parameters[5].Value = model.PlayPriority;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.InteractRelation.InterControlProgram model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into InterControlProgram(");
strSql.Append("ICPID,ICPName,ICPWaitTimeLength,DesControllerInfoInLANID,PointType,PointID,PointState,OutPutLength)");
strSql.Append(" values (");
strSql.Append("@ICPID,@ICPName,@ICPWaitTimeLength,@DesControllerInfoInLANID,@PointType,@PointID,@PointState,@OutPutLength)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@ICPID", DbType.Int32,4),
new SQLiteParameter("@ICPName", DbType.String),
new SQLiteParameter("@ICPWaitTimeLength", DbType.Int32,4),
new SQLiteParameter("@DesControllerInfoInLANID", DbType.Int32,4),
new SQLiteParameter("@PointType", DbType.Int32,4),
new SQLiteParameter("@PointID", DbType.Int32,4),
new SQLiteParameter("@PointState", DbType.Int32,4),
new SQLiteParameter("@OutPutLength", DbType.Int32,4)};
parameters[0].Value = model.ICPID;
parameters[1].Value = model.ICPName;
parameters[2].Value = model.ICPWaitTimeLength;
parameters[3].Value = model.DesControllerInfoInLANID;
parameters[4].Value = model.PointType;
parameters[5].Value = model.PointID;
parameters[6].Value = model.PointState;
parameters[7].Value = model.OutPutLength;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.HolidayICP model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into HolidayICP(");
strSql.Append("HolidayID,HolidayName,HolidayStartDate,HolidayEndDate,HolidayType,TimePoint,ICPID)");
strSql.Append(" values (");
strSql.Append("@HolidayID,@HolidayName,@HolidayStartDate,@HolidayEndDate,@HolidayType,@TimePoint,@ICPID)");
SqlParameter[] parameters = {
new SqlParameter("@HolidayID", SqlDbType.Int,4),
new SqlParameter("@HolidayName", SqlDbType.NVarChar,50),
new SqlParameter("@HolidayStartDate", SqlDbType.NVarChar,10),
new SqlParameter("@HolidayEndDate", SqlDbType.NVarChar,10),
new SqlParameter("@HolidayType", SqlDbType.Int,4),
new SqlParameter("@TimePoint", SqlDbType.NVarChar,8),
new SqlParameter("@ICPID", SqlDbType.Int,4)};
parameters[0].Value = model.HolidayID;
parameters[1].Value = model.HolidayName;
parameters[2].Value = model.HolidayStartDate;
parameters[3].Value = model.HolidayEndDate;
parameters[4].Value = model.HolidayType;
parameters[5].Value = model.TimePoint;
parameters[6].Value = model.ICPID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.InteractRelation.EventICP model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EventICP(");
strSql.Append("EventICPID,EventICPName,EventICPEnable,PointType,PointID,EventCodeID,ICPID)");
strSql.Append(" values (");
strSql.Append("@EventICPID,@EventICPName,@EventICPEnable,@PointType,@PointID,@EventCodeID,@ICPID)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@EventICPID", DbType.Int32,4),
new SQLiteParameter("@EventICPName", DbType.String),
new SQLiteParameter("@EventICPEnable", DbType.Boolean,1),
new SQLiteParameter("@PointType", DbType.Int32,4),
new SQLiteParameter("@PointID", DbType.Int32,4),
new SQLiteParameter("@EventCodeID", DbType.Int32,4),
new SQLiteParameter("@ICPID", DbType.Int32,4)};
parameters[0].Value = model.EventICPID;
parameters[1].Value = model.EventICPName;
parameters[2].Value = model.EventICPEnable;
parameters[3].Value = model.PointType;
parameters[4].Value = model.PointID;
parameters[5].Value = model.EventCodeID;
parameters[6].Value = model.ICPID;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.InteractRelation.InterLock model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into InterLock(");
strSql.Append("InterLockID,InterLockEnable,ControlerInfoInLANID1,DoorUnitID1,ControlerInfoInLANID2,DoorUnitID2)");
strSql.Append(" values (");
strSql.Append("@InterLockID,@InterLockEnable,@ControlerInfoInLANID1,@DoorUnitID1,@ControlerInfoInLANID2,@DoorUnitID2)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@InterLockID", DbType.Int32,4),
new SQLiteParameter("@InterLockEnable", DbType.Boolean,1),
new SQLiteParameter("@ControlerInfoInLANID1", DbType.Int32,4),
new SQLiteParameter("@DoorUnitID1", DbType.Int32,4),
new SQLiteParameter("@ControlerInfoInLANID2", DbType.Int32,4),
new SQLiteParameter("@DoorUnitID2", DbType.Int32,4)};
parameters[0].Value = model.InterLockID;
parameters[1].Value = model.InterLockEnable;
parameters[2].Value = model.ControlerInfoInLANID1;
parameters[3].Value = model.DoorUnitID1;
parameters[4].Value = model.ControlerInfoInLANID2;
parameters[5].Value = model.DoorUnitID2;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.UserRelation.CardInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CardInfo(");
strSql.Append("CardID,CardVersion,CardType,CardLevel,CardPassword,CardIssueDateTime,CardValidDateTime,StateFlag)");
strSql.Append(" values (");
strSql.Append("@CardID,@CardVersion,@CardType,@CardLevel,@CardPassword,@CardIssueDateTime,@CardValidDateTime,@StateFlag)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@CardID", DbType.String),
new SQLiteParameter("@CardVersion", DbType.String),
new SQLiteParameter("@CardType", DbType.Int32,4),
new SQLiteParameter("@CardLevel", DbType.String),
new SQLiteParameter("@CardPassword", DbType.String),
new SQLiteParameter("@CardIssueDateTime", DbType.String),
new SQLiteParameter("@CardValidDateTime", DbType.String),
new SQLiteParameter("@StateFlag", DbType.String)};
parameters[0].Value = model.CardID;
parameters[1].Value = model.CardVersion;
parameters[2].Value = model.CardType;
parameters[3].Value = model.CardLevel;
parameters[4].Value = model.CardPassword;
parameters[5].Value = model.CardIssueDateTime;
parameters[6].Value = model.CardValidDateTime;
parameters[7].Value = model.StateFlag;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.ManagerRelation.MenuIconInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into MenuIconInfo(");
strSql.Append("MenuIconID,MenuIconName,MenuIconCommercial,MenuIconImage)");
strSql.Append(" values (");
strSql.Append("@MenuIconID,@MenuIconName,@MenuIconCommercial,@MenuIconImage)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@MenuIconID", DbType.Int32,4),
new SQLiteParameter("@MenuIconName", DbType.String),
new SQLiteParameter("@MenuIconCommercial", DbType.Int32,4),
new SQLiteParameter("@MenuIconImage", DbType.Binary)};
parameters[0].Value = model.MenuIconID;
parameters[1].Value = model.MenuIconName;
parameters[2].Value = model.MenuIconCommercial;
parameters[3].Value = model.MenuIconImage;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.ManagerRelation.Manager model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Manager(");
strSql.Append("ManagerID,ManagerName,ManagerPassWord,IsSuperManager)");
strSql.Append(" values (");
strSql.Append("@ManagerID,@ManagerName,@ManagerPassWord,@IsSuperManager)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@ManagerID", DbType.Int32,4),
new SQLiteParameter("@ManagerName", DbType.String),
new SQLiteParameter("@ManagerPassWord", DbType.String),
new SQLiteParameter("@IsSuperManager", DbType.Boolean,1)};
parameters[0].Value = model.ManagerID;
parameters[1].Value = model.ManagerName;
parameters[2].Value = model.ManagerPassWord;
parameters[3].Value = model.IsSuperManager;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.EventPictureInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EventPictureInfo(");
strSql.Append("EventPictureID,EventPictureName,EventPictureComercial,EventPictureType,EventPictureImage)");
strSql.Append(" values (");
strSql.Append("@EventPictureID,@EventPictureName,@EventPictureComercial,@EventPictureType,@EventPictureImage)");
SqlParameter[] parameters = {
new SqlParameter("@EventPictureID", SqlDbType.Int,4),
new SqlParameter("@EventPictureName", SqlDbType.NVarChar,50),
new SqlParameter("@EventPictureComercial", SqlDbType.Int,4),
new SqlParameter("@EventPictureType", SqlDbType.Int,4),
new SqlParameter("@EventPictureImage", SqlDbType.Image)};
parameters[0].Value = model.EventPictureID;
parameters[1].Value = model.EventPictureName;
parameters[2].Value = model.EventPictureComercial;
parameters[3].Value = model.EventPictureType;
parameters[4].Value = model.EventPictureImage;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.UserRelation.BlackListCardInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into BlackListCardInfo(");
strSql.Append("CardID,CardVersion,CardDeactiveDateTime,UserName,MarkBListReason,BListStateFlag)");
strSql.Append(" values (");
strSql.Append("@CardID,@CardVersion,@CardDeactiveDateTime,@UserName,@MarkBListReason,@BListStateFlag)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@CardID", DbType.String),
new SQLiteParameter("@CardVersion", DbType.String),
new SQLiteParameter("@CardDeactiveDateTime", DbType.String),
new SQLiteParameter("@UserName", DbType.String),
new SQLiteParameter("@MarkBListReason", DbType.String),
new SQLiteParameter("@BListStateFlag", DbType.String)};
parameters[0].Value = model.CardID;
parameters[1].Value = model.CardVersion;
parameters[2].Value = model.CardDeactiveDateTime;
parameters[3].Value = model.UserName;
parameters[4].Value = model.MarkBListReason;
parameters[5].Value = model.BListStateFlag;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.ExpansionBoardInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ExpansionBoardInfo(");
strSql.Append("ExpansionBoardID,ExpansionBoardType,ExpansionBoardName,ExpansionBoardAddr,InputStateType,ExpansionBoardLocation)");
strSql.Append(" values (");
strSql.Append("@ExpansionBoardID,@ExpansionBoardType,@ExpansionBoardName,@ExpansionBoardAddr,@InputStateType,@ExpansionBoardLocation)");
SqlParameter[] parameters = {
new SqlParameter("@ExpansionBoardID", SqlDbType.Int,4),
new SqlParameter("@ExpansionBoardType", SqlDbType.Int,4),
new SqlParameter("@ExpansionBoardName", SqlDbType.NVarChar,50),
new SqlParameter("@ExpansionBoardAddr", SqlDbType.Int,4),
new SqlParameter("@InputStateType", SqlDbType.Int,4),
new SqlParameter("@ExpansionBoardLocation", SqlDbType.NVarChar,100)};
parameters[0].Value = model.ExpansionBoardID;
parameters[1].Value = model.ExpansionBoardType;
parameters[2].Value = model.ExpansionBoardName;
parameters[3].Value = model.ExpansionBoardAddr;
parameters[4].Value = model.InputStateType;
parameters[5].Value = model.ExpansionBoardLocation;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.CompanyInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CompanyInfo(");
strSql.Append("CompanyID,CompanyName,CompanyDes,CompanyAddress,CompanyTel1,CompanyTel2)");
strSql.Append(" values (");
strSql.Append("@CompanyID,@CompanyName,@CompanyDes,@CompanyAddress,@CompanyTel1,@CompanyTel2)");
SqlParameter[] parameters = {
new SqlParameter("@CompanyID", SqlDbType.Int,4),
new SqlParameter("@CompanyName", SqlDbType.NVarChar,50),
new SqlParameter("@CompanyDes", SqlDbType.NVarChar,100),
new SqlParameter("@CompanyAddress", SqlDbType.NVarChar,100),
new SqlParameter("@CompanyTel1", SqlDbType.NVarChar,15),
new SqlParameter("@CompanyTel2", SqlDbType.NVarChar,15)};
parameters[0].Value = model.CompanyID;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.CompanyDes;
parameters[3].Value = model.CompanyAddress;
parameters[4].Value = model.CompanyTel1;
parameters[5].Value = model.CompanyTel2;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.MediaVideoGroup model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into MediaVideoGroup(");
strSql.Append("MediaVideoGroupID,MediaVideoGroupName,MediaVideoGroupDes)");
strSql.Append(" values (");
strSql.Append("@MediaVideoGroupID,@MediaVideoGroupName,@MediaVideoGroupDes)");
SqlParameter[] parameters = {
new SqlParameter("@MediaVideoGroupID", SqlDbType.Int,4),
new SqlParameter("@MediaVideoGroupName", SqlDbType.NVarChar,50),
new SqlParameter("@MediaVideoGroupDes", SqlDbType.NVarChar,100)};
parameters[0].Value = model.MediaVideoGroupID;
parameters[1].Value = model.MediaVideoGroupName;
parameters[2].Value = model.MediaVideoGroupDes;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.ManagerRightList model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ManagerRightList(");
strSql.Append("ManagerRightListID,ManagerID,MenuID)");
strSql.Append(" values (");
strSql.Append("@ManagerRightListID,@ManagerID,@MenuID)");
SqlParameter[] parameters = {
new SqlParameter("@ManagerRightListID", SqlDbType.Int,4),
new SqlParameter("@ManagerID", SqlDbType.Int,4),
new SqlParameter("@MenuID", SqlDbType.Int,4)};
parameters[0].Value = model.ManagerRightListID;
parameters[1].Value = model.ManagerID;
parameters[2].Value = model.MenuID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.Manager model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Manager(");
strSql.Append("ManagerID,ManagerName,ManagerPassWord,IsSuperManager)");
strSql.Append(" values (");
strSql.Append("@ManagerID,@ManagerName,@ManagerPassWord,@IsSuperManager)");
SqlParameter[] parameters = {
new SqlParameter("@ManagerID", SqlDbType.Int,4),
new SqlParameter("@ManagerName", SqlDbType.NVarChar,50),
new SqlParameter("@ManagerPassWord", SqlDbType.NVarChar,20),
new SqlParameter("@IsSuperManager", SqlDbType.Bit,1)};
parameters[0].Value = model.ManagerID;
parameters[1].Value = model.ManagerName;
parameters[2].Value = model.ManagerPassWord;
parameters[3].Value = model.IsSuperManager;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.InteractHoliday model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into InteractHoliday(");
strSql.Append("InteractHolidayID,InteractHolidayName,InteractHolidayDate,InteractHolidayType)");
strSql.Append(" values (");
strSql.Append("@InteractHolidayID,@InteractHolidayName,@InteractHolidayDate,@InteractHolidayType)");
SqlParameter[] parameters = {
new SqlParameter("@InteractHolidayID", SqlDbType.Int,4),
new SqlParameter("@InteractHolidayName", SqlDbType.NVarChar,50),
new SqlParameter("@InteractHolidayDate", SqlDbType.NVarChar,10),
new SqlParameter("@InteractHolidayType", SqlDbType.Int,4)};
parameters[0].Value = model.InteractHolidayID;
parameters[1].Value = model.InteractHolidayName;
parameters[2].Value = model.InteractHolidayDate;
parameters[3].Value = model.InteractHolidayType;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.UserRelation.UserGroup model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into UserGroup(");
strSql.Append("UserGroupID,UserGroupName,UserGroupDes)");
strSql.Append(" values (");
strSql.Append("@UserGroupID,@UserGroupName,@UserGroupDes)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@UserGroupID", DbType.Int32,4),
new SQLiteParameter("@UserGroupName", DbType.String),
new SQLiteParameter("@UserGroupDes", DbType.String)};
parameters[0].Value = model.UserGroupID;
parameters[1].Value = model.UserGroupName;
parameters[2].Value = model.UserGroupDes;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.MediaPicture model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into MediaPicture(");
strSql.Append("MediaPictureID,MediaPictureName,MediaPicturePath,MediaPictureGroupID,MediaPicgureType,PlayPriority)");
strSql.Append(" values (");
strSql.Append("@MediaPictureID,@MediaPictureName,@MediaPicturePath,@MediaPictureGroupID,@MediaPicgureType,@PlayPriority)");
SqlParameter[] parameters = {
new SqlParameter("@MediaPictureID", SqlDbType.Int,4),
new SqlParameter("@MediaPictureName", SqlDbType.NVarChar,50),
new SqlParameter("@MediaPicturePath", SqlDbType.VarChar,100),
new SqlParameter("@MediaPictureGroupID", SqlDbType.Int,4),
new SqlParameter("@MediaPicgureType", SqlDbType.Int,4),
new SqlParameter("@PlayPriority", SqlDbType.Int,4)};
parameters[0].Value = model.MediaPictureID;
parameters[1].Value = model.MediaPictureName;
parameters[2].Value = model.MediaPicturePath;
parameters[3].Value = model.MediaPictureGroupID;
parameters[4].Value = model.MediaPicgureType;
parameters[5].Value = model.PlayPriority;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.EventSOP model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EventSOP(");
strSql.Append("EventSOPGID,EventSOPGName,EventSOPGEnable,PointType,PointID,EventCodeID,SOPID)");
strSql.Append(" values (");
strSql.Append("@EventSOPGID,@EventSOPGName,@EventSOPGEnable,@PointType,@PointID,@EventCodeID,@SOPID)");
SqlParameter[] parameters = {
new SqlParameter("@EventSOPGID", SqlDbType.Int,4),
new SqlParameter("@EventSOPGName", SqlDbType.NVarChar,50),
new SqlParameter("@EventSOPGEnable", SqlDbType.Bit,1),
new SqlParameter("@PointType", SqlDbType.Int,4),
new SqlParameter("@PointID", SqlDbType.Int,4),
new SqlParameter("@EventCodeID", SqlDbType.Int,4),
new SqlParameter("@SOPID", SqlDbType.Int,4)};
parameters[0].Value = model.EventSOPGID;
parameters[1].Value = model.EventSOPGName;
parameters[2].Value = model.EventSOPGEnable;
parameters[3].Value = model.PointType;
parameters[4].Value = model.PointID;
parameters[5].Value = model.EventCodeID;
parameters[6].Value = model.SOPID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.InteractRelation.EventCodeInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EventCodeInfo(");
strSql.Append("EventCodeID,EventCodeType,EventCodeName,EventCodePictureID,EventUpLoadPriority)");
strSql.Append(" values (");
strSql.Append("@EventCodeID,@EventCodeType,@EventCodeName,@EventCodePictureID,@EventUpLoadPriority)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@EventCodeID", DbType.Int32,4),
new SQLiteParameter("@EventCodeType", DbType.Int32,4),
new SQLiteParameter("@EventCodeName", DbType.String),
new SQLiteParameter("@EventCodePictureID", DbType.Int32,4),
new SQLiteParameter("@EventUpLoadPriority", DbType.Int32,4)};
parameters[0].Value = model.EventCodeID;
parameters[1].Value = model.EventCodeType;
parameters[2].Value = model.EventCodeName;
parameters[3].Value = model.EventCodePictureID;
parameters[4].Value = model.EventUpLoadPriority;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.UserInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into UserInfo(");
strSql.Append("UserID,UserName,Photograph,DepartmentID,EmployedDate,Duty,Telphone,Email,UserGroupID1,UserGroupID2,UserGroupID3,UserGroupID4,FingerPosition0,FingerPrint0,FingerPosition1,FingerPrint1,SercurityAccessLevel,PrimaryCardID,SecondCardID)");
strSql.Append(" values (");
strSql.Append("@UserID,@UserName,@Photograph,@DepartmentID,@EmployedDate,@Duty,@Telphone,@Email,@UserGroupID1,@UserGroupID2,@UserGroupID3,@UserGroupID4,@FingerPosition0,@FingerPrint0,@FingerPosition1,@FingerPrint1,@SercurityAccessLevel,@PrimaryCardID,@SecondCardID)");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Int,4),
new SqlParameter("@UserName", SqlDbType.NVarChar,50),
new SqlParameter("@Photograph", SqlDbType.Image),
new SqlParameter("@DepartmentID", SqlDbType.Int,4),
new SqlParameter("@EmployedDate", SqlDbType.NVarChar,10),
new SqlParameter("@Duty", SqlDbType.NVarChar,50),
new SqlParameter("@Telphone", SqlDbType.NVarChar,15),
new SqlParameter("@Email", SqlDbType.NVarChar,100),
new SqlParameter("@UserGroupID1", SqlDbType.Int,4),
new SqlParameter("@UserGroupID2", SqlDbType.Int,4),
new SqlParameter("@UserGroupID3", SqlDbType.Int,4),
new SqlParameter("@UserGroupID4", SqlDbType.Int,4),
new SqlParameter("@FingerPosition0", SqlDbType.Int,4),
new SqlParameter("@FingerPrint0", SqlDbType.Image),
new SqlParameter("@FingerPosition1", SqlDbType.Int,4),
new SqlParameter("@FingerPrint1", SqlDbType.Image),
new SqlParameter("@SercurityAccessLevel", SqlDbType.Int,4),
new SqlParameter("@PrimaryCardID", SqlDbType.NVarChar,10),
new SqlParameter("@SecondCardID", SqlDbType.NVarChar,10)};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Photograph;
parameters[3].Value = model.DepartmentID;
parameters[4].Value = model.EmployedDate;
parameters[5].Value = model.Duty;
parameters[6].Value = model.Telphone;
parameters[7].Value = model.Email;
parameters[8].Value = model.UserGroupID1;
parameters[9].Value = model.UserGroupID2;
parameters[10].Value = model.UserGroupID3;
parameters[11].Value = model.UserGroupID4;
parameters[12].Value = model.FingerPosition0;
parameters[13].Value = model.FingerPrint0;
parameters[14].Value = model.FingerPosition1;
parameters[15].Value = model.FingerPrint1;
parameters[16].Value = model.SercurityAccessLevel;
parameters[17].Value = model.PrimaryCardID;
parameters[18].Value = model.SecondCardID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <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;
}
}
private int packageControllerInfo(ref KryptonAccessController.AccessDataBase.Model.ControllerInfo modelControllerInfo)
{
modelControllerInfo = new KryptonAccessController.AccessDataBase.Model.ControllerInfo();
int controllerID;
bool ret = int.TryParse(TextBoxControllerID.Text.Trim(), out controllerID);
if (ret == false)
{
Response.Write("<script>alert('控制器编号不能为空，且必须为数字!')</script>");
return -1;
}
modelControllerInfo.ControllerID = controllerID;
return 0;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.UserRelation.UserInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into UserInfo(");
strSql.Append("UserID,UserName,Photograph,UserGroupID1,UserGroupID2,UserGroupID3,UserGroupID4,FingerPosition0,FingerPrint0,FingerPosition1,FingerPrint1,SercurityAccessLevel,PrimaryCardID,SecondCardID)");
strSql.Append(" values (");
strSql.Append("@UserID,@UserName,@Photograph,@UserGroupID1,@UserGroupID2,@UserGroupID3,@UserGroupID4,@FingerPosition0,@FingerPrint0,@FingerPosition1,@FingerPrint1,@SercurityAccessLevel,@PrimaryCardID,@SecondCardID)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@UserID", DbType.Int32,4),
new SQLiteParameter("@UserName", DbType.String),
new SQLiteParameter("@Photograph", DbType.Binary),
new SQLiteParameter("@UserGroupID1", DbType.Int32,4),
new SQLiteParameter("@UserGroupID2", DbType.Int32,4),
new SQLiteParameter("@UserGroupID3", DbType.Int32,4),
new SQLiteParameter("@UserGroupID4", DbType.Int32,4),
new SQLiteParameter("@FingerPosition0", DbType.Int32,4),
new SQLiteParameter("@FingerPrint0", DbType.Binary),
new SQLiteParameter("@FingerPosition1", DbType.Int32,4),
new SQLiteParameter("@FingerPrint1", DbType.Binary),
new SQLiteParameter("@SercurityAccessLevel", DbType.Int32,4),
new SQLiteParameter("@PrimaryCardID", DbType.String),
new SQLiteParameter("@SecondCardID", DbType.String)};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Photograph;
parameters[3].Value = model.UserGroupID1;
parameters[4].Value = model.UserGroupID2;
parameters[5].Value = model.UserGroupID3;
parameters[6].Value = model.UserGroupID4;
parameters[7].Value = model.FingerPosition0;
parameters[8].Value = model.FingerPrint0;
parameters[9].Value = model.FingerPosition1;
parameters[10].Value = model.FingerPrint1;
parameters[11].Value = model.SercurityAccessLevel;
parameters[12].Value = model.PrimaryCardID;
parameters[13].Value = model.SecondCardID;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.TimeZone model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TimeZone(");
strSql.Append("TimeZoneID,STime1,ETime1,STime2,ETime2,STime3,ETime3,STime4,ETime4,STime5,ETime5,STime6,ETime6)");
strSql.Append(" values (");
strSql.Append("@TimeZoneID,@STime1,@ETime1,@STime2,@ETime2,@STime3,@ETime3,@STime4,@ETime4,@STime5,@ETime5,@STime6,@ETime6)");
SqlParameter[] parameters = {
new SqlParameter("@TimeZoneID", SqlDbType.Int,4),
new SqlParameter("@STime1", SqlDbType.NVarChar,8),
new SqlParameter("@ETime1", SqlDbType.NVarChar,8),
new SqlParameter("@STime2", SqlDbType.NVarChar,8),
new SqlParameter("@ETime2", SqlDbType.NVarChar,8),
new SqlParameter("@STime3", SqlDbType.NVarChar,8),
new SqlParameter("@ETime3", SqlDbType.NVarChar,8),
new SqlParameter("@STime4", SqlDbType.NVarChar,8),
new SqlParameter("@ETime4", SqlDbType.NVarChar,8),
new SqlParameter("@STime5", SqlDbType.NVarChar,8),
new SqlParameter("@ETime5", SqlDbType.NVarChar,8),
new SqlParameter("@STime6", SqlDbType.NVarChar,8),
new SqlParameter("@ETime6", SqlDbType.NVarChar,8)};
parameters[0].Value = model.TimeZoneID;
parameters[1].Value = model.STime1;
parameters[2].Value = model.ETime1;
parameters[3].Value = model.STime2;
parameters[4].Value = model.ETime2;
parameters[5].Value = model.STime3;
parameters[6].Value = model.ETime3;
parameters[7].Value = model.STime4;
parameters[8].Value = model.ETime4;
parameters[9].Value = model.STime5;
parameters[10].Value = model.ETime5;
parameters[11].Value = model.STime6;
parameters[12].Value = model.ETime6;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.InteractRelation.TimeICP model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TimeICP(");
strSql.Append("TimeICPID,TimeICPName,TimeICPEnable,TimeICPLoop,MonEnable,TueEnable,WedEnable,ThuEnable,FriEnable,SatEnable,SunEnable,TimePoint,ICPID)");
strSql.Append(" values (");
strSql.Append("@TimeICPID,@TimeICPName,@TimeICPEnable,@TimeICPLoop,@MonEnable,@TueEnable,@WedEnable,@ThuEnable,@FriEnable,@SatEnable,@SunEnable,@TimePoint,@ICPID)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@TimeICPID", DbType.Int32,4),
new SQLiteParameter("@TimeICPName", DbType.String),
new SQLiteParameter("@TimeICPEnable", DbType.Boolean,1),
new SQLiteParameter("@TimeICPLoop", DbType.Boolean,1),
new SQLiteParameter("@MonEnable", DbType.Boolean,1),
new SQLiteParameter("@TueEnable", DbType.Boolean,1),
new SQLiteParameter("@WedEnable", DbType.Boolean,1),
new SQLiteParameter("@ThuEnable", DbType.Boolean,1),
new SQLiteParameter("@FriEnable", DbType.Boolean,1),
new SQLiteParameter("@SatEnable", DbType.Boolean,1),
new SQLiteParameter("@SunEnable", DbType.Boolean,1),
new SQLiteParameter("@TimePoint", DbType.String),
new SQLiteParameter("@ICPID", DbType.Int32,4)};
parameters[0].Value = model.TimeICPID;
parameters[1].Value = model.TimeICPName;
parameters[2].Value = model.TimeICPEnable;
parameters[3].Value = model.TimeICPLoop;
parameters[4].Value = model.MonEnable;
parameters[5].Value = model.TueEnable;
parameters[6].Value = model.WedEnable;
parameters[7].Value = model.ThuEnable;
parameters[8].Value = model.FriEnable;
parameters[9].Value = model.SatEnable;
parameters[10].Value = model.SunEnable;
parameters[11].Value = model.TimePoint;
parameters[12].Value = model.ICPID;
int rows=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
