public bool UpdateModule(Module module) { string sql = "update Module set Name='" + module.Name + "', FormName='" + module.FormName + "', ControlName='" + module.ControlName + "', Remark='" + module.Remark + "' where ID=" + module.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
public bool UpdateRole(Role role) { string sql = "update [Role] set Name='" + role.Name + "', Permissions='" + Common.GetPermissionsStr(role.Permissions) + "', Flag=" + (role.Flag ? "1" : "0") + ", Remark='" + role.Remark + "' where ID=" + role.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
public bool UpdateUserGroup(UserGroup ug) { string sql = "update UserGroup set Name='" + ug.Name + "', Remark='" + ug.Remark + "' where ID=" + ug.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
public bool UpdateAction(Action action) { string sql = "update [Action] set Name='" + action.Name + "', FormName='" + action.FormName + "', ControlName='" + action.ControlName + "', Remark='" + action.Remark + "' where ID=" + action.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
public bool UpdateUser(User user) { string sql = "update [User] set Username='******',Password='******', Depart='" + Common.GetDepartmentsStr(user.Departments) + "', Flag=" + user.Flag + ", Remark='" + user.Remark + "' where ID=" + user.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
public bool UpdateDepartment(Department dep) { //string parent = "0"; //if (dep.Parent != null) // parent = dep.Parent.ID.ToString(); string sql = "update Depart set Name='" + dep.Name + "', Manager='" + dep.Manager + "', Parent=" + dep.ParentID + ", Remark='" + dep.Remark + "' where ID=" + dep.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
public bool UpdatePermission(Permission perm) { string sql = ""; if (perm.TheAction != null) { sql = "update Permission set Name='" + perm.Name + "', IsExcept=" + (perm.IsExcept ? "1" : "0") + ", TheModule=" + perm.TheModule.ID + ", TheAction=" + perm.TheAction.ID + ", Remark='" + perm.Remark + "' where ID=" + perm.ID; } else { sql = "update Permission set Name='" + perm.Name + "', IsExcept=" + (perm.IsExcept ? "1" : "0") + ", TheModule=" + perm.TheModule.ID + ", TheAction=0, Remark='" + perm.Remark + "' where ID=" + perm.ID; } int r = sqlHelper.ExecuteSql(sql); return(r > 0); }