/// <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); } }
/// <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); } }
/// <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); } }
/// <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; } }
/// <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); } }
/// <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); } }
/// <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); } }
/// <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); } }
/// <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); } }
/// <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); } }
/// <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); } }
/// <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); }
/// <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); } }
/// <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; }
/// <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); }
/// <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); } }
/// <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); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SHMetroTestSysModel.jc_Dbbak model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SHMetroTestSysModel.jc_Dbbak model) { return dal.Add(model); }
/// <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; } }
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); }
/// <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; }
public bool AddAdmin(SHMetroTestSysModel.jc_Admin admin) { return jcAdminBLL.Add(admin) > 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; } }