///<summary> ///下一个分享 ///<para>Id:分享Id</para> /// </summary> public JiaJiNewWebModel.Share ShareNext(int Id) { try { JiaJiNewWebModel.Share infor = new JiaJiNewWebModel.Share(); DataTable dt1 = MySqlDB.GetDataTable("select MAX(ShareID) from shares", CommandType.Text, null); int Sid = (int)dt1.Rows[0][0]; if (Id >= Sid) { infor.ShareTitle = "已经是最后一章了"; return(infor); } else { string sql = "select * from shares where ShareID >@Id LIMIT 1"; MySqlParameter[] para = { new MySqlParameter("@Id", Id) }; DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, para); infor.ShareID = (int)dt.Rows[0]["ShareID"]; infor.ShareTitle = dt.Rows[0]["ShareTitle"].ToString(); Log4netHelper.WriteLog("日志报告"); return(infor); } } catch (Exception ex) { Log4netHelper.WriteLog("错误报告", ex); throw ex; } }
///<summary> ///上一个分享 ///<para>Id:分享Id</para> /// </summary> public JiaJiNewWebModel.Share SharePrev(int Id) { try { JiaJiNewWebModel.Share model = new JiaJiNewWebModel.Share(); DataTable dt1 = MySqlDB.GetDataTable("select min(ShareID) from shares", CommandType.Text, null); int Sid = (int)dt1.Rows[0][0]; if (Id == Sid) { model.ShareTitle = "已是第一章了"; return(model); } else { string sql = "select * from shares where ShareID <@Id order by ShareID desc limit 1"; MySqlParameter[] para = { new MySqlParameter("@Id", Id) }; DataTable dt = MySqlDB.GetDataTable(sql, CommandType.Text, para); model.ShareID = (int)dt.Rows[0]["ShareID"]; model.ShareTitle = dt.Rows[0]["ShareTitle"].ToString(); Log4netHelper.WriteLog("日志报告"); return(model); } } catch (Exception ex) { Log4netHelper.WriteLog("错误报告", ex); throw ex; } }
/// <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); } }