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