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