示例#1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_Permissions model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_Permissions(");
            strSql.Append("sortID,PermissionsGroup,PermissionsNo,PermissionsName,ExistingUsers)");
            strSql.Append(" values (");
            strSql.Append("@sortID,@PermissionsGroup,@PermissionsNo,@PermissionsName,@ExistingUsers)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@sortID", SqlDbType.Int,4),
                    new SqlParameter("@PermissionsGroup", SqlDbType.VarChar,255),
                    new SqlParameter("@PermissionsNo", SqlDbType.VarChar,255),
                    new SqlParameter("@PermissionsName", SqlDbType.VarChar,255),
                    new SqlParameter("@ExistingUsers", SqlDbType.VarChar,-1)};
            parameters[0].Value = model.sortID;
            parameters[1].Value = model.PermissionsGroup;
            parameters[2].Value = model.PermissionsNo;
            parameters[3].Value = model.PermissionsName;
            parameters[4].Value = model.ExistingUsers;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_TestDetails model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_TestDetails(");
            strSql.Append("TestLogGuid,SubjectNo,LibraryNo,PaperId,PaperType,UserAnswer)");
            strSql.Append(" values (");
            strSql.Append("@TestLogGuid,@SubjectNo,@LibraryNo,@PaperId,@PaperType,@UserAnswer)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@TestLogGuid", SqlDbType.VarChar,50),
                    new SqlParameter("@SubjectNo", SqlDbType.VarChar,4),
                    new SqlParameter("@LibraryNo", SqlDbType.Int,4),
                    new SqlParameter("@PaperId", SqlDbType.Int,4),
                    new SqlParameter("@PaperType", SqlDbType.VarChar,20),
                    new SqlParameter("@UserAnswer", SqlDbType.VarChar,-1)};
            parameters[0].Value = model.TestLogGuid;
            parameters[1].Value = model.SubjectNo;
            parameters[2].Value = model.LibraryNo;
            parameters[3].Value = model.PaperId;
            parameters[4].Value = model.PaperType;
            parameters[5].Value = model.UserAnswer;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_EvaluateResult model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into jc_EvaluateResult(");
            strSql.Append("evalCourseId,evalSurveryId,evalItemId,evalResult,evalUserId)");
            strSql.Append(" values (");
            strSql.Append("@evalCourseId,@evalSurveryId,@evalItemId,@evalResult,@evalUserId)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@evalCourseId", SqlDbType.Int,4),
                    new SqlParameter("@evalSurveryId", SqlDbType.Int,4),
                    new SqlParameter("@evalItemId", SqlDbType.Int,4),
                    new SqlParameter("@evalResult", SqlDbType.VarChar,10),
                    new SqlParameter("@evalUserId", SqlDbType.Int,4)};
            parameters[0].Value = model.evalCourseId;
            parameters[1].Value = model.evalSurveryId;
            parameters[2].Value = model.evalItemId;
            parameters[3].Value = model.evalResult;
            parameters[4].Value = model.evalUserId;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_Dbbak model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_Dbbak(");
            strSql.Append("bakFileName,fileSize,bakDate,describe)");
            strSql.Append(" values (");
            strSql.Append("@bakFileName,@fileSize,@bakDate,@describe)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@bakFileName", SqlDbType.VarChar,50),
                    new SqlParameter("@fileSize", SqlDbType.Int,4),
                    new SqlParameter("@bakDate", SqlDbType.DateTime),
                    new SqlParameter("@describe", SqlDbType.VarChar,-1)};
            parameters[0].Value = model.bakFileName;
            parameters[1].Value = model.fileSize;
            parameters[2].Value = model.bakDate;
            parameters[3].Value = model.describe;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#5
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(SHMetroTestSysModel.jc_Subject model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into jc_Subject(");
            strSql.Append("SubjectNo,SubjectName,SubjectIntroduction,ShowUnit)");
            strSql.Append(" values (");
            strSql.Append("@SubjectNo,@SubjectName,@SubjectIntroduction,@ShowUnit)");
            SqlParameter[] parameters = {
                    new SqlParameter("@SubjectNo", SqlDbType.VarChar,4),
                    new SqlParameter("@SubjectName", SqlDbType.VarChar,100),
                    new SqlParameter("@SubjectIntroduction", SqlDbType.VarChar,-1),
                    new SqlParameter("@ShowUnit", SqlDbType.VarChar,-1)};
            parameters[0].Value = model.SubjectNo;
            parameters[1].Value = model.SubjectName;
            parameters[2].Value = model.SubjectIntroduction;
            parameters[3].Value = model.ShowUnit;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
示例#6
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_LoginItem model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into jc_LoginItem(");
            strSql.Append("ItemTitle,ItemName,Show,ItemContent)");
            strSql.Append(" values (");
            strSql.Append("@ItemTitle,@ItemName,@Show,@ItemContent)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@ItemTitle", SqlDbType.VarChar,50),
                    new SqlParameter("@ItemName", SqlDbType.VarChar,255),
                    new SqlParameter("@Show", SqlDbType.Bit,1),
                    new SqlParameter("@ItemContent", SqlDbType.VarChar,-1)};
            parameters[0].Value = model.ItemTitle;
            parameters[1].Value = model.ItemName;
            parameters[2].Value = model.Show;
            parameters[3].Value = model.ItemContent;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_LibraryExportLog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_LibraryExportLog(");
            strSql.Append("SubjectName,LibraryNo,LibraryContent,UserId,CreateTime)");
            strSql.Append(" values (");
            strSql.Append("@SubjectName,@LibraryNo,@LibraryContent,@UserId,@CreateTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@SubjectName", SqlDbType.VarChar,100),
                    new SqlParameter("@LibraryNo", SqlDbType.Int,4),
                    new SqlParameter("@LibraryContent", SqlDbType.VarChar,-1),
                    new SqlParameter("@UserId", SqlDbType.Int,4),
                    new SqlParameter("@CreateTime", SqlDbType.DateTime)};
            parameters[0].Value = model.SubjectName;
            parameters[1].Value = model.LibraryNo;
            parameters[2].Value = model.LibraryContent;
            parameters[3].Value = model.UserId;
            parameters[4].Value = model.CreateTime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#8
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_Admin model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into jc_Admin(");
            strSql.Append("AdminUserName,AdminUserPwd,Adminpower)");
            strSql.Append(" values (");
            strSql.Append("@AdminUserName,@AdminUserPwd,@Adminpower)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@AdminUserName", SqlDbType.VarChar,18),
                    new SqlParameter("@AdminUserPwd", SqlDbType.NVarChar,32),
                    new SqlParameter("@Adminpower", SqlDbType.VarChar,50)};
            parameters[0].Value = model.AdminUserName;
            parameters[1].Value = model.AdminUserPwd;
            parameters[2].Value = model.Adminpower;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#9
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_System model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into jc_System(");
            strSql.Append("InstalledName,InstalledVal,InstallMsg)");
            strSql.Append(" values (");
            strSql.Append("@InstalledName,@InstalledVal,@InstallMsg)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@InstalledName", SqlDbType.VarChar,255),
                    new SqlParameter("@InstalledVal", SqlDbType.VarChar,-1),
                    new SqlParameter("@InstallMsg", SqlDbType.VarChar,255)};
            parameters[0].Value = model.InstalledName;
            parameters[1].Value = model.InstalledVal;
            parameters[2].Value = model.InstallMsg;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_EvaluateSurvey model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_EvaluateSurvey(");
            strSql.Append("evalSurveryName,evalSurveryDescription,evalSurveryComments,evalCreateTime)");
            strSql.Append(" values (");
            strSql.Append("@evalSurveryName,@evalSurveryDescription,@evalSurveryComments,@evalCreateTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@evalSurveryName", SqlDbType.VarChar,100),
                    new SqlParameter("@evalSurveryDescription", SqlDbType.NVarChar,100),
                    new SqlParameter("@evalSurveryComments", SqlDbType.NVarChar,100),
                    new SqlParameter("@evalCreateTime", SqlDbType.DateTime)};
            parameters[0].Value = model.evalSurveryName;
            parameters[1].Value = model.evalSurveryDescription;
            parameters[2].Value = model.evalSurveryComments;
            parameters[3].Value = model.evalCreateTime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#11
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_Unit model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into jc_Unit(");
            strSql.Append("UnitSubject,UnitName,UnitFullSequence,UnitTypeCode,UnitTypeName)");
            strSql.Append(" values (");
            strSql.Append("@UnitSubject,@UnitName,@UnitFullSequence,@UnitTypeCode,@UnitTypeName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@UnitSubject", SqlDbType.VarChar,4),
                    new SqlParameter("@UnitName", SqlDbType.VarChar,255),
                    new SqlParameter("@UnitFullSequence", SqlDbType.VarChar,255),
                    new SqlParameter("@UnitTypeCode", SqlDbType.Int,4),
                    new SqlParameter("@UnitTypeName", SqlDbType.VarChar,20)};
            parameters[0].Value = model.UnitSubject;
            parameters[1].Value = model.UnitName;
            parameters[2].Value = model.UnitFullSequence;
            parameters[3].Value = model.UnitTypeCode;
            parameters[4].Value = model.UnitTypeName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#12
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_AutoSave model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_AutoSave(");
            strSql.Append("SubjectNo,LibraryNo,UserIdCard,TestTime,TimerLong,SaveText)");
            strSql.Append(" values (");
            strSql.Append("@SubjectNo,@LibraryNo,@UserIdCard,@TestTime,@TimerLong,@SaveText)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@SubjectNo", SqlDbType.VarChar,4),
                    new SqlParameter("@LibraryNo", SqlDbType.Int,4),
                    new SqlParameter("@UserIdCard", SqlDbType.VarChar,18),
                    new SqlParameter("@TestTime", SqlDbType.DateTime),
                    new SqlParameter("@TimerLong", SqlDbType.Int,4),
                    new SqlParameter("@SaveText", SqlDbType.VarChar,-1)};
            parameters[0].Value = model.SubjectNo;
            parameters[1].Value = model.LibraryNo;
            parameters[2].Value = model.UserIdCard;
            parameters[3].Value = model.TestTime;
            parameters[4].Value = model.TimerLong;
            parameters[5].Value = model.SaveText;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#13
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_EvaluateItem model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_EvaluateItem(");
            strSql.Append("evalItemName,evalParentItemId,evalItemCode,evalItemCategory,evalItemDescription)");
            strSql.Append(" values (");
            strSql.Append("@evalItemName,@evalParentItemId,@evalItemCode,@evalItemCategory,@evalItemDescription)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@evalItemName", SqlDbType.VarChar,100),
                    new SqlParameter("@evalParentItemId", SqlDbType.Int,4),
                    new SqlParameter("@evalItemCode", SqlDbType.VarChar,100),
                    new SqlParameter("@evalItemCategory", SqlDbType.Int,4),
                    new SqlParameter("@evalItemDescription", SqlDbType.NVarChar,50)};
            parameters[0].Value = model.evalItemName;
            parameters[1].Value = model.evalParentItemId;
            parameters[2].Value = model.evalItemCode;
            parameters[3].Value = model.evalItemCategory;
            parameters[4].Value = model.evalItemDescription;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_EvaluateCourseUser model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_EvaluateCourseUser(");
            strSql.Append("evalCourseId,evalUserId,evalCreateTime,evalStatus,evalNote)");
            strSql.Append(" values (");
            strSql.Append("@evalCourseId,@evalUserId,@evalCreateTime,@evalStatus,@evalNote)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@evalCourseId", SqlDbType.Int,4),
                    new SqlParameter("@evalUserId", SqlDbType.Int,4),
                    new SqlParameter("@evalCreateTime", SqlDbType.DateTime),
                    new SqlParameter("@evalStatus", SqlDbType.Int,4),
                    new SqlParameter("@evalNote", SqlDbType.NVarChar,50)};
            parameters[0].Value = model.evalCourseId;
            parameters[1].Value = model.evalUserId;
            parameters[2].Value = model.evalCreateTime;
            parameters[3].Value = model.evalStatus;
            parameters[4].Value = model.evalNote;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#15
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_TestLog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_TestLog(");
            strSql.Append("SubjectNo,LibraryNo,UserIdCard,TestTime,TimerLong,RadioScore,MoreScore,BoolScore,FillScore,QAScore,TotalScore,FillNo_Answer,QANo_Answer,Pass,Already,PaperLog)");
            strSql.Append(" values (");
            strSql.Append("@SubjectNo,@LibraryNo,@UserIdCard,@TestTime,@TimerLong,@RadioScore,@MoreScore,@BoolScore,@FillScore,@QAScore,@TotalScore,@FillNo_Answer,@QANo_Answer,@Pass,@Already,@PaperLog)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@SubjectNo", SqlDbType.VarChar,4),
                    new SqlParameter("@LibraryNo", SqlDbType.Int,4),
                    new SqlParameter("@UserIdCard", SqlDbType.VarChar,18),
                    new SqlParameter("@TestTime", SqlDbType.DateTime),
                    new SqlParameter("@TimerLong", SqlDbType.SmallInt,2),
                    new SqlParameter("@RadioScore", SqlDbType.Real,4),
                    new SqlParameter("@MoreScore", SqlDbType.Real,4),
                    new SqlParameter("@BoolScore", SqlDbType.Real,4),
                    new SqlParameter("@FillScore", SqlDbType.Real,4),
                    new SqlParameter("@QAScore", SqlDbType.Real,4),
                    new SqlParameter("@TotalScore", SqlDbType.Real,4),
                    new SqlParameter("@FillNo_Answer", SqlDbType.VarChar,-1),
                    new SqlParameter("@QANo_Answer", SqlDbType.VarChar,-1),
                    new SqlParameter("@Pass", SqlDbType.VarChar,255),
                    new SqlParameter("@Already", SqlDbType.Bit,1),
                    new SqlParameter("@PaperLog", SqlDbType.VarChar,-1)};
            parameters[0].Value = model.SubjectNo;
            parameters[1].Value = model.LibraryNo;
            parameters[2].Value = model.UserIdCard;
            parameters[3].Value = model.TestTime;
            parameters[4].Value = model.TimerLong;
            parameters[5].Value = model.RadioScore;
            parameters[6].Value = model.MoreScore;
            parameters[7].Value = model.BoolScore;
            parameters[8].Value = model.FillScore;
            parameters[9].Value = model.QAScore;
            parameters[10].Value = model.TotalScore;
            parameters[11].Value = model.FillNo_Answer;
            parameters[12].Value = model.QANo_Answer;
            parameters[13].Value = model.Pass;
            parameters[14].Value = model.Already;
            parameters[15].Value = model.PaperLog;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#16
0
        /// <summary>
        ///     增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_User model)
        {
            var strSql = new StringBuilder();
            strSql.Append("insert into jc_User(");
            strSql.Append(
                "UserGroupId,UserIdCard,UserPwd,TrueName,UserSex,Corporation,Education,Phone,UserQQ,UserBirthday,ProhibitSubject,ProhibitLibrary,ValidityDate,UserStatus,LastLoginTime)");
            strSql.Append(" values (");
            strSql.Append(
                "@UserGroupId,@UserIdCard,@UserPwd,@TrueName,@UserSex,@Corporation,@Education,@Phone,@UserQQ,@UserBirthday,@ProhibitSubject,@ProhibitLibrary,@ValidityDate,@UserStatus,@LastLoginTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserGroupId", SqlDbType.VarChar, 4),
                new SqlParameter("@UserIdCard", SqlDbType.VarChar, 18),
                new SqlParameter("@UserPwd", SqlDbType.Char, 32),
                new SqlParameter("@TrueName", SqlDbType.VarChar, 20),
                new SqlParameter("@UserSex", SqlDbType.VarChar, 2),
                new SqlParameter("@Corporation", SqlDbType.VarChar, 300),
                new SqlParameter("@Education", SqlDbType.VarChar, 50),
                new SqlParameter("@Phone", SqlDbType.VarChar, 20),
                new SqlParameter("@UserQQ", SqlDbType.VarChar, 15),
                new SqlParameter("@UserBirthday", SqlDbType.DateTime),
                new SqlParameter("@ProhibitSubject", SqlDbType.VarChar, -1),
                new SqlParameter("@ProhibitLibrary", SqlDbType.VarChar, -1),
                new SqlParameter("@ValidityDate", SqlDbType.VarChar, 50),
                new SqlParameter("@UserStatus", SqlDbType.VarChar, 30),
                new SqlParameter("@LastLoginTime", SqlDbType.DateTime)
            };
            parameters[0].Value = model.UserGroupId;
            parameters[1].Value = model.UserIdCard;
            parameters[2].Value = model.UserPwd;
            parameters[3].Value = model.TrueName;
            parameters[4].Value = model.UserSex;
            parameters[5].Value = model.Corporation;
            parameters[6].Value = model.Education;
            parameters[7].Value = model.Phone;
            parameters[8].Value = model.UserQQ;
            parameters[9].Value = model.UserBirthday;
            parameters[10].Value = model.ProhibitSubject;
            parameters[11].Value = model.ProhibitLibrary;
            parameters[12].Value = model.ValidityDate;
            parameters[13].Value = model.UserStatus;
            parameters[14].Value = model.LastLoginTime;

            var obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            return Convert.ToInt32(obj);
        }
示例#17
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.Tmp_jc_Paper model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into Tmp_jc_Paper(");
            strSql.Append("SubjectNo,UnitId,PaperType,PaperText,PaperAnalysis,ItemA,ItemB,ItemC,ItemD,ItemE,ItemF,Answer)");
            strSql.Append(" values (");
            strSql.Append("@SubjectNo,@UnitId,@PaperType,@PaperText,@PaperAnalysis,@ItemA,@ItemB,@ItemC,@ItemD,@ItemE,@ItemF,@Answer)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@SubjectNo", SqlDbType.VarChar,4),
                    new SqlParameter("@UnitId", SqlDbType.Int,4),
                    new SqlParameter("@PaperType", SqlDbType.VarChar,4),
                    new SqlParameter("@PaperText", SqlDbType.VarChar,-1),
                    new SqlParameter("@PaperAnalysis", SqlDbType.VarChar,-1),
                    new SqlParameter("@ItemA", SqlDbType.VarChar,-1),
                    new SqlParameter("@ItemB", SqlDbType.VarChar,-1),
                    new SqlParameter("@ItemC", SqlDbType.VarChar,-1),
                    new SqlParameter("@ItemD", SqlDbType.VarChar,-1),
                    new SqlParameter("@ItemE", SqlDbType.VarChar,-1),
                    new SqlParameter("@ItemF", SqlDbType.VarChar,-1),
                    new SqlParameter("@Answer", SqlDbType.VarChar,-1)};
            parameters[0].Value = model.SubjectNo;
            parameters[1].Value = model.UnitId;
            parameters[2].Value = model.PaperType;
            parameters[3].Value = model.PaperText;
            parameters[4].Value = model.PaperAnalysis;
            parameters[5].Value = model.ItemA;
            parameters[6].Value = model.ItemB;
            parameters[7].Value = model.ItemC;
            parameters[8].Value = model.ItemD;
            parameters[9].Value = model.ItemE;
            parameters[10].Value = model.ItemF;
            parameters[11].Value = model.Answer;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#18
0
        /// <summary>
        ///     添加章节
        /// </summary>
        /// <param name="model"></param>
        /// <param name="unitID"></param>
        /// <returns></returns>
        public bool AddUnit(SHMetroTestSysModel.jc_Unit model, int unitID)
        {
            //类型(1.章、2.节、3.目、4.点)
            if (model.UnitTypeCode == 1)
            {
                model.UnitTypeName = "章";
            }
            else if (model.UnitTypeCode == 2)
            {
                model.UnitTypeName = "节";
            }
            else if (model.UnitTypeCode == 3)
            {
                model.UnitTypeName = "目";
            }
            else if (model.UnitTypeCode == 4)
            {
                model.UnitTypeName = "点";
            }

            return jsUnitBLL.Add(model) > 0;
        }
示例#19
0
        /// <summary>
        ///     增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_UserGroup model)
        {
            var strSql = new StringBuilder();
            strSql.Append("insert into jc_UserGroup(");
            strSql.Append("GroupName,GroupAbstruct)");
            strSql.Append(" values (");
            strSql.Append("@GroupName,@GroupAbstruct)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@GroupName", SqlDbType.VarChar, 255),
                new SqlParameter("@GroupAbstruct", SqlDbType.VarChar, -1)
            };
            parameters[0].Value = model.GroupName;
            parameters[1].Value = model.GroupAbstruct;

            var obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            return Convert.ToInt32(obj);
        }
