public bool AddIssueDownLog(IssueDownLogEntity issueDownLogEntity)
{
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.IssueDownLog ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, issueDownLogEntity.JournalID);
db.AddInParameter(cmd, "@ContentID", DbType.Int64, issueDownLogEntity.ContentID);
db.AddInParameter(cmd, "@AuthorID", DbType.Int64, issueDownLogEntity.AuthorID);
db.AddInParameter(cmd, "@Daytime", DbType.Int32, issueDownLogEntity.Daytime);
db.AddInParameter(cmd, "@Year", DbType.Int32, issueDownLogEntity.Year);
db.AddInParameter(cmd, "@Month", DbType.Int32, issueDownLogEntity.Month);
db.AddInParameter(cmd, "@IP", DbType.AnsiString, issueDownLogEntity.IP);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public JsonResult DownStat(long CID)
{
try
{
IssueContentQuery issueCQuery = new IssueContentQuery();
issueCQuery.contentID = CID;
issueCQuery.JournalID = JournalID;
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve <IIssueFacadeService>();
IssueContentEntity issueEntity = service.GetIssueContentModel(issueCQuery);
if (issueEntity == null)
{
return(Json(new { flag = "NOfile" }));
}
else
{
if (!string.IsNullOrEmpty(issueEntity.FilePath))
{
string downPath = GetUploadPath(issueEntity.FilePath);
if (!System.IO.File.Exists(downPath))
{
return(Json(new { flag = "NOfile" }));
}
//更新下载次数
service.UpdateIssueContentDownloads(issueCQuery);
# region 记录下载日志
try
{
IssueDownLogEntity issueLogEntity = new IssueDownLogEntity();
issueLogEntity.ContentID = CID;
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.SaveDownloadLog(issueLogEntity);
}
catch
{
}
# endregion
return(Json(new { flag = "success", URL = "http://" + Request.Url.Host + issueEntity.FilePath }));
}
else
{
return(Json(new { flag = "NOfile" }));
}
}
public List <IssueDownLogEntity> MakeIssueDownLogList(DataTable dt)
{
List <IssueDownLogEntity> list = new List <IssueDownLogEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
IssueDownLogEntity issueDownLogEntity = MakeIssueDownLog(dt.Rows[i]);
list.Add(issueDownLogEntity);
}
}
return(list);
}
public IssueDownLogEntity GetIssueDownLog(Int64 downLogID)
{
IssueDownLogEntity issueDownLogEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 DownLogID,JournalID,ContentID,AuthorID,Daytime,Year,Month,IP,AddDate FROM dbo.IssueDownLog WITH(NOLOCK)");
sqlCommandText.Append(" WHERE DownLogID=@DownLogID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@DownLogID", DbType.Int64, downLogID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
issueDownLogEntity = MakeIssueDownLog(dr);
}
return(issueDownLogEntity);
}
public IssueDownLogEntity MakeIssueDownLog(DataRow dr)
{
IssueDownLogEntity issueDownLogEntity = null;
if (dr != null)
{
issueDownLogEntity = new IssueDownLogEntity();
issueDownLogEntity.DownLogID = (Int64)dr["DownLogID"];
issueDownLogEntity.JournalID = (Int64)dr["JournalID"];
issueDownLogEntity.ContentID = (Int64)dr["ContentID"];
issueDownLogEntity.AuthorID = (Int64)dr["AuthorID"];
issueDownLogEntity.Daytime = (Int32)dr["Daytime"];
issueDownLogEntity.Year = (Int32)dr["Year"];
issueDownLogEntity.Month = (Int32)dr["Month"];
issueDownLogEntity.IP = (String)dr["IP"];
issueDownLogEntity.AddDate = (DateTime)dr["AddDate"];
}
return(issueDownLogEntity);
}
public List <IssueDownLogEntity> MakeIssueDownLogList(IDataReader dr)
{
List <IssueDownLogEntity> list = new List <IssueDownLogEntity>();
while (dr.Read())
{
IssueDownLogEntity issueDownLogEntity = new IssueDownLogEntity();
issueDownLogEntity.DownLogID = (Int64)dr["DownLogID"];
issueDownLogEntity.JournalID = (Int64)dr["JournalID"];
issueDownLogEntity.ContentID = (Int64)dr["ContentID"];
issueDownLogEntity.AuthorID = (Int64)dr["AuthorID"];
issueDownLogEntity.Daytime = (Int32)dr["Daytime"];
issueDownLogEntity.Year = (Int32)dr["Year"];
issueDownLogEntity.Month = (Int32)dr["Month"];
issueDownLogEntity.IP = (String)dr["IP"];
issueDownLogEntity.AddDate = (DateTime)dr["AddDate"];
list.Add(issueDownLogEntity);
}
dr.Close();
return(list);
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="issueDownLog">IssueDownLogEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddIssueDownLog(IssueDownLogEntity issueDownLog)
{
return(IssueDownLogBusProvider.AddIssueDownLog(issueDownLog));
}
