public static DataTable GetArticleItems(int ArticleID, ArticleItemStatus status)
{
ForumArticleItems FAItems = new ForumArticleItems();
if (status != ArticleItemStatus.All)
{
FAItems.Status = (int)status;
}
FAItems.ArticleID = ArticleID;
return(FAItems.LoadItemsByParams().Tables[0]);
}
public static void UpdateArticleItem(int ArticleItemID, int ArticleID, string Subject, string Reply, ArticleItemStatus status)
{
SqlConnection conn = CARETTA.DBI.DBHelper.getConnection();
conn.Open();
SqlTransaction Tran = conn.BeginTransaction(IsolationLevel.Serializable);
try
{
ForumArticleItems mArticleItem = new ForumArticleItems();
mArticleItem.Load(ArticleItemID);
bool StatusChanged = false;
if (mArticleItem.Status != (int)status)
{
StatusChanged = true;
}
mArticleItem.Reply = Reply;
mArticleItem.Status = (int)status;
mArticleItem.Subject = Subject;
mArticleItem.Save();
ForumArticle mArticle = new ForumArticle();
mArticle.Load(ArticleID);
mArticle.ArticleMessage = Reply;
mArticle.ArticleSubject = Subject;
mArticle.Save();
if (StatusChanged)
{
ForumArticle.ArrangeArticle(mArticleItem.ArticleID);
}
Tran.Commit();
}
catch (Exception ex)
{
Tran.Rollback();
throw;
}
finally
{
conn.Close();
}
}
public static int InsertArticleItem(int CategoryID, int ArticleID, string Subject, string Reply, ArticleItemStatus status, int UserID, string NickName)
{
SqlConnection conn = CARETTA.DBI.DBHelper.getConnection();
conn.Open();
SqlTransaction Tran = conn.BeginTransaction(IsolationLevel.Serializable);
int ArticleItemID;
try
{
DateTime CreateDate = DateTime.Now;
string LastPost = LastPostTemplate.Replace("||MemberID||", UserID.ToString()).Replace("||NickName||", NickName).Replace("||Date||", CreateDate.ToShortDateString() + " " + CreateDate.ToShortTimeString());
ForumArticleItems mArticleItem = new ForumArticleItems();
mArticleItem.ArticleID = ArticleID;
mArticleItem.CreateDate = CreateDate;
mArticleItem.CreatedBy = UserID;
mArticleItem.Reply = Reply;
mArticleItem.Score = 0;
mArticleItem.ScoreCount = 0;
mArticleItem.Status = (int)status;
mArticleItem.Subject = Subject;
mArticleItem.Save();
ArticleItemID = mArticleItem.ArticleItemID;
ForumArticle mArticle = new ForumArticle();
mArticle.Load(ArticleID);
mArticle.LastPost = LastPost;
mArticle.LastPostDate = CreateDate;
mArticle.Replies += 1;
mArticle.Save();
ForumCategory mCategory = new ForumCategory();
mCategory.Load(CategoryID);
mCategory.LastPost = LastPost;
mCategory.LastPostDate = CreateDate;
mCategory.Save();
Tran.Commit();
}
catch (Exception ex)
{
Tran.Rollback();
throw;
}
finally
{
conn.Close();
}
return(ArticleItemID);
}
public static string GetArticleItemStatusDesc(ArticleItemStatus status)
{
return(ArticleItemStatusDesc[(int)status]);
}