/// <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);
}
