//保存
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));
}
