private bool DoEdit(string _id)
{
bool result = false;
BLL.Forum_Settings bll = new BLL.Forum_Settings();
Model.Forum_Settings model = bll.GetModel(_id);
//编写编辑操作Begin
model.VariableOld = model.Variable;
model.Variable = txtVariable.Text;
model.Value = txtValue.Text;
model.Title = txtTitle.Text;
model.Group = Convert.ToInt32(ddlGroup.SelectedValue);
model.Description = txtDescription.Text;
model.SortId = Convert.ToInt32(txtSortId.Text);
//编写编辑操作End
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改管理员:" + model.Variable); //记录日志
result = true;
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Forum_Settings DataRowToModel(DataRow row)
{
if (row != null)
{
Model.Forum_Settings model = new Model.Forum_Settings();
model.Variable = row["Variable"].ToString();
model.Value = row["Value"].ToString();
model.Title = row["Title"].ToString();
if (row["Group"].ToString() != "")
{
model.Group = int.Parse(row["Group"].ToString());
}
model.Description = row["Description"].ToString();
if (row["SortId"].ToString() != "")
{
model.SortId = int.Parse(row["SortId"].ToString());
}
return(model);
}
else
{
return(null);
}
}
private void ShowInfo(string _id)
{
BLL.Forum_Settings bll = new BLL.Forum_Settings();
Model.Forum_Settings model = bll.GetModel(_id);
//编写赋值操作Begin
txtVariable.Text = model.Variable;
txtValue.Text = model.Value;
txtTitle.Text = model.Title;
ddlGroup.SelectedValue = model.Group.ToString();
txtDescription.Text = model.Description;
txtSortId.Text = model.SortId.ToString();
//编写赋值操作End
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Forum_Settings model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "Forum_Settings set ");
strSql.Append(" Variable = @Variable , ");
strSql.Append(" Value = @Value , ");
strSql.Append(" Title = @Title , ");
strSql.Append(" [Group] = @Group , ");
strSql.Append(" Description = @Description , ");
strSql.Append(" SortId = @SortId ");
strSql.Append(" where Variable=@VariableOld ");
SqlParameter[] parameters =
{
new SqlParameter("@Variable", SqlDbType.NVarChar, 128),
new SqlParameter("@Value", SqlDbType.NText),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@Group", SqlDbType.Int, 4),
new SqlParameter("@Description", SqlDbType.NVarChar, 255),
new SqlParameter("@SortId", SqlDbType.Int, 4),
new SqlParameter("@VariableOld", SqlDbType.NVarChar, 128)
};
parameters[0].Value = model.Variable;
parameters[1].Value = model.Value;
parameters[2].Value = model.Title;
parameters[3].Value = model.Group;
parameters[4].Value = model.Description;
parameters[5].Value = model.SortId;
parameters[6].Value = model.VariableOld;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private bool DoAdd()
{
Model.Forum_Settings model = new Model.Forum_Settings();
BLL.Forum_Settings bll = new BLL.Forum_Settings();
//编写添加操作Begin
model.Variable = txtVariable.Text;
model.Value = txtValue.Text;
model.Title = txtTitle.Text;
model.Group = Convert.ToInt32(ddlGroup.SelectedValue);
model.Description = txtDescription.Text;
model.SortId = Convert.ToInt32(txtSortId.Text);
//编写添加操作End
if (bll.Add(model))
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加dt_Forum_Settings:"
+ model.Variable); //记录日志
return(true);
}
return(false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.Forum_Settings model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "Forum_Settings(");
strSql.Append("Variable,Value,Title,[Group],Description,SortId");
strSql.Append(") values (");
strSql.Append("@Variable,@Value,@Title,@Group,@Description,@SortId");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@Variable", SqlDbType.NVarChar, 128),
new SqlParameter("@Value", SqlDbType.NText),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@Group", SqlDbType.Int, 4),
new SqlParameter("@Description", SqlDbType.NVarChar, 255),
new SqlParameter("@SortId", SqlDbType.Int, 4)
};
parameters[0].Value = model.Variable;
parameters[1].Value = model.Value;
parameters[2].Value = model.Title;
parameters[3].Value = model.Group;
parameters[4].Value = model.Description;
parameters[5].Value = model.SortId;
int bol = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (bol != 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Forum_Settings model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.Forum_Settings model)
{
return(dal.Add(model));
}
