/// <summary>
/// 获取背景提升项目
/// </summary>
/// <returns></returns>
public List <JiaJiModels.projectitem> Project()
{
string sql = "select * from projectitem";
List <JiaJiModels.projectitem> list = MySqlDB.GetList <JiaJiModels.projectitem>(sql, CommandType.Text, null);
return(list);
}
/// <summary>
/// 分公司
/// </summary>
/// <returns></returns>
public List <filialetext> FilialeShow()
{
try
{
string sql = "select FilialeId,FilialeName from filiale";
return(MySqlDB.GetList <filialetext>(sql, CommandType.Text, null));
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取团队列表信息
/// </summary>
/// <returns></returns>
public List <JiaJiModels.Team> Tshow()
{
try
{
string sql = "SELECT * from team";
return(MySqlDB.GetList <JiaJiModels.Team>(sql, CommandType.Text, null));
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 显示地区
/// </summary>
/// <returns></returns>
public List <JiaJiModels.areases> ShowArea()
{
try
{
string sql = "select AreaID,AreaName from areases ";
List <JiaJiModels.areases> arealist = MySqlDB.GetList <JiaJiModels.areases>(sql, System.Data.CommandType.Text, null);
return(arealist);
}
catch (Exception e)
{
return(null);
}
}
/// <summary>
/// 获取留学申请内容
/// </summary>
/// <returns></returns>
public List <JiaJiModels.ApplyModel.ApplyContentInfo> ShowApplyContent()
{
try
{
string sql = "select * from applycontentinfo order by ApplyContentID desc ";
List <JiaJiModels.ApplyModel.ApplyContentInfo> list = MySqlDB.GetList <JiaJiModels.ApplyModel.ApplyContentInfo>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取免费留学方案
/// </summary>
/// <returns></returns>
public List <JiaJiModels.Apply> StuApplyList()
{
try
{
string sql = "select CountryName,UserName,Phone,GoTime from apply order by ApplyID desc";
List <JiaJiModels.Apply> list = MySqlDB.GetList <JiaJiModels.Apply>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取留学申请条件
/// </summary>
/// <returns></returns>
public List <JiaJiModels.ApplyModel.ApplyCondition> ShowApplyCondition()
{
try
{
string sql = "select * from applycondition ";
List <JiaJiModels.ApplyModel.ApplyCondition> list = MySqlDB.GetList <JiaJiModels.ApplyModel.ApplyCondition>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取资讯列表
/// </summary>
/// <returns></returns>
public List <JiaJiModels.Information> INshow(string Title)
{
try
{
string sql = "SELECT InformationID,Title,Content,InfoDate,`Source`,Author,ReadCount,information.CountryID,information.Site,areases.AreaID,areases.AreaName,InformationImgUrl,InfoKeyWord,InformationProfile from information left join country on information.CountryID=country.CountryID left join areases on information.Site=areases.AreaID order by InformationID desc ";
List <JiaJiModels.Information> list = MySqlDB.GetList <JiaJiModels.Information>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取学员分享列表
/// </summary>
/// <returns></returns>
public List <JiaJiModels.ShareModel> INshow()
{
try
{
string sql = "SELECT InformationID,Title,Content,InfoDate,`Source`,Author,ReadCount,LookYes,information.CountryID,information.Site,areases.AreaID,areases.AreaName from information left join country on information.CountryID=country.CountryID left join areases on information.Site=areases.AreaID order by InformationID desc ";
List <JiaJiModels.ShareModel> list = MySqlDB.GetList <JiaJiModels.ShareModel>(sql.ToString(), System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取学历列表信息
/// </summary>
/// <returns></returns>
public List <JiaJiModels.educationtype> Edushow()
{
try
{
string sql = "select * from educationtype";
List <JiaJiModels.educationtype> list = MySqlDB.GetList <JiaJiModels.educationtype>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
public List <NavInfo> GetTypeByCountryId(int countryId)
{
try
{
string sql = "SELECT NavID,NavTitleOne FROM navinfo where guojia=" + countryId + " and NavParentID=0";
List <NavInfo> list = MySqlDB.GetList <NavInfo>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
public List <NavInfo> GetNavList()
{
try
{
string sql = "select * from navinfo";
List <NavInfo> list = MySqlDB.GetList <NavInfo>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 显示解决方案
/// </summary>
/// <returns></returns>
public List <JiaJiModels.solution> ShowSolution()
{
try
{
string sql = "SELECT * from solution";
List <JiaJiModels.solution> list = MySqlDB.GetList <JiaJiModels.solution>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 显示媒体信息
/// </summary>
/// <returns></returns>
public List <JiaJiModels.medium> ShowMedium()
{
try
{
string sql = "select MediumID,MediumName,MediumTitle,MediumImg,`UpDate`,MediumUrl from medium";
List <JiaJiModels.medium> mediumlist = MySqlDB.GetList <JiaJiModels.medium>(sql, CommandType.Text, null);
return(mediumlist);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 显示
/// </summary>
/// <returns></returns>
public List <JiaJiModels.LunBoImage> ShowCounImage()
{
try
{
string sql = "select * from lunboimage LEFT JOIN country on lunboimage.CountryID=country.CountryID LEFT JOIN educationtype on lunboimage.EducationID=educationtype.EducationID order by LunImageID desc";
List <JiaJiModels.LunBoImage> list = MySqlDB.GetList <JiaJiModels.LunBoImage>(sql.ToString(), System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取留学规时间规划
/// </summary>
/// <returns></returns>
public List <JiaJiModels.ApplyModel.ArrangeTime> ShowArrangTime()
{
try
{
string sql = " select ArrangeID,ArrangeMonth,ArrangeContent,arrangetime.CountryID,arrangetime.EducationID,CountryName,EducationName,ShowID from arrangetime left join country on arrangetime.CountryID=country.CountryID left join educationtype on arrangetime.EducationID=educationtype.EducationID ";
List <JiaJiModels.ApplyModel.ArrangeTime> list = MySqlDB.GetList <JiaJiModels.ApplyModel.ArrangeTime>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 嘉际观点显示
/// </summary>
/// <returns></returns>
public List <JiaJiModels.OptionModel> ShowOptions()
{
try
{
string sql = "select OptionID,OptionTitle,Author,Source,Date,OptionHot,OptionContent,OptionKeyWord,OptionUrl from optioninfo order by OptionID desc ";
List <JiaJiModels.OptionModel> list = MySqlDB.GetList <JiaJiModels.OptionModel>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取活动信息
/// </summary>
/// <returns></returns>
public List <JiaJiModels.Active> Activeshow()
{
try
{
string sql = "select active.ActiveID,active.ActiveTitle,active.ActiveDate,active.Datails,active.ActivePhone,active.HeatID,country.CountryName,country.CountryID,areases.AreaID,areases.AreaName,active.Site,ActiveKeyWord,ActiveProfile from active left join country on active.CountryID=country.CountryID left join areases on active.Site=areases.AreaID order by active.ActiveID desc";
List <JiaJiModels.Active> list = MySqlDB.GetList <JiaJiModels.Active>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 显示学历
/// </summary>
/// <returns></returns>
public List <JiaJiModels.educationtype> ShowEducation()
{
try
{
string sql = "select EducationID,EducationName from educationtype ";
List <JiaJiModels.educationtype> arealist = MySqlDB.GetList <JiaJiModels.educationtype>(sql, System.Data.CommandType.Text, null);
return(arealist);
}
catch (Exception e)
{
return(null);
}
}
/// <summary>
/// 获取学员列表
/// </summary>
/// <returns></returns>
public List <JiaJiModels.LearnerModel> showLearner()
{
try
{
string sql = "select * from learner left join country on learner.CountryID = country.CountryID order by LearnerID desc ";
List <JiaJiModels.LearnerModel> list = MySqlDB.GetList <JiaJiModels.LearnerModel>(sql.ToString(), System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 显示语言
/// </summary>
/// <returns></returns>
public List <JiaJiModels.Languages> ShowLanguage()
{
try
{
string sql = "select * from Languages";
List <JiaJiModels.Languages> list = MySqlDB.GetList <JiaJiModels.Languages>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取高分学员列表
/// </summary>
/// <returns></returns>
public List <JiaJiModels.LearnerModel> showMaxScoStu()
{
try
{
string sql = "select * from learnsorce left join learner on learnsorce.LearnerID=learner.LearnerID left join languages on learnsorce.LanguageID=languages.LanguageID order by LearnSorceID DESC ";
List <JiaJiModels.LearnerModel> list = MySqlDB.GetList <JiaJiModels.LearnerModel>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 课程添加
/// </summary>
/// <param name="model"></param>
/// <param name="LanID"></param>
/// <returns></returns>
//public int CourseAdd(JiaJiModels.CourseModel model)
//{
// string sql = "insert into course(CourseName,CourseContent)values(@Name,@Content)";
// MySqlParameter[] para = {
// new MySqlParameter("@Name",model.CourseName),
// new MySqlParameter("@Content",model.CourseContent)
// };
// MySqlDB.nonquery(sql, CommandType.Text, para);
// string sql1 = "select CourseID from course where CourseName=@CourseName";
// MySqlParameter[] para1 = {
// new MySqlParameter("@CourseName",model.CourseName)
// };
// DataTable dt = MySqlDB.GetDataTable(sql1, CommandType.Text, para1);
// int CourseID = (int)dt.Rows[0][0];
// string sql2 = "insert into languagerelation(LanguageID,CourseID)values(@LanID,@CourseID)";
// MySqlParameter[] para2 = {
// new MySqlParameter("@LanID",model.LanguageID),
// new MySqlParameter("@CourseID",CourseID)
// };
// MySqlDB.nonquery(sql2, CommandType.Text, para2);
// return 1;
//}
#endregion
#region 语言培训
/// <summary>
/// 显示语言培训
/// </summary>
/// <returns></returns>
public List <JiaJiModels.Language_PeiXun> ShowLanguagePeiXun()
{
try
{
string sql = "select * from language_peixun ";
List <JiaJiModels.Language_PeiXun> list = MySqlDB.GetList <JiaJiModels.Language_PeiXun>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 显示课程
/// </summary>
/// <returns></returns>
public List <JiaJiModels.CourseModel> ShowCourse()
{
try
{
string sql = "select * from course";
List <JiaJiModels.CourseModel> list = MySqlDB.GetList <JiaJiModels.CourseModel>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 语言课程关系显示
/// </summary>
/// <returns></returns>
public List <JiaJiModels.languagerelation> ShowLangCour()
{
try
{
string sql = "select * from languagerelation left join course on languagerelation.CourseID = course.CourseID left join languages on languagerelation.LanguageID = languages.LanguageID ORDER BY LRelationID DESC";
List <JiaJiModels.languagerelation> list = MySqlDB.GetList <JiaJiModels.languagerelation>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取团队标题
/// </summary>
/// <returns></returns>
public List <JiaJiModels.Team> showTitle()
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" select TeamTitleID,TitleName from team_title ");
List <JiaJiModels.Team> list = MySqlDB.GetList <JiaJiModels.Team>(sql.ToString(), CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
public List <Team> Team()
{
try
{
string sql = "select TeamID,Name from Team";
List <Team> list = MySqlDB.GetList <Team>(sql.ToString(), CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取优势信息
/// </summary>
/// <returns></returns>
public List <JiaJiModels.DominantModel> ShowDominant()
{
try
{
//string sql = "select CountryDominantID,countrydominant.DominantID,countrydominant.CountryID,CountryName,DominantName,Chance from countrydominant left join dominant on countrydominant.DominantID=dominant.DominantID left join country on countrydominant.CountryID=country.CountryID";
string sql = "select DominantID,DominantName,dominant.CountryID,CountryName from dominant left join country on dominant.CountryID=country.CountryID";
List <JiaJiModels.DominantModel> list = MySqlDB.GetList <JiaJiModels.DominantModel>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取录取学院列表
/// </summary>
/// <returns></returns>
public List <JiaJiModels.collages> Collegehow()
{
try
{
string sql = "select * from college";
List <JiaJiModels.collages> list = MySqlDB.GetList <JiaJiModels.collages>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
var s = ex;
return(null);
}
}
/// <summary>
/// 学员分享
/// </summary>
/// <returns></returns>
public List <JiaJiModels.ShareModel> ShowShare()
{
try
{
string sql = "SELECT ShareID,ShareTitle,ShareContent,shares.LearnerID,Learner.LearnName,ShareDate,shares.Pro_ID,projectitem.Pro_Name,ShareImg,ShareKeyword,ShareProfile,ShareReadCount from shares left join Learner on shares.LearnerID=Learner.LearnerID LEFT JOIN projectitem on shares.Pro_ID=projectitem.Pro_ID order by ShareID desc ";
List <JiaJiModels.ShareModel> list = MySqlDB.GetList <JiaJiModels.ShareModel>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}