本文整理汇总了C#中KryptonAccessController类的典型用法代码示例。如果您正苦于以下问题:C# KryptonAccessController类的具体用法?C# KryptonAccessController怎么用?C# KryptonAccessController使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
KryptonAccessController类属于命名空间,在下文中一共展示了KryptonAccessController类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Add
/// <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;
}
}
示例2: Add
/// <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;
}
}
示例3: Add
/// <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;
}
}
示例4: Add
/// <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;
}
}
示例5: Add
/// <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;
}
}
示例6: Add
/// <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;
}
}
示例7: Add
/// <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;
}
}
示例8: Add
/// <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;
}
}
示例9: Add
/// <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;
}
}
示例10: Add
/// <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;
}
}
示例11: Add
/// <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;
}
}
示例12: Add
/// <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;
}
}
示例13: Add
/// <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;
}
}
示例14: Add
/// <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;
}
}
示例15: Add
/// <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;
}
}