• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

C# KryptonAccessController类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中KryptonAccessController的典型用法代码示例。如果您正苦于以下问题:C# KryptonAccessController类的具体用法?C# KryptonAccessController怎么用?C# KryptonAccessController使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



KryptonAccessController类属于命名空间,在下文中一共展示了KryptonAccessController类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:36,代码来源:EventInfo.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:34,代码来源:StandardOperateProcedure.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:30,代码来源:ElectronicMap.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:34,代码来源:HolidayICP.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:34,代码来源:MediaVideo.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:38,代码来源:InterControlProgram.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:36,代码来源:HolidayICP.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:36,代码来源:EventICP.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:34,代码来源:InterLock.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:38,代码来源:CardInfo.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:30,代码来源:MenuIconInfo.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:30,代码来源:Manager.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:32,代码来源:EventPictureInfo.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:KryptonAccessController,代码行数:34,代码来源:BlackListCardInfo.cs


示例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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:34,代码来源:ExpansionBoardInfo.cs


示例16: Add

        /// <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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:34,代码来源:CompanyInfo.cs


示例17: Add

        /// <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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:28,代码来源:MediaVideoGroup.cs


示例18: Add

        /// <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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:28,代码来源:ManagerRightList.cs


示例19: Add

        /// <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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:30,代码来源:Manager.cs


示例20: Add

        /// <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;
            }
        }
开发者ID:qq5013,项目名称:AccessControllerBS,代码行数:30,代码来源:InteractHoliday.cs



注:本文中的KryptonAccessController类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# KryptonRibbon类代码示例发布时间:2022-05-24
下一篇:
C# Ats.IBNet类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap