/// <summary>
/// 根据学号删除学生信息
/// </summary>
public void Delete_one()
{
Console.WriteLine("请输入要修改的学生学号：");
string Student_Id = Console.ReadLine();
Console.WriteLine("确定要删除此学生信息？（yes/no）");
string judge = Console.ReadLine();
string sql = string.Format("Delete from Student Where StudentNo='{0}'", Student_Id);
try
{
var delete = DBOperation.ExecuteNonQuery(sql);
if (judge == "yes")
{
if (delete > 0)
{
Console.WriteLine("删除成功!");
}
else
{
Console.WriteLine("删除失败！请查看输入的学生学号是否有误！");
}
}
else
{
Console.WriteLine("您取消了修改！");
}
}
catch (Exception ex)
{
Console.WriteLine("出现异常：{0}", ex.Message);
}
}
/// <summary>
/// 根据学生学号修改学生出生日期
/// </summary>
public void Modify_one()
{
Console.WriteLine("请输入要修改的学生学号：");
string Student_Id = Console.ReadLine();
Console.WriteLine("请输入修改日期（使用‘-’隔开）：");
string Data_Birth = Console.ReadLine();
string sql = string.Format("Update Student set BornDate='{0}' Where StudentNo='{1}'", Data_Birth, Student_Id);
try
{
var modify = DBOperation.ExecuteNonQuery(sql);
if (modify > 0)
{
Console.WriteLine("修改成功！");
}
else
{
Console.WriteLine("修改失败！请查看输入的学生学号或修改日期是否有误！");
}
}
catch (Exception ex)
{
Console.WriteLine("出现异常：{0}", ex.Message);
}
}
/// <summary>
/// 新增年级
/// </summary>
public void New_one()
{
Console.WriteLine("请输入待插入的年级名称：");
string Grade_Name = Console.ReadLine();
string sql = string.Format("Insert Grade Values('{0}')", Grade_Name);
try
{
var New = DBOperation.ExecuteNonQuery(sql);
if (New > 0)
{
Console.WriteLine("插入成功！");
}
else
{
Console.WriteLine("插入失败！");
}
}
catch (Exception ex)
{
Console.WriteLine("出现异常：{0}", ex.Message);
}
}