//-------------------------------------------------------------------------------------------------------------------- public Articles Get(string LogFilePath, string LogFileName, int ArticleId) { Articles RetVal = new Articles(db.ConnectionString); try { List <Articles> list = GetListByArticleId(LogFilePath, LogFileName, ArticleId); if (list.Count > 0) { RetVal = (Articles)list[0]; } } catch (Exception ex) { LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name); } return(RetVal); }
//------------------------------------------------------------------------------------------------------------------------------- public string GetArticleLink(string LogFilePath, string LogFileName, string ROOT_PATH, string FILE_EXTEND, string CategoryName) { string RetVal = ""; try { Articles m_Articles = new Articles(this.db.ConnectionString); m_Articles = m_Articles.Get(LogFilePath, LogFileName, this.ArticleId); if (m_Articles.ArticleId > 0) { RetVal = m_Articles.GetArticleLink(LogFilePath, LogFileName, ROOT_PATH, FILE_EXTEND, CategoryName); } } catch (Exception ex) { LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name); } return(RetVal); }
//------------------------------------------------------------------------------------------------------------------- private List <Articles> Init(string LogFilePath, string LogFileName, SqlCommand cmd) { SqlConnection con = db.getConnection(); cmd.Connection = con; List <Articles> l_Articles = new List <Articles>(); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); SmartDataReader smartReader = new SmartDataReader(reader); while (smartReader.Read()) { Articles m_Articles = new Articles(db.ConnectionString); m_Articles.ArticleId = smartReader.GetInt32("ArticleId"); m_Articles.ArticleTitle = smartReader.GetString("ArticleTitle"); m_Articles.ArticleLead = smartReader.GetString("ArticleLead"); m_Articles.EditorStatusId = smartReader.GetByte("EditorStatusId"); m_Articles.CategoryId = smartReader.GetInt16("CategoryId"); m_Articles.AuthorUserId = smartReader.GetInt32("AuthorUserId"); m_Articles.AuthorDateTime = smartReader.GetDateTime("AuthorDateTime"); m_Articles.PublishDateTime = smartReader.GetDateTime("PublishDateTime"); m_Articles.ArticleSource = smartReader.GetString("ArticleSource"); m_Articles.MediaItemId = smartReader.GetInt32("MediaItemId"); m_Articles.CrUserId = smartReader.GetInt32("CrUserId"); m_Articles.CrDateTime = smartReader.GetDateTime("CrDateTime"); l_Articles.Add(m_Articles); } smartReader.disposeReader(reader); db.closeConnection(con); } catch (SqlException ex) { LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name); } return(l_Articles); }