/// <summary>
/// 添加学生信息和学生团队关系表
/// </summary>
/// <returns></returns>
public int stuadd(JiaJiModels.student stu)
{
try
{
string sql = "insert into student(StudentName,Score,Image,JiuDuXueyuan,EducationID) VALUES(?studentname,?score,?image,?jiuduxueyuan,?educationid)";
MySqlParameter[] pars =
{
new MySqlParameter("?studentname", stu.StudentName),
new MySqlParameter("?score", stu.Score),
new MySqlParameter("?image", stu.Image),
new MySqlParameter("?jiuduxueyuan", stu.JiuDuXueyuan),
new MySqlParameter("?educationid", stu.EducationID)
};
MySqlDB.nonquery(sql, CommandType.Text, pars);
string stusql = "select StudentID from student ORDER BY StudentID DESC limit 1";
DataTable dt = MySqlDB.GetDataTable(stusql, CommandType.Text, null);
int stid = Convert.ToInt32(dt.Rows[0]["StudentID"]);
string slq = "insert into teamrelation(TeamID,StudentID) VALUES(?teamid,?studentid)";
MySqlParameter[] parss =
{
new MySqlParameter("?teamid", stu.teamid),
new MySqlParameter("?studentid", stid)
};
MySqlDB.nonquery(slq, CommandType.Text, parss);
return(1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 添加xuesheng信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int addStu(JiaJiModels.student model)
{
try
{
return(new JiaJiDAL.studentdal().addStu(model));
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 修改学生信息
/// </summary>
/// <returns></returns>
public int UpdateStu(JiaJiModels.student model)
{
try
{
string sql = "Update study_abroad.student set StudentName = '" + model.StudentName + "', Score = '" + model.Score + "', CollegeID = " + model.CollegeID + ", `JiuDuXueyuan`= '" + model.JiuDuXueyuan + "', EducationID = " + model.EducationID + ",CountryID =" + model.CountryID + " where StudentID =" + model.StudentID + " ";
int he = MySqlDB.nonquery(sql, CommandType.Text, null);
return(he);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 添加学生信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int addStu(JiaJiModels.student model)
{
try
{
string sql = "insert into student(StudentName,Score,CollegeID,JiuDuXueyuan,EducationID,CountryID) VALUES('" + model.StudentName + "','" + model.Score + "'," + model.CollegeID + ",'" + model.JiuDuXueyuan + "'," + model.EducationID + "," + model.CountryID + ")";
int he = MySqlDB.nonquery(sql, CommandType.Text, null);
return(he);
}
catch (Exception ex)
{
return(0);
}
}
public int Stuadd(JiaJiModels.student stu)
{
return(dal.stuadd(stu));
}
