private bool DoEdit(int _id)
{
bool result = false;
BLL.Forum_Group bll = new BLL.Forum_Group();
Model.Forum_Group model = bll.GetModel(_id);
//编写编辑操作Begin
model.Name = txtName.Text;
model.System = Convert.ToInt32(rblSystem.SelectedValue);
model.Type = Convert.ToInt32(ddlType.SelectedValue);
model.CreditLower = Convert.ToInt32(txtCreditLower.Text);
model.CreditHigher = Convert.ToInt32(txtCreditHigher.Text);
model.Color = txtColor.Text;
model.Image = txtImage.Text;
model.OnlineImage = txtOnlineImage.Text;
model.IsDefault = Convert.ToInt32(rblIsDefault.SelectedValue);
//编写编辑操作End
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改管理员:" + model.Name); //记录日志
result = true;
}
return(result);
}
private bool DoAdd()
{
Model.Forum_Group model = new Model.Forum_Group();
BLL.Forum_Group bll = new BLL.Forum_Group();
//编写添加操作Begin
model.Name = txtName.Text;
model.System = Convert.ToInt32(rblSystem.SelectedValue);
model.Type = Convert.ToInt32(ddlType.SelectedValue);
model.CreditLower = Convert.ToInt32(txtCreditLower.Text);
model.CreditHigher = Convert.ToInt32(txtCreditHigher.Text);
model.Color = txtColor.Text;
model.Image = txtImage.Text;
model.OnlineImage = txtOnlineImage.Text;
model.IsDefault = Convert.ToInt32(rblIsDefault.SelectedValue);
//编写添加操作End
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加dt_Forum_Group:"
+ model.Name); //记录日志
return(true);
}
return(false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Forum_Group model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "Forum_Group set ");
strSql.Append(" Name = @Name , ");
strSql.Append(" System = @System , ");
strSql.Append(" Type = @Type , ");
strSql.Append(" CreditLower = @CreditLower , ");
strSql.Append(" CreditHigher = @CreditHigher , ");
strSql.Append(" [Order] = @Order , ");
strSql.Append(" Color = @Color , ");
strSql.Append(" Image = @Image , ");
strSql.Append(" OnlineImage = @OnlineImage , ");
strSql.Append(" IsDefault = @IsDefault ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 32),
new SqlParameter("@System", SqlDbType.TinyInt, 1),
new SqlParameter("@Type", SqlDbType.TinyInt, 1),
new SqlParameter("@CreditLower", SqlDbType.Int, 4),
new SqlParameter("@CreditHigher", SqlDbType.Int, 4),
new SqlParameter("@Order", SqlDbType.Int, 4),
new SqlParameter("@Color", SqlDbType.NVarChar, 8),
new SqlParameter("@Image", SqlDbType.NVarChar, 256),
new SqlParameter("@OnlineImage", SqlDbType.NVarChar, 256),
new SqlParameter("@IsDefault", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Name;
parameters[2].Value = model.System;
parameters[3].Value = model.Type;
parameters[4].Value = model.CreditLower;
parameters[5].Value = model.CreditHigher;
parameters[6].Value = model.Order;
parameters[7].Value = model.Color;
parameters[8].Value = model.Image;
parameters[9].Value = model.OnlineImage;
parameters[10].Value = model.IsDefault;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
UpdateIsDefault(model.Id, model.IsDefault);
return(true);
}
else
{
return(false);
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("plugin_forum_board", DTEnums.ActionEnum.Edit.ToString()); //检查权限
BLL.Forum_Group bll = new BLL.Forum_Group();
BLL.Forum_BoardPermission bllBPer = new BLL.Forum_BoardPermission();
int _board_id = Convert.ToInt32(Request.Form["board_id"]);
List <Model.Forum_Group> listGroup = bll.GetModelList(" 1=1 ");
Model.Forum_Group modelGroup = new Model.Forum_Group();
modelGroup.Id = 0;
modelGroup.Name = "游客组";
listGroup.Add(modelGroup);
foreach (Model.Forum_Group item in listGroup)
{
Model.Forum_BoardPermission model = bllBPer.GetModel(" BoardId=" + _board_id + " and GroupId=" + item.Id + " ");
bool isNew = false;
if (model == null)
{
model = new Model.Forum_BoardPermission();
isNew = true;
}
model.BoardId = _board_id;
model.GroupId = item.Id;
model.VisitBoard = DTRequest.GetFormIntValue("VisitBoard_" + item.Id, 0);
model.VisitTopic = DTRequest.GetFormIntValue("VisitTopic_" + item.Id, 0);
model.PostTopic = DTRequest.GetFormIntValue("PostTopic_" + item.Id, 0);
model.PostReply = DTRequest.GetFormIntValue("PostReply_" + item.Id, 0);
model.UploadAttachment = DTRequest.GetFormIntValue("UploadAttachment_" + item.Id, 0);
model.ViewAttachment = DTRequest.GetFormIntValue("ViewAttachment_" + item.Id, 0);
model.UpdateMyselfTopic = DTRequest.GetFormIntValue("UpdateMyselfTopic_" + item.Id, 0);
model.UpdateMyselfReply = DTRequest.GetFormIntValue("UpdateMyselfReply_" + item.Id, 0);
model.DeleteMyselfTopic = DTRequest.GetFormIntValue("DeleteMyselfTopic_" + item.Id, 0);
model.DeleteMyselfReply = DTRequest.GetFormIntValue("DeleteMyselfReply_" + item.Id, 0);
if (isNew)
{
bllBPer.Add(model);
}
else
{
bllBPer.Update(model);
}
}
//重新加载
Global.GetBoardPermissionList(true);
JscriptMsg("保存信息成功！", "board_list.aspx");
}
/// <summary>
/// 增加一条数据,它的副表也增加了一条 dt_Forum_GroupExtended
/// </summary>
public int Add(Model.Forum_Group model)
{
int _id = dal.Add(model);
Model.Forum_GroupExtended modelGroupExtended = new Model.Forum_GroupExtended();
modelGroupExtended.GroupId = _id;
new Forum_GroupExtended().Add(modelGroupExtended);
return(_id);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Forum_Group model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "Forum_Group(");
strSql.Append("Name,System,Type,CreditLower,CreditHigher,[Order],Color,Image,OnlineImage,IsDefault");
strSql.Append(") values (");
strSql.Append("@Name,@System,@Type,@CreditLower,@CreditHigher,@Order,@Color,@Image,@OnlineImage,@IsDefault");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 32),
new SqlParameter("@System", SqlDbType.TinyInt, 1),
new SqlParameter("@Type", SqlDbType.TinyInt, 1),
new SqlParameter("@CreditLower", SqlDbType.Int, 4),
new SqlParameter("@CreditHigher", SqlDbType.Int, 4),
new SqlParameter("@Order", SqlDbType.Int, 4),
new SqlParameter("@Color", SqlDbType.NVarChar, 8),
new SqlParameter("@Image", SqlDbType.NVarChar, 256),
new SqlParameter("@OnlineImage", SqlDbType.NVarChar, 256),
new SqlParameter("@IsDefault", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.System;
parameters[2].Value = model.Type;
parameters[3].Value = model.CreditLower;
parameters[4].Value = model.CreditHigher;
parameters[5].Value = model.Order;
parameters[6].Value = model.Color;
parameters[7].Value = model.Image;
parameters[8].Value = model.OnlineImage;
parameters[9].Value = model.IsDefault;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
int _id = Convert.ToInt32(obj);
UpdateIsDefault(_id, model.IsDefault);
return(_id);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Forum_Group DataRowToModel(DataRow row)
{
if (row != null)
{
Model.Forum_Group model = new Model.Forum_Group();
if (row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
model.Name = row["Name"].ToString();
if (row["System"].ToString() != "")
{
model.System = int.Parse(row["System"].ToString());
}
if (row["Type"].ToString() != "")
{
model.Type = int.Parse(row["Type"].ToString());
}
if (row["IsDefault"].ToString() != "")
{
model.IsDefault = int.Parse(row["IsDefault"].ToString());
}
if (row["CreditLower"].ToString() != "")
{
model.CreditLower = int.Parse(row["CreditLower"].ToString());
}
if (row["CreditHigher"].ToString() != "")
{
model.CreditHigher = int.Parse(row["CreditHigher"].ToString());
}
if (row["Order"].ToString() != "")
{
model.Order = int.Parse(row["Order"].ToString());
}
model.Color = row["Color"].ToString();
model.Image = row["Image"].ToString();
model.OnlineImage = row["OnlineImage"].ToString();
return(model);
}
else
{
return(null);
}
}
private void ShowInfo(int _id)
{
BLL.Forum_Group bll = new BLL.Forum_Group();
Model.Forum_Group model = bll.GetModel(_id);
//编写赋值操作Begin
txtName.Text = model.Name;
rblSystem.SelectedValue = model.System.ToString();
ddlType.SelectedValue = model.Type.ToString();
txtCreditLower.Text = model.CreditLower.ToString();
txtCreditHigher.Text = model.CreditHigher.ToString();
txtColor.Text = model.Color;
txtImage.Text = model.Image;
txtOnlineImage.Text = model.OnlineImage;
rblIsDefault.SelectedValue = model.IsDefault.ToString();
//编写赋值操作End
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Forum_Group model)
{
return(dal.Update(model));
}
