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)); }