/// <summary>
/// 修改学员列表
/// </summary>
/// <returns></returns>
public int UpdateLearner(JiaJiModels.LearnerModel model)
{
try
{
return(new JiaJiDAL.LearnerDal().UpdateLearner(model));
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 添加高分学员
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int addMaxScoStu(JiaJiModels.LearnerModel model)
{
try
{
return(new JiaJiDAL.LearnerDal().addMaxScoStu(model));
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 语言添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int LanguageAdd(JiaJiModels.LearnerModel model)
{
string sql = "insert into languages(LanguageName,LanguageTitle,LanguageContent)value(@Name,@Title,@Content)";
MySqlParameter[] para =
{
new MySqlParameter("@Name", model.LanguageName),
new MySqlParameter("@TItle", model.LanguageTitle),
new MySqlParameter("@Content", model.LanguageContent)
};
return(MySqlDB.nonquery(sql, System.Data.CommandType.Text, para));
}
/// <summary>
/// 修改学员列表
/// </summary>
/// <returns></returns>
public int UpdateLearner(JiaJiModels.LearnerModel model)
{
try
{
string sql = "Update study_abroad.learner set LearnName = '" + model.LearnName + "', Phone = '" + model.Phone + "', GoTime = '" + model.GoTime + "', `LearnImage`= '" + model.LearnImage + "', CountryID = " + model.CountryID + " where LearnerID =" + model.LearnerID + " ";
int he = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null);
return(he);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 添加学员列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int addLearner(JiaJiModels.LearnerModel model)
{
try
{
string sql = "INSERT INTO study_abroad.learner (LearnName,Phone, GoTime, LearnImage,CountryID)VALUES ('" + model.LearnName + "','" + model.Phone + "','" + model.GoTime + "','" + model.LearnImage + "'," + model.CountryID + ")";
int he = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null);
return(he);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 修改高分学员列表
/// </summary>
/// <returns></returns>
public int UpdateMaxScoStu(JiaJiModels.LearnerModel model)
{
try
{
string sql = "Update study_abroad.learnsorce set LearnerID = " + model.LearnerID + ", LanguageID = " + model.LanguageID + ", Sorce = '" + model.Sorce + "', `LearnerGonsis`= '" + model.LearnerGonsis + "',LearnerContent='" + model.LearnerContent + "' where LearnSorceID =" + model.LearnSorceID + " ";
int he = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null);
return(he);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 添加高分学员列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int addMaxScoStu(JiaJiModels.LearnerModel model)
{
try
{
string sql = "insert into learnsorce(LearnerID,LanguageID,Sorce,LearnerGonsis,LearnerContent,HeatHot) VALUES(" + model.LearnerID + "," + model.LanguageID + ",'" + model.Sorce + "','" + model.LearnerGonsis + "','" + model.LearnerContent + "',0)";
int he = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null);
return(he);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 语言添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int LanguageAdd(JiaJiModels.LearnerModel model)
{
return(dal.LanguageAdd(model));
}
