///<summary>
///获取资讯详情
///informationID:资讯ID
/// </summary>
public Information InformationShow(int InformationID)
{
try
{
string sql1 = "UPDATE information set ReadCount=ReadCount+1 where InformationID=@Id";
string sql = "select * from information where InformationID=@Id";
MySqlParameter[] para =
{
new MySqlParameter("@Id", InformationID)
};
MySqlDB.nonquery(sql1, CommandType.Text, para);
DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, para);
Information info = new Information();
info.InformationID = (int)dt.Rows[0]["InformationID"];
info.Title = dt.Rows[0]["Title"].ToString();
info.content = dt.Rows[0]["Content"].ToString();
info.InfoDate = dt.Rows[0]["InfoDate"].ToString();
info.Source = dt.Rows[0]["Source"].ToString();
info.Author = dt.Rows[0]["Author"].ToString();
info.ReadCount = (int)dt.Rows[0]["ReadCount"];
info.InfoKeyWord = dt.Rows[0]["InfoKeyWord"].ToString();
info.InformationImgUrl = dt.Rows[0]["InformationImgUrl"].ToString();
Log4netHelper.WriteLog("日志报告");
return(info);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
return(null);
}
}
///// <summary>
///// 根据热度显示资讯列表（分页）
///// </summary>
///// <param name="pageindex"></param>
///// <returns></returns>
//public List<Information> GetInformationList(int pageindex, int pagesize, out int rowcounts)
//{
// string sql = "SELECT SQL_CALC_FOUND_ROWS * FROM information ORDER BY ReadCount DESC LIMIT " + (pageindex - 1) * pagesize + ", " + pagesize + ";SELECT FOUND_ROWS(); ";
// List<Information> list = MySqlDB.GetList<Information>(sql, System.Data.CommandType.Text, null);
// foreach (var item in list)
// {
// if (item.Content.Length > 50)
// {
// item.Content = item.Content.ToString().Substring(0, 25);
// }
// }
// string sql2 = "select count(1) from information";
// rowcounts = MySqlDB.scalar(sql2, System.Data.CommandType.Text, null);
// return list;
//}
/// <summary>
/// 活动详情
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Active ActiveShow(int Id)
{
try
{
string sql1 = "update active set HeatID=HeatID+1 where ActiveID=@Id ";
string sql = "select * from active left join areases on active.Site=areases.AreaID where ActiveID=@Id";
MySqlParameter[] para =
{
new MySqlParameter("@Id", Id)
};
MySqlDB.nonquery(sql1, CommandType.Text, para);
DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, para);
Active active = new Active();
active.ActiveID = (int)dt.Rows[0]["ActiveID"];
active.ActiveTitle = dt.Rows[0]["ActiveTitle"].ToString();
active.ActiveDate = dt.Rows[0]["ActiveDate"].ToString();
active.Site = Convert.ToInt32(dt.Rows[0]["Site"]);
active.Datails = dt.Rows[0]["Datails"].ToString();
active.ActivePhone = dt.Rows[0]["ActivePhone"].ToString();
active.HeatID = (int)dt.Rows[0]["HeatID"];
active.AreaID = (int)dt.Rows[0]["AreaID"];
active.AreaName = dt.Rows[0]["AreaName"].ToString();
active.ActiveKeyWord = dt.Rows[0]["ActiveKeyWord"].ToString();
Log4netHelper.WriteLog("日至报告");
return(active);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误日志", ex);
return(null);
}
}
///<summary>
///规划详情
///<para>Id:规划ID</para>
/// </summary>
public StudentProgram StudentShow(int Id)
{
try
{
string sql1 = "update `studentprogram` set ReadCount=ReadCount+1 where StudentProgramID=" + Id + "";
MySqlDB.nonquery(sql1, CommandType.Text, null);
string sql = "select * from studentprogram left join country on studentprogram.CountryID=country.CountryID left join educationtype on studentprogram.EducationID=educationtype.EducationID where StudentProgramID = @Id";
MySqlParameter[] para =
{
new MySqlParameter("@Id", Id)
};
DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, para);
StudentProgram student = new StudentProgram();
student.Author = dt.Rows[0]["Author"].ToString();
//student.Image = Convert.ToBase64String((byte[])dt.Rows[0]["Image"]);
student.CountryName = dt.Rows[0]["CountryName"].ToString();
student.EducationName = dt.Rows[0]["EducationName"].ToString();
student.ReadCount = (int)dt.Rows[0]["ReadCount"];
student.StudentProgramContent = dt.Rows[0]["StudentProgramContent"].ToString();
student.StudentProgramTitle = dt.Rows[0]["StudentProgramTitle"].ToString();
student.Source = dt.Rows[0]["Source"].ToString();
student.StudentKeyWord = dt.Rows[0]["StudentKeyWord"].ToString();
student.StudentProfile = dt.Rows[0]["StudentProfile"].ToString();
student.Imageurl = dt.Rows[0]["Imageurl"].ToString();
Log4netHelper.WriteLog("日志报告");
return(student);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误日志", ex);
throw ex;
}
}
///<summary>
///观点详情
/// </summary>
public Option OptionShow(int Id)
{
try
{
string sql1 = "update `optioninfo` set OptionHot=OptionHot+1 where OptionID='" + Id + "'";
MySqlDB.nonquery(sql1, CommandType.Text, null);
string sql = "select * from `optioninfo` where OptionID='" + Id + "' ";
DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, null);
Option op = MySqlDB.fanshemodel <Option>(dt);
//DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, null);
//Option op = new Option();
//op.OptionTitle = dt.Rows[0]["OptionTitle"].ToString();
//op.OptionContent = dt.Rows[0]["OptionContent"].ToString();
//op.Author = dt.Rows[0]["Author"].ToString();
//op.Source = dt.Rows[0]["Source"].ToString();
//op.Date = dt.Rows[0]["Date"].ToString();
//op.OptionHot = (int)dt.Rows[0]["OptionHot"];
return(op);
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
}
public bool EditByModel(NavInfoModel model)
{
bool res = false;
try
{
string sql = "update NavInfo set NavTitleOne=@NavTitleOne,NavContentOne=@NavContentOne,NavParentID=@NavParentID,NavTypeID=@NavTypeID,NavIsLevel=@NavIsLevel,NavDate=@NavDate,NavCreateBy=@NavCreateBy,NavHeat=@NavHeat,NavTitleTwo=@NavTitleTwo,NavContentTwo=@NavContentTwo,GuoJia=@GuoJia,BuWei=@BuWei,PaiXu=@PaiXu,depth=@depth,LinkFor=@LinkFor,KeyWord=@KeyWord where NavID=@NavID";
MySqlParameter[] para =
{
new MySqlParameter("@NavID", model.NavId),
new MySqlParameter("@NavTitleOne", model.NavTitleOne),
new MySqlParameter("@NavContentOne", model.NavContentOne),
new MySqlParameter("@NavParentID", model.NavParentId),
new MySqlParameter("@NavTypeID", model.NavType),
new MySqlParameter("@NavIsLevel", model.NavIsLevel),
new MySqlParameter("@NavDate", model.NavDate),
new MySqlParameter("@NavCreateBy", model.NavCreateBy),
new MySqlParameter("@NavHeat", model.NavHeat),
new MySqlParameter("@NavTitleTwo", model.NavTitleTwo),
new MySqlParameter("@NavContentTwo", model.NavContentTwo),
new MySqlParameter("@GuoJia", model.GuoJia),
new MySqlParameter("@BuWei", model.BuWei),
new MySqlParameter("@PaiXu", model.PaiXu),
new MySqlParameter("@depth", model.Depth),
new MySqlParameter("@LinkFor", model.LinkFor),
new MySqlParameter("@KeyWord", model.KeyWord)
};
int n = MySqlDB.nonquery(sql, CommandType.Text, para);
if (n > 0)
{
res = true;
}
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
return(res);
}
/// <summary>
/// 添加申请
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
public bool Addapply(Apply a)
{
string sql = "insert into apply (CountryName,UserName,Phone,GoTime) values(?countryname,?username,?phone,?gotime)";
MySqlParameter[] pars =
{
new MySqlParameter("?countryname", a.CountryName),
new MySqlParameter("?username", a.UserName),
new MySqlParameter("?phone", a.Phone),
new MySqlParameter("?gotime", a.GoTime)
};
int i = MySqlDB.nonquery(sql, System.Data.CommandType.Text, pars);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool AddByModel(NavInfoModel model)
{
bool res = false;
try
{
string sql = "insert into NavInfo (NavTitleOne,NavContentOne,NavParentID,NavTypeID,NavIsLevel,NavDate,NavCreateBy,NavHeat ,NavTitleTwo,NavContentTwo,GuoJia,BuWei,PaiXu,depth,LinkFor,KeyWord) Values (@NavTitleOne,@NavContentOne,@NavParentID,@NavTypeID,@NavIsLevel,@NavDate,@NavCreateBy,@NavHeat,@NavTitleTwo,@NavContentTwo,@GuoJia,@BuWei,@PaiXu,@depth,@LinkFor,@KeyWord)";
MySqlParameter[] para =
{
new MySqlParameter("@NavTitleOne", model.NavTitleOne),
new MySqlParameter("@NavContentOne", model.NavContentOne),
new MySqlParameter("@NavParentID", model.NavParentId),
new MySqlParameter("@NavTypeID", model.NavType),
new MySqlParameter("@NavIsLevel", model.NavIsLevel),
new MySqlParameter("@NavDate", model.NavDate),
new MySqlParameter("@NavCreateBy", model.NavCreateBy),
new MySqlParameter("@NavHeat", model.NavHeat),
new MySqlParameter("@NavTitleTwo", model.NavTitleTwo),
new MySqlParameter("@NavContentTwo", model.NavContentTwo),
new MySqlParameter("@GuoJia", model.GuoJia),
new MySqlParameter("@BuWei", model.BuWei),
new MySqlParameter("@PaiXu", model.PaiXu),
new MySqlParameter("@depth", model.Depth),
new MySqlParameter("@LinkFor", model.LinkFor),
new MySqlParameter("@KeyWord", model.KeyWord)
};
int n = MySqlDB.nonquery(sql, CommandType.Text, para);
if (n > 0)
{
res = true;
}
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
return(res);
}
/// <summary>
/// 获取分享详情
/// </summary>
/// <returns></returns>
public JiaJiNewWebModel.Share GetShareContent(int shareid)
{
try
{
string sql1 = "update Shares set ShareReadCount=ShareReadCount+1 where ShareID=@Id ";
string sql = "select ShareID,ShareTitle,ShareContent,ShareImg,ShareDate,Pro_Img,ProactiveImg1,ProactiveImg2,Shares.LearnerID,LearnName,Pro_Name,shares.Pro_ID,ShareProfile,ShareKeyword,ShareReadCount from Shares LEFT JOIN projectitem on shares.Pro_ID=projectitem.Pro_ID left join learner on learner.LearnerID=Shares.LearnerID where Shares.ShareID=@Id ";
MySqlParameter[] para =
{
new MySqlParameter("@Id", shareid)
};
MySqlDB.nonquery(sql1, CommandType.Text, para);
DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, para);
JiaJiNewWebModel.Share model = new JiaJiNewWebModel.Share();
model.ShareID = (int)dt.Rows[0]["ShareID"];
model.ShareTitle = dt.Rows[0]["ShareTitle"].ToString();
model.ShareContent = dt.Rows[0]["ShareContent"].ToString();
model.ShareImg = dt.Rows[0]["ShareImg"].ToString();
model.ShareDate = dt.Rows[0]["ShareDate"].ToString();
model.Pro_Img = dt.Rows[0]["Pro_Img"].ToString();
model.ProactiveImg1 = dt.Rows[0]["ProactiveImg1"].ToString();
model.ProactiveImg2 = dt.Rows[0]["ProactiveImg2"].ToString();
model.LearnerID = Convert.ToInt32(dt.Rows[0]["LearnerID"]);
model.LearnName = dt.Rows[0]["LearnName"].ToString();
model.Pro_Name = dt.Rows[0]["Pro_Name"].ToString();
model.Pro_ID = (int)dt.Rows[0]["Pro_ID"];
model.LearnerID = Convert.ToInt32(dt.Rows[0]["LearnerID"]);
model.ShareProfile = dt.Rows[0]["ShareProfile"].ToString();
model.ShareKeyword = dt.Rows[0]["ShareKeyword"].ToString();
model.ShareReadCount = Convert.ToInt32(dt.Rows[0]["ShareReadCount"]);
Log4netHelper.WriteLog("系统日志，请求了ProjectItemDAL类下的GetShareList方法");
return(model);
}
catch (System.Exception ex)
{
Log4netHelper.WriteLog("错误信息：请求了ProjectItemDAL类下的GetShareList方法", ex);
return(null);
}
}
public bool DeleteByModel(NavInfoModel model)
{
bool res = false;
try
{
string sql = "delete from NavInfo where NavID=@NavID";
MySqlParameter[] para =
{
new MySqlParameter("@NavID", model.NavId)
};
int n = MySqlDB.nonquery(sql, CommandType.Text, para);
if (n > 0)
{
res = true;
}
}
catch (Exception ex)
{
Log4netHelper.WriteLog("错误报告", ex);
throw ex;
}
return(res);
}