private void ShowInfo(int _id)
{
BLL.forum_posts bll = new BLL.forum_posts();
Model.forum_posts model = bll.GetModel(id);
DTcms.BLL.users ubll = new DTcms.BLL.users();
DTcms.Model.users umodel = ubll.GetModel(model.user_id);
ddlCategoryId.SelectedValue = model.board_id.ToString();
txtUserName.Text = umodel.user_name;
txtUserName.ReadOnly = true;
if (model.is_lock == 1)
{
cblItem.Items[0].Selected = true;
}
if (model.is_top == 1)
{
cblItem.Items[1].Selected = true;
}
if (model.is_red == 1)
{
cblItem.Items[2].Selected = true;
}
if (model.is_hot == 1)
{
cblItem.Items[3].Selected = true;
}
txtPostName.Text = model.title;
txtPostContent.Value = model.content;
}
/// <summary>
/// 获取统计数据，首页中的计数，每减少数据库的操作，每24小时实际读取一次数据库,参数默认 false 不用强制更新数据
/// </summary>
/// <param name="bol"></param>
public void GetStatistics(bool bol = false)
{
DateTime dt = DateTime.Now;
TimeSpan ts = dt - Model.Statistic.RefreshTime;
if (ts.TotalSeconds > 86400.0)
{
bol = true;
}
if (bol)
{
Model.Statistic.TotalUser = new BLL.Forum_UserExtended().GetTotal(" 1=1 ");
//贴子
Model.Statistic.TotalPost = new BLL.Forum_Topic().GetTotal(" 1=1 ");
//昨日
Model.Statistic.YesterdayPost = new BLL.Forum_Topic().GetTotal(" PostDatetime>'" + System.DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 00:00:01") + "' and PostDatetime<'" + System.DateTime.Now.ToString("yyyy-MM-dd 00:00:01") + "' ");
//今日
Model.Statistic.TodayPost = new BLL.Forum_Topic().GetTotal(" PostDatetime>'" + System.DateTime.Now.ToString("yyyy-MM-dd 00:00:01") + "' ");
System.Data.DataTable dtUser = new DTcms.BLL.users().GetList(1, " status=0 ", " id desc ").Tables[0];
if (dtUser.Rows.Count != 0)
{
Model.Statistic.LastUserId = Convert.ToInt32(dtUser.Rows[0]["id"].ToString());
Model.Statistic.LastUserNickname = string.IsNullOrEmpty(dtUser.Rows[0]["nick_name"].ToString()) ? dtUser.Rows[0]["user_name"].ToString() : dtUser.Rows[0]["nick_name"].ToString();
}
Model.Statistic.RefreshTime = System.DateTime.Now;
}
}
private bool DoAdd()
{
bool result = false;
BLL.forum_posts bll = new BLL.forum_posts();
Model.forum_posts model = new Model.forum_posts();
DTcms.BLL.users ubll = new DTcms.BLL.users();
DTcms.Model.users umodel = new DTcms.Model.users();
//判断用户名是否存在
if (!ubll.Exists(txtUserName.Text.Trim()))
{
JscriptMsg("用户名不存在，请重新填写！", "");
return(result);
}
umodel = ubll.GetModel(txtUserName.Text.Trim());
string _userip = System.Web.HttpContext.Current.Request.UserHostAddress;
model.class_layer = 1;
model.title = txtPostName.Text.Trim();
model.content = txtPostContent.Value;
model.user_id = umodel.id;
model.user_ip = _userip;
model.board_id = Utils.StrToInt(ddlCategoryId.SelectedValue, 0);
model.parent_post_id = 0;
model.post_type = 1;//主题帖
model.reply_time = DateTime.Now;
model.click = 0;
model.is_lock = 0;
model.is_top = 0;
model.is_red = 0;
model.is_hot = 0;
if (cblItem.Items[0].Selected == true)
{
model.is_lock = 1;
}
if (cblItem.Items[1].Selected == true)
{
model.is_top = 1;
}
if (cblItem.Items[2].Selected == true)
{
model.is_red = 1;
}
if (cblItem.Items[3].Selected == true)
{
model.is_hot = 1;
}
model.add_time = DateTime.Now;
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "发布了帖子：" + model.title); //记录日志
result = true;
}
return(result);
}
public string get_user_name(int userid)
{
DTcms.Model.users model = new DTcms.BLL.users().GetModel(userid);
if (model == null)
{
return("-");
}
return(model.user_name);
}
private void set_lock(HttpContext context)
{
//检查用户是否登录
DTcms.Model.users umodel = new DTcms.Web.UI.BasePage().GetUserInfo();
if (umodel == null)
{
context.Response.Write("{\"status\":0, \"msg\":\"请登录后再提交！\"}");
return;
}
StringBuilder strTxt = new StringBuilder();
BLL.forum_posts bll = new BLL.forum_posts();
Model.forum_posts model = new Model.forum_posts();
int post_id = DTRequest.GetFormInt("postid");
string optip = DTRequest.GetFormString("optip");
string opremark = DTRequest.GetFormString("opremark");
model = bll.GetModel(post_id);
//检查是否是版主
if (!IsModerator(model.board_id, umodel.id))
{
context.Response.Write("{\"status\":0, \"msg\":\"对不起，你无权进行此操作！\"}");
return;
}
string strSet = "is_lock=0";
if (model.is_lock == 0)
{
strSet = "is_lock=1";
}
bll.UpdateField(post_id, strSet);
//发送短信息
string postusername = new DTcms.BLL.users().GetModel(model.user_id).user_name;
new DTcms.BLL.user_message().Add(1, string.Empty, postusername, "您发布的帖子被管理员进行操作", "您的帖子被管理员进行 " + optip + " 操作，原因：" + opremark);
new DTcms.Web.UI.ManagePage().AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "锁定帖子:" + opremark); //记录日志
context.Response.Write("{\"status\": 1, \"msg\": \"恭喜您，操作成功！\"}");
return;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("plugin_forum_moderator", DTEnums.ActionEnum.Add.ToString()); //检查权限
Model.Forum_Moderator model = new Model.Forum_Moderator();
BLL.Forum_Moderator bll = new BLL.Forum_Moderator();
DTcms.Model.users modelUser = new DTcms.BLL.users().GetModel(txtUsername.Text.Replace("'", ""));
if (modelUser != null)
{
Model.Forum_UserExtended modelExtended = new BLL.Forum_UserExtended().GetModel(modelUser.id);
if (modelExtended != null)
{
//编写添加操作Begin
model.BoardId = this.board_id;
model.GroupId = Convert.ToInt32(ddlGroupId.SelectedValue);
model.UserId = modelUser.id;
model.Username = modelUser.user_name;
model.Nickname = modelUser.nick_name;
//编写添加操作End
bll.Add(model);
modelExtended.GroupId = Convert.ToInt32(ddlGroupId.SelectedValue);
new BLL.Forum_UserExtended().Update(modelExtended);
JscriptMsg("添加信息成功！", Utils.CombUrlTxt("moderator_list.aspx", "board_id={0}", this.board_id.ToString()));
}
else
{
JscriptMsg("该会员未从DTcms中同步！", "");
return;
}
}
else
{
JscriptMsg("会员不存在！", "");
return;
}
}
public void ProcessRequest(HttpContext context)
{
//取得处事类型
int uid = DTRequest.GetQueryInt("uid", 0);
int size = DTRequest.GetQueryInt("size", 50);
DTcms.Model.users userModel = new DTcms.BLL.users().GetModel(uid);
string _avatar = "/plugins/forum/templet/Default/Images/avatar_none_" + size + ".jpg";
if (userModel != null)
{
if (!string.IsNullOrEmpty(userModel.avatar))
{
_avatar = userModel.avatar;
}
}
context.Response.Redirect(_avatar);
}
private void del(HttpContext context)
{
//检查用户是否登录
DTcms.Model.users umodel = new DTcms.Web.UI.BasePage().GetUserInfo();
if (umodel == null)
{
context.Response.Write("{\"status\":0, \"msg\":\"请登录后再提交！\"}");
return;
}
BLL.forum_posts bll = new BLL.forum_posts();
Model.forum_posts model = new Model.forum_posts();
int post_id = DTRequest.GetFormInt("postid");
string optip = DTRequest.GetFormString("optip");
string opremark = DTRequest.GetFormString("opremark");
model = bll.GetModel(post_id);
//检查是否是版主
if (!IsModerator(model.board_id, umodel.id))
{
context.Response.Write("{\"status\":0, \"msg\":\"当前用户无权执行此操作！\"}");
return;
}
if (bll.Delete(post_id))
{
//发送短信息
string postusername = new DTcms.BLL.users().GetModel(model.user_id).user_name;
new DTcms.BLL.user_message().Add(1, string.Empty, postusername, "您发布的帖子被管理员进行操作", "您的帖子被管理员进行 " + optip + " 操作，原因：" + opremark);
new DTcms.Web.UI.ManagePage().AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除帖子:" + opremark); //记录日志
context.Response.Write("{\"status\": 1, \"msg\": \"恭喜您，删除帖子成功！\"}");
return;
}
context.Response.Write("{\"status\": 0, \"msg\": \"对不起，保存过程中发生错误！\"}");
return;
}
//判断是否是版主
public bool IsModerator(int boardid, int userid)
{
bool is_moderator = false;
Model.forum_board bmodel = new Model.forum_board();
DTcms.Model.users umodel = new DTcms.BLL.users().GetModel(userid);
int bid = int.Parse(new board().get_category_id(boardid));
string auid = new BLL.forum_board().GetModel(bid).moderator_list;
auid += ",";
string[] mlist = auid.Split(',');
foreach (string item in mlist)
{
if (item != "" && item == umodel.user_name)
{
is_moderator = true;
}
}
return(is_moderator);
}
private void user_credit_convert(HttpContext context)
{
//检查系统是否启用兑换金币功能
if (DTcms.Web.Plugin.Forum.Global.RateExchange == 0)
{
context.Response.Write("{\"status\":0, \"msg\":\"对不起，网站未开启兑换金币功能！\"}");
return;
}
if (modelUser == null)
{
context.Response.Write("{\"status\":0, \"msg\":\"对不起，用户尚未登录或已超时！\"}");
return;
}
int credit = DTRequest.GetFormInt("txtCredit");
string password = DTRequest.GetFormString("txtPassword");
if (modelUser.Credit < DTcms.Web.Plugin.Forum.Global.RateExchange)
{
context.Response.Write("{\"status\":0, \"msg\":\"对不起，您论坛金币不足！\"}");
return;
}
if (modelUser.Credit < DTcms.Web.Plugin.Forum.Global.RateExchange)
{
context.Response.Write("{\"status\":0, \"msg\":\"对不起，最小兑换金币为" + DTcms.Web.Plugin.Forum.Global.RateExchange + "币！\"}");
return;
}
if (credit > modelUser.Credit)
{
context.Response.Write("{\"status\":0, \"msg\":\"对不起，您输入的兑换的额度大于账户上的论坛余额！\"}");
return;
}
if (password == "")
{
context.Response.Write("{\"status\":0, \"msg\":\"对不起，请输入您账户的密码！\"}");
return;
}
DTcms.Model.users model = new DTcms.BLL.users().GetModel(modelUser.UserId);
//验证密码
if (DESEncrypt.Encrypt(password, model.salt) != model.password)
{
context.Response.Write("{\"status\":0, \"msg\":\"对不起，您输入的密码不正确！\"}");
return;
}
BLL.Forum_UserExtended bllUser = new BLL.Forum_UserExtended();
bllUser.UpdateField(modelUser.UserId, " Credit=Credit-" + credit + " ");
//计算兑换后的积分值
int convertPoint = (int)(Convert.ToDecimal(credit) / DTcms.Web.Plugin.Forum.Global.RateExchange);
//增加积分
int pointNewId = new DTcms.BLL.user_point_log().Add(model.id, model.user_name, convertPoint, "用户兑换论坛金币", true);
//重新计算组
HttpContext.Current.Session["SESSION_USER_EXTENDED"] = bllUser.SetGroupId(modelUser);
context.Response.Write("{\"status\":1, \"msg\":\"恭喜您，积分兑换成功！\"}");
return;
}
public DTcms.Model.users get_user_model(int userid)
{
DTcms.Model.users model = new DTcms.BLL.users().GetModel(userid);
return(model);
}
