/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Course model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Course("); strSql.Append("Name,Credit,Introdution)"); strSql.Append(" values ("); strSql.Append("@Name,@Credit,@Introdution)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@Credit", SqlDbType.Int,4), new SqlParameter("@Introdution", SqlDbType.NVarChar,-1)}; parameters[0].Value = model.Name; parameters[1].Value = model.Credit; parameters[2].Value = model.Introdution; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.ItemList model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into ItemList("); strSql.Append("EvaluationId,ItemId,Evaluation,score)"); strSql.Append(" values ("); strSql.Append("@EvaluationId,@ItemId,@Evaluation,@score)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@EvaluationId", SqlDbType.Int,4), new SqlParameter("@ItemId", SqlDbType.Int,4), new SqlParameter("@Evaluation", SqlDbType.NVarChar,-1), new SqlParameter("@score", SqlDbType.Int,4)}; parameters[0].Value = model.EvaluationId; parameters[1].Value = model.ItemId; parameters[2].Value = model.Evaluation; parameters[3].Value = model.score; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Teach model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Teach("); strSql.Append("CourseId,TeacherId,AcademicYear,SchoolTerm)"); strSql.Append(" values ("); strSql.Append("@CourseId,@TeacherId,@AcademicYear,@SchoolTerm)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CourseId", SqlDbType.Int,4), new SqlParameter("@TeacherId", SqlDbType.Int,4), new SqlParameter("@AcademicYear", SqlDbType.Int,4), new SqlParameter("@SchoolTerm", SqlDbType.Int,4)}; parameters[0].Value = model.CourseId; parameters[1].Value = model.TeacherId; parameters[2].Value = model.AcademicYear; parameters[3].Value = model.SchoolTerm; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
public void doEvents() { for (int i = 0; i < 10; ++i) { Eva temp = new Eva(); temp.msg = eva_.msg + " #" + (i + 1).ToString(); Thread.Sleep(200); if (eventDel != null) { eventDel.Invoke(this, temp); } } }
public async Task Version() { try { await Context.Message.DeleteAsync(); } catch { /*ignored*/ } var arch = System.Runtime.InteropServices.RuntimeInformation.OSArchitecture; var osDesc = System.Runtime.InteropServices.RuntimeInformation.OSDescription; var builder = new EmbedBuilder(); builder.WithTitle("Bot Informations"); builder.WithDescription($"{_client.CurrentUser.Mention} - {_client.CurrentUser.Username}#{_client.CurrentUser.Discriminator}"); EmbedFieldBuilder field = new EmbedFieldBuilder { IsInline = true, Name = "Bot : ", Value = Assembly.GetExecutingAssembly().GetName().Name }; builder.AddField(field); field = new EmbedFieldBuilder { IsInline = true, Name = "Version : ", Value = 'v' + Eva.GetVersion() }; builder.AddField(field); field = new EmbedFieldBuilder { IsInline = true, Name = "Running on : ", Value = $"{osDesc} ({arch})" }; builder.AddField(field); builder.WithThumbnailUrl(_client.CurrentUser.GetAvatarUrl()); builder.WithColor(Color.Blue); var embed = builder.Build(); await Context.Channel.SendMessageAsync("", false, embed); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.WebUser model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into WebUser("); strSql.Append("LoginId,PassWord,AuthorityId,Name,StudentId,Sex,CollegeId,ClassId,MajorId,IdCard,Address,Phone)"); strSql.Append(" values ("); strSql.Append("@LoginId,@PassWord,@AuthorityId,@Name,@StudentId,@Sex,@CollegeId,@ClassId,@MajorId,@IdCard,@Address,@Phone)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@LoginId", SqlDbType.NVarChar,50), new SqlParameter("@PassWord", SqlDbType.NVarChar,50), new SqlParameter("@AuthorityId", SqlDbType.Int,4), new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@StudentId", SqlDbType.Int,4), new SqlParameter("@Sex", SqlDbType.NVarChar,50), new SqlParameter("@CollegeId", SqlDbType.Int,4), new SqlParameter("@ClassId", SqlDbType.Int,4), new SqlParameter("@MajorId", SqlDbType.Int,4), new SqlParameter("@IdCard", SqlDbType.NVarChar,50), new SqlParameter("@Address", SqlDbType.NVarChar,-1), new SqlParameter("@Phone", SqlDbType.NVarChar,50)}; parameters[0].Value = model.LoginId; parameters[1].Value = model.PassWord; parameters[2].Value = model.AuthorityId; parameters[3].Value = model.Name; parameters[4].Value = model.StudentId; parameters[5].Value = model.Sex; parameters[6].Value = model.CollegeId; parameters[7].Value = model.ClassId; parameters[8].Value = model.MajorId; parameters[9].Value = model.IdCard; parameters[10].Value = model.Address; parameters[11].Value = model.Phone; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Mark model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Mark("); strSql.Append("CourseId,StudentId,EvalutionId,Score,BonusPoint,AcademicYear,SchoolTerm,CheckStep,Reason,Gpa)"); strSql.Append(" values ("); strSql.Append("@CourseId,@StudentId,@EvalutionId,@Score,@BonusPoint,@AcademicYear,@SchoolTerm,@CheckStep,@Reason,@Gpa)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CourseId", SqlDbType.Int,4), new SqlParameter("@StudentId", SqlDbType.Int,4), new SqlParameter("@EvalutionId", SqlDbType.Int,4), new SqlParameter("@Score", SqlDbType.Float,8), new SqlParameter("@BonusPoint", SqlDbType.Float,8), new SqlParameter("@AcademicYear", SqlDbType.Int,4), new SqlParameter("@SchoolTerm", SqlDbType.Int,4), new SqlParameter("@CheckStep", SqlDbType.Int,4), new SqlParameter("@Reason", SqlDbType.NVarChar,50), new SqlParameter("@Gpa", SqlDbType.Float,8)}; parameters[0].Value = model.CourseId; parameters[1].Value = model.StudentId; parameters[2].Value = model.EvalutionId; parameters[3].Value = model.Score; parameters[4].Value = model.BonusPoint; parameters[5].Value = model.AcademicYear; parameters[6].Value = model.SchoolTerm; parameters[7].Value = model.CheckStep; parameters[8].Value = model.Reason; parameters[9].Value = model.Gpa; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.College model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into College("); strSql.Append("Name)"); strSql.Append(" values ("); strSql.Append("@Name)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,50)}; parameters[0].Value = model.Name; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Awards model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Awards("); strSql.Append("Name,Grade,Score,StudentId,AcademicYear,SchoolTerm,IsCheck,Total)"); strSql.Append(" values ("); strSql.Append("@Name,@Grade,@Score,@StudentId,@AcademicYear,@SchoolTerm,@IsCheck,@Total)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@Grade", SqlDbType.NVarChar,50), new SqlParameter("@Score", SqlDbType.NVarChar,50), new SqlParameter("@StudentId", SqlDbType.Int,4), new SqlParameter("@AcademicYear", SqlDbType.Int,4), new SqlParameter("@SchoolTerm", SqlDbType.Int,4), new SqlParameter("@IsCheck", SqlDbType.NVarChar,50), new SqlParameter("@Total", SqlDbType.Int,4)}; parameters[0].Value = model.Name; parameters[1].Value = model.Grade; parameters[2].Value = model.Score; parameters[3].Value = model.StudentId; parameters[4].Value = model.AcademicYear; parameters[5].Value = model.SchoolTerm; parameters[6].Value = model.IsCheck; parameters[7].Value = model.Total; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Evaluation model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Evaluation("); strSql.Append("StudentId,AcademicYear,Ave,TeacherEvaluation,SelfEvaluation,TeacherId,SchoolTerm,Total)"); strSql.Append(" values ("); strSql.Append("@StudentId,@AcademicYear,@Ave,@TeacherEvaluation,@SelfEvaluation,@TeacherId,@SchoolTerm,@Total)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StudentId", SqlDbType.Int,4), new SqlParameter("@AcademicYear", SqlDbType.Int,4), new SqlParameter("@Ave", SqlDbType.Float,8), new SqlParameter("@TeacherEvaluation", SqlDbType.NVarChar,-1), new SqlParameter("@SelfEvaluation", SqlDbType.NVarChar,-1), new SqlParameter("@TeacherId", SqlDbType.Int,4), new SqlParameter("@SchoolTerm", SqlDbType.Int,4), new SqlParameter("@Total", SqlDbType.Float,8)}; parameters[0].Value = model.StudentId; parameters[1].Value = model.AcademicYear; parameters[2].Value = model.Ave; parameters[3].Value = model.TeacherEvaluation; parameters[4].Value = model.SelfEvaluation; parameters[5].Value = model.TeacherId; parameters[6].Value = model.SchoolTerm; parameters[7].Value = model.Total; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Teach model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Item model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Item set "); strSql.Append("Name=@Name,"); strSql.Append("Value=@Value"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@Value", SqlDbType.Float,8), new SqlParameter("@Id", SqlDbType.Int,4)}; parameters[0].Value = model.Name; parameters[1].Value = model.Value; parameters[2].Value = model.Id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.College model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.College model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Mark model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Awards model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Evaluation model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Authority model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Course model) { return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Item model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Item model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Awards model) { return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Teach model) { return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.WebUser model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Evaluation model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Course model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Course set "); strSql.Append("Name=@Name,"); strSql.Append("Credit=@Credit,"); strSql.Append("Introdution=@Introdution"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@Credit", SqlDbType.Int,4), new SqlParameter("@Introdution", SqlDbType.NVarChar,-1), new SqlParameter("@Id", SqlDbType.Int,4)}; parameters[0].Value = model.Name; parameters[1].Value = model.Credit; parameters[2].Value = model.Introdution; parameters[3].Value = model.Id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Evaluation model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Evaluation set "); strSql.Append("StudentId=@StudentId,"); strSql.Append("AcademicYear=@AcademicYear,"); strSql.Append("Ave=@Ave,"); strSql.Append("TeacherEvaluation=@TeacherEvaluation,"); strSql.Append("SelfEvaluation=@SelfEvaluation,"); strSql.Append("TeacherId=@TeacherId,"); strSql.Append("SchoolTerm=@SchoolTerm,"); strSql.Append("Total=@Total"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@StudentId", SqlDbType.Int,4), new SqlParameter("@AcademicYear", SqlDbType.Int,4), new SqlParameter("@Ave", SqlDbType.Float,8), new SqlParameter("@TeacherEvaluation", SqlDbType.NVarChar,-1), new SqlParameter("@SelfEvaluation", SqlDbType.NVarChar,-1), new SqlParameter("@TeacherId", SqlDbType.Int,4), new SqlParameter("@SchoolTerm", SqlDbType.Int,4), new SqlParameter("@Total", SqlDbType.Float,8), new SqlParameter("@Id", SqlDbType.Int,4)}; parameters[0].Value = model.StudentId; parameters[1].Value = model.AcademicYear; parameters[2].Value = model.Ave; parameters[3].Value = model.TeacherEvaluation; parameters[4].Value = model.SelfEvaluation; parameters[5].Value = model.TeacherId; parameters[6].Value = model.SchoolTerm; parameters[7].Value = model.Total; parameters[8].Value = model.Id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.WebUser model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update WebUser set "); strSql.Append("LoginId=@LoginId,"); strSql.Append("PassWord=@PassWord,"); strSql.Append("AuthorityId=@AuthorityId,"); strSql.Append("Name=@Name,"); strSql.Append("StudentId=@StudentId,"); strSql.Append("Sex=@Sex,"); strSql.Append("CollegeId=@CollegeId,"); strSql.Append("ClassId=@ClassId,"); strSql.Append("MajorId=@MajorId,"); strSql.Append("IdCard=@IdCard,"); strSql.Append("Address=@Address,"); strSql.Append("Phone=@Phone"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@LoginId", SqlDbType.NVarChar,50), new SqlParameter("@PassWord", SqlDbType.NVarChar,50), new SqlParameter("@AuthorityId", SqlDbType.Int,4), new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@StudentId", SqlDbType.Int,4), new SqlParameter("@Sex", SqlDbType.NVarChar,50), new SqlParameter("@CollegeId", SqlDbType.Int,4), new SqlParameter("@ClassId", SqlDbType.Int,4), new SqlParameter("@MajorId", SqlDbType.Int,4), new SqlParameter("@IdCard", SqlDbType.NVarChar,50), new SqlParameter("@Address", SqlDbType.NVarChar,-1), new SqlParameter("@Phone", SqlDbType.NVarChar,50), new SqlParameter("@Id", SqlDbType.Int,4)}; parameters[0].Value = model.LoginId; parameters[1].Value = model.PassWord; parameters[2].Value = model.AuthorityId; parameters[3].Value = model.Name; parameters[4].Value = model.StudentId; parameters[5].Value = model.Sex; parameters[6].Value = model.CollegeId; parameters[7].Value = model.ClassId; parameters[8].Value = model.MajorId; parameters[9].Value = model.IdCard; parameters[10].Value = model.Address; parameters[11].Value = model.Phone; parameters[12].Value = model.Id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.WebUser model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Mark model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eva.Model.Mark model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Mark set "); strSql.Append("CourseId=@CourseId,"); strSql.Append("StudentId=@StudentId,"); strSql.Append("EvalutionId=@EvalutionId,"); strSql.Append("Score=@Score,"); strSql.Append("BonusPoint=@BonusPoint,"); strSql.Append("AcademicYear=@AcademicYear,"); strSql.Append("SchoolTerm=@SchoolTerm,"); strSql.Append("CheckStep=@CheckStep,"); strSql.Append("Reason=@Reason,"); strSql.Append("Gpa=@Gpa"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@CourseId", SqlDbType.Int,4), new SqlParameter("@StudentId", SqlDbType.Int,4), new SqlParameter("@EvalutionId", SqlDbType.Int,4), new SqlParameter("@Score", SqlDbType.Float,8), new SqlParameter("@BonusPoint", SqlDbType.Float,8), new SqlParameter("@AcademicYear", SqlDbType.Int,4), new SqlParameter("@SchoolTerm", SqlDbType.Int,4), new SqlParameter("@CheckStep", SqlDbType.Int,4), new SqlParameter("@Reason", SqlDbType.NVarChar,50), new SqlParameter("@Gpa", SqlDbType.Float,8), new SqlParameter("@Id", SqlDbType.Int,4)}; parameters[0].Value = model.CourseId; parameters[1].Value = model.StudentId; parameters[2].Value = model.EvalutionId; parameters[3].Value = model.Score; parameters[4].Value = model.BonusPoint; parameters[5].Value = model.AcademicYear; parameters[6].Value = model.SchoolTerm; parameters[7].Value = model.CheckStep; parameters[8].Value = model.Reason; parameters[9].Value = model.Gpa; parameters[10].Value = model.Id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eva.Model.Authority model) { return dal.Add(model); }