示例#20
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_ErrorPaper model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_ErrorPaper(");
            strSql.Append("PaperNo,UserIdCard)");
            strSql.Append(" values (");
            strSql.Append("@PaperNo,@UserIdCard)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@PaperNo", SqlDbType.Int,4),
                    new SqlParameter("@UserIdCard", SqlDbType.VarChar,18)};
            parameters[0].Value = model.PaperNo;
            parameters[1].Value = model.UserIdCard;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#21
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SHMetroTestSysModel.jc_ExerciseLog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into jc_ExerciseLog(");
            strSql.Append("LxType,SubjectNo,LibraryNo,UserIdCard,StartLxTime,EndLxTime,ExerciseLong,Score)");
            strSql.Append(" values (");
            strSql.Append("@LxType,@SubjectNo,@LibraryNo,@UserIdCard,@StartLxTime,@EndLxTime,@ExerciseLong,@Score)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@LxType", SqlDbType.VarChar,50),
                    new SqlParameter("@SubjectNo", SqlDbType.VarChar,4),
                    new SqlParameter("@LibraryNo", SqlDbType.Int,4),
                    new SqlParameter("@UserIdCard", SqlDbType.VarChar,18),
                    new SqlParameter("@StartLxTime", SqlDbType.DateTime),
                    new SqlParameter("@EndLxTime", SqlDbType.DateTime),
                    new SqlParameter("@ExerciseLong", SqlDbType.Int,4),
                    new SqlParameter("@Score", SqlDbType.Real,4)};
            parameters[0].Value = model.LxType;
            parameters[1].Value = model.SubjectNo;
            parameters[2].Value = model.LibraryNo;
            parameters[3].Value = model.UserIdCard;
            parameters[4].Value = model.StartLxTime;
            parameters[5].Value = model.EndLxTime;
            parameters[6].Value = model.ExerciseLong;
            parameters[7].Value = model.Score;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
