public ForumModeratorInfo GetById(int id)
{
ForumModeratorInfo moderator = null;
string sqlStr =
"SELECT FM.MOD_ID, FM.FORUM_ID,FM.MEMBER_ID,FM.MOD_TYPE,M.M_NAME FROM " +
Config.ForumTablePrefix + "MODERATOR FM LEFT OUTER JOIN " + Config.MemberTablePrefix + "MEMBERS M ON FM.MEMBER_ID = M.MEMBER_ID " +
"WHERE FM.MOD_ID=@ModId";
SqlParameter parm = new SqlParameter("@ModId", SqlDbType.VarChar)
{
Value = id
};
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sqlStr, parm))
{
while (rdr.Read())
{
moderator = new ForumModeratorInfo
{
Id = rdr.GetInt32(0),
ForumId = rdr.GetInt32(1),
MemberId = rdr.GetInt32(2),
Type = rdr.GetInt32(3),
Name = rdr.SafeGetString(4)
};
}
}
return(moderator);
}
public void Delete(ForumModeratorInfo forumModerator)
{
string sqlStr = "";
if (forumModerator.Id > 0)
{
sqlStr = "DELETE FROM " + Config.ForumTablePrefix + "MODERATOR WHERE MOD_ID=@Id";
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sqlStr, new SqlParameter("@Id", SqlDbType.Int)
{
Value = forumModerator.Id
});
}
else if (forumModerator.MemberId > 0 && forumModerator.ForumId > 0)
{
sqlStr = "DELETE FROM " + Config.ForumTablePrefix + "MODERATOR WHERE MEMBER_ID=@Id AND FORUM_ID=@ForumId";
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter("@Id", SqlDbType.Int)
{
Value = forumModerator.MemberId
},
new SqlParameter("@ForumId", SqlDbType.Int)
{
Value = forumModerator.ForumId
}
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sqlStr, parms.ToArray());
}
}
public static void AddForumModerator(int forumid, int memberid)
{
ForumModeratorInfo moderator = new ForumModeratorInfo {
ForumId = forumid, MemberId = memberid
};
IForumModerator dal = Factory <IForumModerator> .Create("ForumModerator");
dal.Add(moderator);
}
protected void ModeratorBind(object sender, ListViewItemEventArgs e)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ForumModeratorInfo fm = (ForumModeratorInfo)dataItem.DataItem;
if (!String.IsNullOrEmpty(hdnModerators.Value))
{
hdnModerators.Value += ",";
}
hdnModerators.Value += fm.MemberId;
}
}
public void SetUserAsModeratorForForums(int memberId, int[] forumList)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM FORUM_MODERATOR WHERE MEMBER_ID=@MemberId", new SqlParameter("@MemberId", SqlDbType.Int)
{
Value = memberId
});
foreach (int forum in forumList)
{
ForumModeratorInfo mod = new ForumModeratorInfo {
ForumId = forum, MemberId = memberId
};
Add(mod);
}
}
public void SetForumModerators(int forumId, int[] userList)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM FORUM_MODERATOR WHERE FORUM_ID=@ForumId", new SqlParameter("@ForumId", SqlDbType.Int)
{
Value = forumId
});
foreach (int user in userList)
{
ForumModeratorInfo mod = new ForumModeratorInfo {
ForumId = forumId, MemberId = user
};
Add(mod);
}
}
public void SetUserAsModeratorForForums(int memberId, int[] forumList)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM " + Config.ForumTablePrefix + "MODERATOR WHERE MEMBER_ID=@MemberId", new OleDbParameter("@MemberId", OleDbType.Numeric)
{
Value = memberId
});
foreach (int forum in forumList)
{
ForumModeratorInfo mod = new ForumModeratorInfo {
ForumId = forum, MemberId = memberId
};
Add(mod);
}
}
public void SetForumModerators(int forumId, int[] userList)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM " + Config.ForumTablePrefix + "MODERATOR WHERE FORUM_ID=@ForumId", new OleDbParameter("@ForumId", OleDbType.Numeric)
{
Value = forumId
});
foreach (int user in userList)
{
ForumModeratorInfo mod = new ForumModeratorInfo {
ForumId = forumId, MemberId = user
};
Add(mod);
}
}
public int Add(ForumModeratorInfo forumModerator)
{
string sqlStr = "INSERT INTO " + Config.ForumTablePrefix + "MODERATOR (FORUM_ID,MEMBER_ID,MOD_TYPE) VALUES (@ForumId,@MemberId,0)";
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter("@ForumId", SqlDbType.Int)
{
Value = forumModerator.ForumId
},
new SqlParameter("@MemberId", SqlDbType.Int)
{
Value = forumModerator.MemberId
}
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, sqlStr, parms.ToArray())));
}
/// <summary>
/// 添加版主
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddModerator(ForumModeratorInfo model)
{
string strSQL = @"INSERT INTO ForumModerators(UserId,UserName,ForumId,CreateDateTime)
SELECT @UserId,@UserName,@ForumId,GETDATE() WHERE NOT EXISTS(
SELECT * FROM ForumModerators AS FMB WITH(NOLOCK)
WHERE @UserId= FMB.UserID AND @ForumId = FMB.ForumId
);SELECT @@ROWCOUNT;";
SqlParameter[] parms =
{
new SqlParameter("UserId", SqlDbType.Int),
new SqlParameter("UserName", SqlDbType.NVarChar),
new SqlParameter("ForumId", SqlDbType.Int),
};
parms[0].Value = model.UserId;
parms[1].Value = model.UserName;
parms[2].Value = model.ForumId;
return(Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)) > 0);
}
public void Update(ForumModeratorInfo forumModerator)
{
string sqlStr = "UPDATE " + Config.ForumTablePrefix + "MODERATOR SET FORUM_ID=@ForumId,MEMBER_ID=@MemberId WHERE MOD_ID=@ModId";
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter("@ModId", SqlDbType.Int)
{
Value = forumModerator.Id
},
new SqlParameter("@ForumId", SqlDbType.Int)
{
Value = forumModerator.ForumId
},
new SqlParameter("@MemberId", SqlDbType.Int)
{
Value = forumModerator.MemberId
}
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sqlStr, parms.ToArray());
}
public static void AddForumModerators(int forumid, string[] moderators, string[] remove)
{
//todo: needs testing
IForumModerator dal = Factory <IForumModerator> .Create("ForumModerator");
//get rid of any duplicates
string[] mods = moderators.Distinct().ToArray();
string[] removemods = remove.Distinct().ToArray();
foreach (string moderator in mods)
{
int modid = Convert.ToInt32(moderator);
if (!dal.IsUserForumModerator(modid, forumid))
{
ForumModeratorInfo mod = new ForumModeratorInfo
{
ForumId = forumid,
MemberId = modid
};
dal.Add(mod);
}
}
foreach (string removemod in removemods)
{
int modid = Convert.ToInt32(removemod);
if (dal.IsUserForumModerator(modid, forumid))
{
ForumModeratorInfo mod = new ForumModeratorInfo
{
ForumId = forumid,
MemberId = modid
};
dal.Delete(mod);
}
}
}
public static void RemoveForumModerator(ForumModeratorInfo moderator)
{
IForumModerator dal = Factory <IForumModerator> .Create("ForumModerator");
dal.Delete(moderator);
}
/// <summary>
/// 添加版主
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddModerator(ForumModeratorInfo model)
{
return(ForumManage.AddModerator(model));
}
