/// <summary>
/// 编辑期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <returns></returns>
public bool UpdateIssueReference(IssueReferenceEntity issueReferenceEntity, DbTransaction trans = null)
{
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" ReferenceID=@ReferenceID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" Title=@Title");
sqlCommandText.Append(", RefUrl=@RefUrl");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.IssueReference SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@ReferenceID", DbType.Int64, issueReferenceEntity.ReferenceID);
db.AddInParameter(cmd, "@Title", DbType.AnsiString, issueReferenceEntity.Title.TextFilter());
db.AddInParameter(cmd, "@RefUrl", DbType.AnsiString, issueReferenceEntity.RefUrl.TextFilter());
try
{
bool result = false;
if (trans == null)
result = db.ExecuteNonQuery(cmd) > 0;
else
result = db.ExecuteNonQuery(cmd, trans) > 0;
if (!result)
throw new Exception("编辑期刊参考文献失败！");
return result;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 组装参考文献数据
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private IssueReferenceEntity MakeIssueReferenceInfo(IDataReader dr)
{
IssueReferenceEntity issueReferenceEntity = new IssueReferenceEntity();
issueReferenceEntity.ReferenceID = (Int64)dr["ReferenceID"];
issueReferenceEntity.ContentID = (Int64)dr["ContentID"];
issueReferenceEntity.JournalID = (Int64)dr["JournalID"];
issueReferenceEntity.Title = Convert.IsDBNull(dr["Title"]) ? null : (String)dr["Title"];
issueReferenceEntity.RefUrl = Convert.IsDBNull(dr["RefUrl"]) ? null : (String)dr["RefUrl"];
issueReferenceEntity.AddDate = (DateTime)dr["AddDate"];
return issueReferenceEntity;
}
/// <summary>
/// 编辑期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <returns></returns>
public bool UpdateIssueReference(IssueReferenceEntity issueReferenceEntity)
{
return IssueDataAccess.Instance.UpdateIssueReference(issueReferenceEntity);
}
/// <summary>
/// 新增期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <param name="trans"></param>
/// <returns></returns>
public bool AddIssueReference(IssueReferenceEntity issueReferenceEntity, DbTransaction trans = null)
{
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @ContentID");
sqlCommandText.Append(", @JournalID");
sqlCommandText.Append(", @Title");
sqlCommandText.Append(", @RefUrl");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.IssueReference ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@ContentID", DbType.Int64, issueReferenceEntity.ContentID);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, issueReferenceEntity.JournalID);
db.AddInParameter(cmd, "@Title", DbType.AnsiString, issueReferenceEntity.Title.TextFilter());
db.AddInParameter(cmd, "@RefUrl", DbType.AnsiString, issueReferenceEntity.RefUrl.TextFilter());
try
{
bool result = false;
if (trans == null)
result = db.ExecuteNonQuery(cmd) > 0;
else
result = db.ExecuteNonQuery(cmd, trans) > 0;
if (!result)
throw new Exception("新增期刊参考文献失败！");
return result;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 编辑期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <returns></returns>
public bool UpdateIssueReference(IssueReferenceEntity issueReferenceEntity)
{
return(IssueBusProvider.UpdateIssueReference(issueReferenceEntity));
}
/// <summary>
/// 新增期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <param name="trans"></param>
/// <returns></returns>
public bool AddIssueReference(IssueReferenceEntity issueReferenceEntity)
{
return IssueDataAccess.Instance.AddIssueReference(issueReferenceEntity);
}
/// <summary>
/// 新增期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <param name="trans"></param>
/// <returns></returns>
public bool AddIssueReference(IssueReferenceEntity issueReferenceEntity)
{
return(IssueBusProvider.AddIssueReference(issueReferenceEntity));
}
/// <summary>
/// 编辑期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <returns></returns>
public bool UpdateIssueReference(IssueReferenceEntity issueReferenceEntity)
{
return IssueBusProvider.UpdateIssueReference(issueReferenceEntity);
}
/// <summary>
/// 新增期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <param name="trans"></param>
/// <returns></returns>
public bool AddIssueReference(IssueReferenceEntity issueReferenceEntity)
{
return IssueBusProvider.AddIssueReference(issueReferenceEntity);
}
/// <summary>
/// 编辑期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <returns></returns>
public bool UpdateIssueReference(IssueReferenceEntity issueReferenceEntity)
{
return(IssueDataAccess.Instance.UpdateIssueReference(issueReferenceEntity));
}
/// <summary>
/// 新增期刊参考文献
/// </summary>
/// <param name="issueReferenceEntity"></param>
/// <param name="trans"></param>
/// <returns></returns>
public bool AddIssueReference(IssueReferenceEntity issueReferenceEntity)
{
return(IssueDataAccess.Instance.AddIssueReference(issueReferenceEntity));
}