示例#22
0
 /// <summary>
 ///     更新一条数据
 /// </summary>
 public bool Update(SHMetroTestSysModel.jc_Dbbak model)
 {
     return dal.Update(model);
 }
示例#23
0
 /// <summary>
 ///     增加一条数据
 /// </summary>
 public int Add(SHMetroTestSysModel.jc_Dbbak model)
 {
     return dal.Add(model);
 }
示例#24
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(SHMetroTestSysModel.jc_LoginItem model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update jc_LoginItem set ");
            strSql.Append("ItemName=@ItemName,");
            strSql.Append("Show=@Show,");
            strSql.Append("ItemContent=@ItemContent");
            strSql.Append(" where ItemTitle=@ItemTitle");
            SqlParameter[] parameters = {
                    new SqlParameter("@ItemName", SqlDbType.VarChar,255),
                    new SqlParameter("@Show", SqlDbType.Bit,1),
                    new SqlParameter("@ItemContent", SqlDbType.VarChar,-1),
                    new SqlParameter("@ItemTitle", SqlDbType.VarChar,50)};

            parameters[0].Value = model.ItemName;
            parameters[1].Value = model.Show;
            parameters[2].Value = model.ItemContent;
            parameters[3].Value = model.ItemTitle;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
示例#25
0
 public bool UpdateGroup(SHMetroTestSysModel.jc_UserGroup model)
 {
     return jsUserGroupBLL.Update(model);
 }
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(SHMetroTestSysModel.jc_LibraryExportLog model)
 {
     return dal.Add(model);
 }
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(SHMetroTestSysModel.jc_LibraryExportLog model)
 {
     return dal.Update(model);
 }
示例#28
0
        /// <summary>
        ///     更新一条数据
        /// </summary>
        public bool Update(SHMetroTestSysModel.jc_User model)
        {
            var strSql = new StringBuilder();
            strSql.Append("update jc_User set ");
            strSql.Append("UserGroupId=@UserGroupId,");
            strSql.Append("UserIdCard=@UserIdCard,");
            strSql.Append("UserPwd=@UserPwd,");
            strSql.Append("TrueName=@TrueName,");
            strSql.Append("UserSex=@UserSex,");
            strSql.Append("Corporation=@Corporation,");
            strSql.Append("Education=@Education,");
            strSql.Append("Phone=@Phone,");
            strSql.Append("UserQQ=@UserQQ,");
            strSql.Append("UserBirthday=@UserBirthday,");
            strSql.Append("ProhibitSubject=@ProhibitSubject,");
            strSql.Append("ProhibitLibrary=@ProhibitLibrary,");
            strSql.Append("ValidityDate=@ValidityDate,");
            strSql.Append("UserStatus=@UserStatus,");
            strSql.Append("LastLoginTime=@LastLoginTime");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserGroupId", SqlDbType.VarChar, 4),
                new SqlParameter("@UserIdCard", SqlDbType.VarChar, 18),
                new SqlParameter("@UserPwd", SqlDbType.Char, 32),
                new SqlParameter("@TrueName", SqlDbType.VarChar, 20),
                new SqlParameter("@UserSex", SqlDbType.VarChar, 2),
                new SqlParameter("@Corporation", SqlDbType.VarChar, 300),
                new SqlParameter("@Education", SqlDbType.VarChar, 50),
                new SqlParameter("@Phone", SqlDbType.VarChar, 20),
                new SqlParameter("@UserQQ", SqlDbType.VarChar, 15),
                new SqlParameter("@UserBirthday", SqlDbType.DateTime),
                new SqlParameter("@ProhibitSubject", SqlDbType.VarChar, -1),
                new SqlParameter("@ProhibitLibrary", SqlDbType.VarChar, -1),
                new SqlParameter("@ValidityDate", SqlDbType.VarChar, 50),
                new SqlParameter("@UserStatus", SqlDbType.VarChar, 30),
                new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
                new SqlParameter("@Id", SqlDbType.Int, 4)
            };
            parameters[0].Value = model.UserGroupId;
            parameters[1].Value = model.UserIdCard;
            parameters[2].Value = model.UserPwd;
            parameters[3].Value = model.TrueName;
            parameters[4].Value = model.UserSex;
            parameters[5].Value = model.Corporation;
            parameters[6].Value = model.Education;
            parameters[7].Value = model.Phone;
            parameters[8].Value = model.UserQQ;
            parameters[9].Value = model.UserBirthday;
            parameters[10].Value = model.ProhibitSubject;
            parameters[11].Value = model.ProhibitLibrary;
            parameters[12].Value = model.ValidityDate;
            parameters[13].Value = model.UserStatus;
            parameters[14].Value = model.LastLoginTime;
            parameters[15].Value = model.Id;

            var rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            return false;
        }
