/// <summary>
/// 获取行数
/// </summary>
/// <returns></returns>
public int GetRowCounts()
{
try
{
string sql2 = "select count(1) from information";
int i = MySqlDB.scalar(sql2, System.Data.CommandType.Text, null);
return(i = i % 8 == 0 ? i / 8 : (i / 8) + 1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 热门资讯显示前6条
/// </summary>
/// <returns></returns>
public List <Information> GetInformationTopList()
{
try
{
string sql = "select InformationID,Title,InfoDate from information order by InfoDate DESC LIMIT 6 ";
List <Information> list = MySqlDB.GetList <Information>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取合作的媒体
/// </summary>
/// <returns></returns>
public List <Medium> GetMedium()
{
try
{
string sql = "select MediumID,MediumName,MediumTitle,MediumImg,MediumUrl,`UpDate` from medium order by `UPDATE` desc LIMIT 3";
List <Medium> list = MySqlDB.GetList <Medium>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
///<summary>
///语言显示
/// </summary>
public List <Language> Language()
{
try
{
string sql = "select * from Languages";
List <Language> list = MySqlDB.GetList <Language>(sql, CommandType.Text, null);
return(list);
}
catch (Exception e)
{
return(null);
}
}
/// <summary>
/// 国家页面资讯图片
/// </summary>
/// <param name="countryid"></param>
/// <param name="educatonid"></param>
/// <returns></returns>
public List <Information> CountryZiXunImage(int countryid)
{
try
{
string sql = "select InformationID,Title,InformationImgUrl from information where ReadCount=(select MAX(ReadCount) from information where CountryID=" + countryid + ") limit 1";
List <Information> list = MySqlDB.GetList <Information>(sql.ToString(), System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取语言背景移民
/// </summary>
/// <returns></returns>
public List <Country> GetLBY(int countryid)
{
try
{
string sql = "select * from country where IsCountry=0 AND CountryID=" + countryid + "";
List <Country> list = MySqlDB.GetList <Country>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取搜索结果的行数
/// </summary>
/// <param name="selcontent"></param>
/// <returns></returns>
public int SelectRowCounts(string selcontent)
{
try
{
string sql2 = "select count(1) from information where Title like '%" + selcontent + "%' or Content like '%" + selcontent + "%' order by ReadCount DESC ";
int i = MySqlDB.scalar(sql2, System.Data.CommandType.Text, null);
return(i = i % 8 == 0 ? i / 8 : (i / 8) + 1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 获取国家规划页数
/// </summary>
/// <returns></returns>
public int GetRowCounts()
{
try
{
string sql2 = "select count(1) from studentprogram";
int i = MySqlDB.scalar(sql2, System.Data.CommandType.Text, null);
return(i = i % 8 == 0 ? i / 8 : (i / 8) + 1);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误日志", ex);
return(0);
}
}
///<summary>
///获取热度前六的观点
/// </summary>
public List <JiaJiNewWebModel.Option> HotOption()
{
try
{
string sql = "select * from `optioninfo` ORDER BY Date DESC LIMIT 6";
List <JiaJiNewWebModel.Option> list = MySqlDB.GetList <JiaJiNewWebModel.Option>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
///// <summary>
///// 首页留学图片
///// </summary>
///// <param name="countryid"></param>
///// <param name="educatonid"></param>
///// <returns></returns>
//public List<LunBoImageModel> IndexLXueList()
//{
// try
// {
// StringBuilder sql = new StringBuilder();
// sql.Append(" select lunboimage.ImageUrl,lunboimage.`UpDate` from lunboimage where IsLunBo=3 order by `UpDate` desc limit 2 ");
// List<LunBoImageModel> list = MySqlDB.GetList<LunBoImageModel>(sql.ToString(), System.Data.CommandType.Text, null);
// return list;
// }
// catch (Exception ex)
// {
// return null;
// }
//}
/// <summary>
/// 首页资讯图片
/// </summary>
/// <param name="countryid"></param>
/// <param name="educatonid"></param>
/// <returns></returns>
public List <Information> IndexInforImage()
{
try
{
string sql = "select InformationID,Title,InformationImgUrl from information where ReadCount=(select MAX(ReadCount) from information) limit 1";
List <Information> list = MySqlDB.GetList <Information>(sql.ToString(), System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
///<summary>
///项目显示
/// </summary>
public List <projectItem> ProjectShow()
{
try
{
string sql = "select * from projectitem";
List <projectItem> list = MySqlDB.GetList <projectItem>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
///<summary>
///移民项目
/// </summary>
public List <Project> ImmigrantShow()
{
try
{
string sql = "select * from project order by Date desc limit 2";
List <Project> list = MySqlDB.GetList <Project>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
/// <summary>
/// 获取首页轮播图
/// </summary>
/// <returns></returns>
public List <JiaJiNewWebModel.IndexImage> IndexImageLsit()
{
try
{
string sql = "select * from indeximage ORDER BY ImageUpDate DESC Limit 0,3";
List <JiaJiNewWebModel.IndexImage> indeximglist = MySqlDB.GetList <JiaJiNewWebModel.IndexImage>(sql, System.Data.CommandType.Text, null);
return(indeximglist);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取页数
/// </summary>
/// <returns></returns>
public int GetRowCounts()
{
try
{
string sql2 = "select count(1) from optioninfo";
int i = MySqlDB.scalar(sql2, System.Data.CommandType.Text, null);
return(i = i % 5 == 0 ? i / 5 : (i / 5) + 1);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
return(0);
}
}
/// <summary>
/// 分公司信息
/// </summary>
/// <param name="FilialeId">公司id</param>
/// <returns></returns>
public filialetext GetFilialetext(int FilialeId)
{
try
{
//string sql = "select FilialeId,FilialeName,FilialeTexts,FilialeTextAddr,FilialeTextPhone from filiale INNER JOIN filialetext on filiale.FilialeTextId = filialetext.FilialeTextId where FilialeId = "+FilialeId;
string sql = "SELECT * from filialetext LEFT JOIN filiale on filialetext.FilialeId=filiale.FilialeId where filialetext.FilialeId =" + FilialeId + " LIMIT 1";
DataTable model = MySqlDB.GetDataTable(sql, CommandType.Text, null);
return(MySqlDB.fanshemodel <filialetext>(model));
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 根据热度显示资讯列表（分页）
/// </summary>
/// <param name="pageindex"></param>
/// <returns></returns>
public List <Information> GetInformationList(int pageindex)
{
try
{
int pagesize = 8;
string sql = "SELECT SQL_CALC_FOUND_ROWS * FROM information ORDER BY InfoDate DESC LIMIT " + (pageindex - 1) * pagesize + ", " + pagesize + ";SELECT FOUND_ROWS(); ";
List <Information> list = MySqlDB.GetList <Information>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
///<summary>
///观点图片详情
/// </summary>
public List <JiaJiNewWebModel.Option> HotOptionImage()
{
try
{
string sql = "select OptionUrl from optioninfo where OptionHot=(select max(OptionHot) from optioninfo) limit 1";
List <JiaJiNewWebModel.Option> list = MySqlDB.GetList <JiaJiNewWebModel.Option>(sql, System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
/// <summary>
/// 获取语言培训的内容信息
/// </summary>
/// <returns></returns>
public List <JiaJiNewWebModel.Language_PeiXunModel> GetPeixunList()
{
try
{
string sql = "select Language_Name,Language_Content from Language_PeiXun limit 6";
List <Language_PeiXunModel> list = MySqlDB.GetList <Language_PeiXunModel>(sql, CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
///<summary>
///留学规划类别后五条
///<param></param>
/// </summary>
/// <returns></returns>
public List <StudentProgramType> TypeShow()
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT * from studentprogramtype limit 5 ");
List <StudentProgramType> list = MySqlDB.GetList <StudentProgramType>(sql.ToString(), CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
///<summary>
///申请时间规划表
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public List <ArrangeTime> ArrangeShow(int countryid, int educationid)
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" select ArrangeID,ArrangeMonth,ArrangeContent from arrangetime where CountryID=" + countryid + " and EducationID=" + educationid + " GROUP BY ShowID ORDER BY ShowID limit 7 ");
List <ArrangeTime> list = MySqlDB.GetList <ArrangeTime>(sql.ToString(), CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 二维码
/// </summary>
/// <param name="countryid"></param>
/// <param name="educatonid"></param>
/// <returns></returns>
public List <erweima> ErWeiMaList()
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" select EWMTitle,EWMUrl from erweimainfo order by EWMUpdate desc limit 4 ");
List <erweima> list = MySqlDB.GetList <erweima>(sql.ToString(), System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// js获取高分学员的数量
/// </summary>
/// <param name="areaid"></param>
/// <returns></returns>
public int GetRowCounts(int languageid)
{
try
{
string sql2 = "SELECT count(1) from learnsorce a INNER JOIN `languages` b on a.LanguageID=b.LanguageID " +
" INNER JOIN learner c on a.LearnerID = c.LearnerID where b.LanguageID = " + languageid + "";
int i = MySqlDB.scalar(sql2, System.Data.CommandType.Text, null);
return(i % 5 == 0 ? i / 5 : (i / 5) + 1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 获取学生信息的数量
/// </summary>
/// <returns></returns>
public int CountStudentInfo()
{
try
{
string sql = @"select COUNT(1) from Successful_Relation a INNER JOIN student b on a.StudentID = b.StudentID INNER JOIN College d ON b.CollegeID = d.CollegeID ";
int ids = MySqlDB.scalar(sql, CommandType.Text, null);
Log4netHelper.WriteLog("系统日志：请求了ActiveDal类下的CountStudentInfo方法");
return(ids);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误信息：请求了ActiveDal类下的ActiveLsitIndex方法", ex);
return(0);
}
}
/// <summary>
/// js获取团队行数
/// </summary>
/// <param name="areaid"></param>
/// <returns></returns>
public int GetRowCounts(int areaid)
{
try
{
string sql2 = "SELECT count(1) from arearelation a " +
"INNER JOIN team b ON a.TeamID = b.TeamID " +
"INNER JOIN areases c ON a.AreaID = c.AreaID WHERE c.AreaID = " + areaid + "";
int i = MySqlDB.scalar(sql2, System.Data.CommandType.Text, null);
return(i % 5 == 0 ? i / 5 : (i / 5) + 1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 西安团队
/// </summary>
/// <param name="areaid">地区ID</param>
/// <returns></returns>
public List <Team> GetXiAnTeam()
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT SQL_CALC_FOUND_ROWS b.TeamID,b.`Name`,b.Position,b.WorkDate,b.ShenQing,c.AreaID,c.AreaName,b.Image1,TeamProduce from arearelation a ");
sql.Append(" INNER JOIN team b ON a.TeamID = b.TeamID ");
sql.Append(" INNER JOIN areases c ON a.AreaID = c.AreaID WHERE c.AreaName = '西安' LIMIT 0,4 ");
List <Team> list = MySqlDB.GetList <Team>(sql.ToString(), System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取国家集合
/// </summary>
/// <returns></returns>
public List <JiaJiNewWebModel.Country> CountryList()
{
try
{
string sql = "SELECT CountryID,CountryName,CountryImg from country where IsCountry=1";
List <JiaJiNewWebModel.Country> list = MySqlDB.GetList <JiaJiNewWebModel.Country>(sql, System.Data.CommandType.Text, null);
Log4netHelper.WriteLog("系统日志，请求了CountryDal类下的CountryDAL方法");
return(list);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误，请求了CountryDal类下的CountryDAL方法", ex);
throw;
}
}
/// <summary>
/// 获取项目对应的图片
/// </summary>
/// <returns></returns>
public List <JiaJiNewWebModel.projectItem> GetProImgList(int proid)
{
try
{
string sql = "select * from projectItem where Pro_ID=" + proid + " ";
List <JiaJiNewWebModel.projectItem> list = MySqlDB.GetList <JiaJiNewWebModel.projectItem>(sql, System.Data.CommandType.Text, null);
Log4netHelper.WriteLog("系统日志，请求了ProjectItemDAL类下的GetProductList方法");
return(list);
}
catch (System.Exception ex)
{
Log4netHelper.WriteLog("错误信息：请求了ProjectItemDAL类下的GetProductList方法", ex);
return(null);
}
}
/// <summary>
/// 首页显示解决方案步骤
/// </summary>
/// <returns></returns>
public List <JiaJiNewWebModel.Solution_BuZhou> SolutionBuZhouList()
{
try
{
string sql = "select SolutionBuZhouID,SolutionBuZhou from solution_buzou ORDER BY SolutionBuZhouID DESC LIMIT 8";
List <JiaJiNewWebModel.Solution_BuZhou> list = MySqlDB.GetList <JiaJiNewWebModel.Solution_BuZhou>(sql, CommandType.Text, null);
Log4netHelper.WriteLog("系统日志，请求了SolutionDAL类下的SolutionIndexList方法");
return(list);
}
catch (System.Exception ex)
{
Log4netHelper.WriteLog("错误信息：请求了ActiveDal类下的ActiveLsitIndex方法", ex);
return(null);
}
}
///<summary>
///获取移民项目详情
/// </summary>
/// <para>Id:项目ID</para>
/// <returns></returns>
public Project ImmigrantShow(int Id)
{
try
{
string sql = "update project set ProjectReadCount=ProjectReadCount+1 where ProjectID=" + Id + ";";
sql += "select * from project where ProjectID='" + Id + "'";
DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, null);
Project pro = MySqlDB.fanshemodel <Project>(dt);
return(pro);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
///<summary>
///获取背景提升项目详情
/// </summary>
/// <para>Id:项目ID</para>
/// <returns></returns>
public projectItem ProjectItemShow(int Id)
{
try
{
string sql = "update projectitem set Pro_ReadCount=Pro_ReadCount+1 where Pro_ID=" + Id + ";";
sql += "select * from projectitem where Pro_ID=" + Id + "";
DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, null);
projectItem pro = MySqlDB.fanshemodel <projectItem>(dt);
return(pro);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
