///<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);
}
}
