/// <summary> /// 得到一个对象实体 /// </summary> public Model.Forum_Moderator DataRowToModel(DataRow row) { if (row != null) { Model.Forum_Moderator model = new Model.Forum_Moderator(); if (row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["BoardId"].ToString() != "") { model.BoardId = int.Parse(row["BoardId"].ToString()); } if (row["GroupId"].ToString() != "") { model.GroupId = int.Parse(row["GroupId"].ToString()); } if (row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } model.Username = row["Username"].ToString(); model.Nickname = row["Nickname"].ToString(); return(model); } else { return(null); } }
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; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Forum_Moderator model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "Forum_Moderator set "); strSql.Append(" BoardId = @BoardId , "); strSql.Append(" GroupId = @GroupId , "); strSql.Append(" UserId = @UserId , "); strSql.Append(" Username = @Username , "); strSql.Append(" Nickname = @Nickname "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@BoardId", SqlDbType.Int, 4), new SqlParameter("@GroupId", SqlDbType.Int, 4), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@Username", SqlDbType.NVarChar, 32), new SqlParameter("@Nickname", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.BoardId; parameters[2].Value = model.GroupId; parameters[3].Value = model.UserId; parameters[4].Value = model.Username; parameters[5].Value = model.Nickname; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Forum_Moderator model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "Forum_Moderator("); strSql.Append("BoardId,GroupId,UserId,Username,Nickname"); strSql.Append(") values ("); strSql.Append("@BoardId,@GroupId,@UserId,@Username,@Nickname"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@BoardId", SqlDbType.Int, 4), new SqlParameter("@GroupId", SqlDbType.Int, 4), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@Username", SqlDbType.NVarChar, 32), new SqlParameter("@Nickname", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.BoardId; parameters[1].Value = model.GroupId; parameters[2].Value = model.UserId; parameters[3].Value = model.Username; parameters[4].Value = model.Nickname; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Forum_Moderator model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Forum_Moderator model) { return(dal.Add(model)); }