public bool AddIssueViewLog(IssueViewLogEntity issueViewLogEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("@JournalID");
sqlCommandText.Append(", @ContentID");
sqlCommandText.Append(", @AuthorID");
sqlCommandText.Append(", @Daytime");
sqlCommandText.Append(", @Year");
sqlCommandText.Append(", @Month");
sqlCommandText.Append(", @IP");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.IssueViewLog ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, issueViewLogEntity.JournalID);
db.AddInParameter(cmd, "@ContentID", DbType.Int64, issueViewLogEntity.ContentID);
db.AddInParameter(cmd, "@AuthorID", DbType.Int64, issueViewLogEntity.AuthorID);
db.AddInParameter(cmd, "@Daytime", DbType.Int32, issueViewLogEntity.Daytime);
db.AddInParameter(cmd, "@Year", DbType.Int32, issueViewLogEntity.Year);
db.AddInParameter(cmd, "@Month", DbType.Int32, issueViewLogEntity.Month);
db.AddInParameter(cmd, "@IP", DbType.AnsiString, issueViewLogEntity.IP);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public List <IssueViewLogEntity> MakeIssueViewLogList(DataTable dt)
{
List <IssueViewLogEntity> list = new List <IssueViewLogEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
IssueViewLogEntity issueViewLogEntity = MakeIssueViewLog(dt.Rows[i]);
list.Add(issueViewLogEntity);
}
}
return(list);
}
public IssueViewLogEntity GetIssueViewLog(Int64 viewLogID)
{
IssueViewLogEntity issueViewLogEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 ViewLogID,JournalID,ContentID,AuthorID,Daytime,Year,Month,IP,AddDate FROM dbo.IssueViewLog WITH(NOLOCK)");
sqlCommandText.Append(" WHERE ViewLogID=@ViewLogID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@ViewLogID", DbType.Int64, viewLogID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
issueViewLogEntity = MakeIssueViewLog(dr);
}
return(issueViewLogEntity);
}
public IssueViewLogEntity MakeIssueViewLog(DataRow dr)
{
IssueViewLogEntity issueViewLogEntity = null;
if (dr != null)
{
issueViewLogEntity = new IssueViewLogEntity();
issueViewLogEntity.ViewLogID = (Int64)dr["ViewLogID"];
issueViewLogEntity.JournalID = (Int64)dr["JournalID"];
issueViewLogEntity.ContentID = (Int64)dr["ContentID"];
issueViewLogEntity.AuthorID = (Int64)dr["AuthorID"];
issueViewLogEntity.Daytime = (Int32)dr["Daytime"];
issueViewLogEntity.Year = (Int32)dr["Year"];
issueViewLogEntity.Month = (Int32)dr["Month"];
issueViewLogEntity.IP = (String)dr["IP"];
issueViewLogEntity.AddDate = Convert.IsDBNull(dr["AddDate"]) ? null : (DateTime?)dr["AddDate"];
}
return(issueViewLogEntity);
}
public List <IssueViewLogEntity> MakeIssueViewLogList(IDataReader dr)
{
List <IssueViewLogEntity> list = new List <IssueViewLogEntity>();
while (dr.Read())
{
IssueViewLogEntity issueViewLogEntity = new IssueViewLogEntity();
issueViewLogEntity.ViewLogID = (Int64)dr["ViewLogID"];
issueViewLogEntity.JournalID = (Int64)dr["JournalID"];
issueViewLogEntity.ContentID = (Int64)dr["ContentID"];
issueViewLogEntity.AuthorID = (Int64)dr["AuthorID"];
issueViewLogEntity.Daytime = (Int32)dr["Daytime"];
issueViewLogEntity.Year = (Int32)dr["Year"];
issueViewLogEntity.Month = (Int32)dr["Month"];
issueViewLogEntity.IP = (String)dr["IP"];
issueViewLogEntity.AddDate = Convert.IsDBNull(dr["AddDate"]) ? null : (DateTime?)dr["AddDate"];
list.Add(issueViewLogEntity);
}
dr.Close();
return(list);
}
/// <summary>
/// 查看期刊
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult Show(long ID)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve <IIssueFacadeService>();
IssueContentQuery contentQuery = new IssueContentQuery();
contentQuery.JournalID = JournalID;
contentQuery.contentID = ID;
IssueContentEntity contentEntity = service.GetIssueContentModel(contentQuery);
if (contentEntity == null)
{
contentEntity = new IssueContentEntity();
}
else
{
service.UpdateIssueContentHits(contentQuery);
# region 记录浏览日志
if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["RecodeViewLog"]))
{
try
{
IssueViewLogEntity issueLogEntity = new IssueViewLogEntity();
issueLogEntity.ContentID = ID;
issueLogEntity.JournalID = JournalID;
issueLogEntity.IP = Utils.GetRealIP();
issueLogEntity.Daytime = TypeParse.ToInt(DateTime.Now.ToString("yyyyMMdd"));
issueLogEntity.Year = DateTime.Now.Year;
issueLogEntity.Month = DateTime.Now.Month;
issueLogEntity.AuthorID = 0;
service.SaveViewLog(issueLogEntity);
}
catch
{
}
}
# endregion
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="issueViewLog">IssueViewLogEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddIssueViewLog(IssueViewLogEntity issueViewLog)
{
return(IssueViewLogDataAccess.Instance.AddIssueViewLog(issueViewLog));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="issueViewLog">IssueViewLogEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddIssueViewLog(IssueViewLogEntity issueViewLog)
{
return(IssueViewLogBusProvider.AddIssueViewLog(issueViewLog));
}