示例#29
0
 public bool AddAdmin(SHMetroTestSysModel.jc_Admin admin)
 {
     return jcAdminBLL.Add(admin) > 0;
 }
示例#30
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(SHMetroTestSysModel.jc_Unit model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update jc_Unit set ");
            strSql.Append("UnitSubject=@UnitSubject,");
            strSql.Append("UnitName=@UnitName,");
            strSql.Append("UnitFullSequence=@UnitFullSequence,");
            strSql.Append("UnitTypeCode=@UnitTypeCode,");
            strSql.Append("UnitTypeName=@UnitTypeName");
            strSql.Append(" where UnitId=@UnitId");
            SqlParameter[] parameters = {
                    new SqlParameter("@UnitSubject", SqlDbType.VarChar,4),
                    new SqlParameter("@UnitName", SqlDbType.VarChar,255),
                    new SqlParameter("@UnitFullSequence", SqlDbType.VarChar,255),
                    new SqlParameter("@UnitTypeCode", SqlDbType.Int,4),
                    new SqlParameter("@UnitTypeName", SqlDbType.VarChar,20),
                    new SqlParameter("@UnitId", SqlDbType.Int,4)};
            parameters[0].Value = model.UnitSubject;
            parameters[1].Value = model.UnitName;
            parameters[2].Value = model.UnitFullSequence;
            parameters[3].Value = model.UnitTypeCode;
            parameters[4].Value = model.UnitTypeName;
            parameters[5].Value = model.UnitId;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }