//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("plugin_forum_boardactionpoint", DTEnums.ActionEnum.Add.ToString()); //检查权限 BLL.Forum_BoardActionPoint bll = new BLL.Forum_BoardActionPoint(); Repeater rptList = new Repeater(); rptList = this.rptList; for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); int intPoint; if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtPoint")).Text.Trim(), out intPoint)) { intPoint = 0; } int intEnable = 0; CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { intEnable = 1; } bool bol = bll.UpdateField("ActionId=" + id + " and BoardId=" + board_id, "Enable=" + intEnable + " , Point=" + intPoint.ToString()); if (bol == false) { Model.Forum_BoardActionPoint model = new Model.Forum_BoardActionPoint(); model.ActionId = id; model.BoardId = board_id; model.Enable = intEnable; model.Point = intPoint; bll.Add(model); } //同步所有版块 if (Convert.ToInt32(ddlSYN.SelectedValue) == 1) { bll.UpdateField("ActionId=" + id, " Point=" + intPoint.ToString()); } } JscriptMsg("操作成功!", "board_action_point_list.aspx?board_id=" + this.board_id); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Forum_BoardActionPoint model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "Forum_BoardActionPoint set "); strSql.Append(" Enable = @Enable , "); strSql.Append(" BoardId = @BoardId , "); strSql.Append(" GroupId = @GroupId , "); strSql.Append(" ActionId = @ActionId , "); strSql.Append(" Point = @Point "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Enable", SqlDbType.Int, 4), new SqlParameter("@BoardId", SqlDbType.Int, 4), new SqlParameter("@GroupId", SqlDbType.Int, 4), new SqlParameter("@ActionId", SqlDbType.Int, 4), new SqlParameter("@Point", SqlDbType.Money, 8) }; parameters[0].Value = model.Id; parameters[1].Value = model.Enable; parameters[2].Value = model.BoardId; parameters[3].Value = model.GroupId; parameters[4].Value = model.ActionId; parameters[5].Value = model.Point; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Forum_BoardActionPoint DataRowToModel(DataRow row) { if (row != null) { Model.Forum_BoardActionPoint model = new Model.Forum_BoardActionPoint(); if (row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["Enable"].ToString() != "") { model.Enable = int.Parse(row["Enable"].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["ActionId"].ToString() != "") { model.ActionId = int.Parse(row["ActionId"].ToString()); } if (row["Point"].ToString() != "") { model.Point = decimal.Parse(row["Point"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Forum_BoardActionPoint model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "Forum_BoardActionPoint("); strSql.Append("Enable,BoardId,GroupId,ActionId,Point"); strSql.Append(") values ("); strSql.Append("@Enable,@BoardId,@GroupId,@ActionId,@Point"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Enable", SqlDbType.Int, 4), new SqlParameter("@BoardId", SqlDbType.Int, 4), new SqlParameter("@GroupId", SqlDbType.Int, 4), new SqlParameter("@ActionId", SqlDbType.Int, 4), new SqlParameter("@Point", SqlDbType.Money, 8) }; parameters[0].Value = model.Enable; parameters[1].Value = model.BoardId; parameters[2].Value = model.GroupId; parameters[3].Value = model.ActionId; parameters[4].Value = model.Point; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Forum_BoardActionPoint model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Forum_BoardActionPoint model) { return(dal.Add(model)); }